[
https://issues.apache.org/jira/browse/FLINK-20323?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17327516#comment-17327516
]
Flink Jira Bot commented on FLINK-20323:
----------------------------------------
This major issue is unassigned and itself and all of its Sub-Tasks have not
been updated for 30 days. So, it has been labeled "stale-major". If this ticket
is indeed "major", please either assign yourself or give an update. Afterwards,
please remove the label. In 7 days the issue will be deprioritized.
> CorrelateSortToRankRule cannot deal with multiple groupings
> -----------------------------------------------------------
>
> Key: FLINK-20323
> URL: https://issues.apache.org/jira/browse/FLINK-20323
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Reporter: Timo Walther
> Priority: Major
> Labels: stale-major
>
> Fix the following test case in {{CorrelateSortToRankRuleTest}}:
> {code}
> @Test // TODO: this is a valid case to support
> def testMultipleGroupingsNotSupported(): Unit = {
> val query =
> s"""
> |SELECT f0, f2
> |FROM
> | (SELECT DISTINCT f0, f1 FROM t1) t2,
> | LATERAL (
> | SELECT f2
> | FROM t1
> | WHERE f0 = t2.f0 AND f1 = t2.f1
> | ORDER BY f2
> | DESC LIMIT 3
> | )
> """.stripMargin
> util.verifyPlan(query)
> }
> {code}
> Currently, we only support one equal condition not {{f0 = t2.f0 AND f1 =
> t2.f1}}.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
