Apache Drill
  1. Apache Drill
  2. DRILL-581

Successive execution of same query returns different results

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: None
    • Labels:
      None

      Description

      The input is a simple json file :

      { "first": "John", "last": "Doe", "age": 39, "sex": "M", "salary": 70000, "registered": true, "interests": [ "Reading", "Mountain Biking", "Hacking" ] }

      Execute select * against this file repeatedly.

      0: jdbc:drill:schema=dfs.drillTestDir> select * from `json_storage/employeeNestedArray.json`;
      ------------------------------------------------------------------------

      first last age sex salary registered interests

      ------------------------------------------------------------------------

      John Doe 39 M 70000 true [, , , , Reading, Mountain Biking, Hacking]

      ------------------------------------------------------------------------
      1 row selected (0.201 seconds)
      0: jdbc:drill:schema=dfs.drillTestDir> select * from `json_storage/employeeNestedArray.json`;
      ------------------------------------------------------------------------

      first last age sex salary registered interests

      ------------------------------------------------------------------------

      John Doe 39 M 70000 true [Reading, Mountain Biking, Hacking]

      ------------------------------------------------------------------------
      1 row selected (0.107 seconds)
      0: jdbc:drill:schema=dfs.drillTestDir> select * from `json_storage/employeeNestedArray.json`;
      Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "95ad7894-3b58-4712-803c-9abbd3cbc339"
      endpoint

      { address: "drillats2.qa.lab" user_port: 31010 control_port: 31011 data_port: 31012 }

      error_type: 0
      message: "Failure while running fragment. < IndexOutOfBoundsException:[ index: 1298624105, length: 7 (expected: range(0, 13107200)) ]"
      ]
      Error: exception while executing query (state=,code=0)

      Pretty consistent behavior and can be reproduced on sqlline.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Ramana Inukonda Nagaraj
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development