You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Na Zhai <na...@kyligence.io> on 2018/12/26 08:40:32 UTC

答复: show the kylin sql for timeout

Hi, yunyao.

       Is that you mean you want to see the phenomenon of SQL query timeout? Why do you want to do that? Or you just want to know the value of timeout?



发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用



________________________________
发件人: 黄云尧 <yu...@transsnet.com>
发送时间: Monday, December 24, 2018 4:52:05 PM
收件人: dev@kylin.apache.org
主题: show the kylin sql for timeout

I want to demo the appearance when a sql for timeout in kylin query , someone has a good idea?








Re: 答复: show the kylin sql for timeout

Posted by JiaTao Tao <ta...@gmail.com>.
At present, Kylin's min "kylin.query.timeout-seconds" is 60s, and you can
not set this smaller.

If you want to simulate the scenario of timeout, you can take a look at
"ITKylinQueryTest#testTimeoutQuery". It uses a hack way, see:
"org.apache.kylin.gridtable.StorageSideBehavior#SCAN_FILTER_AGGR_CHECKMEM_WITHDELAY".
But I do not recommend this cuz it seems just for developing and it is too
hacky.

By the way, Kylin's timeout exception is: KylinTimeoutException. And
there's a test mocked this scenario:
"org.apache.kylin.rest.service.KylinQueryTimeoutTest". May this can help
you.

-- 


Regards!

Aron Tao

黄云尧 <yu...@transsnet.com> 于2018年12月26日周三 上午11:54写道:

> i want to catch the exception and do something
> 发件人:Na Zhai <na...@kyligence.io>
> 发送日期:2018-12-26 16:40:32
> 收件人:"dev@kylin.apache.org" <de...@kylin.apache.org>
> 主题:答复: show the kylin sql for timeout>Hi, yunyao.
> >
> >       Is that you mean you want to see the phenomenon of SQL query
> timeout? Why do you want to do that? Or you just want to know the value of
> timeout?
> >
> >
> >
> >发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用
> >
> >
> >
> >________________________________
> >发件人: 黄云尧 <yu...@transsnet.com>
> >发送时间: Monday, December 24, 2018 4:52:05 PM
> >收件人: dev@kylin.apache.org
> >主题: show the kylin sql for timeout
> >
> >I want to demo the appearance when a sql for timeout in kylin query ,
> someone has a good idea?
> >
> >
> >
> >
> >
> >
> >
>
>
>