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 1c7a00826b0 add bitmap_count (#97) 1c7a00826b0 is described below commit 1c7a00826b0cdd21f1240a36f70872e11b5ee303 Author: Liqf <109049295+lemonlit...@users.noreply.github.com> AuthorDate: Wed Sep 14 09:46:03 2022 +0800 add bitmap_count (#97) --- .../sql-functions/bitmap-functions/bitmap_count.md | 57 ++++++++++++++++++++++ .../sql-functions/bitmap-functions/bitmap_count.md | 56 +++++++++++++++++++++ sidebars.json | 1 + 3 files changed, 114 insertions(+) diff --git a/docs/sql-manual/sql-functions/bitmap-functions/bitmap_count.md b/docs/sql-manual/sql-functions/bitmap-functions/bitmap_count.md new file mode 100644 index 00000000000..8858b9d4ad3 --- /dev/null +++ b/docs/sql-manual/sql-functions/bitmap-functions/bitmap_count.md @@ -0,0 +1,57 @@ +--- +{ + "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/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/bitmap-functions/bitmap_count.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/bitmap-functions/bitmap_count.md new file mode 100644 index 00000000000..b106b9e4031 --- /dev/null +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/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 diff --git a/sidebars.json b/sidebars.json index 17f21c13c7b..788118ac829 100644 --- a/sidebars.json +++ b/sidebars.json @@ -374,6 +374,7 @@ "sql-manual/sql-functions/bitmap-functions/bitmap_hash", "sql-manual/sql-functions/bitmap-functions/bitmap_intersect", "sql-manual/sql-functions/bitmap-functions/bitmap_or", + "sql-manual/sql-functions/bitmap-functions/bitmap_count", "sql-manual/sql-functions/bitmap-functions/bitmap_and_count", "sql-manual/sql-functions/bitmap-functions/bitmap_or_count", "sql-manual/sql-functions/bitmap-functions/bitmap_xor_count", --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org