sanjiv singh created HIVE-10780:
-----------------------------------
Summary: Support INTERSECTION set operation
Key: HIVE-10780
URL: https://issues.apache.org/jira/browse/HIVE-10780
Project: Hive
Issue Type: Improvement
Components: SQL
Reporter: sanjiv singh
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'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
