[jira] [Updated] (FLINK-6839) Improve SQL OVER alias When only one OVER window agg in selection.
[ https://issues.apache.org/jira/browse/FLINK-6839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Metzger updated FLINK-6839: -- Component/s: Table API & SQL > Improve SQL OVER alias When only one OVER window agg in selection. > -- > > Key: FLINK-6839 > URL: https://issues.apache.org/jira/browse/FLINK-6839 > Project: Flink > Issue Type: Improvement > Components: Table API & SQL >Reporter: sunjincheng > > For OVER SQL: > {code} > SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND > PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable > {code} > 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.: > {code} > SELECT cnt1 from (SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN > INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable) > {code} > The SQL above is work well. which mentioned in > [FLINK-6760|https://issues.apache.org/jira/browse/FLINK-6760]. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (FLINK-6839) Improve SQL OVER alias When only one OVER window agg in selection.
[ https://issues.apache.org/jira/browse/FLINK-6839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] sunjincheng updated FLINK-6839: --- Description: For OVER SQL: {code} SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable {code} 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.: {code} SELECT cnt1 from (SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable) {code} The SQL above is work well. which mentioned in [FLINK-6760|https://issues.apache.org/jira/browse/FLINK-6760]. was: For OVER SQL: {code} SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable {code} 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.: {code} SELECT cnt1 from (SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable) {code} The SQL above is work well. which mentioned in [FLINK-6760|https://issues.apache.org/jira/browse/FLINK-6760]. > Improve SQL OVER alias When only one OVER window agg in selection. > -- > > Key: FLINK-6839 > URL: https://issues.apache.org/jira/browse/FLINK-6839 > Project: Flink > Issue Type: Improvement >Reporter: sunjincheng > > For OVER SQL: > {code} > SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND > PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable > {code} > 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.: > {code} > SELECT cnt1 from (SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN > INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable) > {code} > The SQL above is work well. which mentioned in > [FLINK-6760|https://issues.apache.org/jira/browse/FLINK-6760]. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (FLINK-6839) Improve SQL OVER alias When only one OVER window agg in selection.
[ https://issues.apache.org/jira/browse/FLINK-6839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] sunjincheng updated FLINK-6839: --- Description: For OVER SQL: {code} SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable {code} 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.: {code} SELECT cnt1 from (SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable) {code} The SQL above is work well. which mentioned in [FLINK-6760|https://issues.apache.org/jira/browse/FLINK-6760]. was: For OVER SQL: {code} SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable {code} 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.: {code} SELECT cnt1 from (SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable) {code} The SQL above is work well. which mentioned in [FLINK-6760|https://issues.apache.org/jira/browse/FLINK-6760]. > Improve SQL OVER alias When only one OVER window agg in selection. > -- > > Key: FLINK-6839 > URL: https://issues.apache.org/jira/browse/FLINK-6839 > Project: Flink > Issue Type: Improvement >Reporter: sunjincheng > > For OVER SQL: > {code} > SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN INTERVAL '10' SECOND > PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable > {code} > 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.: > {code} > SELECT cnt1 from (SELECT a COUNT(c) OVER (ORDER BY proctime RANGE BETWEEN > INTERVAL '10' SECOND PRECEDING AND CURRENT ROW) as cnt1 FROM MyTable) > {code} > The SQL above is work well. which mentioned in > [FLINK-6760|https://issues.apache.org/jira/browse/FLINK-6760]. -- This message was sent by Atlassian JIRA (v6.3.15#6346)