Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-1274

Query from JDBC is partial results by default

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v1.2
    • Fix Version/s: v1.3.0, v1.4.0
    • Component/s: Driver - JDBC
    • Labels:
      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.

        Attachments

        1. KYLIN-1274-2.x-staging.patch
          1 kB
          Yerui Sun
        2. KYLIN-1274-1.x-staging.patch
          1 kB
          Yerui Sun

          Activity

            People

            • Assignee:
              sunyerui Yerui Sun
              Reporter:
              sunyerui Yerui Sun
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: