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/13 02:09:37 UTC
[GitHub] [incubator-doris] hf200012 opened a new issue, #9539: [Bug]
hf200012 opened a new issue, #9539:
URL: https://github.com/apache/incubator-doris/issues/9539
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
1.0
### What's Wrong?
create table vehicle_state_record_1 like vehicle_state_record;
ERROR 1105 (HY000): errCode = 2, detailMessage = Failed to execute CREATE TABLE LIKE vehicle_state_record. Reason: errCode = 2, detailMessage = Duplicate column name '__DORIS_DELETE_SIGN__'
### What You Expected?
success
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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.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
[GitHub] [incubator-doris] hf200012 closed issue #9539: [Bug] CREATE TABLE LIKE Exception
Posted by GitBox <gi...@apache.org>.
hf200012 closed issue #9539: [Bug] CREATE TABLE LIKE Exception
URL: https://github.com/apache/incubator-doris/issues/9539
--
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
[GitHub] [incubator-doris] stalary commented on issue #9539: [Bug] CREATE TABLE LIKE Exception
Posted by GitBox <gi...@apache.org>.
stalary commented on issue #9539:
URL: https://github.com/apache/incubator-doris/issues/9539#issuecomment-1126739340
`__DORIS_DELETE_SIGN__` is a built-in field and should not be used when create table. I have tried it and it is normal to not have this field
--
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
[GitHub] [incubator-doris] stalary commented on issue #9539: [Bug]
Posted by GitBox <gi...@apache.org>.
stalary commented on issue #9539:
URL: https://github.com/apache/incubator-doris/issues/9539#issuecomment-1125586837
Let me have a look.
--
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
[GitHub] [incubator-doris] nextdreamblue commented on issue #9539: [Bug] CREATE TABLE LIKE Exception
Posted by GitBox <gi...@apache.org>.
nextdreamblue commented on issue #9539:
URL: https://github.com/apache/incubator-doris/issues/9539#issuecomment-1133909959
@stalary i think it is a bug, please check it
--
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
[GitHub] [incubator-doris] hf200012 commented on issue #9539: [Bug]
Posted by GitBox <gi...@apache.org>.
hf200012 commented on issue #9539:
URL: https://github.com/apache/incubator-doris/issues/9539#issuecomment-1125588965
> Let me have a look.
OK
--
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
[GitHub] [incubator-doris] nextdreamblue commented on issue #9539: [Bug] CREATE TABLE LIKE Exception
Posted by GitBox <gi...@apache.org>.
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
[GitHub] [incubator-doris] nextdreamblue commented on issue #9539: [Bug] CREATE TABLE LIKE Exception
Posted by GitBox <gi...@apache.org>.
nextdreamblue commented on issue #9539:
URL: https://github.com/apache/incubator-doris/issues/9539#issuecomment-1131876063
i commit a pr for fix this bug .
https://github.com/apache/incubator-doris/pull/9694
--
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