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