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

ClassCastException: *.NullableIntVector cannot be cast to *.NullableVarCharVector will occur when executing sql29 and sql50 (many tables hash join) in TPC-DS

    XMLWordPrintableJSON

    Details

      Description

      for example, sql29 as follows:

      select 

        i_item_id,

        i_item_desc,

        s_store_id,

        s_store_name,

        max(ss_quantity) as store_sales_quantity,

        max(sr_return_quantity) as store_returns_quantity,

        max(cs_quantity) as catalog_sales_quantity

      from

        store_sales,

        store_returns,

        catalog_sales,

        date_dim d1,

        date_dim d2,

        date_dim d3,

        store,

        item

      where

        d1.d_moy = 4

      and d1.d_year=1998

      and d1.d_date_sk = ss_sold_date_sk

      and i_item_sk = ss_item_sk

      and s_store_sk = ss_store_sk

      and ss_customer_sk = sr_customer_sk

      and ss_item_sk = sr_item_sk

      and ss_ticket_number = sr_ticket_number

      and sr_returned_date_sk = d2.d_date_sk

      and d2.d_moy between 4 and 4+3

      and d2.d_year = 1998

      and sr_customer_sk = cs_bill_customer_sk

      and sr_item_sk = cs_item_sk

      and cs_sold_date_sk = cs_item_sk

      and cs_sold_date_sk = d3.d_date_sk

      and d3.d_year in (1998, 1998+1, 1998+2)

      group by 

        i_item_id,

        i_item_desc,

        s_store_id,

        s_store_name

      order by

        i_item_id,

        i_item_desc,

        s_store_id,

        s_store_name

      limit 100;

       

      exception stack as follows:

      Caused by: java.lang.ClassCastException: org.apache.drill.exec.vector.NullableIntVector cannot be cast to org.apache.drill.exec.vector.NullableVarCharVector

        at org.apache.drill.exec.vector.NullableVarCharVector.copyEntry(NullableVarcharVector.java:410)

       at org.apache.drill.exec.test.generated.HashJoinProbeGen1.appendProbe(HashJoinProbeTemplate.java:191)

       at org.apache.drill.exec.test.generated.HashJoinProbeGen1.outputRow(HashJoinProbeTemplate.java:213)

      ....

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sucab Changbo Shu
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: