为了更快的定位您的问题，请提供以下信息，谢谢
【详述】jdbc catalog， 读取mysql数据， 报错
select channel,date,sum(fake=1) as fake, max(index) as good
from mysql_cluster.enlightent_daily.animation_total_info
where date >= ‘2023-11-20’ and channel in (‘qq’,‘iqiyi’,‘youku’,‘bilibili’) and index > 0
group by channel,date
SQL 错误 [1064] [42000]: open JDBCScanner failed, error: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘index > 0)’ at line 1[com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120), com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122), com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953), com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009), com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52), com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java), com.starrocks.jdbcbridge.JDBCScanner.open(JDBCScanner.java:68)]
【业务影响】
【是否存算分离】是
【StarRocks版本】3.1.4
【集群规模】例如：3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】社区群 17 后知后觉