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] > > > >
