small amount of data and do not need to be sharded. Note: Single tables that meet the following conditions will be automatically loaded: ‐ A single table showing the configuration in rules such as encrypt executing DDL statements through ShardingSphere For other single tables that do not meet the above conditions, ShardingSphere will not automatically load them, and users can configure single table rules as routing For the scenario where the sharded field is not determined by SQL but by other external conditions, you can use SQL Hint to inject the shard value. Example: Conduct database sharding by employee

small amount of data and do not need to be sharded. Note: Single tables that meet the following conditions will be automatically loaded: ‐ A single table showing the configuration in rules such as encrypt executing DDL statements through ShardingSphere For other single tables that do not meet the above conditions, ShardingSphere will not automatically load them, and users can configure single table rules as routing For the scenario where the sharded field is not determined by SQL but by other external conditions, you can use SQL Hint to inject the shard value. Example: Conduct database sharding by employee

routing For the scenario where the sharded field is not determined by SQL but by other external conditions, you can use SQL Hint to inject the shard value. Example: Conduct database sharding by employee nodes; SQL routing to multiple data nodes is divided, because of complexity issues, into three conditions: stable support, experimental support, and no support. Stable Support Full support for DML, keyGenerators: snowflake: type: SNOWFLAKE auditors: sharding_key_required_auditor: type: DML_SHARDING_CONDITIONS props: sql-show: false Read the YAML configuration to create a data source according to the

sharding strategy of the primary table, so sharding computation of t_order_item table will use the conditions of t_order. Due to this, sharding keys in binding tables should be totally identical. 3.1. Sharding sharding. SQL Hint In the case that the ShardingColumn is not decided by SQL but other external conditions, SQL hint can be used flexibly to inject ShardingColumn. For example, in the internal system, and values to shard. If SQL does not have sharding conditions, it is impossible to shard without full route. In some applications, sharding conditions are not in SQL but in external business logic. So

sharding strategy of the primary table, so sharding computation of t_order_item table will use the conditions of t_order. Due to this, sharding keys in binding tables should be totally identical. Broadcast operation. SQL Hint In the case that the sharding column is not decide by SQL but other external conditions, SQL hint can be used to inject sharding value. For example, databases are shard according to values to shard. If SQL does not have sharding conditions, it is impossible to shard without full data node route. In some applications, sharding conditions are not in SQL but in external business logic

keyGenerators: snowflake: type: SNOWFLAKE auditors: sharding_key_required_auditor: type: DML_SHARDING_CONDITIONS - !BROADCAST tables: 9.1. ShardingSphere-JDBC 59 Apache ShardingSphere document - t_address result.getAuditors().put("sharding_key_required_auditor", new AlgorithmConfiguration("DML_SHARDING_CONDITIONS", new Properties())); return result; } private ShardingTableRuleConfiguration getOrderTableRuleConfiguration() 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

keyGenerators: snowflake: type: SNOWFLAKE auditors: sharding_key_required_auditor: type: DML_SHARDING_CONDITIONS - !BROADCAST tables: 9.1. ShardingSphere-JDBC 59 Apache ShardingSphere document - t_address result.getAuditors().put("sharding_key_required_auditor", new AlgorithmConfiguration("DML_SHARDING_CONDITIONS", new Properties())); return result; } private ShardingTableRuleConfiguration getOrderTableRuleConfiguration() 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

order_id=i.order_id WHERE o. order_id in (10, 11); In them, since table t_order specifies sharding conditions，it will be taken by ShardingSphere as the primary table of query. All the route computations will sharding strategy of the primary table, so sharding computation of t_order_item table will use the conditions of t_order. 4.3. Sharding 28 Apache ShardingSphere document, v5.1.1 Broadcast Table It refers operation. SQL Hint In the case that the sharding column is not decide by SQL but other external conditions, SQL hint can be used to inject sharding value. For example, databases are shard according to

keyGenerators: snowflake: type: SNOWFLAKE auditors: sharding_key_required_auditor: type: DML_SHARDING_CONDITIONS - !BROADCAST tables: 9.1. ShardingSphere-JDBC 60 Apache ShardingSphere document - t_address result.getAuditors().put("sharding_key_required_auditor", new AlgorithmConfiguration("DML_SHARDING_CONDITIONS", new Properties())); return result; } private ShardingTableRuleConfiguration getOrderTableRuleConfiguration() 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

Sharding 28 Apache ShardingSphere document, v5.1.2 In them, since table t_order specifies sharding conditions, it will be taken by ShardingSphere as the primary table of query. All the route computations sharding strategy of the primary table, so sharding computation of t_order_item table will use the conditions of t_order. Broadcast Table It refers to tables that exist in all sharding database sources. operation. SQL Hint In the case that the sharding column is not decide by SQL but other external conditions, SQL hint can be used to inject sharding value. For example, databases are shard according to