Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive not available in HUE

Solved Go to solution

Hive not available in HUE

Contributor

On CMS 6 (playing around with it ) 

and I configured HUE but Hive is not available 

The only option is 

Hive Service
Hue (Service-Wide) 
 Hive
am I missing something?
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Hive not available in HUE

Contributor

I had to customize 

Hue Server Advanced Configuration Snippet (Safety Valve) for hue_safety_valve_server.ini

to add back the base functionality 

[notebook]
[[interpreters]]
[[[hive]]]
name=Hive
interface=hiveserver2
[[[impala]]]
name=Impala
interface=hiveserver2
[[[presto]]]
name=Presto
interface=jdbc
options='{"url": "jdbc:presto://ta-pci-prod-presto-master01.tripactions.local:8889/ta", "driver": "com.facebook.presto.jdbc.PrestoDriver"}'

3 REPLIES 3

Re: Hive not available in HUE

Super Guru

@scratch28,

 

Can you clarify what you are seeing/trying to do?  It is unclear...screen shots?

Re: Hive not available in HUE

Contributor

sure 

I should be able to see both Hive and HUE on this drop down

see attached

Screen Shot 2018-10-26 at 3.17.26 PM.pngScreen Shot 2018-10-26 at 3.18.14 PM.png

and yes it is activated

 

Highlighted

Re: Hive not available in HUE

Contributor

I had to customize 

Hue Server Advanced Configuration Snippet (Safety Valve) for hue_safety_valve_server.ini

to add back the base functionality 

[notebook]
[[interpreters]]
[[[hive]]]
name=Hive
interface=hiveserver2
[[[impala]]]
name=Impala
interface=hiveserver2
[[[presto]]]
name=Presto
interface=jdbc
options='{"url": "jdbc:presto://ta-pci-prod-presto-master01.tripactions.local:8889/ta", "driver": "com.facebook.presto.jdbc.PrestoDriver"}'