jdbc catalog greenplum6,time字段下午时间无法正常用cast来转换,也无法用time_to_sec来转换,返回null

Viewed 27

现象见下图:
5c4b4a13653e75fb6d14dbcd1f47a07.png

问题:create_time值为上午时段的时候能正常转换成秒或doris的time;当时段为下午时,返回值就为null
create_time的时间为上午早点的时候,能正常转换
image.png
doris版本:为2.1.5

源表的结构:
image.png

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"
);
1 Answers

感谢反馈!
麻烦补齐下catalog场景语句和gp表结构;
另外,正常使用一段时间后,突然无法正常使用,期间有做啥特别操作不,比如数据获schema变更之类的