Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-6614

Applying function on window auxiliary function fails

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.3.0, 1.4.0
    • 1.3.0, 1.4.0
    • Table SQL / API
    • None

    Description

      SQL queries that apply a function or expression on a window auxiliary function (TUMBLE_START, TUMBLE_END, HOP_START, etc). cannot be translated and fail with a CodeGenException:

      Exception in thread "main" org.apache.flink.table.codegen.CodeGenException: Unsupported call: TUMBLE_END

      Example query:

      SELECT 
  a, 
  toLong(TUMBLE_END(rowtime, INTERVAL '10' MINUTE)) AS t, 
  COUNT(b) AS cntB
FROM myTable
GROUP BY a, TUMBLE(rowtime, INTERVAL '10' MINUTE)

      Attachments

        Issue Links

          links to

          Web Link GitHub Pull Request #3930

          Activity

            People

              fhueske Fabian Hueske
              fhueske Fabian Hueske
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: