You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/04/08 03:29:42 UTC
[GitHub] [shardingsphere] as882301 edited a comment on issue #9986: 2Unknown exception: [Can not route tables for `[role_relation, ssmember]`, please make sure the tables are in same schema.]
as882301 edited a comment on issue #9986:
URL: https://github.com/apache/shardingsphere/issues/9986#issuecomment-815418867
> 您好@ as882301 @ wangjing112
> 您能否提供分片配置以及逻辑SQL和实际SQL?
schemaName: sharding_db
#
dataSourceCommon:
# username: root
# password:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
maintenanceIntervalMilliseconds: 30000
#
dataSources:
ds_1:
url: jdbc:mysql://127.0.0.1:3306/shop?serverTimezone=UTC&useSSL=false
username: shop
password: Zjw228478
ds_2:
url: jdbc:mysql://127.0.0.1:3306/hotel?serverTimezone=UTC&useSSL=false
username: hotel
password: 228478
#
rules:
- !SHARDING
tables:
test:
actualDataNodes: ds_${1}.test${1}
tableStrategy:
standard:
shardingColumn: id
shardingAlgorithmName: test_inline
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
SQL
SELECT M.role,M.member_id,M.member_name,M.member_avatar,M.member_mobile FROM role_relation R LEFT JOIN ssmember M ON M.member_id=R.member_id WHERE ( R.bind_id=7 );
ssmember table in shop database
role_relation table in hotel database
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org