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 14fbf7c1a09 [doc](typo) fix some typo in `remote-storage` section
(#1278)
14fbf7c1a09 is described below
commit 14fbf7c1a093616cbee3f34debc33669ab763748
Author: yagagagaga <[email protected]>
AuthorDate: Tue Nov 5 21:26:13 2024 +0800
[doc](typo) fix some typo in `remote-storage` section (#1278)
# Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [x] 2.0
# Languages
- [x] Chinese
- [x] English
---
docs/table-design/tiered-storage/remote-storage.md | 22 ++++++++++++++++------
.../table-design/tiered-storage/remote-storage.md | 20 +++++++++++++++-----
.../table-design/cold-hot-separation.md | 20 +++++++++++++++-----
.../table-design/tiered-storage/remote-storage.md | 20 +++++++++++++++-----
.../table-design/tiered-storage/remote-storage.md | 20 +++++++++++++++-----
.../table-design/cold-hot-separation.md | 22 ++++++++++++++++------
.../table-design/tiered-storage/remote-storage.md | 22 ++++++++++++++++------
.../table-design/tiered-storage/remote-storage.md | 22 ++++++++++++++++------
8 files changed, 124 insertions(+), 44 deletions(-)
diff --git a/docs/table-design/tiered-storage/remote-storage.md
b/docs/table-design/tiered-storage/remote-storage.md
index 5c2645dccc9..ca986f86d6a 100644
--- a/docs/table-design/tiered-storage/remote-storage.md
+++ b/docs/table-design/tiered-storage/remote-storage.md
@@ -66,7 +66,7 @@ When creating an S3 resource, a remote S3 connection
validation is performed to
Here is an example of creating an S3 resource:
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -97,13 +97,18 @@ CREATE TABLE IF NOT EXISTS create_table_use_created_policy
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning Notice
+If you set `"enable_unique_key_merge_on_write" = "true"` in UNIQUE table, you
can't use this feature.
+:::
+
And here is an example of creating an HDFS resource:
-```Plain
+```sql
CREATE RESOURCE "remote_hdfs" PROPERTIES (
"type"="hdfs",
"fs.defaultFS"="fs_host:default_fs_port",
@@ -128,19 +133,24 @@ CREATE TABLE IF NOT EXISTS
create_table_use_created_policy (
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning Notice
+If you set `"enable_unique_key_merge_on_write" = "true"` in UNIQUE table, you
can't use this feature.
+:::
+
Associate a storage policy with an existing table by using the following
command:
-```Plain
+```sql
ALTER TABLE create_table_not_have_policy SET ("storage_policy" =
"test_policy");
```
Associate a storage policy with an existing partition by using the following
command:
-```Plain
+```sql
ALTER TABLE create_table_partition MODIFY PARTITION (*) SET ("storage_policy"
= "test_policy");
```
@@ -219,7 +229,7 @@ Furthermore, the garbage data on objects is not immediately
cleaned up. The BE p
The S3 SDK defaults to using the virtual-hosted style. However, some object
storage systems (e.g., MinIO) may not have virtual-hosted style access enabled
or supported. In such cases, you can add the `use_path_style` parameter to
force the use of path-style access:
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -235,4 +245,4 @@ PROPERTIES
"s3.connection.timeout" = "1000",
"use_path_style" = "true"
);
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/tiered-storage/remote-storage.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/tiered-storage/remote-storage.md
index 21709eea7cc..ebe360c8aa9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/tiered-storage/remote-storage.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/tiered-storage/remote-storage.md
@@ -64,7 +64,7 @@ under the License.
下面演示如何创建 S3 RESOURCE：
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -95,13 +95,18 @@ CREATE TABLE IF NOT EXISTS create_table_use_created_policy
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning 注意
+UNIQUE 表如果设置了 `"enable_unique_key_merge_on_write" = "true"` 的话，无法使用此功能。
+:::
+
以及如何创建 HDFS RESOURCE：
-```Plain
+```sql
CREATE RESOURCE "remote_hdfs" PROPERTIES (
"type"="hdfs",
"fs.defaultFS"="fs_host:default_fs_port",
@@ -127,19 +132,24 @@ CREATE RESOURCE "remote_hdfs" PROPERTIES (
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning 注意
+UNIQUE 表如果设置了 `"enable_unique_key_merge_on_write" = "true"` 的话，无法使用此功能。
+:::
+
或者对一个已存在的表，关联 Storage policy
-```Plain
+```sql
ALTER TABLE create_table_not_have_policy set ("storage_policy" =
"test_policy");
```
或者对一个已存在的 partition，关联 Storage policy
-```Plain
+```sql
ALTER TABLE create_table_partition MODIFY PARTITION (*)
SET("storage_policy"="test_policy");
```
@@ -217,7 +227,7 @@ ALTER TABLE create_table_partition MODIFY PARTITION (*)
SET("storage_policy"="te
S3 SDK 默认使用 virtual-hosted style 方式。但某些对象存储系统 (如：minio) 可能没开启或没支持
virtual-hosted style 方式的访问，此时我们可以添加 use_path_style 参数来强制使用 path style 方式：
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/cold-hot-separation.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/cold-hot-separation.md
index 671f6e4623c..fcb7a400afa 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/cold-hot-separation.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/cold-hot-separation.md
@@ -64,7 +64,7 @@ under the License.
下面演示如何创建 S3 RESOURCE：
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -95,13 +95,18 @@ CREATE TABLE IF NOT EXISTS create_table_use_created_policy
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning 注意
+UNIQUE 表如果设置了 `"enable_unique_key_merge_on_write" = "true"` 的话，无法使用此功能。
+:::
+
以及如何创建 HDFS RESOURCE：
-```Plain
+```sql
CREATE RESOURCE "remote_hdfs" PROPERTIES (
"type"="hdfs",
"fs.defaultFS"="fs_host:default_fs_port",
@@ -127,19 +132,24 @@ CREATE RESOURCE "remote_hdfs" PROPERTIES (
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning 注意
+UNIQUE 表如果设置了 `"enable_unique_key_merge_on_write" = "true"` 的话，无法使用此功能。
+:::
+
或者对一个已存在的表，关联 Storage policy
-```Plain
+```sql
ALTER TABLE create_table_not_have_policy set ("storage_policy" =
"test_policy");
```
或者对一个已存在的 partition，关联 Storage policy
-```Plain
+```sql
ALTER TABLE create_table_partition MODIFY PARTITION (*)
SET("storage_policy"="test_policy");
```
@@ -217,7 +227,7 @@ ALTER TABLE create_table_partition MODIFY PARTITION (*)
SET("storage_policy"="te
S3 SDK 默认使用 virtual-hosted style 方式。但某些对象存储系统 (如：minio) 可能没开启或没支持
virtual-hosted style 方式的访问，此时我们可以添加 use_path_style 参数来强制使用 path style 方式：
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/tiered-storage/remote-storage.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/tiered-storage/remote-storage.md
index 21709eea7cc..ebe360c8aa9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/tiered-storage/remote-storage.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/tiered-storage/remote-storage.md
@@ -64,7 +64,7 @@ under the License.
下面演示如何创建 S3 RESOURCE：
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -95,13 +95,18 @@ CREATE TABLE IF NOT EXISTS create_table_use_created_policy
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning 注意
+UNIQUE 表如果设置了 `"enable_unique_key_merge_on_write" = "true"` 的话，无法使用此功能。
+:::
+
以及如何创建 HDFS RESOURCE：
-```Plain
+```sql
CREATE RESOURCE "remote_hdfs" PROPERTIES (
"type"="hdfs",
"fs.defaultFS"="fs_host:default_fs_port",
@@ -127,19 +132,24 @@ CREATE RESOURCE "remote_hdfs" PROPERTIES (
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning 注意
+UNIQUE 表如果设置了 `"enable_unique_key_merge_on_write" = "true"` 的话，无法使用此功能。
+:::
+
或者对一个已存在的表，关联 Storage policy
-```Plain
+```sql
ALTER TABLE create_table_not_have_policy set ("storage_policy" =
"test_policy");
```
或者对一个已存在的 partition，关联 Storage policy
-```Plain
+```sql
ALTER TABLE create_table_partition MODIFY PARTITION (*)
SET("storage_policy"="test_policy");
```
@@ -217,7 +227,7 @@ ALTER TABLE create_table_partition MODIFY PARTITION (*)
SET("storage_policy"="te
S3 SDK 默认使用 virtual-hosted style 方式。但某些对象存储系统 (如：minio) 可能没开启或没支持
virtual-hosted style 方式的访问，此时我们可以添加 use_path_style 参数来强制使用 path style 方式：
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/tiered-storage/remote-storage.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/tiered-storage/remote-storage.md
index 21709eea7cc..ebe360c8aa9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/tiered-storage/remote-storage.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/tiered-storage/remote-storage.md
@@ -64,7 +64,7 @@ under the License.
下面演示如何创建 S3 RESOURCE：
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -95,13 +95,18 @@ CREATE TABLE IF NOT EXISTS create_table_use_created_policy
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning 注意
+UNIQUE 表如果设置了 `"enable_unique_key_merge_on_write" = "true"` 的话，无法使用此功能。
+:::
+
以及如何创建 HDFS RESOURCE：
-```Plain
+```sql
CREATE RESOURCE "remote_hdfs" PROPERTIES (
"type"="hdfs",
"fs.defaultFS"="fs_host:default_fs_port",
@@ -127,19 +132,24 @@ CREATE RESOURCE "remote_hdfs" PROPERTIES (
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning 注意
+UNIQUE 表如果设置了 `"enable_unique_key_merge_on_write" = "true"` 的话，无法使用此功能。
+:::
+
或者对一个已存在的表，关联 Storage policy
-```Plain
+```sql
ALTER TABLE create_table_not_have_policy set ("storage_policy" =
"test_policy");
```
或者对一个已存在的 partition，关联 Storage policy
-```Plain
+```sql
ALTER TABLE create_table_partition MODIFY PARTITION (*)
SET("storage_policy"="test_policy");
```
@@ -217,7 +227,7 @@ ALTER TABLE create_table_partition MODIFY PARTITION (*)
SET("storage_policy"="te
S3 SDK 默认使用 virtual-hosted style 方式。但某些对象存储系统 (如：minio) 可能没开启或没支持
virtual-hosted style 方式的访问，此时我们可以添加 use_path_style 参数来强制使用 path style 方式：
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
diff --git a/versioned_docs/version-2.0/table-design/cold-hot-separation.md
b/versioned_docs/version-2.0/table-design/cold-hot-separation.md
index 43348379611..40bf39262d6 100644
--- a/versioned_docs/version-2.0/table-design/cold-hot-separation.md
+++ b/versioned_docs/version-2.0/table-design/cold-hot-separation.md
@@ -66,7 +66,7 @@ When creating an S3 resource, a remote S3 connection
validation is performed to
Here is an example of creating an S3 resource:
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -97,13 +97,18 @@ CREATE TABLE IF NOT EXISTS create_table_use_created_policy
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning Notice
+If you set `"enable_unique_key_merge_on_write" = "true"` in UNIQUE table, you
can't use this feature.
+:::
+
And here is an example of creating an HDFS resource:
-```Plain
+```sql
CREATE RESOURCE "remote_hdfs" PROPERTIES (
"type"="hdfs",
"fs.defaultFS"="fs_host:default_fs_port",
@@ -128,19 +133,24 @@ CREATE TABLE IF NOT EXISTS
create_table_use_created_policy (
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning Notice
+If you set `"enable_unique_key_merge_on_write" = "true"` in UNIQUE table, you
can't use this feature.
+:::
+
Associate a storage policy with an existing table by using the following
command:
-```Plain
+```sql
ALTER TABLE create_table_not_have_policy SET ("storage_policy" =
"test_policy");
```
Associate a storage policy with an existing partition by using the following
command:
-```Plain
+```sql
ALTER TABLE create_table_partition MODIFY PARTITION (*) SET ("storage_policy"
= "test_policy");
```
@@ -219,7 +229,7 @@ Furthermore, the garbage data on objects is not immediately
cleaned up. The BE p
The S3 SDK defaults to using the virtual-hosted style. However, some object
storage systems (e.g., MinIO) may not have virtual-hosted style access enabled
or supported. In such cases, you can add the `use_path_style` parameter to
force the use of path-style access:
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -235,4 +245,4 @@ PROPERTIES
"s3.connection.timeout" = "1000",
"use_path_style" = "true"
);
-```
\ No newline at end of file
+```
diff --git
a/versioned_docs/version-2.1/table-design/tiered-storage/remote-storage.md
b/versioned_docs/version-2.1/table-design/tiered-storage/remote-storage.md
index 5c2645dccc9..ca986f86d6a 100644
--- a/versioned_docs/version-2.1/table-design/tiered-storage/remote-storage.md
+++ b/versioned_docs/version-2.1/table-design/tiered-storage/remote-storage.md
@@ -66,7 +66,7 @@ When creating an S3 resource, a remote S3 connection
validation is performed to
Here is an example of creating an S3 resource:
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -97,13 +97,18 @@ CREATE TABLE IF NOT EXISTS create_table_use_created_policy
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning Notice
+If you set `"enable_unique_key_merge_on_write" = "true"` in UNIQUE table, you
can't use this feature.
+:::
+
And here is an example of creating an HDFS resource:
-```Plain
+```sql
CREATE RESOURCE "remote_hdfs" PROPERTIES (
"type"="hdfs",
"fs.defaultFS"="fs_host:default_fs_port",
@@ -128,19 +133,24 @@ CREATE TABLE IF NOT EXISTS
create_table_use_created_policy (
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning Notice
+If you set `"enable_unique_key_merge_on_write" = "true"` in UNIQUE table, you
can't use this feature.
+:::
+
Associate a storage policy with an existing table by using the following
command:
-```Plain
+```sql
ALTER TABLE create_table_not_have_policy SET ("storage_policy" =
"test_policy");
```
Associate a storage policy with an existing partition by using the following
command:
-```Plain
+```sql
ALTER TABLE create_table_partition MODIFY PARTITION (*) SET ("storage_policy"
= "test_policy");
```
@@ -219,7 +229,7 @@ Furthermore, the garbage data on objects is not immediately
cleaned up. The BE p
The S3 SDK defaults to using the virtual-hosted style. However, some object
storage systems (e.g., MinIO) may not have virtual-hosted style access enabled
or supported. In such cases, you can add the `use_path_style` parameter to
force the use of path-style access:
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -235,4 +245,4 @@ PROPERTIES
"s3.connection.timeout" = "1000",
"use_path_style" = "true"
);
-```
\ No newline at end of file
+```
diff --git
a/versioned_docs/version-3.0/table-design/tiered-storage/remote-storage.md
b/versioned_docs/version-3.0/table-design/tiered-storage/remote-storage.md
index 5c2645dccc9..ca986f86d6a 100644
--- a/versioned_docs/version-3.0/table-design/tiered-storage/remote-storage.md
+++ b/versioned_docs/version-3.0/table-design/tiered-storage/remote-storage.md
@@ -66,7 +66,7 @@ When creating an S3 resource, a remote S3 connection
validation is performed to
Here is an example of creating an S3 resource:
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -97,13 +97,18 @@ CREATE TABLE IF NOT EXISTS create_table_use_created_policy
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning Notice
+If you set `"enable_unique_key_merge_on_write" = "true"` in UNIQUE table, you
can't use this feature.
+:::
+
And here is an example of creating an HDFS resource:
-```Plain
+```sql
CREATE RESOURCE "remote_hdfs" PROPERTIES (
"type"="hdfs",
"fs.defaultFS"="fs_host:default_fs_port",
@@ -128,19 +133,24 @@ CREATE TABLE IF NOT EXISTS
create_table_use_created_policy (
UNIQUE KEY(k1)
DISTRIBUTED BY HASH (k1) BUCKETS 3
PROPERTIES(
+ "enable_unique_key_merge_on_write" = "false",
"storage_policy" = "test_policy"
);
```
+:::warning Notice
+If you set `"enable_unique_key_merge_on_write" = "true"` in UNIQUE table, you
can't use this feature.
+:::
+
Associate a storage policy with an existing table by using the following
command:
-```Plain
+```sql
ALTER TABLE create_table_not_have_policy SET ("storage_policy" =
"test_policy");
```
Associate a storage policy with an existing partition by using the following
command:
-```Plain
+```sql
ALTER TABLE create_table_partition MODIFY PARTITION (*) SET ("storage_policy"
= "test_policy");
```
@@ -219,7 +229,7 @@ Furthermore, the garbage data on objects is not immediately
cleaned up. The BE p
The S3 SDK defaults to using the virtual-hosted style. However, some object
storage systems (e.g., MinIO) may not have virtual-hosted style access enabled
or supported. In such cases, you can add the `use_path_style` parameter to
force the use of path-style access:
-```Plain
+```sql
CREATE RESOURCE "remote_s3"
PROPERTIES
(
@@ -235,4 +245,4 @@ PROPERTIES
"s3.connection.timeout" = "1000",
"use_path_style" = "true"
);
-```
\ No newline at end of file
+```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
