CREATE SHARDING TABLE REFERENCE RULE

    • Sharding table reference rule can only be created for sharding tables;
    • The referenced sharding tables should be sharded in the same storage units and have the same number of sharding nodes. For example ds_${0..1}.t_order_${0..1} and ds_${0..1}.t_order_item_${0..1};
    • The referenced sharding tables should use consistent sharding algorithms. For example and t_order_item_{order_item_id % 2};

    1.Create a sharding table reference rule

    2.Create multiple sharding table reference rules

    CREATE, , TABLE, REFERENCE,