CODEWITHSUNDEEP
hadoopodbctableau-apihortonworks-data-platform
user2924472
user2924472

Reputation: 25

Hortonworks Sandbox Error Connecting to Tableau

I am using the HortonWorks Sandbox and trying to connect to tableau but get the following error. I am able to select my table and columns in tableau but cannot access the values. This is after granting admin privileges to my user in hive.

Error:

[Hortonworks][HiveODBC] (35) Error from Hive: error code: '40000' error message: 'Error while compiling statement: FAILED: HiveAccessControlException Permission denied. Principal [name=hue, type=USER] does not have following privileges on Object [type=TABLE_OR_VIEW, name=bse_stock_test.bse_index] : [SELECT]'.

Unexpected Error

Upvotes: 2

Views: 1460

Answers (2)

goks
goks

Reputation: 1206

user: hue should have permission to access the table.

In your case user: hue should have permission to access bse_stock_test.bse_index.

Try below command. It worked for me.

GRANT SELECT on table <table_name> to user <user_name>;

Ex:

grant SELECT on table batting to user hue

Upvotes: 2

Jeff Lewis
Jeff Lewis

Reputation: 318

If you're connecting to Hive, make sure that user has write permissions to the /tmp/hive-hive folder. We had the a similar issue and that is what resolved the ODBC driver issue in both Tableau and Excel.

Upvotes: 0

Related Questions