【已解决】doris 2.1.0，表的统计分析失败，报错：解析错误

Viewed 46
2.1

发现有大量表的统计分析失败，从fe日志里发现如下报错(物化视图为null，和index语法不对)，看到报错有些纳闷，希望能给予帮助，谢谢：

WARN (Analysis Job Executor-1|543057) [StmtExecutor.executeInternalQuery():2859] Fall back to legacy planner, because: Table aa doesn't have materialized view null
org.apache.doris.nereids.exceptions.AnalysisException: Table t_customer doesn't have materialized view null
at org.apache.doris.nereids.rules.analysis.BindRelation.makeOlapScan(BindRelation.java:201) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.rules.analysis.BindRelation.getLogicalPlan(BindRelation.java:244) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.rules.analysis.BindRelation.bind(BindRelation.java:183) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.rules.analysis.BindRelation.doBindRelation(BindRelation.java:120) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.rules.analysis.BindRelation.lambda$build$0(BindRelation.java:96) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.pattern.PatternMatcher$1.transform(PatternMatcher.java:92) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.jobs.rewrite.PlanTreeRewriteJob.rewrite(PlanTreeRewriteJob.java:54) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.jobs.rewrite.PlanTreeRewriteBottomUpJob.rewriteThis(PlanTreeRewriteBottomUpJob.java:116) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.jobs.rewrite.PlanTreeRewriteBottomUpJob.execute(PlanTreeRewriteBottomUpJob.java:80) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.jobs.scheduler.SimpleJobScheduler.executeJobPool(SimpleJobScheduler.java:43) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.jobs.rewrite.RootPlanTreeRewriteJob.execute(RootPlanTreeRewriteJob.java:54) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.jobs.executor.AbstractBatchJobExecutor.execute(AbstractBatchJobExecutor.java:119) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.jobs.executor.Analyzer.analyze(Analyzer.java:112) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.NereidsPlanner.lambda$analyze$0(NereidsPlanner.java:282) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.NereidsPlanner.keepOrShowPlanProcess(NereidsPlanner.java:616) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.NereidsPlanner.analyze(NereidsPlanner.java:282) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.NereidsPlanner.plan(NereidsPlanner.java:201) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.nereids.NereidsPlanner.plan(NereidsPlanner.java:124) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.executeInternalQuery(StmtExecutor.java:2857) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.BaseAnalysisTask.runQuery(BaseAnalysisTask.java:311) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.OlapAnalysisTask.doFull(OlapAnalysisTask.java:231) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.OlapAnalysisTask.doExecute(OlapAnalysisTask.java:82) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.BaseAnalysisTask.executeWithRetry(BaseAnalysisTask.java:190) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.BaseAnalysisTask.execute(BaseAnalysisTask.java:175) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.statistics.AnalysisTaskWrapper.lambda$new$0(AnalysisTaskWrapper.java:43) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_333]
at org.apache.doris.statistics.AnalysisTaskWrapper.run(AnalysisTaskWrapper.java:66) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_333]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_333]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_333]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_333]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_333]
2024-04-28 11:23:23,536 WARN (Analysis Job Executor-2|543058) [StmtExecutor.executeInternalQuery():2871] Failed to run internal SQL: OriginStatement{originStmt='SELECT CONCAT(1111, '-', 1111, '-', 'create_id') AS id, 0 AS catalog_id, 111 AS db_id, 1111 AS tbl_id, 57111980 AS idx_id, 'create_id' AS col_id, NULL AS part_id, COUNT(1) AS row_count, NDV(create_id) AS ndv, COUNT(1) - COUNT(create_id) AS null_count, SUBSTRING(CAST(MIN(create_id) AS STRING), 1, 1024) AS min, SUBSTRING(CAST(MAX(create_id) AS STRING), 1, 1024) AS max, COUNT(1) * 8 AS data_size, NOW() AS update_time FROM internal.aa.aa index null', idx=0}
org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 1:
aa.aa index null
^
Encountered: INDEX
Expected: COMMA, INDEX is keyword, maybe INDEX
引用

mullerjy5
1 Answers
徐振超@SelectDB1801