on 01-13-2015 4:17 AM
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!
Hi,
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 (SessionState.java:printError(546)) - 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] org.apache.hadoop.hive.ql.security.authorization.plugin.
HiveAccessControlException: Permission denied
.
but other searches for "HiveAccessControlException Permission denied" seem to suggest it a case of granting permissions to the user http://hortonworks.com/community/forums/topic/sandbox-2-1-odbc-not-working/ like hive>> grant select on table <Mytable> to user hue;
Regards,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
just to conclude this thread, there is a most excellent tutorial for this integration topics, here http://scn.sap.com/docs/DOC-61453
regards,
H
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.