peilinqian commented on issue #18567:
URL:
https://github.com/apache/shardingsphere/issues/18567#issuecomment-1236066352
config：
rules:
- !SHARDING
tables:
t_single:
actualDataNodes: ds1_0.t_single
t_ssdb_tb:
actualDataNodes: ds1_${0..1}.t_ssdb_tb_${0..1}
databaseStrategy:
standard:
shardingAlgorithmName: ds1_database_inline
shardingColumn: id
tableStrategy:
standard:
shardingColumn: c_id
shardingAlgorithmName: ts_t_ssdb_tb_inline
t_ssdb_tb_view:
actualDataNodes: ds1_${0..1}.t_ssdb_tb_view_${0..1}
databaseStrategy:
standard:
shardingAlgorithmName: ds1_database_inline
shardingColumn: id
tableStrategy:
standard:
shardingColumn: c_id
shardingAlgorithmName: ts_t_ssdb_tb_view_inline
t_ssdb:
actualDataNodes: ds1_${0..1}.t_ssdb
databaseStrategy:
standard:
shardingAlgorithmName: ds1_database_inline
shardingColumn: id
t_ssdb_view:
actualDataNodes: ds1_${0..1}.t_ssdb_view
databaseStrategy:
standard:
shardingAlgorithmName: ds1_database_inline
shardingColumn: id
t_ssdb_tb1:
actualDataNodes: ds1_${0..1}.t_ssdb_tb1_${0..1}
databaseStrategy:
standard:
shardingAlgorithmName: ds1_database_inline
shardingColumn: id
tableStrategy:
standard:
shardingColumn: c_id
shardingAlgorithmName: ts_t_ssdb_tb1_inline
broadcastTables:
- t_broadcast
- t_broadcast_view
# bindingTables:
# - t_ssdb_tb, t_ssdb_tb1
# - t_ssdb_tb, t_ssdb_tb_view
defaultTableStrategy:
none:
defaultDatabaseStrategy:
none:
shardingAlgorithms:
ds1_database_inline:
type: INLINE
props:
algorithm-expression: ds1_${id % 2}
allow-range-query-with-inline-sharding: true
ts_t_ssdb_tb_inline:
type: INLINE
props:
algorithm-expression: t_ssdb_tb_${c_id % 2}
allow-range-query-with-inline-sharding: true
ts_t_ssdb_tb1_inline:
type: INLINE
props:
algorithm-expression: t_ssdb_tb1_${c_id % 2}
allow-range-query-with-inline-sharding: true
ts_t_ssdb_tb_view_inline:
type: INLINE
props:
algorithm-expression: t_ssdb_tb_view_${c_id % 2}
allow-range-query-with-inline-sharding: true
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
