[ https://issues.apache.org/jira/browse/DRILL-7511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17013340#comment-17013340 ]
Changbo Shu commented on DRILL-7511: ------------------------------------ I find a problem of project pushdown through debug test. I think that project express about complex table join is incorrect. > ClassCastException: *.NullableIntVector cannot be cast to > *.NullableVarCharVector will occur when executing sql29 and sql50 (many > tables hash join) in TPC-DS > ------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DRILL-7511 > URL: https://issues.apache.org/jira/browse/DRILL-7511 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Relational Operators, Query Planning & > Optimization > Affects Versions: 1.16.0 > Reporter: Changbo Shu > Priority: Major > > 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) > .... -- This message was sent by Atlassian Jira (v8.3.4#803005)