You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Commit 087fccd
Browse filesBrowse the repository at this point in the historyBrowse files
Copy file name to clipboardExpand all lines: docs/en/docs/lakehouse/multi-catalog/jdbc.md
+13-6Lines changed: 13 additions & 6 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -52,7 +52,7 @@ PROPERTIES ("key"="value", ...)
52
52
|`driver_url `| Yes || JDBC Driver Jar |
53
53
|`driver_class `| Yes || JDBC Driver Class |
54
54
|`only_specified_database`| No | "false" | Whether only the database specified to be synchronized. |
55
-
|`lower_case_table_names`| No | "false" | Whether to synchronize jdbc external data source table names in lower case. |
55
+
|`lower_case_table_names`| No | "false" | Whether to synchronize the database name, table name and column name of jdbc external data source in lowercase.|
56
56
|`include_database_list`| No | "" | When only_specified_database=true,only synchronize the specified databases. split with ','. db name is case sensitive. |
57
57
|`exclude_database_list`| No | "" | When only_specified_database=true,do not synchronize the specified databases. split with ','. db name is case sensitive. |
58
58
@@ -68,7 +68,7 @@ PROPERTIES ("key"="value", ...)
68
68
69
69
### Lowercase table name synchronization
70
70
71
-
When `lower_case_table_names` is set to `true`, Doris is able to query non-lowercase databases and tables by maintaining a mapping of lowercase names to actual names on the remote system
71
+
When `lower_case_table_names` is set to `true`, Doris is able to query non-lowercase databases and tables and columns by maintaining a mapping of lowercase names to actual names on the remote system
72
72
73
73
**Notice:**
74
74
@@ -78,9 +78,9 @@ When `lower_case_table_names` is set to `true`, Doris is able to query non-lower
78
78
79
79
For other databases, you still need to specify the real library name and table name when querying.
80
80
81
-
2. In Doris 2.0.3 and later versions, it is valid for all databases. When querying, all library names and table names will be converted into real names and then queried. If you upgrade from an old version to 2.0. 3, `Refresh <catalog_name>` is required to take effect.
81
+
2. In Doris 2.0.3 and later versions, it is valid for all databases. When querying, all database names and table names and columns will be converted into real names and then queried. If you upgrade from an old version to 2.0. 3, `Refresh <catalog_name>` is required to take effect.
82
82
83
-
However, if the database or table names differ only in case, such as `Doris` and `doris`, Doris cannot query them due to ambiguity.
83
+
However, if the database or table or column names differ only in case, such as `Doris` and `doris`, Doris cannot query them due to ambiguity.
84
84
85
85
3. When the FE parameter's `lower_case_table_names` is set to `1` or `2`, the JDBC Catalog's `lower_case_table_names` parameter must be set to `true`. If the FE parameter's `lower_case_table_names` is set to `0`, the JDBC Catalog parameter can be `true` or `false` and defaults to `false`. This ensures consistency and predictability in how Doris handles internal and external table configurations.
86
86
@@ -113,8 +113,8 @@ In some cases, the keywords in the database might be used as the field names. Fo
113
113
### Predicate Pushdown
114
114
115
115
1. When executing a query like `where dt = '2022-01-01'`, Doris can push down these filtering conditions to the external data source, thereby directly excluding data that does not meet the conditions at the data source level, reducing the number of unqualified Necessary data acquisition and transfer. This greatly improves query performance while also reducing the load on external data sources.
116
-
117
-
2. When `enable_func_pushdown` is set to true, the function condition after where will also be pushed down to the external data source. Currently, only MySQL is supported. If you encounter a function that MySQL does not support, you can set this parameter to false, at present, Doris will automatically identify some functions not supported by MySQL to filter the push-down conditions, which can be checked by explain sql.
116
+
117
+
2. When `enable_func_pushdown` is set to true, the function conditions after where will also be pushed down to the external data source. Currently, only MySQL and ClickHouse are supported. If you encounter a function that is not supported by MySQL or ClickHouse, you can set this parameter to false. , currently Doris will automatically identify some functions not supported by MySQL and functions supported by CLickHouse for push-down condition filtering, which can be viewed through explain sql.
118
118
119
119
Functions that are currently not pushed down include:
120
120
@@ -123,6 +123,13 @@ Functions that are currently not pushed down include:
123
123
| DATE_TRUNC |
124
124
| MONEY_FORMAT |
125
125
126
+
Functions that are currently pushed down include:
127
+
128
+
| ClickHouse |
129
+
|:--------------:|
130
+
| FROM_UNIXTIME |
131
+
| UNIX_TIMESTAMP |
132
+
126
133
### Line Limit
127
134
128
135
If there is a limit keyword in the query, Doris will translate it into semantics suitable for different data sources.
0 commit comments