You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org> on 2014/04/28 19:28:20 UTC
[jira] [Created] (DRILL-581) Successive execution of same query
returns different results
Ramana Inukonda Nagaraj created DRILL-581:
---------------------------------------------
Summary: Successive execution of same query returns different results
Key: DRILL-581
URL: https://issues.apache.org/jira/browse/DRILL-581
Project: Apache Drill
Issue Type: Bug
Reporter: Ramana Inukonda Nagaraj
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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)