Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

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"}'

View solution in original post

3 REPLIES 3

Super Guru

@scratch28,

 

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

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

 

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"}'

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.