Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Connect Hortonworks Sandbox by lumira1.21, got permission denied error

I try to connect Hortonworks Sandbox 2.1 by Apache hadoop hive 0.13 simba jdbc4 hiveserver2, I can connect to the database, and even see all the tables under the database, but when I try to browse the data, I got the following error: HiveaccessControlException:Permission denied.

Please help! Thanks!

Former Member


I've not tried this, so i'm guessing here .. but a googlesearch brings up a Hive 2.1.x release note

8.8. Known Issues for Hive - Hortonworks Data Platform

BUG-16864: When Hive standard
authorization is enabled, the owner of the table backing index is missing.

Problem: The query fails with the
following error:

2014-04-16 16:50:13,312 ERROR [pool-7-thread-5]: ql.Driver ( - FAILED: HiveAccessControlException

Permission denied. Principal [name=hrt_qa, type=USER] does not have following privileges on Object [type=TABLE_OR_VIEW, name=default.default__missing_ddl_3_missing_ddl_3_index__] : [OBJECT OWNERSHIP]

HiveAccessControlException: Permission denied


but other searches for "HiveAccessControlException Permission denied"  seem to suggest it a case of granting permissions to the user  like hive>> grant select on table <Mytable> to user hue;



1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question