[DRILL-1447] Hash join implicit cast fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.6.0
• Assignee: Mehant Baid
• Reporter: Steven Phillips
• Created: 24/Sep/14 01:36
• Updated: 09/Dec/14 17:49
• Resolved: 25/Sep/14 20:46

Description

Join on two columns, where one is int, and the other is bigint, does not return any results when using hash join. Disabling hashjoin gives the expected result.

In this example, nation_int and nation_big int each contain a single column, but one has int, and the other bigint:

0: jdbc:drill:> select i.n_nationkey as a, b.n_nationkey as b from nation_int i, nation_bigint b where i.n_nationkey = b.n_nationkey limit 5;
----------------------+

a

b

----------------------+
----------------------+
No rows selected (0.891 seconds)
0: jdbc:drill:> alter session set `planner.enable_hashjoin` = false;
----------------------+

ok

summary

----------------------+

true	planner.enable_hashjoin updated.

----------------------+
1 row selected (0.04 seconds)
0: jdbc:drill:> select i.n_nationkey as a, b.n_nationkey as b from nation_int i, nation_bigint b where i.n_nationkey = b.n_nationkey limit 5;
----------------------+

a

b

----------------------+

0	0
1	1
2	2
3	3
4	4

----------------------+
5 rows selected (1.275 seconds)

Issue Links

• duplicates: DRILL-1125 Implicit cast not working in the join condition
• is duplicated by: DRILL-1125 Implicit cast not working in the join condition