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 2020/01/11 10:26:27 UTC
[GitHub] [incubator-doris] caiconghui opened a new issue #2738: Support
replication_num setting for table level
caiconghui opened a new issue #2738: Support replication_num setting for table level
URL: https://github.com/apache/incubator-doris/issues/2738
**Is your feature request related to a problem? Please describe.**
Now, there is only global level or partition level for replication_num setting, we need to set replication_num explicitly on alter table add partition statement every time.
**Describe the solution you'd like**
Support replication_num setting for table level, as a property stored in olap table. just like the following:
mysql> show create table doris_test_partition1;
+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| doris_test_partition1 | CREATE TABLE `doris_test_partition1` (
`olap_date` date NOT NULL COMMENT "",
`id` int(11) NOT NULL COMMENT "",
`name` varchar(100) NOT NULL COMMENT ""
) ENGINE=OLAP
UNIQUE KEY(`olap_date`, `id`)
COMMENT "OLAP"
PARTITION BY RANGE(`olap_date`)
(PARTITION p20191122 VALUES [('1900-01-01'), ('2019-11-23')),
PARTITION p20191123 VALUES [('2019-11-23'), ('2019-11-24')),
PARTITION p1111 VALUES [('2019-11-24'), ('2019-11-25')),
PARTITION p111 VALUES [('2019-11-25'), ('2019-11-26')),
PARTITION p1111111 VALUES [('2019-12-24'), ('2019-12-25')))
DISTRIBUTED BY HASH(`id`) BUCKETS 5
PROPERTIES (
"storage_type" = "COLUMN",
"replication_num" = "1"
); |
+-----------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.03 sec)
mysql>
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] caiconghui closed issue #2738: Support replication_num setting for table level
Posted by GitBox <gi...@apache.org>.
caiconghui closed issue #2738:
URL: https://github.com/apache/incubator-doris/issues/2738
----------------------------------------------------------------
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.
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