Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to grant permissions on Hive dummy database/dummy table

Solved Go to solution

How to grant permissions on Hive dummy database/dummy table

I received the following error using date functions in Hive. How are are permissions granted on dummy database/dummy table?

0:
jdbc:hive2://xxx:xxx,> SELECT DATE_ADD('2017-12-21', 1);

Error:
Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [xxx] does
not have [SELECT] privilege on [_dummy_database/_dummy_table]
(state=42000,code=40000)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: How to grant permissions on Hive dummy database/dummy table

@Carol Elliott

You can grant workaround by creating Ranger policy on _dummy_database. Ranger doesn't really check the database, just grant full access on _dummy_database to all. Guess you are hitting the same HIVE-11498 bug which I have already experienced.

Hope this helps you.

View solution in original post

2 REPLIES 2
Highlighted

Re: How to grant permissions on Hive dummy database/dummy table

@Carol Elliott

You can grant workaround by creating Ranger policy on _dummy_database. Ranger doesn't really check the database, just grant full access on _dummy_database to all. Guess you are hitting the same HIVE-11498 bug which I have already experienced.

Hope this helps you.

View solution in original post

Highlighted

Re: How to grant permissions on Hive dummy database/dummy table

This worked for us. Thank you, @Sridhar Reddy.

Don't have an account?
Coming from Hortonworks? Activate your account here