Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.3.0
    • Fix Version/s: 1.3.0, 1.4.0
    • Component/s: Table SQL / API
    • Labels:
      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

          Activity

            People

            • Assignee:
              sunjincheng121 sunjincheng
              Reporter:
              sunjincheng121 sunjincheng

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment