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.

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

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

New Contributor

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.
3 REPLIES 3

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

Expert Contributor

@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. 

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

Guru

@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

 

Highlighted

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

Expert Contributor

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

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