关于amoeba无法执行sql语句的问题

显示全部楼层 · 2021-1-27 07:16:22

ERRORroute.AbstractQueryRouter-SELECTTABLE_NAMEFROMINFORMATION_SCHEMA.COLUMNSWHERECOLUMN_NAME='IR_SID'ANDTABLE_SCHEMA='om_data'ANDTABLE_NAMEIN(SELECTTABLE_NAMEFROMINFORMATION_SCHEMA.COLUMNSGROUPBYTABLE_NAMEHAVINGCOUNT(COLUMN_NAME)>=30)
com.meidusa.amoeba.parser.ParseException:com.meidusa.amoeba.mysql.parser.sql.ParseException:Encountered"COLUMNS"atline1,column43.
Wasexpectingoneof:
[I]...
...
...
"`"...
atcom.meidusa.amoeba.mysql.parser.sql.MysqlParser.doParse(MysqlParser.java:117)
atcom.meidusa.amoeba.route.SqlBaseQueryRouter.parseStatement(SqlBaseQueryRouter.java:149)
atcom.meidusa.amoeba.mysql.handler.MySqlCommandDispatcher.handleMessage(MySqlCommandDispatcher.java:87)
atcom.meidusa.amoeba.mysql.net.MysqlClientConnection$2.run(MysqlClientConnection.java:291)
atjava.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
atjava.lang.Thread.run(Thread.java:662)
这是啥错误，请大神指教~
分 -->

千问 · 2021-1-27 07:16:22

找到小伙伴了，有没有解决方法。。。