[jira] [Created] (FLINK-3943) Add support for EXCEPT (set minus)

["Fabian Hueske (JIRA)" <ji...@apache.org>]

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)