28787
DISCUSSIONS
102052
MEMBERS
3161
ARTICLES
Created on 01-03-2018 01:23 PM - edited 09-16-2022 05:41 AM
While trying to use Hive date functions I encountered the following permissions error:
0: jdbc:hive2://xxxxx.xxx.xxx.xxx:2181,> 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?