添加Sharding Rule的错误

MySQL [hireez_sharding_db]> CREATE SHARDING TABLE RULE emailcampaign(
TABLE_STRATEGY(TYPE=standard,SHARDING_COLUMN="email_campaign_team_id",SHARDING_ALGORITHM="eamil_campaign_table_sharding_strategy"),KEY_GENERATE_STRATEGY(COLUMN="email_campaign_id",KEY_GENERATOR="snowflake"));
ERROR 1235 (42000): This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'

算法已经定义过:

MySQL [hireez_sharding_db]> SHOW SHARDING ALGORITHMS\G;
*************************** 1. row ***************************
 name: email_campaign_table_sharding_strategy
 type: CLASS_BASED
props: algorithmClassName=com.hireez.EmailCampaignTableSharding,teamTableMapping=a::a$b::b$c::c$d::d$e::e,strategy=standard
1 row in set (0.002 sec)

语法不完整,需要 DATANODES 或 RESOURCES

好的,谢谢老师!!!!!


看起来只添加RESOURCES是没用的?必须写DATANODES?
我的版本是5.1.1

京ICP备2021015875号