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 <[email protected]> 写道： > > 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- [email protected] <mailto:[email protected]> > > with regards, > Sonu Kumar Singh > > > > > On Tue, Dec 21, 2021 at 12:21 PM Yaqian Zhang <[email protected] > <mailto:[email protected]>> 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 <[email protected] >> <mailto:[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] <mailto:[email protected]> >> >> with regards, >> Sonu Kumar Singh >
