query 查询异常 Numeric Overflow

Viewed 15

连接的oracle catalog

  1. 直接用select 搜索
select *  from jdbc_oracle.user1.comments_v where id=100002111   
正常返回

  1. 用query的方式就报错了
select * from  query( "catalog" = "jdbc_oracle",  "query" = "select *  from user1.comments_v where id=100002111 " )

[CANCELLED]UdfRuntimeException: jdbc get block address:
CAUSED BY: SQLException: Numeric Overflow

1 Answers

目前driver版本多少,可以换成 mysql8.0.25 以上 的 jdbc driver试试。