This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 49ba374961f Enhance documentation with SQL examples for partition
moves (#3258)
49ba374961f is described below
commit 49ba374961f7dd357dc59fcb517e2d6da15d8535
Author: Vitalii Zurian <[email protected]>
AuthorDate: Tue Jan 27 00:46:04 2026 +0100
Enhance documentation with SQL examples for partition moves (#3258)
Added SQL examples for moving partitions between storage tiers.
## Versions
- [ ] dev
- [x] 4.x
- [ ] 3.x
- [ ] 2.1
## Languages
- [ ] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../version-4.x/table-design/tiered-storage/tiered-ssd-hdd.md | 2 ++
1 file changed, 2 insertions(+)
diff --git
a/versioned_docs/version-4.x/table-design/tiered-storage/tiered-ssd-hdd.md
b/versioned_docs/version-4.x/table-design/tiered-storage/tiered-ssd-hdd.md
index 89beffcbe1e..3e0b781e97e 100644
--- a/versioned_docs/version-4.x/table-design/tiered-storage/tiered-ssd-hdd.md
+++ b/versioned_docs/version-4.x/table-design/tiered-storage/tiered-ssd-hdd.md
@@ -103,6 +103,7 @@ You should have 7 partitions, 5 of which use SSD as the
storage medium, while th
You can manually move an individual partition between storage tiers by
updating its `storage_medium` property. For example, to move a partition to HDD
storage:
```sql
+ALTER TABLE parent_table
MODIFY PARTITION (partition_name) SET ("storage_medium" = "HDD");
```
@@ -129,6 +130,7 @@ ALTER SYSTEM MODIFY BACKEND "cold_node1:9050" SET
("tag.location" = "archive");
Specify both the desired storage medium and the replication allocation:
```sql
+ALTER TABLE parent_table
MODIFY PARTITION (partition_name) SET ("storage_medium" = "HDD",
"replication_allocation" = "tag.location.archive:1");
```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
