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

Posted to issues@flink.apache.org by "Shuo Cheng (Jira)" <ji...@apache.org> on 2021/07/08 03:25:00 UTC

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

    [ https://issues.apache.org/jira/browse/FLINK-23107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17377003#comment-17377003 ] 

Shuo Cheng commented on FLINK-23107:
------------------------------------

cc [~lzljs3620320], I'll take this Jira.

> 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
>            Priority: Major
>             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)