现象见下图:
问题:create_time值为上午时段的时候能正常转换成秒或doris的time;当时段为下午时,返回值就为null
create_time的时间为上午早点的时候,能正常转换
doris版本:为2.1.5
源表的结构:
create catalog:
CREATE CATALOG `gp` PROPERTIES (
"user" = "xxx",
"use_meta_cache" = "false",
"type" = "jdbc",
"password" = "*XXX",
"lower_case_meta_names" = "true",
"jdbc_url" = "jdbc:postgresql://x.x.x.x:5432/xx?reWriteBatchedInserts=true",
"fetchsize" = "100000",
"driver_url" = "postgresql-42.7.2.jar",
"driver_class" = "org.postgresql.Driver",
"create_time" = "2024-09-25 11:23:03.557",
"checksum" = "bb897217989c97a463d8f571069d158a"
);