[DRILL-711] join query fails with split file tables

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Unassigned
• Reporter: Zhiyong Liu
• Created: 13/May/14 18:09
• Updated: 31/Jul/14 06:31
• Resolved: 09/Jun/14 05:34

Description

Split parquet files for part and partsupp into three separate files.

0: jdbc:drill:schema=dfs.TpcHMulti> select p.p_partkey
. . . . . . . . . . . . . . . . . > from part p, partsupp ps
. . . . . . . . . . . . . . . . . > where p.p_partkey = ps.ps_partkey
. . . . . . . . . . . . . . . . . > and p.p_size = 41
. . . . . . . . . . . . . . . . . > order by p.p_partkey
. . . . . . . . . . . . . . . . . > limit 20;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "2c3ee611-9eaa-49a1-8d9e-9c6ce14672f7"
endpoint {
address: "perfnode104.perf.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while running fragment. < ArrayIndexOutOfBoundsException:[ 29301 ]"
]
Error: exception while executing query (state=,code=0)

Note that both of the following query executed:

select p_partkey from part;
select ps_partkey from partsupp;

git.commit.id=63b0346761692f0a4c851e7910791c028dc3cded