This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 43de63d55e7 (feat) sync to apache/master (#375)
43de63d55e7 is described below
commit 43de63d55e7fa43aa8478f65b05ff5fd191988ab
Author: hututu <[email protected]>
AuthorDate: Wed Dec 27 20:08:14 2023 +0800
(feat) sync to apache/master (#375)
* (feat) sync to apache/master
* (feat) add community language switch
---
.../version-1.2/admin-manual/config/be-config.md | 6 ++
.../version-1.2/admin-manual/config/fe-config.md | 70 +++++++++----
.../version-1.2/advanced/compute_node.md | 2 +-
.../version-1.2/advanced/variables.md | 13 +++
.../version-1.2/ecosystem/audit-plugin.md | 2 +
.../version-1.2/ecosystem/flink-doris-connector.md | 2 +-
.../version-1.2/ecosystem/mysql-to-doris.md | 108 ---------------------
.../compilation-with-ldb-toolchain.md | 2 +-
.../version-1.2/lakehouse/multi-catalog/faq.md | 75 ++++++++++++++
.../version-1.2/lakehouse/multi-catalog/hive.md | 17 ++--
.../sql-functions/bitmap-functions/bitmap_and.md | 15 ++-
.../bitmap-functions/bitmap_and_not.md | 21 ++++
.../sql-functions/bitmap-functions/bitmap_empty.md | 7 ++
.../bitmap-functions/bitmap_has_all.md | 26 ++---
.../bitmap-functions/bitmap_has_any.md | 26 ++---
.../bitmap-functions/bitmap_hash64.md | 12 +--
.../sql-functions/bitmap-functions/bitmap_not.md | 20 ++--
.../sql-functions/bitmap-functions/bitmap_or.md | 25 +++--
.../sql-functions/json-functions/json_extract.md | 2 -
.../sql-functions/string-functions/char.md | 69 -------------
.../ALTER-SYSTEM-MODIFY-BROKER.md | 38 --------
.../Manipulation/EXPORT.md | 1 +
src/scss/components/navbar.scss | 9 +-
src/theme/Navbar/Content/index.tsx | 19 ++--
src/theme/Navbar/Layout/index.tsx | 8 ++
.../version-1.2/admin-manual/config/fe-config.md | 54 ++++++++---
versioned_docs/version-1.2/advanced/variables.md | 12 +++
.../version-1.2/ecosystem/audit-plugin.md | 2 +
.../version-1.2/ecosystem/flink-doris-connector.md | 6 +-
.../version-1.2/ecosystem/mysql-to-doris.md | 105 --------------------
.../compilation-with-ldb-toolchain.md | 2 +-
.../version-1.2/lakehouse/multi-catalog/faq.md | 80 +++++++++++++++
.../version-1.2/lakehouse/multi-catalog/hive.md | 13 +--
.../sql-functions/bitmap-functions/bitmap_and.md | 15 ++-
.../bitmap-functions/bitmap_and_not.md | 21 ++++
.../sql-functions/bitmap-functions/bitmap_empty.md | 7 ++
.../bitmap-functions/bitmap_has_all.md | 26 ++---
.../bitmap-functions/bitmap_has_any.md | 26 ++---
.../bitmap-functions/bitmap_hash64.md | 12 +--
.../sql-functions/bitmap-functions/bitmap_not.md | 14 +--
.../sql-functions/bitmap-functions/bitmap_or.md | 25 +++--
.../orthogonal_bitmap_expr_calculate.md | 47 ---------
.../orthogonal_bitmap_expr_calculate_count.md | 47 ---------
.../sql-functions/json-functions/json_extract.md | 2 -
.../sql-functions/string-functions/char.md | 69 -------------
.../ALTER-SYSTEM-MODIFY-BROKER.md | 38 --------
.../Manipulation/EXPORT.md | 1 +
versioned_sidebars/version-1.2-sidebars.json | 8 +-
versioned_sidebars/version-2.0-sidebars.json | 15 ++-
49 files changed, 540 insertions(+), 702 deletions(-)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/admin-manual/config/be-config.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/admin-manual/config/be-config.md
index 8156d2b2a05..fe147ca47c1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/admin-manual/config/be-config.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/admin-manual/config/be-config.md
@@ -1446,4 +1446,10 @@ load tablets from header failed, failed tablets size:
xxx, path=xxx
* 描述: 是否在导入json数据时用simdjson来解析。
* 默认值: false
+
+#### `be_thrift_max_pkg_bytes`
+
+* 描述: be节点thrift端口最大接收包大小
+* 默认值: 20000000
+
</version>
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/admin-manual/config/fe-config.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/admin-manual/config/fe-config.md
index 8f79e7f414c..c0f04e0231a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/admin-manual/config/fe-config.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/admin-manual/config/fe-config.md
@@ -1680,6 +1680,16 @@ sys_log_dir:
日志拆分的大小,每1G拆分一个日志文件
+<version since="dev">
+
+#### `sys_log_enable_compress`
+
+默认值:false
+
+控制是否压缩fe log, 包括fe.log 及 fe.warn.log。如果开启,则使用gzip算法进行压缩。
+
+</version>
+
#### `audit_log_dir`
默认值:DorisFE.DORIS_HOME_DIR + "/log"
@@ -1725,6 +1735,16 @@ HOUR: log前缀是:yyyyMMddHH
- 60m 60 分钟
- 120s 120 秒
+<version since="dev">
+
+#### `audit_log_enable_compress`
+
+默认值:false
+
+控制是否压缩 fe.audit.log。如果开启,则使用gzip算法进行压缩。
+
+</version>
+
### 存储
#### `min_replication_num_per_tablet`
@@ -1785,24 +1805,6 @@ show data (其他用法:HELP SHOW DATA)
在这种情况下,您可以将此配置设置为 true。 系统会将损坏的 tablet 替换为空 tablet,以确保查询可以执行。
(但此时数据已经丢失,所以查询结果可能不准确)
-#### `recover_with_skip_missing_version`
-
-默认值:disable
-
-是否可以动态配置:true
-
-是否为 Master FE 节点独有的配置项:true
-
-有些场景下集群出现了不可恢复的元数据问题,数据已的visibleversion 已经和be 不匹配,
-
-这种情况下仍然需要恢复剩余的数据(可能能会导致数据的正确性有问题),这个配置同`recover_with_empty_tablet` 一样只能在紧急情况下使用
-
-这个配置有三个值:
-
- * disable :出现异常会正常报错。
- * ignore_version: 忽略 fe partition 中记录的visibleVersion 信息, 使用replica version
- * ignore_all: 除了ignore_version, 在遇到找不到可查询的replica 时,直接跳过而不是抛出异常
-
#### `min_clone_task_timeout_sec` 和 `max_clone_task_timeout_sec`
默认值:最小3分钟,最大两小时
@@ -2584,6 +2586,26 @@ SmallFileMgr 中存储的最大文件数
备份作业的默认超时时间
+#### `backup_upload_task_num_per_be`
+
+默认值:3
+
+是否可以动态配置:true
+
+是否为 Master FE 节点独有的配置项:true
+
+备份过程中,分配给每个be的upload任务最大个数,默认值为3个。
+
+#### `restore_download_task_num_per_be`
+
+默认值:3
+
+是否可以动态配置:true
+
+是否为 Master FE 节点独有的配置项:true
+
+恢复过程中,分配给每个be的download任务最大个数,默认值为3个。
+
#### `max_backup_restore_job_num_per_db`
默认值:10
@@ -2714,3 +2736,15 @@ show data (其他用法:HELP SHOW DATA)
这个参数主要用于避免因 external catalog 无法访问、信息过多等原因导致的查询 `information_schema` 超时的问题。
+
+#### `fe_thrift_max_pkg_bytes`
+
+默认值:20000000
+
+是否可以动态配置:false
+
+是否为 Master FE 节点独有的配置项:false
+
+用于限制fe节点thrift端口可以接收的最大包长度,避免接收到过大或者错误的包导致OOM
+
+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/compute_node.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/compute_node.md
index a587b73a6d4..cd61720e408 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/compute_node.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/compute_node.md
@@ -108,4 +108,4 @@ min_backend_num_for_external_table=3
## 未尽事项
- 计算外溢: Doris内表查询, 当集群负载高的时候, 上层(TableScan之外)算子调度到计算节点中.
-- 优雅下线: 当节点下线的时候, 新任务自动调度到其他节点; 等待老任务全部完成后节点再下线; 如果老任务无法按时结束时, 确保任务能够自己结束.
+- 优雅下线: 当节点下线的时候, 任务新任务自动调度到其他节点; 等待老任务后全部完成后节点再下线; 老任务无法按时结束时, 能够让任务能够自己结束.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/variables.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/variables.md
index 81b74850a97..a002749107a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/variables.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/advanced/variables.md
@@ -175,6 +175,10 @@ SELECT /*+ SET_VAR(query_timeout = 1,
enable_partition_cache=true) */ sleep(3);
用于兼容 MySQL 客户端。无实际作用。
+- `have_query_cache`
+
+ 用于兼容 MySQL 客户端。无实际作用。
+
- `default_order_by_limit`
用于控制 OrderBy 以后返回的默认条数。默认值为 -1,默认返回查询后的最大条数,上限为 long 数据类型的 MAX_VALUE 值。
@@ -557,6 +561,10 @@ try (Connection conn =
DriverManager.getConnection("jdbc:mysql://127.0.0.1:9030/
用于调试目的。在Unique Key MoW表中,当发现读取表的数据结果有误的时候,把此变量的值设置为`true`,将会把被delete
bitmap标记删除的数据当成正常数据读取。
+* `skip_missing_version`
+
+ 有些极端场景下,表的 Tablet 下的所有的所有副本都有版本缺失,使得这些 Tablet
没有办法被恢复,导致整张表都不能查询。这个变量可以用来控制查询的行为,打设置为`true`时,查询会忽略 FE partition 中记录的
visibleVersion,使用 replica version。如果 Be 上的 Replica
有缺失的版本,则查询会直接跳过这些缺失的版本,只返回仍存在版本的数据。此外,查询将会总是选择所有存活的 BE 中所有 Replica 里
lastSuccessVersion
最大的那一个,这样可以尽可能的恢复更多的数据。这个变量应该只在上述紧急情况下才被设置为`true`,仅用于临时让表恢复查询。注意,此变量与
use_fix_replica 变量冲突,当 use_fix_replica 变量不等于 -1 时,此变量会不起作用
+
* `default_password_lifetime`
默认的密码过期时间。默认值为 0,即表示不过期。单位为天。该参数只有当用户的密码过期属性为 DEFAULT 值时,才启用。如:
@@ -628,6 +636,11 @@ try (Connection conn =
DriverManager.getConnection("jdbc:mysql://127.0.0.1:9030/
| 10000000 |
+--------------+
```
+
+* `enable_strong_consistency_read`
+
+ 用以开启强一致读。Doris
默认支持同一个会话内的强一致性,即同一个会话内对数据的变更操作是实时可见的。如需要会话间的强一致读,则需将此变量设置为true。
+
***
#### 关于语句执行超时控制的补充说明
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/audit-plugin.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/audit-plugin.md
index 73668f1246e..75615402d79 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/audit-plugin.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/audit-plugin.md
@@ -66,6 +66,7 @@ create table doris_audit_db__.doris_audit_log_tbl__
`time` datetime not null comment "Query start time",
client_ip varchar(32) comment "Client IP",
user varchar(64) comment "User name",
+ catalog varchar(128) comment "Catalog of this query",
db varchar(96) comment "Database of this query",
state varchar(8) comment "Query result state. EOF, ERR, OK",
error_code int comment "Error code of failing query.",
@@ -102,6 +103,7 @@ create table doris_audit_db__.doris_slow_log_tbl__
`time` datetime not null comment "Query start time",
client_ip varchar(32) comment "Client IP",
user varchar(64) comment "User name",
+ catalog varchar(128) comment "Catalog of this query",
db varchar(96) comment "Database of this query",
state varchar(8) comment "Query result state. EOF, ERR, OK",
error_code int comment "Error code of failing query.",
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/flink-doris-connector.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/flink-doris-connector.md
index 8e754c83f27..4dbb3b8ff20 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/flink-doris-connector.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/flink-doris-connector.md
@@ -28,7 +28,7 @@ under the License.
# Flink Doris Connector
-
+> 本文档适用于flink-doris-connector
1.1.0之后的版本,1.1.0之前的版本参考[这里](https://doris.apache.org/zh-CN/docs/0.15/extending-doris/flink-doris-connector)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/mysql-to-doris.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/mysql-to-doris.md
deleted file mode 100644
index f08b192c9e2..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/ecosystem/mysql-to-doris.md
+++ /dev/null
@@ -1,108 +0,0 @@
----
-{
-
- "title": "Mysql to Doris",
- "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.
--->
-
-# Mysql to Doris
-
-mysql to doris 主要适用于自动化创建doris odbc 表,主要用shell脚本实现
-
-## 使用手册
-
-mysql to doris
代码[这里](https://github.com/apache/doris/tree/master/extension/mysql_to_doris)
-
-### 目录结构
-
-```text
-├── mysql_to_doris
-│ ├── conf
-│ │ ├── doris.conf
-│ │ ├── mysql.conf
-│ │ └── tables
-│ ├── all_tables.sh
-│ │
-└── └── user_define_tables.sh
-```
-
-1. all_tables.sh
-
- 这个脚本主要是读取mysql指定库下的所有表,自动创建Doris odbc外表
-
-2. user_define_tables.sh
-
- 这个脚本主要用于用户自定义指定mysql库下某几张表,自动创建Doris odbc外表
-
-3. conf
-
-
配置文件,`doris.conf`主要是配置doris相关的,`mysql.conf`主要配置mysql相关的,`tables`主要用于配置用户自定义mysql库的表
-
-### 全量
-
-1. 下载使用mysql to
doris[这里](https://github.com/apache/doris/tree/master/extension/mysql_to_doris)
-
-2. 配置相关文件
-
- ```shell
- #doris.conf
- master_host=
- master_port=
- doris_password=
- doris_odbc_name=''
-
- #mysql.conf
- mysql_host=
- mysql_password=
- ```
-
- | 配置项 | 说明 |
- |------------------| ----------------------- |
- | master_host | Doris FE master节点IP |
- | master_port | Doris FE query_port端口 |
- | doris_password | Doris 密码(默认root用户) |
- | doris_odbc_name | be/conf 下odbcinst.ini配置文件中mysql odbc的名称 |
- | mysql_host | Mysql IP |
- | mysql_password | Mysql 密码(默认root用户) |
-
-
-3. 执行`all_tables.sh`脚本
-
-```
-sh all_tables.sh mysql_db_name doris_db_name
-```
-
-执行成功后会生成 files目录,该目录包含`tables`(表名称) 和 `tables.sql` (doris odbc建表语句)
-
-### 自定义
-
-1. 修改`conf/tables`文件,添加需要创建doris odbc的表
-2. 配置mysql和doris相关信息,参考全量创建第2步
-3. 执行`user_define_tables.sh`脚本
-
-```
-sh user_define_tables.sh mysql_db_name doris_db_name
-```
-
-执行成功后会生成 user_files目录,该目录包含 `tables.sql` (doris odbc建表语句)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/install/source-install/compilation-with-ldb-toolchain.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/install/source-install/compilation-with-ldb-toolchain.md
index ca8f226adc1..117ad946d85 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/install/source-install/compilation-with-ldb-toolchain.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/install/source-install/compilation-with-ldb-toolchain.md
@@ -63,7 +63,7 @@ under the License.
3. 下载并安装其他编译组件
- 1.
[Java8](https://doris-thirdparty-1308700295.cos.ap-beijing.myqcloud.com/tools/jdk-8u391-linux-x64.tar.gz)
+ 1.
[Java8](https://doris-thirdparty-repo.bj.bcebos.com/thirdparty/jdk-8u131-linux-x64.tar.gz)
2. [Apache Maven
3.6.3](https://doris-thirdparty-repo.bj.bcebos.com/thirdparty/apache-maven-3.6.3-bin.tar.gz)
3. [Node
v12.13.0](https://doris-thirdparty-repo.bj.bcebos.com/thirdparty/node-v12.13.0-linux-x64.tar.gz)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/lakehouse/multi-catalog/faq.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/lakehouse/multi-catalog/faq.md
index 2a0b6eeb69f..e45f37f0565 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/lakehouse/multi-catalog/faq.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/lakehouse/multi-catalog/faq.md
@@ -110,3 +110,78 @@ under the License.
```
'fs.defaultFS' = 'hdfs://<your_nameservice_or_actually_HDFS_IP_and_port>'
```
+
+12. 在hive上可以查到hudi表分区字段的值,但是在doris查不到。
+
+
doris和hive目前查询hudi的方式不一样,doris需要在hudi表结构的avsc文件里添加上分区字段,如果没加,就会导致doris查询partition_val为空(即使设置了hoodie.datasource.hive_sync.partition_fields=partition_val也不可以)
+ ```
+ {
+ "type": "record",
+ "name": "record",
+ "fields": [{
+ "name": "partition_val",
+ "type": [
+ "null",
+ "string"
+ ],
+ "doc": "Preset partition field, empty string when not partitioned",
+ "default": null
+ },
+ {
+ "name": "name",
+ "type": "string",
+ "doc": "名称"
+ },
+ {
+ "name": "create_time",
+ "type": "string",
+ "doc": "创建时间"
+ }
+ ]
+ }
+ ```
+
+13. Hive 1.x 的 orc 格式的表可能会遇到底层 orc 文件 schema 中列名为 `_col0`,`_col1`,`_col2`...
这类系统列名,此时需要在 catalog 配置中添加 `hive.version` 为 1.x.x,这样就会使用 hive 表中的列名进行映射。
+
+ ```sql
+ CREATE CATALOG hive PROPERTIES (
+ 'hive.version' = '1.x.x'
+ );
+ ```
+
+14. 使用JDBC
Catalog将MySQL数据同步到Doris中,日期数据同步错误。需要校验下MySQL的版本是否与MySQL的驱动包是否对应,比如MySQL8以上需要使用驱动com.mysql.cj.jdbc.Driver。
+
+15. 在Catalog中配置Kerberos时,如果报错`SIMPLE authentication is not enabled.
Available:[TOKEN,
KERBEROS]`,那么需要将`core-site.xml`文件放到`"${DORIS_HOME}/be/conf"`目录下。
+
+ 如果访问HDFS报错`No common protection layer between client and
server`,检查客户端和服务端的`hadoop.rpc.protection`属性,使他们保持一致。
+
+ ```
+ <?xml version="1.0" encoding="UTF-8"?>
+ <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
+
+ <configuration>
+
+ <property>
+ <name>hadoop.security.authentication</name>
+ <value>kerberos</value>
+ </property>
+
+ </configuration>
+ ```
+
+16. 在Catalog中配置Kerberos时,报错`Unable to obtain password from user`的解决方法:
+ - 用到的principal必须在klist中存在,使用`klist -kt your.keytab`检查。
+ - 检查catalog配置是否正确,比如漏配`yarn.resourcemanager.principal`。
+ - 若上述检查没问题,则当前系统yum或者其他包管理软件安装的JDK版本存在不支持的加密算法,建议自行安装JDK并设置`JAVA_HOME`环境变量。
+
+17. 查询配置了Kerberos的外表,遇到该报错:`GSSException: No valid credentials provided
(Mechanism level: Failed to find any Kerberos Ticket)`,一般重启FE和BE能够解决该问题。
+ -
重启所有节点前可在`"${DORIS_HOME}/be/conf/be.conf"`中的JAVA_OPTS参数里配置`-Djavax.security.auth.useSubjectCredsOnly=false`,通过底层机制去获取JAAS
credentials信息,而不是应用程序。
+ - 在[JAAS
Troubleshooting](https://docs.oracle.com/javase/8/docs/technotes/guides/security/jgss/tutorials/Troubleshooting.html)中可获取更多常见JAAS报错的解决方法。
+
+18. 使用Catalog查询表数据时发现与Hive Metastore相关的报错:`Invalid method
name`,需要设置`hive.version`参数。
+
+ ```sql
+ CREATE CATALOG hive PROPERTIES (
+ 'hive.version' = '1.x.x'
+ );
+ ```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/lakehouse/multi-catalog/hive.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/lakehouse/multi-catalog/hive.md
index 98d32b86312..6cc16bdbe1a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/lakehouse/multi-catalog/hive.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/lakehouse/multi-catalog/hive.md
@@ -30,19 +30,20 @@ under the License.
除了 Hive 外,很多其他系统也会使用 Hive Metastore 存储元数据。所以通过 Hive Catalog,我们不仅能访问
Hive,也能访问使用 Hive Metastore 作为元数据存储的系统。如 Iceberg、Hudi 等。
-## 使用限制
-
-1. hive 支持 1/2/3 版本。
-2. 支持 Managed Table 和 External Table。
-3. 可以识别 Hive Metastore 中存储的 hive、iceberg、hudi 元数据。
-4. 支持数据存储在 Juicefs 上的 hive 表,用法如下(需要把juicefs-hadoop-x.x.x.jar放在 fe/lib/ 和
apache_hdfs_broker/lib/ 下)。
-5. 支持数据存储在 CHDFS 上的 hive 表。需配置环境:
+## 使用须知
+
+1. 将 core-site.xml,hdfs-site.xml 和 hive-site.xml 放到 FE 和 BE 的 conf 目录下。优先读取
conf 目录下的 hadoop 配置文件,再读取环境变量 `HADOOP_CONF_DIR` 的相关配置文件。
+2. hive 支持 1/2/3 版本。
+3. 支持 Managed Table 和 External Table。
+4. 可以识别 Hive Metastore 中存储的 hive、iceberg、hudi 元数据。
+5. 支持数据存储在 Juicefs 上的 hive 表,用法如下(需要把juicefs-hadoop-x.x.x.jar放在 fe/lib/ 和
apache_hdfs_broker/lib/ 下)。
+6. 支持数据存储在 CHDFS 上的 hive 表。需配置环境:
1. 把chdfs_hadoop_plugin_network-x.x.jar 放在 fe/lib/ 和
apache_hdfs_broker/lib/ 下
2. 将 hive 所在 Hadoop 集群的 core-site.xml 和 hdfs-site.xml 复制到 fe/conf/ 和
apache_hdfs_broker/conf 目录下
<version since="dev">
-6. 支持数据存在在 GooseFS(GFS) 上的 hive、iceberg表。需配置环境:
+7. 支持数据存在在 GooseFS(GFS) 上的 hive、iceberg表。需配置环境:
1. 把 goosefs-x.x.x-client.jar 放在 fe/lib/ 和 apache_hdfs_broker/lib/ 下
2. 创建 catalog 时增加属性:'fs.AbstractFileSystem.gfs.impl' =
'com.qcloud.cos.goosefs.hadoop.GooseFileSystem', 'fs.gfs.impl' =
'com.qcloud.cos.goosefs.hadoop.FileSystem'
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
index 9e342842ed4..ccb413ae816 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
@@ -42,6 +42,13 @@ mysql> select bitmap_count(bitmap_and(to_bitmap(1),
to_bitmap(2))) cnt;
| 0 |
+------+
+mysql> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(2)));
++----------------------------------------------------------+
+| bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(2))) |
++----------------------------------------------------------+
+| |
++----------------------------------------------------------+
+
mysql> select bitmap_count(bitmap_and(to_bitmap(1), to_bitmap(1))) cnt;
+------+
| cnt |
@@ -49,28 +56,28 @@ mysql> select bitmap_count(bitmap_and(to_bitmap(1),
to_bitmap(1))) cnt;
| 1 |
+------+
-MySQL> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1)));
+mysql> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1)));
+----------------------------------------------------------+
| bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1))) |
+----------------------------------------------------------+
| 1 |
+----------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+-----------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'))) |
+-----------------------------------------------------------------------------------------------------------------------+
| 1,2
|
+-----------------------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),bitmap_empty()));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),bitmap_empty()));
+---------------------------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'), bitmap_empty())) |
+---------------------------------------------------------------------------------------------------------------------------------------+
|
|
+---------------------------------------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),NULL));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),NULL));
+-----------------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'), NULL)) |
+-----------------------------------------------------------------------------------------------------------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
index d24bcb3a87b..f587af76c46 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
@@ -41,6 +41,27 @@ mysql> select
bitmap_count(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_fro
+------+
| 2 |
+------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_from_string('3,4,5')));
++--------------------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),
bitmap_from_string('3,4,5'))) |
++--------------------------------------------------------------------------------------------+
+| 1,2
|
++--------------------------------------------------------------------------------------------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_empty())) ;
++-------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),
bitmap_empty())) |
++-------------------------------------------------------------------------------+
+| 1,2,3
|
++-------------------------------------------------------------------------------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),NULL));
++---------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'), NULL)) |
++---------------------------------------------------------------------+
+| NULL |
++---------------------------------------------------------------------+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
index b677f5ac110..f07e7343a20 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
@@ -45,6 +45,13 @@ mysql> select bitmap_count(bitmap_empty());
+------------------------------+
| 0 |
+------------------------------+
+
+mysql> select bitmap_to_string(bitmap_empty());
++----------------------------------+
+| bitmap_to_string(bitmap_empty()) |
++----------------------------------+
+| |
++----------------------------------+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
index c98f79313d6..d38bfb4db51 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
@@ -36,19 +36,19 @@ under the License.
### example
```
-mysql> select bitmap_has_all(bitmap_from_string("0, 1, 2"),
bitmap_from_string("1, 2")) cnt;
-+------+
-| cnt |
-+------+
-| 1 |
-+------+
-
-mysql> select bitmap_has_all(bitmap_empty(), bitmap_from_string("1, 2")) cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
+mysql> select bitmap_has_all(bitmap_from_string("0, 1, 2"),
bitmap_from_string("1, 2"));
++---------------------------------------------------------------------------+
+| bitmap_has_all(bitmap_from_string('0, 1, 2'), bitmap_from_string('1, 2')) |
++---------------------------------------------------------------------------+
+| 1 |
++---------------------------------------------------------------------------+
+
+mysql> select bitmap_has_all(bitmap_empty(), bitmap_from_string("1, 2"));
++------------------------------------------------------------+
+| bitmap_has_all(bitmap_empty(), bitmap_from_string('1, 2')) |
++------------------------------------------------------------+
+| 0 |
++------------------------------------------------------------+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
index 858228ae310..b483d885dbd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
@@ -35,19 +35,19 @@ under the License.
### example
```
-mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(2)) cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
-
-mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(1)) cnt;
-+------+
-| cnt |
-+------+
-| 1 |
-+------+
+mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(2));
++--------------------------------------------+
+| bitmap_has_any(to_bitmap(1), to_bitmap(2)) |
++--------------------------------------------+
+| 0 |
++--------------------------------------------+
+
+mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(1));
++--------------------------------------------+
+| bitmap_has_any(to_bitmap(1), to_bitmap(1)) |
++--------------------------------------------+
+| 1 |
++--------------------------------------------+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
index 38c6bf22b7f..a0c4f5d1036 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
@@ -39,12 +39,12 @@ cat data | curl --location-trusted -u user:passwd -T - -H
"columns: dt,page,devi
### example
```
-mysql> select bitmap_count(bitmap_hash64('hello'));
-+------------------------------------+
-| bitmap_count(bitmap_hash64('hello')) |
-+------------------------------------+
-| 1 |
-+------------------------------------+
+mysql> select bitmap_to_string(bitmap_hash64('hello'));
++------------------------------------------+
+| bitmap_to_string(bitmap_hash64('hello')) |
++------------------------------------------+
+| 15231136565543391023 |
++------------------------------------------+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
index d2e27f2a642..8c346939b84 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
@@ -35,19 +35,19 @@ under the License.
### example
```
-mysql> select
bitmap_count(bitmap_not(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4')))
cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
-
-mysql> select
bitmap_to_string(bitmap_not(bitmap_from_string('2,3,5'),bitmap_from_string('1,2,3,4')));
+mysql> select
bitmap_to_string(bitmap_not(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4')));
+----------------------------------------------------------------------------------------+
-| bitmap_to_string(bitmap_xor(bitmap_from_string('2,3,5'),
bitmap_from_string('1,2,3,4'))) |
+| bitmap_to_string(bitmap_not(bitmap_from_string('2,3'),
bitmap_from_string('1,2,3,4'))) |
+----------------------------------------------------------------------------------------+
-| 5
|
+|
|
+----------------------------------------------------------------------------------------+
+
+mysql> select
bitmap_to_string(bitmap_not(bitmap_from_string('2,3,5'),bitmap_from_string('1,2,3,4')));
++------------------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_not(bitmap_from_string('2,3,5'),
bitmap_from_string('1,2,3,4'))) |
++------------------------------------------------------------------------------------------+
+| 5
|
++------------------------------------------------------------------------------------------+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
index 90c5f895902..811777fa8a5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
@@ -35,42 +35,49 @@ under the License.
### example
```
-mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(2))) cnt;
+mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(1))) cnt;
+------+
| cnt |
+------+
-| 2 |
+| 1 |
+------+
-mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(1))) cnt;
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(1))) ;
++---------------------------------------------------------+
+| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(1))) |
++---------------------------------------------------------+
+| 1 |
++---------------------------------------------------------+
+
+mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(2))) cnt;
+------+
| cnt |
+------+
-| 1 |
+| 2 |
+------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2)));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2)));
+---------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2))) |
+---------------------------------------------------------+
| 1,2 |
+---------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), NULL));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), NULL));
+--------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10),
to_bitmap(0), NULL)) |
+--------------------------------------------------------------------------------------------+
-| NULL
|
+| 0,1,2,10
|
+--------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), bitmap_empty()));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), bitmap_empty()));
+------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10),
to_bitmap(0), bitmap_empty())) |
+------------------------------------------------------------------------------------------------------+
| 0,1,2,10
|
+------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(10),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(10),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+--------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(10), bitmap_from_string('1,2'),
bitmap_from_string('1,2,3,4,5'))) |
+--------------------------------------------------------------------------------------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/json_extract.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/json_extract.md
index 8159eac1eec..7eb3b00b2de 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/json_extract.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/json-functions/json_extract.md
@@ -24,8 +24,6 @@ under the License.
## json_extract
-<version since="dev"></version>
-
### description
#### Syntax
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/char.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/char.md
deleted file mode 100644
index e3d57f3fd31..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/string-functions/char.md
+++ /dev/null
@@ -1,69 +0,0 @@
----
-{
- "title": "char",
- "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.
--->
-
-<version since="1.2">
-
-## function char
-### description
-#### Syntax
-
-`VARCHAR char(INT,..., [USING charset_name])`
-
-将每个参数解释为整数,并返回一个字符串,该字符串由这些整数的代码值给出的字符组成。忽略`NULL`值。
-
-如果结果字符串对于给定字符集是非法的,相应的转换结果为`NULL`值。
-
-大于 `255` 的参数将转换为多个结果字节。例如,`char(15049882)`等价于`char(229, 164, 154)`。
-
-`charset_name`目前只支持`utf8`。
-</version>
-
-### example
-
-```
-mysql> select char(68, 111, 114, 105, 115);
-+--------------------------------------+
-| char('utf8', 68, 111, 114, 105, 115) |
-+--------------------------------------+
-| Doris |
-+--------------------------------------+
-
-mysql> select char(15049882, 15179199, 14989469);
-+--------------------------------------------+
-| char('utf8', 15049882, 15179199, 14989469) |
-+--------------------------------------------+
-| 多睿丝 |
-+--------------------------------------------+
-
-mysql> select char(255);
-+-------------------+
-| char('utf8', 255) |
-+-------------------+
-| NULL |
-+-------------------+
-```
-### keywords
- CHAR
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-MODIFY-BROKER.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-MODIFY-BROKER.md
deleted file mode 100644
index fc3dffb2fb6..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-MODIFY-BROKER.md
+++ /dev/null
@@ -1,38 +0,0 @@
----
-{
- "title": "ALTER-SYSTEM-MODIFY-BROKER",
- "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.
--->
-
-## ALTER-SYSTEM-MODIFY-BROKER
-
-### Description
-
-### Example
-
-### Keywords
-
- ALTER, SYSTEM, MODIFY, BROKER, ALTER SYSTEM
-
-### Best Practice
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
index a64e0034ee6..9e79d854a60 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
@@ -74,6 +74,7 @@ WITH BROKER
- `exec_mem_limit`:导出在单个 BE 节点的内存使用上限,默认为 2GB,单位为字节。
- `timeout`:导出作业的超时时间,默认为2小时,单位是秒。
- `tablet_num_per_task`:每个子任务能分配扫描的最大 Tablet 数量。
+ -
`format`:指定导出的格式,当前只支持csv、csv_with_names、csv_with_names_and_types。在不指定的情况下,默认为csv。
- `WITH BROKER`
diff --git a/src/scss/components/navbar.scss b/src/scss/components/navbar.scss
index 7bcf5949c60..8d1829d705a 100644
--- a/src/scss/components/navbar.scss
+++ b/src/scss/components/navbar.scss
@@ -22,6 +22,11 @@
display: block;
}
}
+ &.community {
+ .custom-navbar-item:nth-child(3) {
+ display: block;
+ }
+ }
&__inner {
padding: 0 5rem;
margin: 0 auto;
@@ -296,7 +301,8 @@
@media screen and (max-width: 996px) {
.navbar {
height: 3.75rem;
- &.docs {
+ &.docs,
+ &.community {
height: 6.5rem;
flex-direction: column;
.navbar__inner {
@@ -319,6 +325,7 @@
}
}
}
+
.navbar__inner {
padding: 0 1.25rem;
}
diff --git a/src/theme/Navbar/Content/index.tsx
b/src/theme/Navbar/Content/index.tsx
index 3bfe7a0afdf..80c173c0951 100644
--- a/src/theme/Navbar/Content/index.tsx
+++ b/src/theme/Navbar/Content/index.tsx
@@ -49,11 +49,14 @@ export default function NavbarContent({ mobile }) {
const searchBarItem = items.find(item => item.type === 'search');
const [star, setStar] = useState<any>();
const [isDocsPage, setIsDocsPage] = useState(false);
+ const [isCommunity, setIsCommunity] = useState(false);
useEffect(() => {
getGithubStar();
if (typeof window !== 'undefined') {
const pathname = location.pathname.split('/')[1];
const docsPage = pathname === 'docs' ||
location.pathname.includes('zh-CN/docs');
+ const communityPage = pathname === 'community' ||
location.pathname.includes('zh-CN/community');
+ setIsCommunity(communityPage);
setIsDocsPage(docsPage);
}
}, [typeof window !== 'undefined' && location.pathname]);
@@ -132,15 +135,17 @@ export default function NavbarContent({ mobile }) {
</>
}
bottom={
- isDocsPage ? (
+ isDocsPage || isCommunity ? (
<div className="docs-nav-version-locale">
<LocaleDropdownNavbarItem mobile={false}
{...(getNavItem('localeDropdown') as any)} />
- <DocsVersionDropdownNavbarItem
- mobile={false}
- docsPluginId="default"
- collapsed={false}
- {...(getNavItem('docsVersionDropdown') as any)}
- />
+ {isDocsPage && (
+ <DocsVersionDropdownNavbarItem
+ mobile={false}
+ docsPluginId="default"
+ collapsed={false}
+ {...(getNavItem('docsVersionDropdown') as any)}
+ />
+ )}
</div>
) : (
<></>
diff --git a/src/theme/Navbar/Layout/index.tsx
b/src/theme/Navbar/Layout/index.tsx
index d5bbc45670b..1e81ecfde38 100644
--- a/src/theme/Navbar/Layout/index.tsx
+++ b/src/theme/Navbar/Layout/index.tsx
@@ -15,12 +15,19 @@ export default function NavbarLayout({ children }) {
const mobileSidebar = useNavbarMobileSidebar();
const { navbarRef, isNavbarVisible } = useHideableNavbar(hideOnScroll);
const [isDocsPage, setIsDocsPage] = useState(false);
+ const [isCommunity, setIsCommunity] = useState(false);
useEffect(() => {
if (typeof window !== 'undefined') {
const pathname = location.pathname.split('/')[1];
const docsPage = pathname === 'docs' ||
location.pathname.includes('zh-CN/docs');
setIsDocsPage(docsPage);
}
+
+ if (typeof window !== 'undefined') {
+ const pathname = location.pathname.split('/')[1];
+ const communityPage = pathname === 'community' ||
location.pathname.includes('zh-CN/community');
+ setIsCommunity(communityPage);
+ }
}, [typeof window !== 'undefined' && location.pathname]);
return (
<nav
@@ -34,6 +41,7 @@ export default function NavbarLayout({ children }) {
'navbar',
'navbar--fixed-top',
isDocsPage && 'docs',
+ isCommunity && 'community',
hideOnScroll && [styles.navbarHideable, !isNavbarVisible &&
styles.navbarHidden],
{
'navbar--dark': style === 'dark',
diff --git a/versioned_docs/version-1.2/admin-manual/config/fe-config.md
b/versioned_docs/version-1.2/admin-manual/config/fe-config.md
index 6cb36cdb8c4..91daa268db1 100644
--- a/versioned_docs/version-1.2/admin-manual/config/fe-config.md
+++ b/versioned_docs/version-1.2/admin-manual/config/fe-config.md
@@ -1680,6 +1680,16 @@ Default:SIZE-MB-1024
The size of the log split, split a log file every 1 G
+<version since="dev">
+
+#### `sys_log_enable_compress`
+
+Default: false
+
+If true, will compress fe.log & fe.warn.log by gzip
+
+</version>
+
#### `audit_log_dir`
Default:DORIS_HOME_DIR + "/log"
@@ -1725,6 +1735,16 @@ support format:
- 60m 60 min
- 120s 120 seconds
+<version since="dev">
+
+#### `audit_log_enable_compress`
+
+Default: false
+
+If true, will compress fe.audit.log by gzip
+
+</version>
+
### Storage
#### `min_replication_num_per_tablet`
@@ -1785,20 +1805,6 @@ In some very special circumstances, such as code bugs,
or human misoperation, et
Set to true so that Doris will automatically use blank replicas to fill
tablets which all replicas have been damaged or missing
-#### `recover_with_skip_missing_version`
-
-Default:disable
-
-IsMutable:true
-
-MasterOnly:true
-
-In some scenarios, there is an unrecoverable metadata problem in the cluster,
and the visibleVersion of the data does not match be. In this case, it is still
necessary to restore the remaining data (which may cause problems with the
correctness of the data). This configuration is the same as`
recover_with_empty_tablet` should only be used in emergency situations
-This configuration has three values:
-* disable : If an exception occurs, an error will be reported normally.
-* ignore_version: ignore the visibleVersion information recorded in fe
partition, use replica version
-* ignore_all: In addition to ignore_version, when encountering no queryable
replica, skip it directly instead of throwing an exception
-
#### `min_clone_task_timeout_sec` `And max_clone_task_timeout_sec`
Default:Minimum 3 minutes, maximum two hours
@@ -2580,6 +2586,26 @@ MasterOnly:true
default timeout of backup job
+#### `backup_upload_task_num_per_be`
+
+Default:3
+
+IsMutable:true
+
+MasterOnly:true
+
+The max number of upload tasks assigned to each be during the backup process,
the default value is 3.
+
+#### `restore_download_task_num_per_be`
+
+Default:3
+
+IsMutable:true
+
+MasterOnly:true
+
+The max number of download tasks assigned to each be during the restore
process, the default value is 3.
+
#### `max_backup_restore_job_num_per_db`
Default: 10
diff --git a/versioned_docs/version-1.2/advanced/variables.md
b/versioned_docs/version-1.2/advanced/variables.md
index bca47193bd9..23880635e6e 100644
--- a/versioned_docs/version-1.2/advanced/variables.md
+++ b/versioned_docs/version-1.2/advanced/variables.md
@@ -177,6 +177,10 @@ Note that the comment must start with /*+ and can only
follow the SELECT.
Used for compatibility with MySQL clients. No practical effect.
+* `have_query_cache`
+
+ Used for compatibility with MySQL clients. No practical effect.
+
* `default_order_by_limit`
Used to control the default number of items returned after OrderBy. The
default value is -1, and the maximum number of records after the query is
returned by default, and the upper limit is the MAX_VALUE of the long data type.
@@ -570,6 +574,10 @@ Translated with www.DeepL.com/Translator (free version)
For debugging purpose. In Unique Key MoW table, in case of problems of
reading data, setting value to `true` will also read deleted data.
+* `skip_missing_version`
+
+ In some scenarios, all replicas of tablet are having missing versions,
and the tablet is unable to recover. This config can control the behavior of
query. When it is opened, the query will ignore the visible version recorded in
FE partition, use the replica version. If the replica on be has missing
versions, the query will directly skip this missing version, and only return
the data of the existing version, In addition, the query will always try to
select the one with the highest la [...]
+
* `default_password_lifetime`
Default password expiration time. The default value is 0, which means
no expiration. The unit is days. This parameter is only enabled if the user's
password expiration property has a value of DEFAULT. like:
@@ -643,6 +651,10 @@ Translated with www.DeepL.com/Translator (free version)
+--------------+
```
+* `enable_strong_consistency_read`
+
+ Used to enable strong consistent reading. By default, Doris supports strong
consistency within the same session, that is, changes to data within the same
session are visible in real time. If you want strong consistent reads between
sessions, set this variable to true.
+
***
#### Supplementary instructions on statement execution timeout control
diff --git a/versioned_docs/version-1.2/ecosystem/audit-plugin.md
b/versioned_docs/version-1.2/ecosystem/audit-plugin.md
index d4823aa5047..4af1f2a20b0 100644
--- a/versioned_docs/version-1.2/ecosystem/audit-plugin.md
+++ b/versioned_docs/version-1.2/ecosystem/audit-plugin.md
@@ -66,6 +66,7 @@ create table doris_audit_db__.doris_audit_log_tbl__
`time` datetime not null comment "Query start time",
client_ip varchar(32) comment "Client IP",
user varchar(64) comment "User name",
+ catalog varchar(128) comment "Catalog of this query",
db varchar(96) comment "Database of this query",
state varchar(8) comment "Query result state. EOF, ERR, OK",
error_code int comment "Error code of failing query.",
@@ -102,6 +103,7 @@ create table doris_audit_db__.doris_slow_log_tbl__
`time` datetime not null comment "Query start time",
client_ip varchar(32) comment "Client IP",
user varchar(64) comment "User name",
+ catalog varchar(128) comment "Catalog of this query",
db varchar(96) comment "Database of this query",
state varchar(8) comment "Query result state. EOF, ERR, OK",
error_code int comment "Error code of failing query.",
diff --git a/versioned_docs/version-1.2/ecosystem/flink-doris-connector.md
b/versioned_docs/version-1.2/ecosystem/flink-doris-connector.md
index 8ffe3a40f2e..82be9f8bfed 100644
--- a/versioned_docs/version-1.2/ecosystem/flink-doris-connector.md
+++ b/versioned_docs/version-1.2/ecosystem/flink-doris-connector.md
@@ -26,7 +26,7 @@ under the License.
# Flink Doris Connector
-
+> This document applies to flink-doris-connector versions after 1.1.0, for
versions before 1.1.0 refer to
[here](https://doris.apache.org/docs/0.15/extending-doris/flink-doris-connector)
@@ -512,7 +512,7 @@ This is because the concurrent import of the same library
exceeds 100, which can
You can add sequence column configuration to ensure that, for details, please
refer to
[sequence](https://doris.apache.org/zh-CN/docs/dev/data-operate/update-delete/sequence-column-manual)
-8. **The Flink task does not report an error, but the data cannot be
synchronized?**
+8. **The Flink task does not report an error, but the data cannot be
synchronized? **
Before Connector1.1.0, it was written in batches, and the writing was driven
by data. It was necessary to determine whether there was data written upstream.
After 1.1.0, it depends on Checkpoint, and Checkpoint must be enabled to write.
@@ -520,7 +520,7 @@ Before Connector1.1.0, it was written in batches, and the
writing was driven by
It usually occurs before Connector1.1.0, because the writing frequency is too
fast, resulting in too many versions. The frequency of Streamload can be
reduced by setting the sink.batch.size and sink.batch.interval parameters.
-10. **Flink imports dirty data, how to skip it?**
+10. **Flink imports dirty data, how to skip it? **
When Flink imports data, if there is dirty data, such as field format, length,
etc., it will cause StreamLoad to report an error, and Flink will continue to
retry at this time. If you need to skip, you can disable the strict mode of
StreamLoad (strict_mode=false, max_filter_ratio=1) or filter the data before
the Sink operator.
diff --git a/versioned_docs/version-1.2/ecosystem/mysql-to-doris.md
b/versioned_docs/version-1.2/ecosystem/mysql-to-doris.md
deleted file mode 100644
index 67afcd1f9d2..00000000000
--- a/versioned_docs/version-1.2/ecosystem/mysql-to-doris.md
+++ /dev/null
@@ -1,105 +0,0 @@
----
-{
-
- "title": "Mysql to Doris",
- "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.
--->
-
-# Mysql to Doris
-
-mysql to doris is mainly suitable for automating the creation of doris odbc
tables, mainly implemented with shell scripts
-
-## manual
-
-mysql to doris code
[here](https://github.com/apache/doris/tree/master/extension/mysql_to_doris)
-
-### Directory Structure
-
-```text
-├── mysql_to_doris
-│ ├── conf
-│ │ ├── doris.conf
-│ │ ├── mysql.conf
-│ │ └── tables
-│ ├── all_tables.sh
-│ │
-└── └── user_define_tables.sh
-```
-
-1. all_tables.sh
-
- This script mainly reads all the tables under the mysql specified library
and automatically creates the Doris odbc external table
-
-2. user_define_tables.sh
-
- This script is mainly used for users to customize certain tables under the
specified mysql library to automatically create Doris odbc external tables
-
-3. conf
-
- Configuration file, `doris.conf` is mainly used to configure doris related,
`mysql.conf` is mainly used to configure mysql related, `tables` is mainly used
to configure user-defined mysql library tables
-
-### full
-
-1. Download using mysql to doris
[here](https://github.com/apache/doris/tree/master/extension/mysql_to_doris)
-2. Configuration related files
-
- ```shell
- #doris.conf
- master_host=
- master_port=
- doris_password=
- doris_odbc_name=''
-
- #mysql.conf
- mysql_host=
- mysql_password=
- ```
-
- | Configuration item | illustrate |
- | -------------- | ----------------------- |
- | master_host | Doris FE master node IP |
- | master_port | Doris FE query_port port |
- | doris_password | Doris Password (default root user) |
- | doris_odbc_name | The name of mysql odbc in the odbcinst.ini
configuration file under be/conf |
- | mysql_host | Mysql IP |
- | mysql_password | Mysql Password (default root user) |
-
-3. Execute the `all_tables.sh` script
-
-```
-sh all_tables.sh mysql_db_name doris_db_name
-```
-After successful execution, the files directory will be generated, and the
directory will contain `tables` (table name) and `tables.sql` (doris odbc table
creation statement)
-
-### custom
-
-1. Modify the `conf/tables` file to add the name of the odbc table that needs
to be created
-2. To configure mysql and doris related information, refer to step 2 of full
creation
-3. Execute the `user_define_tables.sh` script
-
-```
-sh user_define_tables.sh mysql_db_name doris_db_name
-```
-
-After successful execution, the user_files directory will be generated, and
the directory will contain `tables.sql` (doris odbc table creation statement)
diff --git
a/versioned_docs/version-1.2/install/source-install/compilation-with-ldb-toolchain.md
b/versioned_docs/version-1.2/install/source-install/compilation-with-ldb-toolchain.md
index 2fe8cebf307..842ce1c765d 100644
---
a/versioned_docs/version-1.2/install/source-install/compilation-with-ldb-toolchain.md
+++
b/versioned_docs/version-1.2/install/source-install/compilation-with-ldb-toolchain.md
@@ -63,7 +63,7 @@ This works for most Linux distributions (CentOS, Ubuntu,
etc.).
3. Download and install other compilation packages
- 1.
[Java8](https://doris-thirdparty-1308700295.cos.ap-beijing.myqcloud.com/tools/jdk-8u391-linux-x64.tar.gz)
+ 1.
[Java8](https://doris-thirdparty-repo.bj.bcebos.com/thirdparty/jdk-8u131-linux-x64.tar.gz)
2. [Apache Maven
3.6.3](https://doris-thirdparty-repo.bj.bcebos.com/thirdparty/apache-maven-3.6.3-bin.tar.gz)
3. [Node
v12.13.0](https://doris-thirdparty-repo.bj.bcebos.com/thirdparty/node-v12.13.0-linux-x64.tar.gz)
diff --git a/versioned_docs/version-1.2/lakehouse/multi-catalog/faq.md
b/versioned_docs/version-1.2/lakehouse/multi-catalog/faq.md
index 9ec3f3ffbc2..e73a0a5bf40 100644
--- a/versioned_docs/version-1.2/lakehouse/multi-catalog/faq.md
+++ b/versioned_docs/version-1.2/lakehouse/multi-catalog/faq.md
@@ -109,3 +109,83 @@ under the License.
```
'fs.defaultFS' = 'hdfs://<your_nameservice_or_actually_HDFS_IP_and_port>'
```
+12. The values of the partition fields in the hudi table can be found on hive,
but they cannot be found on doris.
+
+ Doris and hive currently query hudi differently. Doris needs to add
partition fields to the avsc file of the hudi table structure. If not added, it
will cause Doris to query partition_ Val is empty (even if home. datasource.
live_sync. partition_fields=partition_val is set)
+
+ ```
+ {
+ "type": "record",
+ "name": "record",
+ "fields": [{
+ "name": "partition_val",
+ "type": [
+ "null",
+ "string"
+ ],
+ "doc": "Preset partition field, empty string when not partitioned",
+ "default": null
+ },
+ {
+ "name": "name",
+ "type": "string",
+ "doc": "名称"
+ },
+ {
+ "name": "create_time",
+ "type": "string",
+ "doc": "创建时间"
+ }
+ ]
+ }
+ ```
+
+13. The table in orc format of Hive 1.x may encounter system column names such
as `_col0`, `_col1`, `_col2`... in the underlying orc file schema, which need
to be specified in the catalog configuration. Add `hive.version` to 1.x.x so
that it will use the column names in the hive table for mapping.
+
+ ```sql
+ CREATE CATALOG hive PROPERTIES (
+ 'hive.version' = '1.x.x'
+ );
+ ```
+
+14. When using JDBC Catalog to synchronize MySQL data to Doris, the date data
synchronization error occurs. It is necessary to check whether the MySQL
version corresponds to the MySQL driver package. For example, the driver
com.mysql.cj.jdbc.Driver is required for MySQL8 and above.
+
+15. If an error is reported while configuring Kerberos in the catalog: `SIMPLE
authentication is not enabled. Available:[TOKEN, KERBEROS]`.
+
+ Need to put `core-site.xml` to the `"${DORIS_HOME}/be/conf"` directory.
+
+ If an error is reported while accessing HDFS: `No common protection layer
between client and server`, check the `hadoop.rpc.protection` on the client and
server to make them consistent.
+
+ ```
+ <?xml version="1.0" encoding="UTF-8"?>
+ <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
+
+ <configuration>
+
+ <property>
+ <name>hadoop.security.authentication</name>
+ <value>kerberos</value>
+ </property>
+
+ </configuration>
+ ```
+
+16. The solutions when configuring Kerberos in the catalog and encounter an
error: `Unable to obtain password from user`.
+ - The principal used must exist in the klist, use `klist -kt your.keytab`
to check.
+ - Ensure the catalog configuration correct, such as missing the
`yarn.resourcemanager.principal`.
+ - If the preceding checks are correct, the JDK version installed by yum or
other package-management utility in the current system maybe have an
unsupported encryption algorithm. It is recommended to install JDK by yourself
and set `JAVA_HOME` environment variable.
+
+17. If an error is reported while querying the catalog with Kerberos:
`GSSException: No valid credentials provided (Mechanism level: Failed to find
any Kerberos Ticket)`.
+ - Restarting FE and BE can solve the problem in most cases.
+ - Before the restart all the nodes, can put
`-Djavax.security.auth.useSubjectCredsOnly=false` to the `JAVA_OPTS` in
`"${DORIS_HOME}/be/conf/be.conf"`, which can obtain credentials through the
underlying mechanism, rather than through the application.
+ - Get more solutions to common JAAS errors from the [JAAS
Troubleshooting](https://docs.oracle.com/javase/8/docs/technotes/guides/security/jgss/tutorials/Troubleshooting.html).
+
+18. If an error related to the Hive Metastore is reported while querying the
catalog: `Invalid method name`.
+
+ Configure the `hive.version`.
+
+ ```sql
+ CREATE CATALOG hive PROPERTIES (
+ 'hive.version' = '2.x.x'
+ );
+ ```
diff --git a/versioned_docs/version-1.2/lakehouse/multi-catalog/hive.md
b/versioned_docs/version-1.2/lakehouse/multi-catalog/hive.md
index f82df22ab7c..1a269d67748 100644
--- a/versioned_docs/version-1.2/lakehouse/multi-catalog/hive.md
+++ b/versioned_docs/version-1.2/lakehouse/multi-catalog/hive.md
@@ -34,17 +34,18 @@ Besides Hive, many other systems, such as Iceberg and Hudi,
use Hive Metastore t
When connnecting to Hive, Doris:
-1. Supports Hive version 1/2/3;
-2. Supports both Managed Table and External Table;
-3. Can identify metadata of Hive, Iceberg, and Hudi stored in Hive Metastore;
-4. Supports Hive tables with data stored in JuiceFS, which can be used the
same way as normal Hive tables (put `juicefs-hadoop-x.x.x.jar` in `fe/lib/` and
`apache_hdfs_broker/lib/`).
-5. Supports Hive tables with data stored in CHDFS, which can be used the same
way as normal Hive tables. Follow below steps to prepare doris environment:
+1. Need to put core-site.xml, hdfs-site.xml and hive-site.xml in the conf
directory of FE and BE. First read the hadoop configuration file in the conf
directory, and then read the related to the environment variable
`HADOOP_CONF_DIR` configuration file.
+2. Supports Hive version 1/2/3;
+3. Supports both Managed Table and External Table;
+4. Can identify metadata of Hive, Iceberg, and Hudi stored in Hive Metastore;
+5. Supports Hive tables with data stored in JuiceFS, which can be used the
same way as normal Hive tables (put `juicefs-hadoop-x.x.x.jar` in `fe/lib/` and
`apache_hdfs_broker/lib/`).
+6. Supports Hive tables with data stored in CHDFS, which can be used the same
way as normal Hive tables. Follow below steps to prepare doris environment:
1. put chdfs_hadoop_plugin_network-x.x.jar in fe/lib/ and
apache_hdfs_broker/lib/
2. copy core-site.xml and hdfs-site.xml from hive cluster to fe/conf/ and
apache_hdfs_broker/conf
<version since="dev">
-6. Supports Hive / Iceberg tables with data stored in GooseFS(GFS), which can
be used the same way as normal Hive tables. Follow below steps to prepare doris
environment:
+7. Supports Hive / Iceberg tables with data stored in GooseFS(GFS), which can
be used the same way as normal Hive tables. Follow below steps to prepare doris
environment:
1. put goosefs-x.x.x-client.jar in fe/lib/ and apache_hdfs_broker/lib/
2. add extra properties 'fs.AbstractFileSystem.gfs.impl' =
'com.qcloud.cos.goosefs.hadoop.GooseFileSystem', 'fs.gfs.impl' =
'com.qcloud.cos.goosefs.hadoop.FileSystem' when creating catalog
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
index a64a52b5705..7cfdcec0d09 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
@@ -42,6 +42,13 @@ mysql> select bitmap_count(bitmap_and(to_bitmap(1),
to_bitmap(2))) cnt;
| 0 |
+------+
+mysql> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(2)));
++----------------------------------------------------------+
+| bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(2))) |
++----------------------------------------------------------+
+| |
++----------------------------------------------------------+
+
mysql> select bitmap_count(bitmap_and(to_bitmap(1), to_bitmap(1))) cnt;
+------+
| cnt |
@@ -49,28 +56,28 @@ mysql> select bitmap_count(bitmap_and(to_bitmap(1),
to_bitmap(1))) cnt;
| 1 |
+------+
-MySQL> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1)));
+mysql> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1)));
+----------------------------------------------------------+
| bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1))) |
+----------------------------------------------------------+
| 1 |
+----------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+-----------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'))) |
+-----------------------------------------------------------------------------------------------------------------------+
| 1,2
|
+-----------------------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),bitmap_empty()));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),bitmap_empty()));
+---------------------------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'), bitmap_empty())) |
+---------------------------------------------------------------------------------------------------------------------------------------+
|
|
+---------------------------------------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),NULL));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),NULL));
+-----------------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'), NULL)) |
+-----------------------------------------------------------------------------------------------------------------------------+
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
index e370ce90b31..b0f13dced10 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
@@ -41,6 +41,27 @@ mysql> select
bitmap_count(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_fro
+------+
| 2 |
+------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_from_string('3,4,5')));
++--------------------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),
bitmap_from_string('3,4,5'))) |
++--------------------------------------------------------------------------------------------+
+| 1,2
|
++--------------------------------------------------------------------------------------------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_empty())) ;
++-------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),
bitmap_empty())) |
++-------------------------------------------------------------------------------+
+| 1,2,3
|
++-------------------------------------------------------------------------------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),NULL));
++---------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'), NULL)) |
++---------------------------------------------------------------------+
+| NULL |
++---------------------------------------------------------------------+
```
### keywords
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
index 6c5a90cceac..a8b4bbdcc1a 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
@@ -45,6 +45,13 @@ mysql> select bitmap_count(bitmap_empty());
+------------------------------+
| 0 |
+------------------------------+
+
+mysql> select bitmap_to_string(bitmap_empty());
++----------------------------------+
+| bitmap_to_string(bitmap_empty()) |
++----------------------------------+
+| |
++----------------------------------+
```
### keywords
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
index 7087abf531e..a8dc6b19b5e 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
@@ -36,19 +36,19 @@ Returns true if the second bitmap contains an empty element.
### example
```
-mysql> select bitmap_has_all(bitmap_from_string("0, 1, 2"),
bitmap_from_string("1, 2")) cnt;
-+------+
-| cnt |
-+------+
-| 1 |
-+------+
-
-mysql> select bitmap_has_all(bitmap_empty(), bitmap_from_string("1, 2")) cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
+mysql> select bitmap_has_all(bitmap_from_string("0, 1, 2"),
bitmap_from_string("1, 2"));
++---------------------------------------------------------------------------+
+| bitmap_has_all(bitmap_from_string('0, 1, 2'), bitmap_from_string('1, 2')) |
++---------------------------------------------------------------------------+
+| 1 |
++---------------------------------------------------------------------------+
+
+mysql> select bitmap_has_all(bitmap_empty(), bitmap_from_string("1, 2"));
++------------------------------------------------------------+
+| bitmap_has_all(bitmap_empty(), bitmap_from_string('1, 2')) |
++------------------------------------------------------------+
+| 0 |
++------------------------------------------------------------+
```
### keywords
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
index 4e47b6f343c..0466aeb3228 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
@@ -35,19 +35,19 @@ Calculate whether there are intersecting elements in the
two Bitmap columns. The
### example
```
-mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(2)) cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
-
-mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(1)) cnt;
-+------+
-| cnt |
-+------+
-| 1 |
-+------+
+mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(2));
++--------------------------------------------+
+| bitmap_has_any(to_bitmap(1), to_bitmap(2)) |
++--------------------------------------------+
+| 0 |
++--------------------------------------------+
+
+mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(1));
++--------------------------------------------+
+| bitmap_has_any(to_bitmap(1), to_bitmap(1)) |
++--------------------------------------------+
+| 1 |
++--------------------------------------------+
```
### keywords
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
index e633df9b942..a9a9f03e6de 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
@@ -39,12 +39,12 @@ cat data | curl --location-trusted -u user:passwd -T - -H
"columns: dt,page,devi
### example
```
-mysql> select bitmap_count(bitmap_hash64('hello'));
-+------------------------------------+
-| bitmap_count(bitmap_hash64('hello')) |
-+------------------------------------+
-| 1 |
-+------------------------------------+
+mysql> select bitmap_to_string(bitmap_hash64('hello'));
++------------------------------------------+
+| bitmap_to_string(bitmap_hash64('hello')) |
++------------------------------------------+
+| 15231136565543391023 |
++------------------------------------------+
```
### keywords
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
index 4d262480917..c3e5a069bd0 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
@@ -35,16 +35,16 @@ Calculate the set after lhs minus rhs, return the new
bitmap.
### example
```
-mysql> select
bitmap_count(bitmap_not(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4')))
cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
+mysql> select
bitmap_to_string(bitmap_not(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4')));
++----------------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_not(bitmap_from_string('2,3'),
bitmap_from_string('1,2,3,4'))) |
++----------------------------------------------------------------------------------------+
+|
|
++----------------------------------------------------------------------------------------+
mysql> select
bitmap_to_string(bitmap_not(bitmap_from_string('2,3,5'),bitmap_from_string('1,2,3,4')));
+----------------------------------------------------------------------------------------+
-| bitmap_to_string(bitmap_xor(bitmap_from_string('2,3,5'),
bitmap_from_string('1,2,3,4'))) |
+| bitmap_to_string(bitmap_not(bitmap_from_string('2,3,5'),
bitmap_from_string('1,2,3,4'))) |
+----------------------------------------------------------------------------------------+
| 5
|
+----------------------------------------------------------------------------------------+
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
index e5e9be9ac69..6754d8f321e 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
@@ -35,42 +35,49 @@ Compute union of two or more input bitmaps, returns the new
bitmap.
### example
```
-mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(2))) cnt;
+mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(1))) cnt;
+------+
| cnt |
+------+
-| 2 |
+| 1 |
+------+
-mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(1))) cnt;
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(1))) ;
++---------------------------------------------------------+
+| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(1))) |
++---------------------------------------------------------+
+| 1 |
++---------------------------------------------------------+
+
+mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(2))) cnt;
+------+
| cnt |
+------+
-| 1 |
+| 2 |
+------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2)));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2)));
+---------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2))) |
+---------------------------------------------------------+
| 1,2 |
+---------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), NULL));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), NULL));
+--------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10),
to_bitmap(0), NULL)) |
+--------------------------------------------------------------------------------------------+
-| NULL
|
+| 0,1,2,10
|
+--------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1),
to_bitmap(2),to_bitmap(10),to_bitmap(0),bitmap_empty()));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1),
to_bitmap(2),to_bitmap(10),to_bitmap(0),bitmap_empty()));
+------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10),
to_bitmap(0), bitmap_empty())) |
+------------------------------------------------------------------------------------------------------+
| 0,1,2,10
|
+------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(10),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'))) ;
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(10),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'))) ;
+--------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(10), bitmap_from_string('1,2'),
bitmap_from_string('1,2,3,4,5'))) |
+--------------------------------------------------------------------------------------------------------+
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_expr_calculate.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_expr_calculate.md
deleted file mode 100644
index e530de904d3..00000000000
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_expr_calculate.md
+++ /dev/null
@@ -1,47 +0,0 @@
----
-{
-"title": "orthogonal_bitmap_expr_calculate",
-"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.
--->
-
-## orthogonal_bitmap_expr_calculate
-### description
-#### Syntax
-
-`BITMAP ORTHOGONAL_BITMAP_EXPR_CALCULATE(bitmap_column, column_to_filter,
input_string)`
-The first parameter is the Bitmap column, the second parameter is the
dimension column used for filtering, that is, the calculated key column, and
the third parameter is the calculation expression string, meaning that the
bitmap intersection, union, and difference set expression is calculated
according to the key column
-The calculators supported by the expression:&represents intersection
calculation, | represents union calculation, - represents difference
calculation, ^ represents XOR calculation, and \ represents escape characters
-
-### example
-
-```
-select orthogonal_bitmap_expr_calculate(user_id, tag,
'(833736|999777)&(1308083|231207)&(1000|20000-30000)') from user_tag_bitmap
where tag in (833736,999777,130808,231207,1000,20000,30000);
-Note: 1000, 20000, 30000 plastic tags represent different labels of users
-```
-
-```
-select orthogonal_bitmap_expr_calculate(user_id, tag,
'(A:a/b|B:2\\-4)&(C:1-D:12)&E:23') from user_str_tag_bitmap where tag in
('A:a/b', 'B:2-4', 'C:1', 'D:12', 'E:23');
-Note: 'A:a/b', 'B:2-4', etc. are string types tag, representing different
labels of users, where 'B:2-4' needs to be escaped as'B:2\\-4'
-```
-
-### keywords
-
- ORTHOGONAL_BITMAP_EXPR_CALCULATE,BITMAP
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_expr_calculate_count.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_expr_calculate_count.md
deleted file mode 100644
index b7a34ff2969..00000000000
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_expr_calculate_count.md
+++ /dev/null
@@ -1,47 +0,0 @@
----
-{
-"title": "orthogonal_bitmap_expr_calculate_count",
-"language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
- http://www.apache.org/licenses/LICENSE-2.0
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## orthogonal_bitmap_expr_calculate_count
-### description
-#### Syntax
-
-`BITMAP ORTHOGONAL_BITMAP_EXPR_CALCULATE_COUNT(bitmap_column,
column_to_filter, input_string)`
-Calculate the bitmap intersection, union and difference set of expressions to
calculate the count function. The first parameter is the Bitmap column, the
second parameter is the dimension column used for filtering, that is, the
calculated key column, and the third parameter is the calculation expression
string, meaning that the bitmap intersection, union and difference set
expression is calculated according to the key column
-The calculators supported by the expression:&represents intersection
calculation, | represents union calculation, - represents difference
calculation, ^ represents XOR calculation, and \ represents escape characters
-
-### example
-
-```
-select orthogonal_bitmap_expr_calculate_count(user_id, tag,
'(833736|999777)&(1308083|231207)&(1000|20000-30000)') from user_tag_bitmap
where tag in (833736,999777,130808,231207,1000,20000,30000);
-Note: 1000, 20000, 30000 plastic tags represent different labels of users
-```
-
-```
-select orthogonal_bitmap_expr_calculate_count(user_id, tag,
'(A:a/b|B:2\\-4)&(C:1-D:12)&E:23') from user_str_tag_bitmap where tag in
('A:a/b', 'B:2-4', 'C:1', 'D:12', 'E:23');
-Note: 'A:a/b', 'B:2-4', etc. are string types tag, representing different
labels of users, where 'B:2-4' needs to be escaped as'B:2\\-4'
-```
-
-### keywords
-
- ORTHOGONAL_BITMAP_EXPR_CALCULATE_COUNT,BITMAP
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/json_extract.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/json_extract.md
index d6b9674f9a3..53c924f0a23 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/json_extract.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/json-functions/json_extract.md
@@ -24,8 +24,6 @@ under the License.
## json_extract
-<version since="dev"></version>
-
### description
#### Syntax
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/char.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/char.md
deleted file mode 100644
index 71e574077cb..00000000000
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/string-functions/char.md
+++ /dev/null
@@ -1,69 +0,0 @@
----
-{
- "title": "char",
- "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.
--->
-
-<version since="1.2">
-
-## function char
-### description
-#### Syntax
-
-`VARCHAR char(INT,..., [USING charset_name])`
-
-Interprets each argument as an integer and returns a string consisting of the
characters given by the code values of those integers. `NULL` values are
skipped.
-
-If the result string is illegal for the given character set, the result from
`CHAR()` becomes `NULL`.
-
-Arguments larger than `255` are converted into multiple result bytes. For
example, `char(15049882)` is equivalent to `char(229, 164, 154)`.
-
-Currently only `utf8` is supported for `charset_name`.
-</version>
-
-### example
-
-```
-mysql> select char(68, 111, 114, 105, 115);
-+--------------------------------------+
-| char('utf8', 68, 111, 114, 105, 115) |
-+--------------------------------------+
-| Doris |
-+--------------------------------------+
-
-mysql> select char(15049882, 15179199, 14989469);
-+--------------------------------------------+
-| char('utf8', 15049882, 15179199, 14989469) |
-+--------------------------------------------+
-| 多睿丝 |
-+--------------------------------------------+
-
-mysql> select char(255);
-+-------------------+
-| char('utf8', 255) |
-+-------------------+
-| NULL |
-+-------------------+
-```
-### keywords
- CHAR
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-MODIFY-BROKER.md
b/versioned_docs/version-1.2/sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-MODIFY-BROKER.md
deleted file mode 100644
index 6db1368d792..00000000000
---
a/versioned_docs/version-1.2/sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-MODIFY-BROKER.md
+++ /dev/null
@@ -1,38 +0,0 @@
----
-{
- "title": "ALTER-SYSTEM-MODIFY-BROKER",
- "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.
--->
-
-## ALTER-SYSTEM-MODIFY-BROKER
-
-### Description
-
-### Example
-
-### Keywords
-
- ALTER, SYSTEM, MODIFY, BROKER, ALTER SYSTEM
-
-### Best Practice
-
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
b/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
index 7610722e6f5..3ebf9e6f936 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
@@ -74,6 +74,7 @@ illustrate:
- `exec_mem_limit`: Export the upper limit of the memory usage of a single
BE node, the default is 2GB, and the unit is bytes.
- `timeout`: The timeout period of the export job, the default is 2 hours,
the unit is seconds.
- `tablet_num_per_task`: The maximum number of tablets each subtask can
allocate to scan.
+ - `format`: Specifies the file format, currently only supports csv,
csv_with_names, csv_with_names_and_types. If without specified, the default is
csv.
- `WITH BROKER`
diff --git a/versioned_sidebars/version-1.2-sidebars.json
b/versioned_sidebars/version-1.2-sidebars.json
index 8d33391ade1..92a7c592b4b 100644
--- a/versioned_sidebars/version-1.2-sidebars.json
+++ b/versioned_sidebars/version-1.2-sidebars.json
@@ -230,7 +230,6 @@
"ecosystem/datax",
"ecosystem/seatunnel",
"ecosystem/kyuubi",
- "ecosystem/mysql-to-doris",
"ecosystem/logstash",
"ecosystem/beats",
"ecosystem/plugin-development-manual",
@@ -421,7 +420,6 @@
"sql-manual/sql-functions/string-functions/initcap",
"sql-manual/sql-functions/string-functions/repeat",
"sql-manual/sql-functions/string-functions/reverse",
-
"sql-manual/sql-functions/string-functions/char",
"sql-manual/sql-functions/string-functions/concat",
"sql-manual/sql-functions/string-functions/concat_ws",
"sql-manual/sql-functions/string-functions/substr",
@@ -560,8 +558,6 @@
"sql-manual/sql-functions/bitmap-functions/bitmap_intersect",
"sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_intersect",
"sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_intersect_count",
-
"sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_expr_calculate",
-
"sql-manual/sql-functions/bitmap-functions/orthogonal_bitmap_expr_calculate_count",
"sql-manual/sql-functions/bitmap-functions/bitmap_hash64"
]
},
@@ -601,6 +597,7 @@
"sql-manual/sql-functions/json-functions/json_array",
"sql-manual/sql-functions/json-functions/json_object",
"sql-manual/sql-functions/json-functions/json_quote",
+
"sql-manual/sql-functions/json-functions/json_unquote",
"sql-manual/sql-functions/json-functions/json_valid",
"sql-manual/sql-functions/json-functions/json_extract"
]
@@ -750,7 +747,6 @@
"sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-ADD-OBSERVER",
"sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-MODIFY-BACKEND",
"sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-ADD-FOLLOWER",
-
"sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-MODIFY-BROKER",
"sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-ADD-BROKER",
"sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-ADD-BACKEND",
"sql-manual/sql-reference/Cluster-Management-Statements/ALTER-SYSTEM-DROP-BACKEND"
@@ -947,6 +943,7 @@
"sql-manual/sql-reference/Show-Statements/SHOW-WHITE-LIST",
"sql-manual/sql-reference/Show-Statements/SHOW-WARNING",
"sql-manual/sql-reference/Show-Statements/SHOW-TABLET",
+
"sql-manual/sql-reference/Show-Statements/SHOW-TABLETS-BELONG",
"sql-manual/sql-reference/Show-Statements/SHOW-VARIABLES",
"sql-manual/sql-reference/Show-Statements/SHOW-PLUGINS",
"sql-manual/sql-reference/Show-Statements/SHOW-ROLES",
@@ -1164,6 +1161,7 @@
"admin-manual/http-actions/fe/show-meta-info-action",
"admin-manual/http-actions/fe/show-proc-action",
"admin-manual/http-actions/fe/show-runtime-info-action",
+
"admin-manual/http-actions/fe/show-table-data-action",
"admin-manual/http-actions/fe/statement-execution-action",
"admin-manual/http-actions/fe/table-query-plan-action",
"admin-manual/http-actions/fe/table-row-count-action",
diff --git a/versioned_sidebars/version-2.0-sidebars.json
b/versioned_sidebars/version-2.0-sidebars.json
index ad4c735f6ff..7bb5231282a 100644
--- a/versioned_sidebars/version-2.0-sidebars.json
+++ b/versioned_sidebars/version-2.0-sidebars.json
@@ -214,7 +214,8 @@
"lakehouse/multi-catalog/dlf",
"lakehouse/multi-catalog/max-compute",
"lakehouse/multi-catalog/es",
- "lakehouse/multi-catalog/jdbc"
+ "lakehouse/multi-catalog/jdbc",
+ "lakehouse/multi-catalog/faq-multi-catalog"
]
},
"lakehouse/file",
@@ -246,7 +247,8 @@
"items": [
"ecosystem/udf/contribute-udf",
"ecosystem/udf/remote-user-defined-function",
- "ecosystem/udf/java-user-defined-function"
+ "ecosystem/udf/java-user-defined-function",
+ "ecosystem/udf/native-user-defined-function"
]
},
{
@@ -345,6 +347,7 @@
"sql-manual/sql-functions/date-time-functions/from-days",
"sql-manual/sql-functions/date-time-functions/last-day",
"sql-manual/sql-functions/date-time-functions/to-monday",
+
"sql-manual/sql-functions/date-time-functions/from-second",
"sql-manual/sql-functions/date-time-functions/from-unixtime",
"sql-manual/sql-functions/date-time-functions/unix-timestamp",
"sql-manual/sql-functions/date-time-functions/utc-timestamp",
@@ -859,7 +862,8 @@
"sql-manual/sql-reference/Database-Administration-Statements/RECOVER",
"sql-manual/sql-reference/Database-Administration-Statements/KILL",
"sql-manual/sql-reference/Database-Administration-Statements/ADMIN-REBALANCE-DISK",
-
"sql-manual/sql-reference/Database-Administration-Statements/ADMIN-CANCEL-REBALANCE-DISK"
+
"sql-manual/sql-reference/Database-Administration-Statements/ADMIN-CANCEL-REBALANCE-DISK",
+
"sql-manual/sql-reference/Database-Administration-Statements/enable-feature"
]
},
{
@@ -1169,6 +1173,7 @@
"admin-manual/maint-monitor/be-olap-error-code",
"admin-manual/maint-monitor/doris-error-code",
"admin-manual/maint-monitor/tablet-meta-tool",
+ "admin-manual/maint-monitor/tablet-restore-tool",
"admin-manual/maint-monitor/monitor-alert",
"admin-manual/maint-monitor/tablet-local-debug",
"admin-manual/maint-monitor/metadata-operation",
@@ -1261,6 +1266,7 @@
"admin-manual/http-actions/fe/show-meta-info-action",
"admin-manual/http-actions/fe/show-proc-action",
"admin-manual/http-actions/fe/show-runtime-info-action",
+
"admin-manual/http-actions/fe/show-table-data-action",
"admin-manual/http-actions/fe/statement-execution-action",
"admin-manual/http-actions/fe/table-query-plan-action",
"admin-manual/http-actions/fe/table-row-count-action",
@@ -1322,6 +1328,7 @@
"type": "category",
"label": "Release notes",
"items": [
+ "releasenotes/release-2.0.3",
"releasenotes/release-2.0.2",
"releasenotes/release-2.0.1",
"releasenotes/release-2.0.0",
@@ -1342,4 +1349,4 @@
]
}
]
-}
\ No newline at end of file
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]