edenpan opened a new issue, #18406:
URL: https://github.com/apache/shardingsphere/issues/18406
## Question
**For English only**, other languages will not accept.
The Version: V 5.1.0
The Oracle select SQL by the date needs to use the to_char or to_date, for
example, my query SQL as below:
`
SELECT
* FROM tradeList WHERE 1 = 1
AND TRADE_DATE = to_date( '20210601', 'yyyymmdd' )
`
It seems that the query not sharding via the sharding key: TRADE_DATE .
So, if there are any suggestions for oracle query via date field.
Below is my shardingsphere setting:
`
spring.shardingsphere.rules.sharding.tables.TRADELIST.actual-data-nodes=db0.TRADELIST_$->{2021..2021}$->{6..12}
spring.shardingsphere.rules.sharding.defaultShardingColumn = TRADE_DATE
spring.shardingsphere.rules.sharding.default-table-strategy.standard.sharding-column=TRADE_DATE
spring.shardingsphere.rules.sharding.default-table-strategy.standard.sharding-algorithm-name=shardingalgorithmbymonth2
spring.shardingsphere.rules.sharding.tables.TRADELIST.table-strategy.standard.sharding-column=TRADE_DATE
spring.shardingsphere.rules.sharding.tables.TRADELIST.table-strategy.standard.sharding-algorithm-name=shardingalgorithmbymonth2
spring.shardingsphere.rules.sharding.sharding-algorithms.shardingalgorithmbymonth2.type=INTERVAL
spring.shardingsphere.rules.sharding.sharding-algorithms.shardingalgorithmbymonth2.props.datetime-pattern=yyyy-MM-dd
HH:mm:ss.SSS
spring.shardingsphere.rules.sharding.sharding-algorithms.shardingalgorithmbymonth2.props.datetime-lower=2021-06-01
00:00:00.000
spring.shardingsphere.rules.sharding.sharding-algorithms.shardingalgorithmbymonth2.props.datetime-upper=2021-12-31
00:00:00.000
spring.shardingsphere.rules.sharding.sharding-algorithms.shardingalgorithmbymonth2.props.sharding-suffix-pattern=yyyyM
spring.shardingsphere.rules.sharding.sharding-algorithms.shardingalgorithmbymonth2.props.datetime-interval-amount=1
spring.shardingsphere.rules.sharding.sharding-algorithms.shardingalgorithmbymonth2.props.datetime-interval-unit=months
spring.shardingsphere.rules.sharding.key-generators.snowflake.type=SNOWFLAKE
`
--
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]
