Loading

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

Julkaisupäivä: Feb 5, 2025
Kuvaus

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.

 

Ratkaisu

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.

 

Lisäresurssit

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:

 

Knowledge-artikkelin numero

001534480

 
Ladataan
Salesforce Help | Article