[
https://issues.apache.org/jira/browse/FLINK-40312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yanquan Lv resolved FLINK-40312.
--------------------------------
Fix Version/s: cdc-3.7.0
Assignee: Mao Jiayi
Resolution: Fixed
Merged in master via ff26ee22f7a89aafdb926d23f207c489d930b623.
> 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
> Assignee: Mao Jiayi
> Priority: Major
> Labels: pull-request-available
> Fix For: cdc-3.7.0
>
>
> 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)
