-
Notifications
You must be signed in to change notification settings - Fork 197
/
Copy pathold_version_ss
37 lines (33 loc) · 2.67 KB
/
old_version_ss
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
commit ff59f7a21169bbc2339ad8139b5a2fbcb1059642
Author: Ling Hengqian <[email protected]>
Date: Fri Mar 28 14:09:26 2025 +0800
Fix the bug that nativeTest under GraalVM Native Image of HiveServer2 cannot run on Windows 11 (#35057)
diff --git a/docs/document/content/user-manual/shardingsphere-jdbc/optional-plugins/hiveserver2/_index.cn.md b/docs/document/content/user-manual/shardingsphere-jdbc/optional-plugins/hiveserver2/_index.cn.md
index 4ec84b5cf42..40f88bd9ae5 100644
--- a/docs/document/content/user-manual/shardingsphere-jdbc/optional-plugins/hiveserver2/_index.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-jdbc/optional-plugins/hiveserver2/_index.cn.md
@@ -482,6 +482,10 @@ HiveServer2 并不能保证每一条 `insert` 相关的 DML SQL 都能成功执
ShardingSphere JDBC DataSource 尚不支持执行 HiveServer2 的 `set`,`create table`,`truncate table` 和 `drop table` 语句。
用户应考虑为 ShardingSphere 提交包含单元测试的 PR。
+#### 使用 `initFile` 参数部分绕开 SQL 限制
+
+受 https://issues.apache.org/jira/browse/HIVE-28835 影响,HiveServer2 JDBC Driver 的`initFile` 参数仅可在 Linux 环境下使用。
+
以 `set` 为代表的 SQL 语句很容易在 HiveServer2 Client 级别被动态配置。
即便 ShardingSphere JDBC 不支持在虚拟 DataSource 上执行 HiveServer2 的 `set` 语句,
用户也可以通过 `initFile` 的 Hive Session 参数来直接为真实 DataSource 执行一系列 SQL。
diff --git a/docs/document/content/user-manual/shardingsphere-jdbc/optional-plugins/hiveserver2/_index.en.md b/docs/document/content/user-manual/shardingsphere-jdbc/optional-plugins/hiveserver2/_index.en.md
index 66ee9beccbf..0e8c562079c 100644
--- a/docs/document/content/user-manual/shardingsphere-jdbc/optional-plugins/hiveserver2/_index.en.md
+++ b/docs/document/content/user-manual/shardingsphere-jdbc/optional-plugins/hiveserver2/_index.en.md
@@ -489,6 +489,11 @@ ShardingSphere JDBC DataSource does not yet support executing HiveServer2's `set
and `drop table` statements.
Users should consider submitting a PR containing unit tests for ShardingSphere.
+#### Use `initFile` parameter to partially bypass SQL restrictions
+
+Affected by https://issues.apache.org/jira/browse/HIVE-28835 ,
+the `initFile` parameter of HiveServer2 JDBC Driver is only available in Linux environment.
+
SQL statements represented by `set` can be easily configured dynamically at the HiveServer2 Client level.
Even though ShardingSphere JDBC does not support executing HiveServer2's `set` statement on a virtual DataSource,
users can directly execute a series of SQLs for the real DataSource through the Hive Session parameter of `initFile`.