Creating Hue Schema in Oracle database
Hue requires a SQL database to store small amounts of data, including user account information as well as the history of queries and sharing permissions. Ensure that tables in the Hue schema are not compressed.
Due to a known bug in the Oracle database (12c and higher), you cannot alter a table
if it is compressed. If you have compressed tables in the Hue schema, then you may
see the “ORA-39726: unsupported add/drop column operation on compressed tables”
error. Even if you uncompress an existing table, you may not be allowed to alter the
columns. To resolve this, follow the below steps:
- Create a new uncompressed table with the same structure as the compressed table.
- Copy the data from the compressed table to the new uncompressed table.
- Rename or delete the compressed table.
- Rename the uncompressed table with the name of the original compressed table.