hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "liyunzhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17973) Fix small bug in multi_insert_union_src.q
Date Thu, 09 Nov 2017 01:52:01 GMT

    [ https://issues.apache.org/jira/browse/HIVE-17973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16245096#comment-16245096
] 

liyunzhang commented on HIVE-17973:
-----------------------------------

guess these unit test failures are not related to current jira. see in the [test|https://builds.apache.org/job/PreCommit-HIVE-Build/7712/#showFailuresLink]
of other jiras, following tests still failed
{code}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[insert_values_orig_table_use_metadata]
(batchId=62)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb] (batchId=156)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_2] (batchId=102)
org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testCliDriver[ct_noperm_loc] (batchId=94)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_multi] (batchId=111)
org.apache.hadoop.hive.cli.control.TestDanglingQOuts.checkDanglingQOut (batchId=206)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testConstraints (batchId=223)

{code}

[~lirui]: can you help review [HIVE-17973.2.patch|https://issues.apache.org/jira/secure/attachment/12896360/HIVE-17973.2.patch]?
thanks!

> 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
>            Priority: Trivial
>         Attachments: HIVE-17973.2.patch, HIVE-17973.2.patch, HIVE-17973.patch
>
>
> in ql\src\test\queries\clientpositive\multi_insert_union_src.q, 
> There are two problems in the query file
>  1.  It is strange to drop src_multi1 twice 
>  2. {{src1}} is not created but used src1(Maybe we create src1 in other qfile)
> {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)

Mime
View raw message