lrc56668 opened a new issue, #37147:
URL: https://github.com/apache/shardingsphere/issues/37147
I use sharing sphere jdbc for version 5.2.1 .I've encountered this
problem.And my config
like this:
'''
sharding:
table-strategy-template: &complex-strategy
complex:
shardingColumns: province,sharding_month
shardingAlgorithmName: tableComplexShardingAlgorithm
binding-tables:
-
model_check_agent_portrait,model_check_agent_rule,model_check_content,model_check_content_task,model_check_result,model_check_rule_content,model_report_processed_content,voice_info
tables:
model_check_agent_portrait:
actualDataNodes:
ds.model_check_agent_portrait_${['BJ','TJ','HE','GX','XJ','AH','CQ','FJ','GS','GD','GZ','HI','HL','HA','HB','HN','JS','JX','JL','LN','NM','NX','QH','SD','SH','SX','SN','SC','XZ','YN','ZJ','YNWH','SJBZ','SHZC','FZWH']}_${202509..206001}
tableStrategy: *complex-strategy
model_check_agent_rule:
actualDataNodes:
ds.model_check_agent_rule_${['BJ','TJ','HE','GX','XJ','AH','CQ','FJ','GS','GD','GZ','HI','HL','HA','HB','HN','JS','JX','JL','LN','NM','NX','QH','SD','SH','SX','SN','SC','XZ','YN','ZJ','YNWH','SJBZ','SHZC','FZWH']}_${202509..206001}
tableStrategy: *complex-strategy
model_check_content:
actualDataNodes:
ds.model_check_content_${['BJ','TJ','HE','GX','XJ','AH','CQ','FJ','GS','GD','GZ','HI','HL','HA','HB','HN','JS','JX','JL','LN','NM','NX','QH','SD','SH','SX','SN','SC','XZ','YN','ZJ','YNWH','SJBZ','SHZC','FZWH']}_${202509..206001}
tableStrategy: *complex-strategy
model_check_content_task:
actualDataNodes:
ds.model_check_content_task_${['BJ','TJ','HE','GX','XJ','AH','CQ','FJ','GS','GD','GZ','HI','HL','HA','HB','HN','JS','JX','JL','LN','NM','NX','QH','SD','SH','SX','SN','SC','XZ','YN','ZJ','YNWH','SJBZ','SHZC','FZWH']}_${202509..206001}
tableStrategy: *complex-strategy
model_check_result:
actualDataNodes:
ds.model_check_result_${['BJ','TJ','HE','GX','XJ','AH','CQ','FJ','GS','GD','GZ','HI','HL','HA','HB','HN','JS','JX','JL','LN','NM','NX','QH','SD','SH','SX','SN','SC','XZ','YN','ZJ','YNWH','SJBZ','SHZC','FZWH']}_${202509..206001}
tableStrategy: *complex-strategy
model_check_rule_content:
actualDataNodes:
ds.model_check_rule_content_${['BJ','TJ','HE','GX','XJ','AH','CQ','FJ','GS','GD','GZ','HI','HL','HA','HB','HN','JS','JX','JL','LN','NM','NX','QH','SD','SH','SX','SN','SC','XZ','YN','ZJ','YNWH','SJBZ','SHZC','FZWH']}_${202509..206001}
tableStrategy: *complex-strategy
model_report_processed_content:
actualDataNodes:
ds.model_report_processed_content_${['BJ','TJ','HE','GX','XJ','AH','CQ','FJ','GS','GD','GZ','HI','HL','HA','HB','HN','JS','JX','JL','LN','NM','NX','QH','SD','SH','SX','SN','SC','XZ','YN','ZJ','YNWH','SJBZ','SHZC','FZWH']}_${202509..206001}
tableStrategy: *complex-strategy
voice_info:
actualDataNodes:
ds.voice_info_${['BJ','TJ','HE','GX','XJ','AH','CQ','FJ','GS','GD','GZ','HI','HL','HA','HB','HN','JS','JX','JL','LN','NM','NX','QH','SD','SH','SX','SN','SC','XZ','YN','ZJ','YNWH','SJBZ','SHZC','FZWH']}_${202509..206001}
tableStrategy: *complex-strategy
sharding-algorithms:
tableComplexShardingAlgorithm:
type: CLASS_BASED
props:
strategy: COMPLEX
algorithmClassName:
com.xxxxxx.algorithm.TableComplexShardingAlgorithm
supported-provinces:
BJ,TJ,HE,GX,XJ,AH,CQ,FJ,GS,GD,GZ,HI,HL,HA,HB,HN,JS,JX,JL,LN,NM,NX,QH,SD,SH,SX,SN,SC,XZ,YN,ZJ,YNWH,SJBZ,SHZC,FZWH
'''
I can use it successfully when I don't use binding-tables. But when I used
binding-tables, it failed. May I ask the experts, how can I solve this 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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
