LakeShen created FLINK-18440: -------------------------------- Summary: ROW_NUMBER function: ROW/RANGE not allowed with RANK, DENSE_RANK or ROW_NUMBER functions Key: FLINK-18440 URL: https://issues.apache.org/jira/browse/FLINK-18440 Project: Flink Issue Type: Bug Components: Table SQL / Planner Affects Versions: 1.11.0 Reporter: LakeShen Fix For: 1.11.1
When I run flink sql ,the flink sql like this: create view test as select name, eat ,sum(age) as cnt from test_source group by name,eat; create view resultsssss as select *, ROW_NUMBER() OVER (PARTITION BY name ORDER BY cnt DESC) as row_num from test; The same sql code I could run success in flink 1.10, now I change the flink version into flink 1.11, it throw the exception. -- This message was sent by Atlassian Jira (v8.3.4#803005)