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 2020/09/16 06:47:20 UTC
[GitHub] [shardingsphere] z3sm opened a new issue #7477: Case:broadcast tables join a not broadcast tables.How to configure？
z3sm opened a new issue #7477:
URL: https://github.com/apache/shardingsphere/issues/7477
I have a query sql like this:
`select * from table_a a left join table_b b on a.id=b.a_id where a.id = 'XX';
`
table_a:configure it by broadcast tables
table_b:not configure it by broadcast tables.
occured an error:
`com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ds.table_b' doesn't exist。
`
How to configure table_b's datasource on this case?
I hope this query from default datasource.
Looking forward to your reply
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:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero edited a comment on issue #7477: Broadcast tables join a not broadcast one, how to route to default datasource?
Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #7477:
URL: https://github.com/apache/shardingsphere/issues/7477#issuecomment-693774672
Hi @z3sm
Where is `table_b`?
Do you want to shard it? If not, how about putting it in default ds?
----------------------------------------------------------------
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
[GitHub] [shardingsphere] kimmking commented on issue #7477: Case:broadcast tables join a not broadcast tables.How to configure？
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #7477:
URL: https://github.com/apache/shardingsphere/issues/7477#issuecomment-693226218
what's your config rules?
----------------------------------------------------------------
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
[GitHub] [shardingsphere] kimmking commented on issue #7477: Case:broadcast tables join a not broadcast tables.How to configure？
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #7477:
URL: https://github.com/apache/shardingsphere/issues/7477#issuecomment-693267622
In your case, hint strategy or raw jdbc datasource maybe a better way.
Sharding rule can't support this case.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] z3sm edited a comment on issue #7477: Case:broadcast tables join a not broadcast tables.How to configure？
Posted by GitBox <gi...@apache.org>.
z3sm edited a comment on issue #7477:
URL: https://github.com/apache/shardingsphere/issues/7477#issuecomment-693233645
> what's your config rules?
spring.shardingsphere.sharding.default-data-source-name=ds
spring.shardingsphere.sharding.broadcast-tables= table_a
spring.shardingsphere.sharding.tables.table_a.actual-data-nodes=ds.table_a
"ds" is the default datasource
----------------------------------------------------------------
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
[GitHub] [shardingsphere] kimmking closed issue #7477: Broadcast tables join a not broadcast one, how to route to default datasource?
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #7477:
URL: https://github.com/apache/shardingsphere/issues/7477
----------------------------------------------------------------
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
[GitHub] [shardingsphere] z3sm commented on issue #7477: Case:broadcast tables join a not broadcast tables.How to configure？
Posted by GitBox <gi...@apache.org>.
z3sm commented on issue #7477:
URL: https://github.com/apache/shardingsphere/issues/7477#issuecomment-693233645
> what's your config rules?
spring.shardingsphere.sharding.broadcast-tables= table_a
spring.shardingsphere.sharding.tables.table_a.actual-data-nodes=ds.table_a
"ds" is the default datasource
----------------------------------------------------------------
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
[GitHub] [shardingsphere] kimmking closed issue #7477: Broadcast tables join a not broadcast one, how to route to default datasource?
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #7477:
URL: https://github.com/apache/shardingsphere/issues/7477
----------------------------------------------------------------
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
[GitHub] [shardingsphere] tristaZero commented on issue #7477: Broadcast tables join a not broadcast one, how to route to default datasource?
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #7477:
URL: https://github.com/apache/shardingsphere/issues/7477#issuecomment-693774672
Where is `table_b`?
Do you want to shard it? If not, how about putting it in default ds?
----------------------------------------------------------------
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