Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive editor on hue does not work with NOSASL

avatar
Contributor

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. 

1 ACCEPTED SOLUTION

avatar
Super Guru
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

View solution in original post

8 REPLIES 8

avatar
Super Guru
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

avatar
Contributor
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


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

What is the Hue version?

Romain



avatar
Contributor
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

avatar
Super Guru
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


avatar
Contributor
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


avatar
Super Guru
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

avatar
Super Guru

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!