Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
v1.2
-
None
Description
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.