Vain-vayne opened a new issue, #32914:
URL: https://github.com/apache/shardingsphere/issues/32914

   # Can ShardingSphere-Proxy be sharded by month?
   
   - Version number: 5.5.0
   - How to handle monthly database sharding? For example, 202301 and 202401 
are both in the ds_01.test database. How to configure? The following 
configuration shows an error after inserting data: 
`org.apache.shardingsphere.sharding.exception.algorithm.NoShardingDatabaseRouteInfoException:
 No sharding database route info.`
   
   ```
   shardingAlgorithms:
   shardingalgorithms_interval:
   type: INTERVAL
   props:
   datetime-pattern: "yyyyMM"
   datetime-lower: "202401"
   sharding-suffix-pattern: "MM"
   datetime-interval-amount: 1
   datetime-interval-unit: "MONTHS"
   ```


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

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to