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:48 UTC
[GitHub] [shardingsphere] udrnrso opened a new issue, #16613: How to use Hint without shard key, and use shard algorithm with shard key?
udrnrso opened a new issue, #16613:
URL: https://github.com/apache/shardingsphere/issues/16613
Suppose the shard field is user_id
Without the user_id condition, such as the following sql, I hope to force the shard number to be specified
// Force the use of shard 00
select * from tableA limit 500
With the user_id condition, use the sharding algorithm
select * from tableA where user_id = 'testuser'
After reading the document, it seems that we can only choose between hint/standard. Does it support mixed use?
--
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] strongduanmu commented on issue #16613: How to use Hint without shard key, and use shard algorithm with shard key?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #16613:
URL: https://github.com/apache/shardingsphere/issues/16613#issuecomment-1089761971
@udrnrso Mixed use is not supported now. The hint sharding algorithm is to support scenarios where the sharding column does not exist in the table. If your table has this field, it is best to use the standard algorithm.
--
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] commented on issue #16613: How to use Hint without shard key, and use shard algorithm with shard key?
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #16613:
URL: https://github.com/apache/shardingsphere/issues/16613#issuecomment-1272350107
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 #16613: How to use Hint without shard key, and use shard algorithm with shard key?
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #16613:
URL: https://github.com/apache/shardingsphere/issues/16613#issuecomment-1410759038
This issue has been inactive for a long time, so I will close it.
If this problem persists, please reopen it or submit a new one.
--
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 #16613: How to use Hint without shard key, and use shard algorithm with shard key?
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #16613: How to use Hint without shard key, and use shard algorithm with shard key?
URL: https://github.com/apache/shardingsphere/issues/16613
--
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 #16613: How to use Hint without shard key, and use shard algorithm with shard key?
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #16613: How to use Hint without shard key, and use shard algorithm with shard key?
URL: https://github.com/apache/shardingsphere/issues/16613
--
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