Loading

Error "Permission denied: user [<hostname>$] does not have [SELECT] privilege" Occurs When Loading a View Connected to Cloudera Hive

Data pubblicazione: Feb 5, 2025
Descrizione

When loading a view that uses a live connection to a Cloudera Hive server, the following error may occur:
 

[Cloudera][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error from server: Error while compiling statement: FAILED: Hive AccessControlException Permission denied: user [<computer_name>$] does not have [SELECT] privilege on [<schema>/<table>/*]  

 

Cause

Network Service account on the Tableau Server host machine does not have required privileges on the Hive database.

 

Risoluzione

Work with your Hive database administrator and Active Directory administrator to configure a Tableau Server Run As user that has the required privileges on the Hive database.

 

Risorse aggiuntive

By default, the Tableau Server Run As service account is set to Network Service. When Tableau Server uses Kerberos authentication with this default service account to connect to the Hive server, the user is identified as the Tableau Server host machine in the format <computer_name>$.

For more information, see:

 

Numero articolo Knowledge

001534480

 
Caricamento
Salesforce Help | Article