doris icon indicating copy to clipboard operation
doris copied to clipboard

[Opt](Vectorized) Support push down no grouping agg

Open HappenLee opened this issue 3 years ago • 2 comments

Proposed changes

Use the segment static to speed up some not grouping agg query:min, max, count

Here need to a new SegmentIter call StatisticsIter to do the work.

lineorder : 60kw line num

query Before After count(*) 0.5s 0.02s min 0.4s 0.01s max 0.4s 0.01s

Problem summary

Describe your changes.

Checklist(Required)

  1. Does it affect the original behavior:
    • [ ] Yes
    • [ ] No
    • [ ] I don't know
  2. Has unit tests been added:
    • [ ] Yes
    • [ ] No
    • [ ] No Need
  3. Has document been added or modified:
    • [ ] Yes
    • [ ] No
    • [ ] No Need
  4. Does it need to update dependencies:
    • [ ] Yes
    • [ ] No
  5. Are there any changes that cannot be rolled back:
    • [ ] Yes (If Yes, please explain WHY)
    • [ ] No

Further comments

If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...

HappenLee avatar Sep 21 '22 04:09 HappenLee

PR approved by at least one committer and no changes requested.

github-actions[bot] avatar Sep 22 '22 05:09 github-actions[bot]

PR approved by anyone and no changes requested.

github-actions[bot] avatar Sep 22 '22 05:09 github-actions[bot]