[
https://issues.apache.org/jira/browse/IMPALA-5397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong updated IMPALA-5397:
----------------------------------
Target Version: Impala 3.2.0
Description:
When queries are executed from Hue and hit the idle query timeout then the
query duration keeps going up even though the query was cancelled and it is not
actually doing any more work. The end time is only set when the query is
actually unregistered.
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....@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....@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|
was:
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....@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....@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|
> 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
> Priority: Major
> Labels: query-lifecycle
>
> When queries are executed from Hue and hit the idle query timeout then the
> query duration keeps going up even though the query was cancelled and it is
> not actually doing any more work. The end time is only set when the query is
> actually unregistered.
> 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....@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....@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
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
