Reply
Explorer
Posts: 19
Registered: ‎04-23-2019

is there a way to get impala query information and store it in hive/imp tables for every sec/minute?

Hi Team,

 

is there a way to get impala query information and store it in hive/impala tables for every sec/minute?

 

Thanks in advance.

Cloudera Employee
Posts: 724
Registered: ‎03-23-2015

Re: is there a way to get impala query information and store it in hive/imp tables for every sec/min

Hi Harish,

Did you mean that you want to store the Hive and Impala query history? If not, can you please clarify on what you mean by "Impala query information"?

Thanks
Eric
Explorer
Posts: 19
Registered: ‎04-23-2019

Re: is there a way to get impala query information and store it in hive/imp tables for every sec/min

Yeah eric, i want to store impala query history information in hive to visualize  and anaylyze through tableau.

 

Thanks.

 

 

 

 

Explorer
Posts: 15
Registered: ‎11-23-2017

Re: is there a way to get impala query information and store it in hive/imp tables for every sec/min

[ Edited ]

Hi,

You may think about processing impalad logs and loding such information into tables:

cd /var/log/impalad/

grep 'stmt=select' impalad.*.impala.log.*

Although it requires some work to do.

Regards

Andrzej

Highlighted
Cloudera Employee
Posts: 724
Registered: ‎03-23-2015

Re: is there a way to get impala query information and store it in hive/imp tables for every sec/min

Have you thought about the option of using Cloudera Navigator? Queries can be passed along to Navigator and you can perform search through its interface.
Announcements