You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "sunjincheng (JIRA)" <ji...@apache.org> on 2017/05/29 11:08:04 UTC

[jira] [Created] (FLINK-6760) Fix OverWindowTest alias test error

sunjincheng created FLINK-6760:
----------------------------------

             Summary: Fix OverWindowTest alias test error
                 Key: FLINK-6760
                 URL: https://issues.apache.org/jira/browse/FLINK-6760
             Project: Flink
          Issue Type: Sub-task
          Components: Table API & SQL
    Affects Versions: 1.3.0
            Reporter: sunjincheng
            Assignee: sunjincheng


For Sql:
{code}
val sql = "SELECT c, count(a) OVER (ORDER BY proctime ROWS BETWEEN 2 preceding AND CURRENT ROW) as cnt1 CURRENT ROW from MyTable"
{code}

The alias `cnt1` The alias did not take effect when we generated the plan string.  But we can using the alias in outer layer query, for example:

{code}
val sql = "SELECT cnt1 from (SELECT c, count(a) OVER (ORDER BY proctime ROWS BETWEEN 2 preceding AND CURRENT ROW) as cnt1 CURRENT ROW from MyTable)"
{code}

So in this JIRA. we just fix the test case for 1.3 release. In another JIRA. will improve the alias. 





--
This message was sent by Atlassian JIRA
(v6.3.15#6346)