You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "ZHAOXIXIN (JIRA)" <ji...@apache.org> on 2018/03/05 02:22:00 UTC

[jira] [Created] (KYLIN-3276) query with dynamic parameter get the same query result

ZHAOXIXIN created KYLIN-3276:
--------------------------------

             Summary: query with dynamic parameter get the same query result
                 Key: KYLIN-3276
                 URL: https://issues.apache.org/jira/browse/KYLIN-3276
             Project: Kylin
          Issue Type: Bug
          Components: Driver - JDBC, Query Engine
    Affects Versions: v2.2.0
         Environment: Kylin 2.2.0, JDK 1.8
            Reporter: ZHAOXIXIN


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) 




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)