- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Hive editor on hue does not work with NOSASL
- Labels:
-
Apache Hive
-
Apache Impala
-
Cloudera Hue
Created on 01-14-2015 12:15 PM - edited 09-16-2022 02:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 01-15-2015 12:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
to a good hive-site.xml directory in Hue safety valve:
[beeswax]
hive_conf_dir=/etc/hive/conf_with_good_hive
Romain
Created 01-14-2015 01:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
http://gethue.com/how-to-configure-hue-in-your-hadoop-cluster/
Romain
Created 01-14-2015 01:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
# 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
Created 01-15-2015 11:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the Hue version?
Romain
Created 01-15-2015 11:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 01-15-2015 12:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 01-15-2015 12:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
/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
Created 01-15-2015 12:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
to a good hive-site.xml directory in Hue safety valve:
[beeswax]
hive_conf_dir=/etc/hive/conf_with_good_hive
Romain
Created 01-15-2015 02:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
