Mao Jiayi created FLINK-40240:
---------------------------------

             Summary: Support additional Flink SQL regular expression functions 
in YAML Transform
                 Key: FLINK-40240
                 URL: https://issues.apache.org/jira/browse/FLINK-40240
             Project: Flink
          Issue Type: Improvement
          Components: Flink CDC
            Reporter: Mao Jiayi


Flink CDC YAML Transform currently supports REGEXP_REPLACE, but the other 
regular expression functions commonly available in Flink SQL are missing.

This limits the ability to extract, locate, and count pattern matches in 
row-level transform expressions. Users currently need to implement UDFs for 
these operations.

The missing functions include:

* REGEXP_EXTRACT
* REGEXP_EXTRACT_ALL
* REGEXP_COUNT
* REGEXP_INSTR
* REGEXP_SUBSTR

YAML Transform should support these functions with behavior aligned with Flink 
SQL, including Java regular expression syntax, capture group indexes, NULL 
arguments, invalid patterns, and unmatched input.

REGEXP_EXTRACT_ALL should return ARRAY<STRING> and work correctly in YAML 
Transform projections.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to