[
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)
