linghengqian commented on issue #22899: URL: https://github.com/apache/shardingsphere/issues/22899#issuecomment-1374486709
@zhfeng - In fact, I haven't started preparing the PR for this issue, because I got `2019-nCoV` some time ago. 🤣 - In fact, in https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/ , all statements involving `DATANODES` and `actual_data_nodes` need to be modified. for example ```sql CREATE SHARDING TABLE RULE t_order_item ( DATANODES("ds_${0..1}.t_order_item_${0..1}"), DATABASE_STRATEGY(TYPE="standard",SHARDING_COLUMN=user_id,SHARDING_ALGORITHM(TYPE(NAME="inline",PROPERTIES("algorithm-expression"="ds_${user_id % 2}")))), TABLE_STRATEGY(TYPE="standard",SHARDING_COLUMN=order_id,SHARDING_ALGORITHM(TYPE(NAME="inline",PROPERTIES("algorithm-expression"="t_order_item_${order_id % 2}")))), KEY_GENERATE_STRATEGY(COLUMN=another_id,TYPE(NAME="snowflake")), AUDIT_STRATEGY (TYPE(NAME="DML_SHARDING_CONDITIONS"),ALLOW_HINT_DISABLE=true) ); CREATE SHARDING TABLE RULE IF NOT EXISTS t_order_item ( DATANODES("ds_${0..1}.t_order_item_${0..1}"), DATABASE_STRATEGY(TYPE="standard",SHARDING_COLUMN=user_id,SHARDING_ALGORITHM(TYPE(NAME="inline",PROPERTIES("algorithm-expression"="ds_${user_id % 2}")))), TABLE_STRATEGY(TYPE="standard",SHARDING_COLUMN=order_id,SHARDING_ALGORITHM(TYPE(NAME="inline",PROPERTIES("algorithm-expression"="t_order_item_${order_id % 2}")))), KEY_GENERATE_STRATEGY(COLUMN=another_id,TYPE(NAME="snowflake")), AUDIT_STRATEGY (TYPE(NAME="DML_SHARDING_CONDITIONS"),ALLOW_HINT_DISABLE=true) ); ALTER SHARDING TABLE RULE t_order_item ( DATANODES("ds_${0..3}.t_order_item${0..3}"), DATABASE_STRATEGY(TYPE="standard",SHARDING_COLUMN=user_id,SHARDING_ALGORITHM(TYPE(NAME="inline",PROPERTIES("algorithm-expression"="ds_${user_id % 4}")))), TABLE_STRATEGY(TYPE="standard",SHARDING_COLUMN=order_id,SHARDING_ALGORITHM(TYPE(NAME="inline",PROPERTIES("algorithm-expression"="t_order_item_${order_id % 4}")))), KEY_GENERATE_STRATEGY(COLUMN=another_id,TYPE(NAME="snowflake")), AUDIT_STRATEGY(TYPE(NAME="dml_sharding_conditions"),ALLOW_HINT_DISABLE=true) ); SHOW SHARDING TABLE RULES; SHOW SHARDING TABLE RULES FROM sharding_db; ``` -- 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]
