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)
