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:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to