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 c3376bb1e40 [fix] correct COUNT DISTINCT example in bitmap precise
deduplication doc (#3659)
c3376bb1e40 is described below
commit c3376bb1e408d4aa031fd72a57ed2861e1dc956e
Author: boluor <[email protected]>
AuthorDate: Mon May 18 20:41:58 2026 -0700
[fix] correct COUNT DISTINCT example in bitmap precise deduplication doc
(#3659)
## Summary
Fixes the equivalent-query example in the BITMAP precise deduplication
doc.
The example used `SELECT COUNT(DISTINCT pv) FROM test_bitmap;`, but the
`test_bitmap` table has no `pv` column — it only has `id`. The result
header was also wrong (`count(DISTINCT \`uv\`)` / `count(DISTINCT
\`pv\`)`).
Corrected to `SELECT COUNT(DISTINCT id)` with header `count(DISTINCT
\`id\`)`.
Affected files:
- `docs-next` (English, next)
- `i18n/zh-CN/.../docs-next/current` (Chinese, next)
- `i18n/zh-CN/.../version-2.1` (Chinese)
- `i18n/zh-CN/.../version-3.x` (Chinese)
- `i18n/zh-CN/.../version-4.x` (Chinese)
The English released versions (2.1/3.x/4.x) were already correct.
Closes #62827
## Test plan
- [x] Verified `test_bitmap` table definition contains only `id` (no
`pv`)
- [x] Confirmed English released versions already use `id`, so no change
needed there
Co-authored-by: Claude Opus 4.7 (1M context) <[email protected]>
---
.../distinct-counts/bitmap-precise-deduplication.md | 4 ++--
.../distinct-counts/bitmap-precise-deduplication.md | 4 ++--
.../distinct-counts/bitmap-precise-deduplication.md | 4 ++--
.../distinct-counts/bitmap-precise-deduplication.md | 4 ++--
.../distinct-counts/bitmap-precise-deduplication.md | 4 ++--
.../distinct-counts/bitmap-precise-deduplication.md | 4 ++--
6 files changed, 12 insertions(+), 12 deletions(-)
diff --git
a/docs/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
b/docs/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
index af8a17554a2..bd1a57a33f5 100644
--- a/docs/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
+++ b/docs/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
@@ -140,9 +140,9 @@ mysql> select bitmap_union_count(uv) from test_bitmap;
This is equivalent to:
```SQL
-mysql> SELECT COUNT(DISTINCT pv) FROM test_bitmap;
+mysql> SELECT COUNT(DISTINCT id) FROM test_bitmap;
+----------------------+
-| count(DISTINCT `pv`) |
+| count(DISTINCT `id`) |
+----------------------+
| 4 |
+----------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
index fe6509ccd5a..de9ca5be2b8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
@@ -140,9 +140,9 @@ mysql> select bitmap_union_count(uv) from test_bitmap;
等价于：
```SQL
-mysql> SELECT COUNT(DISTINCT pv) FROM test_bitmap;
+mysql> SELECT COUNT(DISTINCT id) FROM test_bitmap;
+----------------------+
-| count(DISTINCT `pv`) |
+| count(DISTINCT `id`) |
+----------------------+
| 4 |
+----------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
index 8d98fa1ac25..29fbae82189 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
@@ -126,9 +126,9 @@ mysql> select bitmap_union_count(uv) from test_bitmap;
等价于：
```SQL
-mysql> SELECT COUNT(DISTINCT pv) FROM test_bitmap;
+mysql> SELECT COUNT(DISTINCT id) FROM test_bitmap;
+----------------------+
-| count(DISTINCT `uv`) |
+| count(DISTINCT `id`) |
+----------------------+
| 4 |
+----------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
index 8d98fa1ac25..29fbae82189 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
@@ -126,9 +126,9 @@ mysql> select bitmap_union_count(uv) from test_bitmap;
等价于：
```SQL
-mysql> SELECT COUNT(DISTINCT pv) FROM test_bitmap;
+mysql> SELECT COUNT(DISTINCT id) FROM test_bitmap;
+----------------------+
-| count(DISTINCT `uv`) |
+| count(DISTINCT `id`) |
+----------------------+
| 4 |
+----------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
index fe6509ccd5a..de9ca5be2b8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
@@ -140,9 +140,9 @@ mysql> select bitmap_union_count(uv) from test_bitmap;
等价于：
```SQL
-mysql> SELECT COUNT(DISTINCT pv) FROM test_bitmap;
+mysql> SELECT COUNT(DISTINCT id) FROM test_bitmap;
+----------------------+
-| count(DISTINCT `pv`) |
+| count(DISTINCT `id`) |
+----------------------+
| 4 |
+----------------------+
diff --git
a/versioned_docs/version-4.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
b/versioned_docs/version-4.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
index af8a17554a2..bd1a57a33f5 100644
---
a/versioned_docs/version-4.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
+++
b/versioned_docs/version-4.x/query-acceleration/distinct-counts/bitmap-precise-deduplication.md
@@ -140,9 +140,9 @@ mysql> select bitmap_union_count(uv) from test_bitmap;
This is equivalent to:
```SQL
-mysql> SELECT COUNT(DISTINCT pv) FROM test_bitmap;
+mysql> SELECT COUNT(DISTINCT id) FROM test_bitmap;
+----------------------+
-| count(DISTINCT `pv`) |
+| count(DISTINCT `id`) |
+----------------------+
| 4 |
+----------------------+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
