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

Reply via email to