Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Hive not available in HUE

avatar
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

avatar
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

avatar
Master Guru

@scratch28,

 

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

avatar
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

 

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