This is an automated email from the ASF dual-hosted git repository.
jiafengzheng 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 deb92781dec [typo](doc)add orthogonal bitmap function Note. (#118)
deb92781dec is described below
commit deb92781decb4d3deb791cf2d5af7c622f4eeb98
Author: Liqf <109049295+lemonlit...@users.noreply.github.com>
AuthorDate: Fri Sep 30 15:23:37 2022 +0800
[typo](doc)add orthogonal bitmap function Note. (#118)
---
docs/advanced/orthogonal-bitmap-manual.md | 2 +
.../sql-functions/math-functions/cbrt.md | 57 ++++++++++++++++++++++
.../current/advanced/orthogonal-bitmap-manual.md | 2 +
.../sql-functions/math-functions/cbrt.md | 57 ++++++++++++++++++++++
4 files changed, 118 insertions(+)
diff --git a/docs/advanced/orthogonal-bitmap-manual.md
b/docs/advanced/orthogonal-bitmap-manual.md
index d08307e7490..42750ffa00e 100644
--- a/docs/advanced/orthogonal-bitmap-manual.md
+++ b/docs/advanced/orthogonal-bitmap-manual.md
@@ -87,6 +87,8 @@ Note: the first column represents the user tags, which have
been converted from
When loading data, vertically cut the bitmap value range of the user. For
example, the hid value of the user ID in the range of 1-5000000 is the same,
and the row with the same HID value will be allocated into a sub-bucket, so
that the bitmap value in each sub-bucket is orthogonal. On the UDAF
implementation of bitmap, the orthogonal feature of bitmap value in the bucket
can be used to perform intersection union calculation, and the calculation
results will be shuffled to the top node fo [...]
+Note: The orthogonal bitmap function cannot be used in the partitioned table.
Because the partitions of the partitioned table are orthogonal, the data
between partitions cannot be guaranteed to be orthogonal, so the calculation
result cannot be estimated.
+
#### orthogonal_bitmap_intersect
The bitmap intersection function
diff --git a/docs/sql-manual/sql-functions/math-functions/cbrt.md
b/docs/sql-manual/sql-functions/math-functions/cbrt.md
new file mode 100644
index 00000000000..24fcba137e3
--- /dev/null
+++ b/docs/sql-manual/sql-functions/math-functions/cbrt.md
@@ -0,0 +1,57 @@
+---
+{
+ "title": "cbrt",
+ "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.
+-->
+
+## cbrt
+
+### description
+#### Syntax
+
+`DOUBLE cbrt(DOUBLE x)`
+Returns the cube root of x.
+
+### example
+
+```
+mysql> select cbrt(8);
++-----------+
+| cbrt(8.0) |
++-----------+
+| 2 |
++-----------+
+mysql> select cbrt(2.0);
++--------------------+
+| cbrt(2.0) |
++--------------------+
+| 1.2599210498948734 |
++--------------------+
+mysql> select cbrt(-1000.0);
++---------------+
+| cbrt(-1000.0) |
++---------------+
+| -10 |
++---------------+
+```
+
+### keywords
+ CBRT
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 7db218cdc2d..a1cc19afa86 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
@@ -89,6 +89,8 @@ user_id = to_bitmap(tmp_user_id)
load数据时，对用户bitmap值range范围纵向切割，例如，用户id在1-5000000范围内的hid值相同，hid值相同的行会分配到一个分桶内，如此每个分桶内到的bitmap都是正交的。可以利用桶内bitmap值正交特性，进行交并集计算，计算结果会被shuffle至top节点聚合。
+注：正交bitmap函数不能用在分区表，因为分区表分区内正交，分区之间的数据是无法保证正交的，则计算结果也是无法预估的。
+
#### bitmap_orthogonal_intersect
求bitmap交集函数
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/math-functions/cbrt.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/math-functions/cbrt.md
new file mode 100644
index 00000000000..73178f2003d
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/math-functions/cbrt.md
@@ -0,0 +1,57 @@
+---
+{
+ "title": "cbrt",
+ "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.
+-->
+
+## cbrt
+
+### description
+#### Syntax
+
+`DOUBLE cbrt(DOUBLE x)`
+返回`x`的立方根.
+
+### example
+
+```
+mysql> select cbrt(8);
++-----------+
+| cbrt(8.0) |
++-----------+
+| 2 |
++-----------+
+mysql> select cbrt(2.0);
++--------------------+
+| cbrt(2.0) |
++--------------------+
+| 1.2599210498948734 |
++--------------------+
+mysql> select cbrt(-1000.0);
++---------------+
+| cbrt(-1000.0) |
++---------------+
+| -10 |
++---------------+
+```
+
+### keywords
+ CBRT
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
