[HIVE-10780] Support INTERSECTION set operation

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: SQL
• Assignee: Unassigned
• Reporter: sanjiv singh
• Created: 21/May/15 07:25
• Updated: 10/Aug/17 15:43
• Resolved: 10/Aug/17 15:43

Description

Support a INTERSECTION operation as <qb1> INTERSECTION <qb2> .

Common requirement of queries to project two sets where you want result set which contains only those rows returned by both queries.

The following sample statement combines the results with the INTERSECT operator, which returns only those rows returned by both queries:

SELECT * FROM tableA
INTERSECT
SELECT * FROM tableB;

current exception:
FAILED: ParseException line :* missing EOF at 'SELECT' near 'INTERSECT'