I think I found the problem: CM does not propagate the value of hive.server2.authentication to Hue, so indeed manually copying the hive-site.xml, editing it, and having Hue points to it fixes it. I am going to see with the CM team as this is not good. Romain ... View more

Could you share the hive-site.xml in /etc/hive/conf.cloudera.hive ? What is the Hue version? Romain ... View more

Hue needs to point to a directory containing a valid hive-site.xml: http://gethue.com/how-to-configure-hue-in-your-hadoop-cluster/ Romain ... View more

Thanks for reporting your solution! ... View more

I am not a Hive expert but auth should be LDAP and not PLAIN if you use LDAP? https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2#SettingUpHiveServer2-Authentication/SecurityConfiguration Romain ... View more

You seem to have a custom mapreduce.jobtracker.staging.root.dir: /jobs/input/customer It means only 'hdfs' user can submit jobs. You could change it to 777 permissions. I think there is also a way to have one by user. Romain ... View more

This is typical of a misconfigured HiveServer2: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient It can be that the remote metastore DB is readonly, or is not found I usually recommend to debug it by using beeline: http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/cdh_ig_hiveserver2_start_stop.html Above comments about Sentry are not related, as this is just the Sentry UI in Hue. Romain ... View more

This is weird. Are you using Sentry maybe? (and the user with error does not have access to the 'default' database?) Romain ... View more

Yes and also please share the list of instances you have in the HBase service in CM. Romain ... View more