You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by "liuyankun@enmonster.com" <li...@enmonster.com> on 2023/04/21 08:04:21 UTC
array_filter 报错

doris版本1.2.3 ， 单机安装后，执行array_filter报错，
mysql> select array_filter(x->(x > 0),[1,2,3,0,null]);
ERROR 1105 (HY000): errCode = 2, detailMessage = Syntax error in line 1:
select array_filter(x->(x > 0),[1,2,3,0,null])
                      ^
Encountered: >
Expected: IDENTIFIER

mysql>


fe.warn.log日志如下
2023-04-21 16:02:48,051 WARN (mysql-nio-pool-14|2276) [ConnectProcessor.handleQueryException():361] Process one query failed because.
org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 1:
select array_filter(x->(x > 0),[1,2,3,0,null])
                      ^
Encountered: >
Expected: IDENTIFIER

        at org.apache.doris.qe.ConnectProcessor.parse(ConnectProcessor.java:395) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:285) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:471) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:698) ~[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_191]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_191]
        at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_191]
Caused by: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error
        at org.apache.doris.analysis.SqlParser.unrecovered_syntax_error(SqlParser.java:2374) ~[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:386) ~[doris-fe.jar:1.2-SNAPSHOT]
        ... 7 more




liuyankun@enmonster.com