[jira] [Created] (FLINK-12173) Optimize "SELECT DISTINCT" into Deduplicate with keep first row

[Shang Yuanchun (Jira)]

Jark Wu created FLINK-12173:
-------------------------------

             Summary: Optimize "SELECT DISTINCT" into Deduplicate with keep first row
                 Key: FLINK-12173
                 URL: https://issues.apache.org/jira/browse/FLINK-12173
             Project: Flink
          Issue Type: New Feature
          Components: Table SQL / Planner
            Reporter: Jark Wu


The following distinct query can be optimized into deduplicate on keys "a, b, c, d" and keep the first row.

{code:sql}
SELECT DISTINCT a, b, c, d;
{code}

We can optimize this query into Deduplicate to get a better performance than GroupAggregate.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)