Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (47.2k points)

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

1 Answer

0 votes
by (17.6k points)
  • 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

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...