[FLINK-3942] Add support for INTERSECT

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Fix Version/s: 1.1.0
• Component/s: Table SQL / API
• Assignee: Jark Wu
• Reporter: Fabian Hueske
• Created: 20/May/16 09:30
• Updated: 08/Jul/16 12:56
• Resolved: 08/Jul/16 12:56

Description

Currently, the Table API and SQL do not support INTERSECT.

INTERSECT can be executed as join on all fields.

In order to add support for INTERSECT to the Table API and SQL we need to:

• Implement a DataSetIntersect class that translates an INTERSECT into a DataSet API program using a join on all fields.
• Implement a DataSetIntersectRule that translates a Calcite LogicalIntersect into a DataSetIntersect.
• Extend the Table API (and validation phase) to provide an intersect() method.

Issue Links

• links to: GitHub Pull Request #2159