Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-581

Successive execution of same query returns different results

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: 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:
            inramana Ramana Inukonda Nagaraj
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development