You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by ji...@apache.org on 2023/02/23 14:33:26 UTC
[shardingsphere] branch master updated: Remove hint dist sql (#24227)
This is an automated email from the ASF dual-hosted git repository.
jianglongtao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 81ba0e623d4 Remove hint dist sql (#24227)
81ba0e623d4 is described below
commit 81ba0e623d489f1841ea4f67243d83053e0f963b
Author: anmui <42...@users.noreply.github.com>
AuthorDate: Thu Feb 23 22:33:15 2023 +0800
Remove hint dist sql (#24227)
* Remove HintManager & HintManagerHolder;Remove HintRALStatementExecutor and implementation;Remove HintRALBackendHandler;Remove the judgment related to Hint in OKProxyState
* Remove HintRALStatement and subclasses,mod:ShardingStandardRoutingEngineTest
* del:test-e2e cases ral-hint
* restore:HintManager
* del:proxy-hint-enabled
* conflicts
* conflicts
* conflicts OK
* fix ci:SHOW DIST VARIABLES
* fix ci:SHOW DIST VARIABLES
* del:shardingsphere-examples distsql Hint
* restore：jdbc HintManager
* test:TransactionType
* test:TransactionType
* test:TransactionType
* test:TransactionType
* test:TransactionType
* restore proxy-hint-enabled
* Remove Hint DistSQL documentation
* remove local config file
---------
Co-authored-by: Raigor <ra...@gmail.com>
---
.../core/kernel/KernelDistSQLStatementVisitor.java | 7 --
.../parser/statement/ral/HintRALStatement.java | 24 -----
.../statement/ral/hint/ClearHintStatement.java | 26 -----
.../distsql/syntax/ral/_index.cn.md | 2 +-
.../distsql/syntax/ral/_index.en.md | 2 +-
.../distsql/syntax/ral/hint/_index.cn.md | 8 --
.../distsql/syntax/ral/hint/_index.en.md | 8 --
.../hint/add-sharding-hint-database-value.cn.md | 46 ---------
.../hint/add-sharding-hint-database-value.en.md | 47 ---------
.../ral/hint/add-sharding-hint-table-value.cn.md | 46 ---------
.../ral/hint/add-sharding-hint-table-value.en.md | 47 ---------
.../distsql/syntax/ral/hint/clear-hint.cn.md | 54 -----------
.../distsql/syntax/ral/hint/clear-hint.en.md | 54 -----------
.../hint/set-readwrite-spitting-hint-source.cn.md | 43 --------
.../hint/set-readwrite-spitting-hint-source.en.md | 44 ---------
.../hint/set-sharding-hint-database-value.cn.md | 40 --------
.../hint/set-sharding-hint-database-value.en.md | 41 --------
.../distsql/syntax/ral/hint/show-hint-status.cn.md | 45 ---------
.../distsql/syntax/ral/hint/show-hint-status.en.md | 48 ---------
.../example/proxy/distsql/DistSQLHintExample.java | 66 -------------
.../proxy/distsql/hint/AbstractHintExecutor.java | 43 --------
.../example/proxy/distsql/hint/HintType.java | 62 ------------
.../distsql/hint/impl/AddShardingExecutor.java | 60 ------------
.../hint/impl/SetReadwriteSplittingExecutor.java | 57 -----------
.../distsql/hint/impl/SetShardingExecutor.java | 57 -----------
.../example/proxy/hint/HintType.java | 23 -----
.../example/proxy/hint/ProxyHintExample.java | 49 +---------
.../resources/META-INF/hint-databases-only.yaml | 21 ----
.../resources/META-INF/hint-databases-tables.yaml | 21 ----
.../main/resources/META-INF/hint-write-only.yaml | 21 ----
.../main/resources/conf/config-databases-only.yaml | 60 ------------
.../resources/conf/config-databases-tables.yaml | 78 ---------------
.../src/main/resources/conf/config-write-only.yaml | 57 -----------
.../ReadwriteSplittingDistSQLStatementVisitor.java | 21 ----
.../hint/ClearReadwriteSplittingHintStatement.java | 26 -----
.../hint/SetReadwriteSplittingHintStatement.java | 32 ------
.../ShowReadwriteSplittingHintStatusStatement.java | 26 -----
.../core/ShardingDistSQLStatementVisitor.java | 35 -------
.../AddShardingHintDatabaseValueStatement.java | 34 -------
.../hint/AddShardingHintTableValueStatement.java | 34 -------
.../statement/hint/ClearShardingHintStatement.java | 26 -----
.../SetShardingHintDatabaseValueStatement.java | 32 ------
.../hint/ShowShardingHintStatusStatement.java | 26 -----
.../distsql/ral/RALBackendHandlerFactory.java | 5 -
.../distsql/ral/hint/HintManagerHolder.java | 50 ----------
.../distsql/ral/hint/HintRALBackendHandler.java | 65 -------------
.../distsql/ral/hint/HintRALStatementExecutor.java | 53 ----------
.../ral/hint/HintRALStatementExecutorFactory.java | 87 -----------------
.../distsql/ral/hint/enums/HintShardingType.java | 26 -----
.../distsql/ral/hint/enums/HintSourceType.java | 51 ----------
.../hint/executor/AbstractHintQueryExecutor.java | 66 -------------
.../hint/executor/AbstractHintUpdateExecutor.java | 38 --------
.../AddShardingHintDatabaseValueExecutor.java | 39 --------
.../AddShardingHintTableValueExecutor.java | 39 --------
.../ral/hint/executor/ClearHintExecutor.java | 40 --------
.../ClearReadwriteSplittingHintExecutor.java | 39 --------
.../hint/executor/ClearShardingHintExecutor.java | 39 --------
.../SetReadwriteSplittingHintExecutor.java | 50 ----------
.../SetShardingHintDatabaseValueExecutor.java | 39 --------
.../ShowReadwriteSplittingHintStatusExecutor.java | 52 ----------
.../executor/ShowShardingHintStatusExecutor.java | 102 -------------------
.../hint/result/ShowShardingHintStatusResult.java | 38 --------
.../handler/ProxyBackendHandlerFactoryTest.java | 4 -
.../hint/HintRALStatementExecutorFactoryTest.java | 108 ---------------------
.../cluster/add_database_value_hint.xml | 28 ------
.../empty_rules/cluster/add_table_value_hint.xml | 28 ------
.../empty_rules/cluster/default_sharding_hint.xml | 28 ------
.../cluster/set_database_value_hint.xml | 28 ------
.../default_readwrite_splitting_hint.xml | 23 -----
.../empty_rules/set_readwrite_splitting_hint.xml | 23 -----
.../standalone/add_database_value_hint.xml | 28 ------
.../standalone/add_table_value_hint.xml | 28 ------
.../standalone/default_sharding_hint.xml | 28 ------
.../standalone/set_database_value_hint.xml | 28 ------
.../resources/cases/ral/ral-integration-hint.xml | 54 -----------
.../asserts/statement/ral/RALStatementAssert.java | 4 -
.../statement/ral/impl/HintRALStatementAssert.java | 87 -----------------
...ddShardingHintDatabaseValueStatementAssert.java | 53 ----------
.../AddShardingHintTableValueStatementAssert.java | 53 ----------
.../ral/impl/hint/ClearHintStatementAssert.java | 49 ----------
...ClearReadwriteSplittingHintStatementAssert.java | 49 ----------
.../hint/ClearShardingHintStatementAssert.java | 49 ----------
.../SetReadwriteSplittingHintStatementAssert.java | 52 ----------
...etShardingHintDatabaseValueStatementAssert.java | 52 ----------
...eadwriteSplittingHintStatusStatementAssert.java | 49 ----------
.../ShowShardingHintStatusStatementAssert.java | 49 ----------
.../it/parser/src/main/resources/case/ral/hint.xml | 31 ------
.../src/main/resources/sql/supported/ral/hint.xml | 31 ------
88 files changed, 7 insertions(+), 3554 deletions(-)
diff --git a/distsql/parser/src/main/java/org/apache/shardingsphere/distsql/parser/core/kernel/KernelDistSQLStatementVisitor.java b/distsql/parser/src/main/java/org/apache/shardingsphere/distsql/parser/core/kernel/KernelDistSQLStatementVisitor.java
index c1396ed58f5..540d89d7a16 100644
--- a/distsql/parser/src/main/java/org/apache/shardingsphere/distsql/parser/core/kernel/KernelDistSQLStatementVisitor.java
+++ b/distsql/parser/src/main/java/org/apache/shardingsphere/distsql/parser/core/kernel/KernelDistSQLStatementVisitor.java
@@ -24,7 +24,6 @@ import org.apache.shardingsphere.distsql.parser.autogen.KernelDistSQLStatementPa
import org.apache.shardingsphere.distsql.parser.autogen.KernelDistSQLStatementParser.AlterMigrationRuleContext;
import org.apache.shardingsphere.distsql.parser.autogen.KernelDistSQLStatementParser.AlterStorageUnitContext;
import org.apache.shardingsphere.distsql.parser.autogen.KernelDistSQLStatementParser.BatchSizeContext;
-import org.apache.shardingsphere.distsql.parser.autogen.KernelDistSQLStatementParser.ClearHintContext;
import org.apache.shardingsphere.distsql.parser.autogen.KernelDistSQLStatementParser.ConvertYamlConfigurationContext;
import org.apache.shardingsphere.distsql.parser.autogen.KernelDistSQLStatementParser.CountSingleTableContext;
import org.apache.shardingsphere.distsql.parser.autogen.KernelDistSQLStatementParser.DatabaseNameContext;
@@ -71,7 +70,6 @@ import org.apache.shardingsphere.distsql.parser.segment.HostnameAndPortBasedData
import org.apache.shardingsphere.distsql.parser.segment.InventoryIncrementalRuleSegment;
import org.apache.shardingsphere.distsql.parser.segment.ReadOrWriteSegment;
import org.apache.shardingsphere.distsql.parser.segment.URLBasedDataSourceSegment;
-import org.apache.shardingsphere.distsql.parser.statement.ral.hint.ClearHintStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.queryable.ConvertYamlConfigurationStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.queryable.ExportDatabaseConfigurationStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.queryable.ShowComputeNodeInfoStatement;
@@ -262,11 +260,6 @@ public final class KernelDistSQLStatementVisitor extends KernelDistSQLStatementB
return new ShowDistVariablesStatement();
}
- @Override
- public ASTNode visitClearHint(final ClearHintContext ctx) {
- return new ClearHintStatement();
- }
-
@Override
public ASTNode visitRefreshDatabaseMetadata(final RefreshDatabaseMetadataContext ctx) {
return new RefreshDatabaseMetaDataStatement(null == ctx.databaseName() ? null : getIdentifierValue(ctx.databaseName()));
diff --git a/distsql/statement/src/main/java/org/apache/shardingsphere/distsql/parser/statement/ral/HintRALStatement.java b/distsql/statement/src/main/java/org/apache/shardingsphere/distsql/parser/statement/ral/HintRALStatement.java
deleted file mode 100644
index 0a7a30b4087..00000000000
--- a/distsql/statement/src/main/java/org/apache/shardingsphere/distsql/parser/statement/ral/HintRALStatement.java
+++ /dev/null
@@ -1,24 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.distsql.parser.statement.ral;
-
-/**
- * Hint RAL statement.
- */
-public abstract class HintRALStatement extends RALStatement {
-}
diff --git a/distsql/statement/src/main/java/org/apache/shardingsphere/distsql/parser/statement/ral/hint/ClearHintStatement.java b/distsql/statement/src/main/java/org/apache/shardingsphere/distsql/parser/statement/ral/hint/ClearHintStatement.java
deleted file mode 100644
index 95c7776338a..00000000000
--- a/distsql/statement/src/main/java/org/apache/shardingsphere/distsql/parser/statement/ral/hint/ClearHintStatement.java
+++ /dev/null
@@ -1,26 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.distsql.parser.statement.ral.hint;
-
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-
-/**
- * Clear hint statement.
- */
-public final class ClearHintStatement extends HintRALStatement {
-}
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/_index.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/_index.cn.md
index 2c429f4007a..f2f9e447bf0 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/_index.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/_index.cn.md
@@ -5,4 +5,4 @@ chapter = true
+++
RAL (Resource & Rule Administration Language) 为 Apache ShardingSphere 的管理语言，
-负责强制路由、事务类型切换、弹性伸缩、分片执行计划查询等增量功能的操作。
+负责事务类型切换、弹性伸缩等增量功能的操作。
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/_index.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/_index.en.md
index 96dd206a972..2ad2753bb3a 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/_index.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/_index.en.md
@@ -4,4 +4,4 @@ weight = 3
chapter = true
+++
-RAL (Resource & Rule Administration Language) responsible for the added-on feature of hint, transaction type switch, scaling, sharding execute planning and so on.
+RAL (Resource & Rule Administration Language) responsible for the added-on feature of transaction type switch, scaling and so on.
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/_index.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/_index.cn.md
deleted file mode 100644
index 179ff75fe46..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/_index.cn.md
+++ /dev/null
@@ -1,8 +0,0 @@
-+++
-title = "强制路由"
-weight = 1
-chapter = true
-
-+++
-
-本章节将对强制路由功能的语法进行详细说明。
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/_index.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/_index.en.md
deleted file mode 100644
index e78278f24ae..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/_index.en.md
+++ /dev/null
@@ -1,8 +0,0 @@
-+++
-title = "HINT"
-weight = 1
-chapter = true
-
-+++
-
-This chapter describes the syntax of Hint.
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-database-value.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-database-value.cn.md
deleted file mode 100644
index 7fb2f2241aa..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-database-value.cn.md
+++ /dev/null
@@ -1,46 +0,0 @@
-+++
-title = "ADD SHARDING HINT DATABASE_VALUE"
-weight = 4
-+++
-
-### 描述
-
-`ADD SHARDING HINT DATABASE_VALUE` 语法用于针对当前连接，为指定表添加数据库分片值
-### 语法
-
-{{< tabs >}}
-{{% tab name="语法" %}}
-```sql
-AddShardingHintDatabaseValue ::=
- 'ADD' 'SHARDING' 'HINT' 'DATABASE_VALUE' shardingHintDatabaseValueDefinition
-
- shardingHintDatabaseValueDefinition ::=
- tableName '=' databaseShardingValue
-
- tableName ::=
- identifier
-
- databaseShardingValue ::=
- int
-```
-{{% /tab %}}
-{{% tab name="铁路图" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### 示例
-
-- 为指定表添加数据库分片值
-
-```sql
-ADD SHARDING HINT DATABASE_VALUE t_order = 100;
-```
-
-### 保留字
-
-`ADD`、`SHARDING`、`HINT`、`DATABASE_VALUE`
-
-### 相关链接
-
-- [保留字](/cn/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-database-value.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-database-value.en.md
deleted file mode 100644
index 5705172cba8..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-database-value.en.md
+++ /dev/null
@@ -1,47 +0,0 @@
-+++
-title = "ADD SHARDING HINT DATABASE_VALUE"
-weight = 3
-+++
-
-### Description
-
-The `ADD SHARDING HINT DATABASE_VALUE` syntax is used to add sharding database value to specified table for current connection.
-
-### Syntax
-
-{{< tabs >}}
-{{% tab name="Grammar" %}}
-```sql
-AddShardingHintDatabaseValue ::=
- 'ADD' 'SHARDING' 'HINT' 'DATABASE_VALUE' shardingHintDatabaseValueDefinition
-
- shardingHintDatabaseValueDefinition ::=
- tableName '=' databaseShardingValue
-
- tableName ::=
- identifier
-
- databaseShardingValue ::=
- int
-```
-{{% /tab %}}
-{{% tab name="Railroad diagram" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### Example
-
-- Add the database sharding value for specified table
-
-```sql
-ADD SHARDING HINT DATABASE_VALUE t_order = 100;
-```
-
-### Reserved word
-
-`ADD`, `SHARDING`, `HINT`, `DATABASE_VALUE`
-
-### Related links
-
-- [Reserved word](/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-table-value.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-table-value.cn.md
deleted file mode 100644
index 11119250403..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-table-value.cn.md
+++ /dev/null
@@ -1,46 +0,0 @@
-+++
-title = "ADD SHARDING HINT TABLE_VALUE"
-weight = 5
-+++
-
-### 描述
-
-`ADD SHARDING HINT TABLE_VALUE` 语法用于针对当前连接，为指定表添加表分片值
-### 语法
-
-{{< tabs >}}
-{{% tab name="语法" %}}
-```sql
-AddShardingHintDatabaseValue ::=
- 'ADD' 'SHARDING' 'HINT' 'TABLE_VALUE' shardingHintTableValueDefinition
-
- shardingHintTableValueDefinition ::=
- tableName '=' tableShardingValue
-
- tableName ::=
- identifier
-
- tableShardingValue ::=
- int
-```
-{{% /tab %}}
-{{% tab name="铁路图" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### 示例
-
-- 为指定表添加表分片值
-
-```sql
-ADD SHARDING HINT TABLE_VALUE t_order = 100;
-```
-
-### 保留字
-
-`ADD`、`SHARDING`、`HINT`、`TABLE_VALUE`
-
-### 相关链接
-
-- [保留字](/cn/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-table-value.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-table-value.en.md
deleted file mode 100644
index 658899daacd..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/add-sharding-hint-table-value.en.md
+++ /dev/null
@@ -1,47 +0,0 @@
-+++
-title = "ADD SHARDING HINT TABLE_VALUE"
-weight = 5
-+++
-
-### Description
-
-The `ADD SHARDING HINT TABLE_VALUE` syntax is used to add table sharding value to specified table for current connection.
-
-### Syntax
-
-{{< tabs >}}
-{{% tab name="Grammar" %}}
-```sql
-AddShardingHintDatabaseValue ::=
- 'ADD' 'SHARDING' 'HINT' 'TABLE_VALUE' shardingHintTableValueDefinition
-
- shardingHintTableValueDefinition ::=
- tableName '=' tableShardingValue
-
- tableName ::=
- identifier
-
- tableShardingValue ::=
- int
-```
-{{% /tab %}}
-{{% tab name="Railroad diagram" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### Example
-
-- Add the table sharding value for specified table
-
-```sql
-ADD SHARDING HINT TABLE_VALUE t_order = 100;
-```
-
-### Reserved word
-
-`ADD`, `SHARDING`, `HINT`, `TABLE_VALUE`
-
-### Related links
-
-- [Reserved word](/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/clear-hint.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/clear-hint.cn.md
deleted file mode 100644
index 5c8bfdf3318..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/clear-hint.cn.md
+++ /dev/null
@@ -1,54 +0,0 @@
-+++
-title = "CLEAR HINT"
-weight = 6
-+++
-
-### 描述
-
-`CLEAR HINT` 语法用于针对当前连接，清除 hint 设置
-
-### 语法
-
-{{< tabs >}}
-{{% tab name="语法" %}}
-```sql
-ClearHint ::=
- 'CLEAR' ('SHARDING' | 'READWRITE_SPLITTING')? 'HINT'
-```
-{{% /tab %}}
-{{% tab name="铁路图" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### 补充说明
-
-- 未指定 `SHARDING` / `READWRITE_SPLITTING` 时，默认清除所有 hint 设置
-
-### 示例
-
-- 清除 `SHARDING` 的 hint 设置
-
-```sql
-CLEAR SHARDING HINT;
-```
-
-- 清除 `READWRITE_SPLITTING` 的 hint 设置
-
-```sql
-CLEAR READWRITE_SPLITTING HINT;
-```
-
-- 清除所有 hint 设置
-
-```sql
-CLEAR HINT;
-```
-
-### 保留字
-
-`CLEAR`、`SHARDING`、`READWRITE_SPLITTING`、`HINT`
-
-### 相关链接
-
-- [保留字](/cn/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/clear-hint.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/clear-hint.en.md
deleted file mode 100644
index b33ebd449cd..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/clear-hint.en.md
+++ /dev/null
@@ -1,54 +0,0 @@
-+++
-title = "CLEAR HINT"
-weight = 6
-+++
-
-### Description
-
-The `CLEAR HINT` syntax is used to clear hint settings for current connection.
-
-### Syntax
-
-{{< tabs >}}
-{{% tab name="Grammar" %}}
-```sql
-ClearHint ::=
- 'CLEAR' ('SHARDING' | 'READWRITE_SPLITTING')? 'HINT'
-```
-{{% /tab %}}
-{{% tab name="Railroad diagram" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### Supplement
-
-- When `SHARDING`/`READWRITE_SPLITTING` is not specified, the default is clear all hint settings.
-
-### Example
-
-- Clear hint settings of sharding
-
-```sql
-CLEAR SHARDING HINT;
-```
-
-- Clear hint settings of readwrite splitting
-
-```sql
-CLEAR READWRITE_SPLITTING HINT;
-```
-
-- Clear all hint settings
-
-```sql
-CLEAR HINT;
-```
-
-### Reserved word
-
-`CLEAR`, `SHARDING`, `READWRITE_SPLITTING`, `HINT`
-
-### Related links
-
-- [Reserved word](/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-readwrite-spitting-hint-source.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-readwrite-spitting-hint-source.cn.md
deleted file mode 100644
index 3a498147532..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-readwrite-spitting-hint-source.cn.md
+++ /dev/null
@@ -1,43 +0,0 @@
-+++
-title = "SET READWRITE_SPLITTING HINT SOURCE"
-weight = 2
-+++
-
-### 描述
-
-`SET READWRITE_SPLITTING HINT SOURCE` 语法用于针对当前连接，设置读写分离的路由策略（自动路由或强制到写库）
-### 语法
-
-{{< tabs >}}
-{{% tab name="语法" %}}
-```sql
-SetReadwriteSplittingHintSource ::=
- 'SET' 'READWRITE_SPLITTING' 'HINT' 'SOURCE' '='('auto' | 'write')
-```
-{{% /tab %}}
-{{% tab name="铁路图" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### 示例
-
-- 设置读写分离的路由策略为 auto
-
-```sql
-SET READWRITE_SPLITTING HINT SOURCE = auto;
-```
-
-- 设置读写分离的路由策略为 write
-
-```sql
-SET READWRITE_SPLITTING HINT SOURCE = write;
-```
-
-### 保留字
-
-`SET`、`READWRITE_SPLITTING`、`HINT`、`SOURCE`
-
-### 相关链接
-
-- [保留字](/cn/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-readwrite-spitting-hint-source.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-readwrite-spitting-hint-source.en.md
deleted file mode 100644
index 3e137e18584..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-readwrite-spitting-hint-source.en.md
+++ /dev/null
@@ -1,44 +0,0 @@
-+++
-title = "SET READWRITE_SPLITTING HINT SOURCE"
-weight = 2
-+++
-
-### Description
-
-The `SET READWRITE_SPLITTING HINT SOURCE` syntax is used to set readwrite splitting routing strategy for current connection.
-
-### Syntax
-
-{{< tabs >}}
-{{% tab name="Grammar" %}}
-```sql
-SetReadwriteSplittingHintSource ::=
- 'SET' 'READWRITE_SPLITTING' 'HINT' 'SOURCE' '='('auto' | 'write')
-```
-{{% /tab %}}
-{{% tab name="Railroad diagram" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### Example
-
-- Set the read-write splitting routing strategy to auto
-
-```sql
-SET READWRITE_SPLITTING HINT SOURCE = auto;
-```
-
-- Set the read-write splitting routing strategy to write
-
-```sql
-SET READWRITE_SPLITTING HINT SOURCE = write;
-```
-
-### Reserved word
-
-`SET`, `READWRITE_SPLITTING`, `HINT`, `SOURCE`
-
-### Related links
-
-- [Reserved word](/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-sharding-hint-database-value.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-sharding-hint-database-value.cn.md
deleted file mode 100644
index 05bf96d4346..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-sharding-hint-database-value.cn.md
+++ /dev/null
@@ -1,40 +0,0 @@
-+++
-title = "SET SHARDING HINT DATABASE_VALUE"
-weight = 3
-+++
-
-### 描述
-
-`SET SHARDING HINT DATABASE_VALUE` 语法用于针对当前连接，设置 hint 仅对数据库分片有效，并添加分片值
-### 语法
-
-{{< tabs >}}
-{{% tab name="语法" %}}
-```sql
-SetShardingHintDatabaseValue ::=
- 'SET' 'SHARDING' 'HINT' 'DATABASE_VALUE' '=' databaseShardingValue
-
- databaseShardingValue ::=
- int
-```
-{{% /tab %}}
-{{% tab name="铁路图" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### 示例
-
-- 设置数据库分片值
-
-```sql
-SET SHARDING HINT DATABASE_VALUE = 100;
-```
-
-### 保留字
-
-`SET`、`SHARDING`、`HINT`、`DATABASE_VALUE`
-
-### 相关链接
-
-- [保留字](/cn/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-sharding-hint-database-value.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-sharding-hint-database-value.en.md
deleted file mode 100644
index 78743fbf72d..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/set-sharding-hint-database-value.en.md
+++ /dev/null
@@ -1,41 +0,0 @@
-+++
-title = "SET SHARDING HINT DATABASE_VALUE"
-weight = 3
-+++
-
-### Description
-
-The `SET SHARDING HINT DATABASE_VALUE` syntax is used to set sharding value for database sharding only for current connection.
-
-### Syntax
-
-{{< tabs >}}
-{{% tab name="Grammar" %}}
-```sql
-SetShardingHintDatabaseValue ::=
- 'SET' 'SHARDING' 'HINT' 'DATABASE_VALUE' '=' databaseShardingValue
-
- databaseShardingValue ::=
- int
-```
-{{% /tab %}}
-{{% tab name="Railroad diagram" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### Example
-
-- Set the sharding database value
-
-```sql
-SET SHARDING HINT DATABASE_VALUE = 100;
-```
-
-### Reserved word
-
-`SET`, `SHARDING`, `HINT`, `DATABASE_VALUE`
-
-### Related links
-
-- [Reserved word](/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/show-hint-status.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/show-hint-status.cn.md
deleted file mode 100644
index 20a7968bfea..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/show-hint-status.cn.md
+++ /dev/null
@@ -1,45 +0,0 @@
-+++
-title = "SHOW HINT STATUS"
-weight = 7
-
-+++
-
-### 描述
-
-`SHOW HINT STATUS` 语法用于针对当前连接，查询 hint 设置
-
-### 语法
-
-{{< tabs >}}
-{{% tab name="语法" %}}
-```sql
-ShowHintStatus ::=
- 'SHOW' ('SHARDING' | 'READWRITE_SPLITTING') 'HINT' 'STATUS'
-```
-{{% /tab %}}
-{{% tab name="铁路图" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### 示例
-
-- 查询 `SHARDING` 的 hint 设置
-
-```sql
-SHOW SHARDING HINT STATUS;
-```
-
-- 查询 `READWRITE_SPLITTING` 的 hint 设置
-
-```sql
-SHOW READWRITE_SPLITTING HINT STATUS;
-```
-
-### 保留字
-
-`SHOW`、`SHARDING`、`READWRITE_SPLITTING`、`HINT`、`STATUS`
-
-### 相关链接
-
-- [保留字](/cn/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/show-hint-status.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/show-hint-status.en.md
deleted file mode 100644
index a266a93af11..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/hint/show-hint-status.en.md
+++ /dev/null
@@ -1,48 +0,0 @@
-+++
-title = "SHOW HINT STATUS"
-weight = 7
-+++
-
-### Description
-
-The `SHOW HINT STATUS` syntax is used to query hint settings for current connection.
-
-### Syntax
-
-{{< tabs >}}
-{{% tab name="Grammar" %}}
-```sql
-ShowHintStatus ::=
- 'SHOW' ('SHARDING' | 'READWRITE_SPLITTING') 'HINT' 'STATUS'
-```
-{{% /tab %}}
-{{% tab name="Railroad diagram" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### Supplement
-
-- When `SHARDING`/`READWRITE_SPLITTING` is not specified, the default is clear all hint settings.
-
-### Example
-
-- Query hint settings of sharding
-
-```sql
-SHOW SHARDING HINT STATUS;
-```
-
-- Query hint settings of readwrite splitting
-
-```sql
-SHOW READWRITE_SPLITTING HINT STATUS;
-```
-
-### Reserved word
-
-`SHOW`, `SHARDING`, `READWRITE_SPLITTING`, `HINT`, `STATUS`
-
-### Related links
-
-- [Reserved word](/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/DistSQLHintExample.java b/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/DistSQLHintExample.java
deleted file mode 100644
index 494166cdc2f..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/DistSQLHintExample.java
+++ /dev/null
@@ -1,66 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.example.proxy.distsql;
-
-import lombok.extern.slf4j.Slf4j;
-import org.apache.shardingsphere.example.core.api.service.ExampleService;
-import org.apache.shardingsphere.example.core.jdbc.service.OrderServiceImpl;
-import org.apache.shardingsphere.example.proxy.distsql.factory.DataSourceFactory;
-import org.apache.shardingsphere.example.proxy.distsql.hint.HintType;
-import org.apache.shardingsphere.example.proxy.distsql.utils.FileUtil;
-
-import javax.sql.DataSource;
-import java.io.IOException;
-import java.sql.Connection;
-import java.sql.SQLException;
-import java.sql.Statement;
-
-@Slf4j
-public final class DistSQLHintExample {
-
- public static void main(final String[] args) throws SQLException, IOException {
- HintType hintType = selectedHintType();
- DataSource dataSource = DataSourceFactory.createDataSource(FileUtil.getFile(hintType.getConfigPath()));
- ExampleService exampleService = getExampleService(dataSource);
- exampleService.initEnvironment();
- execute(dataSource, hintType);
- exampleService.cleanEnvironment();
- }
-
- private static HintType selectedHintType() {
- return HintType.SET_SHARDING;
-// return HintType.ADD_SHARDING;
-// return HintType.SET_READWRITE_SPLITTING;
- }
-
- private static ExampleService getExampleService(final DataSource dataSource) {
- return new OrderServiceImpl(dataSource);
- }
-
- private static void execute(final DataSource dataSource, HintType hintType) {
- try {
- Connection connection = dataSource.getConnection();
- Statement statement = connection.createStatement();
- DistSQLExecutor executor = hintType.getExecutor();
- executor.init(statement);
- executor.execute();
- } catch (Exception e) {
- log.error(e.getMessage());
- }
- }
-}
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/AbstractHintExecutor.java b/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/AbstractHintExecutor.java
deleted file mode 100644
index 1d035fc4821..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/AbstractHintExecutor.java
+++ /dev/null
@@ -1,43 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.example.proxy.distsql.hint;
-
-import org.apache.shardingsphere.example.proxy.distsql.DistSQLExecutor;
-
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.sql.Statement;
-import java.util.LinkedList;
-import java.util.List;
-
-public abstract class AbstractHintExecutor implements DistSQLExecutor {
-
- protected Statement statement;
-
- protected List<List<String>> getResultData(ResultSet resultSet) throws SQLException {
- List<List<String>> result = new LinkedList<>();
- while (resultSet.next()) {
- List<String> row = new LinkedList<>();
- for (int i = 0; i < resultSet.getMetaData().getColumnCount(); i++) {
- row.add(resultSet.getString(i + 1));
- }
- result.add(row);
- }
- return result;
- }
-}
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/HintType.java b/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/HintType.java
deleted file mode 100644
index ebfff9896a5..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/HintType.java
+++ /dev/null
@@ -1,62 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.example.proxy.distsql.hint;
-
-import org.apache.shardingsphere.example.proxy.distsql.DistSQLExecutor;
-import org.apache.shardingsphere.example.proxy.distsql.hint.impl.AddShardingExecutor;
-import org.apache.shardingsphere.example.proxy.distsql.hint.impl.SetShardingExecutor;
-import org.apache.shardingsphere.example.proxy.distsql.hint.impl.SetReadwriteSplittingExecutor;
-
-public enum HintType {
-
- SET_SHARDING {
- @Override
- public String getConfigPath() {
- return "/client/datasource-config.yaml";
- }
-
- @Override
- public DistSQLExecutor getExecutor() {
- return new SetShardingExecutor();
- }
- }, ADD_SHARDING {
- @Override
- public String getConfigPath() {
- return "/client/datasource-config.yaml";
- }
-
- @Override
- public DistSQLExecutor getExecutor() {
- return new AddShardingExecutor();
- }
- }, SET_READWRITE_SPLITTING {
- @Override
- public String getConfigPath() {
- return "/client/datasource-config.yaml";
- }
-
- @Override
- public DistSQLExecutor getExecutor() {
- return new SetReadwriteSplittingExecutor();
- }
- };
-
- public abstract String getConfigPath();
-
- public abstract DistSQLExecutor getExecutor();
-}
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/impl/AddShardingExecutor.java b/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/impl/AddShardingExecutor.java
deleted file mode 100644
index 03cea485d09..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/impl/AddShardingExecutor.java
+++ /dev/null
@@ -1,60 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.example.proxy.distsql.hint.impl;
-
-import com.google.gson.Gson;
-import lombok.extern.slf4j.Slf4j;
-import org.apache.shardingsphere.example.proxy.distsql.hint.AbstractHintExecutor;
-
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.sql.Statement;
-
-@Slf4j
-public final class AddShardingExecutor extends AbstractHintExecutor {
-
- private static final String ADD_SHARDING_HINT_DATABASE = "add sharding hint database_value t_order=1";
-
- private static final String ADD_SHARDING_HINT_TABLE = "add sharding hint table_value t_order=1";
-
- private static final String SHOW_STATUS = "show sharding hint status";
-
- @Override
- public void init(Statement statement) {
- this.statement = statement;
- }
-
- @Override
- public void execute() throws SQLException, InterruptedException {
- executeShow();
- executeAdd();
- executeShow();
- }
-
- private void executeShow() throws SQLException {
- log.info("show ...");
- ResultSet resultSet = statement.executeQuery(SHOW_STATUS);
- log.info(new Gson().toJson(getResultData(resultSet)));
- }
-
- private void executeAdd() throws SQLException {
- log.info("add sharding hint ...");
- statement.execute(ADD_SHARDING_HINT_DATABASE);
- statement.execute(ADD_SHARDING_HINT_TABLE);
- }
-}
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/impl/SetReadwriteSplittingExecutor.java b/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/impl/SetReadwriteSplittingExecutor.java
deleted file mode 100644
index 269c9306ca1..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/impl/SetReadwriteSplittingExecutor.java
+++ /dev/null
@@ -1,57 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.example.proxy.distsql.hint.impl;
-
-import com.google.gson.Gson;
-import lombok.extern.slf4j.Slf4j;
-import org.apache.shardingsphere.example.proxy.distsql.hint.AbstractHintExecutor;
-
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.sql.Statement;
-
-@Slf4j
-public final class SetReadwriteSplittingExecutor extends AbstractHintExecutor {
-
- private static final String SET_READ_SPLITTING_HINT = "set readwrite_splitting hint source=write";
-
- private static final String SHOW_STATUS = "show readwrite_splitting hint status";
-
- @Override
- public void init(Statement statement) {
- this.statement = statement;
- }
-
- @Override
- public void execute() throws SQLException, InterruptedException {
- executeShow();
- executeSet();
- executeShow();
- }
-
- private void executeShow() throws SQLException {
- log.info("show ...");
- ResultSet resultSet = statement.executeQuery(SHOW_STATUS);
- log.info(new Gson().toJson(getResultData(resultSet)));
- }
-
- private void executeSet() throws SQLException {
- log.info("set readwrite-splitting hint ...");
- statement.execute(SET_READ_SPLITTING_HINT);
- }
-}
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/impl/SetShardingExecutor.java b/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/impl/SetShardingExecutor.java
deleted file mode 100644
index eddf92bb18e..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-distsql-example/src/main/java/org/apache/shardingsphere/example/proxy/distsql/hint/impl/SetShardingExecutor.java
+++ /dev/null
@@ -1,57 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.example.proxy.distsql.hint.impl;
-
-import com.google.gson.Gson;
-import lombok.extern.slf4j.Slf4j;
-import org.apache.shardingsphere.example.proxy.distsql.hint.AbstractHintExecutor;
-
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.sql.Statement;
-
-@Slf4j
-public final class SetShardingExecutor extends AbstractHintExecutor {
-
- private static final String SET_SHARDING_HINT = "set sharding hint database_value=1";
-
- private static final String SHOW_STATUS = "show sharding hint status";
-
- @Override
- public void init(Statement statement) {
- this.statement = statement;
- }
-
- @Override
- public void execute() throws SQLException, InterruptedException {
- executeShow();
- executeSet();
- executeShow();
- }
-
- private void executeSet() throws SQLException {
- log.info("set sharding hint ...");
- statement.execute(SET_SHARDING_HINT);
- }
-
- private void executeShow() throws SQLException {
- log.info("show ...");
- ResultSet resultSet = statement.executeQuery(SHOW_STATUS);
- log.info(new Gson().toJson(getResultData(resultSet)));
- }
-}
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/java/org/apache/shardingsphere/example/proxy/hint/HintType.java b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/java/org/apache/shardingsphere/example/proxy/hint/HintType.java
deleted file mode 100644
index d1ddf0dc458..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/java/org/apache/shardingsphere/example/proxy/hint/HintType.java
+++ /dev/null
@@ -1,23 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.example.proxy.hint;
-
-public enum HintType {
-
- DATABASE_ONLY, DATABASE_TABLES, WRITE_ONLY, SQL_HINT_DATASOURCE
-}
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/java/org/apache/shardingsphere/example/proxy/hint/ProxyHintExample.java b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/java/org/apache/shardingsphere/example/proxy/hint/ProxyHintExample.java
index 931535c6b87..0e31206e756 100644
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/java/org/apache/shardingsphere/example/proxy/hint/ProxyHintExample.java
+++ b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/java/org/apache/shardingsphere/example/proxy/hint/ProxyHintExample.java
@@ -30,10 +30,6 @@ import java.sql.Statement;
public final class ProxyHintExample {
- private static final HintType TYPE = HintType.DATABASE_TABLES;
-// private static final HintType TYPE = HintType.DATABASE_ONLY;
-// private static final HintType TYPE = HintType.WRITE_ONLY;
-// private static final HintType TYPE = HintType.SQL_HINT_DATASOURCE;
public static void main(final String[] args) throws SQLException, IOException {
DataSource dataSource = getDataSource();
@@ -44,18 +40,7 @@ public final class ProxyHintExample {
}
private static DataSource getDataSource() throws IOException {
- switch (TYPE) {
- case DATABASE_TABLES:
- return YamlDataSourceFactory.createDataSource(getFile("/META-INF/hint-databases-tables.yaml"));
- case DATABASE_ONLY:
- return YamlDataSourceFactory.createDataSource(getFile("/META-INF/hint-databases-only.yaml"));
- case WRITE_ONLY:
- return YamlDataSourceFactory.createDataSource(getFile("/META-INF/hint-write-only.yaml"));
- case SQL_HINT_DATASOURCE:
- return YamlDataSourceFactory.createDataSource(getFile("/META-INF/sql-hint-data-source.yaml"));
- default:
- throw new UnsupportedOperationException("unsupported type");
- }
+ return YamlDataSourceFactory.createDataSource(getFile("/META-INF/sql-hint-data-source.yaml"));
}
private static File getFile(final String configFile) {
@@ -69,35 +54,11 @@ public final class ProxyHintExample {
private static void processWithHintValue(final DataSource dataSource) throws SQLException {
try (Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement()) {
- if (TYPE == HintType.SQL_HINT_DATASOURCE) {
- statement.execute("/* ShardingSphere hint: dataSourceName=ds_1 */select * from t_order");
- statement.execute("/* ShardingSphere hint: dataSourceName=ds_1 */SELECT i.* FROM t_order o, t_order_item i WHERE o.order_id = i.order_id");
- statement.execute("/* ShardingSphere hint: dataSourceName=ds_1 */select * from t_order_item");
- statement.execute("/* ShardingSphere hint: dataSourceName=ds_1 */INSERT INTO t_order (user_id, address_id, status) VALUES (1, 1, 'init')");
- } else {
- setHintValue(statement);
- statement.execute("select * from t_order");
- statement.execute("SELECT i.* FROM t_order o, t_order_item i WHERE o.order_id = i.order_id");
- statement.execute("select * from t_order_item");
- statement.execute("INSERT INTO t_order (user_id, address_id, status) VALUES (1, 1, 'init')");
- }
+ statement.execute("/* ShardingSphere hint: dataSourceName=ds_1 */select * from t_order");
+ statement.execute("/* ShardingSphere hint: dataSourceName=ds_1 */SELECT i.* FROM t_order o, t_order_item i WHERE o.order_id = i.order_id");
+ statement.execute("/* ShardingSphere hint: dataSourceName=ds_1 */select * from t_order_item");
+ statement.execute("/* ShardingSphere hint: dataSourceName=ds_1 */INSERT INTO t_order (user_id, address_id, status) VALUES (1, 1, 'init')");
}
}
- private static void setHintValue(final Statement statement) throws SQLException {
- switch (TYPE) {
- case DATABASE_TABLES:
- statement.execute("add sharding hint database_value t_order=1");
- statement.execute("add sharding hint table_value t_order=1");
- return;
- case DATABASE_ONLY:
- statement.execute("set sharding hint database_value=1");
- return;
- case WRITE_ONLY:
- statement.execute("set readwrite_splitting hint source=write");
- return;
- default:
- throw new UnsupportedOperationException("unsupported type");
- }
- }
}
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/META-INF/hint-databases-only.yaml b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/META-INF/hint-databases-only.yaml
deleted file mode 100644
index 9c9234db8da..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/META-INF/hint-databases-only.yaml
+++ /dev/null
@@ -1,21 +0,0 @@
-#
-# 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.
-#
-
-driverClassName: com.mysql.jdbc.Driver
-jdbcUrl: jdbc:mysql://localhost:3307/databases_only
-username: root
-password: root
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/META-INF/hint-databases-tables.yaml b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/META-INF/hint-databases-tables.yaml
deleted file mode 100644
index 018b1ab2001..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/META-INF/hint-databases-tables.yaml
+++ /dev/null
@@ -1,21 +0,0 @@
-#
-# 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.
-#
-
-driverClassName: com.mysql.jdbc.Driver
-jdbcUrl: jdbc:mysql://localhost:3307/databases_tables
-username: root
-password: root
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/META-INF/hint-write-only.yaml b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/META-INF/hint-write-only.yaml
deleted file mode 100644
index 51f1f3831ac..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/META-INF/hint-write-only.yaml
+++ /dev/null
@@ -1,21 +0,0 @@
-#
-# 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.
-#
-
-driverClassName: com.mysql.jdbc.Driver
-jdbcUrl: jdbc:mysql://localhost:3307/write_only
-username: root
-password: root
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-databases-only.yaml b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-databases-only.yaml
deleted file mode 100644
index 04916ce7ded..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-databases-only.yaml
+++ /dev/null
@@ -1,60 +0,0 @@
-#
-# 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.
-#
-
-databaseName: databases_only
-
-dataSources:
- ds_0:
- url: jdbc:mysql://localhost:3306/demo_ds_0?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
- username: root
- password:
- connectionTimeoutMilliseconds: 30000
- idleTimeoutMilliseconds: 60000
- maxLifetimeMilliseconds: 1800000
- maxPoolSize: 50
- minPoolSize: 1
- ds_1:
- url: jdbc:mysql://localhost:3306/demo_ds_1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
- username: root
- password:
- connectionTimeoutMilliseconds: 30000
- idleTimeoutMilliseconds: 60000
- maxLifetimeMilliseconds: 1800000
- maxPoolSize: 50
- minPoolSize: 1
-
-rules:
-- !SHARDING
- tables:
- t_order:
- actualDataNodes: ds_${0..1}.t_order
- t_order_item:
- actualDataNodes: ds_${0..1}.t_order_item
- bindingTables:
- - t_order,t_order_item
- broadcastTables:
- - t_address
-
- defaultDatabaseStrategy:
- hint:
- shardingAlgorithmName: hint_test
- defaultTableStrategy:
- none:
-
- shardingAlgorithms:
- hint_test:
- type: HINT_TEST
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-databases-tables.yaml b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-databases-tables.yaml
deleted file mode 100644
index a5f65e16af3..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-databases-tables.yaml
+++ /dev/null
@@ -1,78 +0,0 @@
-#
-# 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.
-#
-
-databaseName: databases_tables
-
-dataSources:
- ds_0:
- url: jdbc:mysql://localhost:3306/demo_ds_0?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
- username: root
- password:
- connectionTimeoutMilliseconds: 30000
- idleTimeoutMilliseconds: 60000
- maxLifetimeMilliseconds: 1800000
- maxPoolSize: 50
- minPoolSize: 1
- ds_1:
- url: jdbc:mysql://localhost:3306/demo_ds_1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
- username: root
- password:
- connectionTimeoutMilliseconds: 30000
- idleTimeoutMilliseconds: 60000
- maxLifetimeMilliseconds: 1800000
- maxPoolSize: 50
- minPoolSize: 1
-
-rules:
-- !SHARDING
- tables:
- t_order:
- actualDataNodes: ds_${0..1}.t_order_${0..1}
- databaseStrategy:
- hint:
- shardingAlgorithmName: hint_test
- tableStrategy:
- hint:
- shardingAlgorithmName: hint_test
- keyGenerateStrategy:
- column: order_id
- keyGeneratorName: snowflake
- t_order_item:
- actualDataNodes: ds_${0..1}.t_order_item_${0..1}
- bindingTables:
- - t_order,t_order_item
- broadcastTables:
- - t_address
-
- defaultDatabaseStrategy:
- standard:
- shardingColumn: user_id
- shardingAlgorithmName: database_inline
- defaultTableStrategy:
- none:
-
- shardingAlgorithms:
- hint_test:
- type: HINT_TEST
- database_inline:
- type: INLINE
- props:
- algorithm-expression: ds_${user_id % 2}
-
- keyGenerators:
- snowflake:
- type: SNOWFLAKE
diff --git a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-write-only.yaml b/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-write-only.yaml
deleted file mode 100644
index 7406fa8f2d5..00000000000
--- a/examples/shardingsphere-proxy-example/shardingsphere-proxy-hint-example/src/main/resources/conf/config-write-only.yaml
+++ /dev/null
@@ -1,57 +0,0 @@
-#
-# 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.
-#
-
-databaseName: write_only
-
-dataSources:
- write_ds:
- url: jdbc:mysql://localhost:3306/demo_write_ds?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
- username: root
- password:
- connectionTimeoutMilliseconds: 30000
- idleTimeoutMilliseconds: 60000
- maxLifetimeMilliseconds: 1800000
- maxPoolSize: 50
- minPoolSize: 1
- read_ds_0:
- url: jdbc:mysql://localhost:3306/demo_read_ds_0?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
- username: root
- password:
- connectionTimeoutMilliseconds: 30000
- idleTimeoutMilliseconds: 60000
- maxLifetimeMilliseconds: 1800000
- maxPoolSize: 50
- minPoolSize: 1
- read_ds_1:
- url: jdbc:mysql://localhost:3306/demo_read_ds_1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
- username: root
- password:
- connectionTimeoutMilliseconds: 30000
- idleTimeoutMilliseconds: 60000
- maxLifetimeMilliseconds: 1800000
- maxPoolSize: 50
- minPoolSize: 1
-
-rules:
-- !READWRITE_SPLITTING
- dataSources:
- readwrite_ds:
- staticStrategy:
- writeDataSourceName: write_ds
- readDataSourceNames:
- - read_ds_0
- - read_ds_1
diff --git a/features/readwrite-splitting/distsql/parser/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/core/ReadwriteSplittingDistSQLStatementVisitor.java b/features/readwrite-splitting/distsql/parser/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/core/ReadwriteSplittingDistSQLStatementVisitor.java
index 9b1309c9da0..eedbc9838e4 100644
--- a/features/readwrite-splitting/distsql/parser/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/core/ReadwriteSplittingDistSQLStatementVisitor.java
+++ b/features/readwrite-splitting/distsql/parser/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/core/ReadwriteSplittingDistSQLStatementVisitor.java
@@ -22,7 +22,6 @@ import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQ
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.AlgorithmDefinitionContext;
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.AlterReadwriteSplittingRuleContext;
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.AlterReadwriteSplittingStorageUnitStatusContext;
-import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.ClearReadwriteSplittingHintContext;
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.CountReadwriteSplittingRuleContext;
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.CreateReadwriteSplittingRuleContext;
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.DatabaseNameContext;
@@ -30,8 +29,6 @@ import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQ
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.PropertiesDefinitionContext;
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.PropertyContext;
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.ReadwriteSplittingRuleDefinitionContext;
-import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.SetReadwriteSplittingHintSourceContext;
-import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.ShowReadwriteSplittingHintStatusContext;
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.ShowReadwriteSplittingRulesContext;
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.ShowStatusFromReadwriteSplittingRulesContext;
import org.apache.shardingsphere.distsql.parser.autogen.ReadwriteSplittingDistSQLStatementParser.StaticReadwriteSplittingRuleDefinitionContext;
@@ -43,9 +40,6 @@ import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.Cre
import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.DropReadwriteSplittingRuleStatement;
import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.ShowReadwriteSplittingRulesStatement;
import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.ShowStatusFromReadwriteSplittingRulesStatement;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ClearReadwriteSplittingHintStatement;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.SetReadwriteSplittingHintStatement;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ShowReadwriteSplittingHintStatusStatement;
import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.status.AlterReadwriteSplittingStorageUnitStatusStatement;
import org.apache.shardingsphere.sql.parser.api.visitor.ASTNode;
import org.apache.shardingsphere.sql.parser.api.visitor.SQLVisitor;
@@ -128,25 +122,10 @@ public final class ReadwriteSplittingDistSQLStatementVisitor extends ReadwriteSp
return new ShowStatusFromReadwriteSplittingRulesStatement(databaseSegment, groupName);
}
- @Override
- public ASTNode visitSetReadwriteSplittingHintSource(final SetReadwriteSplittingHintSourceContext ctx) {
- return new SetReadwriteSplittingHintStatement(getIdentifierValue(ctx.sourceValue()));
- }
-
private String getIdentifierValue(final ParseTree context) {
return null == context ? null : new IdentifierValue(context.getText()).getValue();
}
- @Override
- public ASTNode visitShowReadwriteSplittingHintStatus(final ShowReadwriteSplittingHintStatusContext ctx) {
- return new ShowReadwriteSplittingHintStatusStatement();
- }
-
- @Override
- public ASTNode visitClearReadwriteSplittingHint(final ClearReadwriteSplittingHintContext ctx) {
- return new ClearReadwriteSplittingHintStatement();
- }
-
@Override
public ASTNode visitCountReadwriteSplittingRule(final CountReadwriteSplittingRuleContext ctx) {
return new CountReadwriteSplittingRuleStatement(Objects.nonNull(ctx.databaseName()) ? (DatabaseSegment) visit(ctx.databaseName()) : null);
diff --git a/features/readwrite-splitting/distsql/statement/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/statement/hint/ClearReadwriteSplittingHintStatement.java b/features/readwrite-splitting/distsql/statement/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/statement/hint/ClearReadwriteSplittingHintStatement.java
deleted file mode 100644
index 70dd8c72b64..00000000000
--- a/features/readwrite-splitting/distsql/statement/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/statement/hint/ClearReadwriteSplittingHintStatement.java
+++ /dev/null
@@ -1,26 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint;
-
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-
-/**
- * Clear readwrite-splitting hint statement.
- */
-public final class ClearReadwriteSplittingHintStatement extends HintRALStatement {
-}
diff --git a/features/readwrite-splitting/distsql/statement/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/statement/hint/SetReadwriteSplittingHintStatement.java b/features/readwrite-splitting/distsql/statement/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/statement/hint/SetReadwriteSplittingHintStatement.java
deleted file mode 100644
index 5b199cd0877..00000000000
--- a/features/readwrite-splitting/distsql/statement/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/statement/hint/SetReadwriteSplittingHintStatement.java
+++ /dev/null
@@ -1,32 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint;
-
-import lombok.Getter;
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-
-/**
- * Set readwrite-splitting hint statement.
- */
-@RequiredArgsConstructor
-@Getter
-public final class SetReadwriteSplittingHintStatement extends HintRALStatement {
-
- private final String source;
-}
diff --git a/features/readwrite-splitting/distsql/statement/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/statement/hint/ShowReadwriteSplittingHintStatusStatement.java b/features/readwrite-splitting/distsql/statement/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/statement/hint/ShowReadwriteSplittingHintStatusStatement.java
deleted file mode 100644
index 1d5514e5876..00000000000
--- a/features/readwrite-splitting/distsql/statement/src/main/java/org/apache/shardingsphere/readwritesplitting/distsql/parser/statement/hint/ShowReadwriteSplittingHintStatusStatement.java
+++ /dev/null
@@ -1,26 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint;
-
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-
-/**
- * Show readwrite-splitting hint status statement.
- */
-public final class ShowReadwriteSplittingHintStatusStatement extends HintRALStatement {
-}
diff --git a/features/sharding/distsql/parser/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/core/ShardingDistSQLStatementVisitor.java b/features/sharding/distsql/parser/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/core/ShardingDistSQLStatementVisitor.java
index 43b68e40ff2..73d3093311a 100644
--- a/features/sharding/distsql/parser/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/core/ShardingDistSQLStatementVisitor.java
+++ b/features/sharding/distsql/parser/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/core/ShardingDistSQLStatementVisitor.java
@@ -19,15 +19,12 @@ package org.apache.shardingsphere.sharding.distsql.parser.core;
import org.antlr.v4.runtime.tree.ParseTree;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementBaseVisitor;
-import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.AddShardingHintDatabaseValueContext;
-import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.AddShardingHintTableValueContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.AlgorithmDefinitionContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.AlterDefaultShardingStrategyContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.AlterShardingTableReferenceRuleContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.AlterShardingTableRuleContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.AuditDefinitionContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.AutoShardingColumnDefinitionContext;
-import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ClearShardingHintContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.CountShardingRuleContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.CreateBroadcastTableRuleContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.CreateDefaultShardingStrategyContext;
@@ -45,7 +42,6 @@ import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatement
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.KeyGenerateDefinitionContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.PropertiesDefinitionContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.PropertyContext;
-import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.SetShardingHintDatabaseValueContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ShardingAutoTableRuleContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ShardingColumnDefinitionContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ShardingStrategyContext;
@@ -55,7 +51,6 @@ import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatement
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ShowDefaultShardingStrategyContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ShowShardingAlgorithmsContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ShowShardingAuditorsContext;
-import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ShowShardingHintStatusContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ShowShardingKeyGeneratorsContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ShowShardingTableNodesContext;
import org.apache.shardingsphere.distsql.parser.autogen.ShardingDistSQLStatementParser.ShowShardingTableReferenceRulesContext;
@@ -108,11 +103,6 @@ import org.apache.shardingsphere.sharding.distsql.parser.statement.ShowShardingT
import org.apache.shardingsphere.sharding.distsql.parser.statement.ShowUnusedShardingAlgorithmsStatement;
import org.apache.shardingsphere.sharding.distsql.parser.statement.ShowUnusedShardingAuditorsStatement;
import org.apache.shardingsphere.sharding.distsql.parser.statement.ShowUnusedShardingKeyGeneratorsStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintDatabaseValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintTableValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ClearShardingHintStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.SetShardingHintDatabaseValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ShowShardingHintStatusStatement;
import org.apache.shardingsphere.sql.parser.api.visitor.ASTNode;
import org.apache.shardingsphere.sql.parser.api.visitor.SQLVisitor;
import org.apache.shardingsphere.sql.parser.sql.common.segment.generic.DatabaseSegment;
@@ -202,26 +192,6 @@ public final class ShardingDistSQLStatementVisitor extends ShardingDistSQLStatem
return new CreateDefaultShardingStrategyStatement(null != ctx.ifNotExists(), defaultType, strategyType, shardingColumn, algorithmSegment);
}
- @Override
- public ASTNode visitSetShardingHintDatabaseValue(final SetShardingHintDatabaseValueContext ctx) {
- return new SetShardingHintDatabaseValueStatement(getIdentifierValue(ctx.shardingValue()));
- }
-
- @Override
- public ASTNode visitAddShardingHintDatabaseValue(final AddShardingHintDatabaseValueContext ctx) {
- return new AddShardingHintDatabaseValueStatement(getIdentifierValue(ctx.tableName()), getIdentifierValue(ctx.shardingValue()));
- }
-
- @Override
- public ASTNode visitAddShardingHintTableValue(final AddShardingHintTableValueContext ctx) {
- return new AddShardingHintTableValueStatement(getIdentifierValue(ctx.tableName()), getIdentifierValue(ctx.shardingValue()));
- }
-
- @Override
- public ASTNode visitShowShardingHintStatus(final ShowShardingHintStatusContext ctx) {
- return new ShowShardingHintStatusStatement();
- }
-
@Override
public ASTNode visitAlterDefaultShardingStrategy(final AlterDefaultShardingStrategyContext ctx) {
String defaultType = new IdentifierValue(ctx.type.getText()).getValue();
@@ -241,11 +211,6 @@ public final class ShardingDistSQLStatementVisitor extends ShardingDistSQLStatem
return new DropDefaultShardingStrategyStatement(null != ctx.ifExists(), new IdentifierValue(ctx.type.getText()).getValue().toLowerCase());
}
- @Override
- public ASTNode visitClearShardingHint(final ClearShardingHintContext ctx) {
- return new ClearShardingHintStatement();
- }
-
@Override
public ASTNode visitDropBroadcastTableRule(final DropBroadcastTableRuleContext ctx) {
Collection<String> tableNames = ctx.tableName().stream().map(this::getIdentifierValue).collect(Collectors.toList());
diff --git a/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/AddShardingHintDatabaseValueStatement.java b/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/AddShardingHintDatabaseValueStatement.java
deleted file mode 100644
index 38771e2927d..00000000000
--- a/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/AddShardingHintDatabaseValueStatement.java
+++ /dev/null
@@ -1,34 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.sharding.distsql.parser.statement.hint;
-
-import lombok.Getter;
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-
-/**
- * Add sharding hint database value statement.
- */
-@RequiredArgsConstructor
-@Getter
-public final class AddShardingHintDatabaseValueStatement extends HintRALStatement {
-
- private final String logicTableName;
-
- private final String shardingValue;
-}
diff --git a/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/AddShardingHintTableValueStatement.java b/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/AddShardingHintTableValueStatement.java
deleted file mode 100644
index 4dec49ccfd7..00000000000
--- a/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/AddShardingHintTableValueStatement.java
+++ /dev/null
@@ -1,34 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.sharding.distsql.parser.statement.hint;
-
-import lombok.Getter;
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-
-/**
- * Add sharding hint table value statement.
- */
-@RequiredArgsConstructor
-@Getter
-public final class AddShardingHintTableValueStatement extends HintRALStatement {
-
- private final String logicTableName;
-
- private final String shardingValue;
-}
diff --git a/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/ClearShardingHintStatement.java b/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/ClearShardingHintStatement.java
deleted file mode 100644
index 8acca331d97..00000000000
--- a/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/ClearShardingHintStatement.java
+++ /dev/null
@@ -1,26 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.sharding.distsql.parser.statement.hint;
-
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-
-/**
- * Clear sharding hint statement.
- */
-public final class ClearShardingHintStatement extends HintRALStatement {
-}
diff --git a/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/SetShardingHintDatabaseValueStatement.java b/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/SetShardingHintDatabaseValueStatement.java
deleted file mode 100644
index d7a7206b8b6..00000000000
--- a/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/SetShardingHintDatabaseValueStatement.java
+++ /dev/null
@@ -1,32 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.sharding.distsql.parser.statement.hint;
-
-import lombok.Getter;
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-
-/**
- * Set sharding hint database value statement.
- */
-@RequiredArgsConstructor
-@Getter
-public final class SetShardingHintDatabaseValueStatement extends HintRALStatement {
-
- private final String shardingValue;
-}
diff --git a/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/ShowShardingHintStatusStatement.java b/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/ShowShardingHintStatusStatement.java
deleted file mode 100644
index 6c2d4fbff58..00000000000
--- a/features/sharding/distsql/statement/src/main/java/org/apache/shardingsphere/sharding/distsql/parser/statement/hint/ShowShardingHintStatusStatement.java
+++ /dev/null
@@ -1,26 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.sharding.distsql.parser.statement.hint;
-
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-
-/**
- * Show sharding hint status statement.
- */
-public final class ShowShardingHintStatusStatement extends HintRALStatement {
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/RALBackendHandlerFactory.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/RALBackendHandlerFactory.java
index af7db86fdad..7a48504492b 100644
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/RALBackendHandlerFactory.java
+++ b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/RALBackendHandlerFactory.java
@@ -20,7 +20,6 @@ package org.apache.shardingsphere.proxy.backend.handler.distsql.ral;
import lombok.AccessLevel;
import lombok.NoArgsConstructor;
import org.apache.shardingsphere.distsql.handler.ral.update.RALUpdater;
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.QueryableRALStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.RALStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.UpdatableGlobalRuleRALStatement;
@@ -31,7 +30,6 @@ import org.apache.shardingsphere.infra.util.exception.ShardingSpherePrecondition
import org.apache.shardingsphere.infra.util.exception.external.sql.type.generic.UnsupportedSQLOperationException;
import org.apache.shardingsphere.infra.util.spi.type.typed.TypedSPILoader;
import org.apache.shardingsphere.proxy.backend.handler.ProxyBackendHandler;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintRALBackendHandler;
import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.migration.update.UpdatableScalingRALBackendHandler;
import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.updatable.RefreshTableMetaDataHandler;
import org.apache.shardingsphere.proxy.backend.session.ConnectionSession;
@@ -66,9 +64,6 @@ public final class RALBackendHandlerFactory {
if (TypedSPILoader.contains(RALUpdater.class, sqlStatement.getClass().getName())) {
return new UpdatableRALUpdaterBackendHandler<>((UpdatableRALStatement) sqlStatement, connectionSession);
}
- if (sqlStatement instanceof HintRALStatement) {
- return new HintRALBackendHandler((HintRALStatement) sqlStatement, connectionSession);
- }
if (sqlStatement instanceof UpdatableScalingRALStatement) {
return new UpdatableScalingRALBackendHandler((UpdatableScalingRALStatement) sqlStatement, connectionSession);
}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintManagerHolder.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintManagerHolder.java
deleted file mode 100644
index d0369478b3a..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintManagerHolder.java
+++ /dev/null
@@ -1,50 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.infra.hint.HintManager;
-
-/**
- * Holder for {@code HintManager}.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class HintManagerHolder {
-
- private static final ThreadLocal<HintManager> HINT_MANAGER_HOLDER = new ThreadLocal<>();
-
- /**
- * Get an instance for {@code HintManager} from {@code ThreadLocal},if not exist,then create new one.
- *
- * @return hint manager
- */
- public static HintManager get() {
- if (null == HINT_MANAGER_HOLDER.get()) {
- HINT_MANAGER_HOLDER.set(HintManager.getInstance());
- }
- return HINT_MANAGER_HOLDER.get();
- }
-
- /**
- * remove {@code HintManager} from {@code ThreadLocal}.
- */
- public static void remove() {
- HINT_MANAGER_HOLDER.remove();
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALBackendHandler.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALBackendHandler.java
deleted file mode 100644
index dced2911706..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALBackendHandler.java
+++ /dev/null
@@ -1,65 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint;
-
-import lombok.Getter;
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-import org.apache.shardingsphere.infra.config.props.ConfigurationPropertyKey;
-import org.apache.shardingsphere.infra.util.exception.ShardingSpherePreconditions;
-import org.apache.shardingsphere.infra.util.exception.external.sql.type.generic.UnsupportedSQLOperationException;
-import org.apache.shardingsphere.proxy.backend.context.ProxyContext;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.RALBackendHandler;
-import org.apache.shardingsphere.proxy.backend.response.data.QueryResponseRow;
-import org.apache.shardingsphere.proxy.backend.response.header.ResponseHeader;
-import org.apache.shardingsphere.proxy.backend.session.ConnectionSession;
-
-import java.sql.SQLException;
-
-/**
- * Hint RAL backend handler.
- */
-@RequiredArgsConstructor
-@Getter
-public final class HintRALBackendHandler extends RALBackendHandler {
-
- private final HintRALStatement sqlStatement;
-
- private final ConnectionSession connectionSession;
-
- private HintRALStatementExecutor<? extends HintRALStatement> hintRALStatementExecutor;
-
- @Override
- public ResponseHeader execute() {
- ShardingSpherePreconditions.checkState(
- ProxyContext.getInstance().getContextManager().getMetaDataContexts().getMetaData().getProps().<Boolean>getValue(ConfigurationPropertyKey.PROXY_HINT_ENABLED),
- () -> new UnsupportedSQLOperationException(String.format("%s should be true, please check your config", ConfigurationPropertyKey.PROXY_HINT_ENABLED.getKey())));
- hintRALStatementExecutor = HintRALStatementExecutorFactory.newInstance(sqlStatement, connectionSession);
- return hintRALStatementExecutor.execute();
- }
-
- @Override
- public boolean next() throws SQLException {
- return hintRALStatementExecutor.next();
- }
-
- @Override
- public QueryResponseRow getRowData() throws SQLException {
- return hintRALStatementExecutor.getQueryResponseRow();
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALStatementExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALStatementExecutor.java
deleted file mode 100644
index 7e4af458324..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALStatementExecutor.java
+++ /dev/null
@@ -1,53 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint;
-
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-import org.apache.shardingsphere.proxy.backend.response.data.QueryResponseRow;
-import org.apache.shardingsphere.proxy.backend.response.header.ResponseHeader;
-
-import java.sql.SQLException;
-
-/**
- * Hint RAL statement executor.
- */
-public interface HintRALStatementExecutor<T extends HintRALStatement> {
-
- /**
- * Execute hint RAL statement.
- *
- * @return backend response
- */
- ResponseHeader execute();
-
- /**
- * Goto next result value.
- *
- * @return has more result value or not
- * @throws SQLException SQL exception
- */
- boolean next() throws SQLException;
-
- /**
- * Get query response row.
- *
- * @return query response row
- * @throws SQLException SQL exception
- */
- QueryResponseRow getQueryResponseRow() throws SQLException;
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALStatementExecutorFactory.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALStatementExecutorFactory.java
deleted file mode 100644
index b4d3e48c367..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALStatementExecutorFactory.java
+++ /dev/null
@@ -1,87 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-import org.apache.shardingsphere.distsql.parser.statement.ral.hint.ClearHintStatement;
-import org.apache.shardingsphere.infra.util.exception.external.sql.type.generic.UnsupportedSQLOperationException;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.AddShardingHintDatabaseValueExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.AddShardingHintTableValueExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.ClearHintExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.ClearReadwriteSplittingHintExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.ClearShardingHintExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.SetReadwriteSplittingHintExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.SetShardingHintDatabaseValueExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.ShowReadwriteSplittingHintStatusExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.ShowShardingHintStatusExecutor;
-import org.apache.shardingsphere.proxy.backend.session.ConnectionSession;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ClearReadwriteSplittingHintStatement;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.SetReadwriteSplittingHintStatement;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ShowReadwriteSplittingHintStatusStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintDatabaseValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintTableValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ClearShardingHintStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.SetShardingHintDatabaseValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ShowShardingHintStatusStatement;
-
-/**
- * Hint RAL statement executor factory.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class HintRALStatementExecutorFactory {
-
- /**
- * Create hint RAL statement executor instance.
- *
- * @param sqlStatement hint RAL statement
- * @param connectionSession connection session
- * @return hint RAL statement executor
- */
- public static HintRALStatementExecutor<? extends HintRALStatement> newInstance(final HintRALStatement sqlStatement, final ConnectionSession connectionSession) {
- if (sqlStatement instanceof SetReadwriteSplittingHintStatement) {
- return new SetReadwriteSplittingHintExecutor((SetReadwriteSplittingHintStatement) sqlStatement);
- }
- if (sqlStatement instanceof ShowReadwriteSplittingHintStatusStatement) {
- return new ShowReadwriteSplittingHintStatusExecutor();
- }
- if (sqlStatement instanceof ClearReadwriteSplittingHintStatement) {
- return new ClearReadwriteSplittingHintExecutor((ClearReadwriteSplittingHintStatement) sqlStatement);
- }
- if (sqlStatement instanceof ClearHintStatement) {
- return new ClearHintExecutor((ClearHintStatement) sqlStatement);
- }
- if (sqlStatement instanceof SetShardingHintDatabaseValueStatement) {
- return new SetShardingHintDatabaseValueExecutor((SetShardingHintDatabaseValueStatement) sqlStatement);
- }
- if (sqlStatement instanceof AddShardingHintDatabaseValueStatement) {
- return new AddShardingHintDatabaseValueExecutor((AddShardingHintDatabaseValueStatement) sqlStatement);
- }
- if (sqlStatement instanceof AddShardingHintTableValueStatement) {
- return new AddShardingHintTableValueExecutor((AddShardingHintTableValueStatement) sqlStatement);
- }
- if (sqlStatement instanceof ShowShardingHintStatusStatement) {
- return new ShowShardingHintStatusExecutor(connectionSession);
- }
- if (sqlStatement instanceof ClearShardingHintStatement) {
- return new ClearShardingHintExecutor((ClearShardingHintStatement) sqlStatement);
- }
- throw new UnsupportedSQLOperationException(sqlStatement.getClass().getName());
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/enums/HintShardingType.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/enums/HintShardingType.java
deleted file mode 100644
index b9d271903ea..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/enums/HintShardingType.java
+++ /dev/null
@@ -1,26 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.enums;
-
-/**
- * Hint sharding type.
- */
-public enum HintShardingType {
-
- DATABASES_ONLY, DATABASES_TABLES
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/enums/HintSourceType.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/enums/HintSourceType.java
deleted file mode 100644
index e30d4809b3b..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/enums/HintSourceType.java
+++ /dev/null
@@ -1,51 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.enums;
-
-import lombok.Getter;
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.infra.util.exception.external.sql.type.generic.UnsupportedSQLOperationException;
-
-/**
- * Hint source type.
- */
-@RequiredArgsConstructor
-@Getter
-public enum HintSourceType {
-
- AUTO("auto"),
-
- WRITE("write");
-
- private final String value;
-
- /**
- * Convert string to HintSourceType.
- *
- * @param value value
- * @return hint source type
- */
- public static HintSourceType typeOf(final String value) {
- for (HintSourceType each : values()) {
- if (each.value.equalsIgnoreCase(value)) {
- return each;
- }
- }
- throw new UnsupportedSQLOperationException(String.format("unsupported hint source type: %s", value));
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AbstractHintQueryExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AbstractHintQueryExecutor.java
deleted file mode 100644
index 5c05042dc6f..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AbstractHintQueryExecutor.java
+++ /dev/null
@@ -1,66 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-import org.apache.shardingsphere.infra.merge.result.MergedResult;
-import org.apache.shardingsphere.proxy.backend.response.data.QueryResponseCell;
-import org.apache.shardingsphere.proxy.backend.response.data.QueryResponseRow;
-import org.apache.shardingsphere.proxy.backend.response.header.ResponseHeader;
-import org.apache.shardingsphere.proxy.backend.response.header.query.QueryHeader;
-import org.apache.shardingsphere.proxy.backend.response.header.query.QueryResponseHeader;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintRALStatementExecutor;
-
-import java.sql.SQLException;
-import java.util.ArrayList;
-import java.util.List;
-
-/**
- * Abstract hint query executor.
- */
-public abstract class AbstractHintQueryExecutor<T extends HintRALStatement> implements HintRALStatementExecutor<T> {
-
- private List<QueryHeader> queryHeaders;
-
- private MergedResult mergedResult;
-
- @Override
- public final ResponseHeader execute() {
- queryHeaders = createQueryHeaders();
- mergedResult = createMergedResult();
- return new QueryResponseHeader(queryHeaders);
- }
-
- protected abstract List<QueryHeader> createQueryHeaders();
-
- protected abstract MergedResult createMergedResult();
-
- @Override
- public final boolean next() throws SQLException {
- return null != mergedResult && mergedResult.next();
- }
-
- @Override
- public final QueryResponseRow getQueryResponseRow() throws SQLException {
- List<QueryResponseCell> cells = new ArrayList<>(queryHeaders.size());
- for (int i = 0; i < queryHeaders.size(); i++) {
- cells.add(new QueryResponseCell(queryHeaders.get(i).getColumnType(), mergedResult.getValue(i + 1, Object.class)));
- }
- return new QueryResponseRow(cells);
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AbstractHintUpdateExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AbstractHintUpdateExecutor.java
deleted file mode 100644
index 2585b37ed29..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AbstractHintUpdateExecutor.java
+++ /dev/null
@@ -1,38 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-import org.apache.shardingsphere.proxy.backend.response.data.QueryResponseRow;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintRALStatementExecutor;
-
-/**
- * Abstract hint update executor.
- */
-public abstract class AbstractHintUpdateExecutor<T extends HintRALStatement> implements HintRALStatementExecutor<T> {
-
- @Override
- public final boolean next() {
- return false;
- }
-
- @Override
- public final QueryResponseRow getQueryResponseRow() {
- return null;
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AddShardingHintDatabaseValueExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AddShardingHintDatabaseValueExecutor.java
deleted file mode 100644
index 1b2b86b37fe..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AddShardingHintDatabaseValueExecutor.java
+++ /dev/null
@@ -1,39 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintManagerHolder;
-import org.apache.shardingsphere.proxy.backend.response.header.ResponseHeader;
-import org.apache.shardingsphere.proxy.backend.response.header.update.UpdateResponseHeader;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintDatabaseValueStatement;
-
-/**
- * Add sharding hint database value executor.
- */
-@RequiredArgsConstructor
-public final class AddShardingHintDatabaseValueExecutor extends AbstractHintUpdateExecutor<AddShardingHintDatabaseValueStatement> {
-
- private final AddShardingHintDatabaseValueStatement sqlStatement;
-
- @Override
- public ResponseHeader execute() {
- HintManagerHolder.get().addDatabaseShardingValue(sqlStatement.getLogicTableName(), sqlStatement.getShardingValue());
- return new UpdateResponseHeader(sqlStatement);
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AddShardingHintTableValueExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AddShardingHintTableValueExecutor.java
deleted file mode 100644
index a70179f245e..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/AddShardingHintTableValueExecutor.java
+++ /dev/null
@@ -1,39 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintManagerHolder;
-import org.apache.shardingsphere.proxy.backend.response.header.ResponseHeader;
-import org.apache.shardingsphere.proxy.backend.response.header.update.UpdateResponseHeader;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintTableValueStatement;
-
-/**
- * Add sharding hint table value executor.
- */
-@RequiredArgsConstructor
-public final class AddShardingHintTableValueExecutor extends AbstractHintUpdateExecutor<AddShardingHintTableValueStatement> {
-
- private final AddShardingHintTableValueStatement sqlStatement;
-
- @Override
- public ResponseHeader execute() {
- HintManagerHolder.get().addTableShardingValue(sqlStatement.getLogicTableName(), sqlStatement.getShardingValue());
- return new UpdateResponseHeader(sqlStatement);
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ClearHintExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ClearHintExecutor.java
deleted file mode 100644
index e494489b902..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ClearHintExecutor.java
+++ /dev/null
@@ -1,40 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.hint.ClearHintStatement;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintManagerHolder;
-import org.apache.shardingsphere.proxy.backend.response.header.ResponseHeader;
-import org.apache.shardingsphere.proxy.backend.response.header.update.UpdateResponseHeader;
-
-/**
- * Clear hint statement executor.
- */
-@RequiredArgsConstructor
-public final class ClearHintExecutor extends AbstractHintUpdateExecutor<ClearHintStatement> {
-
- private final ClearHintStatement sqlStatement;
-
- @Override
- public ResponseHeader execute() {
- HintManagerHolder.get().close();
- HintManagerHolder.remove();
- return new UpdateResponseHeader(sqlStatement);
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ClearReadwriteSplittingHintExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ClearReadwriteSplittingHintExecutor.java
deleted file mode 100644
index f0a28a0cfa8..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ClearReadwriteSplittingHintExecutor.java
+++ /dev/null
@@ -1,39 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintManagerHolder;
-import org.apache.shardingsphere.proxy.backend.response.header.ResponseHeader;
-import org.apache.shardingsphere.proxy.backend.response.header.update.UpdateResponseHeader;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ClearReadwriteSplittingHintStatement;
-
-/**
- * Clear readwrite-splitting hint executor.
- */
-@RequiredArgsConstructor
-public final class ClearReadwriteSplittingHintExecutor extends AbstractHintUpdateExecutor<ClearReadwriteSplittingHintStatement> {
-
- private final ClearReadwriteSplittingHintStatement sqlStatement;
-
- @Override
- public ResponseHeader execute() {
- HintManagerHolder.get().setReadwriteSplittingAuto();
- return new UpdateResponseHeader(sqlStatement);
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ClearShardingHintExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ClearShardingHintExecutor.java
deleted file mode 100644
index 2eb055af4f6..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ClearShardingHintExecutor.java
+++ /dev/null
@@ -1,39 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintManagerHolder;
-import org.apache.shardingsphere.proxy.backend.response.header.ResponseHeader;
-import org.apache.shardingsphere.proxy.backend.response.header.update.UpdateResponseHeader;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ClearShardingHintStatement;
-
-/**
- * Clear sharding hint executor.
- */
-@RequiredArgsConstructor
-public final class ClearShardingHintExecutor extends AbstractHintUpdateExecutor<ClearShardingHintStatement> {
-
- private final ClearShardingHintStatement sqlStatement;
-
- @Override
- public ResponseHeader execute() {
- HintManagerHolder.get().clearShardingValues();
- return new UpdateResponseHeader(sqlStatement);
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/SetReadwriteSplittingHintExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/SetReadwriteSplittingHintExecutor.java
deleted file mode 100644
index e33df38c09c..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/SetReadwriteSplittingHintExecutor.java
+++ /dev/null
@@ -1,50 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintManagerHolder;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.enums.HintSourceType;
-import org.apache.shardingsphere.proxy.backend.response.header.ResponseHeader;
-import org.apache.shardingsphere.proxy.backend.response.header.update.UpdateResponseHeader;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.SetReadwriteSplittingHintStatement;
-
-/**
- * Set readwrite-splitting hint statement executor.
- */
-@RequiredArgsConstructor
-public final class SetReadwriteSplittingHintExecutor extends AbstractHintUpdateExecutor<SetReadwriteSplittingHintStatement> {
-
- private final SetReadwriteSplittingHintStatement sqlStatement;
-
- @Override
- public ResponseHeader execute() {
- HintSourceType sourceType = HintSourceType.typeOf(sqlStatement.getSource());
- switch (sourceType) {
- case AUTO:
- HintManagerHolder.get().setReadwriteSplittingAuto();
- break;
- case WRITE:
- HintManagerHolder.get().setWriteRouteOnly();
- break;
- default:
- break;
- }
- return new UpdateResponseHeader(sqlStatement);
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/SetShardingHintDatabaseValueExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/SetShardingHintDatabaseValueExecutor.java
deleted file mode 100644
index ac7c32d6179..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/SetShardingHintDatabaseValueExecutor.java
+++ /dev/null
@@ -1,39 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintManagerHolder;
-import org.apache.shardingsphere.proxy.backend.response.header.ResponseHeader;
-import org.apache.shardingsphere.proxy.backend.response.header.update.UpdateResponseHeader;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.SetShardingHintDatabaseValueStatement;
-
-/**
- * Set sharding hint database value executor.
- */
-@RequiredArgsConstructor
-public final class SetShardingHintDatabaseValueExecutor extends AbstractHintUpdateExecutor<SetShardingHintDatabaseValueStatement> {
-
- private final SetShardingHintDatabaseValueStatement sqlStatement;
-
- @Override
- public ResponseHeader execute() {
- HintManagerHolder.get().setDatabaseShardingValue(sqlStatement.getShardingValue());
- return new UpdateResponseHeader(sqlStatement);
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ShowReadwriteSplittingHintStatusExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ShowReadwriteSplittingHintStatusExecutor.java
deleted file mode 100644
index 17eca06cb81..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ShowReadwriteSplittingHintStatusExecutor.java
+++ /dev/null
@@ -1,52 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.infra.hint.HintManager;
-import org.apache.shardingsphere.infra.merge.result.MergedResult;
-import org.apache.shardingsphere.infra.merge.result.impl.local.LocalDataMergedResult;
-import org.apache.shardingsphere.infra.merge.result.impl.local.LocalDataQueryResultRow;
-import org.apache.shardingsphere.proxy.backend.response.header.query.QueryHeader;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.enums.HintSourceType;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ShowReadwriteSplittingHintStatusStatement;
-
-import java.sql.Types;
-import java.util.ArrayList;
-import java.util.Collections;
-import java.util.List;
-
-/**
- * Show readwrite-splitting hint status executor.
- */
-@RequiredArgsConstructor
-public final class ShowReadwriteSplittingHintStatusExecutor extends AbstractHintQueryExecutor<ShowReadwriteSplittingHintStatusStatement> {
-
- @Override
- protected List<QueryHeader> createQueryHeaders() {
- List<QueryHeader> result = new ArrayList<>(2);
- result.add(new QueryHeader("", "", "source", "", Types.CHAR, "CHAR", 5, 0, false, false, false, false));
- return result;
- }
-
- @Override
- protected MergedResult createMergedResult() {
- LocalDataQueryResultRow row = new LocalDataQueryResultRow(HintManager.isWriteRouteOnly() ? HintSourceType.WRITE.getValue() : HintSourceType.AUTO.getValue());
- return new LocalDataMergedResult(Collections.singleton(row));
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ShowShardingHintStatusExecutor.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ShowShardingHintStatusExecutor.java
deleted file mode 100644
index cfe8c42e140..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/executor/ShowShardingHintStatusExecutor.java
+++ /dev/null
@@ -1,102 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor;
-
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine;
-import org.apache.shardingsphere.infra.hint.HintManager;
-import org.apache.shardingsphere.infra.merge.result.MergedResult;
-import org.apache.shardingsphere.infra.merge.result.impl.local.LocalDataMergedResult;
-import org.apache.shardingsphere.infra.merge.result.impl.local.LocalDataQueryResultRow;
-import org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabase;
-import org.apache.shardingsphere.infra.util.exception.ShardingSpherePreconditions;
-import org.apache.shardingsphere.proxy.backend.context.ProxyContext;
-import org.apache.shardingsphere.proxy.backend.exception.RuleNotExistedException;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.enums.HintShardingType;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.result.ShowShardingHintStatusResult;
-import org.apache.shardingsphere.proxy.backend.response.header.query.QueryHeader;
-import org.apache.shardingsphere.proxy.backend.session.ConnectionSession;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ShowShardingHintStatusStatement;
-
-import java.sql.Types;
-import java.util.ArrayList;
-import java.util.Collection;
-import java.util.Collections;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
-import java.util.stream.Collectors;
-
-/**
- * Show sharding hint status executor.
- */
-@RequiredArgsConstructor
-public final class ShowShardingHintStatusExecutor extends AbstractHintQueryExecutor<ShowShardingHintStatusStatement> {
-
- private final ConnectionSession connectionSession;
-
- @Override
- protected List<QueryHeader> createQueryHeaders() {
- List<QueryHeader> result = new ArrayList<>(4);
- result.add(new QueryHeader("", "", "table_name", "", Types.CHAR, "CHAR", 255, 0, false, false, false, false));
- result.add(new QueryHeader("", "", "database_sharding_values", "", Types.CHAR, "CHAR", 255, 0, false, false, false, false));
- result.add(new QueryHeader("", "", "table_sharding_values", "", Types.CHAR, "CHAR", 255, 0, false, false, false, false));
- result.add(new QueryHeader("", "", "sharding_type", "", Types.CHAR, "CHAR", 255, 0, false, false, false, false));
- return result;
- }
-
- @Override
- protected MergedResult createMergedResult() {
- Map<String, ShowShardingHintStatusResult> results = new HashMap<>();
- ShardingSphereDatabase database = ProxyContext.getInstance().getDatabase(connectionSession.getDatabaseName());
- ShardingSpherePreconditions.checkState(database.isComplete(), () -> new RuleNotExistedException(connectionSession.getDatabaseName()));
- String schemaName = DatabaseTypeEngine.getDefaultSchemaName(connectionSession.getProtocolType(), connectionSession.getDatabaseName());
- Collection<String> tableNames = database.getSchema(schemaName).getAllTableNames();
- for (String each : tableNames) {
- if (HintManager.isDatabaseShardingOnly()) {
- fillShardingValues(results, each, HintManager.getDatabaseShardingValues(), Collections.emptyList());
- } else {
- fillShardingValues(results, each, HintManager.getDatabaseShardingValues(each), HintManager.getTableShardingValues(each));
- }
- }
- return convertToMergedResult(results.values());
- }
-
- private void fillShardingValues(final Map<String, ShowShardingHintStatusResult> results, final String logicTable,
- final Collection<Comparable<?>> databaseShardingValues, final Collection<Comparable<?>> tableShardingValues) {
- if (!results.containsKey(logicTable)) {
- results.put(logicTable, new ShowShardingHintStatusResult(logicTable));
- }
- for (Comparable<?> each : databaseShardingValues) {
- results.get(logicTable).getDatabaseShardingValues().add(each.toString());
- }
- for (Comparable<?> each : tableShardingValues) {
- results.get(logicTable).getTableShardingValues().add(each.toString());
- }
- }
-
- private MergedResult convertToMergedResult(final Collection<ShowShardingHintStatusResult> showShardingHintStatusResults) {
- return new LocalDataMergedResult(showShardingHintStatusResults.stream().map(this::createRow).collect(Collectors.toList()));
- }
-
- private LocalDataQueryResultRow createRow(final ShowShardingHintStatusResult showShardingHintStatusResult) {
- return new LocalDataQueryResultRow(showShardingHintStatusResult.getLogicTable(),
- String.join(",", showShardingHintStatusResult.getDatabaseShardingValues()), String.join(",", showShardingHintStatusResult.getTableShardingValues()),
- String.valueOf(HintManager.isDatabaseShardingOnly() ? HintShardingType.DATABASES_ONLY : HintShardingType.DATABASES_TABLES).toLowerCase());
- }
-}
diff --git a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/result/ShowShardingHintStatusResult.java b/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/result/ShowShardingHintStatusResult.java
deleted file mode 100644
index 8b42f4db9d5..00000000000
--- a/proxy/backend/core/src/main/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/result/ShowShardingHintStatusResult.java
+++ /dev/null
@@ -1,38 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.result;
-
-import lombok.Getter;
-import lombok.RequiredArgsConstructor;
-
-import java.util.Collection;
-import java.util.LinkedList;
-
-/**
- * Show sharding hint status result.
- */
-@Getter
-@RequiredArgsConstructor
-public final class ShowShardingHintStatusResult {
-
- private final String logicTable;
-
- private final Collection<String> databaseShardingValues = new LinkedList<>();
-
- private final Collection<String> tableShardingValues = new LinkedList<>();
-}
diff --git a/proxy/backend/core/src/test/java/org/apache/shardingsphere/proxy/backend/handler/ProxyBackendHandlerFactoryTest.java b/proxy/backend/core/src/test/java/org/apache/shardingsphere/proxy/backend/handler/ProxyBackendHandlerFactoryTest.java
index 8f04ded6422..58b3e2a05d5 100644
--- a/proxy/backend/core/src/test/java/org/apache/shardingsphere/proxy/backend/handler/ProxyBackendHandlerFactoryTest.java
+++ b/proxy/backend/core/src/test/java/org/apache/shardingsphere/proxy/backend/handler/ProxyBackendHandlerFactoryTest.java
@@ -37,7 +37,6 @@ import org.apache.shardingsphere.proxy.backend.handler.admin.DatabaseAdminQueryB
import org.apache.shardingsphere.proxy.backend.handler.data.impl.UnicastDatabaseBackendHandler;
import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.QueryableRALBackendHandler;
import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.UpdatableRALUpdaterBackendHandler;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.HintRALBackendHandler;
import org.apache.shardingsphere.proxy.backend.handler.distsql.rql.RQLBackendHandler;
import org.apache.shardingsphere.proxy.backend.handler.distsql.rul.SQLRULBackendHandler;
import org.apache.shardingsphere.proxy.backend.handler.skip.SkipBackendHandler;
@@ -118,9 +117,6 @@ public final class ProxyBackendHandlerFactoryTest extends ProxyContextRestorer {
sql = "show dist variables";
actual = ProxyBackendHandlerFactory.newInstance(databaseType, sql, connectionSession);
assertThat(actual, instanceOf(QueryableRALBackendHandler.class));
- sql = "set sharding hint database_value=1";
- actual = ProxyBackendHandlerFactory.newInstance(databaseType, sql, connectionSession);
- assertThat(actual, instanceOf(HintRALBackendHandler.class));
}
@Test
diff --git a/proxy/backend/core/src/test/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALStatementExecutorFactoryTest.java b/proxy/backend/core/src/test/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALStatementExecutorFactoryTest.java
deleted file mode 100644
index 3ea9fa49f5f..00000000000
--- a/proxy/backend/core/src/test/java/org/apache/shardingsphere/proxy/backend/handler/distsql/ral/hint/HintRALStatementExecutorFactoryTest.java
+++ /dev/null
@@ -1,108 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint;
-
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-import org.apache.shardingsphere.distsql.parser.statement.ral.hint.ClearHintStatement;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.AddShardingHintDatabaseValueExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.AddShardingHintTableValueExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.ClearHintExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.ClearReadwriteSplittingHintExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.ClearShardingHintExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.SetReadwriteSplittingHintExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.SetShardingHintDatabaseValueExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.ShowReadwriteSplittingHintStatusExecutor;
-import org.apache.shardingsphere.proxy.backend.handler.distsql.ral.hint.executor.ShowShardingHintStatusExecutor;
-import org.apache.shardingsphere.proxy.backend.session.ConnectionSession;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ClearReadwriteSplittingHintStatement;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.SetReadwriteSplittingHintStatement;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ShowReadwriteSplittingHintStatusStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintDatabaseValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintTableValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ClearShardingHintStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.SetShardingHintDatabaseValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ShowShardingHintStatusStatement;
-import org.junit.Test;
-import org.junit.runner.RunWith;
-import org.mockito.Mock;
-import org.mockito.junit.MockitoJUnitRunner;
-
-import static org.hamcrest.CoreMatchers.instanceOf;
-import static org.hamcrest.MatcherAssert.assertThat;
-import static org.mockito.Mockito.mock;
-
-@RunWith(MockitoJUnitRunner.class)
-public final class HintRALStatementExecutorFactoryTest {
-
- @Mock
- private ConnectionSession connectionSession;
-
- @Test
- public void assertSetReadwriteSplittingHintSourceExecutor() {
- HintRALStatement sqlStatement = mock(SetReadwriteSplittingHintStatement.class);
- assertThat(HintRALStatementExecutorFactory.newInstance(sqlStatement, connectionSession), instanceOf(SetReadwriteSplittingHintExecutor.class));
- }
-
- @Test
- public void assertShowReadwriteSplittingHintSourceExecutor() {
- HintRALStatement sqlStatement = mock(ShowReadwriteSplittingHintStatusStatement.class);
- assertThat(HintRALStatementExecutorFactory.newInstance(sqlStatement, connectionSession), instanceOf(ShowReadwriteSplittingHintStatusExecutor.class));
- }
-
- @Test
- public void assertClearReadwriteSplittingHintSourceExecutor() {
- HintRALStatement sqlStatement = mock(ClearReadwriteSplittingHintStatement.class);
- assertThat(HintRALStatementExecutorFactory.newInstance(sqlStatement, connectionSession), instanceOf(ClearReadwriteSplittingHintExecutor.class));
- }
-
- @Test
- public void assertClearHintExecutor() {
- HintRALStatement sqlStatement = mock(ClearHintStatement.class);
- assertThat(HintRALStatementExecutorFactory.newInstance(sqlStatement, connectionSession), instanceOf(ClearHintExecutor.class));
- }
-
- @Test
- public void assertSetShardingHintDatabaseValueExecutor() {
- HintRALStatement sqlStatement = mock(SetShardingHintDatabaseValueStatement.class);
- assertThat(HintRALStatementExecutorFactory.newInstance(sqlStatement, connectionSession), instanceOf(SetShardingHintDatabaseValueExecutor.class));
- }
-
- @Test
- public void assertAddShardingHintDatabaseValueExecutor() {
- HintRALStatement sqlStatement = mock(AddShardingHintDatabaseValueStatement.class);
- assertThat(HintRALStatementExecutorFactory.newInstance(sqlStatement, connectionSession), instanceOf(AddShardingHintDatabaseValueExecutor.class));
- }
-
- @Test
- public void assertAddShardingHintTableValueExecutor() {
- HintRALStatement sqlStatement = mock(AddShardingHintTableValueStatement.class);
- assertThat(HintRALStatementExecutorFactory.newInstance(sqlStatement, connectionSession), instanceOf(AddShardingHintTableValueExecutor.class));
- }
-
- @Test
- public void assertShowShardingHintStatusExecutor() {
- HintRALStatement sqlStatement = mock(ShowShardingHintStatusStatement.class);
- assertThat(HintRALStatementExecutorFactory.newInstance(sqlStatement, connectionSession), instanceOf(ShowShardingHintStatusExecutor.class));
- }
-
- @Test
- public void assertClearShardingValueHintExecutor() {
- HintRALStatement sqlStatement = mock(ClearShardingHintStatement.class);
- assertThat(HintRALStatementExecutorFactory.newInstance(sqlStatement, connectionSession), instanceOf(ClearShardingHintExecutor.class));
- }
-}
diff --git a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/add_database_value_hint.xml b/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/add_database_value_hint.xml
deleted file mode 100644
index 747c2245641..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/add_database_value_hint.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<!--
- ~ 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.
- -->
-
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="database_sharding_values" />
- <column name="table_sharding_values" />
- <column name="sharding_type" />
- </metadata>
- <row values="t_single_table| | | databases_tables" />
- <row values="t_user_item| 100 | | databases_tables" />
- <row values="t_user| | | databases_tables" />
-</dataset>
diff --git a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/add_table_value_hint.xml b/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/add_table_value_hint.xml
deleted file mode 100644
index d53cc1e04df..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/add_table_value_hint.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<!--
- ~ 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.
- -->
-
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="database_sharding_values" />
- <column name="table_sharding_values" />
- <column name="sharding_type" />
- </metadata>
- <row values="t_single_table| | | databases_tables" />
- <row values="t_user_item| | 100| databases_tables" />
- <row values="t_user| | | databases_tables" />
-</dataset>
diff --git a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/default_sharding_hint.xml b/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/default_sharding_hint.xml
deleted file mode 100644
index 4d4b2cb981a..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/default_sharding_hint.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<!--
- ~ 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.
- -->
-
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="database_sharding_values" />
- <column name="table_sharding_values" />
- <column name="sharding_type" />
- </metadata>
- <row values="t_single_table| | | databases_tables" />
- <row values="t_user_item| | | databases_tables" />
- <row values="t_user| | | databases_tables" />
-</dataset>
diff --git a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/set_database_value_hint.xml b/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/set_database_value_hint.xml
deleted file mode 100644
index d7d877c4d33..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/cluster/set_database_value_hint.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<!--
- ~ 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.
- -->
-
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="database_sharding_values" />
- <column name="table_sharding_values" />
- <column name="sharding_type" />
- </metadata>
- <row values="t_single_table| 100| | databases_only" />
- <row values="t_user_item| 100| | databases_only" />
- <row values="t_user| 100| | databases_only" />
-</dataset>
diff --git a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/default_readwrite_splitting_hint.xml b/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/default_readwrite_splitting_hint.xml
deleted file mode 100644
index 553711029ef..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/default_readwrite_splitting_hint.xml
+++ /dev/null
@@ -1,23 +0,0 @@
-<!--
- ~ 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.
- -->
-
-<dataset>
- <metadata>
- <column name="source" />
- </metadata>
- <row values="auto" />
-</dataset>
diff --git a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/set_readwrite_splitting_hint.xml b/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/set_readwrite_splitting_hint.xml
deleted file mode 100644
index e24b6364607..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/set_readwrite_splitting_hint.xml
+++ /dev/null
@@ -1,23 +0,0 @@
-<!--
- ~ 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.
- -->
-
-<dataset>
- <metadata>
- <column name="source" />
- </metadata>
- <row values="write" />
-</dataset>
diff --git a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/add_database_value_hint.xml b/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/add_database_value_hint.xml
deleted file mode 100644
index 30ea032ad8e..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/add_database_value_hint.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<!--
- ~ 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.
- -->
-
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="database_sharding_values" />
- <column name="table_sharding_values" />
- <column name="sharding_type" />
- </metadata>
- <row values="t_single_table| | | databases_tables" />
- <row values="t_user| | | databases_tables" />
- <row values="t_user_item| 100 | | databases_tables" />
-</dataset>
diff --git a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/add_table_value_hint.xml b/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/add_table_value_hint.xml
deleted file mode 100644
index 5bd2e3b4cf4..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/add_table_value_hint.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<!--
- ~ 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.
- -->
-
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="database_sharding_values" />
- <column name="table_sharding_values" />
- <column name="sharding_type" />
- </metadata>
- <row values="t_single_table| | | databases_tables" />
- <row values="t_user| | | databases_tables" />
- <row values="t_user_item| | 100 | databases_tables" />
-</dataset>
diff --git a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/default_sharding_hint.xml b/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/default_sharding_hint.xml
deleted file mode 100644
index 09ae0ee9f2c..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/default_sharding_hint.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<!--
- ~ 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.
- -->
-
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="database_sharding_values" />
- <column name="table_sharding_values" />
- <column name="sharding_type" />
- </metadata>
- <row values="t_single_table| | | databases_tables" />
- <row values="t_user| | | databases_tables" />
- <row values="t_user_item| | | databases_tables" />
-</dataset>
diff --git a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/set_database_value_hint.xml b/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/set_database_value_hint.xml
deleted file mode 100644
index 378f29d34db..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/dataset/empty_rules/standalone/set_database_value_hint.xml
+++ /dev/null
@@ -1,28 +0,0 @@
-<!--
- ~ 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.
- -->
-
-<dataset>
- <metadata>
- <column name="table_name" />
- <column name="database_sharding_values" />
- <column name="table_sharding_values" />
- <column name="sharding_type" />
- </metadata>
- <row values="t_single_table| 100| | databases_only" />
- <row values="t_user| 100| | databases_only" />
- <row values="t_user_item| 100| | databases_only" />
-</dataset>
diff --git a/test/e2e/suite/src/test/resources/cases/ral/ral-integration-hint.xml b/test/e2e/suite/src/test/resources/cases/ral/ral-integration-hint.xml
deleted file mode 100644
index a50f5c19447..00000000000
--- a/test/e2e/suite/src/test/resources/cases/ral/ral-integration-hint.xml
+++ /dev/null
@@ -1,54 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
- ~ 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.
- -->
-
-<integration-test-cases>
- <test-case sql="SHOW READWRITE_SPLITTING HINT STATUS">
- <assertion expected-data-file="default_readwrite_splitting_hint.xml" />
- <assertion expected-data-file="set_readwrite_splitting_hint.xml">
- <initial-sql sql="SET READWRITE_SPLITTING HINT SOURCE = write" />
- <destroy-sql sql="CLEAR READWRITE_SPLITTING HINT" />
- </assertion>
- <assertion expected-data-file="default_readwrite_splitting_hint.xml">
- <initial-sql sql="SET READWRITE_SPLITTING HINT SOURCE = write;CLEAR READWRITE_SPLITTING HINT" />
- </assertion>
- <assertion expected-data-file="default_readwrite_splitting_hint.xml">
- <initial-sql sql="SET READWRITE_SPLITTING HINT SOURCE = write;CLEAR HINT" />
- </assertion>
- </test-case>
-
- <test-case sql="SHOW SHARDING HINT STATUS">
- <assertion expected-data-file="default_sharding_hint.xml" />
- <assertion expected-data-file="set_database_value_hint.xml">
- <initial-sql sql="SET SHARDING HINT DATABASE_VALUE = 100" />
- <destroy-sql sql="CLEAR SHARDING HINT" />
- </assertion>
- <assertion expected-data-file="add_database_value_hint.xml">
- <initial-sql sql="ADD SHARDING HINT DATABASE_VALUE t_user_item= 100" />
- <destroy-sql sql="CLEAR SHARDING HINT" />
- </assertion>
- <assertion expected-data-file="add_table_value_hint.xml">
- <initial-sql sql="ADD SHARDING HINT TABLE_VALUE t_user_item = 100" />
- </assertion>
- <assertion expected-data-file="default_sharding_hint.xml">
- <initial-sql sql="ADD SHARDING HINT TABLE_VALUE t_user_item= 100;CLEAR SHARDING HINT" />
- </assertion>
- <assertion expected-data-file="default_sharding_hint.xml">
- <initial-sql sql="ADD SHARDING HINT TABLE_VALUE t_user_item= 100;CLEAR HINT" />
- </assertion>
- </test-case>
-</integration-test-cases>
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/RALStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/RALStatementAssert.java
index c825ef461d8..ff03772188a 100644
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/RALStatementAssert.java
+++ b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/RALStatementAssert.java
@@ -19,14 +19,12 @@ package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.
import lombok.AccessLevel;
import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.QueryableRALStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.RALStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.UpdatableRALStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.scaling.QueryableScalingRALStatement;
import org.apache.shardingsphere.distsql.parser.statement.ral.scaling.UpdatableScalingRALStatement;
import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.HintRALStatementAssert;
import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.QueryableRALStatementAssert;
import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.migration.QueryableScalingRALStatementAssert;
import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.UpdatableRALStatementAssert;
@@ -55,8 +53,6 @@ public final class RALStatementAssert {
QueryableRALStatementAssert.assertIs(assertContext, (QueryableRALStatement) actual, expected);
} else if (actual instanceof UpdatableRALStatement) {
UpdatableRALStatementAssert.assertIs(assertContext, (UpdatableRALStatement) actual, expected);
- } else if (actual instanceof HintRALStatement) {
- HintRALStatementAssert.assertIs(assertContext, (HintRALStatement) actual, expected);
}
}
}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/HintRALStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/HintRALStatementAssert.java
deleted file mode 100644
index 705d99c7bcc..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/HintRALStatementAssert.java
+++ /dev/null
@@ -1,87 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.HintRALStatement;
-import org.apache.shardingsphere.distsql.parser.statement.ral.hint.ClearHintStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintDatabaseValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintTableValueStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ClearShardingHintStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.SetShardingHintDatabaseValueStatement;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.SetReadwriteSplittingHintStatement;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ShowReadwriteSplittingHintStatusStatement;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ShowShardingHintStatusStatement;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ClearReadwriteSplittingHintStatement;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint.AddShardingHintDatabaseValueStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint.AddShardingHintTableValueStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint.ClearHintStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint.ClearShardingHintStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint.SetShardingHintDatabaseValueStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint.SetReadwriteSplittingHintStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint.ShowReadwriteSplittingHintStatusStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint.ShowShardingHintStatusStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint.ClearReadwriteSplittingHintStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.SQLParserTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.AddShardingHintDatabaseValueStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.AddShardingHintTableValueStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ClearHintStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ClearShardingHintStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.SetShardingHintDatabaseValueStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.SetReadwriteSplittingHintStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ShowReadwriteSplittingHintStatusStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ShowShardingHintStatusStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ClearReadwriteSplittingHintStatementTestCase;
-
-/**
- * Hint RAL statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class HintRALStatementAssert {
-
- /**
- * Assert Hint RAL statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual hint RAL statement
- * @param expected expected hint RAL statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final HintRALStatement actual, final SQLParserTestCase expected) {
- if (actual instanceof AddShardingHintTableValueStatement) {
- AddShardingHintTableValueStatementAssert.assertIs(assertContext, (AddShardingHintTableValueStatement) actual, (AddShardingHintTableValueStatementTestCase) expected);
- } else if (actual instanceof AddShardingHintDatabaseValueStatement) {
- AddShardingHintDatabaseValueStatementAssert.assertIs(assertContext, (AddShardingHintDatabaseValueStatement) actual, (AddShardingHintDatabaseValueStatementTestCase) expected);
- } else if (actual instanceof SetShardingHintDatabaseValueStatement) {
- SetShardingHintDatabaseValueStatementAssert.assertIs(assertContext, (SetShardingHintDatabaseValueStatement) actual, (SetShardingHintDatabaseValueStatementTestCase) expected);
- } else if (actual instanceof SetReadwriteSplittingHintStatement) {
- SetReadwriteSplittingHintStatementAssert.assertIs(assertContext, (SetReadwriteSplittingHintStatement) actual, (SetReadwriteSplittingHintStatementTestCase) expected);
- } else if (actual instanceof ShowReadwriteSplittingHintStatusStatement) {
- ShowReadwriteSplittingHintStatusStatementAssert.assertIs(assertContext, (ShowReadwriteSplittingHintStatusStatement) actual, (ShowReadwriteSplittingHintStatusStatementTestCase) expected);
- } else if (actual instanceof ShowShardingHintStatusStatement) {
- ShowShardingHintStatusStatementAssert.assertIs(assertContext, (ShowShardingHintStatusStatement) actual, (ShowShardingHintStatusStatementTestCase) expected);
- } else if (actual instanceof ClearReadwriteSplittingHintStatement) {
- ClearReadwriteSplittingHintStatementAssert.assertIs(assertContext, (ClearReadwriteSplittingHintStatement) actual, (ClearReadwriteSplittingHintStatementTestCase) expected);
- } else if (actual instanceof ClearShardingHintStatement) {
- ClearShardingHintStatementAssert.assertIs(assertContext, (ClearShardingHintStatement) actual, (ClearShardingHintStatementTestCase) expected);
- } else if (actual instanceof ClearHintStatement) {
- ClearHintStatementAssert.assertIs(assertContext, (ClearHintStatement) actual, (ClearHintStatementTestCase) expected);
- }
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/AddShardingHintDatabaseValueStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/AddShardingHintDatabaseValueStatementAssert.java
deleted file mode 100644
index 6c455ae6140..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/AddShardingHintDatabaseValueStatementAssert.java
+++ /dev/null
@@ -1,53 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintDatabaseValueStatement;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.AddShardingHintDatabaseValueStatementTestCase;
-
-import static org.hamcrest.CoreMatchers.is;
-import static org.hamcrest.MatcherAssert.assertThat;
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-
-/**
- * Add sharding hint database value statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class AddShardingHintDatabaseValueStatementAssert {
-
- /**
- * Assert add sharding hint database value statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual add sharding hint database value statement
- * @param expected expected add sharding hint database value statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final AddShardingHintDatabaseValueStatement actual, final AddShardingHintDatabaseValueStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- assertThat(actual.getLogicTableName(), is(expected.getLogicTableName()));
- assertThat(actual.getShardingValue(), is(expected.getShardingValue()));
- }
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/AddShardingHintTableValueStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/AddShardingHintTableValueStatementAssert.java
deleted file mode 100644
index ce39e3f51d5..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/AddShardingHintTableValueStatementAssert.java
+++ /dev/null
@@ -1,53 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.AddShardingHintTableValueStatement;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.AddShardingHintTableValueStatementTestCase;
-
-import static org.hamcrest.CoreMatchers.is;
-import static org.hamcrest.MatcherAssert.assertThat;
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-
-/**
- * Add sharding hint table value statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class AddShardingHintTableValueStatementAssert {
-
- /**
- * Assert add sharding hint table value statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual add sharding hint table value statement
- * @param expected expected add sharding hint table value statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final AddShardingHintTableValueStatement actual, final AddShardingHintTableValueStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- assertThat(actual.getLogicTableName(), is(expected.getLogicTableName()));
- assertThat(actual.getShardingValue(), is(expected.getShardingValue()));
- }
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ClearHintStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ClearHintStatementAssert.java
deleted file mode 100644
index 24f0407cc51..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ClearHintStatementAssert.java
+++ /dev/null
@@ -1,49 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.hint.ClearHintStatement;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ClearHintStatementTestCase;
-
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-
-/**
- * Clear hint statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class ClearHintStatementAssert {
-
- /**
- * Assert clear hint statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual clear hint statement
- * @param expected expected clear hint statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final ClearHintStatement actual, final ClearHintStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- }
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ClearReadwriteSplittingHintStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ClearReadwriteSplittingHintStatementAssert.java
deleted file mode 100644
index 346599cb005..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ClearReadwriteSplittingHintStatementAssert.java
+++ /dev/null
@@ -1,49 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ClearReadwriteSplittingHintStatement;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ClearReadwriteSplittingHintStatementTestCase;
-
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-
-/**
- * Clear readwrite-splitting hint statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class ClearReadwriteSplittingHintStatementAssert {
-
- /**
- * Assert clear readwrite-splitting hint statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual clear readwrite-splitting hint statement
- * @param expected expected clear readwrite-splitting hint statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final ClearReadwriteSplittingHintStatement actual, final ClearReadwriteSplittingHintStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- }
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ClearShardingHintStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ClearShardingHintStatementAssert.java
deleted file mode 100644
index 11868169102..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ClearShardingHintStatementAssert.java
+++ /dev/null
@@ -1,49 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ClearShardingHintStatement;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ClearShardingHintStatementTestCase;
-
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-
-/**
- * Clear sharding hint statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class ClearShardingHintStatementAssert {
-
- /**
- * Assert clear sharding hint statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual clear sharding hint statement
- * @param expected expected clear sharding hint statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final ClearShardingHintStatement actual, final ClearShardingHintStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- }
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/SetReadwriteSplittingHintStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/SetReadwriteSplittingHintStatementAssert.java
deleted file mode 100644
index 939e21c8d61..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/SetReadwriteSplittingHintStatementAssert.java
+++ /dev/null
@@ -1,52 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.SetReadwriteSplittingHintStatement;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.SetReadwriteSplittingHintStatementTestCase;
-
-import static org.hamcrest.CoreMatchers.is;
-import static org.hamcrest.MatcherAssert.assertThat;
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-
-/**
- * Set readwrite-splitting hint statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class SetReadwriteSplittingHintStatementAssert {
-
- /**
- * Assert set readwrite-splitting hint statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual set readwrite-splitting hint statement
- * @param expected expected set readwrite-splitting hint statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final SetReadwriteSplittingHintStatement actual, final SetReadwriteSplittingHintStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- assertThat(actual.getSource(), is(expected.getSource()));
- }
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/SetShardingHintDatabaseValueStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/SetShardingHintDatabaseValueStatementAssert.java
deleted file mode 100644
index aad4116d14b..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/SetShardingHintDatabaseValueStatementAssert.java
+++ /dev/null
@@ -1,52 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.SetShardingHintDatabaseValueStatement;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.SetShardingHintDatabaseValueStatementTestCase;
-
-import static org.hamcrest.CoreMatchers.is;
-import static org.hamcrest.MatcherAssert.assertThat;
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-
-/**
- * Set sharding hint database value statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class SetShardingHintDatabaseValueStatementAssert {
-
- /**
- * Assert set sharding hint database value statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual set sharding hint database value statement
- * @param expected expected set sharding hint database value statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final SetShardingHintDatabaseValueStatement actual, final SetShardingHintDatabaseValueStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- assertThat(actual.getShardingValue(), is(expected.getShardingValue()));
- }
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ShowReadwriteSplittingHintStatusStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ShowReadwriteSplittingHintStatusStatementAssert.java
deleted file mode 100644
index 87023cfdc88..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ShowReadwriteSplittingHintStatusStatementAssert.java
+++ /dev/null
@@ -1,49 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.readwritesplitting.distsql.parser.statement.hint.ShowReadwriteSplittingHintStatusStatement;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ShowReadwriteSplittingHintStatusStatementTestCase;
-
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-
-/**
- * Show readwrite-splitting hint status statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class ShowReadwriteSplittingHintStatusStatementAssert {
-
- /**
- * Assert show readwrite-splitting hint status statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual show readwrite-splitting hint status statement
- * @param expected expected show readwrite-splitting hint status statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final ShowReadwriteSplittingHintStatusStatement actual, final ShowReadwriteSplittingHintStatusStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- }
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ShowShardingHintStatusStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ShowShardingHintStatusStatementAssert.java
deleted file mode 100644
index 7f8e74b3f35..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/hint/ShowShardingHintStatusStatementAssert.java
+++ /dev/null
@@ -1,49 +0,0 @@
-/*
- * 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.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.hint;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.sharding.distsql.parser.statement.hint.ShowShardingHintStatusStatement;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ShowShardingHintStatusStatementTestCase;
-
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-
-/**
- * Show sharding hint status statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class ShowShardingHintStatusStatementAssert {
-
- /**
- * Assert show sharding hint status statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual show sharding hint status statement
- * @param expected expected show sharding hint status statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final ShowShardingHintStatusStatement actual, final ShowShardingHintStatusStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- }
- }
-}
diff --git a/test/it/parser/src/main/resources/case/ral/hint.xml b/test/it/parser/src/main/resources/case/ral/hint.xml
deleted file mode 100644
index b89dddecc3e..00000000000
--- a/test/it/parser/src/main/resources/case/ral/hint.xml
+++ /dev/null
@@ -1,31 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
- ~ 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.
- -->
-
-<sql-parser-test-cases>
- <show-sharding-hint-status sql-case-id="show-sharding-hint-status" />
- <add-sharding-hint-database-value sql-case-id="add-sharding-hint-database-value" logic-table-name="T_ORDER" sharding-value="1" />
- <add-sharding-hint-table-value sql-case-id="add-sharding-hint-table-value" logic-table-name="T_ORDER" sharding-value="1" />
- <set-sharding-hint-database-value sql-case-id="set-sharding-hint-database-value" sharding-value="1" />
- <clear-sharding-hint sql-case-id="clear-sharding-hint" />
-
- <show-readwrite-splitting-hint-source sql-case-id="show-readwrite-splitting-hint-source" />
- <set-readwrite-splitting-hint-source sql-case-id="set-readwrite-splitting-hint-source" source-name="WRITE" />
- <clear-readwrite-splitting-hint-source sql-case-id="clear-readwrite-splitting-hint-source" />
-
- <clear-hint sql-case-id="clear-hint" />
-</sql-parser-test-cases>
diff --git a/test/it/parser/src/main/resources/sql/supported/ral/hint.xml b/test/it/parser/src/main/resources/sql/supported/ral/hint.xml
deleted file mode 100644
index 1400f8d94cb..00000000000
--- a/test/it/parser/src/main/resources/sql/supported/ral/hint.xml
+++ /dev/null
@@ -1,31 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!--
- ~ 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.
- -->
-
-<sql-cases>
- <sql-case id="show-sharding-hint-status" value="SHOW SHARDING HINT STATUS" db-types="ShardingSphere" />
- <sql-case id="add-sharding-hint-database-value" value="ADD SHARDING HINT DATABASE_VALUE T_ORDER=1" db-types="ShardingSphere" />
- <sql-case id="add-sharding-hint-table-value" value="ADD SHARDING HINT TABLE_VALUE T_ORDER=1" db-types="ShardingSphere" />
- <sql-case id="set-sharding-hint-database-value" value="SET SHARDING HINT DATABASE_VALUE=1" db-types="ShardingSphere" />
- <sql-case id="clear-sharding-hint" value="CLEAR SHARDING HINT" db-types="ShardingSphere" />
-
- <sql-case id="show-readwrite-splitting-hint-source" value="SHOW READWRITE_SPLITTING HINT STATUS" db-types="ShardingSphere" />
- <sql-case id="set-readwrite-splitting-hint-source" value="SET READWRITE_SPLITTING HINT SOURCE=WRITE" db-types="ShardingSphere" />
- <sql-case id="clear-readwrite-splitting-hint-source" value="CLEAR READWRITE_SPLITTING HINT" db-types="ShardingSphere" />
-
- <sql-case id="clear-hint" value="CLEAR HINT" db-types="ShardingSphere" />
-</sql-cases>