Created on 05-01-2015 12:42 AM - edited 09-16-2022 02:27 AM
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?
Created 05-02-2015 09:53 AM
ok, i would be nice to have.
but the saftety valve workaround also works fine.
Created 04-12-2016 01:44 AM
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.
Created 04-12-2016 01:21 PM
Created 03-02-2017 08:06 PM
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?
Created 10-07-2017 04:23 AM
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
[root@xxxx java]# ll
-rwxr-xr-x. 1 cloudera-scm cloudera-scm 3397734 Oct 5 09:53 oracle-connector-java.jar
Created 10-10-2017 05:15 AM
Hue is not written in Java, thus the Oracle connector jar will not work. You want the Oracle Instant Client for Hue Parcel.