Where can I find 'Saved Queries' from HUE UI.

[#1]

I saved a sample query in HUE UI(Impala editor). Try to find records in Mysql DB 'HUE' and table 'beeswax_savedquery'. However tables 'beeswax_savedquery' and beeswax_queryhistory are empty.

Whereas other tables were able to store all required information.

E.g. Table 'auth_user' contains all information about users.

My question is that : Where those HUE query are getting stored (in Mysql OR some where in HDFS) 

I am using CDH 6.3.2 with Impala.

[#2]

@manjj This usually saved in the the Hue Database (MySql, MariaDB etc.) beeswax_savedquery table. There might be some latency but I am checking this further. 

[#3]

@manjj,

The query is now saved into table desktop_document2, not beeswax_savedquery anymore.

Search for column type = 'query-impala', and you should be able to find your saved query over there.

My table looks like below:

MariaDB [hue_513]> select * from desktop_document2 order by id desc limit 1\G
*************************** 1. row ***************************
                 id: 50178
           owner_id: 1
               name: Test
        description: Eric's Test query
               uuid: 9cc2006e-9745-43bb-966d-f0bc12da2d2a
               type: query-impala
               data: {"loadingHistory": false..........
              extra:
      last_modified: 2020-01-06 14:33:03
            version: 1
         is_history: 0
parent_directory_id: 1
             search: select * from test.my_table
         is_managed: 0
         is_trashed: 0
1 row in set (0.00 sec)

Cheers

Eric

[#4]

Thanks @EricL for chime in. @manjj That's correct I found it later today as well this resides in desktop_document2 nowadays 🙂