question Re: Hive not available in HUE in Support Questions

Hive not available in HUE

scratch28 — Fri, 16 Sep 2022 13:43:28 GMT

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?

Re: Hive not available in HUE

bgooley — Wed, 19 Sep 2018 00:20:44 GMT

@scratch28,

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

Re: Hive not available in HUE

scratch28 — Fri, 26 Oct 2018 22:19:07 GMT

sure

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

see attached

and yes it is activated

Re: Hive not available in HUE

scratch28 — Mon, 29 Oct 2018 18:42:03 GMT

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