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 fc061c6dcfd docs(ja): translate 20 Dev conditional and aggregate
functions (T09-DEV-059) (#4225)
fc061c6dcfd is described below
commit fc061c6dcfdf735e2c0a3f241b4cacdb29cf0b86
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Tue Oct 13 14:24:48 2026 +0800
docs(ja): translate 20 Dev conditional and aggregate functions
(T09-DEV-059) (#4225)
## Summary
Translate all 20 Dev conditional, quantile, other, and aggregate SQL
function documents assigned to T09-DEV-059 into Japanese. Each target
has independent source/target hashes and `reviewStatus=machine`.
Fourteen Dev/4.x English sources match; six differ and require separate
4.x handling. This PR changes Dev only.
## Checks
- Translation protection: 20 changed pages, 0 errors.
- Targeted Markdown link lint: 20 files, 0 findings.
- No local website build for this routine translation-only PR;
repository Build Check will validate the PR head.
The English source has pre-existing inconsistencies in `DEFAULT` and
`GROUPING_ID` behavior descriptions; some function pages also lack the
full standard section set or NULL examples. The Japanese text preserves
the Dev source structure and technical content. CI success does not
imply human Japanese proofreading.
---------
Co-authored-by: morningman <[email protected]>
---
.../sql-functions/aggregate-functions/ai-agg.md | 130 ++++++++
.../sql-functions/aggregate-functions/any-value.md | 113 +++++++
.../conditional-functions/coalesce.md | 63 ++++
.../conditional-functions/greatest.md | 78 +++++
.../scalar-functions/conditional-functions/if.md | 72 +++++
.../conditional-functions/ifnull.md | 64 ++++
.../conditional-functions/least.md | 79 +++++
.../conditional-functions/not-null-or-empty.md | 36 +++
.../conditional-functions/null-or-empty.md | 36 +++
.../conditional-functions/nullif.md | 63 ++++
.../conditional-functions/overview.md | 88 ++++++
.../scalar-functions/other-functions/convert-to.md | 73 +++++
.../scalar-functions/other-functions/default.md | 183 +++++++++++
.../scalar-functions/other-functions/esquery.md | 59 ++++
.../scalar-functions/other-functions/field.md | 141 +++++++++
.../other-functions/grouping-id.md | 98 ++++++
.../scalar-functions/other-functions/grouping.md | 78 +++++
.../quantile-functions/quantile-percent.md | 61 ++++
.../quantile-functions/quantile-state-empty.md | 37 +++
.../quantile-functions/to-quantile-state.md | 61 ++++
translations/inventory/ja/2026-10-12/batches.md | 2 +-
translations/state/ja/docs.json | 340 +++++++++++++++++++++
22 files changed, 1954 insertions(+), 1 deletion(-)
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/ai-agg.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/ai-agg.md
new file mode 100644
index 00000000000..3a0872dea03
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/ai-agg.md
@@ -0,0 +1,130 @@
+---
+{
+ "title": "AI_AGG",
+ "language": "ja",
+ "description": "ユーザーが指定した指示に従い、大規模言語モデルを使って特定の列を集約します。"
+}
+---
+
+## 説明
+
+ユーザーが指定した指示に従い、大規模言語モデルを使って特定の列を集約します。
+
+## 構文
+
+`AI_AGG([<resource_name>], <expr>, <instruction>)`
+
+## パラメータの説明
+
+| パラメータ | 説明 |
+| --- | --- |
+| `<resource_name>` | 使用するリソース名。省略可能です。 |
+| `<expr>` | 集約するテキスト列。個々のテキストは 128K 文字未満である必要があります。 |
+| `<instruction>` | 実行する指示。リテラルのみ指定できます。 |
+
+## 戻り値
+
+集約結果を含む文字列を返します。
+
+すべての入力値が NULL の場合は NULL を返します。
+
+結果は言語モデルが生成するため、出力は固定されません。
+
+## 例
+
+次のテーブルは、カスタマーサポートの問い合わせを模しています。
+```sql
+CREATE TABLE support_tickets (
+ ticket_id BIGINT,
+ customer_name VARCHAR(100),
+ subject VARCHAR(200),
+ details TEXT
+)
+DUPLICATE KEY(ticket_id)
+DISTRIBUTED BY HASH(ticket_id) BUCKETS 5
+PROPERTIES (
+ "replication_num" = "1"
+);
+
+INSERT INTO support_tickets VALUES
+(1, 'Alice', 'Login Failure', 'Cannot log in after password reset. Tried
clearing cache and different browsers.'),
+(2, 'Bob', 'Login Failure', 'Same problem as Alice. Also seeing 502 errors on
the SSO page.'),
+(3, 'Carol', 'Payment Declined', 'Credit card charged twice but order still
shows pending.'),
+(4, 'Dave', 'Slow Dashboard', 'Dashboard takes >30 seconds to load since the
last release.'),
+(5, 'Eve', 'Login Failure', 'Getting redirected back to login after entering
2FA code.');
+```
+
+`AI_AGG` を使用すると、問題の主題ごとに顧客の問い合わせを要約できます。
+```sql
+SELECT
+ subject,
+ AI_AGG(
+ 'ai_resource_name',
+ details,
+ 'Summarize every ticket detail into one short paragraph of 40 words or
less.'
+ ) AS ai_summary
+FROM support_tickets
+GROUP BY subject;
+```
+
+```text
++------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| subject | ai_summary
|
++------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Slow Dashboard | The dashboard loading time has significantly increased to
over 30 seconds following the latest release, indicating a potential issue with
the recent update. |
+| Login Failure | User experiences login issues, including redirection
post-2FA, inability to log in after password reset despite using different
browsers and clearing cache, and encountering 502 errors on the SSO page. |
+| Payment Declined | The customer's credit card was charged twice, but the
order status remains pending, indicating a potential issue with the transaction
processing or system update. |
++------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+```
+
+ケース 2：
+
+次のテーブルは、EC サイトのユーザーレビューを模しています。
+```sql
+CREATE TABLE product_reviews (
+ review_id BIGINT,
+ product_id BIGINT,
+ rating TINYINT,
+ comment STRING
+)
+DUPLICATE KEY(review_id)
+DISTRIBUTED BY HASH(product_id) BUCKETS 10
+PROPERTIES (
+ "replication_num" = "1"
+);
+
+INSERT INTO product_reviews VALUES
+(1, 1001, 5, '鞋子尺码刚好，穿着舒服，颜色也好看，物流很快！'),
+(2, 1001, 4, '质量不错，就是鞋底有点硬，需要磨合几天。'),
+(3, 1001, 3, '外观和图片一样，但收到时有轻微胶味。'),
+(4, 1002, 5, '杯子小巧，出汁快，清洗也方便，上班带着刚好。'),
+(5, 1002, 3, '声音有点大，不过能接受，充满电只能榨 5 杯。'),
+(6, 1002, 2, '用了两周就充不进电，售后换货流程太慢。'),
+(7, 1003, 5, '面料透气不闷热，袖口设计很贴心，UPF50+ 确实晒不黑。'),
+(8, 1003, 4, '颜色好看，但拉链有点卡顿，需要用力。'),
+(9, 1004, 5, '降噪给力，地铁里也能安静听歌，续航一周充一次。');
+```
+
+AI_AGG を使って要約・評価する場合:
+```sql
+SET default_ai_resource = 'ai_resource_name';
+SELECT
+ product_id,
+ AI_AGG(
+ comment,
+ '请把多条用户评价总结成一句话，突出买家最关心的优点和缺点，控制在50字以内。'
+ ) AS 评价摘要
+FROM product_reviews
+GROUP BY product_id;
+```
+
+```text
++------------+--------------------------------------------------------------------------------------------------------------+
+| product_id | 评价摘要
|
++------------+--------------------------------------------------------------------------------------------------------------+
+| 1003 | 该产品面料透气、防晒效果好且颜色美观，但拉链使用不顺畅。
|
+| 1004 | 用户评价该产品降噪效果好，续航能力强，一周充一次电。
|
+| 1001 | 买家普遍认为鞋子穿着舒适、外观好看且物流快，但鞋底偏硬且有轻微胶味。
|
+| 1002 | 买家认为该榨汁杯小巧便携、出汁快且易清洗，但电池续航短且售后换货流程慢。
|
++------------+--------------------------------------------------------------------------------------------------------------+
+```
\ No newline at end of file
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/any-value.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/any-value.md
new file mode 100644
index 00000000000..edd74e77af4
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/any-value.md
@@ -0,0 +1,113 @@
+---
+{
+ "title": "ANY_VALUE",
+ "language": "ja",
+ "description": "グループ内の式または列から任意の値を返します。NULL でない値があれば、そのいずれかを返し、なければ NULL
を返します。"
+}
+---
+
+## 説明
+
+グループ内の式または列から任意の値を返します。NULL でない値があれば、そのいずれかを返し、なければ NULL を返します。
+
+## 別名
+
+- ANY
+
+## 構文
+
+```sql
+ANY_VALUE(<expr>)
+ANY(<expr>)
+```
+
+## パラメータ
+
+| パラメータ | 説明 |
+| --- | --- |
+| `<expr>` | 集約する列または式。サポートされる型は
String、Date、DateTime、TimestampNs、Timestamptz、IPv4、IPv6、UUID、Bool、TinyInt、SmallInt、Integer、BigInt、LargeInt、Float、Double、Decimal、Array、Map、Struct、AggState、Bitmap、HLL、QuantileState
です。 |
+
+## 戻り値
+
+NULL でない値があればそのいずれかを返し、なければ NULL を返します。
+戻り値の型は入力 expr の型と同じです。
+
+## 例
+
+```sql
+-- setup
+create table t1(
+ k1 int,
+ k_string varchar(100),
+ k_decimal decimal(10, 2)
+) distributed by hash (k1) buckets 1
+properties ("replication_num"="1");
+insert into t1 values
+ (1, 'apple', 10.01),
+ (1, 'banana', 20.02),
+ (2, 'orange', 30.03),
+ (2, null, null),
+ (3, null, null);
+```
+
+```sql
+select k1, any_value(k_string) from t1 group by k1;
+```
+
+文字列型: 各グループから NULL でない任意の値を返します。
+
+```text
++------+---------------------+
+| k1 | any_value(k_string) |
++------+---------------------+
+| 1 | apple |
+| 2 | orange |
+| 3 | NULL |
++------+---------------------+
+```
+
+```sql
+select k1, any_value(k_decimal) from t1 group by k1;
+```
+
+Decimal 型: NULL でない任意の高精度小数値を返します。
+
+```text
++------+----------------------+
+| k1 | any_value(k_decimal) |
++------+----------------------+
+| 1 | 10.01 |
+| 2 | 30.03 |
+| 3 | NULL |
++------+----------------------+
+```
+
+```sql
+select any_value(k_string) from t1 where k1 = 3;
+```
+
+グループ内のすべての値が NULL の場合は NULL を返します。
+
+```text
++---------------------+
+| any_value(k_string) |
++---------------------+
+| NULL |
++---------------------+
+```
+
+```sql
+select k1, any(k_string) from t1 group by k1;
+```
+
+別名 ANY を使用しても、ANY_VALUE と同じ結果になります。
+
+```text
++------+---------------+
+| k1 | any(k_string) |
++------+---------------+
+| 1 | apple |
+| 2 | orange |
+| 3 | NULL |
++------+---------------+
+```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/coalesce.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/coalesce.md
new file mode 100644
index 00000000000..9573630fd6b
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/coalesce.md
@@ -0,0 +1,63 @@
+---
+{
+ "title": "COALESCE",
+ "language": "ja",
+ "description": "引数のリストを左から右へ評価し、最初の NULL でない式の値を返します。すべての引数が NULL の場合は
NULL を返します。"
+}
+---
+
+## 説明
+
+引数のリストを左から右へ評価し、最初の NULL でない式の値を返します。すべての引数が NULL の場合は NULL を返します。
+
+## 構文
+
+```sql
+COALESCE( <expr1> [ , ... , <exprN> ] )
+```
+
+## パラメータ
+### 必須パラメータ
+- `<expr1>`: 任意の型の式。
+### 可変長パラメータ
+- `COALESCE` 関数には複数の可変長パラメータを指定できます。
+
+## 戻り値
+引数のリストで最初の NULL でない式の値を返します。すべての引数が NULL の場合は NULL を返します。
+
+## 使用上の注意
+1. 複数の引数は、できるだけ同じ型にしてください。
+2. 引数の型が異なる場合、この関数は同じ型への変換を試みます。変換規則は
[型変換](../../../basic-element/sql-data-types/conversion/overview.md) を参照してください。
+3. 現在、引数には次の型のみを指定できます。
+ * 文字列型（String/VARCHAR/CHAR）
+ * 真偽値型（Boolean）
+ * 数値型（TinyInt、SmallInt、Int、BigInt、LargeInt、Float、Double、Decimal）
+ * 日付型（Date、DateTime、TimestampNs）
+ * Bitmap 型（Bitmap）
+ * 半構造化型（JSON、Array、MAP、Struct）
+
+## 例
+1. 引数の型変換
+ ```sql
+ select coalesce(null, 2, 1.234);
+ ```
+ ```text
+ +--------------------------+
+ | coalesce(null, 2, 1.234) |
+ +--------------------------+
+ | 2.000 |
+ +--------------------------+
+ ```
+ > 三番目の引数 "1.234" が Decimal 型のため、引数 "2" は Decimal 型に変換されます。
+
+2. すべての引数が NULL の場合
+ ```sql
+ select coalesce(null, null, null);
+ ```
+ ```text
+ +----------------------------+
+ | coalesce(null, null, null) |
+ +----------------------------+
+ | NULL |
+ +----------------------------+
+ ```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/greatest.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/greatest.md
new file mode 100644
index 00000000000..4a8bb036723
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/greatest.md
@@ -0,0 +1,78 @@
+---
+{
+ "title": "GREATEST",
+ "language": "ja",
+ "description": "複数の式を比較し、最大値を返します。いずれかの引数が NULL の場合は NULL を返します。"
+}
+---
+
+## 説明
+
+複数の式を比較し、最大値を返します。いずれかの引数が `NULL` の場合は `NULL` を返します。
+
+## 構文
+
+```sql
+GREATEST(<expr> [, ...])
+```
+
+## パラメータ
+### 必須パラメータ
+- `<expr>`:
`TINYINT`、`SMALLINT`、`INT`、`BIGINT`、`LARGEINT`、`FLOAT`、`DOUBLE`、`STRING`、`DATETIME`、`TIMESTAMP_NS`、`DECIMAL`
型をサポートします。
+### 任意のパラメータ
+- 複数の引数を指定できます。
+
+## 戻り値
+- 指定した式の中で最大の値を返します。
+- いずれかの引数が `NULL` の場合は `NULL` を返します。
+
+## 使用上の注意
+1. 引数には同じ型を指定することを推奨します。型が異なる場合、この関数は同じ型への変換を試みます。変換規則は
[型変換](../../../basic-element/sql-data-types/conversion/overview.md) を参照してください。
+2. いずれかの引数が NULL の場合、結果は NULL になります。
+
+## 例
+1. 例 1
+ ```sql
+ SELECT GREATEST(-1, 0, 5, 8);
+ ```
+ ```text
+ +-----------------------+
+ | GREATEST(-1, 0, 5, 8) |
+ +-----------------------+
+ | 8 |
+ +-----------------------+
+ ```
+2. NULL 引数
+ ```sql
+ SELECT GREATEST(-1, 0, 5, NULL);
+ ```
+ ```text
+ +--------------------------+
+ | GREATEST(-1, 0, 5, NULL) |
+ +--------------------------+
+ | NULL |
+ +--------------------------+
+ ```
+3. 型変換
+ ```sql
+ SELECT GREATEST(6, 4.29, 7);
+ ```
+ ```text
+ +----------------------+
+ | GREATEST(6, 4.29, 7) |
+ +----------------------+
+ | 7.00 |
+ +----------------------+
+ ```
+ > 三番目の引数 "7" は Decimal 型に変換されます。
+4. 日付型
+ ```sql
+ SELECT GREATEST('2022-02-26 20:02:11', '2020-01-23 20:02:11', '2020-06-22
20:02:11');
+ ```
+ ```text
+
+-------------------------------------------------------------------------------+
+ | GREATEST('2022-02-26 20:02:11', '2020-01-23 20:02:11', '2020-06-22
20:02:11') |
+
+-------------------------------------------------------------------------------+
+ | 2022-02-26 20:02:11
|
+
+-------------------------------------------------------------------------------+
+ ```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/if.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/if.md
new file mode 100644
index 00000000000..f659a0c7b62
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/if.md
@@ -0,0 +1,72 @@
+---
+{
+ "title": "IF",
+ "language": "ja",
+ "description": "式 <condition> が true の場合は <valuetrue> を、それ以外の場合は
<valuefalseornull> を返します。"
+}
+---
+
+## 説明
+
+式 `<condition>` が true の場合は `<value_true>` を、それ以外の場合は `<value_false_or_null>`
を返します。
+戻り値の型: `<value_true>` 式の結果の型。
+
+## 構文
+
+```sql
+IF(<condition>, <value_true>, <value_false_or_null>)
+```
+## パラメータ
+- `<condition>`: 条件が true かを判定する Boolean 型の式。
+- `<value_true>`: `<condition>` が true の場合に返す値。
+- `<value_false_or_null>`: `<condition>` が false または NULL の場合に返す値。
+
+## 例
+0. データの準備
+ ```sql
+ create table test_if(
+ user_id int
+ ) properties('replication_num' = '1');
+ insert into test_if values(1),(2),(null);
+ ```
+1. 例 1
+ ```sql
+ SELECT user_id, IF(user_id = 1, "true", "false") AS test_if FROM test_if;
+ ```
+ ```text
+ +---------+---------+
+ | user_id | test_if |
+ +---------+---------+
+ | NULL | false |
+ | 1 | true |
+ | 2 | false |
+ +---------+---------+
+ ```
+2. 型変換
+ ```sql
+ SELECT user_id, IF(user_id = 1, 2, 3.14) AS test_if FROM test_if;
+ ```
+ ```text
+ +---------+---------+
+ | user_id | test_if |
+ +---------+---------+
+ | NULL | 3.14 |
+ | 1 | 2.00 |
+ | 2 | 3.14 |
+ +---------+---------+
+ ```
+ > 二番目の引数 "2" は、三番目の引数 "3.14" の型（Decimal）に変換されます。
+
+3. NULL 引数
+ ```sql
+ SELECT user_id, IF(user_id = 1, 2, NULL) AS test_if FROM test_if;
+ ```
+ ```text
+ +---------+---------+
+ | user_id | test_if |
+ +---------+---------+
+ | NULL | NULL |
+ | 1 | 2 |
+ | 2 | NULL |
+ +---------+---------+
+ ```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/ifnull.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/ifnull.md
new file mode 100644
index 00000000000..8c0ca37e58d
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/ifnull.md
@@ -0,0 +1,64 @@
+---
+{
+ "title": "IFNULL",
+ "language": "ja",
+ "description": "<expr1> が NULL でなければ <expr1> を、それ以外の場合は <expr2> を返します。"
+}
+---
+
+## 説明
+
+`<expr1>` が `NULL` でなければ `<expr1>` を、それ以外の場合は `<expr2>` を返します。
+
+## 別名
+
+- NVL
+
+## 構文
+
+```sql
+IFNULL(<expr1>, <expr2>)
+```
+
+## パラメータ
+- `<expr1>`: `NULL` かを判定する式。
+- `<expr2>`: `<expr1>` が `NULL` の場合に返す値。
+
+## 戻り値
+- `<expr1>` が `NULL` でなければ `<expr1>` を返します。
+- それ以外の場合は `<expr2>` を返します。
+
+## 例
+1. 例 1
+ ```sql
+ SELECT IFNULL(1, 0);
+ ```
+ ```text
+ +--------------+
+ | IFNULL(1, 0) |
+ +--------------+
+ | 1 |
+ +--------------+
+ ```
+2. 例 2
+ ```sql
+ SELECT IFNULL(NULL, 10);
+ ```
+ ```text
+ +------------------+
+ | IFNULL(NULL, 10) |
+ +------------------+
+ | 10 |
+ +------------------+
+ ```
+3. 両方の引数が NULL の場合
+ ```sql
+ SELECT IFNULL(NULL, NULL);
+ ```
+ ```text
+ +--------------------+
+ | IFNULL(NULL, NULL) |
+ +--------------------+
+ | NULL |
+ +--------------------+
+ ```
\ No newline at end of file
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/least.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/least.md
new file mode 100644
index 00000000000..d36e33c0185
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/least.md
@@ -0,0 +1,79 @@
+---
+{
+ "title": "LEAST",
+ "language": "ja",
+ "description": "複数の式を比較し、最小値を返します。いずれかの引数が NULL の場合は NULL を返します。"
+}
+---
+
+## 説明
+
+複数の式を比較し、最小値を返します。いずれかの引数が `NULL` の場合は `NULL` を返します。
+
+## 構文
+
+```sql
+LEAST(<expr> [, ...])
+```
+
+## パラメータ
+### 必須パラメータ
+- `<expr>`:
`TINYINT`、`SMALLINT`、`INT`、`BIGINT`、`LARGEINT`、`FLOAT`、`DOUBLE`、`STRING`、`DATETIME`、`TIMESTAMP_NS`、`DECIMAL`
型をサポートします。
+### 任意のパラメータ
+- 複数の引数を指定できます。
+
+## 戻り値
+- 指定した式の中で最小の値を返します。
+- いずれかの引数が `NULL` の場合は `NULL` を返します。
+
+## 使用上の注意
+1. 引数には同じ型を指定することを推奨します。型が異なる場合、この関数は同じ型への変換を試みます。変換規則は
[型変換](../../../basic-element/sql-data-types/conversion/overview.md) を参照してください。
+2. いずれかの引数が NULL の場合、結果は NULL になります。
+
+
+## 例
+1. 例 1
+ ```sql
+ SELECT LEAST(-1, 0, 5, 8);
+ ```
+ ```text
+ +--------------------+
+ | LEAST(-1, 0, 5, 8) |
+ +--------------------+
+ | -1 |
+ +--------------------+
+ ```
+2. NULL 引数
+ ```sql
+ SELECT LEAST(-1, 0, 5, NULL);
+ ```
+ ```text
+ +-----------------------+
+ | LEAST(-1, 0, 5, NULL) |
+ +-----------------------+
+ | NULL |
+ +-----------------------+
+ ```
+3. 型変換
+ ```sql
+ SELECT LEAST(6, 9.29, 7);
+ ```
+ ```text
+ +-------------------+
+ | LEAST(6, 9.29, 7) |
+ +-------------------+
+ | 6.00 |
+ +-------------------+
+ ```
+ > 最初の引数 "6" は Decimal 型に変換されます。
+4. 日付型
+ ```sql
+ SELECT LEAST('2022-02-26 20:02:11', '2020-01-23 20:02:11', '2020-06-22
20:02:11');
+ ```
+ ```text
+
+----------------------------------------------------------------------------+
+ | LEAST('2022-02-26 20:02:11', '2020-01-23 20:02:11', '2020-06-22
20:02:11') |
+
+----------------------------------------------------------------------------+
+ | 2020-01-23 20:02:11
|
+
+----------------------------------------------------------------------------+
+ ```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
new file mode 100644
index 00000000000..e88d5206267
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md
@@ -0,0 +1,36 @@
+---
+{
+ "title": "NOT_NULL_OR_EMPTY",
+ "language": "ja",
+ "description": "指定した値が NULL でも空でもないかを判定します。"
+}
+---
+
+## 説明
+
+`not_null_or_empty` 関数は、指定した値が NULL でも空でもないかを判定します。NULL でも空でもなければ true、それ以外は
false を返します。
+
+## 構文
+
+```sql
+NOT_NULL_OR_EMPTY (<str>)
+```
+
+## パラメータ
+- `<str>`: STRING 型。NULL または空かを判定する文字列。
+
+## 戻り値
+文字列が空文字列または NULL の場合は false、それ以外は true を返します。
+
+## 例
+1. 例 1
+ ```sql
+ select not_null_or_empty(null), not_null_or_empty(""), not_null_or_empty("
");
+ ```
+ ```text
+
+-------------------------+-----------------------+------------------------+
+ | not_null_or_empty(null) | not_null_or_empty("") | not_null_or_empty(" ")
|
+
+-------------------------+-----------------------+------------------------+
+ | 0 | 0 | 1
|
+
+-------------------------+-----------------------+------------------------+
+ ```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
new file mode 100644
index 00000000000..5c9035ce5c4
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md
@@ -0,0 +1,36 @@
+---
+{
+ "title": "NULL_OR_EMPTY",
+ "language": "ja",
+ "description": "指定した値が NULL または空かを判定します。"
+}
+---
+
+## 説明
+
+`null_or_empty` 関数は、指定した値が NULL または空かを判定します。NULL または空であれば true、それ以外は false
を返します。
+
+## 構文
+
+```sql
+NULL_OR_EMPTY (<str>)
+```
+
+## パラメータ
+- `<str>`: STRING 型。NULL または空かを判定する文字列。
+
+## 戻り値
+文字列が空文字列または NULL の場合は true、それ以外は false を返します。
+
+## 例
+1. 例 1
+ ```sql
+ select null_or_empty(null), null_or_empty(""), null_or_empty(" ");
+ ```
+ ```text
+ +---------------------+-------------------+--------------------+
+ | null_or_empty(null) | null_or_empty("") | null_or_empty(" ") |
+ +---------------------+-------------------+--------------------+
+ | 1 | 1 | 0 |
+ +---------------------+-------------------+--------------------+
+ ```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/nullif.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/nullif.md
new file mode 100644
index 00000000000..f0f933803fc
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/nullif.md
@@ -0,0 +1,63 @@
+---
+{
+ "title": "NULLIF",
+ "language": "ja",
+ "description": "二つの入力値が等しい場合は NULL、異なる場合は最初の入力値を返します。"
+}
+---
+
+## 説明
+
+二つの入力値が等しい場合は `NULL`、異なる場合は最初の入力値を返します。この関数は、次の `CASE WHEN` 式と同等です。
+
+```sql
+CASE
+ WHEN <expr1> = <expr2> THEN NULL
+ ELSE <expr1>
+END
+```
+
+## 構文
+
+```sql
+NULLIF(<expr1>, <expr2>)
+```
+
+## パラメータ
+- `<expr1>`: 比較する最初の入力値。サポートされる型は以下の使用上の注意を参照してください。
+- `<expr2>`: 最初の入力値と比較する二番目の値。サポートされる型は以下の使用上の注意を参照してください。
+
+## 使用上の注意
+パラメータでサポートされる型:
+1. Boolean
+2. 数値型（TinyInt、SmallInt、Int、BigInt、LargeInt、Float、Double、Decimal）
+3. 日付型（Date、DateTime、TimestampNs、Time）
+4. 文字列型（String、VARCHAR、CHAR）
+
+## 戻り値
+- `<expr1>` と `<expr2>` が等しい場合は `NULL` を返します。
+- それ以外の場合は `<expr1>` の値を返します。
+
+## 例
+1. 例 1
+ ```sql
+ SELECT NULLIF(1, 1);
+ ```
+ ```text
+ +--------------+
+ | NULLIF(1, 1) |
+ +--------------+
+ | NULL |
+ +--------------+
+ ```
+2. 例 2
+ ```sql
+ SELECT NULLIF(1, 0);
+ ```
+ ```text
+ +--------------+
+ | NULLIF(1, 0) |
+ +--------------+
+ | 1 |
+ +--------------+
+ ```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
new file mode 100644
index 00000000000..d140a20c0e1
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md
@@ -0,0 +1,88 @@
+---
+{
+ "title": "条件関数の概要",
+ "language": "ja",
+ "description": "条件関数は、SQL クエリで条件分岐を行うための組み込み関数です。"
+}
+---
+
+# 条件関数の概要
+
+条件関数は、SQL クエリで条件分岐を行うための組み込み関数です。指定した条件に応じて値を選択し、NULL を処理し、CASE 式のような分岐を実行できます。
+
+## ベクトル化実行と条件関数
+
+Doris はベクトル化実行エンジンです。一方、条件関数が直感に反する動作をする場合があります。
+
+次の例を見てください。
+
+```sql
+mysql> set enable_strict_cast = true;
+Query OK, 0 rows affected (0.00 sec)
+
+mysql> select count(
+ -> if(number < 128 ,
+ -> cast(number as tinyint),
+ -> cast(number as String))
+ -> ) from numbers("number" = "300");
+ERROR 1105 (HY000): errCode = 2, detailMessage =
(127.0.0.1)[INVALID_ARGUMENT]Value 128 out of range for type tinyint
+```
+
+この例では、`tinyint` への変換を `number < 128` の場合にだけ `if`
関数で行っていても、エラーが発生します。これは、`if(cond, colA, colB)` のような条件関数が従来、次の順序で実行されていたためです。
+
+1. まず `colA` と `colB` の両方をすべて計算します
+2. 次に `cond` の値に応じた結果を選択して返します
+
+そのため、`colA` の値が実際には使われなくても、`colA` はすべて計算されるため、エラーが発生します。
+
+`if`、`ifnull`、`case`、`coalesce` も同様に動作します。
+
+`LEAST` のような関数は、値の比較にすべてのパラメータを計算する必要があるため、この問題は生じません。
+
+## 短絡評価
+
+Doris 4.0.4 では、条件関数の実行ロジックを改善し、短絡評価を可能にしました。
+
+```sql
+mysql> set short_circuit_evaluation = true;
+Query OK, 0 rows affected (0.00 sec)
+
+mysql> select count(
+ -> if(number < 128 ,
+ -> cast(number as tinyint),
+ -> cast(number as String))
+ -> ) from numbers("number" = "300");
++--------------------------------------------------------------------------+
+| count(if(number < 128, cast(number as tinyint), cast(number as String))) |
++--------------------------------------------------------------------------+
+| 300 |
++--------------------------------------------------------------------------+
+```
+
+短絡評価を有効にすると、`if`、`ifnull`、`case`、`coalesce`
などは多くの場面で不要な計算を避けられます。これにより、エラーを防ぎ、性能を改善できます。
+
+### 短絡評価の有効化
+
+短絡評価を有効にするには、次のセッション変数を設定します。
+
+```sql
+SET short_circuit_evaluation = true;
+```
+
+### 短絡評価の利点
+
+1. **エラーの防止**: 条件によって選択されない分岐で、エラーを起こす処理を実行しません
+2. **性能の向上**: 必要な分岐のみを評価し、不要な計算を減らします
+3. **直感的な動作**: 条件関数が一般的なプログラミング言語の条件分岐に近い動作になります
+
+## 主な条件関数
+
+短絡評価の効果を得られる主な条件関数は次のとおりです。
+
+- `IF`: 条件に応じて二つの値のどちらかを返します
+- `IFNULL`: 最初の引数が NULL でなければその値を、NULL なら次の引数を返します
+- `CASE`: switch-case 文のように複数の条件分岐を提供します
+- `COALESCE`: 引数のリストから最初の NULL でない値を返します
+- `NULLIF`: 二つの引数が等しければ NULL を、異なれば最初の引数を返します
+
+各関数の詳細については、それぞれのドキュメントを参照してください。
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/convert-to.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/convert-to.md
new file mode 100644
index 00000000000..a99be78ebdb
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/convert-to.md
@@ -0,0 +1,73 @@
+---
+{
+ "title": "CONVERT_TO",
+ "language": "ja",
+ "description": "列の文字コードを指定した文字セットに変換します。"
+}
+---
+
+## 説明
+
+列の文字コードを指定した文字セットに変換します。通常、ORDER BY 句で中国語の文字を含む列をピンイン順に並べるために使用します。現在は `'gbk'`
への変換のみをサポートします。
+
+## 構文
+
+```sql
+CONVERT_TO(<column>, <character>)
+```
+
+## パラメータ
+
+| パラメータ | 説明 |
+| --- | --- |
+| `<column>` | 文字コードを変換する VARCHAR 型の列。 |
+| `<character>` | 変換先の文字セット。現在は `'gbk'` のみをサポートします。 |
+
+## 戻り値
+
+変換後の文字コードを持つ VARCHAR 値を返します。ORDER BY 句で使用すると、ピンイン順に並べられます。
+
+## 例
+
+<!-- setup-sql
+CREATE TABLE class_test (class_id INT, class_name VARCHAR(50), student_ids
ARRAY<INT>) DISTRIBUTED BY HASH(class_id) BUCKETS 1
PROPERTIES("replication_num"="1");
+INSERT INTO class_test VALUES
(1,'啊',[1]),(2,'哈',[2]),(3,'哦',[3]),(4,'张',[4]),(5,'我',[5]),(6,'asd',[6]),(7,'qwe',[7]),(8,'z',[8]);
+-->
+
+```sql
+SELECT * FROM class_test ORDER BY class_name;
+```
+
+```text
++----------+------------+-------------+
+| class_id | class_name | student_ids |
++----------+------------+-------------+
+| 6 | asd | [6] |
+| 7 | qwe | [7] |
+| 8 | z | [8] |
+| 2 | 哈 | [2] |
+| 3 | 哦 | [3] |
+| 1 | 啊 | [1] |
+| 4 | 张 | [4] |
+| 5 | 我 | [5] |
++----------+------------+-------------+
+```
+
+```sql
+SELECT * FROM class_test ORDER BY CONVERT_TO(class_name, 'gbk');
+```
+
+```text
++----------+------------+-------------+
+| class_id | class_name | student_ids |
++----------+------------+-------------+
+| 6 | asd | [6] |
+| 7 | qwe | [7] |
+| 8 | z | [8] |
+| 1 | 啊 | [1] |
+| 2 | 哈 | [2] |
+| 3 | 哦 | [3] |
+| 5 | 我 | [5] |
+| 4 | 张 | [4] |
++----------+------------+-------------+
+```
\ No newline at end of file
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/default.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/default.md
new file mode 100644
index 00000000000..e11ee59634b
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/default.md
@@ -0,0 +1,183 @@
+---
+{
+ "title": "DEFAULT",
+ "language": "ja"
+}
+---
+
+## 説明
+
+テーブル内の指定した列のデフォルト値を返します。列にデフォルト値がない場合はエラーになります。
+
+この関数の動作は MySQL の DEFAULT 関数と同じです。
+
+## 構文
+
+```sql
+DEFAULT(<column>)
+```
+
+## パラメータ
+
+| パラメータ | 説明 |
+| --- | --- |
+| `<column>` | デフォルト値を取得する列です。列のみを指定できます。それ以外はエラーになります。 |
+
+## 戻り値
+
+列と同じ型のデフォルト値を返します
+- デフォルト値が設定されている場合は、その値を返します
+- デフォルト値がなく、列に NOT NULL 制約もない場合は NULL を返します
+- デフォルト値がなく、列に NOT NULL 制約がある場合はエラーになります
+
+特殊なケース:
+- 入力には列のみを指定できます。NULL を含む定数や式を指定するとエラーになります
+- 入力が自動採番列または生成列の場合はエラーになります
+
+[Doris
がサポートするデフォルト値関連のパラメータ](../../../sql-statements/table-and-view/table/CREATE-TABLE.md#column-default-value-related-parameters)
+
+## 例
+
+1. 定数のデフォルト値を持つ非集約型
+```sql
+-- setup
+-- Columns without an explicitly defined DEFAULT accept only NULL as the
default value
+-- ARRAY type default values only accept `[]` and NULL
+CREATE TABLE test_default_scalar (
+ c_bool BOOLEAN NULL
DEFAULT 1,
+ c_tinyint TINYINT NULL
DEFAULT 7,
+ c_smallint SMALLINT NULL
DEFAULT 32000,
+ c_int INT NULL
DEFAULT 2147483647,
+ c_bigint BIGINT NULL
DEFAULT 9223372036854775807,
+ c_largeint LARGEINT NULL
DEFAULT '170141183460469231731687303715884105727',
+ c_float FLOAT NULL
DEFAULT 3.125,
+ c_double DOUBLE NULL
DEFAULT 2.718281828,
+ c_decimal DECIMAL(27, 9) NULL
DEFAULT '123456789.123456789',
+ c_decimal_compact DECIMAL(18, 4) NULL
DEFAULT '99999.1234',
+ c_pi DOUBLE NULL
DEFAULT PI,
+ c_e DOUBLE NULL
DEFAULT E,
+ c_char CHAR(8) NULL
DEFAULT 'charDemo',
+ c_varchar VARCHAR(32) NULL
DEFAULT '',
+ c_string STRING NULL
DEFAULT 'plain string',
+ c_datetime DATETIME NULL
DEFAULT '2025-10-25 11:22:33',
+ c_date DATE NULL
DEFAULT '2025-10-31',
+ c_json JSON NULL,
+ c_ipv4 IPV4 NULL
DEFAULT '192.168.1.1',
+ c_ipv6 IPV6 NULL
DEFAULT '2001:db8::1',
+ c_array_int ARRAY<INT> NULL
DEFAULT '[]',
+ c_array_string ARRAY<STRING> NULL,
+ c_map_str_int MAP<STRING, INT> NULL,
+ c_struct STRUCT<f1:INT,f2:STRING,f3:BOOLEAN> NULL,
+ c_variant VARIANT NULL
+) PROPERTIES ( 'replication_num' = '1');
+
+-- INSERT statements omitted in the example
+SELECT
+ DEFAULT(c_bool),
+ DEFAULT(c_tinyint),
+ DEFAULT(c_smallint),
+ DEFAULT(c_int),
+ DEFAULT(c_bigint),
+ DEFAULT(c_largeint),
+ DEFAULT(c_float),
+ DEFAULT(c_double),
+ DEFAULT(c_decimal),
+ DEFAULT(c_decimal_compact),
+ DEFAULT(c_pi),
+ DEFAULT(c_e),
+ DEFAULT(c_char),
+ DEFAULT(c_varchar),
+ DEFAULT(c_string),
+ DEFAULT(c_datetime),
+ DEFAULT(c_date),
+ DEFAULT(c_json),
+ DEFAULT(c_ipv4),
+ DEFAULT(c_ipv6),
+ DEFAULT(c_array_int),
+ DEFAULT(c_array_string),
+ DEFAULT(c_map_str_int),
+ DEFAULT(c_struct),
+ DEFAULT(c_variant)
+FROM test_default_scalar
+LIMIT 1;
+```
+```text
++-----------------+--------------------+---------------------+----------------+---------------------+-----------------------------------------+------------------+-------------------+---------------------+----------------------------+-------------------+-------------------+-----------------+--------------------+-------------------+---------------------+-----------------+-----------------+-----------------+-----------------+----------------------+-------------------------+-----------------
[...]
+| DEFAULT(c_bool) | DEFAULT(c_tinyint) | DEFAULT(c_smallint) | DEFAULT(c_int)
| DEFAULT(c_bigint) | DEFAULT(c_largeint) |
DEFAULT(c_float) | DEFAULT(c_double) | DEFAULT(c_decimal) |
DEFAULT(c_decimal_compact) | DEFAULT(c_pi) | DEFAULT(c_e) |
DEFAULT(c_char) | DEFAULT(c_varchar) | DEFAULT(c_string) | DEFAULT(c_datetime)
| DEFAULT(c_date) | DEFAULT(c_json) | DEFAULT(c_ipv4) | DEFAULT(c_ipv6) |
DEFAULT(c_array_int) | DEFAULT(c_array_string) | DEFAULT(c_map_st [...]
++-----------------+--------------------+---------------------+----------------+---------------------+-----------------------------------------+------------------+-------------------+---------------------+----------------------------+-------------------+-------------------+-----------------+--------------------+-------------------+---------------------+-----------------+-----------------+-----------------+-----------------+----------------------+-------------------------+-----------------
[...]
+| 1 | 7 | 32000 | 2147483647
| 9223372036854775807 | 170141183460469231731687303715884105727 |
3.125 | 2.718281828 | 123456789.123456789 | 99999.1234 |
3.141592653589793 | 2.718281828459045 | charDemo | |
plain string | 2025-10-25 11:22:33 | 2025-10-31 | NULL |
192.168.1.1 | 2001:db8::1 | [] | NULL
| NULL [...]
++-----------------+--------------------+---------------------+----------------+---------------------+-----------------------------------------+------------------+-------------------+---------------------+----------------------------+-------------------+-------------------+-----------------+--------------------+-------------------+---------------------+-----------------+-----------------+-----------------+-----------------+----------------------+-------------------------+-----------------
[...]
+```
+
+2. 集約型の例
+```sql
+CREATE TABLE test_default_agg (
+ k_id INT NOT NULL COMMENT 'aggregation key',
+ bitmap_col BITMAP BITMAP_UNION,
+ hll_col HLL HLL_UNION,
+ quantile_col QUANTILE_STATE QUANTILE_UNION
+) AGGREGATE KEY(k_id)
+PROPERTIES ( 'replication_num' = '1' );
+
+SELECT
+ default(bitmap_col),default(hll_col)
+FROM test_default_agg
+LIMIT 1;
+```
+```text
++---------------------+------------------+
+| default(bitmap_col) | default(hll_col) |
++---------------------+------------------+
+| NULL | NULL |
++---------------------+------------------+
+```
+
+3. 定数ではないデフォルト値（`CURRENT_TIMESTAMP`、`CURRENT_DATE`）の例:
+```sql
+CREATE TABLE test_default_time(
+ tm DATETIME(5) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
+ dt DATE DEFAULT CURRENT_DATE
+) PROPERTIES( 'replication_num' = '1' );
+
+SELECT DEFAULT(tm), DEFAULT(dt) FROM test_default_time;
+```
+```text
++---------------------------+-------------+
+| DEFAULT(tm) | DEFAULT(dt) |
++---------------------------+-------------+
+| 2026-01-23 17:32:10.90500 | 2026-01-23 |
++---------------------------+-------------+
+```
+
+4. 定数値
+```sql
+SELECT DEFAULT('hello');
+-- ERROR 1105 (HY000): errCode = 2, detailMessage =
+-- mismatched input ''hello'' expecting {'{', '}', 'ACTIONS', 'AFTER',
'AGG_STATE', 'AGGREGATE', 'ALIAS', 'ANALYZED', 'ARRAY', 'AT', 'AUTHORS',
'AUTO_INCREMENT', 'ALWAYS', 'BACKENDS', 'BACKUP', 'BEGIN', 'BELONG', 'BIN',
'BITAND', 'BITMAP', 'BITMAP_EMPTY', 'BITMAP_UNION', 'BITOR', 'BITXOR', 'BLOB',
'BOOLEAN', 'BRANCH', 'BRIEF', 'BROKER', 'BUCKETS', 'BUILD', 'BUILTIN', 'CACHE',
'CACHED', 'CALL', 'CATALOG', 'CATALOGS', 'CHAIN', CHAR, 'CHARSET', 'CHECK',
'CLUSTER', 'CLUSTERS', 'COLLA
+
+SELECT DEFAULT(NULL);
+-- ERROR 1105 (HY000): errCode = 2, detailMessage =
+-- mismatched input 'NULL' expecting {'{', '}', 'ACTIONS', 'AFTER',
'AGG_STATE', 'AGGREGATE', 'ALIAS', 'ANALYZED', 'ARRAY', 'AT', 'AUTHORS',
'AUTO_INCREMENT', 'ALWAYS', 'BACKENDS', 'BACKUP', 'BEGIN', 'BELONG', 'BIN',
'BITAND', 'BITMAP', 'BITMAP_EMPTY', 'BITMAP_UNION', 'BITOR', 'BITXOR', 'BLOB',
'BOOLEAN', 'BRANCH', 'BRIEF', 'BROKER', 'BUCKETS', 'BUILD', 'BUILTIN', 'CACHE',
'CACHED', 'CALL', 'CATALOG', 'CATALOGS', 'CHAIN', CHAR, 'CHARSET', 'CHECK',
'CLUSTER', 'CLUSTERS', 'COLLATIO
+```
+
+5. 自動採番列
+```sql
+CREATE TABLE test_auto_inc (
+ id BIGINT NULL AUTO_INCREMENT,
+ value BIGINT NOT NULL
+) PROPERTIES ('replication_num' = '1' );
+
+INSERT INTO test_auto_inc(value) VALUES (1), (2);
+--ERROR 1105 (HY000): errCode = 2, detailMessage = Column 'id' has no default
value and does not allow NULL or column is auto-increment
+```
+
+6. 生成列
+```sql
+CREATE TABLE test_gen_col (
+ a INT,
+ b INT AS (a + 10)
+) PROPERTIES ('replication_num' = '1' );
+
+SELECT DEFAULT(b) FROM test_gen_col;
+-- ERROR 1105 (HY000): errCode = 2, detailMessage = DEFAULT cannot be used on
generated column 'b'
+```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/esquery.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/esquery.md
new file mode 100644
index 00000000000..992d4b35743
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/esquery.md
@@ -0,0 +1,59 @@
+---
+{
+ "title": "ESQUERY",
+ "language": "ja",
+ "description": "ESQUERY(<field>, <querydsl>) 関数を使用すると、SQL では表現できない検索条件を
Elasticsearch にプッシュダウンして絞り込めます。"
+}
+---
+
+## 説明
+
+`ESQUERY(<field>, <query_dsl>)` 関数を使用すると、SQL では表現できない検索条件を Elasticsearch
にプッシュダウンして絞り込めます。最初のパラメータ `<field>` はインデックスの関連付けに使用します。二番目の `<query_dsl>` は基本的な
Elasticsearch Query DSL を表す JSON 式です。JSON は波括弧 `{}` で囲み、ルートキーを一つだけ含める必要があります（例:
`match_phrase`、`geo_shape`、`bool`）。
+
+## 構文
+
+```sql
+ESQUERY(<field>, <query_dsl>)
+```
+
+## パラメータ
+
+| パラメータ | 説明 |
+| --- | --- |
+| `<field>` | 検索対象のフィールド。インデックスの関連付けに使用します。 |
+| `<query_dsl>` | Elasticsearch Query DSL を表す JSON 式です。`{}`
で囲み、ルートキーを一つだけ含める必要があります（例: `match_phrase`、`geo_shape`、`bool`）。 |
+
+## 戻り値
+
+ドキュメントが指定した Elasticsearch Query DSL に一致するかを示す真偽値を返します。
+
+## 例
+
+```sql
+-- match_phrase SQL:
+SELECT * FROM es_table
+WHERE ESQUERY(k4, '{
+ "match_phrase": {
+ "k4": "doris on es"
+ }
+}');
+```
+
+```sql
+-- geo_shape SQL:
+SELECT * FROM es_table
+WHERE ESQUERY(k4, '{
+ "geo_shape": {
+ "location": {
+ "shape": {
+ "type": "envelope",
+ "coordinates": [
+ [13, 53],
+ [14, 52]
+ ]
+ },
+ "relation": "within"
+ }
+ }
+}');
+```
\ No newline at end of file
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/field.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/field.md
new file mode 100644
index 00000000000..c665067d6c2
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/field.md
@@ -0,0 +1,141 @@
+---
+{
+ "title": "FIELD",
+ "language": "ja",
+ "description": "値のリスト <param> [, ...] で <expr> が最初に現れる位置を返します。<expr>
が見つからない場合は 0 を返します。"
+}
+---
+
+## 説明
+
+`<expr>` が値のリスト `<param> [, ...]` に最初に現れる位置を返します。
+`<expr>` が見つからない場合は `0` を返します。通常、`ORDER BY` で独自の並び順を指定するために使用します。
+
+## 構文
+
+```sql
+FIELD(<expr>, <param> [, ...])
+```
+
+## パラメータ
+
+| パラメータ | 説明 |
+| --- | --- |
+| `<expr>` | パラメータのリストから検索する値。 |
+| `<param>` | `<expr>` と比較する値の列。 |
+
+## 戻り値
+
+- 1 から始まるインデックスで、`<expr>` が `<param>` の値のリスト内に現れる位置を返します。
+- `<expr>` が見つからない場合は `0` を返します。
+- `<expr>` が `NULL` の場合は `0` を返します。
+
+## 例
+
+```sql
+-- setup
+CREATE TABLE baseall (k1 INT, k7 VARCHAR(64))
+DISTRIBUTED BY HASH(k1) BUCKETS 1
+PROPERTIES ("replication_num" = "1");
+
+INSERT INTO baseall VALUES
+ (1, 'wangjing04'),
+ (2, 'wangyu14'),
+ (3, 'yuanyuan06');
+
+CREATE TABLE class_test (class_name VARCHAR(64))
+DISTRIBUTED BY HASH(class_name) BUCKETS 1
+PROPERTIES ("replication_num" = "1");
+
+INSERT INTO class_test VALUES
+ ('Suzi'), ('Suzi'),
+ ('Ben'), ('Ben'),
+ ('Henry'), ('Henry'),
+ (NULL);
+```
+
+```sql
+SELECT FIELD(2, 3, 1, 2, 5);
+```
+
+```text
++----------------------+
+| FIELD(2, 3, 1, 2, 5) |
++----------------------+
+| 3 |
++----------------------+
+```
+
+```sql
+SELECT k1, k7 FROM baseall WHERE k1 IN (1,2,3) ORDER BY FIELD(k1, 2, 1, 3);
+```
+
+```text
++------+------------+
+| k1 | k7 |
++------+------------+
+| 2 | wangyu14 |
+| 1 | wangjing04 |
+| 3 | yuanyuan06 |
++------+------------+
+```
+
+文字列を独自の順序で並べます。`FIELD` はリストにない値に対して `0` を返し、これには `NULL` も含まれます。このため、デフォルトの昇順では
`NULL` の行が先頭に並びます。
+
+```sql
+SELECT class_name FROM class_test ORDER BY FIELD(class_name, 'Suzi', 'Ben',
'Henry');
+```
+
+```text
++------------+
+| class_name |
++------------+
+| NULL |
+| Suzi |
+| Suzi |
+| Ben |
+| Ben |
+| Henry |
+| Henry |
++------------+
+```
+
+降順では `NULL`（FIELD = 0）が最後に並びます。
+
+```sql
+SELECT class_name FROM class_test ORDER BY FIELD(class_name, 'Suzi', 'Ben',
'Henry') DESC;
+```
+
+```text
++------------+
+| class_name |
++------------+
+| Henry |
+| Henry |
+| Ben |
+| Ben |
+| Suzi |
+| Suzi |
+| NULL |
++------------+
+```
+
+`NULLS FIRST` / `NULLS LAST` を使用すると、並び順とは独立に `NULL` の位置を制御できます。
+
+```sql
+SELECT class_name FROM class_test ORDER BY FIELD(class_name, 'Suzi', 'Ben',
'Henry') NULLS FIRST;
+```
+
+```text
++------------+
+| class_name |
++------------+
+| NULL |
+| Suzi |
+| Suzi |
+| Ben |
+| Ben |
+| Henry |
+| Henry |
++------------+
+```
\ No newline at end of file
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/grouping-id.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/grouping-id.md
new file mode 100644
index 00000000000..01c911240d3
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/grouping-id.md
@@ -0,0 +1,98 @@
+---
+{
+ "title": "GROUPING_ID",
+ "language": "ja",
+ "description": "GROUP BY クエリの各行のグループ化レベルを計算します。"
+}
+---
+
+## 説明
+
+GROUP BY クエリの各行のグループ化レベルを計算します。GROUPING_ID 関数は、出力行について GROUP BY
リスト内のどの列が集約されていないかを示す整数のビットマップを返します。GROUP BY を指定した場合、SELECT リスト、HAVING 句、ORDER
BY 句で使用できます。
+
+## 構文
+
+```sql
+GROUPING_ID(<column_expression> [, ...])
+```
+
+## パラメータ
+
+| パラメータ | 説明 |
+| --- | --- |
+| `<column_expression>` | GROUP BY 句に含まれる列式。 |
+
+## 戻り値
+
+指定した列のグループ化ビットマップを表す BIGINT 値を返します。
+
+## 例
+
+### 例 A: グループ化レベルの判定
+
+```sql
+SELECT
+ department,
+ CASE
+ WHEN GROUPING_ID(department, level) = 0 THEN level
+ WHEN GROUPING_ID(department, level) = 1 THEN CONCAT('Total: ', department)
+ WHEN GROUPING_ID(department, level) = 3 THEN 'Total: Company'
+ ELSE 'Unknown'
+ END AS `Job Title`,
+ COUNT(uid) AS `Employee Count`
+FROM employee
+GROUP BY ROLLUP(department, level)
+ORDER BY GROUPING_ID(department, level) ASC;
+```
+
+*想定される出力:*
+
+```text
++--------------------+---------------------------+----------------+
+| department | Job Title | Employee Count |
++--------------------+---------------------------+----------------+
+| Board of Directors | Senior | 2 |
+| Technology | Senior | 3 |
+| Sales | Senior | 1 |
+| Sales | Assistant | 2 |
+| Sales | Trainee | 1 |
+| Marketing | Senior | 1 |
+| Marketing | Trainee | 2 |
+| Marketing | Assistant | 1 |
+| Board of Directors | Total: Board of Directors | 2 |
+| Technology | Total: Technology | 3 |
+| Sales | Total: Sales | 4 |
+| Marketing | Total: Marketing | 4 |
+| NULL | Total: Company | 13 |
++--------------------+---------------------------+----------------+
+```
+
+### 例 B: GROUPING_ID を使用した結果の絞り込み
+
+```sql
+SELECT
+ department,
+ CASE
+ WHEN GROUPING_ID(department, level) = 0 THEN level
+ WHEN GROUPING_ID(department, level) = 1 THEN CONCAT('Total: ', department)
+ WHEN GROUPING_ID(department, level) = 3 THEN 'Total: Company'
+ ELSE 'Unknown'
+ END AS `Job Title`,
+ COUNT(uid) AS `Count`
+FROM employee
+GROUP BY ROLLUP(department, level)
+HAVING `Job Title` = 'Senior';
+```
+
+*想定される出力:*
+
+```text
++--------------------+-----------+-------+
+| department | Job Title | Count |
++--------------------+-----------+-------+
+| Board of Directors | Senior | 2 |
+| Technology | Senior | 3 |
+| Sales | Senior | 1 |
+| Marketing | Senior | 1 |
++--------------------+-----------+-------+
+```
\ No newline at end of file
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/grouping.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/grouping.md
new file mode 100644
index 00000000000..10a88bde641
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/grouping.md
@@ -0,0 +1,78 @@
+---
+{
+ "title": "GROUPING",
+ "language": "ja",
+ "description": "指定した GROUP BY の列式が集約されているかを示します。集約されている場合、GROUPING は 1
を返します。"
+}
+---
+
+## 説明
+
+指定した GROUP BY の列式が集約されているかを示します。ROLLUP、CUBE、GROUPING SETS によって生成された集計行の列なら
1、集約されていない列なら 0 を返します。これらの操作が生成した NULL と、データ内の実際の NULL を区別するために使用します。
+
+## 構文
+
+```sql
+GROUPING( <column_expression> )
+```
+
+## パラメータ
+
+| パラメータ | 説明 |
+| --- | --- |
+| `<column_expression>` | GROUP BY 句に含まれる列または式。 |
+
+## 戻り値
+
+BIGINT 値を返します。指定した列式が集約されている場合は 1、集約されていない場合は 0 を返します。
+
+## 例
+
+次の例では `camp` 列でグループ化し、`occupation` の件数を集計します。`camp` 列に GROUPING 関数を適用し、ROLLUP
で追加された集計行とデータ内の実際の NULL 値を区別します。
+
+```sql
+CREATE TABLE `roles` (
+ role_id INT,
+ occupation VARCHAR(32),
+ camp VARCHAR(32),
+ register_time DATE
+)
+UNIQUE KEY(role_id)
+DISTRIBUTED BY HASH(role_id) BUCKETS 1
+PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1"
+);
+
+INSERT INTO `roles` VALUES
+(0, 'who am I', NULL, NULL),
+(1, 'mage', 'alliance', '2018-12-03 16:11:28'),
+(2, 'paladin', 'alliance', '2018-11-30 16:11:28'),
+(3, 'rogue', 'horde', '2018-12-01 16:11:28'),
+(4, 'priest', 'alliance', '2018-12-02 16:11:28'),
+(5, 'shaman', 'horde', NULL),
+(6, 'warrior', 'alliance', NULL),
+(7, 'warlock', 'horde', '2018-12-04 16:11:28'),
+(8, 'hunter', 'horde', NULL);
+
+SELECT
+ camp,
+ COUNT(occupation) AS occ_cnt,
+ GROUPING(camp) AS grouping
+FROM
+ `roles`
+GROUP BY
+ ROLLUP(camp);
+```
+
+結果の `camp` 列には二つの NULL 値が表示されます。GROUPING 値が 1 の最初の NULL は、すべての `camp`
グループを集計した ROLLUP の集計行です。GROUPING 値が 0 の次の NULL は、データ内の実際の NULL 値です。
+
+```text
++----------+---------+----------+
+| camp | occ_cnt | grouping |
++----------+---------+----------+
+| NULL | 9 | 1 |
+| NULL | 1 | 0 |
+| alliance | 4 | 0 |
+| horde | 4 | 0 |
++----------+---------+----------+
+```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-percent.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-percent.md
new file mode 100644
index 00000000000..df31e61b158
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-percent.md
@@ -0,0 +1,61 @@
+---
+{
+ "title": "QUANTILE_PERCENT",
+ "language": "ja",
+ "description": "QUANTILEPERCENT 関数は、指定した割合に対応する分位値を計算します。"
+}
+---
+
+## 説明
+
+`QUANTILE_PERCENT` 関数は、指定した割合に対応する分位値を計算します。quantile_state
列と、割合を表す浮動小数点の定数をパラメータとして受け取ります。戻り値は、指定した割合の位置にある分位値を表す浮動小数点数です。
+
+## 構文
+
+```sql
+QUANTILE_PERCENT(<quantile_state>, <percent>)
+```
+
+## パラメータ
+
+| パラメータ | 説明 |
+| --- | --- |
+| `<quantile_state>` | 対象の列。 |
+| `<percent>` | 対象の割合。 |
+
+## 戻り値
+
+分位値を表す `Double` 型の値。
+
+## 例
+
+```sql
+CREATE TABLE IF NOT EXISTS quantile_state_agg_test (
+ `dt` int(11) NULL COMMENT "",
+ `id` int(11) NULL COMMENT "",
+ `price` quantile_state QUANTILE_UNION NOT NULL COMMENT ""
+ ) ENGINE=OLAP
+ AGGREGATE KEY(`dt`, `id`)
+ COMMENT "OLAP"
+ DISTRIBUTED BY HASH(`dt`) BUCKETS 1
+ PROPERTIES ("replication_num" = "1");
+
+INSERT INTO quantile_state_agg_test VALUES(20220201,0, to_quantile_state(1,
2048));
+
+INSERT INTO quantile_state_agg_test VALUES(20220201,1, to_quantile_state(-1,
2048)),
+ (20220201,1, to_quantile_state(0, 2048)),(20220201,1,
to_quantile_state(1, 2048)),
+ (20220201,1, to_quantile_state(2, 2048)),(20220201,1,
to_quantile_state(3, 2048));
+
+SELECT dt, id, quantile_percent(quantile_union(price), 0) FROM
quantile_state_agg_test GROUP BY dt, id ORDER BY dt, id
+```
+
+結果:
+
+```text
++----------+------+--------------------------------------------+
+| dt | id | quantile_percent(quantile_union(price), 0) |
++----------+------+--------------------------------------------+
+| 20220201 | 0 | 1 |
+| 20220201 | 1 | -1 |
++----------+------+--------------------------------------------+
+```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-state-empty.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-state-empty.md
new file mode 100644
index 00000000000..87be6e82be1
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-state-empty.md
@@ -0,0 +1,37 @@
+---
+{
+ "title": "QUANTILE_STATE_EMPTY",
+ "language": "ja",
+ "description": "空の quantilestate 型の列を返します。"
+}
+---
+
+## 説明
+
+空の `quantile_state` 型の列を返します。
+
+## 構文
+
+```sql
+QUANTILE_STATE_EMPTY()
+```
+
+## 戻り値
+
+空の `quantile_state` 型の列。
+
+## 例
+
+```sql
+select quantile_percent(quantile_union(quantile_state_empty()), 0)
+```
+
+結果:
+
+```text
++-------------------------------------------------------------+
+| quantile_percent(quantile_union(quantile_state_empty()), 0) |
++-------------------------------------------------------------+
+| NULL |
++-------------------------------------------------------------+
+```
diff --git
a/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
new file mode 100644
index 00000000000..ec1f8f97361
--- /dev/null
+++
b/i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md
@@ -0,0 +1,61 @@
+---
+{
+ "title": "TO_QUANTILE_STATE",
+ "language": "ja",
+ "description": "数値型を QUANTILESTATE 型に変換します。compression パラメータは省略可能で、範囲
[2048, 10000] の値を設定できます。"
+}
+---
+
+## 説明
+
+数値型を `QUANTILE_STATE` 型に変換します。compression パラメータは省略可能で、範囲 [2048, 10000]
の値を設定できます。値を大きくすると、その後の分位値の近似計算の精度が上がる一方、メモリ使用量と計算時間も増えます。パラメータを省略した場合、または
[2048, 10000] の範囲外の値を指定した場合は、デフォルト値の 2048 で実行します。
+
+## 構文
+
+```sql
+TO_QUANTILE_STATE(<raw_data>, <compression>)
+```
+
+## パラメータ
+
+| パラメータ | 説明 |
+| --- | --- |
+| `<raw_data>` | 対象の列。 |
+| `<compression>` | 圧縮のしきい値。 |
+
+## 戻り値
+
+変換後の `QUANTILE_STATE` 型の列。
+
+## 例
+
+```sql
+CREATE TABLE IF NOT EXISTS quantile_state_agg_test (
+ `dt` int(11) NULL COMMENT "",
+ `id` int(11) NULL COMMENT "",
+ `price` quantile_state QUANTILE_UNION NOT NULL COMMENT ""
+ ) ENGINE=OLAP
+ AGGREGATE KEY(`dt`, `id`)
+ COMMENT "OLAP"
+ DISTRIBUTED BY HASH(`dt`) BUCKETS 1
+ PROPERTIES ("replication_num" = "1");
+
+INSERT INTO quantile_state_agg_test VALUES(20220201,0, to_quantile_state(1,
2048));
+
+INSERT INTO quantile_state_agg_test VALUES(20220201,1, to_quantile_state(-1,
2048)),
+ (20220201,1, to_quantile_state(0, 2048)),(20220201,1,
to_quantile_state(1, 2048)),
+ (20220201,1, to_quantile_state(2, 2048)),(20220201,1,
to_quantile_state(3, 2048));
+
+SELECT dt, id, quantile_percent(quantile_union(price), 0) FROM
quantile_state_agg_test GROUP BY dt, id ORDER BY dt, id
+```
+
+結果:
+
+```text
++----------+------+--------------------------------------------+
+| dt | id | quantile_percent(quantile_union(price), 0) |
++----------+------+--------------------------------------------+
+| 20220201 | 0 | 1 |
+| 20220201 | 1 | -1 |
++----------+------+--------------------------------------------+
+```
diff --git a/translations/inventory/ja/2026-10-12/batches.md
b/translations/inventory/ja/2026-10-12/batches.md
index d40d2f60b9f..753908a84da 100644
--- a/translations/inventory/ja/2026-10-12/batches.md
+++ b/translations/inventory/ja/2026-10-12/batches.md
@@ -1877,7 +1877,7 @@ source/target state recorded; version-specific build and
Japanese proofreading r
## T09-DEV-059
-Status: TODO. PR: none. Japanese proofreading: pending.
+Status: IN_PROGRESS. [PR
#4225](https://github.com/apache/doris-website/pull/4225) proposes all 20 Dev
Japanese targets from master `3ddf1a2b41`. Independent machine-review state
records are present. Japanese proofreading is not recorded.
Dependencies: T03 and T04. Pages: 20. Remaining in DEV after this batch: 457.
diff --git a/translations/state/ja/docs.json b/translations/state/ja/docs.json
index 397c47286e3..36a6cccc806 100644
--- a/translations/state/ja/docs.json
+++ b/translations/state/ja/docs.json
@@ -2755,6 +2755,346 @@
"translatedAt": "2026-10-13T05:31:05.000Z",
"glossaryVersion": "0"
},
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/other-functions/convert-to",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/other-functions/convert-to.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/convert-to.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"0c2a92a5fe1b5c0e3ed998b82bcb93d5bdb04bb9661f8616527acf74984baac2",
+ "sourceTechnicalHash":
"83c04925654d85173138efdd42dd34d09f13abb2036f424f2e09f3b0123856d7",
+ "targetHash":
"93c9ebb3eea803b121719aa348196f6add498a09abd28ec408ca6611420e592e",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.920Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/other-functions/esquery",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/other-functions/esquery.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/esquery.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"b6b56e7f09490b15a711d52df479a213213cd68855efabc7eb173d433b0e9525",
+ "sourceTechnicalHash":
"1bd614a428635458a983db44a025ad7220ec0191f51f44755c0fbf6a476c8fe4",
+ "targetHash":
"83176b8d1d3e2928018502885f6eeba7a0f7cf79ac3194d530531c7a069d86b5",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.923Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/other-functions/default",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/other-functions/default.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/default.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"10ddfda50675f7d625f9ce2b61284744bcf8a0bead1fe753e14984d7c0db78ea",
+ "sourceTechnicalHash":
"5ec3cf65ad4e25fb72a4b5f4abcb256332bdd1dfdd524d4085de3abd0e19b414",
+ "targetHash":
"183f5b7d388116812e367e78fe73681c52a1332011673776ce374acda181d608",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.932Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/other-functions/field",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/other-functions/field.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/field.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"0e8320815aeb8d01d02cd3e2c4aa1077973917dceec95eb89b4bee3f5ee7e6ca",
+ "sourceTechnicalHash":
"6bb9424fa3790c2f471b7ae53c1db7f6cd36b1261fba41188d7211e039dfee4e",
+ "targetHash":
"3f91eb0dfdb7ef0b3139e79911ca037bfd5b5e168ea5d64998fb13d5d36f4b33",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.937Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/other-functions/grouping",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/other-functions/grouping.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/grouping.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"a2404e22f33b5c8323720ffdcfad1c229c8952aebd1eedd4330818725eb8a2ac",
+ "sourceTechnicalHash":
"bb0e553e9afb9888a6136098fe89a0583a8c09ff123bf0a15e646c481ddf9605",
+ "targetHash":
"4f942de3623abd3c0e637159cbb245db4c315a0a0c4461e37a7db27dbbe5c0a8",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.940Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/other-functions/grouping-id",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/other-functions/grouping-id.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/other-functions/grouping-id.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"7128e42f3604f9db791b26f369f84d0a72425d4af72a14e41efad1f6d97ab711",
+ "sourceTechnicalHash":
"d6c20426601c5c3caf61224eb6e7fc529dacfd3df852b7098a8bc449b731ec4f",
+ "targetHash":
"7ad90d850f3081f086847e3e0eff14b890dfca216cfe3206296f405a1fcfd861",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.943Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-percent",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-percent.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-percent.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"09fd31ec61d42d9358650414d9dac519c9a0f33e85e5c4463fb36a8d38116feb",
+ "sourceTechnicalHash":
"17ec74bfa38fac9a784437da259f100fd903ac1bc4b73fd483dece1bddf3720a",
+ "targetHash":
"dff96d60431f1fd36e9e81fee18c369d45684acc099544bb5c75c6c9ada7cc2d",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.944Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-state-empty",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-state-empty.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/quantile-state-empty.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"ad68f80f3e8aad6aa3b2bc705456ba8815e883f69d5d672cc4dc96caac1c5f5a",
+ "sourceTechnicalHash":
"a4d009e38f7044bce980741fa199f4b2fb8f4ce8129714dddc1b621cb3e3e4f6",
+ "targetHash":
"129e421495924f9a0c3ee4241a209673f4fb903705ed17a874788743b0e9cc53",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.945Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/quantile-functions/to-quantile-state.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"c3afd2fe565bf0867d51713495c010dd060689a399f70b955189431776c991c0",
+ "sourceTechnicalHash":
"d2650efd6db83f2291449471e91e217f1d9b53c585634f94ea78a18ed6216ddd",
+ "targetHash":
"49904de9d4b6c785777e6bc713a0eda4351bb225cf4515dc05d7ad1af81d69ff",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.947Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/conditional-functions/overview",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/overview.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"c8038fa0d3a3d1fa38f4fdc76dcb266e5843c35c9c8053d76df2da7ebba0e0e0",
+ "sourceTechnicalHash":
"49d30745bfc39b64f139faf000902193b7c87b8bc6b58ff34e3230155a3dd67e",
+ "targetHash":
"5a9d9b94dad287726b597f853a81369da01b326e903b0542407a74b556291f5e",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.950Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/conditional-functions/coalesce",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/conditional-functions/coalesce.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/coalesce.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"4b807805cb3233fd482c170bd812dbcc1b52b7e797d23e7a83a37cd89dc05c35",
+ "sourceTechnicalHash":
"9bf741a403bc6bfbd5854e49c7b87da135a7f8c06821820c0e9d9eb3e710bb50",
+ "targetHash":
"e67ca56773e727b4776f4c148515857fa0a3393b519959ed28e8bf0321d9d07e",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.953Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/conditional-functions/greatest",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/conditional-functions/greatest.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/greatest.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"ab0b3fed6636259a7786ee410f0ac1c01ad45f4ad80069905783d3fe9c01616c",
+ "sourceTechnicalHash":
"6a9675df0cc1a15b9cb1e6419ded0fac9d08b79f84993580f9d0f381390fc8f3",
+ "targetHash":
"880a7434f71d5fb292ed38580f1cfc1de54b98414fa6024d77fdf6e806c5bd5f",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.956Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/conditional-functions/if",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/conditional-functions/if.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/if.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"e3b270b9a20228ddc7bb5762f226545ecae1356600c238fec830a24349babfbd",
+ "sourceTechnicalHash":
"eec4d107e95e61b38a67c40a7d1f8a1dbf387b26f25930078e9d8a477c53d362",
+ "targetHash":
"8ec0e35da71aacd9af8651afd640b303e60bb7123de78d976b5f3796d768384a",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.959Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/conditional-functions/ifnull",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/conditional-functions/ifnull.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/ifnull.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"d0f609d1981091bbff0f7466f6f2b25eacfbef73178dd90febcd7e64e541694b",
+ "sourceTechnicalHash":
"17964768f14060293132cdf2a28f1a4aa6bb563c9979aa6247082ce5cda48a2a",
+ "targetHash":
"cffce90eee73b15e0bdb27b987893e8c33b50056e327e2287a9539c10d2e5c05",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.960Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/conditional-functions/least",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/conditional-functions/least.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/least.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"411df88e676c8aaffd125ee793d1098971660e8bafa965660211b2f09c0c6e22",
+ "sourceTechnicalHash":
"ac357f5fdc5b694b0118a990495e6ff7f6824dbc5ea18a50306fe13f087377e3",
+ "targetHash":
"170047864bfe898c11f5441873f532e7caf4f154e0f8f6c158452d4716160664",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.964Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/not-null-or-empty.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"80cd081f2677fa4fd60495232e12ba3305a2da4e7d8e905fcd93fc2b4363b93b",
+ "sourceTechnicalHash":
"8d90044786488f1bdbeef5e52f54e79c1766321ab8fd666d1ed8ac588cb3a0b1",
+ "targetHash":
"7ebc149acf4e916f59b7f3ce0daa31691414001ad4828d1242cbf1ec1d1d0b93",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.965Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/null-or-empty.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"ac7ca44133ef24bdd588af8f8dd99a6a6d58a7a85760f14666faafb62997be65",
+ "sourceTechnicalHash":
"aa973d0b30d7ca9887e3e3f5e7cc631f02314e901ad592816f4dd3a4cac4bdcd",
+ "targetHash":
"8e1a4a67da5012506a903ff7bde01b1577b83ffdebf9d339ca377cc01da51209",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.966Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId":
"sql-manual/sql-functions/scalar-functions/conditional-functions/nullif",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/scalar-functions/conditional-functions/nullif.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/conditional-functions/nullif.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"ae99910bf88a5a9f3324e03b6f7b58430993532f1a9be6ce4d5e64cc2c34371c",
+ "sourceTechnicalHash":
"c51d3a636fdaa932d2ea5178d830439c2a3c082b9c5c3591e5bf4712495cd944",
+ "targetHash":
"83d8ad0c73d250718cd6b576a57b7ca96e04cefb9d632b250489750297f98c11",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.968Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId": "sql-manual/sql-functions/aggregate-functions/ai-agg",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/aggregate-functions/ai-agg.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/ai-agg.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"f02c0c3cc608cc4a6bff781a4e365dd45e89fd5f2f25390496cc9686cda3253b",
+ "sourceTechnicalHash":
"c0577ab6b324d36aae0633b2f937a6d875c4707bba3c389f26ee6e4cf79ce3c0",
+ "targetHash":
"36aabf1b9f2c6873d6eb620d09ed362e838f6788bea7e0f39f29bb511124c418",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.971Z",
+ "glossaryVersion": "0"
+ },
+ {
+ "pluginId": "default",
+ "version": "current",
+ "docId": "sql-manual/sql-functions/aggregate-functions/any-value",
+ "locale": "ja",
+ "sourceLocale": "en",
+ "sourcePath":
"docs/sql-manual/sql-functions/aggregate-functions/any-value.md",
+ "targetPath":
"i18n/ja/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/any-value.md",
+ "sourceCommit": "3ddf1a2b4173903e3346b76e1102ca9e203922f1",
+ "sourceHash":
"e50a0aa92be39989f5976114fcb6b641627ae528e1e2b716846dd2bae7cde4e1",
+ "sourceTechnicalHash":
"82b015f62bb7bd7d69506746f1c527bb7fc368cb2652be78756777cfb86ff72f",
+ "targetHash":
"601b1603031b6e650dc4ce16aceadbcc6c265a6bb59ae514fdaf16dbefa346ba",
+ "reviewStatus": "machine",
+ "ownership": "machine",
+ "translatedAt": "2026-10-13T06:05:23.973Z",
+ "glossaryVersion": "0"
+ },
{
"pluginId": "default",
"version": "current",
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
