flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (FLINK-12017) Support translation from Rank/Deduplicate to StreamTransformation
Date Wed, 03 Apr 2019 11:27:00 GMT

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

ASF GitHub Bot updated FLINK-12017:
-----------------------------------
    Labels: pull-request-available  (was: )

> Support translation from Rank/Deduplicate to StreamTransformation
> -----------------------------------------------------------------
>
>                 Key: FLINK-12017
>                 URL: https://issues.apache.org/jira/browse/FLINK-12017
>             Project: Flink
>          Issue Type: Task
>          Components: Table SQL / Planner
>            Reporter: Jing Zhang
>            Priority: Major
>              Labels: pull-request-available
>
> Support translation from Rank/Deduplicate to StreamTransformation, So following sql can
be run:
>  1. 
>  SELECT a, b, c
>  FROM (
>  SELECT *,
>  ROW_NUMBER() OVER (PARTITION BY b ORDER BY proc DESC) as rowNum
>  FROM T
>  )
>  WHERE rowNum = 1
>  2. 
>  SELECT *
>  FROM (
>  SELECT category, shopId, num,
>  ROW_NUMBER() OVER (PARTITION BY category ORDER BY num DESC) as rank_num
>  FROM T)
>  WHERE rank_num <= 2
>  



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

Mime
View raw message