- last edited on
Do you mean saved queries are not available in hue 4 but present in hue 3.9 version?
Have you recently upgraded the cluster? What is the CDH version here?
Go to "http[s]://<huehost>:<hueport>/home" or click the house icon in the upper left corner in hue.
After this recheck if the saved queries are visible.
I have HUE 3.9 installed and a separate installation of hue 4.5. I want to copy the save queries in 3.9 to ver 4.5
You can migrate the Hue DB. Refer doc to migrate Hue DB
Manually migrating queries from tables would be complex and not tested completely. It has the below requirement:
The Hue database has a "desktop_document2" table that stores all the saved queries and Oozie workflows and all sorts of users' saved stuff (query history included).
This table has an OWNER_ID column that is a foreign key to the auth_user table's ID column.
The process of getting the new ID of the "auth_user" table, and associating them with the correct "owner_id" in the "desktop_document2" table, can be very involved.