You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tristan Stevens (JIRA)" <ji...@apache.org> on 2018/11/09 16:19:00 UTC
[jira] [Commented] (IMPALA-5397) Queries/sessions that are left
idle after executing a query report incorrect duration
[ https://issues.apache.org/jira/browse/IMPALA-5397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16681662#comment-16681662 ]
Tristan Stevens commented on IMPALA-5397:
-----------------------------------------
Bump.
So long as the session stays open, even using --idle-query-timeout, queries only go into "Waiting to be closed".
We should have a way of timing queries out of this state into actual closure. Or we should make --idle-query-timeout do more what it says and actually close the query.
> 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 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
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org