Hive editor on hue does not work with NOSASL

[#1]

Hi, 

We are using NOSASL setting for hive.server2.authentication. Impala editor on hue is able to access hive tables but hive editor does not work. 

It keeps on hanging with no error. 

Any ideas?

Also, if we change hive.server2.authentication to default then hive editor works. It is definitely an authentication issue. 

[#2]

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

[#3]

Hue is pointing to the hive server as well as hive/conf folder.

# Host where Hive server Thrift daemon is running.
# If Kerberos security is enabled, use fully-qualified domain name (FQDN).
hive_server_host=quickstart.cloudera

# Port where HiveServer2 Thrift server runs on.
hive_server_port=10000

# Hive configuration directory, where hive-site.xml is located
#hive_conf_dir=/etc/hive/conf
hive_conf_dir=/etc/hive/conf.cloudera.hive

[#4]

Could you share the hive-site.xml in /etc/hive/conf.cloudera.hive ?

What is the Hue version?

Romain

[#5]

Hue version 3.7.0

Hive-site.xml -> http://www.hastebin.com/iquqemujan.xml

Also, For some reason Hue does not copy the hive-site.xml specified.
Instead it uses some default version, if that makes any sense. I am using
the Couldera Quickstart VM version 5.3

Anu

[#6]

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

[#7]

I did add the hive.server2.authentication as NOSASL in
/var/run/cloudera-scm-agent/process/168-hue-HUE_SERVER/hive-conf/hive-site.xml
but for that to propagate I need to restart which creates a whole new Hue
Server folder without those settings. Do you suggest any temporary fix for
the time being?

Anu

[#8 · Accepted solution]

The only temporary woark around is to do what you did and hardcode a path
to a good hive-site.xml directory in Hue safety valve:

[beeswax]
hive_conf_dir=/etc/hive/conf_with_good_hive


Romain

[#9]

Actually, there is a safety valve for Hive clients in the Hive service. This property should be specified there and it will work as Hue will get it:

 
  hive.server2.authentication
    NOSASL
  

I am forwarding this to the VM guys so that they fix it for next time!