doris2.1.4查询oracle数据看的数据时 ,某字段提示日期转换异常

Viewed 8

错误提示:
rrCode = 2, detailMessage = (192.168.5.28)[CANCELLED]UdfRuntimeException: jdbc get block address:
CAUSED BY: SQLException: ORA-17132: Invalid conversion requested: oracle.sql.DATE to java.time.LocalDateTime
https://docs.oracle.com/error-help/db/ora-17132/
CAUSED BY: DateTimeException: Invalid value for HourOfDay (valid values 0 - 23): -1
但是从本库查询,数据正常

1 Answers

需要提供下创建 JDBC CATALOG 的语句,以及oracle的建表语句信息。

如果涉及到敏感信息,您可以私聊我主页微信发我下哈