[
https://issues.apache.org/jira/browse/KYLIN-5392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jiale He updated KYLIN-5392:
----------------------------
Description:
badquery到900S才被cancel，预期应该是超过300S就被cancel
!image-2023-01-09-17-59-13-427.png|width=480,height=287!
复现SQL见附件
h1. Root Cause
从这条 SQL 来看，卡在了 RestoreFromComputedColumn 这个里面，这个操作特别耗时，里面会最大调用 10次，对于这条
SQL，第一次耗时将近花了 250s，所以走到这个逻辑里面就需要等待执行完毕才能退出来，查询被取消。
> The query cannot be canceled immediately if it exceeds the timeout period
> -------------------------------------------------------------------------
>
> Key: KYLIN-5392
> URL: https://issues.apache.org/jira/browse/KYLIN-5392
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 5.0-alpha
> Reporter: Jiale He
> Assignee: Jiale He
> Priority: Major
> Fix For: 5.0-alpha
>
> Attachments: image-2023-01-09-17-58-49-310.png,
> image-2023-01-09-17-59-13-427.png
>
>
> badquery到900S才被cancel，预期应该是超过300S就被cancel
> !image-2023-01-09-17-59-13-427.png|width=480,height=287!
>
> 复现SQL见附件
> h1. Root Cause
> 从这条 SQL 来看，卡在了 RestoreFromComputedColumn 这个里面，这个操作特别耗时，里面会最大调用 10次，对于这条
> SQL，第一次耗时将近花了 250s，所以走到这个逻辑里面就需要等待执行完毕才能退出来，查询被取消。
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
