Zhiyong Liu created DRILL-782:
---------------------------------
Summary: ArrayIndexOutOfBoundsException encountered in a sequence
of query executions
Key: DRILL-782
URL: https://issues.apache.org/jira/browse/DRILL-782
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Reporter: Zhiyong Liu
Datasources: TPCH (10MB), three-way split parquet files
git.commit.id.abbrev=70fab8c
git.commit.id=70fab8c968a6dc05471aa1f32009cd15945d4f3d
Follow the steps in exactly this order:
1. Restart drillbit
2. 0: jdbc:drill:schema=dfs.TpcHMulti> select c_custkey from customer1 order by
c_custkey;
+------------+
| c_custkey |
+------------+
| 1 |
| 2 |
| 3 |
| 4 |
| ... |
+------------+
| 1500 |
+------------+
1,500 rows selected (2.781 seconds)
3. Repeat the above query:
0: jdbc:drill:schema=dfs.TpcHMulti> select c_custkey from customer1 order by
c_custkey;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query.[error_id: "604a3e93-0eaf-4697-8367-d1d193624413"
endpoint {
address: "perfnode104.perf.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while running fragment. < IndexOutOfBoundsException:[ index:
640, length: 8 (expected: range(0, 640)) ]"
]
Error: exception while executing query (state=,code=0)
4. Now, add limit:
0: jdbc:drill:schema=dfs.TpcHMulti> select c_custkey from customer1 order by
c_custkey limit 5;
+------------+
| c_custkey |
+------------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
+------------+
5 rows selected (0.465 seconds)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
