Understanding Impala Query Details in Cloudera Manager

Hi,

this is a screenshot from the Impala Query Details page in Cloudera
Manager (in German, sorry):


<https://lh3.googleusercontent.com/-qb7uJf14Fy8/UtlUkhmjJoI/AAAAAAAAH5M/V8B-JvMVnlQ/s1600/Impala_Query_Result.jpg>

We are confused about start time (Startzeit), end time (Endzeit) and
duration (Dauer).
If we compare start and end time we see that the query took *3min 26s* to
complete but what does duration then mean? We expected duration to be the
query runtime.
The output in Cloudera Manager is just a formatted output of the query
PROFILE (see the full output of PROFILE attached).
The value of duration seems to correspond to the TotalTime in Execution
Profile but the query actually took over 3min to complete.

Can somebody help us to understand the output of Cloudera Manager or
PROFILE, respectively?
Is there somewhere a documentation how to interpret the output of
PROFILE, the Cloudera documentation about it is not really useful:
http://www.cloudera.com/content/cloudera-content/
cloudera-docs/Impala/latest/Installing-and-Using-Impala/
ciiu_performance.html#perf_profile_unique_1

Thx,
Alex

To unsubscribe from this group and stop receiving emails from it, send
an email to impala-user...@cloudera.org.

Alex,

There is a bug in CM's computation of the duration. You are correct that
it is simply reporting the total execution time and does not include other
portions of the query lifecycle. A fix for this will be in the next version
of CM (5.0 and 4.x).

chris





On Fri, Jan 17, 2014 at 8:22 AM, Alexander Schätzle <
schaetzle...@gmail.com> wrote:
To unsubscribe from this group and stop receiving emails from it, send