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

如何像mysql一样定义会话级别的临时表?CTE如何定义成会话级别?

Asked May 11, 2024 Modified May 13, 2024
Viewed 162
2.1 demand

1.在doris如何实现类似mysql临时表功能?

CREATE TEMPORARY TABLE temp_table_name AS
SELECT column1, column2, ...
FROM source_table
WHERE condition;

2.或者CTE是否可以在整个会话中生效?

edited May 13, 2024
wangdi29
asked May 11, 2024
1 Answers

这个暂时不支持,有想法的话,欢迎参与贡献呀~

edited May 13, 2024
徐振超@SelectDB(可以直接加微信Faith_xzc)8286
answered May 11, 2024
Related Questions
集群规划问题
1 answers
doris2.0.7集群迁移到新搭建的doris2.1.11集群
1 answers
多台BE节点异常宕机
1 answers
2.1.11版本,新优化器,执行计划隐式类型转换丢失精度,导致数据不一致
1 answers
workload groups 设置是否合理
1 answers
doris 2.x 同步到哪个版本的doris 最稳定
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 中文技术论坛.