[jira] [Updated] (FLINK-29699) Json format parsing supports converting strings at the end with Z and numbers to timestamp

["Yuepeng Pan (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-29699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yuepeng Pan updated FLINK-29699:
--------------------------------
    Fix Version/s: 2.4.0
                       (was: 2.3.0)

> Json format parsing supports converting strings  at the end with Z and numbers to timestamp
> -------------------------------------------------------------------------------------------
>
>                 Key: FLINK-29699
>                 URL: https://issues.apache.org/jira/browse/FLINK-29699
>             Project: Flink
>          Issue Type: Improvement
>          Components: Formats (JSON, Avro, Parquet, ORC, SequenceFile)
>    Affects Versions: 2.1.0
>            Reporter: waywtdcc
>            Assignee: waywtdcc
>            Priority: Major
>              Labels: pull-request-available, stale-assigned
>             Fix For: 2.4.0
>
>
> When I use flink cdc to read oracle, the time type data returned by cdc is a long type timestamp. I want to convert it to timestamp type, but it is not supported.
>  
> 1. JSON parsing supports converting long timestamps into flink timestamp types, for example, supporting JSON parsing of 1666255300000 numbers into timestamp
> 2. JSON analysis supports the conversion of WITH_LOCAL_TIMEZONE string data into flink timestamp type, for example, it supports 1990-10-14T12:12:43.123456789Z into timestamp type



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