Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
v2.2.0
-
None
-
Kylin 2.2.0, JDK 1.8
Description
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 600000"
then I got the right value the same like query from GUI:count (distinct uid)