You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/05/19 15:30:45 UTC
[GitHub] [incubator-doris] nextdreamblue commented on issue #9539: [Bug] CREATE TABLE LIKE Exception
nextdreamblue commented on issue #9539:
URL: https://github.com/apache/incubator-doris/issues/9539#issuecomment-1131874747
i meet some error like this issue.
i reproduce it like this :
MySQL [abc]> ADMIN SET FRONTEND CONFIG ("enable_batch_delete_by_default" = "true");
Query OK, 0 rows affected (0.01 sec)
MySQL [abc]>
MySQL [abc]> SET show_hidden_columns=true;
Query OK, 0 rows affected (0.00 sec)
MySQL [abc]> use aaa
Database changed
MySQL [aaa]> CREATE TABLE `expamle_1` ( `user_id` largeint(40) NOT NULL COMMENT "用户id", `username` varchar(50) NOT NULL COMMENT "用户昵称" ) ENGINE=OLAP UNIQUE KEY(`user_id`, `username`) COMMENT "OLAP" DISTRIBUTED BY HASH(`user_id`) BUCKETS 1 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "in_memory" = "false", "storage_format" = "V2" );
Query OK, 0 rows affected (4.47 sec)
MySQL [aaa]> show create table expamle_1;
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| expamle_1 | CREATE TABLE `expamle_1` (
`user_id` largeint(40) NOT NULL COMMENT "用户id",
`username` varchar(50) NOT NULL COMMENT "用户昵称",
`__DORIS_DELETE_SIGN__` tinyint(4) NOT NULL DEFAULT "0" COMMENT "doris delete flag hidden column"
) ENGINE=OLAP
UNIQUE KEY(`user_id`, `username`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`user_id`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2"
) |
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (13.05 sec)
MySQL [aaa]> create table expamle_2 like expamle_1;
ERROR 1105 (HY000): errCode = 2, detailMessage = Failed to execute CREATE TABLE LIKE expamle_1. Reason: errCode = 2, detailMessage = Duplicate column name '__DORIS_DELETE_SIGN__'
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org