KNOWLEDGE BASE

Error "Permission denied: user [<hostname>$] does not have [SELECT] privilege"


Published: 25 Feb 2022
Last Modified Date: 28 Feb 2022

Issue

When loading a view that uses a live connection to a 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>/*]  

Environment

  • Tableau Server
  • Cloudera Hadoop Hive
  • Kerberos database authentication

Resolution

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.

Cause

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

Additional Information

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:
Did this article resolve the issue?