Raigor
Raigor
Closed due to no response. If this problem persists, please reopen it or submit a new one.
As @FlyingZC said, this issue has been inactive for a long time, and ShardingSphere has released several new versions, so I will close it. Please try the latest version, and...
@prefect1005 So did you configured database `db2` and create (or load) table2 in it?
> @RaigorJiang Of course . in other word, if one project need to select db1 and db2 database, just db1.table1 need sharding config，so how to config that we can execute...
@prefect1005 OK, so you just want to access tables in multiple data sources, not multiple logic data bases. let's do two things: 1. Configure single rule `*.*`; ([link](https://shardingsphere.apache.org/document/5.4.1/en/user-manual/shardingsphere-jdbc/yaml-config/rules/single/)) 2. Use...
Please enable `sql-show` ([refer to props](https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sharding/)) and provide the Logic SQL and Actual SQL in the log.
@zhoubin7 This is really great news, thanks for your feedback. Perhaps the subquery in the sharding scenario needs to enable federated query, you can try to configure [sql-federation-type](https://shardingsphere.apache.org/document/current/en/user-manual/common-config/props/).
Hi @agoodcoolman , Thanks for your feedback, are you intrested in improving it?
@agoodcoolman OK, I'll mark this issue as volunteer wanted, thank you~
@hhw3KevinHou Hi, are you test with standalone mode?