Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
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.