hive-issues mailing list archives

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

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

Pengcheng Xiong commented on HIVE-9039:
---------------------------------------

[~wenli], please take a look at SQL standard. limit should be applied to the whole union all
results.

> 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