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

[#1]

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.

[#2]

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

[#3]

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

Thanks.

[#4]

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.

[#5]

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