Hanumath Rao Maduri created DRILL-5851: ------------------------------------------
Summary: Empty table during a join operation with a non empty table produces cast exception Key: DRILL-5851 URL: https://issues.apache.org/jira/browse/DRILL-5851 Project: Apache Drill Issue Type: Bug Components: Execution - Relational Operators Affects Versions: 1.11.0 Reporter: Hanumath Rao Maduri Assignee: Hanumath Rao Maduri Hash Join operation on tables with one table empty and the other non empty throws an exception {code} 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 {code} Here is an example query with which it is reproducible. {code} select * from cp.`sample-data/nation.parquet` nation left outer join dfs.tmp.`2.csv` as two on two.a = nation.`N_COMMENT`; {code} the contents of 2.csv is empty (i.e not even header info). -- This message was sent by Atlassian JIRA (v6.4.14#64029)