You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/10/21 03:35:29 UTC
[GitHub] [shardingsphere] winer77444 opened a new issue #13190: Range query problem of compound sharding algorithm
winer77444 opened a new issue #13190:
URL: https://github.com/apache/shardingsphere/issues/13190
The version dependency I use is
` <dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.0.0-RC1</version>
</dependency>`
There is no problem with adding the custom compound sharding algorithm, but the range query returns an error, and the debug shows that the custom compound sharding algorithm is not entered



--
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] winer77444 commented on issue #13190: Range query problem of compound sharding algorithm
Posted by GitBox <gi...@apache.org>.
winer77444 commented on issue #13190:
URL: https://github.com/apache/shardingsphere/issues/13190#issuecomment-948380494
If I switch to the latest version, I get an error building sqlsessionFactory,

--
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] winer77444 commented on issue #13190: Range query problem of compound sharding algorithm
Posted by GitBox <gi...@apache.org>.
winer77444 commented on issue #13190:
URL: https://github.com/apache/shardingsphere/issues/13190#issuecomment-949121044
Druid's scene launcher is not compatible with druid's scene launcher. Druid's scene launcher is compatible with druid's scene launcher

--
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] CreatureOX commented on issue #13190: Range query problem of compound sharding algorithm
Posted by GitBox <gi...@apache.org>.
CreatureOX commented on issue #13190:
URL: https://github.com/apache/shardingsphere/issues/13190#issuecomment-948712243
@winer77444 In my opion, range query is hard to determine which sharding table should be hit, so sql should be broadcasted to all sharding tables.
Below code block may be help.
``` java
// using complexKeysShardingValue.getColumnNameAndShardingValuesMap() do some logic
if (null != complexKeysShardingValue.getColumnNameAndRangeValuesMap()
&& !complexKeysShardingValue.getColumnNameAndRangeValuesMap().isEmpty()) {
// broadcast sql to all sharding tables
return collections;
}
```
--
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] winer77444 closed issue #13190: Range query problem of compound sharding algorithm
Posted by GitBox <gi...@apache.org>.
winer77444 closed issue #13190:
URL: https://github.com/apache/shardingsphere/issues/13190
--
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] winer77444 commented on issue #13190: Range query problem of compound sharding algorithm
Posted by GitBox <gi...@apache.org>.
winer77444 commented on issue #13190:
URL: https://github.com/apache/shardingsphere/issues/13190#issuecomment-948391624
@lanchengx What is the reason why the range query does not enter the custom compound sharding policy
--
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] lanchengx edited a comment on issue #13190: Range query problem of compound sharding algorithm
Posted by GitBox <gi...@apache.org>.
lanchengx edited a comment on issue #13190:
URL: https://github.com/apache/shardingsphere/issues/13190#issuecomment-948439791
> If I switch to the latest version, I get an error building sqlsessionFactory, 
Regarding the error of `sqlsessionFactory`, I think you should check the configuration of mybatis.
It is more recommended that you use the latest version, and you can refer to `ModuloHintShardingAlgorithm.java` and `META-INF/services/org.apache.shardingsphere.sharding.spi.ShardingAlgorithm`in the example
--
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] winer77444 commented on issue #13190: Range query problem of compound sharding algorithm
Posted by GitBox <gi...@apache.org>.
winer77444 commented on issue #13190:
URL: https://github.com/apache/shardingsphere/issues/13190#issuecomment-949123446
@CreatureOX
Thank you, I have checked out the problem, it is not druid scene launcher

--
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] lanchengx commented on issue #13190: Range query problem of compound sharding algorithm
Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #13190:
URL: https://github.com/apache/shardingsphere/issues/13190#issuecomment-948354837
Hi @winer77444 , thanks for you feedback, could you try the latest version?
--
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] lanchengx commented on issue #13190: Range query problem of compound sharding algorithm
Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #13190:
URL: https://github.com/apache/shardingsphere/issues/13190#issuecomment-948439791
> If I switch to the latest version, I get an error building sqlsessionFactory, 
Regarding the error of `sqlsessionFactory`, I think you should check the configuration of mybatis.
It is more recommended that you use the latest version, and you can refer to `ModuloHintShardingAlgorithm.java` in the example
--
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