Re: TIME/TIMESTAMP parse in Flink TABLE/SQL API

2020-02-25 Thread Outlook
again. Original Message Sender: Leonard Xu Recipient: godfrey he Cc: Outlook; user Date: Tuesday, Feb 25, 2020 22:56 Subject: Re: TIME/TIMESTAMP parse in Flink TABLE/SQL API Hi,Outlook Godfrey is right, you should follow the json format[1] when you parse your json message. You can use foll

Re: TIME/TIMESTAMP parse in Flink TABLE/SQL API

2020-02-25 Thread Outlook
By the way, my flink version is 1.10.0. Original Message Sender: Outlook Recipient: user Date: Tuesday, Feb 25, 2020 17:43 Subject: TIME/TIMESTAMP parse in Flink TABLE/SQL API Hi all, I read json data from kafka, and print to console. When I do this, some error occurs when time/timestamp

TIME/TIMESTAMP parse in Flink TABLE/SQL API

2020-02-25 Thread Outlook
Hi all, I read json data from kafka, and print to console. When I do this, some error occurs when time/timestamp deserialization. json data in Kafka: ``` { "server_date": "2019-07-09", "server_time": "14:02:00", "reqsndtime_c": "2019-07-09 02:02:00.040" } ``` flink code: ``` bsTableEnv.c