joey168 opened a new issue #2110: how to use shardingsphere multiple databases 
store different tables sharding?
URL: https://github.com/apache/incubator-shardingsphere/issues/2110
 
 
   I use shardingsphere to split a large table into multiple database stores
   And store the data in different tables in each database according to the 
time. 
   like. 
   ds-0.{table1,table2},   table1 store 2018-01 data table store 2018-02 data
   ds-1.{table3,table4},   table3 store 2018-03 data table store 2018-04 data
   ds-2.{table5,table6}   ...............
   ds-.....
   use rangeAlgorithm for create_date filed to sharding
   when query conditions span multiple databases throws exection 
SQLSyntaxErrorException: Table table3 doesn't exist
   like. create_date between '2018-01-01' and '2018-04-31'
   
   how to store different sharding tables in multiple databases?
   
   shardingsphere version: 3.0.0.M3

----------------------------------------------------------------
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:
[email protected]


With regards,
Apache Git Services

Reply via email to