[FLINK-15310] A timestamp result get by a select sql and a csvsink sql is different

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.10.0
• Component/s: Table SQL / Client

Environment

execution:
planner: blink
type: batch

• Assignee: Unassigned
• Reporter: xiaojin.wy
• Created: 18/Dec/19 08:36
• Updated: 26/Dec/19 04:33
• Resolved: 26/Dec/19 04:33

Description

The sql is:
CREATE TABLE `orders` (
rowtime TIMESTAMP,
id INT,
product VARCHAR,
units INT
) WITH (
'format.field-delimiter'='|',
'connector.type'='filesystem',
'format.derive-schema'='true',
'connector.path'='/defender_test_data/daily_regression_blink_sql_1.10/test_agg/sources/orders.csv',
'format.type'='csv'
);
select floor(rowtime to hour) as rowtime, count as c from orders group by floor(rowtime to hour)

The result got in a sqlClient environment which use the sql above is like this:

But the same sql write directly to a cvs batch sink will get a result like this:
1972-03-06 08:44:36.736|4
1972-03-06 08:44:36.736|1

Issue Links

• is duplicated by: FLINK-15313 Can not insert decimal with precision into sink using TypeInformation
• relates to: FLINK-15313 Can not insert decimal with precision into sink using TypeInformation