[DRILL-5851] Empty table during a join operation with a non empty table produces cast exception

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Fix Version/s: 1.13.0
• Component/s: Execution - Relational Operators
• Labels: ready-to-commit
• Assignee: Hanumath Rao Maduri
• Reporter: Hanumath Rao Maduri
• Reviewer: Paul Rogers
• Created: 06/Oct/17 23:43
• Updated: 06/Feb/18 19:12
• Resolved: 25/Jan/18 01:53

Description

Hash Join operation on tables with one table empty and the other non empty throws an exception

 
Error: SYSTEM ERROR: DrillRuntimeException: Join only supports implicit casts between 1. Numeric data
 2. Varchar, Varbinary data 3. Date, Timestamp data Left type: VARCHAR, Right type: INT. Add explicit casts to avoid this error

Here is an example query with which it is reproducible.

select * from cp.`sample-data/nation.parquet` nation left outer join dfs.tmp.`2.csv` as two on two.a = nation.`N_COMMENT`;

the contents of 2.csv is empty (i.e not even header info).

Issue Links

• is depended upon by: DRILL-4185 UNION ALL involving empty directory on any side of union all results in Failed query
• is related to: DRILL-6070 Hash join with empty tables should not do casting of data types to INT<OPTIONAL>
• links to: GitHub Pull Request #1059