You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2025/11/26 07:34:36 UTC
[PR] [refactor](grouping set) remove virtual slot reference [doris]
morrySnow opened a new pull request, #58397:
URL: https://github.com/apache/doris/pull/58397
### What problem does this PR solve?
Problem Summary:
This pull request refactors how grouping and virtual slot logic is handled in the Nereids query planner, removing the use of `VirtualSlotReference` and related logic in favor of more explicit handling of grouping functions and grouping IDs. This simplifies the codebase and makes grouping set handling more robust and maintainable.
**Refactoring grouping and virtual slot logic:**
* Removed all references and special handling for `VirtualSlotReference` across the codebase, including imports, type checks, and related logic in `ExpressionTranslator`, `PhysicalPlanTranslator`, `PlanTranslatorContext`, and analysis rules. [[1]](diffhunk://#diff-2c4fc9eb93bc201b1fc73fd5bbfeb60f3138e5063707b661a51f617418a2db5cL83) [[2]](diffhunk://#diff-f363369b49ec5af5a087420f31ec3d9a8c5147eacabdf051792017cfab289dacL107-R110) [[3]](diffhunk://#diff-73d395bdaf1754e51e7f2c9dabaa8e27a78fabb244995d6ed0f98d0b07293d13L27) [[4]](diffhunk://#diff-e5076e5f12e7289f6f98f8e532fb50bdd01a55f6e9ff6dafebc763828b453f7aL32) [[5]](diffhunk://#diff-c89012884aea51ce8f9b302110cd2e05ea5767905b417d21d3620150b6a5650bL31)
* Updated the logic in `PhysicalPlanTranslator` to use grouping functions directly (via `GroupingScalarFunction`) and to explicitly include the grouping ID slot in output slot construction for repeat nodes, improving correctness and clarity. [[1]](diffhunk://#diff-f363369b49ec5af5a087420f31ec3d9a8c5147eacabdf051792017cfab289dacL2463-R2469) [[2]](diffhunk://#diff-f363369b49ec5af5a087420f31ec3d9a8c5147eacabdf051792017cfab289dacL2481-R2482) [[3]](diffhunk://#diff-f363369b49ec5af5a087420f31ec3d9a8c5147eacabdf051792017cfab289dacL2503-R2502)
* Simplified slot descriptor creation in `PlanTranslatorContext` by removing special handling for virtual slots and always using `SlotRef`, streamlining slot management. [[1]](diffhunk://#diff-73d395bdaf1754e51e7f2c9dabaa8e27a78fabb244995d6ed0f98d0b07293d13R310-L320) [[2]](diffhunk://#diff-73d395bdaf1754e51e7f2c9dabaa8e27a78fabb244995d6ed0f98d0b07293d13L329)
**Analysis and rule improvements:**
* Enhanced analysis rules to correctly allow grouping scalar functions only in repeat plans, and to properly ignore the grouping ID slot when checking slot references from children, making validation stricter and more accurate. [[1]](diffhunk://#diff-e5076e5f12e7289f6f98f8e532fb50bdd01a55f6e9ff6dafebc763828b453f7aR76) [[2]](diffhunk://#diff-e5076e5f12e7289f6f98f8e532fb50bdd01a55f6e9ff6dafebc763828b453f7aL88-R88) [[3]](diffhunk://#diff-e5076e5f12e7289f6f98f8e532fb50bdd01a55f6e9ff6dafebc763828b453f7aL113-R126) [[4]](diffhunk://#diff-e5076e5f12e7289f6f98f8e532fb50bdd01a55f6e9ff6dafebc763828b453f7aL145-L157)
* Updated the normalization rule for repeat plans to bind grouping IDs explicitly and to use `BigIntType` for grouping IDs, removing dependency on virtual slot binding. [[1]](diffhunk://#diff-c89012884aea51ce8f9b302110cd2e05ea5767905b417d21d3620150b6a5650bR40) [[2]](diffhunk://#diff-c89012884aea51ce8f9b302110cd2e05ea5767905b417d21d3620150b6a5650bL89-R89)
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [x] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [x] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [x] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [x] No.
- [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3584162947
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3579856331
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3584918206
# FE UT Coverage Report
Increment line coverage ` 70.45% (93/132)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58397_a663f5d58f0fb052aa2e41a11be45b6b82ced97e/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58397_a663f5d58f0fb052aa2e41a11be45b6b82ced97e/fe_report/index.html)
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3589415074
# FE Regression Coverage Report
Increment line coverage ` 84.31% (129/153)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58397_804f338d09c509d0b3b855ca45b85e842c6c7584_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58397_804f338d09c509d0b3b855ca45b85e842c6c7584_merge_fe/report/index.html)
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3584301021
<details>
<summary>ClickBench: <b>Total hot run time: 27.42 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit dba1546d8bc3bdd27b7a66d9eed44a66daabf0d1, data reload: false
query1 0.06 0.05 0.06
query2 0.09 0.05 0.05
query3 0.25 0.08 0.08
query4 1.61 0.11 0.11
query5 0.27 0.25 0.24
query6 1.18 0.65 0.64
query7 0.03 0.02 0.03
query8 0.06 0.04 0.04
query9 0.59 0.53 0.51
query10 0.58 0.57 0.59
query11 0.17 0.11 0.11
query12 0.15 0.11 0.11
query13 0.63 0.60 0.60
query14 1.02 1.00 1.00
query15 0.85 0.83 0.85
query16 0.41 0.38 0.38
query17 1.00 1.03 1.02
query18 0.21 0.20 0.19
query19 1.87 1.80 1.78
query20 0.01 0.01 0.01
query21 15.47 0.19 0.13
query22 5.12 0.07 0.05
query23 15.67 0.27 0.10
query24 3.06 0.63 0.42
query25 0.07 0.07 0.06
query26 0.14 0.14 0.14
query27 0.06 0.06 0.06
query28 4.43 1.19 0.92
query29 12.57 3.90 3.25
query30 0.28 0.13 0.12
query31 2.81 0.63 0.39
query32 3.22 0.55 0.48
query33 3.01 3.06 3.02
query34 15.87 5.22 4.52
query35 4.55 4.57 4.63
query36 0.67 0.50 0.49
query37 0.10 0.06 0.06
query38 0.06 0.05 0.04
query39 0.03 0.04 0.03
query40 0.19 0.14 0.14
query41 0.08 0.03 0.03
query42 0.04 0.03 0.03
query43 0.04 0.03 0.03
Total cold run time: 98.58 s
Total hot run time: 27.42 s
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3601242782
<details>
<summary>ClickBench: <b>Total hot run time: 27.31 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 9215d4ba6b8462e81e13e33f6a533a7d60f3a2b4, data reload: false
query1 0.06 0.05 0.05
query2 0.10 0.06 0.05
query3 0.26 0.09 0.09
query4 1.61 0.12 0.11
query5 0.28 0.25 0.26
query6 1.18 0.65 0.64
query7 0.04 0.03 0.03
query8 0.06 0.04 0.05
query9 0.58 0.52 0.51
query10 0.54 0.56 0.57
query11 0.15 0.12 0.11
query12 0.16 0.12 0.12
query13 0.62 0.60 0.61
query14 0.99 0.99 0.98
query15 0.81 0.81 0.80
query16 0.38 0.39 0.42
query17 0.99 1.02 1.04
query18 0.24 0.22 0.26
query19 1.88 1.80 1.88
query20 0.02 0.01 0.01
query21 15.47 0.30 0.14
query22 4.54 0.05 0.04
query23 15.87 0.29 0.10
query24 2.27 0.30 0.47
query25 0.08 0.06 0.04
query26 0.15 0.14 0.13
query27 0.05 0.05 0.06
query28 4.26 1.23 1.04
query29 12.60 4.00 3.16
query30 0.28 0.15 0.11
query31 2.81 0.62 0.41
query32 3.22 0.56 0.47
query33 3.09 3.05 3.04
query34 16.62 5.19 4.55
query35 4.56 4.58 4.52
query36 0.66 0.49 0.50
query37 0.11 0.06 0.06
query38 0.08 0.05 0.03
query39 0.04 0.03 0.04
query40 0.17 0.14 0.14
query41 0.08 0.03 0.03
query42 0.04 0.04 0.02
query43 0.05 0.03 0.03
Total cold run time: 98.05 s
Total hot run time: 27.31 s
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3580388858
<details>
<summary>TPC-DS: <b>Total hot run time: 176322 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 6d8f0dbb5122d1cef67ebf54bdb7d4ed051a06c4, data reload: false
web_returns Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:43:58 2023-12-26 22:45:43 NULL utf-8 NULL NULL
warehouse Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:43:56 2023-12-26 22:44:01 NULL utf-8 NULL NULL
web_site Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:43:58 2023-12-26 22:44:01 NULL utf-8 NULL NULL
customer_demographics Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:43:56 2023-12-26 22:44:34 NULL utf-8 NULL NULL
promotion Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:43:58 2023-12-26 22:44:01 NULL utf-8 NULL NULL
web_page Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:43:59 2023-12-26 22:44:01 NULL utf-8 NULL NULL
store_returns Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:43:59 2023-12-26 22:47:09 NULL utf-8 NULL NULL
income_band Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:43:58 2023-12-26 22:44:01 NULL utf-8 NULL NULL
dbgen_version Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:44:00 2023-12-26 22:44:01 NULL utf-8 NULL NULL
catalog_page Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:43:58 2023-12-26 22:44:01 NULL utf-8 NULL NULL
reason Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 22:43:56 2023-12-26 22:44:01 NULL utf-8 NULL NULL
============================================
query1 1002 408 388 388
query2 6552 1620 1627 1620
query3 6757 231 224 224
query4 27469 25182 24797 24797
query5 query6 324 255 257 255
query7 4642 465 314 314
query8 311 269 279 269
query9 8903 2609 2609 2609
query10 564 472 409 409
query11 16733 16295 16085 16085
query12 189 122 123 122
query13 1659 524 395 395
query14 query15 238 228 221 221
query16 8549 2014 1677 1677
query17 1080 738 625 625
query18 query19 239 236 196 196
query20 141 136 135 135
query21 221 146 122 122
query22 query23 32942 32377 32315 32315
query24 8879 2299 2328 2299
query25 711 586 529 529
query26 1932 296 168 168
query27 query28 7798 2142 2129 2129
query29 1023 842 740 740
query30 347 208 181 181
query31 906 748 611 611
query32 91 80 77 77
query33 626 396 353 353
query34 1136 918 549 549
query35 695 728 686 686
query36 query37 236 111 91 91
query38 3478 3415 3460 3415
query39 1594 1512 1500 1500
query40 309 271 247 247
query41 79 62 61 61
query42 155 129 116 116
query43 451 460 437 437
query44 1356 773 756 756
query45 217 197 202 197
query46 878 989 630 630
query47 1884 1905 1826 1826
query48 584 422 321 321
query49 1523 571 430 430
query50 670 724 429 429
query51 3992 4121 4139 4121
query52 111 113 104 104
query53 241 266 191 191
query54 415 343 331 331
query55 97 96 87 87
query56 339 328 314 314
query57 1238 1293 1188 1188
query58 287 275 281 275
query59 2525 2668 2506 2506
query60 341 345 328 328
query61 173 176 173 173
query62 826 747 701 701
query63 230 194 198 194
query64 3714 2727 2290 2290
query65 4086 3981 3961 3961
query66 1428 498 400 400
query67 query68 2561 1081 607 607
query69 491 374 358 358
query70 query71 360 330 334 330
query72 10796 10688 10164 10164
query73 3521 582 398 398
query74 8521 8715 8354 8354
query75 4941 3463 3122 3122
query76 5255 1129 753 753
query77 query78 11008 8756 8393 8393
query79 1647 929 607 607
query80 query81 559 259 229 229
query82 197 150 121 121
query83 372 276 260 260
query84 313 124 115 115
query85 query86 query87 4055 3993 3538 3538
query88 8786 2229 2233 2229
query89 998 305 294 294
query90 2707 230 220 220
query91 250 176 154 154
query92 129 72 71 71
query93 10453 946 663 663
query94 1429 1054 893 893
query95 10990 11329 11008 11008
query96 709 303 293 293
query97 3181 2840 2850 2840
query98 267 225 217 217
query99 1763 1475 1371 1371
Total cold run time: 272375 ms
Total hot run time: 176322 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3584696938
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3600100187
# FE UT Coverage Report
Increment line coverage ` 69.74% (106/152)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58397_5001f725c4cf053e12c1cd1aec19ea2f42cea179/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58397_5001f725c4cf053e12c1cd1aec19ea2f42cea179/fe_report/index.html)
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3599936079
PR approved by anyone and no changes requested.
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3588295224
<details>
<summary>TPC-DS: <b>Total hot run time: 181848 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 05602b62a735bbc6684f25cb9b96cfa5969c17e1, data reload: false
query1 1032 405 408 405
query2 6608 1615 1546 1546
query3 6761 229 219 219
query4 25231 23370 23073 23073
query5 5241 627 470 470
query6 352 237 222 222
query7 4657 513 308 308
query8 308 270 263 263
query9 8750 2610 2581 2581
query10 571 361 308 308
query11 15292 14866 15057 14866
query12 191 125 116 116
query13 1688 578 452 452
query14 9714 5507 5555 5507
query15 209 208 204 204
query16 7683 692 525 525
query17 1220 740 615 615
query18 2042 426 352 352
query19 203 198 188 188
query20 134 125 125 125
query21 217 138 112 112
query22 3889 3945 3805 3805
query23 32792 32192 31844 31844
query24 8452 2416 2441 2416
query25 621 530 447 447
query26 1242 272 169 169
query27 2732 488 344 344
query28 4348 2141 2139 2139
query29 801 622 505 505
query30 311 247 219 219
query31 812 728 653 653
query32 89 72 79 72
query33 603 384 332 332
query34 806 864 551 551
query35 812 820 745 745
query36 916 920 843 843
query37 130 111 86 86
query38 3957 3891 3782 3782
query39 1470 1416 1416 1416
query40 246 143 123 123
query41 71 69 68 68
query42 124 115 121 115
query43 458 458 424 424
query44 1321 738 749 738
query45 198 199 182 182
query46 875 1004 644 644
query47 1686 1738 1658 1658
query48 389 436 335 335
query49 762 480 409 409
query50 647 687 430 430
query51 3861 4014 3820 3820
query52 112 114 110 110
query53 245 269 208 208
query54 321 302 277 277
query55 98 95 92 92
query56 328 324 332 324
query57 1128 1159 1130 1130
query58 291 270 277 270
query59 2337 2383 2334 2334
query60 363 356 355 355
query61 164 162 162 162
query62 763 728 690 690
query63 229 197 197 197
query64 4472 1251 926 926
query65 4089 4020 3968 3968
query66 1093 445 348 348
query67 15215 14992 14743 14743
query68 5685 952 629 629
query69 542 365 312 312
query70 1107 1046 1011 1011
query71 429 335 314 314
query72 5419 4741 4921 4741
query73 682 585 362 362
query74 8797 8851 8605 8605
query75 3088 3093 2615 2615
query76 3324 1156 703 703
query77 523 415 338 338
query78 9517 9834 8947 8947
query79 1194 858 579 579
query80 748 627 549 549
query81 489 271 238 238
query82 185 147 117 117
query83 275 280 270 270
query84 265 115 103 103
query85 977 557 439 439
query86 330 294 274 274
query87 4020 4095 3959 3959
query88 2886 2314 2348 2314
query89 382 335 303 303
query90 1802 227 222 222
query91 175 172 141 141
query92 72 79 67 67
query93 1064 1017 663 663
query94 685 458 350 350
query95 500 410 404 404
query96 521 549 290 290
query97 2639 2693 2577 2577
query98 232 235 215 215
query99 1327 1423 1292 1292
Total cold run time: 264654 ms
Total hot run time: 181848 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3588307472
<details>
<summary>ClickBench: <b>Total hot run time: 27.44 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 05602b62a735bbc6684f25cb9b96cfa5969c17e1, data reload: false
query1 0.06 0.05 0.05
query2 0.11 0.04 0.05
query3 0.25 0.09 0.08
query4 1.61 0.12 0.11
query5 0.30 0.27 0.27
query6 1.18 0.62 0.64
query7 0.04 0.02 0.03
query8 0.06 0.05 0.04
query9 0.59 0.51 0.50
query10 0.56 0.56 0.56
query11 0.16 0.12 0.11
query12 0.15 0.11 0.12
query13 0.65 0.60 0.61
query14 0.99 0.98 0.99
query15 0.83 0.82 0.82
query16 0.40 0.38 0.42
query17 1.00 1.05 1.05
query18 0.23 0.22 0.22
query19 1.86 1.85 1.83
query20 0.01 0.01 0.01
query21 15.48 0.29 0.13
query22 4.73 0.05 0.04
query23 15.98 0.26 0.11
query24 1.01 0.79 0.27
query25 0.08 0.09 0.06
query26 0.15 0.14 0.13
query27 0.09 0.06 0.06
query28 4.31 1.22 1.03
query29 12.57 3.96 3.22
query30 0.28 0.13 0.12
query31 2.82 0.59 0.41
query32 3.24 0.55 0.46
query33 3.08 3.06 3.07
query34 16.91 5.14 4.49
query35 4.59 4.61 4.57
query36 0.66 0.51 0.51
query37 0.11 0.07 0.07
query38 0.07 0.04 0.04
query39 0.04 0.04 0.03
query40 0.17 0.14 0.14
query41 0.08 0.04 0.03
query42 0.05 0.03 0.03
query43 0.04 0.03 0.04
Total cold run time: 97.58 s
Total hot run time: 27.44 s
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3584764067
<details>
<summary>TPC-H: <b>Total hot run time: 34428 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit a663f5d58f0fb052aa2e41a11be45b6b82ced97e, data reload: false
------ Round 1 ----------------------------------
q1 17607 5066 4904 4904
q2 2028 313 205 205
q3 10264 1291 743 743
q4 10229 968 387 387
q5 7576 2369 2354 2354
q6 184 171 142 142
q7 929 792 641 641
q8 9355 1338 1155 1155
q9 7312 5335 5317 5317
q10 6894 2233 1809 1809
q11 498 304 289 289
q12 360 386 236 236
q13 17775 3700 3042 3042
q14 231 242 216 216
q15 580 509 506 506
q16 1040 1012 973 973
q17 597 863 359 359
q18 7693 7215 7117 7117
q19 1564 956 547 547
q20 366 348 231 231
q21 3792 3137 2301 2301
q22 1023 1035 954 954
Total cold run time: 107897 ms
Total hot run time: 34428 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5069 4972 4924 4924
q2 338 403 314 314
q3 2166 2715 2360 2360
q4 1339 1768 1349 1349
q5 4227 4582 4415 4415
q6 219 184 135 135
q7 2073 2041 1830 1830
q8 2838 2636 2628 2628
q9 7485 7608 7522 7522
q10 3024 3237 2865 2865
q11 614 526 516 516
q12 709 801 847 801
q13 3490 3913 3267 3267
q14 311 310 295 295
q15 563 516 522 516
q16 1269 1134 1047 1047
q17 1177 1573 1438 1438
q18 7981 7629 7720 7629
q19 816 865 874 865
q20 2043 2088 1940 1940
q21 4993 4317 4285 4285
q22 1095 1065 1033 1033
Total cold run time: 53839 ms
Total hot run time: 51974 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3580409379
<details>
<summary>ClickBench: <b>Total hot run time: 27.42 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 6d8f0dbb5122d1cef67ebf54bdb7d4ed051a06c4, data reload: false
query1 0.06 0.04 0.04
query2 0.10 0.05 0.06
query3 0.25 0.08 0.08
query4 1.61 0.12 0.11
query5 0.28 0.25 0.25
query6 1.17 0.66 0.63
query7 0.03 0.02 0.02
query8 0.06 0.04 0.04
query9 0.57 0.54 0.51
query10 0.56 0.58 0.58
query11 0.16 0.11 0.11
query12 0.14 0.12 0.12
query13 0.62 0.61 0.61
query14 1.00 1.01 1.01
query15 0.86 0.83 0.84
query16 0.40 0.39 0.38
query17 1.07 1.04 1.00
query18 0.21 0.20 0.21
query19 1.93 1.82 1.81
query20 0.02 0.01 0.02
query21 15.44 0.20 0.13
query22 5.07 0.08 0.05
query23 15.67 0.26 0.10
query24 3.41 0.49 0.43
query25 0.07 0.06 0.06
query26 0.14 0.15 0.13
query27 0.06 0.05 0.06
query28 4.13 1.13 0.93
query29 12.62 3.90 3.22
query30 0.28 0.13 0.11
query31 2.81 0.59 0.38
query32 3.23 0.55 0.47
query33 3.04 3.05 3.06
query34 15.79 5.14 4.54
query35 4.55 4.55 4.62
query36 0.65 0.50 0.49
query37 0.10 0.07 0.07
query38 0.06 0.04 0.03
query39 0.04 0.03 0.03
query40 0.18 0.14 0.13
query41 0.08 0.03 0.02
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 98.6 s
Total hot run time: 27.42 s
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3588740884
<details>
<summary>TPC-H: <b>Total hot run time: 34490 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 804f338d09c509d0b3b855ca45b85e842c6c7584, data reload: false
------ Round 1 ----------------------------------
q1 17608 5218 4922 4922
q2 2087 324 206 206
q3 10243 1296 733 733
q4 10227 939 370 370
q5 7548 2485 2280 2280
q6 188 182 141 141
q7 961 780 635 635
q8 9359 1365 1077 1077
q9 7143 5423 5329 5329
q10 6892 2275 1842 1842
q11 522 321 292 292
q12 353 386 230 230
q13 17785 3675 3333 3333
q14 243 238 218 218
q15 586 529 512 512
q16 885 865 826 826
q17 619 770 501 501
q18 7374 7137 7058 7058
q19 1085 967 577 577
q20 339 332 231 231
q21 3615 3242 2251 2251
q22 1001 974 926 926
Total cold run time: 106663 ms
Total hot run time: 34490 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4990 4935 5009 4935
q2 315 386 327 327
q3 2159 2669 2305 2305
q4 1356 1760 1278 1278
q5 4245 4553 4608 4553
q6 225 183 139 139
q7 2091 2020 1847 1847
q8 2650 2537 2523 2523
q9 7553 7462 7484 7462
q10 3046 3334 2820 2820
q11 576 517 506 506
q12 728 791 607 607
q13 3576 3927 3389 3389
q14 305 303 306 303
q15 590 532 538 532
q16 918 1012 868 868
q17 1156 1406 1441 1406
q18 7981 7696 7402 7402
q19 851 820 819 819
q20 2049 2049 1962 1962
q21 4774 4236 4161 4161
q22 1058 1041 984 984
Total cold run time: 53192 ms
Total hot run time: 51128 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #58397:
URL: https://github.com/apache/doris/pull/58397
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3601171979
<details>
<summary>TPC-H: <b>Total hot run time: 34293 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 9215d4ba6b8462e81e13e33f6a533a7d60f3a2b4, data reload: false
------ Round 1 ----------------------------------
q1 17622 5054 4898 4898
q2 2114 323 210 210
q3 10199 1323 732 732
q4 10197 810 331 331
q5 7473 2399 2189 2189
q6 190 182 140 140
q7 946 804 644 644
q8 9373 1415 1099 1099
q9 7037 5420 5348 5348
q10 6771 2185 1793 1793
q11 520 322 290 290
q12 347 365 222 222
q13 17772 3667 3027 3027
q14 244 238 214 214
q15 602 515 513 513
q16 901 869 814 814
q17 679 846 500 500
q18 7487 7086 7018 7018
q19 1105 975 603 603
q20 360 352 236 236
q21 4034 3595 2521 2521
q22 1010 992 951 951
Total cold run time: 106983 ms
Total hot run time: 34293 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5192 4919 4968 4919
q2 340 394 325 325
q3 2156 2658 2254 2254
q4 1331 1819 1295 1295
q5 4225 4494 4593 4494
q6 240 181 134 134
q7 2073 1941 1841 1841
q8 2666 2619 2602 2602
q9 7625 7481 7540 7481
q10 3068 3425 2843 2843
q11 611 538 499 499
q12 641 702 602 602
q13 3687 3992 3312 3312
q14 299 313 286 286
q15 550 522 500 500
q16 890 934 892 892
q17 1259 1589 1395 1395
q18 7966 7715 7577 7577
q19 904 882 912 882
q20 2054 2087 1901 1901
q21 4996 4542 4172 4172
q22 1095 1071 985 985
Total cold run time: 53868 ms
Total hot run time: 51191 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3585721228
<details>
<summary>ClickBench: <b>Total hot run time: 27.43 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit a9658b378e7db5c16ea2aebec982c43905dd359d, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.04 0.05
query3 0.25 0.09 0.09
query4 1.61 0.12 0.11
query5 0.28 0.26 0.26
query6 1.17 0.66 0.63
query7 0.03 0.03 0.02
query8 0.05 0.04 0.04
query9 0.57 0.50 0.50
query10 0.55 0.56 0.56
query11 0.16 0.11 0.12
query12 0.15 0.12 0.11
query13 0.63 0.60 0.60
query14 0.98 0.99 1.00
query15 0.82 0.80 0.79
query16 0.42 0.41 0.39
query17 1.02 1.07 1.06
query18 0.25 0.22 0.20
query19 1.92 1.88 1.85
query20 0.01 0.01 0.01
query21 15.45 0.27 0.14
query22 4.76 0.05 0.05
query23 16.04 0.26 0.10
query24 1.09 0.73 0.42
query25 0.08 0.06 0.05
query26 0.14 0.14 0.13
query27 0.08 0.05 0.06
query28 4.79 1.20 1.02
query29 12.59 3.83 3.16
query30 0.27 0.14 0.11
query31 2.81 0.63 0.40
query32 3.24 0.56 0.46
query33 3.11 3.07 3.07
query34 16.64 5.15 4.48
query35 4.55 4.61 4.56
query36 0.67 0.51 0.48
query37 0.10 0.06 0.06
query38 0.07 0.04 0.04
query39 0.04 0.03 0.02
query40 0.17 0.14 0.13
query41 0.09 0.03 0.03
query42 0.05 0.03 0.03
query43 0.04 0.03 0.04
Total cold run time: 97.89 s
Total hot run time: 27.43 s
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3588799139
<details>
<summary>ClickBench: <b>Total hot run time: 27.33 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 804f338d09c509d0b3b855ca45b85e842c6c7584, data reload: false
query1 0.05 0.04 0.05
query2 0.10 0.05 0.05
query3 0.25 0.09 0.08
query4 1.60 0.12 0.11
query5 0.28 0.25 0.26
query6 1.17 0.64 0.63
query7 0.03 0.02 0.03
query8 0.06 0.04 0.04
query9 0.57 0.53 0.51
query10 0.56 0.55 0.56
query11 0.17 0.11 0.11
query12 0.14 0.12 0.11
query13 0.63 0.61 0.60
query14 0.99 0.99 0.98
query15 0.83 0.83 0.79
query16 0.40 0.40 0.41
query17 1.05 1.05 1.07
query18 0.23 0.20 0.21
query19 1.83 1.78 1.86
query20 0.01 0.01 0.01
query21 15.48 0.27 0.14
query22 4.79 0.05 0.05
query23 16.01 0.26 0.11
query24 1.29 0.29 0.25
query25 0.05 0.04 0.05
query26 0.14 0.13 0.14
query27 0.06 0.09 0.06
query28 3.17 1.20 1.02
query29 12.58 3.90 3.33
query30 0.29 0.13 0.12
query31 2.83 0.60 0.41
query32 3.23 0.54 0.46
query33 3.04 3.04 3.08
query34 17.03 5.23 4.50
query35 4.57 4.52 4.56
query36 0.66 0.49 0.50
query37 0.11 0.07 0.06
query38 0.07 0.04 0.04
query39 0.04 0.03 0.03
query40 0.17 0.15 0.13
query41 0.09 0.04 0.03
query42 0.04 0.03 0.03
query43 0.05 0.03 0.03
Total cold run time: 96.74 s
Total hot run time: 27.33 s
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3586547832
# FE Regression Coverage Report
Increment line coverage ` 83.11% (123/148)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58397_a9658b378e7db5c16ea2aebec982c43905dd359d_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58397_a9658b378e7db5c16ea2aebec982c43905dd359d_merge_fe/report/index.html)
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3600114306
<details>
<summary>TPC-DS: <b>Total hot run time: 182336 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 5001f725c4cf053e12c1cd1aec19ea2f42cea179, data reload: false
query1 1028 415 420 415
query2 6570 1168 1146 1146
query3 6739 228 221 221
query4 25298 23224 22994 22994
query5 5027 634 514 514
query6 351 243 224 224
query7 4683 516 309 309
query8 307 249 244 244
query9 8727 2644 2658 2644
query10 517 352 314 314
query11 15211 14961 14859 14859
query12 196 121 116 116
query13 1696 578 437 437
query14 9389 6097 6133 6097
query15 215 207 185 185
query16 7672 710 544 544
query17 1210 788 647 647
query18 2044 437 346 346
query19 228 206 186 186
query20 131 128 122 122
query21 217 134 115 115
query22 3895 4015 3932 3932
query23 33370 32021 31806 31806
query24 8483 2456 2455 2455
query25 656 573 500 500
query26 1251 279 174 174
query27 2693 497 352 352
query28 4328 2170 2147 2147
query29 818 659 525 525
query30 323 243 220 220
query31 840 719 623 623
query32 87 75 78 75
query33 610 404 365 365
query34 819 862 532 532
query35 805 882 742 742
query36 902 936 845 845
query37 119 109 88 88
query38 3901 3830 3845 3830
query39 1488 1420 1411 1411
query40 225 135 118 118
query41 66 62 63 62
query42 124 123 112 112
query43 420 433 426 426
query44 1319 764 747 747
query45 199 194 188 188
query46 869 997 643 643
query47 1651 1745 1636 1636
query48 391 416 336 336
query49 765 498 412 412
query50 663 685 423 423
query51 3887 3859 3908 3859
query52 114 121 112 112
query53 240 266 194 194
query54 320 305 289 289
query55 98 92 93 92
query56 345 332 320 320
query57 1139 1193 1083 1083
query58 287 285 292 285
query59 2282 2410 2287 2287
query60 367 359 374 359
query61 158 160 159 159
query62 772 700 659 659
query63 240 201 204 201
query64 4484 1239 914 914
query65 4030 3935 3994 3935
query66 1120 425 348 348
query67 15088 14970 14838 14838
query68 8295 956 616 616
query69 517 346 311 311
query70 1123 1040 1020 1020
query71 488 341 315 315
query72 5818 4928 4861 4861
query73 722 579 338 338
query74 8724 8714 8664 8664
query75 3666 3023 2556 2556
query76 3839 1130 750 750
query77 815 416 319 319
query78 9442 9619 8846 8846
query79 1200 844 581 581
query80 781 585 524 524
query81 468 268 237 237
query82 204 136 123 123
query83 311 270 262 262
query84 297 116 99 99
query85 908 490 455 455
query86 334 287 287 287
query87 4024 4060 3991 3991
query88 2836 2296 2279 2279
query89 390 329 304 304
query90 2091 230 218 218
query91 170 174 159 159
query92 85 72 73 72
query93 1106 997 670 670
query94 718 456 336 336
query95 514 420 413 413
query96 519 538 281 281
query97 2598 2677 2620 2620
query98 245 222 215 215
query99 1406 1384 1276 1276
Total cold run time: 269161 ms
Total hot run time: 182336 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3601066031
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3580315449
<details>
<summary>TPC-H: <b>Total hot run time: 34505 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 6d8f0dbb5122d1cef67ebf54bdb7d4ed051a06c4, data reload: false
------ Round 1 ----------------------------------
============================================
q1 17593 5124 4880 4880
q2 2082 319 214 214
q3 10179 1295 717 717
q4 10235 966 387 387
q5 q6 1530 245 141 141
q7 5048 533 529 529
q8 12910 840 573 573
q9 15771 5209 5264 5209
q10 7517 2877 2470 2470
q11 511 312 302 302
q12 376 363 214 214
q13 17806 3639 3073 3073
q14 251 237 218 218
q15 662 519 512 512
q16 937 929 867 867
q17 600 869 378 378
q18 7457 7055 7041 7041
q19 1111 1005 573 573
q20 376 376 260 260
q21 6291 5862 5631 5631
q22 404 347 316 316
Total cold run time: 119647 ms
Total hot run time: 34505 ms
----- Round 2, with runtime_filter_mode=off -----
============================================
q1 5454 5271 5154 5154
q2 264 359 237 237
q3 2453 2888 2521 2521
q4 1456 1893 1411 1411
q5 q6 2256 219 124 124
q7 10142 4996 4945 4945
q8 20040 3350 3403 3350
q9 15272 14992 14984 14984
q10 3400 3706 3372 3372
q11 578 490 481 481
q12 1019 744 567 567
q13 3309 3661 3080 3080
q14 268 310 273 273
q15 538 512 502 502
q16 1086 1085 1067 1067
q17 2199 2496 2331 2331
q18 7303 7188 7086 7086
q19 770 764 855 764
q20 1899 1947 1829 1829
q21 11817 9930 10386 9930
q22 628 565 517 517
Total cold run time: 92151 ms
Total hot run time: 64525 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3584805437
<details>
<summary>TPC-DS: <b>Total hot run time: 185296 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit a663f5d58f0fb052aa2e41a11be45b6b82ced97e, data reload: false
query1 1051 440 386 386
query2 6580 1642 1574 1574
query3 6752 231 228 228
query4 25814 22738 22595 22595
query5 4462 629 471 471
query6 338 244 228 228
query7 4643 505 300 300
query8 316 253 247 247
query9 8696 2591 2610 2591
query10 533 368 337 337
query11 15289 14974 14660 14660
query12 194 122 118 118
query13 1690 590 471 471
query14 10712 8982 8996 8982
query15 217 212 187 187
query16 7463 675 500 500
query17 1264 766 664 664
query18 2002 425 333 333
query19 208 193 170 170
query20 129 129 119 119
query21 213 134 115 115
query22 3800 4066 4043 4043
query23 32899 32035 32253 32035
query24 8541 2362 2402 2362
query25 596 529 453 453
query26 1249 274 167 167
query27 2761 490 333 333
query28 4407 2146 2104 2104
query29 793 618 489 489
query30 309 243 211 211
query31 824 708 641 641
query32 110 77 67 67
query33 597 389 326 326
query34 800 884 530 530
query35 814 849 758 758
query36 934 953 858 858
query37 123 110 87 87
query38 3353 3325 3289 3289
query39 1489 1433 1409 1409
query40 216 125 120 120
query41 66 65 64 64
query42 125 117 119 117
query43 462 479 452 452
query44 1250 760 742 742
query45 197 192 187 187
query46 888 1000 651 651
query47 1712 1742 1655 1655
query48 391 434 331 331
query49 782 492 420 420
query50 656 705 406 406
query51 3861 3975 3949 3949
query52 108 113 102 102
query53 238 280 191 191
query54 321 304 275 275
query55 97 91 90 90
query56 347 339 321 321
query57 1159 1182 1093 1093
query58 306 283 278 278
query59 2409 2587 2387 2387
query60 358 358 355 355
query61 166 162 189 162
query62 783 710 673 673
query63 220 196 191 191
query64 4540 1193 889 889
query65 4095 3962 3972 3962
query66 1170 454 321 321
query67 15209 14935 14940 14935
query68 4662 980 637 637
query69 515 340 300 300
query70 1375 1275 1228 1228
query71 416 343 316 316
query72 6026 5121 5128 5121
query73 648 570 345 345
query74 8867 8730 8577 8577
query75 3315 3379 2888 2888
query76 3291 1135 741 741
query77 535 420 330 330
query78 9485 9768 8974 8974
query79 2168 847 592 592
query80 831 603 530 530
query81 516 273 242 242
query82 406 167 147 147
query83 335 263 256 256
query84 265 118 103 103
query85 905 493 453 453
query86 436 314 282 282
query87 3522 3493 3445 3445
query88 3197 2296 2285 2285
query89 387 331 293 293
query90 1959 227 218 218
query91 182 177 144 144
query92 80 70 66 66
query93 2594 981 652 652
query94 749 450 315 315
query95 506 411 402 402
query96 515 579 298 298
query97 2945 2983 2839 2839
query98 235 215 204 204
query99 1300 1413 1316 1316
Total cold run time: 268265 ms
Total hot run time: 185296 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3584823101
<details>
<summary>ClickBench: <b>Total hot run time: 27.63 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit a663f5d58f0fb052aa2e41a11be45b6b82ced97e, data reload: false
query1 0.05 0.05 0.05
query2 0.09 0.05 0.05
query3 0.26 0.08 0.08
query4 1.62 0.12 0.11
query5 0.29 0.25 0.26
query6 1.20 0.65 0.64
query7 0.04 0.03 0.02
query8 0.05 0.04 0.05
query9 0.60 0.53 0.51
query10 0.58 0.58 0.56
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.62 0.60 0.60
query14 1.02 1.00 1.00
query15 0.85 0.86 0.83
query16 0.39 0.38 0.38
query17 1.04 1.02 1.02
query18 0.21 0.19 0.20
query19 1.86 1.87 1.81
query20 0.02 0.01 0.01
query21 15.43 0.20 0.13
query22 5.07 0.08 0.05
query23 15.68 0.26 0.10
query24 2.71 1.14 0.52
query25 0.07 0.07 0.06
query26 0.15 0.14 0.12
query27 0.07 0.05 0.06
query28 4.63 1.13 0.93
query29 12.55 3.84 3.21
query30 0.27 0.14 0.11
query31 2.82 0.59 0.40
query32 3.26 0.56 0.46
query33 2.99 3.15 3.15
query34 15.82 5.11 4.58
query35 4.64 4.53 4.58
query36 0.67 0.50 0.52
query37 0.10 0.06 0.07
query38 0.07 0.04 0.04
query39 0.04 0.03 0.02
query40 0.16 0.14 0.14
query41 0.08 0.03 0.04
query42 0.04 0.03 0.03
query43 0.04 0.03 0.03
Total cold run time: 98.46 s
Total hot run time: 27.63 s
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3588784530
<details>
<summary>TPC-DS: <b>Total hot run time: 181661 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 804f338d09c509d0b3b855ca45b85e842c6c7584, data reload: false
query1 1049 409 402 402
query2 6632 1213 1157 1157
query3 6755 228 235 228
query4 25500 23448 22768 22768
query5 5132 649 486 486
query6 341 247 219 219
query7 4646 524 305 305
query8 302 280 247 247
query9 8724 2608 2582 2582
query10 585 366 313 313
query11 15601 14847 14531 14531
query12 187 121 114 114
query13 1702 586 464 464
query14 9651 6040 5922 5922
query15 216 197 192 192
query16 7695 707 546 546
query17 1282 773 649 649
query18 2059 437 348 348
query19 221 207 187 187
query20 138 128 124 124
query21 225 143 119 119
query22 3939 4150 3996 3996
query23 33088 32145 32082 32082
query24 8535 2426 2450 2426
query25 640 560 495 495
query26 1274 285 171 171
query27 2707 505 345 345
query28 4335 2167 2133 2133
query29 838 670 536 536
query30 327 248 214 214
query31 848 729 620 620
query32 92 75 82 75
query33 632 393 400 393
query34 808 872 539 539
query35 793 837 730 730
query36 896 927 861 861
query37 127 108 90 90
query38 3828 3829 3828 3828
query39 1506 1403 1389 1389
query40 225 145 123 123
query41 70 62 63 62
query42 126 110 110 110
query43 454 457 424 424
query44 1326 759 771 759
query45 205 194 184 184
query46 869 978 654 654
query47 1724 1736 1655 1655
query48 400 418 332 332
query49 757 484 439 439
query50 654 688 419 419
query51 3874 3877 3961 3877
query52 116 112 106 106
query53 249 264 187 187
query54 307 295 280 280
query55 97 93 89 89
query56 337 334 313 313
query57 1162 1152 1101 1101
query58 287 274 267 267
query59 2287 2436 2383 2383
query60 364 354 339 339
query61 162 154 159 154
query62 798 721 643 643
query63 232 194 192 192
query64 4545 1231 899 899
query65 4059 3977 3957 3957
query66 1106 449 335 335
query67 15234 15152 14908 14908
query68 8467 962 629 629
query69 517 339 290 290
query70 1073 1002 1041 1002
query71 512 334 314 314
query72 5805 4919 4800 4800
query73 729 571 340 340
query74 8840 8952 8651 8651
query75 3714 3000 2443 2443
query76 3842 1124 742 742
query77 811 385 313 313
query78 9563 9698 8871 8871
query79 2208 822 585 585
query80 627 567 487 487
query81 520 274 237 237
query82 458 145 114 114
query83 271 254 247 247
query84 267 108 98 98
query85 919 479 444 444
query86 390 297 298 297
query87 4009 4058 4072 4058
query88 4101 2256 2269 2256
query89 389 333 291 291
query90 1946 219 219 219
query91 172 168 141 141
query92 83 66 67 66
query93 1836 988 665 665
query94 712 453 336 336
query95 501 405 408 405
query96 515 549 284 284
query97 2594 2709 2567 2567
query98 259 219 210 210
query99 1387 1385 1242 1242
Total cold run time: 273919 ms
Total hot run time: 181661 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3600092811
<details>
<summary>TPC-H: <b>Total hot run time: 34137 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 5001f725c4cf053e12c1cd1aec19ea2f42cea179, data reload: false
------ Round 1 ----------------------------------
q1 17655 5097 4941 4941
q2 2037 305 207 207
q3 10271 1323 737 737
q4 10215 792 320 320
q5 7511 2369 2125 2125
q6 189 173 142 142
q7 962 789 636 636
q8 9351 1311 1053 1053
q9 7033 5302 5338 5302
q10 6832 2201 1779 1779
q11 530 310 309 309
q12 365 369 224 224
q13 17767 3658 3059 3059
q14 239 227 216 216
q15 584 528 509 509
q16 859 880 820 820
q17 593 718 527 527
q18 7536 7057 7045 7045
q19 1611 1088 579 579
q20 346 354 222 222
q21 3521 3053 2420 2420
q22 1050 992 965 965
Total cold run time: 107057 ms
Total hot run time: 34137 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5016 4952 4896 4896
q2 332 389 307 307
q3 2165 2724 2283 2283
q4 1312 1757 1271 1271
q5 4240 4339 4588 4339
q6 215 179 136 136
q7 2050 2037 1879 1879
q8 2610 2525 2459 2459
q9 7626 7528 7415 7415
q10 3063 3331 2805 2805
q11 604 518 512 512
q12 718 767 617 617
q13 3506 4004 3308 3308
q14 287 298 300 298
q15 568 524 521 521
q16 917 898 877 877
q17 1158 1377 1410 1377
q18 7860 7789 7375 7375
q19 830 776 757 757
q20 2002 2038 1798 1798
q21 4728 4233 4134 4134
q22 1081 1046 989 989
Total cold run time: 52888 ms
Total hot run time: 50353 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3584266270
<details>
<summary>TPC-H: <b>Total hot run time: 34532 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit dba1546d8bc3bdd27b7a66d9eed44a66daabf0d1, data reload: false
------ Round 1 ----------------------------------
============================================
q1 17599 5163 4901 4901
q2 2011 317 197 197
q3 10278 1292 746 746
q4 10234 932 367 367
q5 q6 1537 239 142 142
q7 5047 529 508 508
q8 12933 813 535 535
q9 15738 5240 5255 5240
q10 7517 2879 2472 2472
q11 500 313 297 297
q12 372 357 223 223
q13 17812 3711 3061 3061
q14 245 236 217 217
q15 625 513 510 510
q16 940 906 851 851
q17 592 867 377 377
q18 7491 7069 7052 7052
q19 1096 969 598 598
q20 390 389 255 255
q21 6434 5796 5691 5691
q22 366 317 292 292
Total cold run time: 119757 ms
Total hot run time: 34532 ms
----- Round 2, with runtime_filter_mode=off -----
============================================
q1 5435 5160 5210 5160
q2 277 370 253 253
q3 2469 2872 2552 2552
q4 1440 1891 1538 1538
q5 q6 2289 200 120 120
q7 10293 4990 4933 4933
q8 24236 3334 3438 3334
q9 15313 15067 14928 14928
q10 3500 3703 3353 3353
q11 564 503 476 476
q12 1041 775 565 565
q13 3337 3737 3083 3083
q14 266 296 253 253
q15 553 494 497 494
q16 1124 1129 1102 1102
q17 2161 2394 2313 2313
q18 7262 7085 6999 6999
q19 787 804 849 804
q20 1900 1943 1830 1830
q21 11943 10119 10178 10119
q22 604 638 526 526
Total cold run time: 96794 ms
Total hot run time: 64735 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3585650076
<details>
<summary>TPC-H: <b>Total hot run time: 34353 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit a9658b378e7db5c16ea2aebec982c43905dd359d, data reload: false
------ Round 1 ----------------------------------
q1 17647 5099 4875 4875
q2 2024 321 214 214
q3 10262 1317 724 724
q4 10229 937 362 362
q5 7530 2489 2282 2282
q6 199 175 142 142
q7 946 783 649 649
q8 9350 1350 1044 1044
q9 7352 5341 5280 5280
q10 6912 2244 1801 1801
q11 545 328 287 287
q12 385 369 221 221
q13 17787 3688 3042 3042
q14 234 226 215 215
q15 588 520 513 513
q16 1048 1000 984 984
q17 601 813 449 449
q18 7831 7094 7426 7094
q19 1245 987 558 558
q20 342 340 235 235
q21 3556 3147 2429 2429
q22 1043 999 953 953
Total cold run time: 107656 ms
Total hot run time: 34353 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4993 4960 4974 4960
q2 336 402 315 315
q3 2155 2707 2278 2278
q4 1324 1762 1270 1270
q5 4200 4490 4625 4490
q6 229 183 142 142
q7 1995 2052 1827 1827
q8 2657 2534 2562 2534
q9 7609 7526 7448 7448
q10 3038 3330 2786 2786
q11 601 511 496 496
q12 688 827 628 628
q13 3523 3920 3333 3333
q14 297 317 292 292
q15 552 578 632 578
q16 1093 1112 1074 1074
q17 1159 1432 1360 1360
q18 8191 7659 7401 7401
q19 822 791 812 791
q20 1997 2013 1800 1800
q21 4595 4179 4133 4133
q22 1039 1026 1004 1004
Total cold run time: 53093 ms
Total hot run time: 50940 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3585698474
<details>
<summary>TPC-DS: <b>Total hot run time: 184558 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit a9658b378e7db5c16ea2aebec982c43905dd359d, data reload: false
query1 1102 410 396 396
query2 6565 1528 1593 1528
query3 6754 231 225 225
query4 25397 23276 22991 22991
query5 4909 597 446 446
query6 329 236 211 211
query7 4644 505 303 303
query8 305 270 241 241
query9 8705 2566 2562 2562
query10 551 370 343 343
query11 15285 15337 14932 14932
query12 178 119 112 112
query13 1661 543 428 428
query14 10987 8930 8856 8856
query15 217 201 182 182
query16 7508 693 517 517
query17 1179 726 669 669
query18 2033 424 330 330
query19 208 197 176 176
query20 129 122 125 122
query21 224 133 115 115
query22 3883 3893 3892 3892
query23 32946 31998 32105 31998
query24 8570 2414 2350 2350
query25 617 502 448 448
query26 1241 275 166 166
query27 2737 505 336 336
query28 4384 2126 2127 2126
query29 772 637 483 483
query30 311 235 209 209
query31 834 699 639 639
query32 84 73 75 73
query33 621 388 328 328
query34 821 857 522 522
query35 813 820 741 741
query36 863 925 830 830
query37 122 115 91 91
query38 3293 3348 3286 3286
query39 1492 1432 1402 1402
query40 220 135 118 118
query41 65 64 63 63
query42 122 118 112 112
query43 414 451 436 436
query44 1277 746 744 744
query45 193 193 182 182
query46 874 982 641 641
query47 1665 1712 1655 1655
query48 397 441 328 328
query49 791 511 435 435
query50 662 704 410 410
query51 3874 4012 3803 3803
query52 116 116 105 105
query53 244 260 206 206
query54 333 302 301 301
query55 101 99 95 95
query56 355 341 335 335
query57 1142 1163 1088 1088
query58 295 295 293 293
query59 2356 2345 2383 2345
query60 378 360 362 360
query61 196 190 187 187
query62 796 718 654 654
query63 233 198 205 198
query64 4574 1306 993 993
query65 4049 4010 3978 3978
query66 1155 447 353 353
query67 15174 14906 14988 14906
query68 8311 940 630 630
query69 510 353 325 325
query70 1334 1155 1107 1107
query71 458 346 322 322
query72 5990 4774 4726 4726
query73 656 572 337 337
query74 8856 8789 8578 8578
query75 3546 3319 2855 2855
query76 3491 1128 707 707
query77 742 402 320 320
query78 9598 9597 8854 8854
query79 2512 905 596 596
query80 660 593 486 486
query81 496 273 240 240
query82 240 163 129 129
query83 284 253 260 253
query84 268 111 93 93
query85 908 490 445 445
query86 383 297 296 296
query87 3496 3522 3342 3342
query88 4357 2259 2210 2210
query89 395 328 292 292
query90 1988 222 211 211
query91 174 173 134 134
query92 88 70 64 64
query93 2347 1002 661 661
query94 740 425 350 350
query95 495 413 397 397
query96 506 555 288 288
query97 2895 2997 2845 2845
query98 245 220 213 213
query99 1316 1419 1323 1323
Total cold run time: 273610 ms
Total hot run time: 184558 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3588472718
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3588751387
# FE UT Coverage Report
Increment line coverage ` 69.93% (107/153)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58397_804f338d09c509d0b3b855ca45b85e842c6c7584/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58397_804f338d09c509d0b3b855ca45b85e842c6c7584/fe_report/index.html)
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3601221300
<details>
<summary>TPC-DS: <b>Total hot run time: 183403 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 9215d4ba6b8462e81e13e33f6a533a7d60f3a2b4, data reload: false
query1 1052 420 406 406
query2 6633 1195 1190 1190
query3 6742 238 234 234
query4 25566 23579 23025 23025
query5 5701 688 523 523
query6 346 256 232 232
query7 4666 524 318 318
query8 323 260 245 245
query9 8746 2682 2691 2682
query10 564 359 310 310
query11 15362 14767 14848 14767
query12 188 127 117 117
query13 1702 588 455 455
query14 10235 6140 6127 6127
query15 236 202 202 202
query16 7725 705 528 528
query17 1617 815 647 647
query18 2064 458 363 363
query19 249 212 188 188
query20 135 130 125 125
query21 226 147 119 119
query22 3877 4113 3924 3924
query23 33209 32113 32302 32113
query24 8354 2451 2506 2451
query25 643 571 501 501
query26 1244 300 182 182
query27 2655 514 354 354
query28 4385 2219 2188 2188
query29 819 665 536 536
query30 329 251 218 218
query31 818 728 659 659
query32 90 83 80 80
query33 667 406 338 338
query34 838 876 542 542
query35 809 826 756 756
query36 882 932 852 852
query37 122 124 94 94
query38 3831 3916 3736 3736
query39 1463 1405 1408 1405
query40 234 137 122 122
query41 69 67 63 63
query42 129 118 117 117
query43 445 461 427 427
query44 1362 768 754 754
query45 206 193 185 185
query46 918 1033 665 665
query47 1676 1754 1631 1631
query48 401 436 333 333
query49 809 534 416 416
query50 700 721 411 411
query51 3846 3868 3924 3868
query52 118 115 110 110
query53 260 273 196 196
query54 329 303 294 294
query55 97 97 96 96
query56 343 332 330 330
query57 1163 1161 1109 1109
query58 293 292 268 268
query59 2324 2435 2405 2405
query60 384 368 359 359
query61 171 168 161 161
query62 786 735 679 679
query63 232 199 199 199
query64 4486 1221 905 905
query65 4102 3999 4001 3999
query66 1044 444 342 342
query67 15541 15115 15048 15048
query68 8291 1039 623 623
query69 557 353 313 313
query70 1133 990 1007 990
query71 528 361 321 321
query72 5820 4898 4913 4898
query73 729 585 348 348
query74 8569 8832 8715 8715
query75 3796 3050 2523 2523
query76 3710 1173 771 771
query77 821 435 326 326
query78 9465 9502 8855 8855
query79 2630 857 592 592
query80 764 573 526 526
query81 501 270 242 242
query82 495 145 113 113
query83 271 267 245 245
query84 280 125 95 95
query85 921 511 455 455
query86 360 295 294 294
query87 4068 4066 4078 4066
query88 4262 2328 2330 2328
query89 396 338 302 302
query90 1972 223 219 219
query91 177 173 146 146
query92 88 77 66 66
query93 2259 1039 657 657
query94 735 446 350 350
query95 504 433 415 415
query96 557 570 294 294
query97 2617 2683 2585 2585
query98 249 224 213 213
query99 1369 1405 1293 1293
Total cold run time: 276475 ms
Total hot run time: 183403 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3584582992
# FE Regression Coverage Report
Increment line coverage ` 82.17% (106/129)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58397_dba1546d8bc3bdd27b7a66d9eed44a66daabf0d1_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58397_dba1546d8bc3bdd27b7a66d9eed44a66daabf0d1_merge_fe/report/index.html)
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3588193536
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3604814649
PR approved by at least one committer and no changes requested.
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3601776643
# FE Regression Coverage Report
Increment line coverage ` 84.21% (128/152)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58397_9215d4ba6b8462e81e13e33f6a533a7d60f3a2b4_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58397_9215d4ba6b8462e81e13e33f6a533a7d60f3a2b4_merge_fe/report/index.html)
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3579842675
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3580940878
# FE Regression Coverage Report
Increment line coverage ` 86.29% (107/124)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58397_6d8f0dbb5122d1cef67ebf54bdb7d4ed051a06c4_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58397_6d8f0dbb5122d1cef67ebf54bdb7d4ed051a06c4_merge_fe/report/index.html)
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3585237916
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3588270478
<details>
<summary>TPC-H: <b>Total hot run time: 34387 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 05602b62a735bbc6684f25cb9b96cfa5969c17e1, data reload: false
------ Round 1 ----------------------------------
q1 17619 4950 4898 4898
q2 2093 311 211 211
q3 10225 1299 712 712
q4 10230 887 368 368
q5 7509 2411 2244 2244
q6 196 174 141 141
q7 931 786 652 652
q8 9358 1337 1024 1024
q9 6901 5312 5276 5276
q10 6872 2218 1814 1814
q11 496 315 292 292
q12 340 366 228 228
q13 18333 3689 3180 3180
q14 249 243 215 215
q15 616 531 517 517
q16 925 869 832 832
q17 612 770 512 512
q18 7608 7259 7108 7108
q19 1199 957 585 585
q20 355 350 238 238
q21 4074 3227 2358 2358
q22 1044 1046 982 982
Total cold run time: 107785 ms
Total hot run time: 34387 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5005 5005 4924 4924
q2 352 415 319 319
q3 2140 2632 2356 2356
q4 1321 1770 1284 1284
q5 4258 4437 4549 4437
q6 219 178 138 138
q7 2068 1974 1796 1796
q8 2691 2502 2536 2502
q9 7397 7488 7441 7441
q10 3027 3232 2894 2894
q11 579 564 492 492
q12 678 749 592 592
q13 3642 3873 3290 3290
q14 304 296 294 294
q15 575 515 549 515
q16 1013 937 869 869
q17 1166 1448 1409 1409
q18 7824 7700 7513 7513
q19 789 770 819 770
q20 1949 2068 2127 2068
q21 4731 4409 4144 4144
q22 1067 1040 964 964
Total cold run time: 52795 ms
Total hot run time: 51011 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3600123184
<details>
<summary>ClickBench: <b>Total hot run time: 27.16 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 5001f725c4cf053e12c1cd1aec19ea2f42cea179, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.05
query3 0.25 0.09 0.09
query4 1.60 0.12 0.11
query5 0.26 0.25 0.26
query6 1.17 0.66 0.62
query7 0.03 0.02 0.02
query8 0.06 0.04 0.05
query9 0.56 0.51 0.50
query10 0.56 0.55 0.56
query11 0.16 0.11 0.12
query12 0.16 0.12 0.11
query13 0.63 0.60 0.61
query14 1.01 0.99 0.97
query15 0.83 0.79 0.79
query16 0.41 0.39 0.39
query17 1.05 1.06 1.08
query18 0.23 0.21 0.21
query19 1.90 1.76 1.72
query20 0.02 0.01 0.01
query21 15.41 0.28 0.14
query22 4.81 0.04 0.04
query23 16.03 0.26 0.10
query24 1.08 0.28 0.17
query25 0.05 0.06 0.08
query26 0.14 0.14 0.13
query27 0.06 0.07 0.04
query28 3.26 1.22 1.03
query29 12.66 3.92 3.33
query30 0.28 0.15 0.11
query31 2.81 0.60 0.40
query32 3.22 0.55 0.46
query33 3.00 3.02 3.14
query34 16.91 5.21 4.53
query35 4.51 4.53 4.58
query36 0.67 0.50 0.49
query37 0.11 0.06 0.07
query38 0.07 0.04 0.03
query39 0.05 0.03 0.03
query40 0.17 0.14 0.13
query41 0.09 0.03 0.02
query42 0.05 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 96.52 s
Total hot run time: 27.16 s
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3600449683
# FE Regression Coverage Report
Increment line coverage ` 84.21% (128/152)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58397_5001f725c4cf053e12c1cd1aec19ea2f42cea179_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58397_5001f725c4cf053e12c1cd1aec19ea2f42cea179_merge_fe/report/index.html)
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](grouping set) remove virtual slot reference [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #58397:
URL: https://github.com/apache/doris/pull/58397#issuecomment-3599936970
run buildall
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org