[jira] (FLINK-27018) timestamp missing end zero when outputing to kafka

["jeff-zou (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-27018 ]


    jeff-zou deleted comment on FLINK-27018:
    ----------------------------------

was (Author: JIRAUSER282259):
[~fpaul]  

yes, just kafka will trailing end 0, and i am sure the record coming to the sink is container end 0 when i debug in FlinkKafkaProducer.java: !kafka.png!

u can try it by connector print or file like this:

 
{code:java}
create table tmp_table(stime timestamp) with ('connector'='print');
insert into tmp_table select * from (values(timestamp '2022-04-02 03:34:21.260'));
 
{code}
 

> timestamp missing end  zero when outputing to kafka
> ---------------------------------------------------
>
>                 Key: FLINK-27018
>                 URL: https://issues.apache.org/jira/browse/FLINK-27018
>             Project: Flink
>          Issue Type: Bug
>          Components: Connectors / Kafka
>    Affects Versions: 1.13.5
>            Reporter: jeff-zou
>            Priority: Major
>         Attachments: kafka.png
>
>
> the bug is described as follows:
>  
> {code:java}
> data in source:
>  2022-04-02 03:34:21.260
> but after sink by sql, data in kafka:
>  2022-04-02 03:34:21.26
> {code}
>  
> data miss end zero in kafka.
>  
> sql:
> {code:java}
> create kafka_table(stime stimestamp) with ('connector'='kafka','format' = 'json');
> insert into kafka_table select stime from (values(timestamp '2022-04-02 03:34:21.260')){code}
> the value in kafka is : \{"stime":"2022-04-02 03:34:21.26"}, missed end zero.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)