Fabian Hueske created FLINK-3943: ------------------------------------ Summary: Add support for EXCEPT (set minus) Key: FLINK-3943 URL: https://issues.apache.org/jira/browse/FLINK-3943 Project: Flink Issue Type: New Feature Components: Table API Affects Versions: 1.1.0 Reporter: Fabian Hueske Priority: Minor
Currently, the Table API and SQL do not support EXCEPT. EXCEPT can be executed as a coGroup on all fields that forwards records of the first input if the second input is empty. In order to add support for EXCEPT to the Table API and SQL we need to: - Implement a {{DataSetMinus}} class that translates an EXCEPT into a DataSet API program using a coGroup on all fields. - Implement a {{DataSetMinusRule}} that translates a Calcite {{LogicalMinus}} into a {{DataSetMinus}}. - Extend the Table API (and validation phase) to provide an except() method. -- This message was sent by Atlassian JIRA (v6.3.4#6332)