How do I migrate saved queries from HUE 3.9 to 4.x

[#1]

@Siddo 

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.

[#2]

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

[#3]

@Siddo 

You can migrate the Hue DB. Refer doc to migrate Hue DB

https://docs.cloudera.com/documentation/enterprise/6/latest/topics/hue_dbs_migrate.html#hue_dbs_migr...

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.