terrymanu opened a new issue #8598:
URL: https://github.com/apache/shardingsphere/issues/8598


   The current `create sharding rule` RDL is:
   
   ```sql
   CREATE shardingrules (
   t_order=hash_mod(order_id, 4), 
   t_item=mod(item_id, 2)
   )
   ```
   
   The RDL maybe not standard enough. I want discuss to standardize them.
   
   1. For `create sharding rule`, is it better to extract sharding column 
together with table name? 
   2. How about add properties key and value mapping?
   3. How about spilit `shardingrules` to `sharding rules`?
   4. `shardingrules` is not accurate, `sharding rule` is better, the RDL is 
create a single rule with multiple table rules.
   
   The optimized RDL should be:
   
   ```sql
   CREATE SHARDING RULE (
   t_order.order_id=HASH_MOD(sharding_count=4), 
   t_item.item_id=MOD(sharding_count=2)
   )
   ```
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to