[jira] [Created] (DRILL-1447) Hash join implicit cast fails

["Steven Phillips (JIRA)" <ji...@apache.org>]

Steven Phillips created DRILL-1447:
--------------------------------------

             Summary: Hash join implicit cast fails
                 Key: DRILL-1447
                 URL: https://issues.apache.org/jira/browse/DRILL-1447
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Steven Phillips


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)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)