This is an automated email from the ASF dual-hosted git repository.
morningman 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 d7ed522e3e [Doc](function) Support hll_from_base64, hll_to_base64,
group_array_intersect functions (#560)
d7ed522e3e is described below
commit d7ed522e3e479f599f1d41e73a12af6a97e657cf
Author: Chester <[email protected]>
AuthorDate: Wed Apr 17 23:06:03 2024 +0800
[Doc](function) Support hll_from_base64, hll_to_base64,
group_array_intersect functions (#560)
- hll_from_base64, hll_to_base64:
master pr: https://github.com/apache/doris/pull/32089
- group_array_intersect:
master pr: https://github.com/apache/doris/pull/33265
---
.../aggregate-functions/group-array-intersect.md | 57 ++++++++++++++++
.../sql-functions/hll-functions/hll-from-base64.md | 71 +++++++++++++++++++
.../sql-functions/hll-functions/hll-to-base64.md | 79 ++++++++++++++++++++++
.../aggregate-functions/group-array-intersect.md | 57 ++++++++++++++++
.../sql-functions/hll-functions/hll-from-base64.md | 71 +++++++++++++++++++
.../sql-functions/hll-functions/hll-to-base64.md | 79 ++++++++++++++++++++++
.../aggregate-functions/group-array-intersect.md | 57 ++++++++++++++++
.../sql-functions/hll-functions/hll-from-base64.md | 71 +++++++++++++++++++
.../sql-functions/hll-functions/hll-to-base64.md | 79 ++++++++++++++++++++++
sidebars.json | 5 +-
.../aggregate-functions/group-array-intersect.md | 57 ++++++++++++++++
.../sql-functions/hll-functions/hll-from-base64.md | 71 +++++++++++++++++++
.../sql-functions/hll-functions/hll-to-base64.md | 79 ++++++++++++++++++++++
versioned_sidebars/version-2.1-sidebars.json | 5 +-
14 files changed, 836 insertions(+), 2 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
b/docs/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
new file mode 100644
index 0000000000..fe19bbefb2
--- /dev/null
+++ b/docs/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
@@ -0,0 +1,57 @@
+---
+{
+ "title": "GROUP_ARRAY_INTERSECT",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## group_array_intersect
+### description
+#### Syntax
+
+`expr GROUP_ARRAY_INTERSECT(expr)`
+
+calculate the intersect element from all arrays given, return a new array
+
+### example
+
+```
+mysql> select c_array_string from group_array_intersect_test where id in (18,
20);
++--------------------------------+
+| c_array_string |
++--------------------------------+
+| ["a", "b", "c", "d", "e", "f"] |
+| ["a", null] |
++--------------------------------+
+2 rows in set (0.02 sec)
+
+mysql> select group_array_intersect(c_array_string) from
group_array_intersect_test where id in (18, 20);
++---------------------------------------+
+| group_array_intersect(c_array_string) |
++---------------------------------------+
+| ["a"] |
++---------------------------------------+
+1 row in set (0.03 sec)
+```
+
+### keywords
+GROUP_ARRAY_INTERSECT, ARRAY
diff --git a/docs/sql-manual/sql-functions/hll-functions/hll-from-base64.md
b/docs/sql-manual/sql-functions/hll-functions/hll-from-base64.md
new file mode 100644
index 0000000000..c0efeb4644
--- /dev/null
+++ b/docs/sql-manual/sql-functions/hll-functions/hll-from-base64.md
@@ -0,0 +1,71 @@
+---
+{
+ "title": "HLL_FROM_BASE64",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## hll_from_base64
+
+### description
+#### Syntax
+
+`HLL HLL_FROM_BASE64(VARCHAR input)`
+
+Convert a base64 string(result of function `hll_to_base64`) into a hll. If
input string is invalid, return NULL.
+
+### example
+
+```
+mysql> select hll_union_agg(hll_from_base64(hll_to_base64(pv))),
hll_union_agg(pv) from test_hll;
++---------------------------------------------------+-------------------+
+| hll_union_agg(hll_from_base64(hll_to_base64(pv))) | hll_union_agg(pv) |
++---------------------------------------------------+-------------------+
+| 3 | 3 |
++---------------------------------------------------+-------------------+
+1 row in set (0.04 sec)
+
+mysql> select
hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc'))));
++------------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc')))) |
++------------------------------------------------------------------+
+| 1 |
++------------------------------------------------------------------+
+1 row in set (0.04 sec)
+
+mysql> select hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(''))));
++---------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('')))) |
++---------------------------------------------------------------+
+| 1 |
++---------------------------------------------------------------+
+1 row in set (0.02 sec)
+
+mysql> select hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(NULL))));
++-----------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(NULL)))) |
++-----------------------------------------------------------------+
+| 0 |
++-----------------------------------------------------------------+
+1 row in set (0.02 sec)
+```
+
+### keywords
+HLL_FROM_BASE64, HLL
diff --git a/docs/sql-manual/sql-functions/hll-functions/hll-to-base64.md
b/docs/sql-manual/sql-functions/hll-functions/hll-to-base64.md
new file mode 100644
index 0000000000..6da0051d84
--- /dev/null
+++ b/docs/sql-manual/sql-functions/hll-functions/hll-to-base64.md
@@ -0,0 +1,79 @@
+---
+{
+ "title": "HLL_TO_BASE64",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## hll_to_base64
+
+### description
+#### Syntax
+
+`VARCHAR HLL_TO_BASE64(HLL input)`
+
+Convert an input hll to a base64 string. If input is NULL, return NULL.
+
+### example
+
+```
+mysql> select hll_to_base64(NULL);
++---------------------+
+| hll_to_base64(NULL) |
++---------------------+
+| NULL |
++---------------------+
+1 row in set (0.00 sec)
+
+mysql> select hll_to_base64(hll_empty());
++----------------------------+
+| hll_to_base64(hll_empty()) |
++----------------------------+
+| AA== |
++----------------------------+
+1 row in set (0.02 sec)
+
+mysql> select hll_to_base64(hll_hash('abc'));
++--------------------------------+
+| hll_to_base64(hll_hash('abc')) |
++--------------------------------+
+| AQEC5XSzrpDsdw== |
++--------------------------------+
+1 row in set (0.03 sec)
+
+mysql> select hll_union_agg(hll_from_base64(hll_to_base64(pv))),
hll_union_agg(pv) from test_hll;
++---------------------------------------------------+-------------------+
+| hll_union_agg(hll_from_base64(hll_to_base64(pv))) | hll_union_agg(pv) |
++---------------------------------------------------+-------------------+
+| 3 | 3 |
++---------------------------------------------------+-------------------+
+1 row in set (0.04 sec)
+
+mysql> select
hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc'))));
++------------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc')))) |
++------------------------------------------------------------------+
+| 1 |
++------------------------------------------------------------------+
+1 row in set (0.04 sec)
+```
+
+### keywords
+HLL_TO_BASE64, HLL
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
new file mode 100644
index 0000000000..d7375f8bec
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
@@ -0,0 +1,57 @@
+---
+{
+ "title": "GROUP_ARRAY_INTERSECT",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## group_array_intersect
+### description
+#### Syntax
+
+`expr GROUP_ARRAY_INTERSECT(expr)`
+
+求出所有行中输入数组中的交集元素，返回一个新的数组
+
+### example
+
+```
+mysql> select c_array_string from group_array_intersect_test where id in (18,
20);
++--------------------------------+
+| c_array_string |
++--------------------------------+
+| ["a", "b", "c", "d", "e", "f"] |
+| ["a", null] |
++--------------------------------+
+2 rows in set (0.02 sec)
+
+mysql> select group_array_intersect(c_array_string) from
group_array_intersect_test where id in (18, 20);
++---------------------------------------+
+| group_array_intersect(c_array_string) |
++---------------------------------------+
+| ["a"] |
++---------------------------------------+
+1 row in set (0.03 sec)
+```
+
+### keywords
+GROUP_ARRAY_INTERSECT, ARRAY
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/hll-functions/hll-from-base64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/hll-functions/hll-from-base64.md
new file mode 100644
index 0000000000..be5b46ec81
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/hll-functions/hll-from-base64.md
@@ -0,0 +1,71 @@
+---
+{
+ "title": "HLL_FROM_BASE64",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## hll_from_base64
+
+### description
+#### Syntax
+
+`HLL HLL_FROM_BASE64(VARCHAR input)`
+
+将一个base64字符串(`hll_to_base64`函数的结果)转化为一个HLL。当输入字符串不合法时，返回NULL。
+
+### example
+
+```
+mysql> select hll_union_agg(hll_from_base64(hll_to_base64(pv))),
hll_union_agg(pv) from test_hll;
++---------------------------------------------------+-------------------+
+| hll_union_agg(hll_from_base64(hll_to_base64(pv))) | hll_union_agg(pv) |
++---------------------------------------------------+-------------------+
+| 3 | 3 |
++---------------------------------------------------+-------------------+
+1 row in set (0.04 sec)
+
+mysql> select
hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc'))));
++------------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc')))) |
++------------------------------------------------------------------+
+| 1 |
++------------------------------------------------------------------+
+1 row in set (0.04 sec)
+
+mysql> select hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(''))));
++---------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('')))) |
++---------------------------------------------------------------+
+| 1 |
++---------------------------------------------------------------+
+1 row in set (0.02 sec)
+
+mysql> select hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(NULL))));
++-----------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(NULL)))) |
++-----------------------------------------------------------------+
+| 0 |
++-----------------------------------------------------------------+
+1 row in set (0.02 sec)
+```
+
+### keywords
+HLL_FROM_BASE64,HLL
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/hll-functions/hll-to-base64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/hll-functions/hll-to-base64.md
new file mode 100644
index 0000000000..ff9f3ee336
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/hll-functions/hll-to-base64.md
@@ -0,0 +1,79 @@
+---
+{
+ "title": "HLL_TO_BASE64",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## hll_to_base64
+
+### description
+#### Syntax
+
+`VARCHAR HLL_TO_BASE64(HLL input)`
+
+将一个hll转化成一个base64字符串。输入是NULL的话返回NULL。
+
+### example
+
+```
+mysql> select hll_to_base64(NULL);
++---------------------+
+| hll_to_base64(NULL) |
++---------------------+
+| NULL |
++---------------------+
+1 row in set (0.00 sec)
+
+mysql> select hll_to_base64(hll_empty());
++----------------------------+
+| hll_to_base64(hll_empty()) |
++----------------------------+
+| AA== |
++----------------------------+
+1 row in set (0.02 sec)
+
+mysql> select hll_to_base64(hll_hash('abc'));
++--------------------------------+
+| hll_to_base64(hll_hash('abc')) |
++--------------------------------+
+| AQEC5XSzrpDsdw== |
++--------------------------------+
+1 row in set (0.03 sec)
+
+mysql> select hll_union_agg(hll_from_base64(hll_to_base64(pv))),
hll_union_agg(pv) from test_hll;
++---------------------------------------------------+-------------------+
+| hll_union_agg(hll_from_base64(hll_to_base64(pv))) | hll_union_agg(pv) |
++---------------------------------------------------+-------------------+
+| 3 | 3 |
++---------------------------------------------------+-------------------+
+1 row in set (0.04 sec)
+
+mysql> select
hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc'))));
++------------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc')))) |
++------------------------------------------------------------------+
+| 1 |
++------------------------------------------------------------------+
+1 row in set (0.04 sec)
+```
+
+### keywords
+HLL_TO_BASE64, HLL
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
new file mode 100644
index 0000000000..d7375f8bec
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
@@ -0,0 +1,57 @@
+---
+{
+ "title": "GROUP_ARRAY_INTERSECT",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## group_array_intersect
+### description
+#### Syntax
+
+`expr GROUP_ARRAY_INTERSECT(expr)`
+
+求出所有行中输入数组中的交集元素，返回一个新的数组
+
+### example
+
+```
+mysql> select c_array_string from group_array_intersect_test where id in (18,
20);
++--------------------------------+
+| c_array_string |
++--------------------------------+
+| ["a", "b", "c", "d", "e", "f"] |
+| ["a", null] |
++--------------------------------+
+2 rows in set (0.02 sec)
+
+mysql> select group_array_intersect(c_array_string) from
group_array_intersect_test where id in (18, 20);
++---------------------------------------+
+| group_array_intersect(c_array_string) |
++---------------------------------------+
+| ["a"] |
++---------------------------------------+
+1 row in set (0.03 sec)
+```
+
+### keywords
+GROUP_ARRAY_INTERSECT, ARRAY
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-from-base64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-from-base64.md
new file mode 100644
index 0000000000..be5b46ec81
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-from-base64.md
@@ -0,0 +1,71 @@
+---
+{
+ "title": "HLL_FROM_BASE64",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## hll_from_base64
+
+### description
+#### Syntax
+
+`HLL HLL_FROM_BASE64(VARCHAR input)`
+
+将一个base64字符串(`hll_to_base64`函数的结果)转化为一个HLL。当输入字符串不合法时，返回NULL。
+
+### example
+
+```
+mysql> select hll_union_agg(hll_from_base64(hll_to_base64(pv))),
hll_union_agg(pv) from test_hll;
++---------------------------------------------------+-------------------+
+| hll_union_agg(hll_from_base64(hll_to_base64(pv))) | hll_union_agg(pv) |
++---------------------------------------------------+-------------------+
+| 3 | 3 |
++---------------------------------------------------+-------------------+
+1 row in set (0.04 sec)
+
+mysql> select
hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc'))));
++------------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc')))) |
++------------------------------------------------------------------+
+| 1 |
++------------------------------------------------------------------+
+1 row in set (0.04 sec)
+
+mysql> select hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(''))));
++---------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('')))) |
++---------------------------------------------------------------+
+| 1 |
++---------------------------------------------------------------+
+1 row in set (0.02 sec)
+
+mysql> select hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(NULL))));
++-----------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(NULL)))) |
++-----------------------------------------------------------------+
+| 0 |
++-----------------------------------------------------------------+
+1 row in set (0.02 sec)
+```
+
+### keywords
+HLL_FROM_BASE64,HLL
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-to-base64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-to-base64.md
new file mode 100644
index 0000000000..ff9f3ee336
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-to-base64.md
@@ -0,0 +1,79 @@
+---
+{
+ "title": "HLL_TO_BASE64",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## hll_to_base64
+
+### description
+#### Syntax
+
+`VARCHAR HLL_TO_BASE64(HLL input)`
+
+将一个hll转化成一个base64字符串。输入是NULL的话返回NULL。
+
+### example
+
+```
+mysql> select hll_to_base64(NULL);
++---------------------+
+| hll_to_base64(NULL) |
++---------------------+
+| NULL |
++---------------------+
+1 row in set (0.00 sec)
+
+mysql> select hll_to_base64(hll_empty());
++----------------------------+
+| hll_to_base64(hll_empty()) |
++----------------------------+
+| AA== |
++----------------------------+
+1 row in set (0.02 sec)
+
+mysql> select hll_to_base64(hll_hash('abc'));
++--------------------------------+
+| hll_to_base64(hll_hash('abc')) |
++--------------------------------+
+| AQEC5XSzrpDsdw== |
++--------------------------------+
+1 row in set (0.03 sec)
+
+mysql> select hll_union_agg(hll_from_base64(hll_to_base64(pv))),
hll_union_agg(pv) from test_hll;
++---------------------------------------------------+-------------------+
+| hll_union_agg(hll_from_base64(hll_to_base64(pv))) | hll_union_agg(pv) |
++---------------------------------------------------+-------------------+
+| 3 | 3 |
++---------------------------------------------------+-------------------+
+1 row in set (0.04 sec)
+
+mysql> select
hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc'))));
++------------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc')))) |
++------------------------------------------------------------------+
+| 1 |
++------------------------------------------------------------------+
+1 row in set (0.04 sec)
+```
+
+### keywords
+HLL_TO_BASE64, HLL
diff --git a/sidebars.json b/sidebars.json
index eaf64d5cb9..0609bcce92 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -629,6 +629,7 @@
"sql-manual/sql-functions/aggregate-functions/percentile-array",
"sql-manual/sql-functions/aggregate-functions/percentile-approx",
"sql-manual/sql-functions/aggregate-functions/histogram",
+
"sql-manual/sql-functions/aggregate-functions/group-array-intersect",
"sql-manual/sql-functions/aggregate-functions/group-bitmap-xor",
"sql-manual/sql-functions/aggregate-functions/group-bit-and",
"sql-manual/sql-functions/aggregate-functions/group-bit-or",
@@ -758,7 +759,9 @@
"items": [
"sql-manual/sql-functions/hll-functions/hll-cardinality",
"sql-manual/sql-functions/hll-functions/hll-empty",
-
"sql-manual/sql-functions/hll-functions/hll-hash"
+
"sql-manual/sql-functions/hll-functions/hll-from-base64",
+
"sql-manual/sql-functions/hll-functions/hll-hash",
+
"sql-manual/sql-functions/hll-functions/hll-to-base64"
]
},
{
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
new file mode 100644
index 0000000000..fe19bbefb2
--- /dev/null
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
@@ -0,0 +1,57 @@
+---
+{
+ "title": "GROUP_ARRAY_INTERSECT",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## group_array_intersect
+### description
+#### Syntax
+
+`expr GROUP_ARRAY_INTERSECT(expr)`
+
+calculate the intersect element from all arrays given, return a new array
+
+### example
+
+```
+mysql> select c_array_string from group_array_intersect_test where id in (18,
20);
++--------------------------------+
+| c_array_string |
++--------------------------------+
+| ["a", "b", "c", "d", "e", "f"] |
+| ["a", null] |
++--------------------------------+
+2 rows in set (0.02 sec)
+
+mysql> select group_array_intersect(c_array_string) from
group_array_intersect_test where id in (18, 20);
++---------------------------------------+
+| group_array_intersect(c_array_string) |
++---------------------------------------+
+| ["a"] |
++---------------------------------------+
+1 row in set (0.03 sec)
+```
+
+### keywords
+GROUP_ARRAY_INTERSECT, ARRAY
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-from-base64.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-from-base64.md
new file mode 100644
index 0000000000..c0efeb4644
--- /dev/null
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-from-base64.md
@@ -0,0 +1,71 @@
+---
+{
+ "title": "HLL_FROM_BASE64",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## hll_from_base64
+
+### description
+#### Syntax
+
+`HLL HLL_FROM_BASE64(VARCHAR input)`
+
+Convert a base64 string(result of function `hll_to_base64`) into a hll. If
input string is invalid, return NULL.
+
+### example
+
+```
+mysql> select hll_union_agg(hll_from_base64(hll_to_base64(pv))),
hll_union_agg(pv) from test_hll;
++---------------------------------------------------+-------------------+
+| hll_union_agg(hll_from_base64(hll_to_base64(pv))) | hll_union_agg(pv) |
++---------------------------------------------------+-------------------+
+| 3 | 3 |
++---------------------------------------------------+-------------------+
+1 row in set (0.04 sec)
+
+mysql> select
hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc'))));
++------------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc')))) |
++------------------------------------------------------------------+
+| 1 |
++------------------------------------------------------------------+
+1 row in set (0.04 sec)
+
+mysql> select hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(''))));
++---------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('')))) |
++---------------------------------------------------------------+
+| 1 |
++---------------------------------------------------------------+
+1 row in set (0.02 sec)
+
+mysql> select hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(NULL))));
++-----------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash(NULL)))) |
++-----------------------------------------------------------------+
+| 0 |
++-----------------------------------------------------------------+
+1 row in set (0.02 sec)
+```
+
+### keywords
+HLL_FROM_BASE64, HLL
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-to-base64.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-to-base64.md
new file mode 100644
index 0000000000..6da0051d84
--- /dev/null
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/hll-functions/hll-to-base64.md
@@ -0,0 +1,79 @@
+---
+{
+ "title": "HLL_TO_BASE64",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+ http://www.apache.org/licenses/LICENSE-2.0
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## hll_to_base64
+
+### description
+#### Syntax
+
+`VARCHAR HLL_TO_BASE64(HLL input)`
+
+Convert an input hll to a base64 string. If input is NULL, return NULL.
+
+### example
+
+```
+mysql> select hll_to_base64(NULL);
++---------------------+
+| hll_to_base64(NULL) |
++---------------------+
+| NULL |
++---------------------+
+1 row in set (0.00 sec)
+
+mysql> select hll_to_base64(hll_empty());
++----------------------------+
+| hll_to_base64(hll_empty()) |
++----------------------------+
+| AA== |
++----------------------------+
+1 row in set (0.02 sec)
+
+mysql> select hll_to_base64(hll_hash('abc'));
++--------------------------------+
+| hll_to_base64(hll_hash('abc')) |
++--------------------------------+
+| AQEC5XSzrpDsdw== |
++--------------------------------+
+1 row in set (0.03 sec)
+
+mysql> select hll_union_agg(hll_from_base64(hll_to_base64(pv))),
hll_union_agg(pv) from test_hll;
++---------------------------------------------------+-------------------+
+| hll_union_agg(hll_from_base64(hll_to_base64(pv))) | hll_union_agg(pv) |
++---------------------------------------------------+-------------------+
+| 3 | 3 |
++---------------------------------------------------+-------------------+
+1 row in set (0.04 sec)
+
+mysql> select
hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc'))));
++------------------------------------------------------------------+
+| hll_cardinality(hll_from_base64(hll_to_base64(hll_hash('abc')))) |
++------------------------------------------------------------------+
+| 1 |
++------------------------------------------------------------------+
+1 row in set (0.04 sec)
+```
+
+### keywords
+HLL_TO_BASE64, HLL
diff --git a/versioned_sidebars/version-2.1-sidebars.json
b/versioned_sidebars/version-2.1-sidebars.json
index e47a401c73..e785c56965 100644
--- a/versioned_sidebars/version-2.1-sidebars.json
+++ b/versioned_sidebars/version-2.1-sidebars.json
@@ -623,6 +623,7 @@
"sql-manual/sql-functions/aggregate-functions/percentile-array",
"sql-manual/sql-functions/aggregate-functions/percentile-approx",
"sql-manual/sql-functions/aggregate-functions/histogram",
+
"sql-manual/sql-functions/aggregate-functions/group-array-intersect",
"sql-manual/sql-functions/aggregate-functions/group-bitmap-xor",
"sql-manual/sql-functions/aggregate-functions/group-bit-and",
"sql-manual/sql-functions/aggregate-functions/group-bit-or",
@@ -752,7 +753,9 @@
"items": [
"sql-manual/sql-functions/hll-functions/hll-cardinality",
"sql-manual/sql-functions/hll-functions/hll-empty",
-
"sql-manual/sql-functions/hll-functions/hll-hash"
+
"sql-manual/sql-functions/hll-functions/hll-from-base64",
+
"sql-manual/sql-functions/hll-functions/hll-hash",
+
"sql-manual/sql-functions/hll-functions/hll-to-base64"
]
},
{
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
