question Re: Hive editor on hue does not work with NOSASL in Archives of Support Questions (Read Only)

Hive editor on hue does not work with NOSASL

morfious902002 — Tue, 21 Apr 2026 13:59:18 GMT

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.

Re: Hive editor on hue does not work with NOSASL

Romainr — Wed, 14 Jan 2015 21:20:50 GMT

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

Re: Hive editor on hue does not work with NOSASL

morfious902002 — Wed, 14 Jan 2015 21:23:50 GMT

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

Re: Hive editor on hue does not work with NOSASL

Romainr — Thu, 15 Jan 2015 19:35:50 GMT

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

What is the Hue version?

Romain

Re: Hive editor on hue does not work with NOSASL

morfious902002 — Thu, 15 Jan 2015 19:43:50 GMT

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

Re: Hive editor on hue does not work with NOSASL

Romainr — Thu, 15 Jan 2015 20:26:50 GMT

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

Re: Hive editor on hue does not work with NOSASL

morfious902002 — Thu, 15 Jan 2015 20:33:50 GMT

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

Re: Hive editor on hue does not work with NOSASL

Romainr — Thu, 15 Jan 2015 20:36:50 GMT

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

Re: Hive editor on hue does not work with NOSASL

Romainr — Thu, 15 Jan 2015 22:33:15 GMT

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!