[ https://issues.apache.org/jira/browse/HIVE-25548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17419117#comment-17419117 ]
Stamatis Zampetakis commented on HIVE-25548: -------------------------------------------- Thanks for reporting this [~ximz]. Can you please include the stack trace in the description (inside \{noformat\} tags). People can find the JIRA easier by searching in Google for the exception. > ClassCastException during VectorMapJoinCommonOperator initialization for some > queries > ------------------------------------------------------------------------------------- > > Key: HIVE-25548 > URL: https://issues.apache.org/jira/browse/HIVE-25548 > Project: Hive > Issue Type: Bug > Affects Versions: 2.1.0, 2.2.0, 2.3.0, 3.0.0 > Reporter: Xiaomin Zhang > Priority: Major > > This issue is very similar to > https://issues.apache.org/jira/browse/HIVE-19388. On a Hive release with > HIVE-19388 fixed, some queries still failed. > set hive.execution.engine=spark; > create table if not exists t1(c int, d decimal) stored as orc; > insert into t1 values(0, 1); > create table if not exists t2(p int, q decimal) partitioned by (d int) stored > as ORC; > insert into t2 partition(d=10) values(10,2); > select c,t.p from t1 join (select * from t2 where t2.d=1) t on t1.d=t.q join > (select * from t2)x on x.d=t.d group by c,t.p; > Setting hive.mapjoin.optimized.hashtable=false worked, which is the same > workaround without HIVE-19388 fix -- This message was sent by Atlassian Jira (v8.3.4#803005)