marker-wu commented on issue #19423: URL: https://github.com/apache/shardingsphere/issues/19423#issuecomment-1202201944
> @strongduanmu hi, i am using shardingsphere jdbc 5.1.1 and also meet this problem. But the type of binding tables' sharding key i used is string, now the shardingsphere use "\d+$" to get actualDataNodes' suffix. I want to know why choose to use numbers as the rule, will other types (like string) be added in the future? Usually, the suffixes of the partition table are all numbers, and the binding table requires the same partition rules. Numbers are more friendly than letters during verification, and it is difficult to specify verification rules with letters. In addition, the purpose of our sub-table is for better routing later. Common sharding algorithms such as: hash modulo, time, range, etc. These suffixes are all numbers. If you want to divide the table according to letters, you can convert it to numbers by hash algorithm. this is my understanding -- 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]
