Loading

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

Publiseringsdato: Feb 5, 2025
Beskrivelse

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.

 

Løsning

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.

 

Flere ressurser

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-artikkelnummer

001534480

 
Laster
Salesforce Help | Article