songwdfu commented on PR #16308:
URL: https://github.com/apache/pinot/pull/16308#issuecomment-3058841983
Posting some benchmark results here.
**TL;DR**: this works significantly better when combine is difficult (when
cardinality is high / segments are heterogeneous), and is comparable when
combine is trivial, compared to the previous approach.
1. When we have high cardinality (case where combine is more non-trivial)
before
```
Benchmark (_limit) (_numRows)
(_numSegments)
(_query) (_scenario) Mode
Cnt Score Error Units
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 3.129 ± 4.893 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 16.514 ± 7.142 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 47.954 ± 19.621 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 217.165 ± 134.572 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 5.990 ± 11.172 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 58.851 ± 13.147 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 201.846 ± 124.280 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 858.647 ± 623.113 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 5.984 ± 10.611 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 148.480 ± 90.148 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 412.622 ± 372.467 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 1324.294 ± 1965.114 ms/op
```
after:
```
Benchmark (_limit) (_numRows)
(_numSegments)
(_query) (_scenario) Mode
Cnt Score Error Units
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 3.090 ± 6.740 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 11.066 ± 9.907 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 30.922 ± 5.480 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 144.412 ± 83.481 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 5.388 ± 17.988 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 18.025 ± 15.761 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 55.601 ± 15.059 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 252.829 ± 34.326 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 6.713 ± 21.936 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 63.126 ± 20.740 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 153.047 ± 25.816 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 669.081 ± 654.073 ms/op
```
P.S. same as above but when each segment contains more rows
before:
```
Benchmark (_limit) (_numRows)
(_numSegments)
(_query) (_scenario) Mode
Cnt Score Error Units
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 15000
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 8.020 ± 3.797 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 15000
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 61.520 ± 37.095 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 15000
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 230.405 ± 63.434 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 15000
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 1556.102 ± 1786.330 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 15000
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 10.219 ± 6.751 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 15000
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 117.850 ± 185.339 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 15000
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 441.594 ± 224.622 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 15000
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 2218.430 ± 1655.918 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 15000
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 16.873 ± 11.466 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 15000
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 371.442 ± 230.607 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 15000
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 923.553 ± 440.083 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 15000
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 3878.062 ± 2095.122 ms/op
```
after:
```
Benchmark (_limit) (_numRows)
(_numSegments)
(_query) (_scenario) Mode
Cnt Score Error Units
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 15000
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 8.589 ± 1.124 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 15000
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 60.611 ± 41.930 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 15000
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 232.372 ± 87.084 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 15000
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 1507.881 ± 1548.949 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 15000
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 10.095 ± 11.979 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 15000
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 79.085 ± 107.484 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 15000
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 276.691 ± 77.589 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 15000
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 1756.821 ± 2498.734 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 15000
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 17.627 ± 7.227 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 15000
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 130.812 ± 61.856 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 15000
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 464.771 ± 962.730 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 15000
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.001) avgt
3 2612.355 ± 4046.972 ms/op
```
2. When we have mid-low cardinality (When merging is more trivial)
before:
```
Benchmark (_limit) (_numRows)
(_numSegments)
(_query) (_scenario) Mode
Cnt Score Error Units
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 4.704 ± 15.097 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 2.836 ± 4.926 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 7.021 ± 8.706 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 6.959 ± 14.674 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 17.732 ± 5.857 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 16.853 ± 12.722 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 75.329 ± 42.797 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 66.019 ± 24.065 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 2.292 ± 4.172 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 2.272 ± 4.687 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 6.694 ± 6.883 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 6.279 ± 6.611 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 18.657 ± 3.592 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 16.350 ± 4.889 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 74.575 ± 40.917 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 67.406 ± 28.781 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 2.324 ± 5.306 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 2.290 ± 2.047 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 8.151 ± 36.454 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 6.397 ± 4.467 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 18.557 ± 13.166 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 16.430 ± 5.203 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 111.217 ± 80.821 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 71.733 ± 20.200 ms/op
```
after:
```
Benchmark (_limit) (_numRows)
(_numSegments)
(_query) (_scenario) Mode
Cnt Score Error Units
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 2.732 ± 8.576 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 2.342 ± 5.420 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 6.693 ± 6.925 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 6.150 ± 4.933 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 18.807 ± 29.398 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 18.854 ± 51.010 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 68.289 ± 13.958 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 100 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 68.261 ± 178.586 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 2.217 ± 3.417 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 2.286 ± 5.028 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 7.430 ± 5.227 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 8.241 ± 17.376 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 20.092 ± 8.761 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 17.250 ± 8.780 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 74.066 ± 104.439 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 1000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 72.919 ± 54.590 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 2.530 ± 8.437 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
2 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 2.303 ± 2.852 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 7.264 ± 7.890 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
50 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 6.868 ± 7.660 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 20.725 ± 10.692 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
200 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 17.148 ± 5.950 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.5) avgt
3 105.847 ± 176.879 ms/op
BenchmarkAggregateGroupByOrderByQueriesSSE.query 10000 1500
1000 SELECT RAW_STRING_COL,STRING_COL,COUNT(*) FROM MyTable GROUP BY
RAW_STRING_COL,STRING_COL ORDER BY RAW_STRING_COL,STRING_COL EXP(0.999) avgt
3 80.727 ± 22.931 ms/op
```
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
