Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hue DBQuery not showing Postgres columns for all schemas

Hue DBQuery not showing Postgres columns for all schemas

New Contributor

Hi,

 

I am using Hue (DBQuery editor) and Notebook (interpreters) to connect to an external Postgres database for running SQLs. 

 

From the drop down of the databases/schemas, I can see the metadata such as column names for all tables in the "public" schema However when I choose a custom schema "my_schema" for example, I see the table names and I am able to RUN queries but I cannot expand or double click on TABLE names on the Left hand side to see the columns as it does for "public" schema.

 

Is there any extra setting or privilege that I have to set up on Postgres ? 

2 REPLIES 2

Re: Hue DBQuery not showing Postgres columns for all schemas

Explorer

Anybody found a solution for that?

 

Re: Hue DBQuery not showing Postgres columns for all schemas

Explorer

adding the schemas to the search path does the trick:

ALTER DATABASE <database_name> SET search_path TO schema1,schema2,...;

Don't have an account?
Coming from Hortonworks? Activate your account here