Using Oracle database with Hue

You can use the Oracle database to store Hue metadata, job and query history, and account information. In CDP 7.1.x, Hue supports Oracle database versions 12c and 19c.

To use an Oracle database with Hue, you need:

Oracle Instant Client library: The Oracle Instant Client connects Hue to the backend Oracle database. The Oracle Client libraries provide the necessary network connectivity and tools such as SQL*Plus and Oracle Data Pump to access the data.
cx_Oracle Python extension module: The cx_Oracle module loads the Oracle Client libraries. The cx_Oracle module and the Oracle Client libraries communicate with the data over Oracle Net.

Hue on CDP 7.1.8 and higher uses Python version 3.8.12 and Django version 3.2.13. The minimum compatible cx_Oracle version that you can use with Hue is 6.4.1. cx_Oracle is not distributed with CDP 7.1.8. You must download and install it manually. If you are on an older version of CDP, or if you are upgrading to CDP from CDH 5.x or 6.x, then you must upgrade cx_Oracle from 5.2.1 to 6.4.1.

To use Oracle as a backend database for Hue, you must download and install the Oracle Instant Client library and cx_Oracle Python extension module, and then set the database parameters in Cloudera Manager Hue configurations.

You must download the Oracle Instant Client library 19.16 (both basic and SDK clients) from the Oracle website. You can download the cx_Oracle Python extension module from https://pypi.org/project/cx-Oracle/.