- 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
