I do not think anyone plans to work on these issues in the near future. On Sun, Mar 24, 2024 at 6:59 PM Jaehyeon Kim <dott...@gmail.com> wrote:
> 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 <user@beam.apache.org> 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 <dott...@gmail.com> 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 >>> >>