[jira] [Commented] (IMPALA-891) Add support for INTERSECT and EXCEPT set operations

["David J (Jira)" <ji...@apache.org>]

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

David J commented on IMPALA-891:
--------------------------------

Ran into a need for Intersect today.

 

I can Inner Join but need the functionality of a Union to pull all the data through without having to re-write my business logic in two places.

> Add support for INTERSECT and EXCEPT set operations
> ---------------------------------------------------
>
>                 Key: IMPALA-891
>                 URL: https://issues.apache.org/jira/browse/IMPALA-891
>             Project: IMPALA
>          Issue Type: New Feature
>          Components: Backend
>    Affects Versions: Impala 1.2.4, Impala 2.5.0, Impala 2.6.0, Impala 2.7.0
>            Reporter: Jonathan Seidman
>            Priority: Major
>              Labels: sql-language, tpc-ds, usability
>
> Set functionality includes the below.  Today, Impala has just {{UNION}} & {{UNION ALL}}.
> {code}
> UNION [DISTINCT]
> UNION ALL
> INTERSECT [DISTINCT]
> INTERSECT ALL
> EXCEPT [DISTINCT]
> EXCEPT ALL
> * MINUS is an alias for EXCEPT
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org