You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Singh Sonu <so...@gmail.com> on 2021/12/20 14:33:11 UTC
Apache Kylin - 3.1.3 Release - Stop/Cancel Query is not working for long queries.
Hi Experts,
I am trying to kill long-running bad queries from Stop Query API and it's
not working.
Also, long-running bad queries are killing my HBasea and Kylin is down
frequently. I want to understand and need help from you, how we can kill
these kind of bad queries?
You can reach me out at
Email- sonusingh.javatech@gmail.com
with regards,
Sonu Kumar Singh
Re: Apache Kylin - 3.1.3 Release - Stop/Cancel Query is not working for long queries.
Posted by Yaqian Zhang <Ya...@126.com>.
Hi Sonu:
Thank you for your suggestion!
I think "upgrade this stop query functionality” is a good idea，those queries that run too long should be detected and stopped automatically.
Can you open a JIRA issue to track this? And you can write your thoughts on the description of the issue.
> 在 2021年12月23日，下午12:27，Singh Sonu <so...@gmail.com> 写道：
>
> Hi Zhang,
>
> I am calling this API using swagger and yes after the API call, I can see the related logs got printed.
>
> I am just thinking can we upgrade this stop query functionality? so we can kill the running query thread because sometimes these queries are running in HBase for 100-300 secs.
>
> Thanks for your suggestions, I will surely going to try these all using the property file.
>
>
> You can reach me out at
> Email- sonusingh.javatech@gmail.com <ma...@gmail.com>
>
> with regards,
> Sonu Kumar Singh
>
>
>
>
> On Tue, Dec 21, 2021 at 12:21 PM Yaqian Zhang <Yaqian_Zhang@126.com <ma...@126.com>> wrote:
> Hi Sonu Kumar Singh:
>
> Can you describe in detail how you call the Stop Query API? And after calling the API, whether relevant logs are output in $KYLIN_HOME/logs/kylin.log? such as "the query: {} is not existing" or "{quaryid} stopped by {user}".
>
> By the way, you can set some query related parameters to prevent HBase cluster from downtime due to excessive query execution. such as kylin.query.max-scan-bytes, kylin.storage.partition.max-scan-bytes, etc.
> For details: https://kylin.apache.org/cn/docs31/install/configuration.html#kylin-query <https://kylin.apache.org/cn/docs31/install/configuration.html#kylin-query>.
>
>> 在 2021年12月20日，下午10:33，Singh Sonu <sonusingh.javatech@gmail.com <ma...@gmail.com>> 写道：
>>
>> Hi Experts,
>>
>> I am trying to kill long-running bad queries from Stop Query API and it's
>> not working.
>> Also, long-running bad queries are killing my HBasea and Kylin is down
>> frequently. I want to understand and need help from you, how we can kill
>> these kind of bad queries?
>>
>>
>> You can reach me out at
>> Email- sonusingh.javatech@gmail.com <ma...@gmail.com>
>>
>> with regards,
>> Sonu Kumar Singh
>
Re: Apache Kylin - 3.1.3 Release - Stop/Cancel Query is not working for long queries.
Posted by Yaqian Zhang <Ya...@126.com>.
Hi Sonu Kumar Singh:
Can you describe in detail how you call the Stop Query API? And after calling the API, whether relevant logs are output in $KYLIN_HOME/logs/kylin.log? such as "the query: {} is not existing" or "{quaryid} stopped by {user}".
By the way, you can set some query related parameters to prevent HBase cluster from downtime due to excessive query execution. such as kylin.query.max-scan-bytes, kylin.storage.partition.max-scan-bytes, etc.
For details: https://kylin.apache.org/cn/docs31/install/configuration.html#kylin-query <https://kylin.apache.org/cn/docs31/install/configuration.html#kylin-query>.
> 在 2021年12月20日，下午10:33，Singh Sonu <so...@gmail.com> 写道：
>
> Hi Experts,
>
> I am trying to kill long-running bad queries from Stop Query API and it's
> not working.
> Also, long-running bad queries are killing my HBasea and Kylin is down
> frequently. I want to understand and need help from you, how we can kill
> these kind of bad queries?
>
>
> You can reach me out at
> Email- sonusingh.javatech@gmail.com
>
> with regards,
> Sonu Kumar Singh