nextdreamblue opened a new issue, #11941: URL: https://github.com/apache/doris/issues/11941
### 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. ### Description right now, if i restore a table, i must set "replication_num"="1" or other replication num or default 3 replication, and i will get a table with all parititions which have same replication_num. if a table have different replication num, if backup and restore it, i can not get a table which every partition with the same replication num as before the backup. for example: every partition of a table do not have same replication_num: MySQL [tmp]> show partitions from part_p; +-------------+---------------+----------------+---------------------+--------+--------------+------------------------------------------------------------------------+-----------------+---------+----------------+---------------+---------------------+---------------------+--------------------------+----------+------------+-------------------------+ | PartitionId | PartitionName | VisibleVersion | VisibleVersionTime | State | PartitionKey | Range | DistributionKey | Buckets | ReplicationNum | StorageMedium | CooldownTime | RemoteStoragePolicy | LastConsistencyCheckTime | DataSize | IsInMemory | ReplicaAllocation | +-------------+---------------+----------------+---------------------+--------+--------------+------------------------------------------------------------------------+-----------------+---------+----------------+---------------+---------------------+---------------------+--------------------------+----------+------------+-------------------------+ | 16004 | p1 | 2 | 2022-08-20 17:14:51 | NORMAL | p_partkey | [types: [INT]; keys: [-2147483648]; ..types: [INT]; keys: [1013157]; ) | p_partkey | 3 | 1 | HDD | 9999-12-31 23:59:59 | | NULL | 8.634 MB | false | tag.location.default: 1 | | 16005 | p2 | 2 | 2022-08-20 17:14:51 | NORMAL | p_partkey | [types: [INT]; keys: [1013157]; ..types: [INT]; keys: [1113157]; ) | p_partkey | 3 | 2 | HDD | 9999-12-31 23:59:59 | | NULL | 2.175 MB | false | tag.location.default: 2 | | 16006 | p3 | 2 | 2022-08-20 17:14:51 | NORMAL | p_partkey | [types: [INT]; keys: [1113157]; ..types: [INT]; keys: [1213157]; ) | p_partkey | 3 | 3 | HDD | 9999-12-31 23:59:59 | | NULL | 3.265 MB | false | tag.location.default: 3 | | 16007 | p4 | 2 | 2022-08-20 17:14:51 | NORMAL | p_partkey | [types: [INT]; keys: [1213157]; ..types: [INT]; keys: [2147483647]; ) | p_partkey | 3 | 1 | HDD | 9999-12-31 23:59:59 | | NULL | 1.810 MB | false | tag.location.default: 1 | +-------------+---------------+----------------+---------------------+--------+--------------+------------------------------------------------------------------------+-----------------+---------+----------------+---------------+---------------------+---------------------+--------------------------+----------+------------+-------------------------+ 4 rows in set (0.00 sec) i backup this table and restore it, i can not get same table with same partitions with the same replication num as before the backup. ### Solution add restore new property 'reserve_replica', which means you can get a table with same partitions with the same replication num as before the backup. ### Are you willing to submit PR? - [X] 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-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
