You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Pengcheng Xiong (JIRA)" <ji...@apache.org> on 2014/12/15 21:12:13 UTC

[jira] [Updated] (HIVE-9105) Hive-0.13 select constant in union all followed by group by gives wrong result

     [ https://issues.apache.org/jira/browse/HIVE-9105?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pengcheng Xiong updated HIVE-9105:
----------------------------------
    Summary: Hive-0.13 select constant in union all followed by group by gives wrong result  (was: Hive-0.13 )

> Hive-0.13 select constant in union all followed by group by gives wrong result
> ------------------------------------------------------------------------------
>
>                 Key: HIVE-9105
>                 URL: https://issues.apache.org/jira/browse/HIVE-9105
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.13.0
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>
> select '1' as key from srcpart where ds="2008-04-09"
> UNION all
> SELECT key from srcpart where ds="2008-04-09" and hr="11"
> ) tab group by key 
> will generate wrong results



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