hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "wangwenli (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-9039) Support Union Distinct
Date Thu, 14 Jul 2016 01:01:20 GMT

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

wangwenli commented on HIVE-9039:
---------------------------------

[~pxiong], yes, you are correct, i am not means that , i just want to give a clue that, people
once write like that, should be chagned after this .
coming to this union feature, now it must be put under subqueries,  any plan to remove this
limitation, support like this? 

(select key,value from src limit 2)
UNION ALL
(select key,value from src3 limit 3)

> Support Union Distinct
> ----------------------
>
>                 Key: HIVE-9039
>                 URL: https://issues.apache.org/jira/browse/HIVE-9039
>             Project: Hive
>          Issue Type: New Feature
>          Components: Query Planning
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>             Fix For: 1.2.0
>
>         Attachments: HIVE-9039.01.patch, HIVE-9039.02.patch, HIVE-9039.03.patch, HIVE-9039.04.patch,
HIVE-9039.05.patch, HIVE-9039.06.patch, HIVE-9039.07.patch, HIVE-9039.08.patch, HIVE-9039.09.patch,
HIVE-9039.10.patch, HIVE-9039.11.patch, HIVE-9039.12.patch, HIVE-9039.13.patch, HIVE-9039.14.patch,
HIVE-9039.15.patch, HIVE-9039.16.patch, HIVE-9039.17.patch, HIVE-9039.18.patch, HIVE-9039.19.patch,
HIVE-9039.20.patch, HIVE-9039.21.patch, HIVE-9039.22.patch, HIVE-9039.23.patch
>
>
> CLEAR LIBRARY CACHE
> Current version (Hive 0.14) does not support union (or union distinct). It only supports
union all. In this patch, we try to add this new feature by rewriting union distinct to union
all followed by group by.



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

Mime
View raw message