[DRILL-581] Successive execution of same query returns different results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Unassigned
• Reporter: Ramana Inukonda Nagaraj
• Created: 28/Apr/14 17:27
• Updated: 31/Jul/14 06:31
• Resolved: 09/Jun/14 05:35

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.