This is a bug in Kylin JDBC driver, found by Yerui: https://issues.apache.org/jira/browse/KYLIN-1274
2015-09-29 14:26 GMT+08:00 Li Yang <[email protected]>: > Sounds like a bug around limit. > > Meng, could you share a sample query that is unstable with limit clause? > > On Tue, Sep 22, 2015 at 9:40 AM, [email protected] <[email protected]> > wrote: > > > i use jdbc to query, and don't know how to set “acceptPartial=true", > > without limit clause in sql, it return right number of results, but with > > limit clause, it seems that random number of results would be returned, > for > > example: with limit 100000 in different sql, sometimes it return > > 100000,sometimes less than 100000,but all these query sql, the whole > > results number >100000 > > > > > > > > > > 中国移动广东有限公司 网管中心 梁猛 > > [email protected] > > > > 发件人： Shi, Shaofeng > > 发送时间： 2015-09-22 09:29 > > 收件人： [email protected] > > 主题： Re: 回复: Re: how to set 'acceptPartial' parameter in jdbc driver? > > Meng, if you don’t set limit, but set “acceptPartial=true”, will it > return > > records? ‘acceptPartial’ is a threshold when “limit” not presented; So if > > its behavior is different, there should be a bug; Could you please open a > > JIRA with your sample SQL? Thank you! > > > > On 9/22/15, 9:19 AM, "[email protected]" <[email protected]> wrote: > > > > >'limit' clause dosen't return right answer, for example, i use limit > > >100000 after query sql, but it returns nothing, without 'limit 100000', > > >it returns about a million results; > > > > > > > > > > > >中国移动广东有限公司 网管中心 梁猛 > > >[email protected] > > > > > >发件人： Shi, Shaofeng > > >发送时间： 2015-09-22 09:12 > > >收件人： [email protected] > > >主题： Re: how to set 'acceptPartial' parameter in jdbc driver? > > >so far no such option in jdbc driver, the default behavior is to accept > > >all results; If you only need a partial result set, you can use “limit” > > >clause in your SQL; Please open a JIRA if you have specific scenario or > > >need; > > > > > >On 9/21/15, 11:07 PM, "[email protected]" <[email protected]> > wrote: > > > > > >>i am using kylin jdbc driver, how to set 'acceptPartial' to be > > >>false/true in jdbc driver? > > >> > > >> > > >> > > >>中国移动广东有限公司 网管中心 梁猛 > > >>[email protected] > > > > > > > > -- Best regards, Shaofeng Shi
