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

Exception in code generation when ambiguous columns in MATCH_RECOGNIZE

    XMLWordPrintableJSON

    Details

      Description

      Query:

      SELECT *
      FROM Ticker
      MATCH_RECOGNIZE (
        PARTITION BY symbol, price
        ORDER BY proctime
        MEASURES
          A.symbol AS symbol,
          A.price AS price
        PATTERN (A)
        DEFINE
          A AS symbol = 'a'
      ) AS T
      

      throws a cryptic exception from the code generation stack that the output arity is wrong. We should add early validation and throw a meaningful exception.

      I've also created a calcite ticket to fix it on calcite's side: CALCITE-2747

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                dwysakowicz Dawid Wysakowicz
                Reporter:
                dwysakowicz Dawid Wysakowicz
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 40m
                  40m