Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.3.0
    • 1.3.0, 1.4.0
    • Table SQL / API
    • None

    Description

      When we run the TableAPI as follows:

      val windowedTable = table
            .window(Over partitionBy 'c orderBy 'proctime preceding UNBOUNDED_ROW as 'w)
            .select('c, "countFun(b)" over 'w as 'mycount, weightAvgFun('a, 'b) over 'w as 'wAvg)
      

      We get the error:

      org.apache.flink.table.api.TableException: The over method can only using with aggregation expression.
      
      	at org.apache.flink.table.api.scala.ImplicitExpressionOperations$class.over(expressionDsl.scala:469)
      	at org.apache.flink.table.api.scala.ImplicitExpressionConversions$LiteralStringExpression.over(expressionDsl.scala:756)
      

      The reason is, the `over` method of `expressionDsl` not parse the String case.
      I think we should fix this before 1.3 release.

      Attachments

        Issue Links

          Activity

            People

              sunjincheng121 sunjincheng
              sunjincheng121 sunjincheng
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: