使用环境：
shardingsphere-proxy:5.5.0
场景、问题：
按照教程
使用
CREATE SHARDING TABLE RULE test_table(
STORAGE_UNITS(ds0),
SHARDING_COLUMN=media_id,
TYPE(NAME=“hash_mod”,PROPERTIES(“sharding-count”=“6”)),
KEY_GENERATE_STRATEGY(COLUMN=media_id,TYPE(NAME=“snowflake”))
);
已经成功数据迁移
但现在想用自定义分类算法，不知道这个distSql怎么写？
已进行操作：
已经将需要的算法类打成jar放进/lib文件夹下
并且含有spi文件，类路径com.qx.agg.client.sharding.SourceDateComplexShardingAlgorithm
查询类似提问有人使用
CREATE SHARDING ALGORITHM ftms_flow_algorithm (
TYPE(NAME=CLASS_BASED,PROPERTIES(“strategy”="COMPLEX ",“algorithm-class-name”=“com.xieyc.sharding.config.FtmsFlowShardingAlgorithm”))
);这种语法成功
现状：
按照上述语法写出自己的distSql
CREATE SHARDING ALGORITHM source_date_complex (
TYPE(NAME=CLASS_BASED,PROPERTIES(“defTable”=“o2pcm_multimedia”,“sources”=“mall,customer”,“strategy”=“COMPLEX”,“algorithmClassName”=“com.qx.agg.client.sharding.SourceDateComplexShardingAlgorithm”))
);
报错 You have an error in your SQL syntax: no viable alternative at input ‘CREATESHARDING’ near ‘[@2,47:54=‘SHARDING’,<864>,1:47]’ at line 1
CREATE SHARDING TABLE RULE o2pcm_multimedia(
STORAGE_UNITS(ds0),
SHARDING_COLUMNS=product_source,creation_date,
TYPE(NAME=“source_date_complex”),
KEY_GENERATE_STRATEGY(COLUMN=media_id,TYPE(NAME=“snowflake”))
);
报错 You have an error in your SQL syntax: no viable alternative at input ‘CREATESHARDING’ near ‘[@2,47:54=‘SHARDING’,<864>,1:47]’ at line 1