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

Who agreed with this topic

How to grant permissions on _dummy_database/_dummy_table

While trying to use Hive date functions I encountered the following permissions error:

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

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

How can permissions be granted to users, groups, or public on the dummy database/dummy table in Hive?

Who agreed with this topic