Hi XQ Thanks for your reply. I had a quick check and there seem to be two streams of discussions.
1. (BEAM-9543) BeamSQL Pattern Recognization Functionality - https://issues.apache.org/jira/browse/BEAM-9543 I see the code is merged but the ticket indicates it is partially supported due to the time limit for Google Summer of Code 2020. It also indicates full functionality would be via constructing a CEP (Complex Event Processing) library, which is discussed in BEAM- 3767 . 2. (BEAM-3767) A Complex Event Processing (CEP) library/extension for Apache Beam - https://issues.apache.org/jira/browse/BEAM-3767 The goal is to implement an efficient pattern matching library inspired by eg) Apache Flink CEP. Both the tickets have an associating GitHub issue and no update for more than 1 year, which means they are not likely to be completed in the near future? Cheers, Jaehyeon On Sun, 24 Mar 2024 at 12:02, XQ Hu via user <[email protected]> wrote: > https://beam.apache.org/documentation/dsls/sql/zetasql/overview/ > and > > https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/zetasql/src/main/java/org/apache/beam/sdk/extensions/sql/zetasql/SupportedZetaSqlBuiltinFunctions.java > for the supported functions. > > On Sat, Mar 23, 2024 at 5:50 AM Jaehyeon Kim <[email protected]> wrote: > >> Hello, >> >> I found a blog article about pattern matching with Beam SQL - >> https://beam.apache.org/blog/pattern-match-beam-sql/. All of the PRs and >> commits that are included in the post are merged. >> >> On the other hand, the Beam Calcite SQL overview page indicates >> MATCH_RECOGNIZE is not supported ( >> https://beam.apache.org/documentation/dsls/sql/calcite/overview/). I >> haven't found a section whether ZetaSQL supports it or not. >> >> Can you please inform me if it is supported and relevant resources if so? >> >> Cheers, >> Jaehyeon >> >
