childewuque opened a new issue #10597:
URL: https://github.com/apache/shardingsphere/issues/10597
shardingsphere 5.0.0-RC1 (master)
There are two tables in a sql, but only one is sharding (hint sharding).
Only sharding of that table is configured, but hint sharding is not executed.
1st sql: select a.name from a,b where a.id= b.id and b.buyid=20 and
b.sellerid=100
table a is sharding，table b is a single table
yaml config:
...
tables:
td_coupon_buyer:
actual-data-nodes: db.a$->{0..255}
tableStrategy:
hint:
shardingAlgorithmName: table-class-based-hint
sharding-algorithms:
table-class-based-hint:
type: CLASS_BASED
props:
strategy: hint
algorithmClassName: com.a.TableHintAlgorithm
But it can run in hint sharding code when using the below sql:
2nd sql:select a.name from a order by id limit 10
Then I debug code ：
1st sql ,it will come in ShardingFederatedRoutingEngine
2nd sql ,it will come in ShardingStandardRoutingEngine
ShardingFederatedRoutingEngine does not contain hint invoking.But
ShardingStandardRoutingEngine has hint invoking
So, is my config error? Thanks
--
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:
[email protected]
