Hortonworks Sandbox Error Connecting to Tableau

Question

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

Answer 1

• User should have permission to access the table.

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

• Use the below command 

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

Ex:

grant SELECT on table batting to user ashok