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 2022/10/10 06:41:22 UTC
[GitHub] [shardingsphere] Gordonman opened a new issue, #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Gordonman opened a new issue, #16720:
URL: https://github.com/apache/shardingsphere/issues/16720
## Question
shardingshere version: 4.0.0-RC2
I chose the sharding strategy is preciseShardingAlgorithm, and the precise algorithm class was specified.
When there is no sharding key in SQL, I want to use HintManager to manually specify the sharding key, but it does not take effect.
I checked the source code and found that only one sharding rule can be configured.
Is there any way to solve my problem？
thanks.
--
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] github-actions[bot] commented on issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #16720:
URL: https://github.com/apache/shardingsphere/issues/16720#issuecomment-1272350061
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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] RaigorJiang commented on issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #16720:
URL: https://github.com/apache/shardingsphere/issues/16720#issuecomment-1094482193
https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/sharding/hint/#route-to-the-specified-database-with-hint
--
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] Gordonman commented on issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Posted by GitBox <gi...@apache.org>.
Gordonman commented on issue #16720:
URL: https://github.com/apache/shardingsphere/issues/16720#issuecomment-1094491506
> https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/sharding/hint/#route-to-the-specified-database-with-hint
Thank you @RaigorJiang.
I've tried before , but it can't solve my problem. Because I have specified the table strategy is standard.
Use hintManager.addTableShardingValue to add sharding key value of table. it does not take effect.
--
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] RaigorJiang commented on issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #16720:
URL: https://github.com/apache/shardingsphere/issues/16720#issuecomment-1095884992
> @RaigorJiang Ok, I see, thanks. Version upgrade is a difficult thing. I have another question, Dose SQL comments support specifying sharding table? I checked the doc and found that it seems to only support data source routing
Yes, just support hint to data source for now.
--
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] RaigorJiang commented on issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #16720:
URL: https://github.com/apache/shardingsphere/issues/16720#issuecomment-1094511123
@Gordonman
I am referring to specifying sharding routing through `SQL comments`, which does not require hint algorithm and is designed for sharding algorithm.
But this requires you to upgrade to version 5.x.
- example
```sql
/* ShardingSphere hint: dataSourceName=ds_0 */
SELECT * FROM t_order;
```
--
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] Gordonman commented on issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Posted by GitBox <gi...@apache.org>.
Gordonman commented on issue #16720:
URL: https://github.com/apache/shardingsphere/issues/16720#issuecomment-1095811161
@RaigorJiang
Ok, I see, thanks. Version upgrade is a difficult thing.
I have another question, Dose SQL comments support specifying sharding table? I checked the doc and found that it seems to only support data source routing
--
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] RaigorJiang commented on issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #16720:
URL: https://github.com/apache/shardingsphere/issues/16720#issuecomment-1094480126
Hi @Gordonman , Please see if sql hint can solve your problem？
--
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] RaigorJiang closed issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
URL: https://github.com/apache/shardingsphere/issues/16720
--
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] RaigorJiang commented on issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #16720:
URL: https://github.com/apache/shardingsphere/issues/16720#issuecomment-1323796959
Closed due to no reply for a long time.
--
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] github-actions[bot] closed issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #16720: I chose the sharding strategy is preciseShardingAlgorithm, but I want to use HintManager
URL: https://github.com/apache/shardingsphere/issues/16720
--
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