Since you have mentioned the word "user role", I want to clarify this You have to understand the difference between Group, User and Role Group and User to be created in both Linux(root user) and Hue(as admin user) But Role to be created only in Hue   Ex: Login as root in Linux and apply below commands. Group: groupadd hive; groupadd hue; groupadd impala; groupadd analyst; groupadd admin;   # In your case, your Group suppose to be.. Auditor, Read-Only, Limited Operator, Operator, Configurator, Cluster Administrator ,BDR Administrator, Navigator Administrator, User Administrator, Key Administrator, Full Administrator   User: useradd kumar; # User belongs to Group usermod -a -G hive,hue,impala,admin,analyst kumar; passwd kumar;   # Role assigned to Group: Now, login to Hue -> Security(Menu)-> Sentry Tables -> Add Roles (as Hive user)   ... View more

@cplusplus1   You can get xml files in the below path... But I will not recommand you to update it directly, instead you can update your configuration using CM   /var/run/cloudera-scm-agent/process/*-hive-HIVESERVER2   By default, Sentry requirs configuration changes in Hive, Imapal, YARN and Hue ( you can add addiontal services as needed and change configuration)   Ex: You can follow this method CM -> Hive -> Configuration  Select Scope > HiveServer2. Select Category > Main. Uncheck the HiveServer2 Enable Impersonation checkbox   ... View more

Hi cpluplus1,    To log into hive server 2 by command line you need this:   $ beeline -u "jdbc:hive2://hive_node:10000/;principal=hive/_HOST@ad_domain   To log into hive server 2 web UI:   http://hive_node:10002/   To run queries from HUE into Hive:   https://hue_node:8888/notebook/editor?type=hive   With which user are you logging into hue? Maybe you don't have enough privileges to access in hive query editor, can you access with administration user and validate it?   Marc. ... View more