回复： how to kill a query request in kylin

[李寅威 <25...@qq.com>]

Hi Jose & ShaoFeng:


    Thanks for your help. I've read the discussion in https://issues.apache.org/jira/browse/KYLIN-1872, whether there is an optional or temporary solution or improvement plan in the recent versions.




 




------------------ 原始邮件 ------------------
发件人: "Jose Raul Perez Rodriguez";<jo...@gmail.com>;
发送时间: 2016年8月31日(星期三) 晚上6:33
收件人: "dev"<de...@kylin.apache.org>; 

主题: Re: how to kill a query request in kylin



Sorry Yanwei, I was mixing Kylin with Hive (because I was working with 
Hive recently I had the same experience with queries), Hive does 
translate query to MR jobs.


On 31/08/16 12:22, ShaoFeng Shi wrote:
> Hi Jose, Kylin does NOT translate query to MR jobs; Actually, it translates
> the query to HBase scan;
>
> For yanwei's question, so far Kylin doesn't have an API to stop a query,
> there are some discussions in
> https://issues.apache.org/jira/browse/KYLIN-1872 , comments are welcomed.
>
> 2016-08-31 15:09 GMT+08:00 Jose Raul Perez Rodriguez <
> joseraul.work@gmail.com>:
>
>> Hi,
>>
>> Every query on Kylin is traduced to Map-Reduce jobs and that appears on
>> http://[hadoop]:8088/cluster/apps , here you can kill the map-reduce app
>> related to your query.
>>
>> I hope this helps,
>>
>> Regards,
>>
>>
>>
>> On 31/08/16 04:04, 李寅威 wrote:
>>
>>> Hi all:
>>>
>>>     I have a query consuming so long time until it return an error says
>>> time out, does kylin has rest api or other methods that can kill a query
>>> request?
>>>
>>
>

Re: how to kill a query request in kylin

[Li Yang <li...@apache.org>]

The key is HBase does not has an API to cancel a running coprocessor. We
may hack to achieve the cancel effect, but not a good approach in the end.

On Thu, Sep 1, 2016 at 9:49 AM, 李寅威 <25...@qq.com> wrote:

> Hi Jose & ShaoFeng:
>
>
>     Thanks for your help. I've read the discussion in
> https://issues.apache.org/jira/browse/KYLIN-1872, whether there is an
> optional or temporary solution or improvement plan in the recent versions.
>
>
>
>
>
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "Jose Raul Perez Rodriguez";<jo...@gmail.com>;
> 发送时间: 2016年8月31日(星期三) 晚上6:33
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: Re: how to kill a query request in kylin
>
>
>
> Sorry Yanwei, I was mixing Kylin with Hive (because I was working with
> Hive recently I had the same experience with queries), Hive does
> translate query to MR jobs.
>
>
> On 31/08/16 12:22, ShaoFeng Shi wrote:
> > Hi Jose, Kylin does NOT translate query to MR jobs; Actually, it
> translates
> > the query to HBase scan;
> >
> > For yanwei's question, so far Kylin doesn't have an API to stop a query,
> > there are some discussions in
> > https://issues.apache.org/jira/browse/KYLIN-1872 , comments are
> welcomed.
> >
> > 2016-08-31 15:09 GMT+08:00 Jose Raul Perez Rodriguez <
> > joseraul.work@gmail.com>:
> >
> >> Hi,
> >>
> >> Every query on Kylin is traduced to Map-Reduce jobs and that appears on
> >> http://[hadoop]:8088/cluster/apps , here you can kill the map-reduce
> app
> >> related to your query.
> >>
> >> I hope this helps,
> >>
> >> Regards,
> >>
> >>
> >>
> >> On 31/08/16 04:04, 李寅威 wrote:
> >>
> >>> Hi all:
> >>>
> >>>     I have a query consuming so long time until it return an error says
> >>> time out, does kylin has rest api or other methods that can kill a
> query
> >>> request?
> >>>
> >>
> >
>