mandone opened a new issue, #24572:
URL: https://github.com/apache/shardingsphere/issues/24572

   ## Question
   
   this is my sql before route
   
   ```sql
   select day_value as id_date, avg(success_count) as success, 
avg(failed_count) as fail
   from t_sdk_stat_count_vivo_encrypt_sdk_202301 force index (idx_day_count)
   where sdk_code = 'xxx_sdk'
     and day_value >= '20221201'
     and day_value <= '20230301'
     and month_value >= '202212'
     and month_value <= '202303'
   group by day_value;
   ```
   
   
   sdk_code and month_value column is my sharding rule columns like under config
   
   ```sql
   <sharding:complex-strategy id="complexStrategy" 
sharding-columns="sdk_code,month_value" 
algorithm-ref="complexShardingAlgorithm"/>
   ```
   
   due to my shard table with month_value  and sdk_code,the final sql needn't  
sdk_code = 'xxx_sdk' and  and month_value >= '202212' and month_value <= 
'202303';
   so I want to remve these two conditions。
   I read the source code, didn't find any hook meet this demand


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

Reply via email to