建表like catalog表

Viewed 40
demand

mysql> create table xx like catalog.dbname.xx;
ERROR 1105 (HY000): errCode = 2, detailMessage = errCode = 2, detailMessage = External catalog 'mysql' is not allowed in 'CreateTableLikeStmt'
是否可以增加建表时like catalog中表的功能

1 Answers

试试 create table xx as select * from catalog.dbname.xx where 1=0;

黄海军@SelectDB4903
Related Questions
[CANCELLED]failed to initialize storage reader. tablet=57732, res=[E-3110][INTERNAL_ERROR]different type between schema and column reader
期望Doris支持Apache Ozone对象存储ofs协议
1 answers
【Bug】窗口函数+groupby 在join时报错
1 answers
最近生产环境Be 节点总是全部同时宕机！！！求大佬帮忙看看啊
2 answers
AWS上是否有Doris正式服务可用？计划用于生产环境。
1 answers
Doris 2.1.9 count(DISTINCT IF(sum(ActualPrice)>0,PatientId,null)) 无法执行
1 answers