You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "young138120 (via GitHub)" <gi...@apache.org> on 2023/04/20 12:53:14 UTC
[GitHub] [shardingsphere] young138120 opened a new issue, #25251: single table can not join with sharding table
young138120 opened a new issue, #25251:
URL: https://github.com/apache/shardingsphere/issues/25251
version: 5.3.2
backgroud:
i have big many tables with more than 100 million rows in database_a,i want split those tables by year ,and move it to anther databases like database_2020,databse_2021,database_2022。
i use shardingsphere proxy server to sharding select , i don't execute any insert or update dml
now ,i set database_a datasource to single table datasource , you know many of other table in databse_a exclude big table.
i run join sql with singe table and sharding table , proxy server will scan all of sharding table like this:
![image](https://user-images.githubusercontent.com/11519151/233370994-6e13a091-b438-4b77-a03f-122cc8303ae8.png)
i get some advice from sphereEx , i need to change single table to broadcast table ,because of single table can not join with sharding table。
so how can i design it ?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuichenchuxin commented on issue #25251: single table can not join with sharding table
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #25251:
URL: https://github.com/apache/shardingsphere/issues/25251#issuecomment-1517507843
Sharding table can't join with single table with different database. If your single table data is not big enough, you can try to change it to broadcast table.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] young138120 commented on issue #25251: single table can not join with sharding table
Posted by "young138120 (via GitHub)" <gi...@apache.org>.
young138120 commented on issue #25251:
URL: https://github.com/apache/shardingsphere/issues/25251#issuecomment-1518925754
> use experimental features federation
i already tried it ,not work for me
you can find configuration here https://github.com/apache/shardingsphere/issues/25260#issuecomment-1518925033
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] young138120 commented on issue #25251: single table can not join with sharding table
Posted by "young138120 (via GitHub)" <gi...@apache.org>.
young138120 commented on issue #25251:
URL: https://github.com/apache/shardingsphere/issues/25251#issuecomment-1517515730
> Sharding table can't join with single table with different database. If your single table data is not big enough, you can try to change it to broadcast table.
i know that now
it is question if i change singe table to broadcast table ,i need to maintenance all of broadcase table on all sharding database
it is so sad
is there other way to resolve it ?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuichenchuxin commented on issue #25251: single table can not join with sharding table
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #25251:
URL: https://github.com/apache/shardingsphere/issues/25251#issuecomment-1518925165
use experimental features federation
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org