You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 伍明 <su...@qq.com> on 2020/04/24 08:02:33 UTC
回复：Is there any way to kill a running query?
Hello,
I found the slow query module on the web page, but I still don’t know how to kill it。
------------------ 原始邮件 ------------------
发件人: "伍明"<sunshinemi.wu@qq.com>;
发送时间: 2020年4月24日(星期五) 下午3:48
收件人: "user"<user@kylin.apache.org>;
主题: Is there any way to kill a running query?
Hello,
How should I manage kylin queries, especially slow queries? Can only the currently submitted queries be monitored through logs?
Re: Is there any way to kill a running query?
Posted by Yaqian Zhang <Ya...@126.com>.
Yes, actually this link already contains most of the commonly used APIs, but it is still not comprehensive enough and needs further improvement.
More detailed API is used to directly view the source code of related controller classes, such as QueryController.java, CubeController.java, etc.
> 在 2020年4月26日，12:14，伍明 <su...@qq.com> 写道：
>
> Hello,
> Is there a detailed document describing all the API services provided by kylin？
> http://kylin.apache.org/docs/howto/howto_use_restapi.html <http://kylin.apache.org/docs/howto/howto_use_restapi.html>
> The link above is not comprehensive.
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "Yaqian Zhang"<Ya...@126.com>;
> 发送时间: 2020年4月24日(星期五) 下午4:58
> 收件人: "user"<us...@kylin.apache.org>;
> 主题: Re: Is there any way to kill a running query?
>
> Yes, I think you can terminate all threads related to this query through the rest API.
>
> This rest API is introduced by PR corresponding to this issue KYLIN-1872. You can check the code changes here:
> https://github.com/apache/kylin/commit/54266f88c6e33d29f40f34092f54df98b1e8ec68 <https://github.com/apache/kylin/commit/54266f88c6e33d29f40f34092f54df98b1e8ec68>
>
>> 在 2020年4月24日，16:43，伍明 <sunshinemi.wu@qq.com <ma...@qq.com>> 写道：
>>
>>
>> Hi Yaqian:
>> Thank you for your reply.
>> I just saw this discussion：https://issues.apache.org/jira/browse/KYLIN-1872 <https://issues.apache.org/jira/browse/KYLIN-1872>
>> Can I stop the coprocessor running in the region through the rest api?
>>
>> ------------------ 原始邮件 ------------------
>> 发件人: "Yaqian Zhang"<Yaqian_Zhang@126.com <ma...@126.com>>;
>> 发送时间: 2020年4月24日(星期五) 下午4:33
>> 收件人: "user"<user@kylin.apache.org <ma...@kylin.apache.org>>;
>> 主题: Re: Is there any way to kill a running query?
>>
>> Hi:
>>
>> If you are operating on kylin web UI, when you leave the insight page, the page will prompt you "You've executing query in current page, are you sure to leave this page?”. Click Yes and the query will be terminated automatically.
>>
>> If you operate through REST API, you can use `http: //host:port / kylin / API / query / {queryid} / stop` to terminate the specified query statement. Before that, you can obtain the queryid through `http: / / localhost: 7070 / kylin / API / query / runningqueries`
>>
>>> 在 2020年4月24日，16:02，伍明 <sunshinemi.wu@qq.com <ma...@qq.com>> 写道：
>>>
>>> Hello,
>>> I found the slow query module on the web page, but I still don’t know how to kill it。
>>>
>>>
>>> ------------------ 原始邮件 ------------------
>>> 发件人: "伍明"<sunshinemi.wu@qq.com <ma...@qq.com>>;
>>> 发送时间: 2020年4月24日(星期五) 下午3:48
>>> 收件人: "user"<user@kylin.apache.org <ma...@kylin.apache.org>>;
>>> 主题: Is there any way to kill a running query?
>>>
>>> Hello,
>>> How should I manage kylin queries, especially slow queries? Can only the currently submitted queries be monitored through logs?
>>
>
回复： Is there any way to kill a running query?
Posted by 伍明 <su...@qq.com>.
Hello,
Is there a detailed document describing all the API services provided by kylin？
http://kylin.apache.org/docs/howto/howto_use_restapi.html
The link above is not comprehensive.
------------------ 原始邮件 ------------------
发件人: "Yaqian Zhang"<Yaqian_Zhang@126.com>;
发送时间: 2020年4月24日(星期五) 下午4:58
收件人: "user"<user@kylin.apache.org>;
主题: Re: Is there any way to kill a running query?
Yes, I think you can terminate all threads related to this query through the rest API.
This rest API is introduced by PR corresponding to this issue KYLIN-1872. You can check the code changes here:
https://github.com/apache/kylin/commit/54266f88c6e33d29f40f34092f54df98b1e8ec68
在 2020年4月24日，16:43，伍明 <sunshinemi.wu@qq.com> 写道：
Hi Yaqian:
Thank you for your reply.
I just saw this discussion：https://issues.apache.org/jira/browse/KYLIN-1872
Can I stop the coprocessor running in the region through the rest api?
------------------ 原始邮件 ------------------
发件人: "Yaqian Zhang"<Yaqian_Zhang@126.com>;
发送时间: 2020年4月24日(星期五) 下午4:33
收件人: "user"<user@kylin.apache.org>;
主题: Re: Is there any way to kill a running query?
Hi:
If you are operating on kylin web UI, when you leave the insight page, the page will prompt you "You've executing query in current page, are you sure to leave this page?”. Click Yes and the query will be terminated automatically.
If you operate through REST API, you can use `http: //host:port / kylin / API / query / {queryid} / stop` to terminate the specified query statement. Before that, you can obtain the queryid through `http: / / localhost: 7070 / kylin / API / query / runningqueries`
在 2020年4月24日，16:02，伍明 <sunshinemi.wu@qq.com> 写道：
Hello,
I found the slow query module on the web page, but I still don’t know how to kill it。
------------------ 原始邮件 ------------------
发件人: "伍明"<sunshinemi.wu@qq.com>;
发送时间: 2020年4月24日(星期五) 下午3:48
收件人: "user"<user@kylin.apache.org>;
主题: Is there any way to kill a running query?
Hello,
How should I manage kylin queries, especially slow queries? Can only the currently submitted queries be monitored through logs?
Re: Is there any way to kill a running query?
Posted by Yaqian Zhang <Ya...@126.com>.
Yes, I think you can terminate all threads related to this query through the rest API.
This rest API is introduced by PR corresponding to this issue KYLIN-1872. You can check the code changes here:
https://github.com/apache/kylin/commit/54266f88c6e33d29f40f34092f54df98b1e8ec68 <https://github.com/apache/kylin/commit/54266f88c6e33d29f40f34092f54df98b1e8ec68>
> 在 2020年4月24日，16:43，伍明 <su...@qq.com> 写道：
>
>
> Hi Yaqian:
> Thank you for your reply.
> I just saw this discussion：https://issues.apache.org/jira/browse/KYLIN-1872 <https://issues.apache.org/jira/browse/KYLIN-1872>
> Can I stop the coprocessor running in the region through the rest api?
>
> ------------------ 原始邮件 ------------------
> 发件人: "Yaqian Zhang"<Ya...@126.com>;
> 发送时间: 2020年4月24日(星期五) 下午4:33
> 收件人: "user"<us...@kylin.apache.org>;
> 主题: Re: Is there any way to kill a running query?
>
> Hi:
>
> If you are operating on kylin web UI, when you leave the insight page, the page will prompt you "You've executing query in current page, are you sure to leave this page?”. Click Yes and the query will be terminated automatically.
>
> If you operate through REST API, you can use `http: //host:port / kylin / API / query / {queryid} / stop` to terminate the specified query statement. Before that, you can obtain the queryid through `http: / / localhost: 7070 / kylin / API / query / runningqueries`
>
>> 在 2020年4月24日，16:02，伍明 <sunshinemi.wu@qq.com <ma...@qq.com>> 写道：
>>
>> Hello,
>> I found the slow query module on the web page, but I still don’t know how to kill it。
>>
>>
>> ------------------ 原始邮件 ------------------
>> 发件人: "伍明"<sunshinemi.wu@qq.com <ma...@qq.com>>;
>> 发送时间: 2020年4月24日(星期五) 下午3:48
>> 收件人: "user"<user@kylin.apache.org <ma...@kylin.apache.org>>;
>> 主题: Is there any way to kill a running query?
>>
>> Hello,
>> How should I manage kylin queries, especially slow queries? Can only the currently submitted queries be monitored through logs?
>
回复： Is there any way to kill a running query?
Posted by 伍明 <su...@qq.com>.
Hi Yaqian:
Thank you for your reply.
I just saw this discussion：https://issues.apache.org/jira/browse/KYLIN-1872
Can I stop the coprocessor running in the region through the rest api?
------------------ 原始邮件 ------------------
发件人: "Yaqian Zhang"<Yaqian_Zhang@126.com>;
发送时间: 2020年4月24日(星期五) 下午4:33
收件人: "user"<user@kylin.apache.org>;
主题: Re: Is there any way to kill a running query?
Hi:
If you are operating on kylin web UI, when you leave the insight page, the page will prompt you "You've executing query in current page, are you sure to leave this page?”. Click Yes and the query will be terminated automatically.
If you operate through REST API, you can use `http: //host:port / kylin / API / query / {queryid} / stop` to terminate the specified query statement. Before that, you can obtain the queryid through `http: / / localhost: 7070 / kylin / API / query / runningqueries`
在 2020年4月24日，16:02，伍明 <sunshinemi.wu@qq.com> 写道：
Hello,
I found the slow query module on the web page, but I still don’t know how to kill it。
------------------ 原始邮件 ------------------
发件人: "伍明"<sunshinemi.wu@qq.com>;
发送时间: 2020年4月24日(星期五) 下午3:48
收件人: "user"<user@kylin.apache.org>;
主题: Is there any way to kill a running query?
Hello,
How should I manage kylin queries, especially slow queries? Can only the currently submitted queries be monitored through logs?
Re: Is there any way to kill a running query?
Posted by Yaqian Zhang <Ya...@126.com>.
Hi:
If you are operating on kylin web UI, when you leave the insight page, the page will prompt you "You've executing query in current page, are you sure to leave this page?”. Click Yes and the query will be terminated automatically.
If you operate through REST API, you can use `http: //host:port / kylin / API / query / {queryid} / stop` to terminate the specified query statement. Before that, you can obtain the queryid through `http: / / localhost: 7070 / kylin / API / query / runningqueries`
> 在 2020年4月24日，16:02，伍明 <su...@qq.com> 写道：
>
> Hello,
> I found the slow query module on the web page, but I still don’t know how to kill it。
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "伍明"<su...@qq.com>;
> 发送时间: 2020年4月24日(星期五) 下午3:48
> 收件人: "user"<us...@kylin.apache.org>;
> 主题: Is there any way to kill a running query?
>
> Hello,
> How should I manage kylin queries, especially slow queries? Can only the currently submitted queries be monitored through logs?