This seems a bug to me. Guess the caching check didn't consider the dynamic parameter. Could you open a JIRA?
Cheers Yang On Thu, Mar 1, 2018 at 3:07 PM, Xixin <zxxb...@163.com> wrote: > Hi Yang, > I met the similar problem > sql:"select distinct uid from table where daytime=? limit 700000" > ps.setString(1,"2018-01-03") > store the result to ArrayList, and print the size of ArrayList. > when I set the daytime to different dates, the same result I got. > > I changed the sql, just change limit value for example > sql:"select distinct uid from table where daytime=? limit *60*0000" > then I got the right value the same like query from GUI:count (distinct > uid) > > is it a bug? or something I query in a wrong way? > Thanks in advance! > > -- > Sent from: http://apache-kylin.74782.x6.nabble.com/ >