[jira] [Created] (FLINK-40312) Support EXTRACT, date-part functions, and interval arithmetic in YAML Transform

["Mao Jiayi (Jira)" <ji...@apache.org>]

Mao Jiayi created FLINK-40312:
---------------------------------

             Summary: Support EXTRACT, date-part functions, and interval arithmetic in YAML Transform
                 Key: FLINK-40312
                 URL: https://issues.apache.org/jira/browse/FLINK-40312
             Project: Flink
          Issue Type: Improvement
          Components: Flink CDC
            Reporter: Mao Jiayi


Flink CDC YAML Transform already supports several temporal functions, but the following expressions are still incomplete:

* {{EXTRACT(unit FROM temporal)}}
* Date-part functions such as {{YEAR}}, {{QUARTER}}, {{MONTH}}, {{WEEK}}, {{DAYOFYEAR}}, {{DAYOFMONTH}}, {{DAYOFWEEK}}, {{HOUR}}, {{MINUTE}}, and {{SECOND}}
* Temporal arithmetic with interval literals

{code:sql}
event_time + INTERVAL '1' DAY
event_time - INTERVAL '2' HOUR
event_time + INTERVAL '1-2' YEAR TO MONTH
{code}

Date-part functions can currently be parsed by some parser tests, but their operator metadata and runtime implementations are missing. Interval literals can also be parsed, but are translated as ordinary Java arithmetic and fail at runtime.



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