You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "liyunzhang (JIRA)" <ji...@apache.org> on 2017/11/03 07:14:00 UTC

[jira] [Created] (HIVE-17973) Fix small bug in multi_insert_union_src.q

liyunzhang created HIVE-17973:
---------------------------------

             Summary: Fix small bug in multi_insert_union_src.q
                 Key: HIVE-17973
                 URL: https://issues.apache.org/jira/browse/HIVE-17973
             Project: Hive
          Issue Type: Bug
            Reporter: liyunzhang
            Assignee: liyunzhang


in ql\src\test\queries\clientpositive\multi_insert_union_src.q,  It is strange to drop src_multi1 twice and maybe want to drop src_multi2.
{code}
set hive.mapred.mode=nonstrict;
drop table if exists src2;
drop table if exists src_multi1;
drop table if exists src_multi1;
set hive.stats.dbclass=fs;
CREATE TABLE src2 as SELECT * FROM src;

create table src_multi1 like src;
create table src_multi2 like src;

explain
from (select * from src1 where key < 10 union all select * from src2 where key > 100) s
insert overwrite table src_multi1 select key, value where key < 150 order by key
insert overwrite table src_multi2 select key, value where key > 400 order by value;

from (select * from src1 where key < 10 union all select * from src2 where key > 100) s
insert overwrite table src_multi1 select key, value where key < 150 order by key
insert overwrite table src_multi2 select key, value where key > 400 order by value;

select * from src_multi1;
select * from src_multi2;


{code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)