lvqibin123 commented on issue #33635:
URL:
https://github.com/apache/shardingsphere/issues/33635#issuecomment-2472847459
how to use SHARDING ALGORITHM Type: INTERVAL two database?
```
app_user:
actualDataNodes:
<INTERVAL>P=ds0.app_user_;SP=yyyyMM;DIA=1;DIU=Months;DL=202401;DU=202412
tableStrategy:
standard:
shardingColumn: updatetime
shardingAlgorithmName: app_user_table_inline
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
```
it work,but i have 2 database,I don't know how to configure it.
I have tried the following configurations, but none of them work:
```
<INTERVAL>P=ds0.app_user_;SP=yyyyMM;DIA=1;DIU=Months;DL=202401;DU=202412,<INTERVAL>P=ds1.app_user_;SP=yyyyMM;DIA=1;DIU=Months;DL=202401;DU=202412
```
```
<INTERVAL>P=ds${0..1}.app_user_;SP=yyyyMM;DIA=1;DIU=Months;DL=202401;DU=202412
```
Canonly be used for a single database?
--
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]