simenliuxing created FLINK-25700: ------------------------------------ Summary: flinksql Cascading Window TVF Aggregation exception Key: FLINK-25700 URL: https://issues.apache.org/jira/browse/FLINK-25700 Project: Flink Issue Type: Bug Components: Table SQL / Planner Affects Versions: 1.14.0 Reporter: simenliuxing
flink version 1.14.0 sql {code:java} CREATE TABLE order_test ( order_price int, order_item varchar, ts as localtimestamp, WATERMARK FOR ts as ts - INTERVAL '5' SECOND ) WITH ( 'connector' = 'datagen' ); create view window_view2 as select window_start, window_end, window_time as rowtime, sum(order_price) partial_price from TABLE( TUMBLE( TABLE order_test, DESCRIPTOR(ts), INTERVAL '2' SECOND) ) group by order_price, window_start, window_end, window_time; select window_start, window_end, sum(partial_price) total_price from TABLE( TUMBLE( TABLE window_view2, DESCRIPTOR(rowtime), INTERVAL '10' SECOND) ) group by window_start, window_end;{code} exception {code:java} Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Column 'window_start' is ambiguous at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:467) at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:560) ... 41 more{code} I think it's a bug -- This message was sent by Atlassian Jira (v8.20.1#820001)