为了更快的定位您的问题,请提供以下信息,谢谢
【详述】问题详细描述
使用mysql catalog能查看库表信息,但是当进行select 查询时报错:
URL rejected: Malformed input to a URL function
CREATE EXTERNAL CATALOG mysql1
PROPERTIES
(
“type”=“jdbc”,
“user”=“m***”,
“password”=“G***”,
“jdbc_uri”=“jdbc:mysql://****?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&autoReconnect=true”,
“driver_url”="*****.jar",
“driver_class”=“com.mysql.cj.jdbc.Driver”
);
请检查下jdbc_uri和driver_url是否有空格特殊字符的问题,be.INFO 和 be.out 里面可以搜索到详细的日志信息么
show databases from mysql1是能查询的,按理说已经连接上了,但是select * from db.tables;这样就不行
be里面没有信息,grep "Malformed input to a URL function"搜索不到
后续更改jdbc_uri,已经删除“/rsksmartcollectiondb”,但不知道为什么查询继续报错
open JDBCScanner failed, error: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: The connection property ‘zeroDateTimeBehavior’ acceptable values are: ‘CONVERT_TO_NULL’, ‘EXCEPTION’ or ‘ROUND’. The value ‘CONVERT_TO_NULL/rsksmartcollectiondb’ is not acceptable.
at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:595)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:581)
at com.zaxxer.hikari.pool.HikariPool.<init
已解决,不能添加多余的mysql参数,应该是目前starrocks mysql catalog还不支持,只需要加ip:port