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/11/04 07:47:22 UTC

[GitHub] [shardingsphere] XiaoleLee opened a new issue #8025: Can Sharding Proxy support cross databases join between sharding table and no sharding table?

XiaoleLee opened a new issue #8025:
URL: https://github.com/apache/shardingsphere/issues/8025


   For example:
   I have 3 databases :  `db1`, `db2`,  `db3` and 2 tables : `tb1`, `tb2`.
   `tb1` is sharding table in `db1`, `db2` and `db3`.
   `tb2` is no sharding table only in `db1`.
   
   The config is almost like this : 
   
   ```
   schemaName: db_test
   
   .
   .
   .
   
   shardingRule:
     tables:
       tb1:
         actualDataNodes: ds${1..3}.tb1
         databaseStrategy:
           standard:
             shardingColumn: xxx
             preciseAlgorithmClassName: xxx
             rangeAlgorithmClassName: xxx
         keyGenerator:
           type: UUID
           column: id
     defaultDataSourceName: ds1
     defaultDatabaseStrategy:
       none:
     defaultTableStrategy:
       none:
   ```
   
   Then I will get a logical logic database `db_test` and 2 logic tables `tb1` , `tb2`.
   Can  `tb1`  join with `tb2` ?
   
   I have tried on Sharding Proxy 4.1.0. The log file print like  'db2.tb2 doesn`t exist'.
   It seems that, sharding try to use `db2.tb2` to join with `db2.tb1`.
   
   Can sharding use `db1.tb2` join with `db1.tb1` , `db2.tb1`, `db3.tb1` ?
   And that, I may have many table used like `tb2` , so `broadcastTable`  is not suitable in this case.
   
   Looking forward to someone answering meļ¼Œ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] kimmking commented on issue #8025: Can Sharding Proxy support cross databases join between sharding table and no sharding table?

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #8025:
URL: https://github.com/apache/shardingsphere/issues/8025#issuecomment-721583183


   Doesn't support yet.
   IMO, almost database middleware can't.
   Some integration tools like Teiid can do 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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] kimmking closed issue #8025: Can Sharding Proxy support cross databases join between sharding table and no sharding table?

Posted by GitBox <gi...@apache.org>.
kimmking closed issue #8025:
URL: https://github.com/apache/shardingsphere/issues/8025


   


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