By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement . We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

目前并不支持，不过这确实是一个好需求。
但doris的表结构导出后，应该只能给doris自身使用。并不适合mysql数据库。因为doris本身的数据模型和mysql是不一样的。

目前你可以通过 show create table table_name 命令来查看建表的sql。但不能批量导出。

It is not currently supported, but it is indeed a good demand.
But after the table structure of doris is exported, it should only be used by doris itself. Not suitable for mysql database. Because the data model of doris itself is different from mysql.

@EmmyMiao87 same problem, we want to use a table structure to create a new table，no data.
mysql has create table like xxx, if doris has it, that would be nice

@francisoliverlee The grammar you mentioned only needs to modify the grammar files sql_parser.cup and add a new CreateTableLikeStmt in analysis package. This function is not very complicated.

Does anyone want to help doris realize it?

< #4402 (comment) >, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AAGIITJHEYERJ2MQSOOERTLXFBZE3ANCNFSM4QFXMREA > You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>