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 13096ed967f [doc](fix) add caution for `group_concat` and `lateral
view` (#646)
13096ed967f is described below
commit 13096ed967f89f1e285e221c3b89676dac264b17
Author: yagagagaga <zhangminkefromflyd...@gmail.com>
AuthorDate: Tue May 14 10:54:28 2024 +0800
[doc](fix) add caution for `group_concat` and `lateral view` (#646)
---
docs/query/query-data/lateral-view.md | 4 ++--
docs/sql-manual/sql-functions/aggregate-functions/group-concat.md | 5 ++++-
.../current/query/query-data/lateral-view.md | 4 ++--
.../sql-manual/sql-functions/aggregate-functions/group-concat.md | 5 ++++-
.../version-1.2/advanced/lateral-view.md | 4 ++--
.../sql-manual/sql-functions/aggregate-functions/group_concat.md | 5 ++++-
.../version-2.0/query/query-data/lateral-view.md | 4 ++--
.../sql-manual/sql-functions/aggregate-functions/group-concat.md | 5 ++++-
.../version-2.1/query/query-data/lateral-view.md | 4 ++--
.../sql-manual/sql-functions/aggregate-functions/group-concat.md | 5 ++++-
versioned_docs/version-1.2/advanced/lateral-view.md | 4 ++--
.../sql-manual/sql-functions/aggregate-functions/group_concat.md | 5 ++++-
versioned_docs/version-2.0/query/query-data/lateral-view.md | 4 ++--
.../sql-manual/sql-functions/aggregate-functions/group-concat.md | 5 ++++-
versioned_docs/version-2.1/query/query-data/lateral-view.md | 4 ++--
.../sql-manual/sql-functions/aggregate-functions/group-concat.md | 5 ++++-
16 files changed, 48 insertions(+), 24 deletions(-)
diff --git a/docs/query/query-data/lateral-view.md
b/docs/query/query-data/lateral-view.md
index b32283f0261..15929a94349 100644
--- a/docs/query/query-data/lateral-view.md
+++ b/docs/query/query-data/lateral-view.md
@@ -31,7 +31,7 @@ Used in conjunction with generator functions such as
`EXPLODE`, will generate a
## Grammar
```sql
-LATERAL VIEW generator_function ( expression [, ...] ) [ table_identifier ]
AS column_identifier [, ...]
+LATERAL VIEW generator_function ( expression [, ...] ) table_identifier AS
column_identifier [, ...]
```
## Parameters
@@ -42,7 +42,7 @@ LATERAL VIEW generator_function ( expression [, ...] ) [
table_identifier ] AS
- table_identifier
- Alias for `generator_function`, which is optional.
+ Alias for `generator_function`.
- column_identifier
diff --git a/docs/sql-manual/sql-functions/aggregate-functions/group-concat.md
b/docs/sql-manual/sql-functions/aggregate-functions/group-concat.md
index 85b825c985f..cc870e11a43 100644
--- a/docs/sql-manual/sql-functions/aggregate-functions/group-concat.md
+++ b/docs/sql-manual/sql-functions/aggregate-functions/group-concat.md
@@ -33,9 +33,12 @@ under the License.
This function is an aggregation function similar to sum (), and group_concat
links multiple rows of results in the result set to a string. The second
parameter, sep, is a connection symbol between strings, which can be omitted.
This function usually needs to be used with group by statements.
-<version since="1.2"></version>
Support Order By for sorting multi-row results, sorting and aggregation
columns can be different.
+:::caution
+`group_concat` don't support using `distinct` with `order by` together.
+:::
+
### example
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query/query-data/lateral-view.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query/query-data/lateral-view.md
index eb7260c64bb..a17709d6946 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query/query-data/lateral-view.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query/query-data/lateral-view.md
@@ -31,7 +31,7 @@ under the License.
## 语法
```sql
-LATERAL VIEW generator_function ( expression [, ...] ) [ table_identifier ] AS
column_identifier [, ...]
+LATERAL VIEW generator_function ( expression [, ...] ) table_identifier AS
column_identifier [, ...]
```
## 参数
@@ -42,7 +42,7 @@ LATERAL VIEW generator_function ( expression [, ...] ) [
table_identifier ] AS c
- table_identifier
- `generator_function` 的别名，它是可选项。
+ `generator_function` 的别名。
- column_identifier
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/group-concat.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/group-concat.md
index 6e62f7c191e..4a578f38dc9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/group-concat.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/group-concat.md
@@ -33,9 +33,12 @@ under the License.
该函数是类似于 sum() 的聚合函数，group_concat 将结果集中的多行结果连接成一个字符串。第二个参数 sep
为字符串之间的连接符号，该参数可以省略。该函数通常需要和 group by 语句一起使用。
-<version since="1.2"></version>
支持Order By进行多行结果的排序，排序和聚合列可不同。
+:::caution
+`group_concat`暂不支持`distinct`和`order by`一起用。
+:::
+
### example
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/lateral-view.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/lateral-view.md
index 298d7ae7bf3..be59d57b363 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/lateral-view.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/lateral-view.md
@@ -31,7 +31,7 @@ under the License.
## 语法
```sql
-LATERAL VIEW generator_function ( expression [, ...] ) [ table_identifier ] AS
column_identifier [, ...]
+LATERAL VIEW generator_function ( expression [, ...] ) table_identifier AS
column_identifier [, ...]
```
## 参数
@@ -42,7 +42,7 @@ LATERAL VIEW generator_function ( expression [, ...] ) [
table_identifier ] AS c
- table_identifier
- `generator_function` 的别名，它是可选项。
+ `generator_function` 的别名。
- column_identifier
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/aggregate-functions/group_concat.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/aggregate-functions/group_concat.md
index f028636040e..065be63c392 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/aggregate-functions/group_concat.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/aggregate-functions/group_concat.md
@@ -33,9 +33,12 @@ under the License.
该函数是类似于 sum() 的聚合函数，group_concat 将结果集中的多行结果连接成一个字符串。第二个参数 sep
为字符串之间的连接符号，该参数可以省略。该函数通常需要和 group by 语句一起使用。
-<version since="1.2"></version>
支持Order By进行多行结果的排序，排序和聚合列可不同。
+:::caution
+`group_concat`暂不支持`distinct`和`order by`一起用。
+:::
+
### example
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/lateral-view.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/lateral-view.md
index eb7260c64bb..a17709d6946 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/lateral-view.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/lateral-view.md
@@ -31,7 +31,7 @@ under the License.
## 语法
```sql
-LATERAL VIEW generator_function ( expression [, ...] ) [ table_identifier ] AS
column_identifier [, ...]
+LATERAL VIEW generator_function ( expression [, ...] ) table_identifier AS
column_identifier [, ...]
```
## 参数
@@ -42,7 +42,7 @@ LATERAL VIEW generator_function ( expression [, ...] ) [
table_identifier ] AS c
- table_identifier
- `generator_function` 的别名，它是可选项。
+ `generator_function` 的别名。
- column_identifier
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/aggregate-functions/group-concat.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/aggregate-functions/group-concat.md
index 6e62f7c191e..4a578f38dc9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/aggregate-functions/group-concat.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/aggregate-functions/group-concat.md
@@ -33,9 +33,12 @@ under the License.
该函数是类似于 sum() 的聚合函数，group_concat 将结果集中的多行结果连接成一个字符串。第二个参数 sep
为字符串之间的连接符号，该参数可以省略。该函数通常需要和 group by 语句一起使用。
-<version since="1.2"></version>
支持Order By进行多行结果的排序，排序和聚合列可不同。
+:::caution
+`group_concat`暂不支持`distinct`和`order by`一起用。
+:::
+
### example
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query/query-data/lateral-view.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query/query-data/lateral-view.md
index eb7260c64bb..a17709d6946 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query/query-data/lateral-view.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query/query-data/lateral-view.md
@@ -31,7 +31,7 @@ under the License.
## 语法
```sql
-LATERAL VIEW generator_function ( expression [, ...] ) [ table_identifier ] AS
column_identifier [, ...]
+LATERAL VIEW generator_function ( expression [, ...] ) table_identifier AS
column_identifier [, ...]
```
## 参数
@@ -42,7 +42,7 @@ LATERAL VIEW generator_function ( expression [, ...] ) [
table_identifier ] AS c
- table_identifier
- `generator_function` 的别名，它是可选项。
+ `generator_function` 的别名。
- column_identifier
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-concat.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-concat.md
index 6e62f7c191e..4a578f38dc9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-concat.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-concat.md
@@ -33,9 +33,12 @@ under the License.
该函数是类似于 sum() 的聚合函数，group_concat 将结果集中的多行结果连接成一个字符串。第二个参数 sep
为字符串之间的连接符号，该参数可以省略。该函数通常需要和 group by 语句一起使用。
-<version since="1.2"></version>
支持Order By进行多行结果的排序，排序和聚合列可不同。
+:::caution
+`group_concat`暂不支持`distinct`和`order by`一起用。
+:::
+
### example
```
diff --git a/versioned_docs/version-1.2/advanced/lateral-view.md
b/versioned_docs/version-1.2/advanced/lateral-view.md
index c6921f36635..75633a4384d 100644
--- a/versioned_docs/version-1.2/advanced/lateral-view.md
+++ b/versioned_docs/version-1.2/advanced/lateral-view.md
@@ -31,7 +31,7 @@ Used in conjunction with generator functions such as
`EXPLODE`, will generate a
## Grammar
```sql
-LATERAL VIEW generator_function ( expression [, ...] ) [ table_identifier ]
AS column_identifier [, ...]
+LATERAL VIEW generator_function ( expression [, ...] ) table_identifier AS
column_identifier [, ...]
```
## Parameters
@@ -42,7 +42,7 @@ LATERAL VIEW generator_function ( expression [, ...] ) [
table_identifier ] AS
- table_identifier
- Alias for `generator_function`, which is optional.
+ Alias for `generator_function`.
- column_identifier
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/aggregate-functions/group_concat.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/aggregate-functions/group_concat.md
index b938ad8ed18..347cae7fa67 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/aggregate-functions/group_concat.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/aggregate-functions/group_concat.md
@@ -33,9 +33,12 @@ under the License.
This function is an aggregation function similar to sum (), and group_concat
links multiple rows of results in the result set to a string. The second
parameter, sep, is a connection symbol between strings, which can be omitted.
This function usually needs to be used with group by statements.
-<version since="1.2"></version>
Support Order By for sorting multi-row results, sorting and aggregation
columns can be different.
+:::caution
+`group_concat` don't support using `distinct` with `order by` together.
+:::
+
### example
```
diff --git a/versioned_docs/version-2.0/query/query-data/lateral-view.md
b/versioned_docs/version-2.0/query/query-data/lateral-view.md
index b32283f0261..15929a94349 100644
--- a/versioned_docs/version-2.0/query/query-data/lateral-view.md
+++ b/versioned_docs/version-2.0/query/query-data/lateral-view.md
@@ -31,7 +31,7 @@ Used in conjunction with generator functions such as
`EXPLODE`, will generate a
## Grammar
```sql
-LATERAL VIEW generator_function ( expression [, ...] ) [ table_identifier ]
AS column_identifier [, ...]
+LATERAL VIEW generator_function ( expression [, ...] ) table_identifier AS
column_identifier [, ...]
```
## Parameters
@@ -42,7 +42,7 @@ LATERAL VIEW generator_function ( expression [, ...] ) [
table_identifier ] AS
- table_identifier
- Alias for `generator_function`, which is optional.
+ Alias for `generator_function`.
- column_identifier
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-functions/aggregate-functions/group-concat.md
b/versioned_docs/version-2.0/sql-manual/sql-functions/aggregate-functions/group-concat.md
index 85b825c985f..cc870e11a43 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-functions/aggregate-functions/group-concat.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-functions/aggregate-functions/group-concat.md
@@ -33,9 +33,12 @@ under the License.
This function is an aggregation function similar to sum (), and group_concat
links multiple rows of results in the result set to a string. The second
parameter, sep, is a connection symbol between strings, which can be omitted.
This function usually needs to be used with group by statements.
-<version since="1.2"></version>
Support Order By for sorting multi-row results, sorting and aggregation
columns can be different.
+:::caution
+`group_concat` don't support using `distinct` with `order by` together.
+:::
+
### example
```
diff --git a/versioned_docs/version-2.1/query/query-data/lateral-view.md
b/versioned_docs/version-2.1/query/query-data/lateral-view.md
index b32283f0261..15929a94349 100644
--- a/versioned_docs/version-2.1/query/query-data/lateral-view.md
+++ b/versioned_docs/version-2.1/query/query-data/lateral-view.md
@@ -31,7 +31,7 @@ Used in conjunction with generator functions such as
`EXPLODE`, will generate a
## Grammar
```sql
-LATERAL VIEW generator_function ( expression [, ...] ) [ table_identifier ]
AS column_identifier [, ...]
+LATERAL VIEW generator_function ( expression [, ...] ) table_identifier AS
column_identifier [, ...]
```
## Parameters
@@ -42,7 +42,7 @@ LATERAL VIEW generator_function ( expression [, ...] ) [
table_identifier ] AS
- table_identifier
- Alias for `generator_function`, which is optional.
+ Alias for `generator_function`.
- column_identifier
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-concat.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-concat.md
index 85b825c985f..cc870e11a43 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-concat.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-concat.md
@@ -33,9 +33,12 @@ under the License.
This function is an aggregation function similar to sum (), and group_concat
links multiple rows of results in the result set to a string. The second
parameter, sep, is a connection symbol between strings, which can be omitted.
This function usually needs to be used with group by statements.
-<version since="1.2"></version>
Support Order By for sorting multi-row results, sorting and aggregation
columns can be different.
+:::caution
+`group_concat` don't support using `distinct` with `order by` together.
+:::
+
### example
```
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
