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 2020/01/20 05:01:00 UTC
[jira] [Created] (FLINK-15678) Optimize producing primary key
without row number in special Top 1
Jingsong Lee created FLINK-15678:
------------------------------------
Summary: Optimize producing primary key without row number in special Top 1
Key: FLINK-15678
URL: https://issues.apache.org/jira/browse/FLINK-15678
Project: Flink
Issue Type: Bug
Components: Table SQL / Planner
Reporter: Jingsong Lee
Fix For: 1.11.0
{code:java}
SELECT c1, c2, c3, c4
FROM (
SELECT *,ROW_NUMBER() OVER (PARTITION BY c1, c2, c3 ORDER BY c4 DESC) AS rownum
FROM t
) WHERE rownum <= 1
{code}
This SQL is Top 1, Top N produce stream with primary keys contains row number, but your sql didn't select row number, so there is not primary key.
But for Top 1, we can produce primary key, because row number is always 1.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)