You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Mostafa Mokhtar (JIRA)" <ji...@apache.org> on 2017/05/31 16:49:04 UTC

[jira] [Created] (IMPALA-5397) Queries/sessions that are left idle after executing a query report incorrect duration

Mostafa Mokhtar created IMPALA-5397:
---------------------------------------

             Summary: Queries/sessions that are left idle after executing a query report incorrect duration 
                 Key: IMPALA-5397
                 URL: https://issues.apache.org/jira/browse/IMPALA-5397
             Project: IMPALA
          Issue Type: Bug
          Components: Backend
    Affects Versions: Impala 2.9.0
            Reporter: Mostafa Mokhtar


When queries are executed from Hue then the session is left idle and incorrect query duration is reported. 
As the session is left alive the query duration keeps going up even though the query stats is FINISHED.

Queries below finished in 1s640ms while the reported time is much longer. 

|User||Default Db||Statement||Query Type||Start Time||Waiting Time||Duration||Scan Progress||State||Last Event||# rows fetched||Resource Pool||Details||Action|
|hue/va1026.halxg.cloudera.com@HALXG.CLOUDERA.COM|tpcds_1000_parquet|select count(*) from tpcds_1000_parquet.inventory|QUERY|2017-05-31 09:38:20.472804000|4m27s|4m32s|261 / 261 ( 100%)|FINISHED|First row fetched|1|root.default|Details|Close|
|hue/va1026.halxg.cloudera.com@HALXG.CLOUDERA.COM|tpcds_1000_parquet|select count(*) from tpcds_1000_parquet.inventory|QUERY|2017-05-31 08:38:52.780237000|2017-05-31 09:38:20.289582000|59m27s|261 / 261 ( 100%)|FINISHED|1|root.default|Details|



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)