This is an automated email from the ASF dual-hosted git repository.
eldenmoon pushed a commit to branch opt-var-nested
in repository https://gitbox.apache.org/repos/asf/doris-website.git
commit 339d9812e9df0a2c52a10cbeda21f9160fd988f0
Author: eldenmoon <lihan...@selectdb.com>
AuthorDate: Tue Mar 18 11:13:43 2025 +0800
remove `variant_enable_flatten_nested` in 2.1 docs
---
.../admin-manual/data-admin/ccr/feature.md | 1 -
.../table-functions/explode-variant-array.md | 111 ---------------------
.../admin-manual/data-admin/ccr/feature.md | 1 -
.../table-functions/explode-variant-array.md | 110 --------------------
4 files changed, 223 deletions(-)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/data-admin/ccr/feature.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/data-admin/ccr/feature.md
index f97ae9e1388..c189a78ae40 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/data-admin/ccr/feature.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/data-admin/ccr/feature.md
@@ -81,7 +81,6 @@ CCR 任务不同步修改库属性操作。
| compaction_policy | 支持 | - | SQL
| |
| time_series_compaction 系列 | 支持 | - | SQL
| |
| binlog 系列 | 支持 | - | SQL
| |
-| variant_enable_flatten_nested | 支持 | - | SQL
| |
| skip_write_index_on_load | 支持 | - | SQL
| |
| row_strore 系列 | 支持 | - | SQL
| |
| seq 列 | 支持 | - | SQL
| |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/table-functions/explode-variant-array.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/table-functions/explode-variant-array.md
deleted file mode 100644
index cf113ec3b6c..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/table-functions/explode-variant-array.md
+++ /dev/null
@@ -1,111 +0,0 @@
----
-{
-"title": "EXPLODE_VARIANT_ARRAY",
-"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.
--->
-
-## 描述
-
-`explode_variant_array` 表函数，接受一个 variant 类型，其中每个元素是 JSON 对象类型，将该 json 数组中的每个
json 对象展开为多行，每行包含一个 JSON 对象。配合 LATERAL VIEW 使用。
-
-## 语法
-
-```sql
-EXPLODE_VARIANT_ARRAY(<variant>)
-```
-
-## 参数
-
-| 参数 | 说明 |
-| -- | -- |
-| `<variant>` | variant 类型 |
-
-## 返回值
-
-展开 JSON 数组，每个元素生成一行，返回 JSON 对象列。
-
-## 举例
-
-```sql
-CREATE TABLE `simple_nested_test` (
- `k` bigint NULL,
- `v` variant NULL
-) ENGINE=OLAP
-DUPLICATE KEY(`k`)
-DISTRIBUTED BY HASH(`k`) BUCKETS 8
-PROPERTIES (
-"file_cache_ttl_seconds" = "0",
-"is_being_synced" = "false",
-"storage_medium" = "hdd",
-"storage_format" = "V2",
-"inverted_index_storage_format" = "V2",
-"light_schema_change" = "true",
-"disable_auto_compaction" = "false",
-"variant_enable_flatten_nested" = "true",
-"enable_single_replica_compaction" = "false",
-"group_commit_interval_ms" = "10000",
-"group_commit_data_bytes" = "134217728"
-);
-```
-
-```sql
-insert into simple_nested_test values(1, '{
- "eventId": 1,
- "firstName": "Name1",
- "lastName": "Eric",
- "body": {
- "phoneNumbers": [
- {
- "number": "1111111111",
- "type": "GSM",
- "callLimit": 5
- },
- {
- "number": "222222222",
- "type": "HOME",
- "callLimit": 3
- },
- {
- "number": "33333333",
- "callLimit": 2,
- "type": "WORK"
- }
- ]
- }
-}');
-```
-
-```sql
-select v['eventId'], phone_numbers
- from simple_nested_test lateral view
explode_variant_array(v['body']['phoneNumbers']) tmp1 as phone_numbers
- where phone_numbers['type'] = 'GSM' OR phone_numbers['type'] = 'HOME' and
phone_numbers['callLimit'] > 2;
-```
-
-```text
-+--------------------------+----------------------------------------------------+
-| element_at(v, 'eventId') | phone_numbers
|
-+--------------------------+----------------------------------------------------+
-| 1 |
{"callLimit":5,"number":"1111111111","type":"GSM"} |
-| 1 |
{"callLimit":3,"number":"222222222","type":"HOME"} |
-+--------------------------+----------------------------------------------------+
-```
\ No newline at end of file
diff --git a/versioned_docs/version-2.1/admin-manual/data-admin/ccr/feature.md
b/versioned_docs/version-2.1/admin-manual/data-admin/ccr/feature.md
index 5abf45f1417..9e7bba7c8f1 100644
--- a/versioned_docs/version-2.1/admin-manual/data-admin/ccr/feature.md
+++ b/versioned_docs/version-2.1/admin-manual/data-admin/ccr/feature.md
@@ -81,7 +81,6 @@ Renaming is not supported for upstream and downstream; if
done, it may cause vie
| compaction_policy | Supported | - |
SQL | |
| time_series_compaction series | Supported | - |
SQL | |
| binlog series | Supported | - |
SQL | |
-| variant_enable_flatten_nested | Supported | - |
SQL | |
| skip_write_index_on_load | Supported | - |
SQL | |
| row_store series | Supported | - |
SQL | |
| seq column | Supported | - |
SQL | |
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/table-functions/explode-variant-array.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/table-functions/explode-variant-array.md
deleted file mode 100644
index 73d74dd8867..00000000000
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/table-functions/explode-variant-array.md
+++ /dev/null
@@ -1,110 +0,0 @@
----
-{
-"title": "EXPLODE_VARIANT_ARRAY",
-"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.
--->
-
-## Description
-
-The `explode_variant_array` table function accepts a variant type, where each
element is a JSON object, and expands each JSON object in the array into
multiple rows, with each row containing one JSON object. It is used in
conjunction with LATERAL VIEW.
-
-## Syntax
-```sql
-EXPLODE_VARIANT_ARRAY(<variant>)
-```
-
-## Return Value
-
-| Parameter | Description |
-| -- | -- |
-| `<variant>` | variant type |
-
-## Parameters
-
-Expands the JSON array, creating a row for each element, returning a JSON
object column.
-
-## Examples
-
-```sql
-CREATE TABLE `simple_nested_test` (
- `k` bigint NULL,
- `v` variant NULL
-) ENGINE=OLAP
-DUPLICATE KEY(`k`)
-DISTRIBUTED BY HASH(`k`) BUCKETS 8
-PROPERTIES (
-"file_cache_ttl_seconds" = "0",
-"is_being_synced" = "false",
-"storage_medium" = "hdd",
-"storage_format" = "V2",
-"inverted_index_storage_format" = "V2",
-"light_schema_change" = "true",
-"disable_auto_compaction" = "false",
-"variant_enable_flatten_nested" = "true",
-"enable_single_replica_compaction" = "false",
-"group_commit_interval_ms" = "10000",
-"group_commit_data_bytes" = "134217728"
-);
-```
-
-```sql
-insert into simple_nested_test values(1, '{
- "eventId": 1,
- "firstName": "Name1",
- "lastName": "Eric",
- "body": {
- "phoneNumbers": [
- {
- "number": "1111111111",
- "type": "GSM",
- "callLimit": 5
- },
- {
- "number": "222222222",
- "type": "HOME",
- "callLimit": 3
- },
- {
- "number": "33333333",
- "callLimit": 2,
- "type": "WORK"
- }
- ]
- }
-}');
-```
-
-```sql
-select v['eventId'], phone_numbers
- from simple_nested_test lateral view
explode_variant_array(v['body']['phoneNumbers']) tmp1 as phone_numbers
- where phone_numbers['type'] = 'GSM' OR phone_numbers['type'] = 'HOME' and
phone_numbers['callLimit'] > 2;
-```
-
-```text
-+--------------------------+----------------------------------------------------+
-| element_at(v, 'eventId') | phone_numbers
|
-+--------------------------+----------------------------------------------------+
-| 1 |
{"callLimit":5,"number":"1111111111","type":"GSM"} |
-| 1 |
{"callLimit":3,"number":"222222222","type":"HOME"} |
-+--------------------------+----------------------------------------------------+
-```
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
