[jira] [Created] (HIVE-9053) select constant in union all followed by group by gives wrong result

[Pengcheng Xiong (JIRA)]

Pengcheng Xiong created HIVE-9053:
-------------------------------------

             Summary: select constant in union all followed by group by gives 
wrong result
                 Key: HIVE-9053
                 URL: https://issues.apache.org/jira/browse/HIVE-9053
             Project: Hive
          Issue Type: Bug
            Reporter: Pengcheng Xiong
            Assignee: Pengcheng Xiong


Here is the the way to reproduce with q test:

select key from (select '1' as key from src union all select key from src)tab 
group by key;

will give

OK
NULL
1

This is not correct as src contains many other keys.



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