question Re: Impala "Rows available" in Query Timeline in Archives of Support Questions (Read Only)

Impala "Rows available" in Query Timeline

hores — Fri, 16 Sep 2022 12:50:23 GMT

Hi All,

1. What is "Rows available" in Query Timeline of Impala query mean? what is Impala doing at this stage?

2. Is there a place where I can find an explanation of all the query profile metrics?

Thanks

Re: Impala "Rows available" in Query Timeline

AcharkiMed — Wed, 28 Feb 2018 16:09:21 GMT

Hi @hores

1- I thing "Rows available" time, is the time that impala taked to execute the query and prepare the results to be fetched, it's just before "First row fetched".

2- May be this link about Monitoring Impala Queries can help you.

Re: Impala "Rows available" in Query Timeline

hores — Sun, 04 Mar 2018 13:32:37 GMT

HI @AcharkiMed,

1. Thanks!

2. Thanks, but all the explanations in the link you sent I get when hovering with the mouse over the metrics,

but I was asking about the metrics in Query Fragments section in Impala Cloudera .

Re: Impala "Rows available" in Query Timeline

AcharkiMed — Mon, 05 Mar 2018 10:34:16 GMT

Hi @hores

1- You are welcome.
2- Unfortunaly, I do a lot of searchs and it seems like there is no more depth explications about the queries profile metrics. What I advice you is when do you have a problem to understand one of it, try to communicate it with the community to get more explanations.

Good luck.

Re: Impala "Rows available" in Query Timeline

AbelUD — Thu, 03 Feb 2022 01:00:52 GMT

The problem we have is in "Last row fetched", it is the longest time to execute a query. This slows down response times. Can you help us with some information to optimize these times.


For example:

Rows available: 510ms (499ms)
First row fetched: 1.97s (1.46s)
Last row fetched: 1.97s (57.35us)

we have Impala version 2.12. cdh5.16.2