You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "ThisOnly (via GitHub)" <gi...@apache.org> on 2023/06/08 02:35:44 UTC
[GitHub] [shardingsphere] ThisOnly opened a new issue, #26111: Sharding does not support configuring ActualDataNodes to ${01.. 02}. If I want to split the table by month, regardless of year, how should I configure it
ThisOnly opened a new issue, #26111:
URL: https://github.com/apache/shardingsphere/issues/26111
## Bug Report
Configure the table according to the following diagram, but it cannot be successful. Why is it
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
5.1.2
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
The above configuration can be executed correctly
### Actual behavior
error
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] linghengqian commented on issue #26111: Sharding does not support configuring ActualDataNodes to ${01.. 02}. If I want to split the table by month, regardless of year, how should I configure it
Posted by "linghengqian (via GitHub)" <gi...@apache.org>.
linghengqian commented on issue #26111:
URL: https://github.com/apache/shardingsphere/issues/26111#issuecomment-1705362133
- In fact you can use Groovy Shell to verify, I think you want to use `0${1.. 2}` instead of `${01.. 02}`.
- For the second question, there is actually no need to consider Groovy syntax. You can directly dynamically modify the `actualDataNodes` through `DistSQL`, or take out the `ContextManager` and modify it manually.
- I think you can wait for #22899 to be closed, I have a batch of unmerged PRs working on this issue. Once #22899 is closed, the configuration of this expression can be customized via SPI.
--
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] linghengqian commented on issue #26111: Sharding does not support configuring ActualDataNodes to ${01.. 02}. If I want to split the table by month, regardless of year, how should I configure it
Posted by "linghengqian (via GitHub)" <gi...@apache.org>.
linghengqian commented on issue #26111:
URL: https://github.com/apache/shardingsphere/issues/26111#issuecomment-1738305367
- The new SPI was introduced in the related PR at https://github.com/apache/shardingsphere/issues/22899 , this issue can now define `List<String>` via an new Row Value Expression SPI implementation.
--
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
Re: [I] Sharding does not support configuring ActualDataNodes to ${01.. 02}. If I want to split the table by month, regardless of year, how should I configure it [shardingsphere]
Posted by "KeZhimin (via GitHub)" <gi...@apache.org>.
KeZhimin commented on issue #26111:
URL: https://github.com/apache/shardingsphere/issues/26111#issuecomment-1767930845
ds_0.t_user_$->{2023..2050}$->{(1..12).collect{t ->t.toString().padLeft(2,'0')}}
--
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] linghengqian closed issue #26111: Sharding does not support configuring ActualDataNodes to ${01.. 02}. If I want to split the table by month, regardless of year, how should I configure it
Posted by "linghengqian (via GitHub)" <gi...@apache.org>.
linghengqian closed issue #26111: Sharding does not support configuring ActualDataNodes to ${01.. 02}. If I want to split the table by month, regardless of year, how should I configure it
URL: https://github.com/apache/shardingsphere/issues/26111
--
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