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

Query from JDBC is partial results by default

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • v1.2
    • v1.3.0, v1.4.0
    • Driver - JDBC
    • 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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment