You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/11/29 14:43:15 UTC

[GitHub] [incubator-shardingsphere] terrymanu opened a new issue #3627: Refactor DISTINCT SQL merge

terrymanu opened a new issue #3627: Refactor DISTINCT SQL merge
URL: https://github.com/apache/incubator-shardingsphere/issues/3627
 
 
   Current distinct process logic is too complicated and mix the logic with execute module and merge module.
   We need to refactor it.
   
   - [ ] Reuse GROUP BY's logic to process DISTINCT row, add all DISTINCT projections in to group by items
   - [ ] Refactor `SUM (DISTINCT xxx)` and `COUNT (DISTINCT xxx)` from QueryResult to `GroupByStreamMergedResult` and `GroupByMemoryMergedResult`
   - [ ] Add `DistinctSumAggregationUnit`, `DistinctCountAggregationUnit` and `DistinctAverageAggregationUnit` to handle aggregation with distinct
   - [ ] Do not need care about `MAX (DISTINCT xxx)` and `MIN (DISTINCT xxx)`, just use regular GROUP BY logic
   - [ ] Remove all distinct logic from execute module

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services