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

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.16.0, 1.16.1
• Fix Version/s: 2.0.0
• Component/s: Formats (JSON, Avro, Parquet, ORC, SequenceFile)
• Labels: pull-request-available stale-assigned
• Assignee: waywtdcc
• Reporter: waywtdcc
• Created: 20/Oct/22 07:27
• Updated: 10/Jul/24 06:57

Description

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

Issue Links

• links to: GitHub Pull Request #21124