Description
stream sql use this will occur `SQL validation failed. From line 1, column 106 to line 1, column 109: ROW/RANGE not allowed with RANK, DENSE_RANK or ROW_NUMBER functions`
Reproduce code:
CREATE TABLE src (
name STRING,
age BIGINT
) WITH (
'connector' = 'values'
)
create view src_view as select *, ROW_NUMBER() OVER (PARTITION BY name ORDER BY age DESC) as row_num from src
select name, age, row_num from src_view where row_num <= 3
Related Flink PR is:
https://github.com/apache/flink/pull/12819