imay commented on issue #2663: [Proposal] Support partition overwrite operation URL: https://github.com/apache/incubator-doris/issues/2663#issuecomment-583736874 > ``` > ALTER TABLE tbl > ADD TEMP PARTITION tp1 values [(lower), (high)) BUCKETS 10, > ADD TEMP PARTITION tp2 values ((lower), (high)) BUCKETS 20, > ADD TEMP PARTITION tp3 values [(lower), (high)); > ``` Prefer using keyword TEMPORARY > However, all ranges of the temporary partitions of a table must not conflict. Is this necessary? > In the replace partition operation, as long as after deleting original partitions and replaced with the temp partitions, the range of the entire table does not conflict, then the replace operation will be allowed. Besides the ranges don't conflict, the new partitions' range should be exactly the same with old partitions'. For example in the situation that the old partitions ranges are [1,3), [3,5) the new partition is [1,2) [3,5), there will be a hole [2,3) in the table. I'm not sure if this will work fine. > ``` > LOAD LABEL db1.label1 > DATA INFILE ("hdfs: // files") > INTO TABLE `my_table` > TEMP PARTITION (p1, p2) > ... > ``` I think the TEMP keyword here isn't necessary, and should be removed.
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
