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.git
The following commit(s) were added to refs/heads/master by this push:
new 7b4fc412c5 [typo](docs) Optimize documents so that users can better
understand. (#17295)
7b4fc412c5 is described below
commit 7b4fc412c597dc1bb6d2af265a3ff65a621d5491
Author: yagagagaga <[email protected]>
AuthorDate: Sat Mar 4 21:02:45 2023 +0800
[typo](docs) Optimize documents so that users can better understand.
(#17295)
---
docs/en/docs/lakehouse/multi-catalog/jdbc.md | 10 +++++-----
.../Data-Definition-Statements/Create/CREATE-CATALOG.md | 12 ++++++------
docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md | 10 +++++-----
.../Data-Definition-Statements/Create/CREATE-CATALOG.md | 12 ++++++------
4 files changed, 22 insertions(+), 22 deletions(-)
diff --git a/docs/en/docs/lakehouse/multi-catalog/jdbc.md
b/docs/en/docs/lakehouse/multi-catalog/jdbc.md
index bd006608fe..9827f3ba5f 100644
--- a/docs/en/docs/lakehouse/multi-catalog/jdbc.md
+++ b/docs/en/docs/lakehouse/multi-catalog/jdbc.md
@@ -185,7 +185,7 @@ Currently, Jdbc Catalog only support to use 5.x version of
JDBC jar package to c
## Query
```
-select * from mysql_table where k1 > 1000 and k3 ='term';
+select * from mysql_catalog.mysql_database.mysql_table where k1 > 1000 and k3
='term';
```
In some cases, the keywords in the database might be used as the field names.
For queries to function normally in these cases, Doris will add escape
characters to the field names and tables names in SQL statements based on the
rules of different databases, such as (``) for MySQL, ([]) for SQLServer, and
("") for PostgreSQL and Oracle. This might require extra attention on case
sensitivity. You can view the query statements sent to these various databases
via ```explain sql```.
@@ -199,8 +199,8 @@ After creating a JDBC Catalog in Doris, you can write data
or query results to i
Example:
```
-insert into mysql_table values(1, "doris");
-insert into mysql_table select * from table;
+insert into mysql_catalog.mysql_database.mysql_table values(1, "doris");
+insert into mysql_catalog.mysql_database.mysql_table select * from table;
```
### Transaction
@@ -429,6 +429,6 @@ The transaction mechanism ensures the atomicity of data
writing to JDBC External
To reduce memory usage, Doris obtains one batch of query results at a time,
and has a size limit for each batch. However, MySQL conducts one-off loading of
all query results by default, which means the "loading in batches" method won't
work. To solve this, you need to specify
"jdbc_url"="jdbc:mysql://IP:PORT/doris_test?useCursorFetch=true" in the URL.
- 7. What to do with errors such as "CAUSED BY: SQLException OutOfMemoryError"
when performing JDBC queries?
+7. What to do with errors such as "CAUSED BY: SQLException OutOfMemoryError"
when performing JDBC queries?
- If you have set `useCursorFetch` for MySQL, you can increase the JVM
memory limit by modifying the value of `jvm_max_heap_size` in be.conf. The
current default value is 1024M.
+ If you have set `useCursorFetch` for MySQL, you can increase the JVM
memory limit by modifying the value of `jvm_max_heap_size` in be.conf. The
current default value is 1024M.
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-CATALOG.md
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-CATALOG.md
index 2cc2e03eaa..275d1cee42 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-CATALOG.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-CATALOG.md
@@ -154,7 +154,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"user"="postgres",
"password"="123456",
"jdbc_url" = "jdbc:postgresql://127.0.0.1:5432/demo",
- "driver_url" = "file:/path/to/postgresql-42.5.1.jar",
+ "driver_url" = "file:///path/to/postgresql-42.5.1.jar",
"driver_class" = "org.postgresql.Driver"
);
CREATE CATALOG jdbc WITH RESOURCE pg_resource;
@@ -165,7 +165,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"jdbc.user"="postgres",
"jdbc.password"="123456",
"jdbc.jdbc_url" = "jdbc:postgresql://127.0.0.1:5432/demo",
- "jdbc.driver_url" = "file:/path/to/postgresql-42.5.1.jar",
+ "jdbc.driver_url" = "file:///path/to/postgresql-42.5.1.jar",
"jdbc.driver_class" = "org.postgresql.Driver"
);
```
@@ -200,7 +200,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"user"="doris",
"password"="123456",
"jdbc_url" = "jdbc:oracle:thin:@127.0.0.1:1521:helowin",
- "driver_url" = "file:/path/to/ojdbc6.jar",
+ "driver_url" = "file:///path/to/ojdbc6.jar",
"driver_class" = "oracle.jdbc.driver.OracleDriver"
);
CREATE CATALOG jdbc WITH RESOURCE oracle_resource;
@@ -211,7 +211,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"jdbc.user"="doris",
"jdbc.password"="123456",
"jdbc.jdbc_url" = "jdbc:oracle:thin:@127.0.0.1:1521:helowin",
- "jdbc.driver_url" = "file:/path/to/ojdbc6.jar",
+ "jdbc.driver_url" = "file:///path/to/ojdbc6.jar",
"jdbc.driver_class" = "oracle.jdbc.driver.OracleDriver"
);
```
@@ -224,7 +224,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"user"="SA",
"password"="Doris123456",
"jdbc_url" =
"jdbc:sqlserver://localhost:1433;DataBaseName=doris_test",
- "driver_url" = "file:/path/to/mssql-jdbc-11.2.3.jre8.jar",
+ "driver_url" = "file:///path/to/mssql-jdbc-11.2.3.jre8.jar",
"driver_class" = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
);
CREATE CATALOG sqlserver_catlog WITH RESOURCE sqlserver_resource;
@@ -235,7 +235,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"jdbc.user"="SA",
"jdbc.password"="Doris123456",
"jdbc.jdbc_url" =
"jdbc:sqlserver://localhost:1433;DataBaseName=doris_test",
- "jdbc.driver_url" = "file:/path/to/mssql-jdbc-11.2.3.jre8.jar",
+ "jdbc.driver_url" =
"file:///path/to/mssql-jdbc-11.2.3.jre8.jar",
"jdbc.driver_class" =
"com.microsoft.sqlserver.jdbc.SQLServerDriver"
);
```
diff --git a/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
b/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
index 0556eb72dc..c41b6ba153 100644
--- a/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
+++ b/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
@@ -184,7 +184,7 @@ CREATE CATALOG doris_catalog PROPERTIES (
## 数据查询
```sql
-select * from mysql_table where k1 > 1000 and k3 ='term';
+select * from mysql_catalog.mysql_database.mysql_table where k1 > 1000 and k3
='term';
```
由于可能存在使用数据库内部的关键字作为字段名，为解决这种状况下仍能正确查询，所以在SQL语句中，会根据各个数据库的标准自动在字段名与表名上加上转义符。例如
MYSQL(``)、PostgreSQL("")、SQLServer([])、ORACLE("")，所以此时可能会造成字段名的大小写敏感，具体可以通过explain
sql，查看转义后下发到各个数据库的查询语句。
@@ -197,8 +197,8 @@ select * from mysql_table where k1 > 1000 and k3 ='term';
示例：
```sql
-insert into mysql_table values(1, "doris");
-insert into mysql_table select * from table;
+insert into mysql_catalog.mysql_database.mysql_table values(1, "doris");
+insert into mysql_catalog.mysql_database.mysql_table select * from table;
```
### 事务
@@ -427,6 +427,6 @@ set enable_odbc_transcation = true;
为减少内存的使用，在获取结果集时，每次仅获取batchSize的大小，这样一批一批的获取结果。而MYSQL默认是一次将结果全部加载到内存，
设置的按批获取无法生效，需要主动显示的在URL中指定:"jdbc_url"="jdbc:mysql://IP:PORT/doris_test?useCursorFetch=true"
- 7. 在使用JDBC查询过程中时，如果出现"CAUSED BY: SQLException OutOfMemoryError" 类似的错误
+7. 在使用JDBC查询过程中时，如果出现"CAUSED BY: SQLException OutOfMemoryError" 类似的错误
-
如果MYSQL已经主动设置useCursorFetch，可以在be.conf中修改jvm_max_heap_size的值，尝试增大JVM的内存，目前默认值为1024M。
\ No newline at end of file
+
如果MYSQL已经主动设置useCursorFetch，可以在be.conf中修改jvm_max_heap_size的值，尝试增大JVM的内存，目前默认值为1024M。
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-CATALOG.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-CATALOG.md
index 65b3417302..fd11653b5a 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-CATALOG.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-CATALOG.md
@@ -160,7 +160,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"user"="postgres",
"password"="123456",
"jdbc_url" = "jdbc:postgresql://127.0.0.1:5432/demo",
- "driver_url" = "file:/path/to/postgresql-42.5.1.jar",
+ "driver_url" = "file:///path/to/postgresql-42.5.1.jar",
"driver_class" = "org.postgresql.Driver"
);
CREATE CATALOG jdbc WITH RESOURCE pg_resource;
@@ -171,7 +171,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"jdbc.user"="postgres",
"jdbc.password"="123456",
"jdbc.jdbc_url" = "jdbc:postgresql://127.0.0.1:5432/demo",
- "jdbc.driver_url" = "file:/path/to/postgresql-42.5.1.jar",
+ "jdbc.driver_url" = "file:///path/to/postgresql-42.5.1.jar",
"jdbc.driver_class" = "org.postgresql.Driver"
);
```
@@ -206,7 +206,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"user"="doris",
"password"="123456",
"jdbc_url" = "jdbc:oracle:thin:@127.0.0.1:1521:helowin",
- "driver_url" = "file:/path/to/ojdbc6.jar",
+ "driver_url" = "file:///path/to/ojdbc6.jar",
"driver_class" = "oracle.jdbc.driver.OracleDriver"
);
CREATE CATALOG jdbc WITH RESOURCE oracle_resource;
@@ -217,7 +217,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"jdbc.user"="doris",
"jdbc.password"="123456",
"jdbc.jdbc_url" = "jdbc:oracle:thin:@127.0.0.1:1521:helowin",
- "jdbc.driver_url" = "file:/path/to/ojdbc6.jar",
+ "jdbc.driver_url" = "file:///path/to/ojdbc6.jar",
"jdbc.driver_class" = "oracle.jdbc.driver.OracleDriver"
);
```
@@ -230,7 +230,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"user"="SA",
"password"="Doris123456",
"jdbc_url" =
"jdbc:sqlserver://localhost:1433;DataBaseName=doris_test",
- "driver_url" = "file:/path/to/mssql-jdbc-11.2.3.jre8.jar",
+ "driver_url" = "file:///path/to/mssql-jdbc-11.2.3.jre8.jar",
"driver_class" = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
);
CREATE CATALOG sqlserver_catlog WITH RESOURCE sqlserver_resource;
@@ -241,7 +241,7 @@ CREATE CATALOG catalog_name PROPERTIES (
"jdbc.user"="SA",
"jdbc.password"="Doris123456",
"jdbc.jdbc_url" =
"jdbc:sqlserver://localhost:1433;DataBaseName=doris_test",
- "jdbc.driver_url" = "file:/path/to/mssql-jdbc-11.2.3.jre8.jar",
+ "jdbc.driver_url" =
"file:///path/to/mssql-jdbc-11.2.3.jre8.jar",
"jdbc.driver_class" =
"com.microsoft.sqlserver.jdbc.SQLServerDriver"
);
```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
