You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/06/09 07:35:24 UTC
[jira] [Resolved] (DRILL-581) Successive execution of same query
returns different results
[ https://issues.apache.org/jira/browse/DRILL-581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau resolved DRILL-581.
----------------------------------
Resolution: Fixed
> 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)