This is an automated email from the ASF dual-hosted git repository.
zykkk 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 0a55c29989 [fix](jdbc catalog) fix jdbc catalog doc for query tvf and
create example (#677)
0a55c29989 is described below
commit 0a55c299897a94f075e12e20da9ba47364486cf1
Author: zy-kkk <zhongy...@gmail.com>
AuthorDate: Wed May 22 14:35:58 2024 +0800
[fix](jdbc catalog) fix jdbc catalog doc for query tvf and create example
(#677)
---
docs/lakehouse/database/jdbc.md | 57 +++++--------------
.../sql-functions/table-functions/query.md | 2 +-
.../current/lakehouse/database/jdbc.md | 61 +++++---------------
.../sql-functions/table-functions/query.md | 2 +-
.../version-2.0/lakehouse/database/jdbc.md | 30 ----------
.../version-2.1/lakehouse/database/jdbc.md | 65 ++++++----------------
.../sql-functions/table-functions/query.md | 2 +-
.../version-2.0/lakehouse/database/jdbc.md | 30 ----------
.../version-2.1/lakehouse/database/jdbc.md | 57 +++++--------------
.../sql-functions/table-functions/query.md | 2 +-
10 files changed, 62 insertions(+), 246 deletions(-)
diff --git a/docs/lakehouse/database/jdbc.md b/docs/lakehouse/database/jdbc.md
index bfd85ed4f6..b397ab99c7 100644
--- a/docs/lakehouse/database/jdbc.md
+++ b/docs/lakehouse/database/jdbc.md
@@ -367,7 +367,7 @@ In versions prior to Doris 2.0.3, users could only perform
query operations (SEL
Starting from version Doris 2.0.4, users can perform DDL (Data Definition
Language) and DML (Data Manipulation Language) operations on JDBC data sources
using the `CALL` command.
-Starting from version Doris 2.1.4, users can perform data query operations on
JDBC data sources through the `query` table function.
+Starting from version Doris 2.1.3, users can perform data query operations on
JDBC data sources through the `query` table function.
### Passthrough of DDL and DML
@@ -441,21 +441,6 @@ Note that the above two url parameters are only valid for
jdbc driver mysql 8 or
#### Example
-* mysql 5.7
-
-```sql
-CREATE CATALOG jdbc_mysql PROPERTIES (
- "type" = "jdbc",
- "user" = "root",
- "password" = "123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:3306/demo",
- "driver_url" = "mysql-connector-java-5.1.49.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
-)
-```
-
-* mysql 8
-
```sql
CREATE CATALOG jdbc_mysql PROPERTIES (
"type" = "jdbc",
@@ -659,21 +644,6 @@ As for data mapping from SQLServer to Doris, one Database
in Doris corresponds t
The JDBC catalog supports connecting to another Doris database:
-* MySQL 5.7 driver
-
-```sql
-CREATE CATALOG jdbc_doris PROPERTIES (
- "type" = "jdbc",
- "user" = "root",
- "password" = "123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:9030?useSSL=false",
- "driver_url" = "mysql-connector-java-5.1.49.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
-)
-```
-
-* MySQL 8 driver
-
```sql
CREATE CATALOG jdbc_doris PROPERTIES (
"type" = "jdbc",
@@ -939,19 +909,18 @@ When mapping DB2, Doris's Database corresponds to a
Schema under the specified D
It is recommended to use the following versions of Driver to connect to the
corresponding database. Other versions of the Driver have not been tested and
may cause unexpected problems.
-| Source | JDBC Driver Version
|
-|:------------:|:-----------------------------------------------------------------:|
-| MySQL 5.x | mysql-connector-java-5.1.49.jar
|
-| MySQL 8.x | mysql-connector-java-8.0.25.jar
|
-| PostgreSQL | postgresql-42.5.1.jar
|
-| Oracle | ojdbc8.jar
|
-| SQLServer | mssql-jdbc-11.2.3.jre8.jar
|
-| Doris | mysql-connector-java-5.1.49.jar /
mysql-connector-java-8.0.25.jar |
-| Clickhouse | clickhouse-jdbc-0.4.2-all.jar
|
-| SAP HAHA | ngdbc.jar
|
-| Trino/Presto | trino-jdbc-389.jar / presto-jdbc-0.280.jar
|
-| OceanBase | oceanbase-client-2.4.2.jar
|
-| DB2 | jcc-11.5.8.0.jar
|
+| Source | JDBC Driver Version |
+|:------------:|:------------------------------------------:|
+| MySQL | mysql-connector-java-8.0.25.jar |
+| PostgreSQL | postgresql-42.5.1.jar |
+| Oracle | ojdbc8.jar |
+| SQLServer | mssql-jdbc-11.2.3.jre8.jar |
+| Doris | mysql-connector-java-8.0.25.jar |
+| Clickhouse | clickhouse-jdbc-0.4.2-all.jar |
+| SAP HAHA | ngdbc.jar |
+| Trino/Presto | trino-jdbc-389.jar / presto-jdbc-0.280.jar |
+| OceanBase | oceanbase-client-2.4.2.jar |
+| DB2 | jcc-11.5.8.0.jar |
## FAQ
diff --git a/docs/sql-manual/sql-functions/table-functions/query.md
b/docs/sql-manual/sql-functions/table-functions/query.md
index 86164bf567..f3f0adfd5f 100644
--- a/docs/sql-manual/sql-functions/table-functions/query.md
+++ b/docs/sql-manual/sql-functions/table-functions/query.md
@@ -35,7 +35,7 @@ query
Query table function (table-valued-function, tvf) can be used to transparently
transmit query statements directly to a catalog for data query
:::info note
-Supported by Doris version 2.1.4, currently only transparent query jdbc
catalog is supported.
+Supported by Doris version 2.1.3, currently only transparent query jdbc
catalog is supported.
You need to create the corresponding catalog in Doris first.
:::
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/jdbc.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/jdbc.md
index 0666b5d93c..4458dcf24c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/jdbc.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/database/jdbc.md
@@ -364,13 +364,13 @@ DROP CATALOG <catalog_name>;
SELECT * FROM <table_name>;
```
-### SQL 透传
+## SQL 透传
在 Doris 2.0.3 之前的版本中，用户只能通过 JDBC Catalog 进行查询操作（SELECT）。
在 Doris 2.0.4 版本之后，用户可以通过 `CALL` 命令，对 JDBC 数据源进行 DDL 和 DML 操作。
-在 Doris 2.1.4 版本之后，用户可以通过 `query` 表函数，对 JDBC 数据源进行数据查询操作。
+在 Doris 2.1.3 版本之后，用户可以通过 `query` 表函数，对 JDBC 数据源进行数据查询操作。
### 透传 DDL 和 DML
@@ -409,7 +409,7 @@ query(
select * from query("catalog" = "jdbc", "query" = "select * from
db_name.table_name where condition");
```
-#### 原理和限制
+### 原理和限制
通过 `CALL EXECUTE_STMT()` 命令，Doris 会直接将用户编写的 SQL 语句发送给 Catalog 对应的 JDBC
数据源进行执行。因此，这个操作有如下限制：
@@ -445,21 +445,6 @@ select * from query("catalog" = "jdbc", "query" = "select
* from db_name.table_n
#### 创建示例
-* mysql 5.7
-
- ```sql
- CREATE CATALOG jdbc_mysql PROPERTIES (
- "type"="jdbc",
- "user"="root",
- "password"="123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:3306/demo",
- "driver_url" = "mysql-connector-java-5.1.49.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
- )
- ```
-
-* mysql 8
-
```sql
CREATE CATALOG jdbc_mysql PROPERTIES (
"type"="jdbc",
@@ -664,21 +649,6 @@ CREATE CATALOG jdbc_sqlserve PROPERTIES (
Jdbc Catalog 也支持连接另一个Doris数据库：
-* mysql 5.7 Driver
-
-```sql
-CREATE CATALOG jdbc_doris PROPERTIES (
- "type"="jdbc",
- "user"="root",
- "password"="123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:9030?useSSL=false",
- "driver_url" = "mysql-connector-java-5.1.49.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
-)
-```
-
-* mysql 8 Driver
-
```sql
CREATE CATALOG jdbc_doris PROPERTIES (
"type"="jdbc",
@@ -944,19 +914,18 @@ CREATE CATALOG `jdbc_db2` PROPERTIES (
推荐使用以下版本的 Driver 连接对应的数据库。其他版本的 Driver 未经测试，可能导致非预期的问题。
-| Source | JDBC Driver Version
|
-|:------------:|:-----------------------------------------------------------------:|
-| MySQL 5.x | mysql-connector-java-5.1.49.jar
|
-| MySQL 8.x | mysql-connector-java-8.0.25.jar
|
-| PostgreSQL | postgresql-42.5.1.jar
|
-| Oracle | ojdbc8.jar
|
-| SQLServer | mssql-jdbc-11.2.3.jre8.jar
|
-| Doris | mysql-connector-java-5.1.49.jar /
mysql-connector-java-8.0.25.jar |
-| Clickhouse | clickhouse-jdbc-0.4.2-all.jar
|
-| SAP HAHA | ngdbc.jar
|
-| Trino/Presto | trino-jdbc-389.jar / presto-jdbc-0.280.jar
|
-| OceanBase | oceanbase-client-2.4.2.jar
|
-| DB2 | jcc-11.5.8.0.jar
|
+| Source | JDBC Driver Version |
+|:------------:|:------------------------------------------:|
+| MySQL | mysql-connector-java-8.0.25.jar |
+| PostgreSQL | postgresql-42.5.1.jar |
+| Oracle | ojdbc8.jar |
+| SQLServer | mssql-jdbc-11.2.3.jre8.jar |
+| Doris | mysql-connector-java-8.0.25.jar |
+| Clickhouse | clickhouse-jdbc-0.4.2-all.jar |
+| SAP HAHA | ngdbc.jar |
+| Trino/Presto | trino-jdbc-389.jar / presto-jdbc-0.280.jar |
+| OceanBase | oceanbase-client-2.4.2.jar |
+| DB2 | jcc-11.5.8.0.jar |
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-functions/query.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-functions/query.md
index b48a9cfec5..3e7e715db0 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-functions/query.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-functions/query.md
@@ -35,7 +35,7 @@ query
query 表函数（table-valued-function,tvf），可用于将查询语句直接透传到某个 catalog 进行数据查询
:::info note
-Doris 2.1.4 版本开始支持，当前仅支持透传查询 jdbc catalog。
+Doris 2.1.3 版本开始支持，当前仅支持透传查询 jdbc catalog。
需要先在 Doris 中创建对应的 catalog。
:::
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/jdbc.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/jdbc.md
index 9e33ed7a1a..8715521ae6 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/jdbc.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/lakehouse/database/jdbc.md
@@ -165,21 +165,6 @@ set enable_odbc_transcation = true;
**创建示例**
-* mysql 5.7
-
- ```sql
- CREATE CATALOG jdbc_mysql PROPERTIES (
- "type"="jdbc",
- "user"="root",
- "password"="123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:3306/demo",
- "driver_url" = "mysql-connector-java-5.1.47.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
- )
- ```
-
-* mysql 8
-
```sql
CREATE CATALOG jdbc_mysql PROPERTIES (
"type"="jdbc",
@@ -384,21 +369,6 @@ CREATE CATALOG jdbc_sqlserve PROPERTIES (
JDBC Catalog 也支持连接另一个 Doris 数据库：
-* mysql 5.7 Driver
-
- ```sql
- CREATE CATALOG jdbc_doris PROPERTIES (
- "type"="jdbc",
- "user"="root",
- "password"="123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:9030?useSSL=false",
- "driver_url" = "mysql-connector-java-5.1.47.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
- )
- ```
-
-* mysql 8 Driver
-
```sql
CREATE CATALOG jdbc_doris PROPERTIES (
"type"="jdbc",
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/jdbc.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/jdbc.md
index 41fcdcf2f9..2218b350fc 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/jdbc.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/database/jdbc.md
@@ -364,15 +364,15 @@ DROP CATALOG <catalog_name>;
SELECT * FROM <table_name>;
```
-### SQL 透传
+## SQL 透传
在 Doris 2.0.3 之前的版本中，用户只能通过 JDBC Catalog 进行查询操作（SELECT）。
在 Doris 2.0.4 版本之后，用户可以通过 `CALL` 命令，对 JDBC 数据源进行 DDL 和 DML 操作。
-在 Doris 2.1.4 版本之后，用户可以通过 `query` 表函数，对 JDBC 数据源进行数据查询操作。
+在 Doris 2.1.3 版本之后，用户可以通过 `query` 表函数，对 JDBC 数据源进行数据查询操作。
-#### 透传 DDL 和 DML
+### 透传 DDL 和 DML
```
CALL EXECUTE_STMT("catalog_name", "raw_stmt_string");
@@ -391,7 +391,7 @@ CALL EXECUTE_STMT(jdbc_catalog", "delete from db1.tbl1
where k1 = 2");
CALL EXECUTE_STMT(jdbc_catalog", "create table dbl1.tbl2 (k1 int)");
```
-#### 透传查询
+### 透传查询
```sql
query(
@@ -409,7 +409,7 @@ query(
select * from query("catalog" = "jdbc", "query" = "select * from
db_name.table_name where condition");
```
-#### 原理和限制
+### 原理和限制
通过 `CALL EXECUTE_STMT()` 命令，Doris 会直接将用户编写的 SQL 语句发送给 Catalog 对应的 JDBC
数据源进行执行。因此，这个操作有如下限制：
@@ -445,21 +445,6 @@ select * from query("catalog" = "jdbc", "query" = "select
* from db_name.table_n
#### 创建示例
-* mysql 5.7
-
- ```sql
- CREATE CATALOG jdbc_mysql PROPERTIES (
- "type"="jdbc",
- "user"="root",
- "password"="123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:3306/demo",
- "driver_url" = "mysql-connector-java-5.1.49.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
- )
- ```
-
-* mysql 8
-
```sql
CREATE CATALOG jdbc_mysql PROPERTIES (
"type"="jdbc",
@@ -664,21 +649,6 @@ CREATE CATALOG jdbc_sqlserve PROPERTIES (
Jdbc Catalog 也支持连接另一个Doris数据库：
-* mysql 5.7 Driver
-
-```sql
-CREATE CATALOG jdbc_doris PROPERTIES (
- "type"="jdbc",
- "user"="root",
- "password"="123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:9030?useSSL=false",
- "driver_url" = "mysql-connector-java-5.1.49.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
-)
-```
-
-* mysql 8 Driver
-
```sql
CREATE CATALOG jdbc_doris PROPERTIES (
"type"="jdbc",
@@ -944,19 +914,18 @@ CREATE CATALOG `jdbc_db2` PROPERTIES (
推荐使用以下版本的 Driver 连接对应的数据库。其他版本的 Driver 未经测试，可能导致非预期的问题。
-| Source | JDBC Driver Version
|
-|:------------:|:-----------------------------------------------------------------:|
-| MySQL 5.x | mysql-connector-java-5.1.49.jar
|
-| MySQL 8.x | mysql-connector-java-8.0.25.jar
|
-| PostgreSQL | postgresql-42.5.1.jar
|
-| Oracle | ojdbc8.jar
|
-| SQLServer | mssql-jdbc-11.2.3.jre8.jar
|
-| Doris | mysql-connector-java-5.1.49.jar /
mysql-connector-java-8.0.25.jar |
-| Clickhouse | clickhouse-jdbc-0.4.2-all.jar
|
-| SAP HAHA | ngdbc.jar
|
-| Trino/Presto | trino-jdbc-389.jar / presto-jdbc-0.280.jar
|
-| OceanBase | oceanbase-client-2.4.2.jar
|
-| DB2 | jcc-11.5.8.0.jar
|
+| Source | JDBC Driver Version |
+|:------------:|:------------------------------------------:|
+| MySQL | mysql-connector-java-8.0.25.jar |
+| PostgreSQL | postgresql-42.5.1.jar |
+| Oracle | ojdbc8.jar |
+| SQLServer | mssql-jdbc-11.2.3.jre8.jar |
+| Doris | mysql-connector-java-8.0.25.jar |
+| Clickhouse | clickhouse-jdbc-0.4.2-all.jar |
+| SAP HAHA | ngdbc.jar |
+| Trino/Presto | trino-jdbc-389.jar / presto-jdbc-0.280.jar |
+| OceanBase | oceanbase-client-2.4.2.jar |
+| DB2 | jcc-11.5.8.0.jar |
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/table-functions/query.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/table-functions/query.md
index b48a9cfec5..3e7e715db0 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/table-functions/query.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/table-functions/query.md
@@ -35,7 +35,7 @@ query
query 表函数（table-valued-function,tvf），可用于将查询语句直接透传到某个 catalog 进行数据查询
:::info note
-Doris 2.1.4 版本开始支持，当前仅支持透传查询 jdbc catalog。
+Doris 2.1.3 版本开始支持，当前仅支持透传查询 jdbc catalog。
需要先在 Doris 中创建对应的 catalog。
:::
diff --git a/versioned_docs/version-2.0/lakehouse/database/jdbc.md
b/versioned_docs/version-2.0/lakehouse/database/jdbc.md
index 363a1e469a..8ad5bc39f0 100644
--- a/versioned_docs/version-2.0/lakehouse/database/jdbc.md
+++ b/versioned_docs/version-2.0/lakehouse/database/jdbc.md
@@ -165,21 +165,6 @@ The transaction mechanism ensures the atomicity of data
writing to JDBC External
#### Example
-* MySQL 5.7
-
-```sql
-CREATE CATALOG jdbc_mysql PROPERTIES (
- "type" = "jdbc",
- "user" = "root",
- "password" = "123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:3306/demo",
- "driver_url" = "mysql-connector-java-5.1.47.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
-)
-```
-
-* MySQL 8
-
```sql
CREATE CATALOG jdbc_mysql PROPERTIES (
"type" = "jdbc",
@@ -383,21 +368,6 @@ As for data mapping from SQLServer to Doris, one Database
in Doris corresponds t
Jdbc Catalog also support to connect another Doris database:
-* MySQL 5.7 Driver
-
-```sql
-CREATE CATALOG jdbc_doris PROPERTIES (
- "type" = "jdbc",
- "user" = "root",
- "password" = "123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:9030?useSSL=false",
- "driver_url" = "mysql-connector-java-5.1.47.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
-)
-```
-
-* MySQL 8 Driver
-
```sql
CREATE CATALOG jdbc_doris PROPERTIES (
"type" = "jdbc",
diff --git a/versioned_docs/version-2.1/lakehouse/database/jdbc.md
b/versioned_docs/version-2.1/lakehouse/database/jdbc.md
index 73ed381d34..4880de8d4d 100644
--- a/versioned_docs/version-2.1/lakehouse/database/jdbc.md
+++ b/versioned_docs/version-2.1/lakehouse/database/jdbc.md
@@ -367,7 +367,7 @@ In versions prior to Doris 2.0.3, users could only perform
query operations (SEL
Starting from version Doris 2.0.4, users can perform DDL (Data Definition
Language) and DML (Data Manipulation Language) operations on JDBC data sources
using the `CALL` command.
-Starting from version Doris 2.1.4, users can perform data query operations on
JDBC data sources through the `query` table function.
+Starting from version Doris 2.1.3, users can perform data query operations on
JDBC data sources through the `query` table function.
### Passthrough of DDL and DML
@@ -441,21 +441,6 @@ Note that the above two url parameters are only valid for
jdbc driver mysql 8 or
#### Example
-* mysql 5.7
-
-```sql
-CREATE CATALOG jdbc_mysql PROPERTIES (
- "type" = "jdbc",
- "user" = "root",
- "password" = "123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:3306/demo",
- "driver_url" = "mysql-connector-java-5.1.49.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
-)
-```
-
-* mysql 8
-
```sql
CREATE CATALOG jdbc_mysql PROPERTIES (
"type" = "jdbc",
@@ -659,21 +644,6 @@ As for data mapping from SQLServer to Doris, one Database
in Doris corresponds t
The JDBC catalog supports connecting to another Doris database:
-* MySQL 5.7 driver
-
-```sql
-CREATE CATALOG jdbc_doris PROPERTIES (
- "type" = "jdbc",
- "user" = "root",
- "password" = "123456",
- "jdbc_url" = "jdbc:mysql://127.0.0.1:9030?useSSL=false",
- "driver_url" = "mysql-connector-java-5.1.49.jar",
- "driver_class" = "com.mysql.jdbc.Driver"
-)
-```
-
-* MySQL 8 driver
-
```sql
CREATE CATALOG jdbc_doris PROPERTIES (
"type" = "jdbc",
@@ -939,19 +909,18 @@ When mapping DB2, Doris's Database corresponds to a
Schema under the specified D
It is recommended to use the following versions of Driver to connect to the
corresponding database. Other versions of the Driver have not been tested and
may cause unexpected problems.
-| Source | JDBC Driver Version
|
-|:------------:|:-----------------------------------------------------------------:|
-| MySQL 5.x | mysql-connector-java-5.1.49.jar
|
-| MySQL 8.x | mysql-connector-java-8.0.25.jar
|
-| PostgreSQL | postgresql-42.5.1.jar
|
-| Oracle | ojdbc8.jar
|
-| SQLServer | mssql-jdbc-11.2.3.jre8.jar
|
-| Doris | mysql-connector-java-5.1.49.jar /
mysql-connector-java-8.0.25.jar |
-| Clickhouse | clickhouse-jdbc-0.4.2-all.jar
|
-| SAP HAHA | ngdbc.jar
|
-| Trino/Presto | trino-jdbc-389.jar / presto-jdbc-0.280.jar
|
-| OceanBase | oceanbase-client-2.4.2.jar
|
-| DB2 | jcc-11.5.8.0.jar
|
+| Source | JDBC Driver Version |
+|:------------:|:------------------------------------------:|
+| MySQL | mysql-connector-java-8.0.25.jar |
+| PostgreSQL | postgresql-42.5.1.jar |
+| Oracle | ojdbc8.jar |
+| SQLServer | mssql-jdbc-11.2.3.jre8.jar |
+| Doris | mysql-connector-java-8.0.25.jar |
+| Clickhouse | clickhouse-jdbc-0.4.2-all.jar |
+| SAP HAHA | ngdbc.jar |
+| Trino/Presto | trino-jdbc-389.jar / presto-jdbc-0.280.jar |
+| OceanBase | oceanbase-client-2.4.2.jar |
+| DB2 | jcc-11.5.8.0.jar |
## FAQ
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/table-functions/query.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/table-functions/query.md
index 1988063339..400ad30e64 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/table-functions/query.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/table-functions/query.md
@@ -35,7 +35,7 @@ query
Query table function (table-valued-function, tvf) can be used to transparently
transmit query statements directly to a catalog for data query
:::info note
-Supported by Doris version 2.1.4, currently only transparent query jdbc
catalog is supported.
+Supported by Doris version 2.1.3, currently only transparent query jdbc
catalog is supported.
You need to create the corresponding catalog in Doris first.
:::
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
