Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5851

Empty table during a join operation with a non empty table produces cast exception

    Details

      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).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                hanu.ncr Hanumath Rao Maduri
                Reporter:
                hanu.ncr Hanumath Rao Maduri
                Reviewer:
                Paul Rogers
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: