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/