[IMPALA-891] Add support for INTERSECT and EXCEPT set operations

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 1.2.4, Impala 2.5.0, Impala 2.6.0, Impala 2.7.0
• Component/s: Backend
• Labels: sql-language tpc-ds usability
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Jonathan Seidman
• Created: 17/Mar/14 22:39
• Updated: 09/Jun/20 01:12

Description

Set functionality includes the below. Today, Impala has just UNION & UNION ALL.

UNION [DISTINCT]
UNION ALL
INTERSECT [DISTINCT]
INTERSECT ALL
EXCEPT [DISTINCT]
EXCEPT ALL

* MINUS is an alias for EXCEPT

Sub-Tasks

• Convert UnionStmt class into to SetOperationStmt: Resolved
• Add INTERSECT and EXCEPT support to SetOperationStmt: Resolved
• Add INTERSECT and EXCEPT support to the Query Generator: Open
• Add INTERSECT and EXCEPT with DISTINCT Qualifier: Resolved
• Add INTERSECT and EXCEPT with ALL Qualifier: Open