This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 8fb11f01aa8b [doc](auto-increment) fix some error of code example
(#477)
8fb11f01aa8b is described below
commit 8fb11f01aa8b513b52c073c4764bc561d018c471
Author: Wanghuan <[email protected]>
AuthorDate: Thu Mar 28 19:43:53 2024 +0800
[doc](auto-increment) fix some error of code example (#477)
---
docs/advanced/auto-increment.md | 2 +-
.../current/advanced/auto-increment.md | 4 ++--
.../current/advanced/orthogonal-bitmap-manual.md | 2 +-
.../version-2.1/advanced/auto-increment.md | 8 ++++----
.../version-2.1/advanced/orthogonal-bitmap-manual.md | 2 +-
versioned_docs/version-2.1/advanced/auto-increment.md | 6 +++---
6 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/docs/advanced/auto-increment.md b/docs/advanced/auto-increment.md
index 3b68a3499b67..d86c82c8af6b 100644
--- a/docs/advanced/auto-increment.md
+++ b/docs/advanced/auto-increment.md
@@ -417,7 +417,7 @@ PROPERTIES (
Store the result of the data aggregation operations into the aggregation
result table:
```sql
-insert into dws_tbl
+insert into dws_agg_tbl
select dwd_dup_tbl.dim1, dwd_dup_tbl.dim3, dwd_dup_tbl.dim5,
BITMAP_UNION(TO_BITMAP(dictionary_tbl.aid)), COUNT(1)
from dwd_dup_tbl INNER JOIN dictionary_tbl on dwd_dup_tbl.user_id =
dictionary_tbl.user_id
group by dwd_dup_tbl.dim1, dwd_dup_tbl.dim3, dwd_dup_tbl.dim5;
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/auto-increment.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/auto-increment.md
index 7544a995e8cc..afc1c6254afa 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/auto-increment.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/auto-increment.md
@@ -271,7 +271,7 @@ mysql> select * from tbl2 order by id;
4 rows in set (0.04 sec)
```
-当自增列是非key列时，如果用户没有指定自增列的值，其值会从表中原有的数据行中进行补齐。如果用户指定了自增列，则该列数据中的null值会被替换为生成出的值，非null值则保持不表，然后以部分列更新的语义插入该表。
+当自增列是非key列时，如果用户没有指定自增列的值，其值会从表中原有的数据行中进行补齐。如果用户指定了自增列，则该列数据中的null值会被替换为生成出的值，非null值则保持不变，然后以部分列更新的语义插入该表。
```sql
mysql> CREATE TABLE `demo`.`tbl3` (
@@ -414,7 +414,7 @@ PROPERTIES (
将数据聚合运算后存放至聚合结果表
```sql
-insert into dws_tbl
+insert into dws_agg_tbl
select dwd_dup_tbl.dim1, dwd_dup_tbl.dim3, dwd_dup_tbl.dim5,
BITMAP_UNION(TO_BITMAP(dictionary_tbl.aid)), COUNT(1)
from dwd_dup_tbl INNER JOIN dictionary_tbl on dwd_dup_tbl.user_id =
dictionary_tbl.user_id
group by dwd_dup_tbl.dim1, dwd_dup_tbl.dim3, dwd_dup_tbl.dim5;
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/orthogonal-bitmap-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/orthogonal-bitmap-manual.md
index 077db0003c3e..058923ba1683 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/orthogonal-bitmap-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/orthogonal-bitmap-manual.md
@@ -91,7 +91,7 @@ load数据时，对用户bitmap值range范围纵向切割，例如，用户id在
注：正交bitmap函数不能用在分区表，因为分区表分区内正交，分区之间的数据是无法保证正交的，则计算结果也是无法预估的。
-#### bitmap_orthogonal_intersect
+#### orthogonal_bitmap_intersect
求bitmap交集函数
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/auto-increment.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/auto-increment.md
index 7b8f48f6497c..1cfb17dbd73f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/auto-increment.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/auto-increment.md
@@ -274,7 +274,7 @@ mysql> select * from tbl2 order by id;
4 rows in set (0.04 sec)
```
-当自增列是非 key 列时，如果用户没有指定自增列的值，其值会从表中原有的数据行中进行补齐。如果用户指定了自增列，则该列数据中的 null
值会被替换为生成出的值，非 null 值则保持不表，然后以部分列更新的语义插入该表。
+当自增列是非 key 列时，如果用户没有指定自增列的值，其值会从表中原有的数据行中进行补齐。如果用户指定了自增列，则该列数据中的 null
值会被替换为生成出的值，非 null 值则保持不变，然后以部分列更新的语义插入该表。
```sql
mysql> CREATE TABLE `demo`.`tbl3` (
@@ -383,14 +383,14 @@ PROPERTIES (
将存量数据中的`user_id`导入字典表，建立`user_id`到整数值的编码映射
```sql
-insert into dit_tbl(user_id)
+insert into dictionary_tbl(user_id)
select user_id from dwd_dup_tbl group by user_id;
```
或者使用如下方式仅将增量数据中的`user_id`导入到字典表
```sql
-insert into dit_tbl(user_id)
+insert into dictionary_tbl(user_id)
select dwd_dup_tbl.user_id from dwd_dup_tbl left join dictionary_tbl
on dwd_dup_tbl.user_id = dictionary_tbl.user_id where dwd_dup_tbl.visit_time >
'2023-12-10' and dictionary_tbl.user_id is NULL;
```
@@ -417,7 +417,7 @@ PROPERTIES (
将数据聚合运算后存放至聚合结果表
```sql
-insert into dws_tbl
+insert into dws_agg_tbl
select dwd_dup_tbl.dim1, dwd_dup_tbl.dim3, dwd_dup_tbl.dim5,
BITMAP_UNION(TO_BITMAP(dictionary_tbl.aid)), COUNT(1)
from dwd_dup_tbl INNER JOIN dictionary_tbl on dwd_dup_tbl.user_id =
dictionary_tbl.user_id;
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/orthogonal-bitmap-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/orthogonal-bitmap-manual.md
index 077db0003c3e..058923ba1683 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/orthogonal-bitmap-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/orthogonal-bitmap-manual.md
@@ -91,7 +91,7 @@ load数据时，对用户bitmap值range范围纵向切割，例如，用户id在
注：正交bitmap函数不能用在分区表，因为分区表分区内正交，分区之间的数据是无法保证正交的，则计算结果也是无法预估的。
-#### bitmap_orthogonal_intersect
+#### orthogonal_bitmap_intersect
求bitmap交集函数
diff --git a/versioned_docs/version-2.1/advanced/auto-increment.md
b/versioned_docs/version-2.1/advanced/auto-increment.md
index 9cc51cae8c04..af1186f08f61 100644
--- a/versioned_docs/version-2.1/advanced/auto-increment.md
+++ b/versioned_docs/version-2.1/advanced/auto-increment.md
@@ -385,7 +385,7 @@ PROPERTIES (
Import the value of `user_id` from existing data into the dictionary table,
establishing the mapping of `user_id` to integer values:
```sql
-insert into dit_tbl(user_id)
+insert into dictionary_tbl(user_id)
select user_id from dwd_dup_tbl group by user_id;
```
@@ -393,7 +393,7 @@ Or import only the value of `user_id` in incrementa data
into the dictionary tab
```sql
-insert into dit_tbl(user_id)
+insert into dictionary_tbl(user_id)
select dwd_dup_tbl.user_id from dwd_dup_tbl left join dictionary_tbl
on dwd_dup_tbl.user_id = dictionary_tbl.user_id where dwd_dup_tbl.visit_time >
'2023-12-10' and dictionary_tbl.user_id is NULL;
```
@@ -420,7 +420,7 @@ PROPERTIES (
Store the result of the data aggregation operations into the aggregation
result table:
```sql
-insert into dws_tbl
+insert into dws_agg_tbl
select dwd_dup_tbl.dim1, dwd_dup_tbl.dim3, dwd_dup_tbl.dim5,
BITMAP_UNION(TO_BITMAP(dictionary_tbl.aid)), COUNT(1)
from dwd_dup_tbl INNER JOIN dictionary_tbl on dwd_dup_tbl.user_id =
dictionary_tbl.user_id;
```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
