hive alter tale error does not have privileges for ALTERTABLE_ADDCOLS

[#1]

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

[#2]

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

[#3]

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