Support Questions
Find answers, ask questions, and share your expertise

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

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

Explorer

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

 

Thanks.

 

 

 

 

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.

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.