question Re: How to grant permissions on Hive dummy database/dummy table in Archives of Support Questions (Read Only)

How to grant permissions on Hive dummy database/dummy table

carol_elliott — Thu, 04 Jan 2018 23:33:13 GMT

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)

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

bandarusridhar1 — Sat, 06 Jan 2018 13:42:29 GMT

@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.

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

carol_elliott — Thu, 11 Jan 2018 05:06:46 GMT

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