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 075b2abaa5e docs(i18n): machine Japanese translation candidates (#4330)
075b2abaa5e is described below
commit 075b2abaa5ee972380ce6d17bd83060c8dd1a2f9
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Fri Oct 16 15:38:24 2026 +0800
docs(i18n): machine Japanese translation candidates (#4330)
## Japanese translation candidate
Source commit: `f8f3bcc26a30a6de16c701f2d8fe68e14f4660f7`
Model: `gpt-6-sol`; glossary: `1`
Review status: machine. Japanese proofreading and the normal PR checks
are still required.
| Action | Version | English source | SHA-256 prefix | Generation |
| --- | --- | --- | --- | --- |
| update | current |
[`docs/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.md`](https://github.com/apache/doris-website/blob/f8f3bcc26a30a6de16c701f2d8fe68e14f4660f7/docs/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.md)
| `de904c589a28` | model call |
## Failed or skipped tasks
None.
## Validation
The generator checked committed source hashes, managed paths, protected
syntax,
target/state hashes and the current master SHA before applying the
candidate.
The PR checks must verify links, routes, coverage and the site build
before merging.
<!-- japanese-translation-automation:v1
bot-head=9cd8ddc84f2b841a57a55aa5687da3dc7cd5caf8 -->
Local Japanese translation gate: passed.
Co-authored-by: morningman <[email protected]>
---
.../aggregate-functions/bitmap-union-int.md | 64 ++++++++++++++++++----
.../aggregate-functions/bitmap-union-int.json | 12 ++--
2 files changed, 60 insertions(+), 16 deletions(-)
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.md
index 787986613f4..35082fc864c 100644
---
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.md
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.md
@@ -2,31 +2,37 @@
{
"title": "BITMAP-UNION-INT",
"language": "ja",
- "description": "入力式の重複しない値の数を数えます。戻り値は COUNT(DISTINCT expr) と同じです。"
+ "description": "入力式に含まれる重複しない非負整数の数を、負の値とNULLを無視して数えます。"
}
---
-## 説明
+## 説明 {#description}
-入力式の重複しない値の数を数えます。戻り値は COUNT(DISTINCT expr) と同じです。
+入力式に含まれる重複しない非負整数の数を、負の値とNULLを無視して数えます。
-## 構文
+サポートされる整数型の入力では、これは `COUNT(DISTINCT CASE WHEN expr >= 0 THEN expr END)` および
`BITMAP_COUNT(BITMAP_AGG(expr))`と同等です。また、 `COUNT(DISTINCT expr)`
と同等になるのは、入力に負の値が含まれない場合に限られます。
+
+## 使用上の注意 {#usage-notes}
+
+負の値を無視するのは開発版の動作です。以前のリリースでは負の値も数える場合があるため、負の値を含むクエリはアップグレード後に異なる結果を返す可能性があります。
+
+## 構文 {#syntax}
```sql
BITMAP_UNION_INT(<expr>)
```
-## パラメータ
+## パラメータ {#parameters}
| パラメータ | 説明 |
-| -- | -- |
-| `<expr>` | 入力式。対応する型: TinyInt、SmallInt、Integer。 |
+| --- | --- |
+| `<expr>` | 入力式。サポートされる型: TinyInt、SmallInt、Integer。 |
-## 戻り値
+## 戻り値 {#return-value}
-列内の重複しない値の数を返します。グループ内に有効なデータがない場合は 0 を返します。
+重複しない非負整数の数をBIGINTで返します。NULLと負の値は無視されます。入力が空の場合、またはグループにNULLと負の値しか含まれない場合は0を返します。結果がNULLになることはありません。
-## 例
+## 例 {#example}
```sql
-- setup
@@ -44,6 +50,11 @@ INSERT INTO pv_bitmap VALUES
(2, 200, to_bitmap(300));
```
+```text
+Query OK, 0 rows affected
+Query OK, 5 rows affected
+```
+
```sql
select bitmap_union_int(dt) from pv_bitmap;
```
@@ -67,3 +78,36 @@ select bitmap_union_int(dt) from pv_bitmap where dt is null;
| 0 |
+----------------------+
```
+
+負の整数は除外され、ゼロは含まれます:
+
+```sql
+SELECT bitmap_union_int(x) AS nonnegative_count
+FROM (
+ SELECT -1 AS x UNION ALL SELECT 0 UNION ALL SELECT 1
+ UNION ALL SELECT 1 UNION ALL SELECT NULL
+) AS input;
+```
+
+```text
++-------------------+
+| nonnegative_count |
++-------------------+
+| 2 |
++-------------------+
+```
+
+負の値とNULLしか含まれないグループでは、ゼロが返されます:
+
+```sql
+SELECT bitmap_union_int(x) AS nonnegative_count
+FROM (SELECT -1 AS x UNION ALL SELECT -2 UNION ALL SELECT NULL) AS input;
+```
+
+```text
++-------------------+
+| nonnegative_count |
++-------------------+
+| 0 |
++-------------------+
+```
diff --git
a/translations/state/ja/pages/default/current/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.json
b/translations/state/ja/pages/default/current/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.json
index 65ca3f72bdf..2ea3599b8c2 100644
---
a/translations/state/ja/pages/default/current/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.json
+++
b/translations/state/ja/pages/default/current/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.json
@@ -8,13 +8,13 @@
"sourceLocale": "en",
"sourcePath":
"docs/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.md",
"targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/bitmap-union-int.md",
- "sourceCommit": "8dd8cb1f5ce4154d6f537595ac445d1b9ca2431d",
- "sourceHash":
"d0b223fe0eec3770de65bc139321ba693df54c8a4b3158f0c69ac505642046c1",
- "sourceTechnicalHash":
"3535810d7c0c11dfcc9a8aaa340b11a489d35ad0e43a8768b62921f49153516c",
- "targetHash":
"3a8c062961dcfa03d4c94b460e7ae945cbef558c46618b15418a2d826dbf9b88",
+ "sourceCommit": "f8f3bcc26a30a6de16c701f2d8fe68e14f4660f7",
+ "sourceHash":
"de904c589a289f94c7f58ffb12980f2beb530802c18bc28f89edfa6b3615810f",
+ "sourceTechnicalHash":
"026ec146b754671f89187f8d8eef756e066ea5480743f7d8c1a7380648dc6ac3",
+ "targetHash":
"ec15ce9a1e142ca3337610291f4f41b4081020c1b6ad1d442b1c3631d1ee303e",
"reviewStatus": "machine",
"ownership": "machine",
- "translatedAt": "2026-10-14T20:08:32.053Z",
- "glossaryVersion": "0"
+ "translatedAt": "2026-10-16T07:10:45.505Z",
+ "glossaryVersion": "1"
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
