You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "yujun777 (via GitHub)" <gi...@apache.org> on 2025/10/14 07:10:55 UTC
[PR] [feat](case when) Push upper function into case when branch [doris]
yujun777 opened a new pull request, #56941:
URL: https://github.com/apache/doris/pull/56941
push upper function into case when branch.
example:
```
2 > case when c1 then 1
when c2 then 2
else 3
end
```
will rewrite to
```
case when c1 then true
when c2 then false
else false
end
```
### 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3413759242
<details>
<summary>TPC-DS: <b>Total hot run time: 190099 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 d02c24c3a242d0060b6fc1bfee6d741cece966cd, data reload: false
query1 1073 444 414 414
query2 6592 1696 1682 1682
query3 6754 220 228 220
query4 26588 23930 23202 23202
query5 4673 649 506 506
query6 330 274 237 237
query7 4661 503 310 310
query8 342 275 282 275
query9 8721 2591 2566 2566
query10 513 340 300 300
query11 15211 15149 14821 14821
query12 182 119 113 113
query13 1667 552 431 431
query14 11090 9330 9286 9286
query15 200 194 176 176
query16 7688 674 519 519
query17 1213 773 618 618
query18 2031 427 339 339
query19 234 254 185 185
query20 144 135 140 135
query21 222 140 124 124
query22 4802 4812 4479 4479
query23 34769 33934 33731 33731
query24 8594 2650 2495 2495
query25 593 523 480 480
query26 1246 287 191 191
query27 2803 530 377 377
query28 4378 2230 2212 2212
query29 856 625 491 491
query30 341 229 215 215
query31 949 839 1063 839
query32 80 70 68 68
query33 579 386 327 327
query34 819 875 537 537
query35 807 890 790 790
query36 979 1053 927 927
query37 128 118 98 98
query38 3667 3730 3635 3635
query39 1506 1408 1428 1408
query40 217 128 117 117
query41 61 59 59 59
query42 121 116 108 108
query43 494 479 473 473
query44 1314 827 845 827
query45 187 178 171 171
query46 834 997 641 641
query47 1749 1784 1682 1682
query48 399 426 334 334
query49 767 507 397 397
query50 645 690 402 402
query51 3977 3893 3827 3827
query52 110 103 101 101
query53 241 262 197 197
query54 606 594 538 538
query55 87 87 88 87
query56 315 317 295 295
query57 1182 1209 1117 1117
query58 290 288 287 287
query59 2591 2721 2602 2602
query60 351 345 369 345
query61 160 152 151 151
query62 806 755 663 663
query63 229 195 187 187
query64 4364 1131 819 819
query65 4033 3974 3971 3971
query66 1086 430 334 334
query67 15484 15054 15021 15021
query68 6469 906 594 594
query69 495 320 293 293
query70 1327 1248 1264 1248
query71 450 349 316 316
query72 6002 5135 5047 5047
query73 652 582 358 358
query74 8859 9072 8742 8742
query75 3315 3279 2893 2893
query76 3261 1173 745 745
query77 516 418 313 313
query78 9584 9733 8981 8981
query79 2430 852 606 606
query80 759 554 510 510
query81 527 269 221 221
query82 455 164 132 132
query83 262 382 249 249
query84 267 109 95 95
query85 911 476 425 425
query86 390 313 312 312
query87 3745 3717 3605 3605
query88 3816 2246 2211 2211
query89 389 336 296 296
query90 1941 218 225 218
query91 186 164 130 130
query92 83 69 70 69
query93 1944 978 633 633
query94 739 431 345 345
query95 410 323 308 308
query96 490 590 281 281
query97 2942 3002 2913 2913
query98 243 221 225 221
query99 1468 1399 1277 1277
Total cold run time: 276052 ms
Total hot run time: 190099 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3506041693
<details>
<summary>ClickBench: <b>Total hot run time: 27.57 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 a7b43fb0e933fc9c58cf8e0b4a26b2de28ea1880, data reload: false
query1 0.06 0.05 0.05
query2 0.10 0.04 0.04
query3 0.27 0.09 0.08
query4 1.94 0.12 0.12
query5 0.26 0.26 0.26
query6 1.18 0.64 0.64
query7 0.03 0.03 0.02
query8 0.05 0.04 0.04
query9 0.60 0.52 0.53
query10 0.59 0.58 0.57
query11 0.18 0.12 0.11
query12 0.15 0.12 0.11
query13 0.62 0.61 0.60
query14 1.00 0.99 1.04
query15 0.86 0.82 0.82
query16 0.39 0.38 0.39
query17 1.05 1.04 1.03
query18 0.21 0.20 0.20
query19 2.08 1.82 1.78
query20 0.01 0.01 0.01
query21 15.48 0.21 0.13
query22 4.99 0.08 0.04
query23 16.01 0.27 0.10
query24 2.82 0.66 0.60
query25 0.08 0.08 0.06
query26 0.14 0.13 0.13
query27 0.08 0.06 0.05
query28 5.02 1.15 0.92
query29 12.55 3.84 3.20
query30 0.28 0.13 0.11
query31 2.82 0.58 0.39
query32 3.59 0.54 0.48
query33 3.01 3.08 3.18
query34 15.92 5.18 4.52
query35 4.58 4.56 4.60
query36 0.70 0.51 0.49
query37 0.11 0.07 0.07
query38 0.06 0.04 0.04
query39 0.05 0.02 0.02
query40 0.17 0.13 0.14
query41 0.11 0.03 0.02
query42 0.06 0.03 0.03
query43 0.04 0.03 0.04
Total cold run time: 100.3 s
Total hot run time: 27.57 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3413775753
<details>
<summary>ClickBench: <b>Total hot run time: 30.53 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 d02c24c3a242d0060b6fc1bfee6d741cece966cd, data reload: false
query1 0.06 0.06 0.05
query2 0.09 0.06 0.06
query3 0.26 0.09 0.09
query4 1.62 0.12 0.12
query5 0.28 0.27 0.25
query6 1.18 0.66 0.65
query7 0.04 0.03 0.03
query8 0.06 0.04 0.04
query9 0.64 0.52 0.52
query10 0.58 0.59 0.58
query11 0.16 0.11 0.12
query12 0.15 0.13 0.12
query13 0.63 0.62 0.62
query14 1.04 1.05 1.03
query15 0.87 0.84 0.87
query16 0.43 0.39 0.39
query17 1.08 1.04 1.04
query18 0.22 0.20 0.19
query19 1.94 1.89 1.82
query20 0.02 0.02 0.01
query21 15.46 0.96 0.58
query22 0.76 1.13 0.63
query23 15.04 1.40 0.63
query24 6.72 2.03 0.90
query25 0.44 0.10 0.14
query26 0.67 0.16 0.13
query27 0.06 0.07 0.05
query28 9.66 1.34 0.94
query29 12.63 3.94 3.28
query30 0.31 0.15 0.11
query31 2.83 0.58 0.39
query32 3.26 0.56 0.47
query33 2.99 3.16 3.11
query34 16.02 5.45 4.88
query35 4.93 4.87 4.91
query36 0.72 0.51 0.52
query37 0.10 0.08 0.08
query38 0.06 0.04 0.04
query39 0.04 0.03 0.03
query40 0.18 0.15 0.14
query41 0.08 0.03 0.04
query42 0.04 0.03 0.03
query43 0.04 0.04 0.04
Total cold run time: 104.39 s
Total hot run time: 30.53 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 merged PR #56941:
URL: https://github.com/apache/doris/pull/56941
--
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546870566
<details>
<summary>ClickBench: <b>Total hot run time: 28.07 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 20dee04388464e8c370b9fbc1c58572de608cc51, data reload: false
query1 0.06 0.05 0.05
query2 0.09 0.05 0.05
query3 0.26 0.08 0.08
query4 1.61 0.12 0.11
query5 0.26 0.26 0.24
query6 1.19 0.65 0.63
query7 0.03 0.03 0.02
query8 0.05 0.04 0.04
query9 0.60 0.53 0.52
query10 0.59 0.58 0.57
query11 0.16 0.11 0.11
query12 0.15 0.12 0.13
query13 0.62 0.61 0.61
query14 1.00 0.99 0.99
query15 0.85 0.83 0.83
query16 0.39 0.39 0.39
query17 1.04 1.00 1.00
query18 0.21 0.20 0.20
query19 1.88 1.82 1.80
query20 0.02 0.01 0.02
query21 15.44 0.22 0.13
query22 4.88 0.08 0.06
query23 15.65 0.26 0.10
query24 2.68 1.04 1.00
query25 0.09 0.05 0.06
query26 0.15 0.14 0.13
query27 0.06 0.05 0.05
query28 5.10 1.18 0.94
query29 12.62 3.90 3.24
query30 0.28 0.14 0.12
query31 2.82 0.59 0.39
query32 3.23 0.55 0.46
query33 3.02 3.04 3.06
query34 15.87 5.32 4.57
query35 4.57 4.60 4.56
query36 0.66 0.51 0.50
query37 0.10 0.07 0.06
query38 0.06 0.04 0.04
query39 0.04 0.03 0.03
query40 0.17 0.14 0.15
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.71 s
Total hot run time: 28.07 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551026298
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3503018166
# FE Regression Coverage Report
Increment line coverage ` 92.00% (92/100)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_5a0df8ec586cff8aadf8ed24293d09a1beb34d48_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_5a0df8ec586cff8aadf8ed24293d09a1beb34d48_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] [feat](case when) Push upper function into case when branch [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3506148342
# FE Regression Coverage Report
Increment line coverage ` 92.00% (92/100)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_a7b43fb0e933fc9c58cf8e0b4a26b2de28ea1880_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_a7b43fb0e933fc9c58cf8e0b4a26b2de28ea1880_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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3502237316
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3541033731
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3541279600
<details>
<summary>TPC-DS: <b>Total hot run time: 188725 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 caf1efb71eb2e24e58b51104280ade8282e1b387, data reload: false
query1 1023 446 391 391
query2 6550 1666 1692 1666
query3 6760 241 221 221
query4 27218 23432 23345 23345
query5 4486 641 515 515
query6 343 249 240 240
query7 4645 508 314 314
query8 309 275 256 256
query9 8662 2955 2939 2939
query10 515 369 309 309
query11 15806 14921 14885 14885
query12 190 128 120 120
query13 1692 583 472 472
query14 10499 9439 9389 9389
query15 203 188 171 171
query16 7680 696 467 467
query17 1252 796 646 646
query18 2042 435 353 353
query19 226 207 190 190
query20 143 131 121 121
query21 222 141 121 121
query22 3970 3930 4036 3930
query23 34102 32884 32883 32883
query24 8156 2436 2448 2436
query25 645 550 498 498
query26 1246 279 179 179
query27 2715 521 380 380
query28 4434 2278 2249 2249
query29 849 666 554 554
query30 308 229 202 202
query31 931 810 745 745
query32 96 91 81 81
query33 611 432 370 370
query34 821 867 543 543
query35 868 833 746 746
query36 957 1001 931 931
query37 130 121 93 93
query38 3487 3535 3446 3446
query39 1504 1420 1430 1420
query40 227 135 127 127
query41 62 58 58 58
query42 139 122 119 119
query43 485 483 464 464
query44 1306 810 795 795
query45 187 183 172 172
query46 934 1010 666 666
query47 1754 1755 1690 1690
query48 403 439 330 330
query49 758 497 416 416
query50 692 706 424 424
query51 3888 4026 3844 3844
query52 124 126 111 111
query53 247 272 215 215
query54 341 319 300 300
query55 96 94 97 94
query56 351 356 346 346
query57 1157 1176 1111 1111
query58 302 284 292 284
query59 2562 2603 2459 2459
query60 374 415 369 369
query61 154 163 157 157
query62 832 755 655 655
query63 243 203 196 196
query64 4443 1156 875 875
query65 4009 3917 3968 3917
query66 1140 445 348 348
query67 15002 15011 14714 14714
query68 8254 973 643 643
query69 490 340 321 321
query70 1333 1254 1275 1254
query71 491 360 343 343
query72 6030 4895 4953 4895
query73 713 636 372 372
query74 9345 9086 8934 8934
query75 3983 3269 2760 2760
query76 3772 1138 750 750
query77 818 435 347 347
query78 9598 9567 8768 8768
query79 2462 844 632 632
query80 665 609 534 534
query81 509 262 230 230
query82 477 160 137 137
query83 269 268 252 252
query84 251 112 93 93
query85 927 477 456 456
query86 398 320 297 297
query87 3693 3679 3622 3622
query88 3863 2293 2271 2271
query89 400 335 288 288
query90 1962 233 233 233
query91 170 170 139 139
query92 91 77 74 74
query93 1930 1014 679 679
query94 701 421 339 339
query95 434 349 340 340
query96 496 608 288 288
query97 2963 2959 2859 2859
query98 275 229 214 214
query99 1417 1424 1288 1288
Total cold run time: 277688 ms
Total hot run time: 188725 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3454898565
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3502428742
<details>
<summary>TPC-DS: <b>Total hot run time: 188215 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 5a0df8ec586cff8aadf8ed24293d09a1beb34d48, data reload: false
query1 1074 394 397 394
query2 6584 1726 1726 1726
query3 6757 227 232 227
query4 26955 24296 23592 23592
query5 4441 654 478 478
query6 326 236 220 220
query7 4642 504 314 314
query8 333 256 252 252
query9 8658 2590 2557 2557
query10 475 337 277 277
query11 15913 15060 14801 14801
query12 182 117 116 116
query13 1714 570 430 430
query14 11198 9345 9269 9269
query15 202 193 179 179
query16 7557 673 545 545
query17 1296 793 626 626
query18 2020 438 331 331
query19 209 209 180 180
query20 129 130 123 123
query21 221 143 117 117
query22 4328 4162 3985 3985
query23 33750 33063 32894 32894
query24 8444 2433 2456 2433
query25 588 500 449 449
query26 1242 269 158 158
query27 2766 488 352 352
query28 4385 2202 2187 2187
query29 783 609 492 492
query30 310 231 198 198
query31 915 800 714 714
query32 86 76 80 76
query33 584 375 313 313
query34 790 872 534 534
query35 851 840 741 741
query36 955 1001 903 903
query37 119 117 85 85
query38 3492 3560 3503 3503
query39 1503 1436 1430 1430
query40 222 128 119 119
query41 63 60 61 60
query42 131 110 115 110
query43 512 494 476 476
query44 1274 746 743 743
query45 192 183 176 176
query46 884 1006 648 648
query47 1767 1807 1698 1698
query48 407 427 320 320
query49 767 536 435 435
query50 649 690 423 423
query51 3934 3853 3848 3848
query52 112 111 105 105
query53 247 267 196 196
query54 325 283 279 279
query55 88 86 84 84
query56 327 312 307 307
query57 1172 1190 1119 1119
query58 286 271 272 271
query59 2517 2697 2552 2552
query60 342 360 326 326
query61 157 162 157 157
query62 788 745 677 677
query63 235 197 197 197
query64 4478 1178 951 951
query65 4041 3926 3986 3926
query66 1144 452 362 362
query67 15225 15114 14985 14985
query68 6873 878 606 606
query69 500 341 296 296
query70 1330 1323 1319 1319
query71 439 348 318 318
query72 5643 5011 4723 4723
query73 644 574 362 362
query74 8860 8891 8950 8891
query75 3326 3326 2824 2824
query76 3312 1176 749 749
query77 516 419 312 312
query78 9608 9699 8863 8863
query79 2846 808 603 603
query80 810 569 503 503
query81 534 262 225 225
query82 458 158 130 130
query83 269 264 251 251
query84 261 117 93 93
query85 946 482 448 448
query86 409 324 291 291
query87 3733 3743 3652 3652
query88 3915 2298 2284 2284
query89 397 327 296 296
query90 1909 236 237 236
query91 169 167 138 138
query92 79 67 65 65
query93 2593 997 636 636
query94 765 440 341 341
query95 397 329 319 319
query96 481 575 284 284
query97 2884 2944 2842 2842
query98 260 220 209 209
query99 1361 1434 1355 1355
Total cold run time: 275590 ms
Total hot run time: 188215 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3454970168
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546769768
<details>
<summary>TPC-H: <b>Total hot run time: 33888 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 20dee04388464e8c370b9fbc1c58572de608cc51, data reload: false
------ Round 1 ----------------------------------
q1 17612 5135 4934 4934
q2 2015 308 202 202
q3 10298 1281 723 723
q4 10229 890 365 365
q5 7484 2420 2297 2297
q6 184 170 135 135
q7 939 764 618 618
q8 9359 1322 1109 1109
q9 7041 5133 5188 5133
q10 6898 2214 1794 1794
q11 518 310 285 285
q12 385 365 227 227
q13 17788 3631 2986 2986
q14 238 233 211 211
q15 579 506 509 506
q16 1029 999 938 938
q17 584 858 366 366
q18 7606 7192 7006 7006
q19 1093 934 530 530
q20 355 354 234 234
q21 3849 3187 2311 2311
q22 1071 1051 978 978
Total cold run time: 107154 ms
Total hot run time: 33888 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4919 4931 4932 4931
q2 249 319 226 226
q3 2155 2661 2354 2354
q4 1328 1806 1355 1355
q5 4212 4315 4489 4315
q6 214 175 128 128
q7 2007 2030 1790 1790
q8 2671 2566 2690 2566
q9 7179 7324 7317 7317
q10 3032 3318 2828 2828
q11 593 562 505 505
q12 696 999 626 626
q13 3455 3835 3330 3330
q14 302 304 269 269
q15 561 495 494 494
q16 1057 1146 1043 1043
q17 1174 1574 1396 1396
q18 7937 7769 7533 7533
q19 781 760 870 760
q20 2037 2129 1889 1889
q21 4700 4330 4311 4311
q22 1116 1027 1026 1026
Total cold run time: 52375 ms
Total hot run time: 50992 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551024107
run feut
--
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3544778230
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551026574
run external
--
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3502452852
<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 5a0df8ec586cff8aadf8ed24293d09a1beb34d48, data reload: false
query1 0.05 0.04 0.04
query2 0.10 0.05 0.04
query3 0.26 0.08 0.08
query4 1.61 0.11 0.11
query5 0.28 0.25 0.24
query6 1.18 0.66 0.64
query7 0.03 0.03 0.02
query8 0.05 0.04 0.04
query9 0.59 0.52 0.52
query10 0.57 0.56 0.58
query11 0.16 0.11 0.11
query12 0.14 0.12 0.11
query13 0.61 0.61 0.60
query14 1.00 1.00 1.01
query15 0.84 0.83 0.83
query16 0.38 0.40 0.39
query17 1.05 1.02 1.01
query18 0.22 0.19 0.20
query19 1.90 1.72 1.81
query20 0.02 0.02 0.01
query21 15.43 0.17 0.13
query22 5.17 0.07 0.04
query23 15.69 0.26 0.10
query24 2.66 0.79 0.39
query25 0.08 0.07 0.06
query26 0.17 0.15 0.12
query27 0.06 0.05 0.05
query28 4.60 1.12 0.92
query29 12.54 3.87 3.22
query30 0.28 0.14 0.10
query31 2.82 0.58 0.37
query32 3.23 0.56 0.47
query33 3.03 3.10 3.05
query34 15.93 5.18 4.50
query35 4.58 4.58 4.54
query36 0.68 0.51 0.49
query37 0.10 0.07 0.06
query38 0.06 0.04 0.04
query39 0.04 0.03 0.03
query40 0.17 0.14 0.13
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.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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3502377721
<details>
<summary>TPC-H: <b>Total hot run time: 34298 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 5a0df8ec586cff8aadf8ed24293d09a1beb34d48, data reload: false
------ Round 1 ----------------------------------
q1 17596 5255 5064 5064
q2 1998 343 197 197
q3 10286 1280 716 716
q4 10211 851 375 375
q5 7546 2460 2291 2291
q6 184 165 138 138
q7 951 770 619 619
q8 9337 1343 1224 1224
q9 6928 5127 5200 5127
q10 6896 2218 1794 1794
q11 488 303 284 284
q12 336 376 238 238
q13 17776 3670 3056 3056
q14 232 236 211 211
q15 580 508 506 506
q16 1019 988 936 936
q17 589 875 375 375
q18 7506 7183 6984 6984
q19 1225 946 576 576
q20 362 350 231 231
q21 3928 2574 2370 2370
q22 1045 1051 986 986
Total cold run time: 107019 ms
Total hot run time: 34298 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5186 5130 5084 5084
q2 251 324 227 227
q3 2194 2666 2279 2279
q4 1368 1748 1337 1337
q5 4235 4352 4541 4352
q6 219 171 137 137
q7 2052 1992 1740 1740
q8 2701 2655 2521 2521
q9 7388 7232 7261 7232
q10 3007 3376 2870 2870
q11 588 531 512 512
q12 689 798 639 639
q13 3541 4003 3207 3207
q14 268 295 272 272
q15 551 500 514 500
q16 1075 1090 1081 1081
q17 1173 1519 1635 1519
q18 7883 7735 7492 7492
q19 874 865 889 865
q20 2008 2130 1945 1945
q21 4994 4299 4344 4299
q22 1079 1083 994 994
Total cold run time: 53324 ms
Total hot run time: 51104 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3455003425
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3400462088
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3401313262
# FE Regression Coverage Report
Increment line coverage ` 94.51% (86/91)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_858da7fe4ae69a9a91ea92f0411e1a80a40782cf_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_858da7fe4ae69a9a91ea92f0411e1a80a40782cf_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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3506025534
<details>
<summary>TPC-H: <b>Total hot run time: 34351 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 a7b43fb0e933fc9c58cf8e0b4a26b2de28ea1880, data reload: false
------ Round 1 ----------------------------------
q1 17738 5205 5076 5076
q2 2272 346 209 209
q3 10287 1247 719 719
q4 10335 888 371 371
q5 7525 2313 2357 2313
q6 178 166 136 136
q7 888 771 621 621
q8 9379 1328 1148 1148
q9 7151 5337 5227 5227
q10 7271 2268 1843 1843
q11 548 307 300 300
q12 451 368 236 236
q13 18116 3647 3016 3016
q14 252 231 208 208
q15 575 508 510 508
q16 1031 1008 944 944
q17 582 869 363 363
q18 7770 7082 7156 7082
q19 1201 931 539 539
q20 351 340 231 231
q21 3688 2519 2287 2287
q22 1070 1026 974 974
Total cold run time: 108659 ms
Total hot run time: 34351 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5170 5096 5038 5038
q2 246 329 232 232
q3 2157 2719 2317 2317
q4 1350 1759 1316 1316
q5 4438 4506 4371 4371
q6 208 189 138 138
q7 2029 1997 1899 1899
q8 2606 2624 2603 2603
q9 7369 7409 7267 7267
q10 3068 3357 2789 2789
q11 595 543 486 486
q12 629 755 603 603
q13 3483 3913 3291 3291
q14 310 311 267 267
q15 538 508 500 500
q16 1069 1103 1059 1059
q17 1197 1561 1490 1490
q18 7943 7770 7602 7602
q19 774 802 919 802
q20 1928 1946 1838 1838
q21 4786 4354 4352 4352
q22 1083 1055 963 963
Total cold run time: 52976 ms
Total hot run time: 51223 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3454972878
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546838777
<details>
<summary>TPC-DS: <b>Total hot run time: 189012 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 20dee04388464e8c370b9fbc1c58572de608cc51, data reload: false
query1 1020 426 393 393
query2 6569 1707 1687 1687
query3 6761 232 222 222
query4 26786 22825 22904 22825
query5 4433 667 511 511
query6 349 263 229 229
query7 4640 499 315 315
query8 311 265 254 254
query9 8659 2937 2949 2937
query10 506 367 306 306
query11 15915 15024 14752 14752
query12 193 126 124 124
query13 1712 593 451 451
query14 11060 9364 9351 9351
query15 206 192 180 180
query16 7445 656 537 537
query17 1256 784 651 651
query18 2018 427 342 342
query19 224 210 183 183
query20 138 128 129 128
query21 219 135 117 117
query22 4093 4227 4021 4021
query23 34117 33187 33008 33008
query24 8146 2405 2412 2405
query25 631 580 494 494
query26 1241 282 178 178
query27 2737 514 360 360
query28 4412 2252 2241 2241
query29 826 667 528 528
query30 301 227 199 199
query31 920 816 719 719
query32 96 85 86 85
query33 600 407 376 376
query34 792 864 525 525
query35 871 837 776 776
query36 916 981 889 889
query37 134 115 99 99
query38 3530 3479 3470 3470
query39 1469 1453 1394 1394
query40 234 137 129 129
query41 63 59 62 59
query42 134 119 116 116
query43 484 468 461 461
query44 1253 799 803 799
query45 189 186 193 186
query46 889 992 638 638
query47 1745 1786 1750 1750
query48 413 438 326 326
query49 783 495 418 418
query50 656 681 403 403
query51 3871 3963 3929 3929
query52 118 114 111 111
query53 254 293 200 200
query54 347 320 297 297
query55 95 97 89 89
query56 352 346 328 328
query57 1182 1242 1113 1113
query58 296 294 286 286
query59 2421 2567 2561 2561
query60 370 374 352 352
query61 163 157 159 157
query62 815 696 641 641
query63 227 199 195 195
query64 4427 1200 883 883
query65 4018 3933 3943 3933
query66 1177 438 352 352
query67 15273 15059 15021 15021
query68 8235 948 651 651
query69 506 358 307 307
query70 1409 1255 1296 1255
query71 473 354 359 354
query72 5901 4893 5044 4893
query73 707 576 368 368
query74 8913 9047 8869 8869
query75 3920 3249 2742 2742
query76 3681 1129 759 759
query77 821 424 337 337
query78 9485 9706 9279 9279
query79 2179 870 613 613
query80 680 605 547 547
query81 481 257 236 236
query82 431 164 135 135
query83 266 261 247 247
query84 245 123 92 92
query85 894 482 451 451
query86 349 331 324 324
query87 3656 3697 3628 3628
query88 3427 2229 2206 2206
query89 389 325 297 297
query90 1966 239 228 228
query91 175 166 139 139
query92 90 78 74 74
query93 1407 1019 703 703
query94 715 429 342 342
query95 416 351 347 347
query96 482 581 284 284
query97 2897 2989 2846 2846
query98 240 223 225 223
query99 1405 1383 1241 1241
Total cold run time: 275342 ms
Total hot run time: 189012 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551025548
run 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3454986213
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3400774378
<details>
<summary>ClickBench: <b>Total hot run time: 30.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 858da7fe4ae69a9a91ea92f0411e1a80a40782cf, data reload: false
query1 0.05 0.04 0.05
query2 0.09 0.04 0.06
query3 0.26 0.09 0.08
query4 1.61 0.12 0.12
query5 0.28 0.26 0.25
query6 1.18 0.64 0.65
query7 0.04 0.03 0.03
query8 0.06 0.04 0.05
query9 0.64 0.54 0.52
query10 0.59 0.58 0.59
query11 0.16 0.11 0.11
query12 0.15 0.11 0.12
query13 0.63 0.61 0.62
query14 1.04 1.03 1.02
query15 0.89 0.85 0.88
query16 0.40 0.40 0.39
query17 1.02 1.11 1.01
query18 0.22 0.20 0.20
query19 1.95 1.82 1.86
query20 0.01 0.01 0.02
query21 15.41 0.92 0.59
query22 0.76 1.22 0.68
query23 14.92 1.39 0.66
query24 7.18 0.79 0.47
query25 0.48 0.26 0.10
query26 0.56 0.17 0.13
query27 0.07 0.06 0.06
query28 9.38 1.39 0.95
query29 12.64 4.00 3.34
query30 0.27 0.13 0.12
query31 2.82 0.58 0.39
query32 3.24 0.56 0.51
query33 3.08 3.10 3.09
query34 16.19 5.45 4.87
query35 4.97 4.96 4.94
query36 0.71 0.52 0.50
query37 0.10 0.08 0.08
query38 0.07 0.05 0.05
query39 0.03 0.03 0.03
query40 0.18 0.15 0.15
query41 0.09 0.04 0.03
query42 0.04 0.03 0.04
query43 0.05 0.03 0.03
Total cold run time: 104.51 s
Total hot run time: 30.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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546311117
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551308920
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551403684
# FE Regression Coverage Report
Increment line coverage ` 93.75% (90/96)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_20dee04388464e8c370b9fbc1c58572de608cc51_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_20dee04388464e8c370b9fbc1c58572de608cc51_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] [feat](case when) Push upper function into case when branch [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3414223141
# FE Regression Coverage Report
Increment line coverage ` 94.51% (86/91)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_d02c24c3a242d0060b6fc1bfee6d741cece966cd_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_d02c24c3a242d0060b6fc1bfee6d741cece966cd_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] [feat](case when) Push upper function into case when branch [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3541835174
# FE Regression Coverage Report
Increment line coverage ` 92.00% (92/100)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_caf1efb71eb2e24e58b51104280ade8282e1b387_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_caf1efb71eb2e24e58b51104280ade8282e1b387_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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3400419897
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3400755512
<details>
<summary>TPC-DS: <b>Total hot run time: 190920 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 858da7fe4ae69a9a91ea92f0411e1a80a40782cf, data reload: false
query1 1087 440 406 406
query2 6604 1640 1686 1640
query3 6748 229 223 223
query4 26807 23737 23587 23587
query5 5684 626 479 479
query6 360 228 223 223
query7 4660 491 307 307
query8 318 267 244 244
query9 8695 2558 2545 2545
query10 545 332 292 292
query11 15557 15093 15518 15093
query12 199 143 138 138
query13 1700 582 458 458
query14 11664 9532 9502 9502
query15 216 201 185 185
query16 7900 743 569 569
query17 2003 827 653 653
query18 2227 436 339 339
query19 209 211 181 181
query20 130 125 121 121
query21 216 134 137 134
query22 4648 4678 4642 4642
query23 34736 34393 33943 33943
query24 8731 2472 2429 2429
query25 572 486 446 446
query26 1227 265 153 153
query27 2732 502 341 341
query28 4393 2163 2151 2151
query29 774 596 469 469
query30 299 218 196 196
query31 904 780 745 745
query32 80 65 70 65
query33 615 368 313 313
query34 811 841 508 508
query35 779 833 759 759
query36 967 991 933 933
query37 115 109 84 84
query38 3501 3528 3497 3497
query39 1475 1424 1420 1420
query40 216 123 116 116
query41 60 64 61 61
query42 120 107 110 107
query43 488 500 474 474
query44 1301 821 812 812
query45 179 180 178 178
query46 827 987 638 638
query47 1739 1819 1767 1767
query48 390 426 316 316
query49 755 509 414 414
query50 626 697 413 413
query51 3905 3909 3862 3862
query52 116 112 107 107
query53 242 262 216 216
query54 617 589 545 545
query55 83 90 88 88
query56 343 317 305 305
query57 1199 1222 1127 1127
query58 284 284 271 271
query59 2553 2644 2496 2496
query60 352 332 319 319
query61 152 150 153 150
query62 806 727 677 677
query63 221 200 190 190
query64 4384 1202 827 827
query65 4039 3999 3970 3970
query66 1036 420 353 353
query67 15821 15574 15192 15192
query68 7942 926 597 597
query69 529 314 282 282
query70 1266 1294 1279 1279
query71 466 336 308 308
query72 5741 5029 4902 4902
query73 628 582 361 361
query74 8856 9254 8872 8872
query75 3652 3352 2865 2865
query76 3497 1156 736 736
query77 725 412 322 322
query78 9544 9714 8903 8903
query79 2156 847 593 593
query80 632 561 509 509
query81 483 258 232 232
query82 424 168 134 134
query83 301 270 249 249
query84 304 118 94 94
query85 912 475 427 427
query86 351 321 287 287
query87 3727 3811 3672 3672
query88 3574 2231 2259 2231
query89 396 317 296 296
query90 1968 216 213 213
query91 164 164 132 132
query92 79 71 64 64
query93 1697 970 646 646
query94 731 455 340 340
query95 395 326 316 316
query96 485 571 278 278
query97 2955 2995 2882 2882
query98 251 216 209 209
query99 1413 1402 1285 1285
Total cold run time: 279986 ms
Total hot run time: 190920 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3505999308
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3506036790
<details>
<summary>TPC-DS: <b>Total hot run time: 185655 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 a7b43fb0e933fc9c58cf8e0b4a26b2de28ea1880, data reload: false
query1 1660 406 386 386
query2 6748 1692 1735 1692
query3 6881 228 221 221
query4 26241 23615 23394 23394
query5 4467 636 447 447
query6 324 252 225 225
query7 4653 526 299 299
query8 307 248 230 230
query9 8671 2573 2571 2571
query10 480 337 292 292
query11 15820 15203 14943 14943
query12 173 119 113 113
query13 1718 574 445 445
query14 10618 9216 9170 9170
query15 199 186 178 178
query16 7379 705 553 553
query17 1294 798 647 647
query18 2072 432 347 347
query19 235 211 183 183
query20 137 124 122 122
query21 520 138 121 121
query22 4193 4257 3924 3924
query23 33923 33184 32885 32885
query24 8518 2440 2397 2397
query25 642 528 446 446
query26 1254 265 156 156
query27 2738 493 343 343
query28 4347 2202 2187 2187
query29 833 617 482 482
query30 320 224 203 203
query31 943 826 726 726
query32 87 68 73 68
query33 597 383 323 323
query34 772 858 546 546
query35 813 843 757 757
query36 943 1001 906 906
query37 142 111 95 95
query38 3498 3597 3532 3532
query39 1499 1479 1482 1479
query40 417 128 119 119
query41 67 62 64 62
query42 128 110 110 110
query43 476 464 459 459
query44 1230 757 760 757
query45 190 189 178 178
query46 868 984 629 629
query47 1745 1810 1703 1703
query48 414 429 325 325
query49 983 520 425 425
query50 637 690 402 402
query51 3897 3975 4003 3975
query52 110 110 100 100
query53 243 263 192 192
query54 313 296 277 277
query55 88 86 86 86
query56 340 319 327 319
query57 1198 1201 1154 1154
query58 291 280 272 272
query59 2661 2608 2497 2497
query60 339 339 314 314
query61 161 150 158 150
query62 796 748 664 664
query63 219 190 194 190
query64 4573 1143 841 841
query65 4017 3986 3969 3969
query66 1219 437 344 344
query67 15230 15287 14917 14917
query68 7936 915 596 596
query69 546 318 276 276
query70 1282 1282 1288 1282
query71 433 328 321 321
query72 6005 2663 5358 2663
query73 758 766 361 361
query74 9004 8942 9099 8942
query75 3270 3295 2860 2860
query76 3338 1146 726 726
query77 502 418 317 317
query78 9557 9533 8855 8855
query79 2229 804 586 586
query80 617 563 498 498
query81 521 270 234 234
query82 485 161 126 126
query83 270 260 236 236
query84 275 114 92 92
query85 934 486 440 440
query86 384 318 311 311
query87 3767 3783 3589 3589
query88 3923 2248 2201 2201
query89 394 327 287 287
query90 1991 216 211 211
query91 171 172 138 138
query92 77 69 62 62
query93 1870 980 634 634
query94 730 459 356 356
query95 422 338 320 320
query96 481 574 287 287
query97 2914 2977 2878 2878
query98 248 218 210 210
query99 1357 1439 1296 1296
Total cold run time: 276200 ms
Total hot run time: 185655 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546416736
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3541232469
<details>
<summary>TPC-H: <b>Total hot run time: 34336 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 caf1efb71eb2e24e58b51104280ade8282e1b387, data reload: false
------ Round 1 ----------------------------------
q1 17621 5128 4998 4998
q2 2084 305 208 208
q3 10250 1254 717 717
q4 10235 940 374 374
q5 7513 2466 2298 2298
q6 185 170 139 139
q7 906 753 613 613
q8 9327 1358 1287 1287
q9 6857 5034 5231 5034
q10 6936 2256 1845 1845
q11 518 305 281 281
q12 349 371 242 242
q13 18066 3722 3079 3079
q14 230 241 221 221
q15 619 504 492 492
q16 1022 1016 958 958
q17 594 876 389 389
q18 7867 7267 7075 7075
q19 1091 949 575 575
q20 347 339 235 235
q21 3687 3210 2291 2291
q22 1081 1047 985 985
Total cold run time: 107385 ms
Total hot run time: 34336 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5102 5083 5112 5083
q2 246 356 232 232
q3 2117 2661 2290 2290
q4 1403 1752 1331 1331
q5 4171 4483 4434 4434
q6 211 186 141 141
q7 2015 1999 1799 1799
q8 2652 2634 2580 2580
q9 7341 7152 7391 7152
q10 3089 3244 2810 2810
q11 621 511 502 502
q12 681 813 664 664
q13 3843 3850 3206 3206
q14 283 287 285 285
q15 546 497 499 497
q16 1099 1155 1067 1067
q17 1211 1484 1405 1405
q18 7940 7777 7524 7524
q19 845 863 891 863
q20 1877 2011 1819 1819
q21 4721 4297 4152 4152
q22 1091 1049 999 999
Total cold run time: 53105 ms
Total hot run time: 50835 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3455122175
<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 34d00c92288c72ce5cd057473306aeaeb03fe9d2, data reload: false
query1 0.05 0.05 0.04
query2 0.10 0.06 0.05
query3 0.25 0.09 0.08
query4 1.61 0.11 0.11
query5 0.29 0.27 0.25
query6 1.18 0.67 0.66
query7 0.03 0.03 0.03
query8 0.05 0.04 0.04
query9 0.62 0.53 0.53
query10 0.58 0.58 0.58
query11 0.16 0.11 0.11
query12 0.16 0.13 0.12
query13 0.63 0.61 0.60
query14 1.01 1.02 1.01
query15 0.84 0.83 0.84
query16 0.40 0.41 0.40
query17 1.03 1.09 1.02
query18 0.21 0.20 0.20
query19 1.94 1.78 1.90
query20 0.01 0.02 0.02
query21 15.42 0.20 0.13
query22 5.03 0.07 0.05
query23 15.67 0.26 0.10
query24 2.41 0.74 0.30
query25 0.08 0.06 0.07
query26 0.14 0.14 0.12
query27 0.07 0.05 0.06
query28 3.82 1.18 0.94
query29 12.69 4.04 3.25
query30 0.28 0.15 0.11
query31 2.82 0.61 0.39
query32 3.23 0.54 0.48
query33 3.00 3.00 3.01
query34 15.87 5.12 4.55
query35 4.55 4.55 4.56
query36 0.67 0.50 0.50
query37 0.10 0.07 0.07
query38 0.07 0.05 0.04
query39 0.04 0.03 0.03
query40 0.17 0.13 0.15
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: 97.44 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3400730074
# FE UT Coverage Report
Increment line coverage ` 98.90% (90/91)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_858da7fe4ae69a9a91ea92f0411e1a80a40782cf/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_858da7fe4ae69a9a91ea92f0411e1a80a40782cf/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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3454908597
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3455598365
# FE Regression Coverage Report
Increment line coverage ` 91.84% (90/98)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_34d00c92288c72ce5cd057473306aeaeb03fe9d2_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_34d00c92288c72ce5cd057473306aeaeb03fe9d2_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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3502376442
run feut
--
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3551395796
# FE Regression Coverage Report
Increment line coverage ` 93.75% (90/96)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/56941_20dee04388464e8c370b9fbc1c58572de608cc51_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/56941_20dee04388464e8c370b9fbc1c58572de608cc51_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] [feat](case when) Push upper function into case when branch [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3541299527
<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 caf1efb71eb2e24e58b51104280ade8282e1b387, data reload: false
query1 0.05 0.04 0.05
query2 0.09 0.05 0.05
query3 0.25 0.08 0.09
query4 1.63 0.11 0.11
query5 0.27 0.25 0.25
query6 1.19 0.64 0.66
query7 0.03 0.03 0.02
query8 0.05 0.04 0.04
query9 0.59 0.53 0.52
query10 0.57 0.56 0.57
query11 0.17 0.11 0.11
query12 0.14 0.12 0.12
query13 0.62 0.61 0.60
query14 1.00 1.00 1.00
query15 0.85 0.83 0.84
query16 0.40 0.39 0.39
query17 1.06 1.05 0.99
query18 0.21 0.20 0.20
query19 1.98 1.86 1.80
query20 0.01 0.02 0.01
query21 15.44 0.20 0.13
query22 5.01 0.06 0.06
query23 15.66 0.26 0.10
query24 2.16 1.42 0.40
query25 0.07 0.06 0.05
query26 0.14 0.13 0.15
query27 0.07 0.06 0.04
query28 4.81 1.10 0.93
query29 12.61 3.96 3.22
query30 0.28 0.13 0.12
query31 2.82 0.59 0.38
query32 3.23 0.55 0.46
query33 3.07 3.08 3.11
query34 15.78 5.21 4.51
query35 4.57 4.55 4.62
query36 0.68 0.50 0.49
query37 0.09 0.06 0.06
query38 0.06 0.04 0.04
query39 0.04 0.02 0.02
query40 0.17 0.14 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: 98.1 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] [feat](case when) Push upper function into case when branch [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546416911
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3546431386
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] [feat](case when) Push upper function into case when branch [doris]
Posted by "yujun777 (via GitHub)" <gi...@apache.org>.
yujun777 commented on PR #56941:
URL: https://github.com/apache/doris/pull/56941#issuecomment-3413685671
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