This is an automated email from the ASF dual-hosted git repository.
kassiez 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 9b69d942c5f [fix] add the window-function doc and
multi-dimensional-analytics doc sql used table data (#1478)
9b69d942c5f is described below
commit 9b69d942c5fa9483deba51dc60abb31dcf4cfc41
Author: feiniaofeiafei <[email protected]>
AuthorDate: Thu Dec 12 11:19:05 2024 +0800
[fix] add the window-function doc and multi-dimensional-analytics doc sql
used table data (#1478)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/query-data/multi-dimensional-analytics.md | 4 ++--
docs/query-data/window-function.md | 12 ++----------
.../current/query-data/multi-dimensional-analytics.md | 4 ++--
.../current/query-data/window-function.md | 12 ++----------
.../version-2.1/query-data/multi-dimensional-analytics.md | 3 +++
.../version-2.1/query-data/window-function.md | 12 ++----------
.../version-3.0/query-data/multi-dimensional-analytics.md | 4 ++--
.../version-3.0/query-data/window-function.md | 12 ++----------
.../version-2.1/query-data/multi-dimensional-analytics.md | 3 +++
versioned_docs/version-2.1/query-data/window-function.md | 12 ++----------
.../version-3.0/query-data/multi-dimensional-analytics.md | 4 ++--
versioned_docs/version-3.0/query-data/window-function.md | 12 ++----------
12 files changed, 26 insertions(+), 68 deletions(-)
diff --git a/docs/query-data/multi-dimensional-analytics.md
b/docs/query-data/multi-dimensional-analytics.md
index 88c20497ce3..021a49150b7 100644
--- a/docs/query-data/multi-dimensional-analytics.md
+++ b/docs/query-data/multi-dimensional-analytics.md
@@ -549,6 +549,6 @@ Using `CUBE` computes all possible aggregation levels
(eight in this case), but
);
```
-## Design Document
+## APPENDIX
-For detailed information, please refer to [SQL for Aggregation in Data
Warehouses](https://www.oracle.com/path-to-reference-documentation) on the
Oracle official website.
\ No newline at end of file
+For table creation statements and data files, see the [Window
Function](window-function.md) appendix.
\ No newline at end of file
diff --git a/docs/query-data/window-function.md
b/docs/query-data/window-function.md
index 9e806751728..d1b09006f26 100644
--- a/docs/query-data/window-function.md
+++ b/docs/query-data/window-function.md
@@ -647,7 +647,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS date_dim (
d_date_sk bigint not null,
d_date_id char(16) not null,
@@ -684,7 +683,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS customer_address (
ca_address_sk bigint not null,
ca_address_id char(16) not null,
@@ -706,7 +704,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -714,7 +711,6 @@ curl --location-trusted \
-T "/path/to/data/item_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/item/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -722,7 +718,6 @@ curl --location-trusted \
-T "/path/to/data/date_dim_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/date_dim/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -730,15 +725,12 @@ curl --location-trusted \
-T "/path/to/data/store_sales.csv" \
http://127.0.0.1:8030/api/doc_tpcds/store_sales/_stream_load
-
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
-H "ca_address_sk, ca_address_id, ca_street_number, ca_street_name,
ca_street_type, ca_suite_number, ca_city, ca_county, ca_state, ca_zip,
ca_country, ca_gmt_offset, ca_location_type" \
-T "/path/to/data/customer_address_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/customer_address/_stream_load
-
-Path：
-/Users/${username}/Documents/file/docs_write/doc_ddl_dir.tar
```
+
+The data files ``item_1_10.dat``, ``date-dim_1_10.dat``, ``store_stales.csv``,
and ``customer-address_1_10.dat`` can be downloaded by clicking on the
[link](https://cdn.selectdb.com/static/doc_ddl_dir_d27a752a7b.tar).
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/multi-dimensional-analytics.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/multi-dimensional-analytics.md
index 9edd7ceb34f..020f82405c3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/multi-dimensional-analytics.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/multi-dimensional-analytics.md
@@ -547,6 +547,6 @@ HAVING grouping_id(YEAR(d_date), ca_state, i_category) = 0
);
```
-## 设计文档
+## 附录
-详细内容，可前往 Oracle 官网参考[ SQL for Aggregation in Data
Warehouses](https://docs.oracle.com/en/database/oracle/oracle-database/23/dwhsg/sql-aggregation-data-warehouses.html#GUID-C70DDA78-57D4-480A-AFDD-33EDFC1C15AE)
\ No newline at end of file
+建表语句和数据文件见[分析函数 (窗口函数）](window-function.md)附录。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/window-function.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/window-function.md
index 55b23a418ca..55f71093d8c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/window-function.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/window-function.md
@@ -639,7 +639,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS date_dim (
d_date_sk bigint not null,
d_date_id char(16) not null,
@@ -676,7 +675,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS customer_address (
ca_address_sk bigint not null,
ca_address_id char(16) not null,
@@ -698,7 +696,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -706,7 +703,6 @@ curl --location-trusted \
-T "/path/to/data/item_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/item/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -714,7 +710,6 @@ curl --location-trusted \
-T "/path/to/data/date_dim_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/date_dim/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -722,15 +717,12 @@ curl --location-trusted \
-T "/path/to/data/store_sales.csv" \
http://127.0.0.1:8030/api/doc_tpcds/store_sales/_stream_load
-
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
-H "ca_address_sk, ca_address_id, ca_street_number, ca_street_name,
ca_street_type, ca_suite_number, ca_city, ca_county, ca_state, ca_zip,
ca_country, ca_gmt_offset, ca_location_type" \
-T "/path/to/data/customer_address_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/customer_address/_stream_load
+```
-数据路径：
-/Users/${username}/Documents/file/docs_write/doc_ddl_dir.tar
-```
\ No newline at end of file
+数据文件``item_1_10.dat``，``date_dim_1_10.dat``，``store_sales.csv``，``customer_address_1_10.dat``可以[点击链接](https://cdn.selectdb.com/static/doc_ddl_dir_d27a752a7b.tar)下载。
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/multi-dimensional-analytics.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/multi-dimensional-analytics.md
index b2c60a15973..020f82405c3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/multi-dimensional-analytics.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/multi-dimensional-analytics.md
@@ -547,3 +547,6 @@ HAVING grouping_id(YEAR(d_date), ca_state, i_category) = 0
);
```
+## 附录
+
+建表语句和数据文件见[分析函数 (窗口函数）](window-function.md)附录。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/window-function.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/window-function.md
index cd1d3372539..b9efd2e8d5a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/window-function.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/window-function.md
@@ -638,7 +638,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS date_dim (
d_date_sk bigint not null,
d_date_id char(16) not null,
@@ -675,7 +674,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS customer_address (
ca_address_sk bigint not null,
ca_address_id char(16) not null,
@@ -697,7 +695,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -705,7 +702,6 @@ curl --location-trusted \
-T "/path/to/data/item_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/item/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -713,7 +709,6 @@ curl --location-trusted \
-T "/path/to/data/date_dim_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/date_dim/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -721,15 +716,12 @@ curl --location-trusted \
-T "/path/to/data/store_sales.csv" \
http://127.0.0.1:8030/api/doc_tpcds/store_sales/_stream_load
-
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
-H "ca_address_sk, ca_address_id, ca_street_number, ca_street_name,
ca_street_type, ca_suite_number, ca_city, ca_county, ca_state, ca_zip,
ca_country, ca_gmt_offset, ca_location_type" \
-T "/path/to/data/customer_address_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/customer_address/_stream_load
-
-数据路径：
-/Users/${username}/Documents/file/docs_write/doc_ddl_dir.tar
```
+
+数据文件``item_1_10.dat``，``date_dim_1_10.dat``，``store_sales.csv``，``customer_address_1_10.dat``可以[点击链接](https://cdn.selectdb.com/static/doc_ddl_dir_d27a752a7b.tar)下载。
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-data/multi-dimensional-analytics.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-data/multi-dimensional-analytics.md
index 9edd7ceb34f..72599ba2283 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-data/multi-dimensional-analytics.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-data/multi-dimensional-analytics.md
@@ -547,6 +547,6 @@ HAVING grouping_id(YEAR(d_date), ca_state, i_category) = 0
);
```
-## 设计文档
+## 附录
-详细内容，可前往 Oracle 官网参考[ SQL for Aggregation in Data
Warehouses](https://docs.oracle.com/en/database/oracle/oracle-database/23/dwhsg/sql-aggregation-data-warehouses.html#GUID-C70DDA78-57D4-480A-AFDD-33EDFC1C15AE)
\ No newline at end of file
+建表语句和数据文件见[分析函数 (窗口函数）](window-function.md)附录。
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-data/window-function.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-data/window-function.md
index 55b23a418ca..55f71093d8c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-data/window-function.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/query-data/window-function.md
@@ -639,7 +639,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS date_dim (
d_date_sk bigint not null,
d_date_id char(16) not null,
@@ -676,7 +675,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS customer_address (
ca_address_sk bigint not null,
ca_address_id char(16) not null,
@@ -698,7 +696,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -706,7 +703,6 @@ curl --location-trusted \
-T "/path/to/data/item_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/item/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -714,7 +710,6 @@ curl --location-trusted \
-T "/path/to/data/date_dim_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/date_dim/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -722,15 +717,12 @@ curl --location-trusted \
-T "/path/to/data/store_sales.csv" \
http://127.0.0.1:8030/api/doc_tpcds/store_sales/_stream_load
-
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
-H "ca_address_sk, ca_address_id, ca_street_number, ca_street_name,
ca_street_type, ca_suite_number, ca_city, ca_county, ca_state, ca_zip,
ca_country, ca_gmt_offset, ca_location_type" \
-T "/path/to/data/customer_address_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/customer_address/_stream_load
+```
-数据路径：
-/Users/${username}/Documents/file/docs_write/doc_ddl_dir.tar
-```
\ No newline at end of file
+数据文件``item_1_10.dat``，``date_dim_1_10.dat``，``store_sales.csv``，``customer_address_1_10.dat``可以[点击链接](https://cdn.selectdb.com/static/doc_ddl_dir_d27a752a7b.tar)下载。
\ No newline at end of file
diff --git
a/versioned_docs/version-2.1/query-data/multi-dimensional-analytics.md
b/versioned_docs/version-2.1/query-data/multi-dimensional-analytics.md
index f33f3276abd..f07ac8ff9d8 100644
--- a/versioned_docs/version-2.1/query-data/multi-dimensional-analytics.md
+++ b/versioned_docs/version-2.1/query-data/multi-dimensional-analytics.md
@@ -549,3 +549,6 @@ Using `CUBE` computes all possible aggregation levels
(eight in this case), but
);
```
+## APPENDIX
+
+For table creation statements and data files, see the [Window
Function](window-function.md) appendix.
diff --git a/versioned_docs/version-2.1/query-data/window-function.md
b/versioned_docs/version-2.1/query-data/window-function.md
index ef3ca961f16..89e6d63e160 100644
--- a/versioned_docs/version-2.1/query-data/window-function.md
+++ b/versioned_docs/version-2.1/query-data/window-function.md
@@ -646,7 +646,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS date_dim (
d_date_sk bigint not null,
d_date_id char(16) not null,
@@ -683,7 +682,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS customer_address (
ca_address_sk bigint not null,
ca_address_id char(16) not null,
@@ -705,7 +703,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -713,7 +710,6 @@ curl --location-trusted \
-T "/path/to/data/item_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/item/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -721,7 +717,6 @@ curl --location-trusted \
-T "/path/to/data/date_dim_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/date_dim/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -729,15 +724,12 @@ curl --location-trusted \
-T "/path/to/data/store_sales.csv" \
http://127.0.0.1:8030/api/doc_tpcds/store_sales/_stream_load
-
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
-H "ca_address_sk, ca_address_id, ca_street_number, ca_street_name,
ca_street_type, ca_suite_number, ca_city, ca_county, ca_state, ca_zip,
ca_country, ca_gmt_offset, ca_location_type" \
-T "/path/to/data/customer_address_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/customer_address/_stream_load
-
-Path：
-/Users/${username}/Documents/file/docs_write/doc_ddl_dir.tar
```
+
+The data files ``item_1_10.dat``, ``date-dim_1_10.dat``, ``store_stales.csv``,
and ``customer-address_1_10.dat`` can be downloaded by clicking on the
[link](https://cdn.selectdb.com/static/doc_ddl_dir_d27a752a7b.tar).
\ No newline at end of file
diff --git
a/versioned_docs/version-3.0/query-data/multi-dimensional-analytics.md
b/versioned_docs/version-3.0/query-data/multi-dimensional-analytics.md
index 88c20497ce3..021a49150b7 100644
--- a/versioned_docs/version-3.0/query-data/multi-dimensional-analytics.md
+++ b/versioned_docs/version-3.0/query-data/multi-dimensional-analytics.md
@@ -549,6 +549,6 @@ Using `CUBE` computes all possible aggregation levels
(eight in this case), but
);
```
-## Design Document
+## APPENDIX
-For detailed information, please refer to [SQL for Aggregation in Data
Warehouses](https://www.oracle.com/path-to-reference-documentation) on the
Oracle official website.
\ No newline at end of file
+For table creation statements and data files, see the [Window
Function](window-function.md) appendix.
\ No newline at end of file
diff --git a/versioned_docs/version-3.0/query-data/window-function.md
b/versioned_docs/version-3.0/query-data/window-function.md
index 9e806751728..d1b09006f26 100644
--- a/versioned_docs/version-3.0/query-data/window-function.md
+++ b/versioned_docs/version-3.0/query-data/window-function.md
@@ -647,7 +647,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS date_dim (
d_date_sk bigint not null,
d_date_id char(16) not null,
@@ -684,7 +683,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
CREATE TABLE IF NOT EXISTS customer_address (
ca_address_sk bigint not null,
ca_address_id char(16) not null,
@@ -706,7 +704,6 @@ PROPERTIES (
"replication_num" = "1"
);
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -714,7 +711,6 @@ curl --location-trusted \
-T "/path/to/data/item_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/item/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -722,7 +718,6 @@ curl --location-trusted \
-T "/path/to/data/date_dim_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/date_dim/_stream_load
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
@@ -730,15 +725,12 @@ curl --location-trusted \
-T "/path/to/data/store_sales.csv" \
http://127.0.0.1:8030/api/doc_tpcds/store_sales/_stream_load
-
-
curl --location-trusted \
-u "root:" \
-H "column_separator:|" \
-H "ca_address_sk, ca_address_id, ca_street_number, ca_street_name,
ca_street_type, ca_suite_number, ca_city, ca_county, ca_state, ca_zip,
ca_country, ca_gmt_offset, ca_location_type" \
-T "/path/to/data/customer_address_1_10.dat" \
http://127.0.0.1:8030/api/doc_tpcds/customer_address/_stream_load
-
-Path：
-/Users/${username}/Documents/file/docs_write/doc_ddl_dir.tar
```
+
+The data files ``item_1_10.dat``, ``date-dim_1_10.dat``, ``store_stales.csv``,
and ``customer-address_1_10.dat`` can be downloaded by clicking on the
[link](https://cdn.selectdb.com/static/doc_ddl_dir_d27a752a7b.tar).
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
