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 2021/09/02 09:04:38 UTC
[GitHub] [shardingsphere] number68 opened a new issue #12176: Can shardingsphere 5.0 beta version support joining tables from different dbs
number68 opened a new issue #12176:
URL: https://github.com/apache/shardingsphere/issues/12176
## Question
Can shardingsphere 5.0.0 beta version support joining tables per from different db?
I found an exciting new feature in shardingsphere 5.0.0 beta version release note , details in below pic:
But i can't follow what it exactly means.
Can shardingsphere 5.0.0 beta version support joining tables per from different db?
For example, a from db1，b from db2，maybe a,b have sharding rules(not important here).
select a.name, b.name
from a,b
where a.bid = b.id
and a.name like "%xxx%";
--
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] sandynz closed issue #12176: Can shardingsphere 5.0 beta version support joining tables from different dbs
Posted by GitBox <gi...@apache.org>.
sandynz closed issue #12176:
URL: https://github.com/apache/shardingsphere/issues/12176
--
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] strongduanmu commented on issue #12176: Can shardingsphere 5.0 beta version support joining tables from different dbs
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12176:
URL: https://github.com/apache/shardingsphere/issues/12176#issuecomment-911430540
@number68 Yes, the beta version has begun to support cross-database query, this is a new feature, there may be some problems, but you can try 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] number68 commented on issue #12176: Can shardingsphere 5.0 beta version support joining tables from different dbs
Posted by GitBox <gi...@apache.org>.
number68 commented on issue #12176:
URL: https://github.com/apache/shardingsphere/issues/12176#issuecomment-912385774
> @number68 You can find the entrance through `FederateExecutor` and realize cross-database query with the help of Calcite. At present, the feature is still being optimized. Welcome to participate.
ok thx a lot!
what config needs to be done for using this awesome feature? @strongduanmu
--
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] number68 commented on issue #12176: Can shardingsphere 5.0 beta version support joining tables from different dbs
Posted by GitBox <gi...@apache.org>.
number68 commented on issue #12176:
URL: https://github.com/apache/shardingsphere/issues/12176#issuecomment-911441178
> @number68 Yes, the beta version has begun to support cross-database query, this is a new feature, there may be some problems, but you can try it.
@strongduanmu thanks for reply, it's a great feature.
How to deal with huge pre filting results , i.e. a filtered millon records and cross join b's filtered result and sort , do you used streaming process tool(like mpp spark)?
What the join code classes are?
thanks a lot!
--
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] strongduanmu commented on issue #12176: Can shardingsphere 5.0 beta version support joining tables from different dbs
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12176:
URL: https://github.com/apache/shardingsphere/issues/12176#issuecomment-912177422
@number68 You can find the entrance through `FederateExecutor` and realize cross-database query with the help of Calcite. At present, the feature is still being optimized. Welcome to participate.
--
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] kimmking commented on issue #12176: Can shardingsphere 5.0 beta version support joining tables from different dbs
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #12176:
URL: https://github.com/apache/shardingsphere/issues/12176#issuecomment-914970055
It's a big issue. I will try it and feedback later in another thread.
--
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