[GitHub] [incubator-shardingsphere] jeffmxzhao edited a comment on issue #2791: How to config round robin routing of broadcast tables?

[GitBox <gi...@apache.org>]

jeffmxzhao edited a comment on issue #2791: How to config round robin routing of broadcast tables?
URL: https://github.com/apache/incubator-shardingsphere/issues/2791#issuecomment-518534212
 
 
   Yes, broadcast table is used to join with sharding tables, but it is also used to without join.
   `SELECT o.id,d.value FROM order o LEFT JOIN dict d ON o.type=d.value WHERE o.id=?`, If the `order` data is on `Host A`, the query will send to `Host A`, or the data is on `Host B`, send to `Host B`, That is okay.
   `SELECT * FROM dict WHERE id = ?`, This is always send to Host A, The loading is always in the Host A. @terrymanu 

----------------------------------------------------------------
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


With regards,
Apache Git Services