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

Union all not passing type info when the output contains 0 rows

    Details

      Description

      Version : 1.10.0
      git.commit.id.abbrev=4d4e0c2

      The below query fails without an explicit cast

      0: jdbc:drill:zk=10.10.100.190:5181> select t1.l_partkey, t2.o_orderdate from (
      . . . . . . . . . . . . . . . . . .> select l_orderkey, l_partkey, l_comment from cp.`tpch/lineitem.parquet` where l_quantity is null
      . . . . . . . . . . . . . . . . . .> union 
      . . . . . . . . . . . . . . . . . .> select l_orderkey, l_partkey, l_comment from cp.`tpch/lineitem.parquet` where l_quantity is null
      . . . . . . . . . . . . . . . . . .> ) as t1,
      . . . . . . . . . . . . . . . . . .> cp.`tpch/orders.parquet` as t2
      . . . . . . . . . . . . . . . . . .> where t1.l_comment = t2.o_comment;
      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
      
      Fragment 0:0
      
      [Error Id: e09bb8ee-cb1c-48bc-9dce-42ace2d4b80b on qa-node190.qa.lab:31010] (state=,code=0)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jni Jinfeng Ni
                Reporter:
                rkins Rahul Challapalli
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: