【doris2.1.5】Dorsi时间字段结果读取错误, 时间精度 9999 超长

Viewed 69

组件版本信息

组件 版本信息
doris 2.1.5
flink 1.17.2
flink-doris-connector-1.16 1.6.2

Doris数据

id data_time
1 9999-12-31 00:00:00

表结构信息

create table test(
	`id` varchar(20) NOT NULL,
	`data_time` datetime null
)ENGINE=OLAP
UNIQUE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);

flink 任务

create table doris_test(
	`id` varchar(20),
	`data_time` TIMESTAMP,
	PRIMARY KEY(`id`) NOT ENFORCED
)with(
	'connector' = 'doris',
	'fenodes' = 'localhost:8031',
	'table.identifier' = 'dim.test',
	'username' = 'root',
	'password' = '123456'
);
create table print(
	id varchar(20),
	data_time timestamp
)with(
	'connector' = 'print'
);
insert into print 
select * from doris_test;

结果

1978-01-12T05:29:45.600

1 Answers