This is an automated email from the ASF dual-hosted git repository. yiguolei pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push: new 907494760d [typo](docs)Add bitmap_count doc And Adjustment function list (#12978) 907494760d is described below commit 907494760d9c5a291fcb06247d7685d9c3fd82d9 Author: Liqf <109049295+lemonlit...@users.noreply.github.com> AuthorDate: Tue Sep 27 14:21:37 2022 +0800 [typo](docs)Add bitmap_count doc And Adjustment function list (#12978) --- .../sql-functions/bitmap-functions/bitmap_count.md | 56 ++++++++++++++++ docs/sidebars.json | 77 +++++++++++----------- .../sql-functions/bitmap-functions/bitmap_count.md | 56 ++++++++++++++++ 3 files changed, 152 insertions(+), 37 deletions(-) diff --git a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_count.md b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_count.md new file mode 100644 index 0000000000..fe7e35e702 --- /dev/null +++ b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_count.md @@ -0,0 +1,56 @@ +--- +{ + "title": "bitmap_count", + "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. +--> + +## bitmap_count +### description +#### Syntax + +`BITMAP BITMAP_COUNT(BITMAP lhs)` + +Returns the number of input bitmaps。 + +### example + +``` +mysql> select bitmap_count(to_bitmap(1)) cnt; ++------+ +| cnt | ++------+ +| 1 | ++------+ + +mysql> select bitmap_count(bitmap_and(to_bitmap(1), to_bitmap(1))) cnt; ++------+ +| cnt | ++------+ +| 1 | ++------+ + +``` + +### keywords + + BITMAP_COUNT diff --git a/docs/sidebars.json b/docs/sidebars.json index 38f1a24425..a28873b608 100644 --- a/docs/sidebars.json +++ b/docs/sidebars.json @@ -433,34 +433,35 @@ "type": "category", "label": "Bitmap Functions", "items": [ - "sql-manual/sql-functions/bitmap-functions/bitmap_and_not_count", - "sql-manual/sql-functions/bitmap-functions/bitmap_subset_limit", "sql-manual/sql-functions/bitmap-functions/to_bitmap", + "sql-manual/sql-functions/bitmap-functions/bitmap_hash", "sql-manual/sql-functions/bitmap-functions/bitmap_from_string", + "sql-manual/sql-functions/bitmap-functions/bitmap_to_string", + "sql-manual/sql-functions/bitmap-functions/bitmap_empty", "sql-manual/sql-functions/bitmap-functions/bitmap_or", "sql-manual/sql-functions/bitmap-functions/bitmap_and", - "sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_union_count", - "sql-manual/sql-functions/bitmap-functions/bitmap_has_all", - "sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_intersect", + "sql-manual/sql-functions/bitmap-functions/bitmap_union", + "sql-manual/sql-functions/bitmap-functions/bitmap_xor", "sql-manual/sql-functions/bitmap-functions/bitmap_not", - "sql-manual/sql-functions/bitmap-functions/bitmap_min", - "sql-manual/sql-functions/bitmap-functions/bitmap_contains", + "sql-manual/sql-functions/bitmap-functions/bitmap_and_not", + "sql-manual/sql-functions/bitmap-functions/bitmap_subset_limit", + "sql-manual/sql-functions/bitmap-functions/bitmap_subset_in_range", "sql-manual/sql-functions/bitmap-functions/sub_bitmap", - "sql-manual/sql-functions/bitmap-functions/bitmap_union", + "sql-manual/sql-functions/bitmap-functions/bitmap_count", + "sql-manual/sql-functions/bitmap-functions/bitmap_and_count", + "sql-manual/sql-functions/bitmap-functions/bitmap_and_not_count", + "sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_union_count", "sql-manual/sql-functions/bitmap-functions/bitmap_xor_count", - "sql-manual/sql-functions/bitmap-functions/bitmap_and_not", - "sql-manual/sql-functions/bitmap-functions/bitmap_xor", "sql-manual/sql-functions/bitmap-functions/bitmap_or_count", - "sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_intersect_count", + "sql-manual/sql-functions/bitmap-functions/bitmap_contains", + "sql-manual/sql-functions/bitmap-functions/bitmap_has_all", "sql-manual/sql-functions/bitmap-functions/bitmap_has_any", - "sql-manual/sql-functions/bitmap-functions/bitmap_intersect", - "sql-manual/sql-functions/bitmap-functions/bitmap_to_string", - "sql-manual/sql-functions/bitmap-functions/bitmap_hash", - "sql-manual/sql-functions/bitmap-functions/intersect_count", - "sql-manual/sql-functions/bitmap-functions/bitmap_empty", "sql-manual/sql-functions/bitmap-functions/bitmap_max", - "sql-manual/sql-functions/bitmap-functions/bitmap_and_count", - "sql-manual/sql-functions/bitmap-functions/bitmap_subset_in_range" + "sql-manual/sql-functions/bitmap-functions/bitmap_min", + "sql-manual/sql-functions/bitmap-functions/intersect_count", + "sql-manual/sql-functions/bitmap-functions/bitmap_intersect", + "sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_intersect", + "sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_intersect_count" ] }, { @@ -509,34 +510,36 @@ "label": "Math Functions", "items": [ "sql-manual/sql-functions/math-functions/conv", - "sql-manual/sql-functions/math-functions/pmod", - "sql-manual/sql-functions/math-functions/abs", - "sql-manual/sql-functions/math-functions/acos", - "sql-manual/sql-functions/math-functions/asin", - "sql-manual/sql-functions/math-functions/atan", "sql-manual/sql-functions/math-functions/bin", - "sql-manual/sql-functions/math-functions/ceil", + "sql-manual/sql-functions/math-functions/sin", "sql-manual/sql-functions/math-functions/cos", - "sql-manual/sql-functions/math-functions/degrees", + "sql-manual/sql-functions/math-functions/tan", + "sql-manual/sql-functions/math-functions/asin", + "sql-manual/sql-functions/math-functions/acos", + "sql-manual/sql-functions/math-functions/atan", "sql-manual/sql-functions/math-functions/e", + "sql-manual/sql-functions/math-functions/pi", "sql-manual/sql-functions/math-functions/exp", - "sql-manual/sql-functions/math-functions/greatest", - "sql-manual/sql-functions/math-functions/least", - "sql-manual/sql-functions/math-functions/ln", "sql-manual/sql-functions/math-functions/log", - "sql-manual/sql-functions/math-functions/log10", "sql-manual/sql-functions/math-functions/log2", - "sql-manual/sql-functions/math-functions/negative", - "sql-manual/sql-functions/math-functions/pi", - "sql-manual/sql-functions/math-functions/positive", + "sql-manual/sql-functions/math-functions/ln", + "sql-manual/sql-functions/math-functions/log10", + "sql-manual/sql-functions/math-functions/ceil", + "sql-manual/sql-functions/math-functions/floor", + "sql-manual/sql-functions/math-functions/pmod", + "sql-manual/sql-functions/math-functions/round", + "sql-manual/sql-functions/math-functions/truncate", + "sql-manual/sql-functions/math-functions/abs", + "sql-manual/sql-functions/math-functions/sqrt", + "sql-manual/sql-functions/math-functions/cbrt", "sql-manual/sql-functions/math-functions/pow", + "sql-manual/sql-functions/math-functions/degrees", "sql-manual/sql-functions/math-functions/radians", - "sql-manual/sql-functions/math-functions/round", "sql-manual/sql-functions/math-functions/sign", - "sql-manual/sql-functions/math-functions/sin", - "sql-manual/sql-functions/math-functions/sqrt", - "sql-manual/sql-functions/math-functions/tan", - "sql-manual/sql-functions/math-functions/truncate" + "sql-manual/sql-functions/math-functions/positive", + "sql-manual/sql-functions/math-functions/negative", + "sql-manual/sql-functions/math-functions/greatest", + "sql-manual/sql-functions/math-functions/least" ] }, { diff --git a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_count.md b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_count.md new file mode 100644 index 0000000000..b106b9e403 --- /dev/null +++ b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_count.md @@ -0,0 +1,56 @@ +--- +{ + "title": "bitmap_count", + "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. +--> + +## bitmap_count +### description +#### Syntax + +`BITMAP BITMAP_COUNT(BITMAP lhs)` + +返回输入bitmap的个数。 + +### example + +``` +mysql> select bitmap_count(to_bitmap(1)) cnt; ++------+ +| cnt | ++------+ +| 1 | ++------+ + +mysql> select bitmap_count(bitmap_and(to_bitmap(1), to_bitmap(1))) cnt; ++------+ +| cnt | ++------+ +| 1 | ++------+ + +``` + +### keywords + + BITMAP_COUNT --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org