Reply
Contributor
Posts: 26
Registered: ‎05-01-2015
Accepted Solution

HUE external database

[ Edited ]

Hi,

 

With CDH 5.4 i am trying to use an external postgres database. The selection option in the CDH manager for the HUE service only list options for mysql and sqllite. 

 

Hue does support postgres and i got it to work by adding the config into the safety valve. Is there a reason why this cannot be done with the selection options.

 

maybe something to add in a next version?

Cloudera Employee
Posts: 500
Registered: ‎07-30-2013

Re: HUE external database

There are licensing issues with the postgresql library that Hue uses, so we have not been able to incorporate a seamless integration into Cloudera Manager.

We'd like to improve this experience in a future release, but I can't promise anything.
Contributor
Posts: 26
Registered: ‎05-01-2015

Re: HUE external database

ok, i would be nice to have.

but the saftety valve workaround also works fine.

 

thx.

Explorer
Posts: 21
Registered: ‎11-10-2015

Re: HUE external database

Hello Darren,

                           could you explain better what are the problems about postgresql license ?

I am also in the PostgreSQL community, so if it's possible I will help with.

 

Kind Regards

Cloudera Employee
Posts: 500
Registered: ‎07-30-2013

Re: HUE external database

Hi,

Thanks for the offer to help! Hue uses the psycopg2 to talk to postgresql, which we have since found a way to make easy to install without violating the license.

We'll likely have more seamless integration in an upcoming release.

Thanks,
Darren
New Contributor
Posts: 1
Registered: ‎02-28-2017

Re: HUE external database

I'm also trying to connect HUE to an external database, Oracle.  But I'm getting the error: "Oracle client libraries cannot be found on host".  This doesn''t make sense because I've sucessfully connected to the database from that installation node using the scm_prepare_database.sh script.  Any suggestions?

Thanks,

Vince 

Explorer
Posts: 13
Registered: ‎09-13-2015

Re: HUE external database

Hi Team,

 

I am also getting same error.I am able t oconnect remote db with scm,rman,hive,oozie and where as for hue it is throwing error :Oracle client libraries cannot be found on host 

Any specific steps are required for hue:

[root@xxxxx java]# pwd
/usr/share/java
[root@xxxx java]# ll
total 3320
-rwxr-xr-x. 1 cloudera-scm cloudera-scm 3397734 Oct 5 09:53 oracle-connector-java.jar

 

Thanks,

Sridhar

Highlighted
Explorer
Posts: 21
Registered: ‎10-27-2015

Re: HUE external database

@sridharm

 

Hue is not written in Java, thus the Oracle connector jar will not work.  You want the Oracle Instant Client for Hue Parcel.

Announcements