1,092
社区成员
发帖
与我相关
我的任务
分享
2017-07-31 16:12:10,679 ERROR route.AbstractQueryRouter - SELECT STATE AS `Status`, ROUND(SUM(DURATION),7) AS `Duration`, CONCAT(ROUND(SUM(DURATION)/*100,3), '%') AS `Percentage` FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID= GROUP BY STATE ORDER BY SEQ;
com.meidusa.amoeba.parser.ParseException: com.meidusa.amoeba.mysql.parser.sql.ParseException: Encountered "*" at line 1, column 92.
Was expecting one of:
"CASE" ...
"CAST" ...
"NULL" ...
"TRUE" ...
"FALSE" ...
"INTERVAL" ...
<INTEGER_LITERAL> ...
<FLOATING_POINT_LITERAL> ...
<IDENTIFIER> ...
<STRING_LITERAL> ...
<S_QUOTED_IDENTIFIER> ...
<S_COMMA_IDENTIFIER> ...
<S_PARAMETER_MARKER> ...
"(" ...
"`" ...
"+" ...
"-" ...
<IDENTIFIER> ...
"`" ...
<S_QUOTED_IDENTIFIER> ...
<S_COMMA_IDENTIFIER> ...
<IDENTIFIER> ...
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.doParse(MysqlParser.java:117)
at com.meidusa.amoeba.route.SqlBaseQueryRouter.parseStatement(SqlBaseQueryRouter.java:138)
at com.meidusa.amoeba.route.SqlBaseQueryRouter.evaluateTable(SqlBaseQueryRouter.java:50)
at com.meidusa.amoeba.route.SqlBaseQueryRouter.evaluateTable(SqlBaseQueryRouter.java:1)
at com.meidusa.amoeba.route.AbstractQueryRouter.evaluate(AbstractQueryRouter.java:136)
at com.meidusa.amoeba.route.AbstractQueryRouter.selectPool(AbstractQueryRouter.java:411)
at com.meidusa.amoeba.mysql.parser.MysqlQueryRouter.selectPool(MysqlQueryRouter.java:59)
at com.meidusa.amoeba.mysql.parser.MysqlQueryRouter.selectPool(MysqlQueryRouter.java:1)
at com.meidusa.amoeba.route.AbstractQueryRouter.doRoute(AbstractQueryRouter.java:111)
at com.meidusa.amoeba.mysql.handler.MySqlCommandDispatcher.handleQueryCommandMessage(MySqlCommandDispatcher.java:98)
at com.meidusa.amoeba.mysql.handler.MySqlCommandDispatcher$1.run(MySqlCommandDispatcher.java:242)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.meidusa.amoeba.mysql.parser.sql.ParseException: Encountered "*" at line 1, column 92.
Was expecting one of:
"CASE" ...
"CAST" ...
"NULL" ...
"TRUE" ...
"FALSE" ...
"INTERVAL" ...
<INTEGER_LITERAL> ...
<FLOATING_POINT_LITERAL> ...
<IDENTIFIER> ...
<STRING_LITERAL> ...
<S_QUOTED_IDENTIFIER> ...
<S_COMMA_IDENTIFIER> ...
<S_PARAMETER_MARKER> ...
"(" ...
"`" ...
"+" ...
"-" ...
<IDENTIFIER> ...
"`" ...
<S_QUOTED_IDENTIFIER> ...
<S_COMMA_IDENTIFIER> ...
<IDENTIFIER> ...
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.generateParseException(MysqlParser.java:5848)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.jj_consume_token(MysqlParser.java:5718)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLPrimaryExpression(MysqlParser.java:3305)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLUnaryExpression(MysqlParser.java:3106)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLMultiplicativeExpression(MysqlParser.java:3061)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLAddSubtractExpression(MysqlParser.java:2964)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLSimpleExpression(MysqlParser.java:2953)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLExpressionList(MysqlParser.java:2746)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.FunctionCall(MysqlParser.java:3359)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLPrimaryExpression(MysqlParser.java:3291)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLUnaryExpression(MysqlParser.java:3106)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLMultiplicativeExpression(MysqlParser.java:3025)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLAddSubtractExpression(MysqlParser.java:2964)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLSimpleExpression(MysqlParser.java:2953)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.OverloadedFunctionCall(MysqlParser.java:3452)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLPrimaryExpression(MysqlParser.java:3276)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLUnaryExpression(MysqlParser.java:3106)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLMultiplicativeExpression(MysqlParser.java:3025)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLAddSubtractExpression(MysqlParser.java:2964)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SQLSimpleExpression(MysqlParser.java:2953)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SelectItem(MysqlParser.java:2002)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SelectList(MysqlParser.java:1980)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SelectClause(MysqlParser.java:1943)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SubSelectStatement(MysqlParser.java:1734)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.FullSelectStatement(MysqlParser.java:1681)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.SelectQuery(MysqlParser.java:1309)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.parserInner(MysqlParser.java:355)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.parse(MysqlParser.java:268)
at com.meidusa.amoeba.mysql.parser.sql.MysqlParser.doParse(MysqlParser.java:114)
... 13 more