Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Abandoned
-
None
-
None
-
None
Description
For OVER SQL:
SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable
We expect plan DataStreamCalc(select=[a, w0$o0 AS cnt1]) But we get DataStreamCalc(select=[a, w0$o0 AS $1]). this improve only for plan check. the functional is work well in nested queries,e.g.:
SELECT cnt1 from (SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable)
The SQL above is work well. which mentioned in FLINK-6760.