【已记录】fe.log 日志 analysis exception happened when parsing stmt OriginStatement

Viewed 60

doris从1.2.7升级到2.0.7后,fe有这种异常日志,这个语句不是业务代码产生的。

2024-04-16 14:58:36,197 INFO (Analysis Job Executor-0|535) [StmtExecutor.parseByLegacy():1078] analysis exception happened when parsing stmt OriginStatement{originStmt='SELECT SUBSTRING(CAST(MIN(crm_chance_id) AS STRING), 1, 1024) as min, SUBSTRING(CAST(MAX(crm_chance_id) AS STRING), 1, 1024) as max FROM default_cluster:crm_report.ods_wechat_work_room_member index null', idx=0}, id: 0, error: Syntax error in line 1:
..._wechat_work_room_memberindexnull^ Encountered: INDEX Expected: COMMA, INDEX is keyword, maybeINDE

1 Answers

【问题状态】已处理
【问题进展】升级以后,materializedview的index id不对了,统计信息这边报错只是这个问题的一个表现https://github.com/apache/doris/pull/33423 这个pr修了,pr合并到了208版本,升级208版后,问题解决