连接的oracle catalog
- 直接用select 搜索
select * from jdbc_oracle.user1.comments_v where id=100002111
正常返回
- 用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