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 <[email protected]> 写道：
>
> 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- [email protected]
>
> with regards,
> Sonu Kumar Singh
