Apache Doris 中文技术论坛
Questions Tags Users Badges

使用正则查询的时候可以,insert就报错

Asked Aug 23, 2024 Modified Jan 1, 0001
Viewed 46
2.0

ad97c6dfc68f3e9190f161b45d88a16.png

edited Jan 1, 0001
chen7
asked Aug 23, 2024
1 Answers

确定几个问题:

  1. 2.0的具体哪个版本
  2. explain $sql ,分别 insert 和 select 都explain下看下走的什么优化器
  3. show variables like "%ner%"; 看下默认的优化器是什么。
    mysql> explain insert into supplier select * from supplier;
    +---------------------------------------------------------+
    | Explain String(Nereids Planner) |
    +---------------------------------------------------------+
edited Jan 1, 1970
阿渊@SelectDB (没回帖直接加我主页微信)9580
answered Aug 23, 2024
Related Questions
Doris Routine Load自动恢复机制
我的doris版本为2.0.6 在备份操作时,会导致所以fe节点宕机,这种情况该怎么排查,为什么备份会导致这个问题?
1 answers
doris fe节点变更成高可用配置
1 answers
各位大哥在通过k8s安装doris3.0的时候,有没有遇到cg启动不起来,提示Set max number of open file descriptors to a value greater than 60000.
1 answers
doris主键表可以bucket配置太小,怎么修改?
1 answers
doris2.0.2.1大量delete语句和stream load执行在5分钟左右
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.