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.

How can I check the Impala Query Execution Time?

Solved Go to solution
Highlighted

How can I check the Impala Query Execution Time?

New Contributor

Hello all,

My system administrator wants to check the Impala Query's execution time.

I can check the each fragment's total time in

[Cloudera Manager > Impala > Query > Query details].

But I can't find the total of query execution time.

 

Please anyone tell me where can I check it.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How can I check the Impala Query Execution Time?

Guru
Hi @Mogiking

Hue keeps the query handler open so that it can get back to its result during pagination. This is a feature in Hue, not a bug.

You can find that info from impala PROFILE under Query Timeline section, like below:

Query Timeline
Query submitted: 0ns (0)
Planning finished: 170ms (170000854)
Submit for admission: 172ms (172000864)
Completed admission: 172ms (172000864)
Ready to start on 2 backends: 172ms (172000864)
All 2 execution backends (3 fragment instances) started: 176ms (176000884)
Rows available: 422ms (422002119)
First row fetched: 501ms (501002515)
Unregister query: 509ms (509002555)

You can see detailed information on when data is available.

Cheers
Eric
4 REPLIES 4

Re: How can I check the Impala Query Execution Time?

Cloudera Employee

On that Cloudera Manager page, you can click 'Select Attributes' and check the box by 'Duration'.
Now any queries that are displayed will show the query duration in milliseconds.

Re: How can I check the Impala Query Execution Time?

New Contributor

Thanks for reply Andrew,

I found that duration keep increasing while Hue session is opened.

So I guess that 'Duration' is not a exact execution time..

Is it bug?

Re: How can I check the Impala Query Execution Time?

Guru
Hi @Mogiking

Hue keeps the query handler open so that it can get back to its result during pagination. This is a feature in Hue, not a bug.

You can find that info from impala PROFILE under Query Timeline section, like below:

Query Timeline
Query submitted: 0ns (0)
Planning finished: 170ms (170000854)
Submit for admission: 172ms (172000864)
Completed admission: 172ms (172000864)
Ready to start on 2 backends: 172ms (172000864)
All 2 execution backends (3 fragment instances) started: 176ms (176000884)
Rows available: 422ms (422002119)
First row fetched: 501ms (501002515)
Unregister query: 509ms (509002555)

You can see detailed information on when data is available.

Cheers
Eric

Re: How can I check the Impala Query Execution Time?

Cloudera Employee

Hi Mogiking,

On the version I was testing (CDH 6.2) the duration looks correct, but the queries do not show up until they are completely closed. I was able to force this from the Impala Daemon Web UI, or by waiting, or by closing hue.

-Andrew

 

 

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