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/04/24 11:07:03 UTC

[GitHub] [incubator-doris] xy720 opened a new issue #3389: [New Feature] Batch update partition's property in one command

xy720 opened a new issue #3389:
URL: https://github.com/apache/incubator-doris/issues/3389


   As [ISSUE #2299] saying, if users wanna update the replication number of a table, users can only alter partition one by one.
   We should support updating partitions' properties of a table in one command.
   
   1、For unpartitioned table, we should support update table's property directly.(pr #3360 )
   
   ```
   alter table test_tbl set ("replication_num" = "3");
   ```
   
   2、For range table, we should let user know they are updating multi-partitions and let them to specify partitions that needed update.
   
   Example:
   
   - replication_num
   
   ```
   alter table tbl_name modify partition (p1, p2, p3) set ("replication_num" = "3");
   ```
   
   - storage_medium && storage_cooldown_time
   
   ```
   alter table tbl_name modify partition (p1, p2, p3) set ("storage_medium" = "SSD", "storage_cooldown_time" = "2018-01-01 12:00:00");
   ```
   
   - in_memory
   
   ```
   alter table tbl_name modify partition (*) set ("in_memory" = "true");
   ```


----------------------------------------------------------------
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


[GitHub] [incubator-doris] morningman commented on issue #3389: [New Feature] Batch update partition's property in one command

Posted by GitBox <gi...@apache.org>.
morningman commented on issue #3389:
URL: https://github.com/apache/incubator-doris/issues/3389#issuecomment-619562668


   Looking forward your PR


----------------------------------------------------------------
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