Loading

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

Дата публикации: Feb 5, 2025
Описание

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.

 

Решение

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.

 

Дополнительные ресурсы

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:

 

Номер статьи базы знаний

001534480

 
Загрузка
Salesforce Help | Article