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.

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

Highlighted

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

Explorer

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.

4 REPLIES 4

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

Guru
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

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

Explorer

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

 

Thanks.

 

 

 

 

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

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

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

Explorer

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