I finally solved it
The problem was that I had no role at all, and roles created by hue didnt work for some reason.
So I created an admin role via beeline:
- Obtained hive ticket
kinit -k -t run/cloudera-scm-agent/process/218-hive-HIVESERVER2/hive.keytab hive/node01.test.com@TEST.COM - Connected to hive with beeline using hive keytab.
beeline>!connect jdbc:hive2://node01.test.com:10000/default;principal=hive/node01.test.com@TEST.COM - Created the role admin.
beeline>Create role admin; - Granted priviledges to admin role.
GRANT ALL ON SERVER server1 TO ROLE admin WITH GRANT OPTION; - Assign the role to a group.
GRANT ROLE admin TO GROUP administrators;
After these steps all users within the group administrators are allowed to manage hive priviledges