[
https://issues.apache.org/jira/browse/FLINK-27018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jeff-zou updated FLINK-27018:
-----------------------------
Description:
the bug is described as follows:
{code:java}
data in source:
2022-04-02 03:34:21.260
but after sink by sql, the 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.
was:
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.
> 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, the 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.10#820010)
