Zoltan Haindrich created HIVE-25792:
---------------------------------------

             Summary: Multi Insert query fails on CBO path 
                 Key: HIVE-25792
                 URL: https://issues.apache.org/jira/browse/HIVE-25792
             Project: Hive
          Issue Type: Bug
            Reporter: Zoltan Haindrich


{code}
set hive.cbo.enable=true;

drop table if exists aa1;
drop table if exists bb1;
drop table if exists cc1;
drop table if exists dd1;
drop table if exists ee1;
drop table if exists ff1;

create table aa1 ( stf_id string);
create table bb1 ( stf_id string);
create table cc1 ( stf_id string);
create table ff1 ( x string);

explain
from ff1 as a join cc1 as b 
insert overwrite table aa1 select   stf_id GROUP BY b.stf_id
insert overwrite table bb1 select b.stf_id GROUP BY b.stf_id
;

{code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to