You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Mryange (via GitHub)" <gi...@apache.org> on 2025/12/01 10:36:16 UTC
[PR] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Mryange opened a new pull request, #58578:
URL: https://github.com/apache/doris/pull/58578
### What problem does this PR solve?
Previously, when executing an expr we relied on block.rows() to determine the number of rows to return. That required guaranteeing the block was not empty and that the first column (since block.rows() is implemented from it) had the final desired row count. Now we pass a count parameter to indicate the size each expr should return for its Column.
before
```C++
vectorized::Block tmp_block;
tmp_block.insert({vectorized::ColumnUInt8::create(1),
std::make_shared<vectorized::DataTypeUInt8>(), ""});
RETURN_IF_ERROR(_const_expr_lists[_const_expr_list_idx][i]->execute(&tmp_block,
&result_list[i]));
```
now
```C++
RETURN_IF_ERROR(_const_expr_lists[_const_expr_list_idx][i]->execute_const_expr(
tmp_block_columns[i]));
Status VExprContext::execute_const_expr(ColumnWithTypeAndName& result) {
Status st;
RETURN_IF_CATCH_EXCEPTION({ st = _root->execute_column(this, nullptr, 1, result.column); });
```
### 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)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3600058580
<details>
<summary>ClickBench: <b>Total hot run time: 27.27 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 85ed7ea1ae5e0a8b18c4478943bd45988b181cbd, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.05
query3 0.26 0.08 0.08
query4 1.61 0.12 0.11
query5 0.29 0.27 0.25
query6 1.18 0.65 0.63
query7 0.03 0.02 0.03
query8 0.06 0.04 0.05
query9 0.56 0.50 0.49
query10 0.56 0.57 0.55
query11 0.17 0.12 0.11
query12 0.15 0.11 0.12
query13 0.64 0.60 0.61
query14 1.01 0.98 0.98
query15 0.82 0.80 0.80
query16 0.38 0.41 0.40
query17 1.03 1.05 1.02
query18 0.23 0.21 0.21
query19 1.84 1.73 1.89
query20 0.02 0.01 0.02
query21 15.45 0.28 0.14
query22 4.75 0.05 0.05
query23 16.08 0.27 0.10
query24 1.00 0.67 0.30
query25 0.10 0.06 0.05
query26 0.14 0.14 0.14
query27 0.10 0.04 0.05
query28 3.14 1.23 1.02
query29 12.59 3.91 3.23
query30 0.29 0.14 0.12
query31 2.81 0.60 0.40
query32 3.23 0.54 0.46
query33 2.99 3.02 3.13
query34 16.77 5.16 4.59
query35 4.55 4.55 4.54
query36 0.67 0.49 0.48
query37 0.10 0.06 0.07
query38 0.07 0.05 0.04
query39 0.04 0.02 0.02
query40 0.18 0.14 0.14
query41 0.08 0.03 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 96.2 s
Total hot run time: 27.27 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3601329844
<details>
<summary>TPC-H: <b>Total hot run time: 34804 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 92eb709a93362eb94acaee7c6bc96ca13a5d6dee, data reload: false
------ Round 1 ----------------------------------
q1 17604 5026 4952 4952
q2 2035 318 213 213
q3 10254 1328 727 727
q4 10232 897 325 325
q5 7546 2283 2327 2283
q6 184 167 136 136
q7 956 784 648 648
q8 9361 1495 1088 1088
q9 7131 5342 5391 5342
q10 6855 2186 1789 1789
q11 525 308 290 290
q12 378 378 233 233
q13 17785 3729 3026 3026
q14 235 238 217 217
q15 610 519 502 502
q16 912 872 828 828
q17 685 793 569 569
q18 7534 7310 7163 7163
q19 1100 979 592 592
q20 370 349 233 233
q21 4001 3862 2689 2689
q22 1063 997 959 959
Total cold run time: 107356 ms
Total hot run time: 34804 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5016 4969 4970 4969
q2 342 413 317 317
q3 2150 2660 2271 2271
q4 1319 1761 1310 1310
q5 4300 4616 4646 4616
q6 227 177 134 134
q7 2054 1913 1871 1871
q8 2680 2526 2557 2526
q9 7568 7539 7551 7539
q10 3077 3280 2856 2856
q11 598 515 496 496
q12 736 766 580 580
q13 3527 3984 3286 3286
q14 281 306 299 299
q15 556 524 508 508
q16 916 936 884 884
q17 1240 1419 1419 1419
q18 8095 7823 7455 7455
q19 915 927 912 912
q20 2005 1964 1865 1865
q21 4684 4227 4155 4155
q22 1068 1050 961 961
Total cold run time: 53354 ms
Total hot run time: 51229 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3609913682
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3601789655
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3596333490
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3601391675
<details>
<summary>ClickBench: <b>Total hot run time: 27.54 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 92eb709a93362eb94acaee7c6bc96ca13a5d6dee, data reload: false
query1 0.06 0.05 0.04
query2 0.10 0.05 0.04
query3 0.26 0.10 0.08
query4 1.60 0.11 0.11
query5 0.27 0.26 0.27
query6 1.18 0.65 0.65
query7 0.04 0.02 0.02
query8 0.07 0.04 0.04
query9 0.58 0.49 0.50
query10 0.56 0.57 0.56
query11 0.16 0.11 0.10
query12 0.16 0.11 0.12
query13 0.61 0.60 0.60
query14 0.98 0.98 0.99
query15 0.82 0.80 0.81
query16 0.43 0.40 0.41
query17 1.05 1.06 1.08
query18 0.24 0.21 0.21
query19 1.97 1.87 1.92
query20 0.02 0.01 0.01
query21 15.44 0.29 0.15
query22 4.98 0.05 0.05
query23 16.15 0.29 0.10
query24 1.17 0.29 0.34
query25 0.06 0.08 0.08
query26 0.14 0.13 0.13
query27 0.08 0.06 0.05
query28 3.54 1.22 1.03
query29 12.56 4.15 3.29
query30 0.28 0.14 0.12
query31 2.83 0.64 0.40
query32 3.23 0.59 0.46
query33 3.02 3.03 3.07
query34 16.83 5.20 4.53
query35 4.60 4.56 4.54
query36 0.67 0.52 0.50
query37 0.12 0.07 0.07
query38 0.07 0.04 0.04
query39 0.04 0.03 0.04
query40 0.17 0.15 0.14
query41 0.09 0.03 0.03
query42 0.04 0.02 0.02
query43 0.04 0.04 0.03
Total cold run time: 97.31 s
Total hot run time: 27.54 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3604800858
<details>
<summary>TPC-H: <b>Total hot run time: 35550 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 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false
------ Round 1 ----------------------------------
q1 17724 5035 4964 4964
q2 2443 321 215 215
q3 10567 1376 763 763
q4 10867 933 347 347
q5 7982 2487 2213 2213
q6 195 173 139 139
q7 989 845 673 673
q8 9354 1458 1142 1142
q9 6962 5373 5340 5340
q10 7015 2192 1794 1794
q11 607 309 307 307
q12 359 373 232 232
q13 17843 3663 3034 3034
q14 240 239 212 212
q15 589 522 513 513
q16 882 876 797 797
q17 731 824 568 568
q18 7427 7561 7538 7538
q19 1150 1045 691 691
q20 415 372 252 252
q21 4403 4005 2791 2791
q22 1109 1069 1025 1025
Total cold run time: 109853 ms
Total hot run time: 35550 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5277 5235 5251 5235
q2 342 419 320 320
q3 2289 2789 2413 2413
q4 1470 2036 1423 1423
q5 4479 4449 4444 4444
q6 211 166 125 125
q7 1994 1961 1772 1772
q8 2678 2532 2523 2523
q9 7596 7451 7613 7451
q10 3064 3185 2832 2832
q11 612 510 498 498
q12 631 720 558 558
q13 3227 3642 3093 3093
q14 278 305 260 260
q15 537 503 509 503
q16 886 892 849 849
q17 1124 1316 1344 1316
q18 7140 7096 7036 7036
q19 857 803 824 803
q20 1892 1971 1848 1848
q21 4659 4279 4133 4133
q22 1067 1010 956 956
Total cold run time: 52310 ms
Total hot run time: 50391 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3603062424
# BE UT Coverage Report
Increment line coverage `25.00% (26/104)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/16b4038c94f9ac58ba86db780a2f242c2789cacb_16b4038c94f9ac58ba86db780a2f242c2789cacb/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/16b4038c94f9ac58ba86db780a2f242c2789cacb_16b4038c94f9ac58ba86db780a2f242c2789cacb/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 53.51% (18734/35010) |
| Line Coverage | 39.10% (172703/441710) |
| Region Coverage | 33.69% (133692/396831) |
| Branch Coverage | 34.65% (57552/166113) |
--
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3596596425
<details>
<summary>TPC-H: <b>Total hot run time: 34035 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 a179bb8ed88354dbbe084a7282c1361d5294d996, data reload: false
------ Round 1 ----------------------------------
q1 17637 5112 4876 4876
q2 2056 312 210 210
q3 10284 1298 746 746
q4 10228 873 324 324
q5 7499 2373 2196 2196
q6 184 178 143 143
q7 953 786 642 642
q8 9355 1358 1076 1076
q9 7011 5345 5309 5309
q10 6843 2214 1795 1795
q11 529 315 299 299
q12 349 364 226 226
q13 17813 3719 3048 3048
q14 229 238 224 224
q15 596 532 509 509
q16 882 853 831 831
q17 580 792 458 458
q18 7570 7029 7034 7029
q19 1085 961 568 568
q20 338 339 232 232
q21 3615 3171 2348 2348
q22 1016 1018 946 946
Total cold run time: 106652 ms
Total hot run time: 34035 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4970 4912 4923 4912
q2 353 412 325 325
q3 2111 2712 2297 2297
q4 1304 1781 1302 1302
q5 4208 4347 4618 4347
q6 222 178 127 127
q7 2078 2018 1823 1823
q8 2728 2429 2549 2429
q9 7574 7784 7412 7412
q10 3063 3300 2973 2973
q11 589 512 493 493
q12 681 763 577 577
q13 3442 3926 3304 3304
q14 276 316 283 283
q15 554 498 518 498
q16 914 957 1020 957
q17 1166 1459 1453 1453
q18 7740 7696 7581 7581
q19 849 800 826 800
q20 1994 2129 1890 1890
q21 4862 4564 4452 4452
q22 1109 1047 978 978
Total cold run time: 52787 ms
Total hot run time: 51213 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3606451581
# BE UT Coverage Report
Increment line coverage `25.00% (26/104)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/16b4038c94f9ac58ba86db780a2f242c2789cacb_16b4038c94f9ac58ba86db780a2f242c2789cacb/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/16b4038c94f9ac58ba86db780a2f242c2789cacb_16b4038c94f9ac58ba86db780a2f242c2789cacb/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 53.36% (18639/34930) |
| Line Coverage | 39.02% (172087/441046) |
| Region Coverage | 33.64% (133301/396294) |
| Branch Coverage | 34.58% (57339/165792) |
--
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3602023601
<details>
<summary>TPC-DS: <b>Total hot run time: 181012 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 183b17b533daa97cb3992374c3ca8b1421afd0c7, data reload: false
query1 1028 411 399 399
query2 6619 1210 1156 1156
query3 6740 233 223 223
query4 24219 23176 22895 22895
query5 5096 647 482 482
query6 331 229 220 220
query7 4658 497 305 305
query8 321 260 232 232
query9 8749 2641 2642 2641
query10 536 346 304 304
query11 15243 14945 14579 14579
query12 180 122 116 116
query13 1669 572 460 460
query14 9593 5980 6016 5980
query15 211 203 189 189
query16 7690 683 555 555
query17 1219 775 631 631
query18 2048 429 344 344
query19 221 209 177 177
query20 128 125 122 122
query21 222 137 116 116
query22 3914 4090 3782 3782
query23 32992 32203 31911 31911
query24 8537 2468 2405 2405
query25 641 554 499 499
query26 1248 281 172 172
query27 2669 512 346 346
query28 4349 2141 2153 2141
query29 801 642 518 518
query30 315 242 214 214
query31 811 702 634 634
query32 83 77 80 77
query33 644 395 345 345
query34 834 893 533 533
query35 828 849 748 748
query36 873 943 837 837
query37 126 115 88 88
query38 3835 3860 3802 3802
query39 1459 1413 1428 1413
query40 222 127 120 120
query41 66 60 62 60
query42 127 116 112 112
query43 431 445 418 418
query44 1316 745 731 731
query45 197 191 183 183
query46 897 1013 660 660
query47 1647 1708 1646 1646
query48 408 419 330 330
query49 790 506 406 406
query50 684 714 417 417
query51 3879 3891 3798 3798
query52 112 120 101 101
query53 241 255 195 195
query54 313 292 276 276
query55 92 92 90 90
query56 322 326 320 320
query57 1149 1161 1099 1099
query58 293 275 275 275
query59 2390 2455 2262 2262
query60 364 346 338 338
query61 164 155 155 155
query62 788 740 660 660
query63 242 188 196 188
query64 4449 1186 891 891
query65 4058 3917 4023 3917
query66 1090 423 332 332
query67 14927 14970 14875 14875
query68 8161 1002 620 620
query69 517 359 306 306
query70 1099 1022 1014 1014
query71 516 357 314 314
query72 5792 4849 4740 4740
query73 695 572 348 348
query74 8819 8748 8580 8580
query75 3697 3019 2524 2524
query76 3866 1150 744 744
query77 818 409 306 306
query78 9481 9651 8864 8864
query79 2656 847 590 590
query80 671 587 490 490
query81 530 271 236 236
query82 493 139 111 111
query83 274 266 256 256
query84 259 115 99 99
query85 906 486 438 438
query86 395 286 288 286
query87 4095 4055 3919 3919
query88 4231 2329 2290 2290
query89 411 333 302 302
query90 1955 231 221 221
query91 165 171 136 136
query92 87 72 67 67
query93 2405 1015 653 653
query94 694 450 337 337
query95 504 415 413 413
query96 536 563 286 286
query97 2650 2708 2610 2610
query98 244 211 209 209
query99 1334 1421 1257 1257
Total cold run time: 272294 ms
Total hot run time: 181012 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3602308609
run cloud_p0
--
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3604830878
<details>
<summary>ClickBench: <b>Total hot run time: 27.35 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 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false
query1 0.06 0.05 0.05
query2 0.14 0.06 0.05
query3 0.28 0.09 0.08
query4 1.61 0.11 0.11
query5 0.28 0.26 0.26
query6 1.16 0.65 0.64
query7 0.04 0.03 0.03
query8 0.05 0.04 0.04
query9 0.58 0.52 0.50
query10 0.56 0.57 0.56
query11 0.21 0.12 0.11
query12 0.16 0.11 0.12
query13 0.64 0.60 0.61
query14 0.98 0.97 0.98
query15 0.83 0.81 0.82
query16 0.42 0.38 0.40
query17 1.10 1.04 1.04
query18 0.24 0.21 0.22
query19 1.99 1.91 1.82
query20 0.01 0.01 0.01
query21 15.51 0.29 0.14
query22 4.96 0.05 0.04
query23 16.13 0.28 0.10
query24 2.29 0.36 0.18
query25 0.09 0.09 0.06
query26 0.14 0.14 0.13
query27 0.07 0.04 0.06
query28 3.75 1.24 1.03
query29 12.55 4.13 3.27
query30 0.27 0.14 0.11
query31 2.83 0.67 0.40
query32 3.23 0.56 0.47
query33 2.99 2.99 3.08
query34 16.87 5.28 4.54
query35 4.54 4.62 4.61
query36 0.65 0.51 0.50
query37 0.14 0.07 0.06
query38 0.07 0.04 0.04
query39 0.24 0.04 0.03
query40 0.23 0.13 0.13
query41 0.29 0.03 0.03
query42 0.07 0.03 0.03
query43 0.06 0.04 0.04
Total cold run time: 99.31 s
Total hot run time: 27.35 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3606009930
<details>
<summary>TPC-DS: <b>Total hot run time: 182500 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 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false
query1 1060 411 395 395
query2 6584 1186 1134 1134
query3 6744 227 229 227
query4 25522 23376 22828 22828
query5 4483 644 495 495
query6 356 259 241 241
query7 4667 533 320 320
query8 318 259 251 251
query9 8726 2658 2658 2658
query10 517 392 333 333
query11 15365 15220 15064 15064
query12 184 124 118 118
query13 1686 605 469 469
query14 9115 5948 5929 5929
query15 210 209 183 183
query16 7443 692 533 533
query17 1249 787 651 651
query18 2028 438 351 351
query19 223 212 179 179
query20 144 130 120 120
query21 218 143 115 115
query22 3982 4017 3981 3981
query23 33146 31868 32168 31868
query24 8492 2489 2436 2436
query25 680 560 504 504
query26 1252 297 179 179
query27 2709 506 361 361
query28 4366 2219 2185 2185
query29 883 676 524 524
query30 320 252 219 219
query31 851 703 619 619
query32 94 76 82 76
query33 623 399 344 344
query34 868 888 589 589
query35 805 830 738 738
query36 914 931 823 823
query37 124 113 90 90
query38 3895 3888 3763 3763
query39 1459 1408 1415 1408
query40 228 127 122 122
query41 67 62 61 61
query42 124 120 114 114
query43 447 456 434 434
query44 1333 764 770 764
query45 200 195 189 189
query46 926 1027 647 647
query47 1694 1762 1624 1624
query48 420 425 329 329
query49 761 496 404 404
query50 697 726 421 421
query51 3890 3864 4151 3864
query52 117 112 103 103
query53 246 262 189 189
query54 319 310 287 287
query55 99 93 96 93
query56 349 349 360 349
query57 1118 1165 1100 1100
query58 294 287 289 287
query59 2346 2389 2333 2333
query60 344 358 341 341
query61 162 164 156 156
query62 830 713 672 672
query63 233 196 190 190
query64 4616 1255 876 876
query65 4056 3981 4000 3981
query66 1174 447 335 335
query67 15398 14924 14815 14815
query68 8399 1008 640 640
query69 530 341 317 317
query70 1083 1036 1001 1001
query71 489 346 309 309
query72 5848 4883 4867 4867
query73 719 572 342 342
query74 8746 8818 8674 8674
query75 3598 3016 2568 2568
query76 3730 1136 748 748
query77 827 401 321 321
query78 9434 9680 8889 8889
query79 1481 876 601 601
query80 661 609 506 506
query81 484 275 246 246
query82 432 142 113 113
query83 277 278 267 267
query84 255 121 108 108
query85 918 490 434 434
query86 338 305 283 283
query87 4074 4084 3976 3976
query88 2971 2347 2336 2336
query89 415 338 301 301
query90 1941 234 223 223
query91 178 174 138 138
query92 88 68 67 67
query93 1198 1060 685 685
query94 726 433 349 349
query95 505 416 409 409
query96 549 550 290 290
query97 2634 2696 2630 2630
query98 234 212 205 205
query99 1588 1402 1276 1276
Total cold run time: 270143 ms
Total hot run time: 182500 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3603489760
# BE Regression && UT Coverage Report
Increment line coverage `96.15% (100/104)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 72.27% (24807/34326) |
| Line Coverage | 58.87% (259783/441315) |
| Region Coverage | 53.50% (214893/401641) |
| Branch Coverage | 55.17% (92138/167010) |
--
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3605048454
# BE Regression && UT Coverage Report
Increment line coverage `97.12% (101/104)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 73.75% (25314/34326) |
| Line Coverage | 60.98% (269099/441315) |
| Region Coverage | 55.84% (224276/401641) |
| Branch Coverage | 57.65% (96286/167010) |
--
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3600020119
<details>
<summary>TPC-H: <b>Total hot run time: 34248 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 85ed7ea1ae5e0a8b18c4478943bd45988b181cbd, data reload: false
------ Round 1 ----------------------------------
q1 17060 5117 4954 4954
q2 2100 304 213 213
q3 10011 1324 733 733
q4 10192 785 323 323
q5 7524 2046 2288 2046
q6 195 176 142 142
q7 912 844 641 641
q8 9372 1353 1111 1111
q9 7084 5350 5380 5350
q10 6844 2207 1801 1801
q11 537 305 298 298
q12 333 373 222 222
q13 17781 3678 3061 3061
q14 243 256 218 218
q15 599 520 518 518
q16 876 880 815 815
q17 595 730 568 568
q18 7987 7188 7161 7161
q19 1089 970 576 576
q20 353 355 232 232
q21 3629 3198 2317 2317
q22 1039 1023 948 948
Total cold run time: 106355 ms
Total hot run time: 34248 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5000 5234 4960 4960
q2 325 389 314 314
q3 2134 2705 2316 2316
q4 1373 1777 1296 1296
q5 4224 4412 4472 4412
q6 227 180 133 133
q7 2045 1957 1926 1926
q8 2678 2533 2528 2528
q9 7497 7477 7514 7477
q10 3063 3320 2832 2832
q11 630 525 488 488
q12 698 752 835 752
q13 3488 3873 3350 3350
q14 279 287 273 273
q15 553 506 536 506
q16 935 958 889 889
q17 1160 1412 1418 1412
q18 7808 7745 7570 7570
q19 864 852 829 829
q20 2085 1983 1822 1822
q21 4633 4310 4208 4208
q22 1062 1059 994 994
Total cold run time: 52761 ms
Total hot run time: 51287 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb merged PR #58578:
URL: https://github.com/apache/doris/pull/58578
--
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3596682727
<details>
<summary>ClickBench: <b>Total hot run time: 27.41 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 a179bb8ed88354dbbe084a7282c1361d5294d996, data reload: false
query1 0.05 0.06 0.05
query2 0.11 0.05 0.05
query3 0.25 0.09 0.09
query4 1.61 0.12 0.11
query5 0.28 0.27 0.26
query6 1.15 0.65 0.63
query7 0.03 0.03 0.03
query8 0.06 0.04 0.04
query9 0.57 0.52 0.51
query10 0.57 0.55 0.56
query11 0.16 0.11 0.12
query12 0.15 0.12 0.11
query13 0.62 0.60 0.62
query14 0.98 0.97 0.99
query15 0.82 0.81 0.81
query16 0.39 0.41 0.45
query17 0.99 1.05 1.07
query18 0.23 0.21 0.21
query19 1.97 1.87 1.87
query20 0.02 0.01 0.02
query21 15.48 0.27 0.14
query22 4.67 0.06 0.04
query23 15.85 0.25 0.11
query24 1.33 1.00 0.24
query25 0.12 0.07 0.06
query26 0.14 0.13 0.12
query27 0.08 0.04 0.04
query28 4.92 1.22 1.01
query29 12.58 3.85 3.24
query30 0.29 0.14 0.13
query31 2.84 0.62 0.39
query32 3.23 0.54 0.46
query33 3.01 3.11 3.05
query34 16.90 5.19 4.50
query35 4.53 4.60 4.56
query36 0.67 0.50 0.50
query37 0.11 0.07 0.06
query38 0.07 0.04 0.04
query39 0.05 0.03 0.03
query40 0.17 0.14 0.15
query41 0.08 0.03 0.03
query42 0.04 0.02 0.02
query43 0.04 0.04 0.03
Total cold run time: 98.21 s
Total hot run time: 27.41 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3601961484
<details>
<summary>TPC-H: <b>Total hot run time: 34142 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 183b17b533daa97cb3992374c3ca8b1421afd0c7, data reload: false
------ Round 1 ----------------------------------
q1 18060 5005 4936 4936
q2 2053 312 198 198
q3 10285 1323 758 758
q4 10218 857 318 318
q5 7537 2409 2169 2169
q6 182 171 139 139
q7 946 765 647 647
q8 9355 1393 1104 1104
q9 6921 5342 5352 5342
q10 6842 2192 1803 1803
q11 551 304 288 288
q12 339 371 230 230
q13 17786 3697 3026 3026
q14 234 250 216 216
q15 601 503 504 503
q16 869 871 792 792
q17 666 803 503 503
q18 7667 6949 6973 6949
q19 1105 939 585 585
q20 375 347 226 226
q21 3966 3222 2465 2465
q22 1022 1017 945 945
Total cold run time: 107580 ms
Total hot run time: 34142 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4949 4920 4904 4904
q2 323 384 318 318
q3 2179 2641 2244 2244
q4 1313 1770 1289 1289
q5 4241 4407 4590 4407
q6 216 173 126 126
q7 2109 2004 1850 1850
q8 2813 2524 2478 2478
q9 7610 7534 7665 7534
q10 3065 3254 2819 2819
q11 612 517 492 492
q12 719 774 588 588
q13 3514 3980 3521 3521
q14 313 303 286 286
q15 557 520 512 512
q16 901 953 887 887
q17 1162 1436 1477 1436
q18 7944 7659 7585 7585
q19 901 1006 868 868
q20 1957 2060 1933 1933
q21 4710 4305 4183 4183
q22 1055 1002 958 958
Total cold run time: 53163 ms
Total hot run time: 51218 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3601004399
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3609913834
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3605963778
<details>
<summary>TPC-H: <b>Total hot run time: 34852 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 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false
------ Round 1 ----------------------------------
q1 17616 5096 4978 4978
q2 2077 318 210 210
q3 10206 1319 769 769
q4 10210 856 316 316
q5 7536 2505 2141 2141
q6 188 174 139 139
q7 984 795 651 651
q8 9360 1459 1257 1257
q9 7181 5447 5439 5439
q10 6859 2209 1775 1775
q11 525 310 286 286
q12 358 376 227 227
q13 17784 3748 3100 3100
q14 236 240 211 211
q15 600 517 508 508
q16 900 867 813 813
q17 713 743 575 575
q18 7704 7197 7023 7023
q19 1102 970 603 603
q20 379 372 248 248
q21 4171 3634 2612 2612
q22 1043 987 971 971
Total cold run time: 107732 ms
Total hot run time: 34852 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4992 4953 4958 4953
q2 336 404 310 310
q3 2151 2703 2303 2303
q4 1393 1789 1274 1274
q5 4347 4580 4540 4540
q6 229 183 131 131
q7 2065 1985 1829 1829
q8 2701 2611 2572 2572
q9 7641 7593 7635 7593
q10 3072 3276 2878 2878
q11 616 525 512 512
q12 713 792 607 607
q13 3562 3899 3337 3337
q14 284 303 302 302
q15 581 522 510 510
q16 934 909 909 909
q17 1235 1601 1373 1373
q18 8004 7626 7677 7626
q19 905 888 880 880
q20 1955 2085 1914 1914
q21 4828 4291 4206 4206
q22 1087 1053 970 970
Total cold run time: 53631 ms
Total hot run time: 51529 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3606033042
<details>
<summary>ClickBench: <b>Total hot run time: 27.51 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 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false
query1 0.06 0.05 0.05
query2 0.10 0.05 0.05
query3 0.25 0.08 0.09
query4 1.60 0.10 0.11
query5 0.28 0.25 0.25
query6 1.16 0.65 0.64
query7 0.03 0.02 0.02
query8 0.06 0.04 0.04
query9 0.58 0.52 0.49
query10 0.57 0.56 0.55
query11 0.17 0.11 0.12
query12 0.15 0.11 0.12
query13 0.64 0.61 0.60
query14 1.00 0.97 0.99
query15 0.81 0.81 0.80
query16 0.40 0.40 0.39
query17 1.04 1.07 1.05
query18 0.24 0.22 0.22
query19 1.87 1.80 1.76
query20 0.02 0.01 0.01
query21 15.49 0.31 0.14
query22 4.86 0.05 0.05
query23 15.99 0.29 0.11
query24 2.15 0.37 0.63
query25 0.07 0.05 0.05
query26 0.14 0.15 0.14
query27 0.12 0.05 0.04
query28 4.06 1.22 1.03
query29 12.55 3.96 3.21
query30 0.29 0.14 0.11
query31 2.82 0.63 0.42
query32 3.24 0.57 0.46
query33 3.02 3.07 3.09
query34 16.74 5.20 4.62
query35 4.62 4.58 4.54
query36 0.68 0.49 0.49
query37 0.11 0.07 0.06
query38 0.07 0.04 0.04
query39 0.05 0.03 0.03
query40 0.16 0.14 0.14
query41 0.08 0.04 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.04
Total cold run time: 98.42 s
Total hot run time: 27.51 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3606655885
# BE Regression && UT Coverage Report
Increment line coverage `96.15% (100/104)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 72.11% (24695/34246) |
| Line Coverage | 58.70% (258667/440651) |
| Region Coverage | 53.32% (213868/401104) |
| Branch Coverage | 54.98% (91651/166689) |
--
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3596108061
<details>
<summary>TPC-DS: <b>Total hot run time: 181794 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 2e40358b1b4fd8a85a0d6194f3e8b5b5ea1acaa1, data reload: false
query1 1057 407 430 407
query2 6575 1171 1157 1157
query3 6757 223 227 223
query4 25517 23416 22947 22947
query5 5280 643 505 505
query6 346 256 237 237
query7 4651 500 305 305
query8 302 260 254 254
query9 8740 2666 2687 2666
query10 532 355 307 307
query11 15468 14928 15012 14928
query12 188 121 116 116
query13 1689 587 437 437
query14 9842 5995 6004 5995
query15 217 198 192 192
query16 7693 715 531 531
query17 1305 771 654 654
query18 2045 437 350 350
query19 217 207 182 182
query20 134 132 122 122
query21 222 142 115 115
query22 3845 4035 3919 3919
query23 33077 32010 31881 31881
query24 8445 2447 2415 2415
query25 647 564 481 481
query26 1260 292 174 174
query27 2714 507 359 359
query28 4340 2172 2157 2157
query29 824 638 516 516
query30 312 240 220 220
query31 821 716 646 646
query32 93 80 72 72
query33 601 391 340 340
query34 823 912 536 536
query35 796 837 738 738
query36 894 927 827 827
query37 119 115 93 93
query38 3845 3864 3813 3813
query39 1528 1411 1434 1411
query40 226 130 120 120
query41 66 64 63 63
query42 125 114 117 114
query43 434 454 414 414
query44 1262 756 751 751
query45 202 194 188 188
query46 892 994 638 638
query47 1684 1723 1632 1632
query48 390 417 337 337
query49 764 478 431 431
query50 666 688 415 415
query51 3973 3898 4061 3898
query52 115 112 102 102
query53 244 263 195 195
query54 315 292 281 281
query55 100 97 92 92
query56 328 315 326 315
query57 1128 1172 1091 1091
query58 286 275 272 272
query59 2249 2498 2265 2265
query60 357 364 334 334
query61 162 157 159 157
query62 782 723 686 686
query63 228 193 190 190
query64 4509 1208 878 878
query65 4061 3974 4011 3974
query66 1084 440 344 344
query67 15187 15143 14712 14712
query68 8464 949 618 618
query69 499 354 312 312
query70 1094 1048 995 995
query71 475 357 317 317
query72 6043 4921 4784 4784
query73 646 559 344 344
query74 8874 8751 8611 8611
query75 3719 3007 2545 2545
query76 3625 1125 735 735
query77 806 402 325 325
query78 9467 9627 8821 8821
query79 2221 856 576 576
query80 635 568 504 504
query81 527 265 253 253
query82 462 134 111 111
query83 268 259 249 249
query84 266 115 101 101
query85 915 510 444 444
query86 380 308 289 289
query87 3991 4054 3980 3980
query88 4189 2302 2296 2296
query89 419 340 298 298
query90 1956 246 225 225
query91 176 170 143 143
query92 85 71 70 70
query93 1905 993 660 660
query94 731 462 352 352
query95 513 416 418 416
query96 520 550 281 281
query97 2610 2684 2567 2567
query98 245 222 219 219
query99 1641 1371 1236 1236
Total cold run time: 273947 ms
Total hot run time: 181794 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3596126287
<details>
<summary>ClickBench: <b>Total hot run time: 27.29 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 2e40358b1b4fd8a85a0d6194f3e8b5b5ea1acaa1, data reload: false
query1 0.06 0.04 0.05
query2 0.09 0.05 0.06
query3 0.26 0.10 0.09
query4 1.61 0.11 0.12
query5 0.28 0.25 0.25
query6 1.17 0.66 0.65
query7 0.03 0.02 0.02
query8 0.05 0.04 0.04
query9 0.59 0.52 0.49
query10 0.56 0.56 0.54
query11 0.17 0.11 0.12
query12 0.15 0.12 0.11
query13 0.64 0.61 0.60
query14 0.99 0.98 0.99
query15 0.82 0.79 0.80
query16 0.39 0.42 0.39
query17 0.97 1.04 1.04
query18 0.23 0.22 0.24
query19 1.97 1.86 1.76
query20 0.02 0.02 0.01
query21 15.46 0.29 0.14
query22 4.70 0.06 0.05
query23 15.90 0.26 0.11
query24 2.29 0.59 0.19
query25 0.07 0.07 0.06
query26 0.14 0.15 0.13
query27 0.06 0.04 0.05
query28 3.94 1.22 1.02
query29 12.56 3.87 3.30
query30 0.27 0.14 0.11
query31 2.84 0.61 0.39
query32 3.24 0.55 0.47
query33 2.98 3.09 3.08
query34 16.73 5.22 4.51
query35 4.59 4.57 4.57
query36 0.67 0.51 0.49
query37 0.11 0.06 0.06
query38 0.07 0.04 0.04
query39 0.04 0.03 0.02
query40 0.17 0.14 0.14
query41 0.08 0.02 0.03
query42 0.04 0.04 0.03
query43 0.04 0.03 0.03
Total cold run time: 98.04 s
Total hot run time: 27.29 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3595814085
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3595816967
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3601373592
<details>
<summary>TPC-DS: <b>Total hot run time: 182831 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 92eb709a93362eb94acaee7c6bc96ca13a5d6dee, data reload: false
query1 1071 433 399 399
query2 6567 1193 1170 1170
query3 6748 233 231 231
query4 25951 23483 22915 22915
query5 4941 686 503 503
query6 340 244 233 233
query7 4657 509 320 320
query8 305 255 249 249
query9 8734 2649 2642 2642
query10 543 364 319 319
query11 15081 14944 14970 14944
query12 193 121 117 117
query13 1687 585 437 437
query14 9677 6139 6121 6121
query15 220 207 191 191
query16 7663 703 538 538
query17 1219 787 647 647
query18 2049 439 354 354
query19 233 215 190 190
query20 141 164 123 123
query21 222 137 117 117
query22 3912 3939 3802 3802
query23 32997 31956 31820 31820
query24 8515 2395 2422 2395
query25 600 534 467 467
query26 741 279 173 173
query27 2645 500 349 349
query28 4254 2177 2160 2160
query29 716 639 509 509
query30 316 245 214 214
query31 822 701 637 637
query32 86 75 78 75
query33 606 399 366 366
query34 840 869 550 550
query35 785 832 754 754
query36 908 936 850 850
query37 131 110 92 92
query38 3914 3925 3843 3843
query39 1490 1405 1412 1405
query40 244 134 121 121
query41 67 67 64 64
query42 129 120 116 116
query43 442 453 436 436
query44 1370 755 749 749
query45 201 195 184 184
query46 902 1012 661 661
query47 1672 1727 1671 1671
query48 400 445 336 336
query49 742 497 412 412
query50 711 734 430 430
query51 3999 3880 3886 3880
query52 117 115 109 109
query53 252 269 204 204
query54 316 301 293 293
query55 100 94 95 94
query56 361 340 330 330
query57 1112 1158 1097 1097
query58 293 283 283 283
query59 2371 2436 2279 2279
query60 355 367 346 346
query61 166 167 166 166
query62 787 715 664 664
query63 240 204 202 202
query64 3398 1234 919 919
query65 4029 3988 3974 3974
query66 920 458 358 358
query67 15127 14851 14992 14851
query68 5638 1004 640 640
query69 513 347 309 309
query70 1139 1031 1020 1020
query71 429 358 320 320
query72 5934 4997 5141 4997
query73 683 613 354 354
query74 8838 8820 8612 8612
query75 3107 3063 2568 2568
query76 3210 1165 793 793
query77 516 418 338 338
query78 9387 9675 8961 8961
query79 1927 848 578 578
query80 790 630 551 551
query81 536 274 239 239
query82 439 148 117 117
query83 283 279 271 271
query84 285 123 105 105
query85 983 489 449 449
query86 393 291 281 281
query87 3983 4033 3964 3964
query88 3025 2296 2323 2296
query89 392 337 298 298
query90 1886 233 227 227
query91 177 184 177 177
query92 80 72 67 67
query93 1553 1008 670 670
query94 715 457 346 346
query95 508 425 424 424
query96 552 548 284 284
query97 2626 2709 2584 2584
query98 242 220 214 214
query99 1295 1421 1327 1327
Total cold run time: 265407 ms
Total hot run time: 182831 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3599885628
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3596655304
<details>
<summary>TPC-DS: <b>Total hot run time: 182288 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 a179bb8ed88354dbbe084a7282c1361d5294d996, data reload: false
query1 1108 426 405 405
query2 6596 1210 1151 1151
query3 6741 231 226 226
query4 25660 23265 22922 22922
query5 4853 684 502 502
query6 370 239 241 239
query7 4661 528 314 314
query8 323 255 246 246
query9 8770 2650 2660 2650
query10 540 357 339 339
query11 15323 15401 14905 14905
query12 192 122 117 117
query13 1695 570 451 451
query14 9594 6113 6070 6070
query15 225 201 189 189
query16 7556 714 543 543
query17 1227 793 644 644
query18 2037 442 345 345
query19 218 222 184 184
query20 135 125 124 124
query21 225 145 128 128
query22 3991 3883 3868 3868
query23 32801 32208 32017 32017
query24 8531 2446 2476 2446
query25 626 549 498 498
query26 1258 287 173 173
query27 2719 518 363 363
query28 4342 2165 2155 2155
query29 857 675 533 533
query30 316 247 216 216
query31 838 718 637 637
query32 90 77 79 77
query33 652 396 328 328
query34 841 900 557 557
query35 818 842 748 748
query36 916 924 839 839
query37 126 117 87 87
query38 3857 3785 3869 3785
query39 1480 1411 1417 1411
query40 237 135 119 119
query41 66 63 66 63
query42 125 113 114 113
query43 440 458 430 430
query44 1328 748 753 748
query45 208 192 184 184
query46 896 1009 664 664
query47 1689 1746 1639 1639
query48 396 436 336 336
query49 771 509 437 437
query50 687 725 417 417
query51 3852 3980 3915 3915
query52 111 115 105 105
query53 238 268 193 193
query54 318 297 285 285
query55 100 96 94 94
query56 328 350 325 325
query57 1145 1146 1091 1091
query58 301 290 281 281
query59 2359 2396 2264 2264
query60 365 346 341 341
query61 167 164 200 164
query62 805 727 659 659
query63 235 201 206 201
query64 4561 1207 902 902
query65 4097 3989 4045 3989
query66 1132 441 353 353
query67 15182 15136 14685 14685
query68 8354 980 629 629
query69 518 354 315 315
query70 1120 1001 1005 1001
query71 489 338 318 318
query72 5829 4854 4797 4797
query73 717 576 343 343
query74 8753 8757 8552 8552
query75 3750 3064 2533 2533
query76 3814 1162 754 754
query77 815 428 329 329
query78 9519 9612 8862 8862
query79 1988 858 577 577
query80 656 589 514 514
query81 499 269 246 246
query82 842 149 112 112
query83 272 270 258 258
query84 259 117 93 93
query85 942 492 461 461
query86 340 307 291 291
query87 4029 4097 3980 3980
query88 3847 2327 2314 2314
query89 400 343 306 306
query90 2020 229 234 229
query91 174 172 148 148
query92 87 71 71 71
query93 1400 988 676 676
query94 744 472 349 349
query95 506 414 404 404
query96 513 552 288 288
query97 2636 2703 2586 2586
query98 248 221 222 221
query99 1361 1400 1302 1302
Total cold run time: 272688 ms
Total hot run time: 182288 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3600348939
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3600049271
<details>
<summary>TPC-DS: <b>Total hot run time: 182475 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 85ed7ea1ae5e0a8b18c4478943bd45988b181cbd, data reload: false
query1 1042 411 397 397
query2 6625 1153 1162 1153
query3 6746 236 232 232
query4 25094 23475 23030 23030
query5 5106 659 536 536
query6 365 244 230 230
query7 4643 522 314 314
query8 330 256 251 251
query9 8744 2705 2660 2660
query10 552 338 311 311
query11 15415 14825 15356 14825
query12 186 122 115 115
query13 1686 563 435 435
query14 9565 5932 6036 5932
query15 211 200 183 183
query16 7670 691 536 536
query17 1216 792 633 633
query18 2046 438 350 350
query19 217 211 185 185
query20 141 131 124 124
query21 254 142 116 116
query22 3902 4015 3913 3913
query23 32856 32186 32138 32138
query24 8493 2409 2444 2409
query25 598 512 470 470
query26 1236 277 167 167
query27 2732 491 348 348
query28 4269 2170 2144 2144
query29 801 617 488 488
query30 316 229 209 209
query31 818 731 620 620
query32 83 71 77 71
query33 595 405 344 344
query34 817 882 539 539
query35 782 827 745 745
query36 873 926 838 838
query37 140 114 87 87
query38 3883 3913 3781 3781
query39 1483 1414 1414 1414
query40 224 132 125 125
query41 67 61 62 61
query42 126 125 118 118
query43 442 452 415 415
query44 1345 762 752 752
query45 200 197 186 186
query46 897 1011 654 654
query47 1708 1772 1669 1669
query48 384 423 335 335
query49 762 491 437 437
query50 662 686 414 414
query51 3922 3966 3931 3931
query52 112 113 108 108
query53 244 267 195 195
query54 322 306 288 288
query55 100 104 93 93
query56 345 340 357 340
query57 1173 1185 1078 1078
query58 296 276 283 276
query59 2305 2451 2291 2291
query60 354 360 364 360
query61 160 159 163 159
query62 780 721 660 660
query63 226 202 200 200
query64 4534 1190 906 906
query65 4045 3967 3969 3967
query66 1103 457 358 358
query67 15159 14898 14896 14896
query68 5800 975 634 634
query69 519 352 315 315
query70 1090 1050 1007 1007
query71 429 361 329 329
query72 5798 4857 4898 4857
query73 673 569 347 347
query74 8586 8753 8632 8632
query75 3062 3051 2559 2559
query76 3328 1148 745 745
query77 496 429 320 320
query78 9433 9523 8886 8886
query79 2391 848 599 599
query80 642 589 500 500
query81 527 274 235 235
query82 306 141 115 115
query83 277 263 250 250
query84 259 127 102 102
query85 906 488 437 437
query86 382 297 286 286
query87 4022 4088 3975 3975
query88 4161 2342 2309 2309
query89 412 331 296 296
query90 1993 226 229 226
query91 161 173 144 144
query92 82 72 69 69
query93 2011 1010 666 666
query94 741 473 349 349
query95 512 417 408 408
query96 522 557 291 291
query97 2642 2706 2576 2576
query98 251 222 213 213
query99 1375 1365 1253 1253
Total cold run time: 268317 ms
Total hot run time: 182475 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3602047851
<details>
<summary>ClickBench: <b>Total hot run time: 27.11 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 183b17b533daa97cb3992374c3ca8b1421afd0c7, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.04
query3 0.25 0.10 0.09
query4 1.61 0.11 0.11
query5 0.30 0.25 0.25
query6 1.16 0.64 0.63
query7 0.03 0.03 0.03
query8 0.05 0.04 0.04
query9 0.56 0.51 0.51
query10 0.56 0.54 0.56
query11 0.15 0.11 0.11
query12 0.15 0.11 0.12
query13 0.63 0.59 0.61
query14 0.99 0.97 0.98
query15 0.81 0.79 0.82
query16 0.41 0.41 0.40
query17 1.06 1.07 0.98
query18 0.23 0.22 0.21
query19 1.93 1.85 1.74
query20 0.02 0.01 0.01
query21 15.45 0.29 0.14
query22 5.04 0.05 0.04
query23 15.90 0.26 0.10
query24 1.63 1.11 0.17
query25 0.10 0.06 0.05
query26 0.14 0.13 0.13
query27 0.08 0.06 0.04
query28 5.52 1.23 1.03
query29 12.56 4.07 3.32
query30 0.27 0.16 0.11
query31 2.83 0.63 0.40
query32 3.23 0.55 0.46
query33 3.03 3.03 3.04
query34 17.03 5.25 4.56
query35 4.62 4.51 4.50
query36 0.65 0.52 0.49
query37 0.10 0.06 0.06
query38 0.07 0.04 0.04
query39 0.04 0.03 0.03
query40 0.18 0.14 0.13
query41 0.08 0.04 0.03
query42 0.05 0.03 0.02
query43 0.04 0.03 0.03
Total cold run time: 99.69 s
Total hot run time: 27.11 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3604822291
<details>
<summary>TPC-DS: <b>Total hot run time: 182478 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 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false
query1 1192 417 398 398
query2 7042 1178 1145 1145
query3 6853 230 225 225
query4 25866 23283 22981 22981
query5 5160 657 502 502
query6 325 237 227 227
query7 4680 532 302 302
query8 302 251 250 250
query9 8716 2655 2633 2633
query10 524 364 331 331
query11 15291 15487 14967 14967
query12 197 122 115 115
query13 1690 585 437 437
query14 9758 6087 5969 5969
query15 213 204 186 186
query16 7695 675 533 533
query17 1221 810 638 638
query18 2053 442 343 343
query19 223 218 182 182
query20 137 133 122 122
query21 461 136 117 117
query22 3958 4076 3911 3911
query23 32969 31930 31857 31857
query24 8497 2443 2453 2443
query25 680 541 491 491
query26 857 284 181 181
query27 2554 510 350 350
query28 4260 2167 2161 2161
query29 774 661 520 520
query30 350 245 213 213
query31 818 725 627 627
query32 86 76 76 76
query33 680 402 349 349
query34 848 897 534 534
query35 809 897 734 734
query36 903 925 838 838
query37 139 124 94 94
query38 3902 3907 3817 3817
query39 1502 1414 1423 1414
query40 223 133 120 120
query41 63 63 64 63
query42 128 129 119 119
query43 448 444 434 434
query44 1337 741 738 738
query45 200 196 189 189
query46 909 1036 651 651
query47 1716 1711 1657 1657
query48 411 426 331 331
query49 753 489 425 425
query50 678 717 424 424
query51 3876 3901 3865 3865
query52 114 115 105 105
query53 236 264 187 187
query54 319 301 278 278
query55 98 96 89 89
query56 338 324 350 324
query57 1136 1165 1105 1105
query58 294 279 277 277
query59 2321 2382 2396 2382
query60 355 348 345 345
query61 155 153 147 147
query62 784 750 673 673
query63 239 191 196 191
query64 3307 1228 874 874
query65 4092 3950 4002 3950
query66 897 445 343 343
query67 15168 15153 14841 14841
query68 8475 1005 623 623
query69 526 342 308 308
query70 1142 1031 1026 1026
query71 477 340 332 332
query72 5842 4907 4839 4839
query73 723 600 344 344
query74 8592 8882 8719 8719
query75 3680 3005 2538 2538
query76 3763 1192 770 770
query77 818 420 305 305
query78 9639 9814 8958 8958
query79 2023 862 613 613
query80 659 612 497 497
query81 497 272 239 239
query82 282 148 113 113
query83 271 268 255 255
query84 261 116 101 101
query85 886 501 441 441
query86 341 293 274 274
query87 4069 4127 4073 4073
query88 3723 2313 2316 2313
query89 394 336 292 292
query90 2027 227 224 224
query91 167 166 144 144
query92 86 71 66 66
query93 1231 1030 672 672
query94 697 466 346 346
query95 530 411 417 411
query96 538 564 283 283
query97 2575 2705 2559 2559
query98 251 224 216 216
query99 1299 1414 1244 1244
Total cold run time: 271264 ms
Total hot run time: 182478 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3606696472
# BE Regression && UT Coverage Report
Increment line coverage `96.15% (100/104)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 72.11% (24695/34246) |
| Line Coverage | 58.71% (258695/440651) |
| Region Coverage | 53.33% (213905/401104) |
| Branch Coverage | 54.99% (91659/166689) |
--
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3606622680
# BE Regression && UT Coverage Report
Increment line coverage `96.15% (100/104)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 72.11% (24694/34246) |
| Line Coverage | 58.70% (258645/440651) |
| Region Coverage | 53.31% (213820/401104) |
| Branch Coverage | 54.97% (91632/166689) |
--
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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #58578:
URL: https://github.com/apache/doris/pull/58578#issuecomment-3602702849
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