This is an automated email from the ASF dual-hosted git repository.
jiafengzheng 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 ba1c42a3b2e [typo](doc)delete CREATE-EXTERNAL_TABLE docs 1.2 (#373)
ba1c42a3b2e is described below
commit ba1c42a3b2eb24b931f87d0a3605537b0ec253cd
Author: ZhenchaoXu <49646212+i...@users.noreply.github.com>
AuthorDate: Tue Dec 26 16:43:08 2023 +0800
[typo](doc)delete CREATE-EXTERNAL_TABLE docs 1.2 (#373)
---
.../Create/CREATE-EXTERNAL-TABLE.md | 272 --------------------
.../Create/CREATE-EXTERNAL-TABLE.md | 274 ---------------------
versioned_sidebars/version-1.2-sidebars.json | 1 -
3 files changed, 547 deletions(-)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-EXTERNAL-TABLE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-EXTERNAL-TABLE.md
deleted file mode 100644
index 3f32a452ac3..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-EXTERNAL-TABLE.md
+++ /dev/null
@@ -1,272 +0,0 @@
----
-{
- "title": "CREATE-EXTERNAL-TABLE",
- "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.
--->
-
-## CREATE-EXTERNAL-TABLE
-
-### Name
-
-CREATE EXTERNAL TABLE
-
-### Description
-
-此语句用来创建外部表，具体语法参阅 [CREATE TABLE](./CREATE-TABLE.md)。
-
-主要通过 ENGINE 类型来标识是哪种类型的外部表，目前可选 MYSQL、BROKER、HIVE、ICEBERG
-、HUDI
-1. 如果是 mysql，则需要在 properties 提供以下信息：
-
- ```sql
- PROPERTIES (
- "host" = "mysql_server_host",
- "port" = "mysql_server_port",
- "user" = "your_user_name",
- "password" = "your_password",
- "database" = "database_name",
- "table" = "table_name"
- )
- ```
- 以及一个可选属性"charset"，可以用来设置mysql连接的字符集, 默认值是"utf8"。如有需要,你可以设置为另外一个字符集"utf8mb4"。
-
- 注意：
-
- - "table" 条目中的 "table_name" 是 mysql 中的真实表名。而 CREATE TABLE 语句中的 table_name
是该 mysql 表在 Doris 中的名字，可以不同。
-
- - 在 Doris 创建 mysql 表的目的是可以通过 Doris 访问 mysql 数据库。而 Doris 本身并不维护、存储任何 mysql
数据。
-
-2. 如果是 broker，表示表的访问需要通过指定的broker, 需要在 properties 提供以下信息：
-
- ```sql
- PROPERTIES (
- "broker_name" = "broker_name",
- "path" = "file_path1[,file_path2]",
- "column_separator" = "value_separator"
- "line_delimiter" = "value_delimiter"
- )
- ```
-
- 另外还需要提供Broker需要的Property信息，通过BROKER PROPERTIES来传递，例如HDFS需要传入
-
- ```sql
- BROKER PROPERTIES(
- "username" = "name",
- "password" = "password"
- )
- ```
-
- 这个根据不同的Broker类型，需要传入的内容也不相同
-
- 注意：
-
- - "path" 中如果有多个文件，用逗号[,]分割。如果文件名中包含逗号，那么使用 %2c 来替代。如果文件名中包含 %，使用 %25 代替
- - 现在文件内容格式支持CSV，支持GZ，BZ2，LZ4，LZO(LZOP) 压缩格式。
-
-3. 如果是 hive，则需要在 properties 提供以下信息：
-
- ```sql
- PROPERTIES (
- "database" = "hive_db_name",
- "table" = "hive_table_name",
- "hive.metastore.uris" = "thrift://127.0.0.1:9083"
- )
- ```
-
- 其中 database 是 hive 表对应的库名字，table 是 hive 表的名字，hive.metastore.uris 是 hive
metastore 服务地址。
-
-4. 如果是 iceberg，则需要在 properties 中提供以下信息：
-
- ```sql
- PROPERTIES (
- "iceberg.database" = "iceberg_db_name",
- "iceberg.table" = "iceberg_table_name",
- "iceberg.hive.metastore.uris" = "thrift://127.0.0.1:9083",
- "iceberg.catalog.type" = "HIVE_CATALOG"
- )
- ```
-
- 其中 database 是 Iceberg 对应的库名；
- table 是 Iceberg 中对应的表名；
- hive.metastore.uris 是 hive metastore 服务地址；
- catalog.type 默认为 HIVE_CATALOG。当前仅支持 HIVE_CATALOG，后续会支持更多 Iceberg catalog 类型。
-
-5. 如果是 hudi，则需要在 properties 中提供以下信息：
-
- ```sql
- PROPERTIES (
- "hudi.database" = "hudi_db_in_hive_metastore",
- "hudi.table" = "hudi_table_in_hive_metastore",
- "hudi.hive.metastore.uris" = "thrift://127.0.0.1:9083"
- )
- ````
-
- 其中 hudi.database 是 hive 表对应的库名字，hudi.table 是 hive 表的名字，hive.metastore.uris
是 hive metastore 服务地址。
-
-### Example
-
-1. 创建MYSQL外部表
-
- 直接通过外表信息创建mysql表
-
- ```sql
- CREATE EXTERNAL TABLE example_db.table_mysql
- (
- k1 DATE,
- k2 INT,
- k3 SMALLINT,
- k4 VARCHAR(2048),
- k5 DATETIME
- )
- ENGINE=mysql
- PROPERTIES
- (
- "host" = "127.0.0.1",
- "port" = "8239",
- "user" = "mysql_user",
- "password" = "mysql_passwd",
- "database" = "mysql_db_test",
- "table" = "mysql_table_test",
- "charset" = "utf8mb4"
- )
- ```
-
- 通过External Catalog Resource创建mysql表
-
- ```sql
- # 先创建Resource
- CREATE EXTERNAL RESOURCE "mysql_resource"
- PROPERTIES
- (
- "type" = "odbc_catalog",
- "user" = "mysql_user",
- "password" = "mysql_passwd",
- "host" = "127.0.0.1",
- "port" = "8239"
- );
-
- # 再通过Resource创建mysql外部表
- CREATE EXTERNAL TABLE example_db.table_mysql
- (
- k1 DATE,
- k2 INT,
- k3 SMALLINT,
- k4 VARCHAR(2048),
- k5 DATETIME
- )
- ENGINE=mysql
- PROPERTIES
- (
- "odbc_catalog_resource" = "mysql_resource",
- "database" = "mysql_db_test",
- "table" = "mysql_table_test"
- )
- ```
-
-2. 创建一个数据文件存储在HDFS上的 broker 外部表, 数据使用 "|" 分割，"\n" 换行
-
- ```sql
- CREATE EXTERNAL TABLE example_db.table_broker (
- k1 DATE,
- k2 INT,
- k3 SMALLINT,
- k4 VARCHAR(2048),
- k5 DATETIME
- )
- ENGINE=broker
- PROPERTIES (
- "broker_name" = "hdfs",
- "path" =
"hdfs://hdfs_host:hdfs_port/data1,hdfs://hdfs_host:hdfs_port/data2,hdfs://hdfs_host:hdfs_port/data3%2c4",
- "column_separator" = "|",
- "line_delimiter" = "\n"
- )
- BROKER PROPERTIES (
- "username" = "hdfs_user",
- "password" = "hdfs_password"
- )
- ```
-
-3. 创建一个hive外部表
-
- ```sql
- CREATE TABLE example_db.table_hive
- (
- k1 TINYINT,
- k2 VARCHAR(50),
- v INT
- )
- ENGINE=hive
- PROPERTIES
- (
- "database" = "hive_db_name",
- "table" = "hive_table_name",
- "hive.metastore.uris" = "thrift://127.0.0.1:9083"
- );
- ```
-
-4. 创建一个 Iceberg 外表
-
- ```sql
- CREATE TABLE example_db.t_iceberg
- ENGINE=ICEBERG
- PROPERTIES (
- "iceberg.database" = "iceberg_db",
- "iceberg.table" = "iceberg_table",
- "iceberg.hive.metastore.uris" = "thrift://127.0.0.1:9083",
- "iceberg.catalog.type" = "HIVE_CATALOG"
- );
- ```
-
-5. 创建一个 Hudi 外表
-
- 创建时不指定schema(推荐)
- ```sql
- CREATE TABLE example_db.t_hudi
- ENGINE=HUDI
- PROPERTIES (
- "hudi.database" = "hudi_db_in_hive_metastore",
- "hudi.table" = "hudi_table_in_hive_metastore",
- "hudi.hive.metastore.uris" = "thrift://127.0.0.1:9083"
- );
- ````
-
- 创建时指定schema
- ```sql
- CREATE TABLE example_db.t_hudi (
- `id` int NOT NULL COMMENT "id number",
- `name` varchar(10) NOT NULL COMMENT "user name"
- )
- ENGINE=HUDI
- PROPERTIES (
- "hudi.database" = "hudi_db_in_hive_metastore",
- "hudi.table" = "hudi_table_in_hive_metastore",
- "hudi.hive.metastore.uris" = "thrift://127.0.0.1:9083"
- );
- ````
-
-### Keywords
-
- CREATE, EXTERNAL, TABLE
-
-### Best Practice
-
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-EXTERNAL-TABLE.md
b/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-EXTERNAL-TABLE.md
deleted file mode 100644
index 80417979639..00000000000
---
a/versioned_docs/version-1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-EXTERNAL-TABLE.md
+++ /dev/null
@@ -1,274 +0,0 @@
----
-{
- "title": "CREATE-EXTERNAL-TABLE",
- "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.
--->
-
-## CREATE-EXTERNAL-TABLE
-
-### Name
-
-CREATE EXTERNAL TABLE
-
-### Description
-
-This statement is used to create an external table, see [CREATE
TABLE](./CREATE-TABLE.md) for the specific syntax.
-
-Which type of external table is mainly identified by the ENGINE type,
currently MYSQL, BROKER, HIVE, ICEBERG, HUDI are optional
-
-1. If it is mysql, you need to provide the following information in properties:
-
- ```sql
- PROPERTIES (
- "host" = "mysql_server_host",
- "port" = "mysql_server_port",
- "user" = "your_user_name",
- "password" = "your_password",
- "database" = "database_name",
- "table" = "table_name"
- )
- ````
- and there is an optional propertiy "charset" which can set character fom
mysql connection, default value is "utf8". You can set another value "utf8mb4"
instead of "utf8" when you need.
-
- Notice:
-
- - "table_name" in "table" entry is the real table name in mysql. The
table_name in the CREATE TABLE statement is the name of the mysql table in
Doris, which can be different.
-
- - The purpose of creating a mysql table in Doris is to access the mysql
database through Doris. Doris itself does not maintain or store any mysql data.
-
-2. If it is a broker, it means that the access to the table needs to pass
through the specified broker, and the following information needs to be
provided in properties:
-
- ```sql
- PROPERTIES (
- "broker_name" = "broker_name",
- "path" = "file_path1[,file_path2]",
- "column_separator" = "value_separator"
- "line_delimiter" = "value_delimiter"
- )
- ````
-
- In addition, you need to provide the Property information required by the
Broker, and pass it through the BROKER PROPERTIES, for example, HDFS needs to
pass in
-
- ```sql
- BROKER PROPERTIES(
- "username" = "name",
- "password" = "password"
- )
- ````
-
- According to different Broker types, the content that needs to be passed in
is also different.
-
- Notice:
-
- - If there are multiple files in "path", separate them with comma [,]. If
the filename contains a comma, use %2c instead. If the filename contains %, use
%25 instead
- - Now the file content format supports CSV, and supports GZ, BZ2, LZ4, LZO
(LZOP) compression formats.
-
-3. If it is hive, you need to provide the following information in properties:
-
- ```sql
- PROPERTIES (
- "database" = "hive_db_name",
- "table" = "hive_table_name",
- "hive.metastore.uris" = "thrift://127.0.0.1:9083"
- )
- ````
-
- Where database is the name of the library corresponding to the hive table,
table is the name of the hive table, and hive.metastore.uris is the address of
the hive metastore service.
-
-4. In case of iceberg, you need to provide the following information in
properties:
-
- ```sql
- PROPERTIES (
- "iceberg.database" = "iceberg_db_name",
- "iceberg.table" = "iceberg_table_name",
- "iceberg.hive.metastore.uris" = "thrift://127.0.0.1:9083",
- "iceberg.catalog.type" = "HIVE_CATALOG"
- )
- ````
-
- Where database is the library name corresponding to Iceberg;
- table is the corresponding table name in Iceberg;
- hive.metastore.uris is the hive metastore service address;
- catalog.type defaults to HIVE_CATALOG. Currently only HIVE_CATALOG is
supported, more Iceberg catalog types will be supported in the future.
-
-5. In case of hudi, you need to provide the following information in
properties:
-
- ```sql
- PROPERTIES (
- "hudi.database" = "hudi_db_in_hive_metastore",
- "hudi.table" = "hudi_table_in_hive_metastore",
- "hudi.hive.metastore.uris" = "thrift://127.0.0.1:9083"
- )
- ````
-
- Where hudi.database is the corresponding database name in HiveMetaStore;
- hudi.table is the corresponding table name in HiveMetaStore;
- hive.metastore.uris is the hive metastore service address;
-
-### Example
-
-1. Create a MYSQL external table
-
- Create mysql table directly from outer table information
-
- ```sql
- CREATE EXTERNAL TABLE example_db.table_mysql
- (
- k1 DATE,
- k2 INT,
- k3 SMALLINT,
- k4 VARCHAR(2048),
- k5 DATETIME
- )
- ENGINE=mysql
- PROPERTIES
- (
- "host" = "127.0.0.1",
- "port" = "8239",
- "user" = "mysql_user",
- "password" = "mysql_passwd",
- "database" = "mysql_db_test",
- "table" = "mysql_table_test",
- "charset" = "utf8mb4"
- )
- ````
-
- Create mysql table through External Catalog Resource
-
- ```sql
- # Create Resource first
- CREATE EXTERNAL RESOURCE "mysql_resource"
- PROPERTIES
- (
- "type" = "odbc_catalog",
- "user" = "mysql_user",
- "password" = "mysql_passwd",
- "host" = "127.0.0.1",
- "port" = "8239"
- );
-
- # Then create mysql external table through Resource
- CREATE EXTERNAL TABLE example_db.table_mysql
- (
- k1 DATE,
- k2 INT,
- k3 SMALLINT,
- k4 VARCHAR(2048),
- k5 DATETIME
- )
- ENGINE=mysql
- PROPERTIES
- (
- "odbc_catalog_resource" = "mysql_resource",
- "database" = "mysql_db_test",
- "table" = "mysql_table_test"
- )
- ````
-
-2. Create a broker external table with data files stored on HDFS, the data is
split with "|", and "\n" is newline
-
- ```sql
- CREATE EXTERNAL TABLE example_db.table_broker (
- k1 DATE,
- k2 INT,
- k3 SMALLINT,
- k4 VARCHAR(2048),
- k5 DATETIME
- )
- ENGINE=broker
- PROPERTIES (
- "broker_name" = "hdfs",
- "path" =
"hdfs://hdfs_host:hdfs_port/data1,hdfs://hdfs_host:hdfs_port/data2,hdfs://hdfs_host:hdfs_port/data3%2c4",
- "column_separator" = "|",
- "line_delimiter" = "\n"
- )
- BROKER PROPERTIES (
- "username" = "hdfs_user",
- "password" = "hdfs_password"
- )
- ````
-
-3. Create a hive external table
-
- ```sql
- CREATE TABLE example_db.table_hive
- (
- k1 TINYINT,
- k2 VARCHAR(50),
- v INT
- )
- ENGINE=hive
- PROPERTIES
- (
- "database" = "hive_db_name",
- "table" = "hive_table_name",
- "hive.metastore.uris" = "thrift://127.0.0.1:9083"
- );
- ````
-
-4. Create an Iceberg skin
-
- ```sql
- CREATE TABLE example_db.t_iceberg
- ENGINE=ICEBERG
- PROPERTIES (
- "iceberg.database" = "iceberg_db",
- "iceberg.table" = "iceberg_table",
- "iceberg.hive.metastore.uris" = "thrift://127.0.0.1:9083",
- "iceberg.catalog.type" = "HIVE_CATALOG"
- );
- ````
-
-5. Create an Hudi external table
-
- create hudi table without schema(recommend)
- ```sql
- CREATE TABLE example_db.t_hudi
- ENGINE=HUDI
- PROPERTIES (
- "hudi.database" = "hudi_db_in_hive_metastore",
- "hudi.table" = "hudi_table_in_hive_metastore",
- "hudi.hive.metastore.uris" = "thrift://127.0.0.1:9083"
- );
- ````
-
- create hudi table with schema
- ```sql
- CREATE TABLE example_db.t_hudi (
- `id` int NOT NULL COMMENT "id number",
- `name` varchar(10) NOT NULL COMMENT "user name"
- )
- ENGINE=HUDI
- PROPERTIES (
- "hudi.database" = "hudi_db_in_hive_metastore",
- "hudi.table" = "hudi_table_in_hive_metastore",
- "hudi.hive.metastore.uris" = "thrift://127.0.0.1:9083"
- );
- ````
-
-### Keywords
-
- CREATE, EXTERNAL, TABLE
-
-### Best Practice
-
diff --git a/versioned_sidebars/version-1.2-sidebars.json
b/versioned_sidebars/version-1.2-sidebars.json
index b227bfd1c0b..8d33391ade1 100644
--- a/versioned_sidebars/version-1.2-sidebars.json
+++ b/versioned_sidebars/version-1.2-sidebars.json
@@ -807,7 +807,6 @@
"sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-RESOURCE",
"sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE-LIKE",
"sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW",
-
"sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-EXTERNAL-TABLE",
"sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE",
"sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-SQL-BLOCK-RULE",
"sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-FUNCTION",
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
