lvjingang-git opened a new issue, #36967: URL: https://github.com/apache/shardingsphere/issues/36967
I have a table signjob that uses a composite algorithm of id+reqDate (divided into 20 slices based on id once a month). Due to the fact that there is a query SQL condition only for parentJobId in the business, it will cause broadcast execution. Therefore, I have defined this field as a sharding field so that when sharding is executed, it will be included in my custom algorithm. If there is time in this field, the range can be reduced to one month, which greatly reduces the broadcast range. However, I have another SQL that needs to update parentJobId, and the result gives me an error message, which does not allow me to update the sharding key. What should I do? -- 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]
