hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13737) incorrect count when multiple inserts with union all
Date Thu, 26 May 2016 16:29:12 GMT

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

Ashutosh Chauhan commented on HIVE-13737:
-----------------------------------------

yes. There are lots of improvements to address this issue:  HIVE-13334

> incorrect count when multiple inserts with union all
> ----------------------------------------------------
>
>                 Key: HIVE-13737
>                 URL: https://issues.apache.org/jira/browse/HIVE-13737
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 1.2.1
>         Environment: hdp 2.3.4.7 on Red Hat 6
>            Reporter: Frank Luo
>            Priority: Critical
>
> Here is a test case to illustrate the issue. It seems MR works fine but Tez is having
the problem. 
> CREATE TABLE test(col1   STRING);
> CREATE TABLE src (col1 string);
> insert into table src values ('a');
> INSERT into TABLE test
> select * from (
>    SELECT * from src
>    UNION ALL
>    SELECT * from src) x;
> -- do it one more time
> INSERT INTO TABLE test
>    SELECT * from src
>    UNION ALL
>    SELECT * from src;
> --below gives correct result
> SELECT * FROM TEST;
> --count is incorrect. It might give either '1' or '2', but I am expecting '4'
> SELECT count (*) FROM test;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message