You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Zhiyong Liu (JIRA)" <ji...@apache.org> on 2014/05/20 00:39:38 UTC

[jira] [Created] (DRILL-782) ArrayIndexOutOfBoundsException encountered in a sequence of query executions

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)