- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
hive alter tale error does not have privileges for ALTERTABLE_ADDCOLS
Created ‎06-14-2023 07:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hello great guys
I get a error in hive hql
but my user have this Permissions for databases
my version is cdh6.3.4 hadoop3,hive2.1.1,Installed kerberos and sentry beeline can do this operate ,only in hql file
Created ‎06-14-2023 10:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@haihua Do you mean it works from beeline but not from Hive CLI? If it works with beeline, why don't we run it run it with that instead?
beeline ... -f query.hql
Also, could you try providing required privileges to the role with GRANT OPTION ? Refer to https://docs.cloudera.com/documentation/enterprise/latest/topics/sg_hive_sql.html#grant_privilege_wi...
Created ‎06-15-2023 12:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you help
because this script is too old. noone want change this . i mean just user's privileges in beeline is ok,not the hql file .this hql is not for beeline
