[jira] [Comment Edited] (HIVE-20319) group by and union all always generate empty query result

["Alice Fan (JIRA)" <ji...@apache.org>]

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

Alice Fan edited comment on HIVE-20319 at 9/27/18 5:57 PM:
-----------------------------------------------------------

HIVE-12812 is committed to master branch today. Let me know if you still see the same error and can we close this Jira? Thank you for reporting the issue. 


was (Author: afan):
HIVE-12812 is committed to master branch today. Let me know if you still see the same error and can we close this Jira. Thank you for reporting the issue. 

> group by and union all always generate empty query result
> ---------------------------------------------------------
>
>                 Key: HIVE-20319
>                 URL: https://issues.apache.org/jira/browse/HIVE-20319
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 2.3.2
>         Environment: Run on MR, hadoop 2.7.3
>            Reporter: Wang Yan
>            Priority: Blocker
>
> The following query always generates empty results which is wrong.
> {code:sql}
> create table if not exists test_table(column1 string, column2 int);
> insert into test_table values('a',1),('b',2);
> set hive.optimize.union.remove=true;
> select column1 from test_table group by column1
> union all
> select column1 from test_table group by column1;
> {code}
> Actual result : empty
> Expected result: 
> {code:java}
> a
> b
> a
> b
> {code}
> Note that correct result is generated when set hive.optimize.union.remove=false.
> It seems like the fix in HIVE-12788 is insufficient.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)