Jun10ng commented on issue #16534:
URL:
https://github.com/apache/shardingsphere/issues/16534#issuecomment-1085519606
> Hi @Jun10ng
>
> 1. You could specify the sharding column by :
>
> ```
>
spring.shardingsphere.rules.sharding.tables.gs_job_log.table-strategy.standard.sharding-column=job_group
> ```
>
> 2. For your `actual-data-nodes`, do you want
`db.job_log_0000000$->{0..9}, db.job_log_000000$->{10..99},
db.job_log_00000100`?
Thanks for your reply, but my actually route field is `job_group%100`. Could
I write as the follow？
>
spring.shardingsphere.rules.sharding.tables.gs_job_log.table-strategy.standard.sharding-column=job_group%100
感谢你的回复。 实际上我的字段是 job_group的后三位，也就是 `job_group%100`。
所以我可以这样写吗？
>
spring.shardingsphere.rules.sharding.tables.gs_job_log.table-strategy.standard.sharding-column=job_group%100
--
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]
