Yerui Sun created KYLIN-1274:
--------------------------------

             Summary: Query from JDBC is partial results by default
                 Key: KYLIN-1274
                 URL: https://issues.apache.org/jira/browse/KYLIN-1274
             Project: Kylin
          Issue Type: Bug
          Components: Driver - JDBC
    Affects Versions: 1.2
            Reporter: Yerui Sun
            Assignee: Yerui Sun
             Fix For: 1.3, 2.0


How to produce this problem: create a query with the result over 10000 rows, 
and query with 'order by desc'. Check the first row, it's not the last row in 
all result, but a middle row, maybe the 10000th row.
Checked the query log in kylin server, found 'Accept Partial: false', 
indicating it's indeed a partial query.
The reason is, JDBC driver sent the QueryRequest with json encoding, and parsed 
into SQLRequest in server side. By default, QueryRequest only has sql and 
project parameters, and leave all other attributes as default in SQLRequest, 
and in SQLRequest, acceptPartial is true. That's why the query was processed as 
a partial query.
The solution to solve this is simple, add acceptPartial as false in 
QueryRequest, and update JDBC driver.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to