You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "liyunzhang (JIRA)" <ji...@apache.org> on 2017/11/03 07:17:00 UTC
[jira] [Updated] (HIVE-17973) Fix small bug in
multi_insert_union_src.q
[ https://issues.apache.org/jira/browse/HIVE-17973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liyunzhang updated HIVE-17973:
------------------------------
Attachment: HIVE-17973.patch
> 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
> Attachments: HIVE-17973.patch
>
>
> 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)