[jira] [Created] (HIVE-25548) ClassCastException during VectorMapJoinCommonOperator initialization for some queries

["Xiaomin Zhang (Jira)" <ji...@apache.org>]

Xiaomin Zhang created HIVE-25548:
------------------------------------

             Summary: 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: 3.0.0, 2.3.0, 2.2.0, 2.1.0
            Reporter: Xiaomin Zhang


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)