You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Jingsong Lee (Jira)" <ji...@apache.org> on 2021/07/15 06:31:00 UTC

[jira] [Closed] (FLINK-23107) Separate deduplicate rank from rank functions

     [ https://issues.apache.org/jira/browse/FLINK-23107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jingsong Lee closed FLINK-23107.
--------------------------------
    Resolution: Fixed

master: 3abec22c53662e69f82e6bc0d15f28e77b712fe3

> Separate deduplicate rank from rank functions
> ---------------------------------------------
>
>                 Key: FLINK-23107
>                 URL: https://issues.apache.org/jira/browse/FLINK-23107
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / Runtime
>            Reporter: Jingsong Lee
>            Assignee: Shuo Cheng
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.14.0
>
>
> SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY d ORDER BY e DESC) AS rownum from T) WHERE rownum=1
> Actually above sql is a deduplicate rank instead of a normal rank. We should separate the implementation for optimize the deduplicate rank and reduce bugs.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)