xhh0168 opened a new issue, #49824: URL: https://github.com/apache/doris/issues/49824
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version apache-doris-3.0.3-bin-x64 ### What's Wrong? using web-ui ---> query ---> Log Analysis error errCode = 2, detailMessage = Syntax error in line 1: ...'2025-04-07 13:12:03' AND <STR_78>) ORDER BY `created_... ^ Encountered: < Expected: IDENTIFIE 2025-04-07 14:08:42,991 WARN (mysql-nio-pool-23|41912) [ConnectProcessor.handleQueryException():471] Process one query failed because. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 1: ...'2025-04-07 13:06:48' AND <STR_200>) GROUP BY T ORDER ... ^ Encountered: < Expected: IDENTIFIER at org.apache.doris.qe.ConnectProcessor.parse(ConnectProcessor.java:514) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.executeQuery(ConnectProcessor.java:295) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:225) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:285) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:313) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:483) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352] at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352] Caused by: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error at org.apache.doris.analysis.SqlParser.unrecovered_syntax_error(SqlParser.java:2996) ~[doris-fe.jar:1.2-SNAPSHOT] at java_cup.runtime.lr_parser.parse(lr_parser.java:616) ~[jflex-1.4.3.jar:?] at org.apache.doris.common.util.SqlParserUtils.getMultiStmts(SqlParserUtils.java:60) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.parse(ConnectProcessor.java:503) ~[doris-fe.jar:1.2-SNAPSHOT] ... 9 more 2025-04-07 14:08:43,061 WARN (mysql-nio-pool-23|41912) [ConnectProcessor.handleQueryException():471] Process one query failed because. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 1: ...'2025-04-07 13:06:48' AND <STR_78>) ORDER BY `created_... ^ Encountered: < Expected: IDENTIFIER at org.apache.doris.qe.ConnectProcessor.parse(ConnectProcessor.java:514) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.executeQuery(ConnectProcessor.java:295) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:225) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:285) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:313) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:483) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352] at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352] Caused by: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error at org.apache.doris.analysis.SqlParser.unrecovered_syntax_error(SqlParser.java:2996) ~[doris-fe.jar:1.2-SNAPSHOT] at java_cup.runtime.lr_parser.parse(lr_parser.java:616) ~[jflex-1.4.3.jar:?] at org.apache.doris.common.util.SqlParserUtils.getMultiStmts(SqlParserUtils.java:60) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.parse(ConnectProcessor.java:503) ~[doris-fe.jar:1.2-SNAPSHOT] ... 9 more 2025-04-07 14:09:04,276 WARN (mysql-nio-pool-25|43072) [ProfileManager.pushProfile():216] Remove expired profile 70498270bd6480d-971473aa8cc303ea, execution profiles , queryIdDeque size 100, profile count 100, execution profile count 21 max_query_profile_num 100 2025-04-07 14:09:04,277 WARN (mysql-nio-pool-23|41912) [ProfileManager.pushProfile():216] Remove expired profile 6de0fe96696d4064-b922de5b26924db1, execution profiles , queryIdDeque size 100, profile count 100, execution profile count 21 max_query_profile_num 100 2025-04-07 14:09:04,282 WARN (mysql-nio-pool-23|41912) [ConnectProcessor.handleQueryException():471] Process one query failed because. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 1: ...'2020-04-01 13:06:48' AND <STR_78>) ORDER BY `created_... ^ Encountered: < Expected: IDENTIFIER at org.apache.doris.qe.ConnectProcessor.parse(ConnectProcessor.java:514) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.executeQuery(ConnectProcessor.java:295) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:225) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:285) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:313) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:483) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352] at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352] Caused by: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error at org.apache.doris.analysis.SqlParser.unrecovered_syntax_error(SqlParser.java:2996) ~[doris-fe.jar:1.2-SNAPSHOT] at java_cup.runtime.lr_parser.parse(lr_parser.java:616) ~[jflex-1.4.3.jar:?] at org.apache.doris.common.util.SqlParserUtils.getMultiStmts(SqlParserUtils.java:60) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.parse(ConnectProcessor.java:503) ~[doris-fe.jar:1.2-SNAPSHOT] ... 9 more 2025-04-07 14:09:04,283 WARN (mysql-nio-pool-25|43072) [ConnectProcessor.handleQueryException():471] Process one query failed because. org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 1: ...'2020-04-01 13:06:48' AND <STR_198>) GROUP BY T ORDER ... ^ Encountered: < Expected: IDENTIFIER at org.apache.doris.qe.ConnectProcessor.parse(ConnectProcessor.java:514) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.executeQuery(ConnectProcessor.java:295) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:225) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:285) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:313) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:483) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_352-352] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_352-352] at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_352-352] Caused by: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error at org.apache.doris.analysis.SqlParser.unrecovered_syntax_error(SqlParser.java:2996) ~[doris-fe.jar:1.2-SNAPSHOT] at java_cup.runtime.lr_parser.parse(lr_parser.java:616) ~[jflex-1.4.3.jar:?] at org.apache.doris.common.util.SqlParserUtils.getMultiStmts(SqlParserUtils.java:60) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.parse(ConnectProcessor.java:503) ~[doris-fe.jar:1.2-SNAPSHOT] ... 9 more ### What You Expected? how to fix this ? ### How to Reproduce? _No response_ ### Anything Else? how to fix this? ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
