Hi, I am using flink 1.11 and trying nested query where match_recognize is inside, as shown below : /select * from events where id = (SELECT * FROM events MATCH_RECOGNIZE (PARTITION BY org_id ORDER BY proctime MEASURES A.id AS startId ONE ROW PER MATCH PATTERN (A C* B) DEFINE A AS A.tag = 'tag1', C AS C.tag <> 'tag2', B AS B.tag = 'tag2'));/
And I am getting an error as : /org.apache.calcite.sql.validate.SqlValidatorException: Table 'A' not found/ Is this not supported ? If not what's the alternative ? -- Sent from: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/
