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:15:13 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=14247163#comment-14247163 ]
Pengcheng Xiong commented on HIVE-9105:
---------------------------------------
as per [~jpullokkaran]'s request
> 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)