You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "sunjincheng (JIRA)" <ji...@apache.org> on 2017/06/02 16:51:04 UTC
[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)