[GitHub] [shardingsphere] chana71 edited a comment on issue #6967: about "not support sql contains schema"

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

chana71 edited a comment on issue #6967:
URL: https://github.com/apache/shardingsphere/issues/6967#issuecomment-680770613


   I have config those two data sources. 
   Sorry, I can't get your idea clearly. I'll just introduce my situation to see if you can help. Thx.
   We create one database for each customer, e.g. cust1, cust2. 
   `show databases` will see these two dbs.
   ```
   cust1
   cust2
   ```
   We used to have SQL like this: `select * from cust1.table`(use cust2's jdbc data source)。We have requirements of querying **across two schemas 's(cust1, cust2) data**. 
   > So, the right way is config that 2 data sources as sharding DB  
   
   As I say, I have created two logic schema.
   1. config-cust1.yml  2. config-cust2.yml. 
   
   Finally, we met the problem-_db1.table not exists_, when executing the above SQL.
   
   


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