You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Gabriel39 (via GitHub)" <gi...@apache.org> on 2026/01/07 07:57:45 UTC
[PR] [refactor](predicates) Simplify predicates and profile [doris]
Gabriel39 opened a new pull request, #59625:
URL: https://github.com/apache/doris/pull/59625
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### 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] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3722886958
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3726729485
skip check_coverage
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "Gabriel39 (via GitHub)" <gi...@apache.org>.
Gabriel39 commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3721797071
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3722044896
<details>
<summary>ClickBench: <b>Total hot run time: 27.32 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 7011528d7d59c6d0c558d02c028ef02e91962d6b, data reload: false
query1 0.06 0.05 0.05
query2 0.09 0.05 0.04
query3 0.26 0.09 0.09
query4 1.60 0.11 0.12
query5 0.28 0.25 0.26
query6 1.17 0.66 0.65
query7 0.03 0.03 0.03
query8 0.05 0.05 0.04
query9 0.57 0.51 0.51
query10 0.56 0.55 0.56
query11 0.14 0.10 0.10
query12 0.13 0.11 0.11
query13 0.60 0.59 0.59
query14 0.95 0.94 0.96
query15 0.79 0.78 0.80
query16 0.42 0.37 0.40
query17 1.02 1.06 1.09
query18 0.23 0.21 0.21
query19 1.92 1.88 1.85
query20 0.02 0.02 0.01
query21 15.35 0.23 0.10
query22 4.80 0.05 0.04
query23 15.80 0.29 0.11
query24 5.31 0.75 0.51
query25 1.07 0.27 0.15
query26 0.14 0.14 0.14
query27 0.15 0.14 0.15
query28 1.50 0.96 0.88
query29 12.59 3.95 3.20
query30 0.27 0.13 0.14
query31 2.83 0.66 0.42
query32 3.23 0.56 0.45
query33 3.01 2.96 3.10
query34 16.60 5.12 4.46
query35 4.49 4.56 4.45
query36 0.68 0.49 0.50
query37 0.11 0.06 0.06
query38 0.11 0.04 0.04
query39 0.04 0.03 0.03
query40 0.18 0.15 0.13
query41 0.08 0.03 0.04
query42 0.04 0.04 0.03
query43 0.05 0.04 0.03
Total cold run time: 99.32 s
Total hot run time: 27.32 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3718406572
<details>
<summary>ClickBench: <b>Total hot run time: 27.25 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 e4c2db599d158a3cd2402180a17d58ca17f5a201, data reload: false
query1 0.05 0.04 0.04
query2 0.10 0.05 0.05
query3 0.26 0.09 0.08
query4 1.62 0.11 0.11
query5 0.28 0.25 0.24
query6 1.16 0.66 0.65
query7 0.03 0.02 0.03
query8 0.05 0.04 0.04
query9 0.58 0.50 0.50
query10 0.55 0.55 0.56
query11 0.14 0.10 0.10
query12 0.14 0.11 0.11
query13 0.60 0.58 0.58
query14 0.96 0.95 0.93
query15 0.79 0.78 0.80
query16 0.42 0.41 0.39
query17 1.04 1.04 1.06
query18 0.24 0.22 0.21
query19 1.97 1.86 1.88
query20 0.02 0.02 0.01
query21 15.45 0.28 0.14
query22 5.27 0.05 0.04
query23 15.94 0.29 0.11
query24 1.54 1.32 0.52
query25 0.11 0.06 0.06
query26 0.14 0.12 0.12
query27 0.06 0.07 0.06
query28 4.15 1.08 0.88
query29 12.61 4.04 3.26
query30 0.28 0.13 0.12
query31 2.82 0.65 0.40
query32 3.25 0.56 0.46
query33 3.08 3.06 3.04
query34 16.53 5.06 4.46
query35 4.43 4.47 4.46
query36 0.66 0.52 0.48
query37 0.11 0.07 0.06
query38 0.08 0.05 0.04
query39 0.04 0.03 0.03
query40 0.16 0.15 0.13
query41 0.08 0.03 0.03
query42 0.05 0.03 0.03
query43 0.04 0.03 0.03
Total cold run time: 97.88 s
Total hot run time: 27.25 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3722021032
<details>
<summary>TPC-DS: <b>Total hot run time: 172830 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 7011528d7d59c6d0c558d02c028ef02e91962d6b, data reload: false
query5 4631 598 440 440
query6 348 223 213 213
query7 4209 460 262 262
query8 328 248 236 236
query9 8760 2628 2653 2628
query10 499 375 315 315
query11 15260 15164 14860 14860
query12 177 116 117 116
query13 1261 485 386 386
query14 6293 2992 2710 2710
query14_1 2788 2635 2640 2635
query15 202 196 176 176
query16 1000 482 457 457
query17 1144 672 587 587
query18 2560 467 327 327
query19 220 217 189 189
query20 126 118 117 117
query21 218 142 120 120
query22 4037 3891 4073 3891
query23 16030 15844 15355 15355
query23_1 15415 15552 15457 15457
query24 7424 1542 1142 1142
query24_1 1192 1151 1174 1151
query25 530 449 387 387
query26 818 265 154 154
query27 2763 453 280 280
query28 4478 2132 2118 2118
query29 751 526 438 438
query30 299 228 197 197
query31 792 631 550 550
query32 81 71 66 66
query33 541 366 290 290
query34 869 898 505 505
query35 713 794 677 677
query36 857 883 810 810
query37 131 93 75 75
query38 2751 2739 2645 2645
query39 767 769 738 738
query39_1 726 704 712 704
query40 220 134 115 115
query41 61 57 59 57
query42 108 97 99 97
query43 451 461 402 402
query44 1345 714 713 713
query45 186 182 179 179
query46 862 1000 590 590
query47 1439 1554 1358 1358
query48 307 311 240 240
query49 591 439 337 337
query50 622 269 206 206
query51 3792 3890 3756 3756
query52 102 107 95 95
query53 290 325 282 282
query54 276 259 243 243
query55 74 78 71 71
query56 278 294 293 293
query57 992 1013 962 962
query58 266 257 256 256
query59 2031 2075 1998 1998
query60 324 323 297 297
query61 164 166 176 166
query62 391 362 338 338
query63 293 271 271 271
query64 4219 1301 1013 1013
query65 3826 3695 3757 3695
query66 1377 426 313 313
query67 15138 15611 14643 14643
query68 2766 1015 735 735
query69 437 351 311 311
query70 1021 971 971 971
query71 317 297 277 277
query72 5803 3760 3744 3744
query73 601 717 302 302
query74 8889 8862 8655 8655
query75 2795 2811 2451 2451
query76 2860 1068 635 635
query77 352 386 296 296
query78 9806 9960 9151 9151
query79 1021 916 581 581
query80 908 567 473 473
query81 519 264 228 228
query82 812 146 111 111
query83 372 261 246 246
query84 261 122 106 106
query85 898 543 462 462
query86 411 318 319 318
query87 2857 2922 2764 2764
query88 3197 2201 2190 2190
query89 391 357 330 330
query90 1954 159 154 154
query91 178 174 143 143
query92 72 72 62 62
query93 923 896 527 527
query94 548 313 296 296
query95 574 337 317 317
query96 597 483 206 206
query97 2333 2393 2305 2305
query98 208 200 201 200
query99 627 616 507 507
Total cold run time: 247047 ms
Total hot run time: 172830 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "Gabriel39 (via GitHub)" <gi...@apache.org>.
Gabriel39 merged PR #59625:
URL: https://github.com/apache/doris/pull/59625
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3718387750
<details>
<summary>TPC-DS: <b>Total hot run time: 172249 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 e4c2db599d158a3cd2402180a17d58ca17f5a201, data reload: false
query5 4411 612 421 421
query6 327 235 218 218
query7 4224 461 256 256
query8 321 237 236 236
query9 8727 2635 2658 2635
query10 536 362 321 321
query11 15252 15253 14820 14820
query12 200 116 109 109
query13 1235 474 355 355
query14 6245 2998 2730 2730
query14_1 2697 2622 2637 2622
query15 204 195 177 177
query16 979 455 447 447
query17 1080 638 561 561
query18 2624 428 366 366
query19 253 224 190 190
query20 123 116 112 112
query21 217 136 117 117
query22 3916 3938 4048 3938
query23 16059 15599 15291 15291
query23_1 15433 15528 15277 15277
query24 7355 1550 1156 1156
query24_1 1178 1156 1208 1156
query25 529 433 393 393
query26 1235 266 160 160
query27 2774 452 281 281
query28 4572 2104 2107 2104
query29 762 532 461 461
query30 312 245 223 223
query31 839 626 550 550
query32 76 70 67 67
query33 546 319 286 286
query34 891 882 522 522
query35 747 797 713 713
query36 883 887 829 829
query37 133 93 80 80
query38 2724 2688 2633 2633
query39 793 744 715 715
query39_1 709 698 721 698
query40 219 129 115 115
query41 65 64 62 62
query42 103 107 113 107
query43 444 441 463 441
query44 1334 733 719 719
query45 186 181 177 177
query46 860 947 579 579
query47 1344 1439 1336 1336
query48 314 320 239 239
query49 617 418 325 325
query50 641 282 200 200
query51 3755 3861 3743 3743
query52 101 105 94 94
query53 287 325 269 269
query54 289 256 243 243
query55 77 76 68 68
query56 287 298 297 297
query57 1017 974 923 923
query58 272 250 249 249
query59 2077 2092 2079 2079
query60 331 336 313 313
query61 193 181 194 181
query62 425 363 333 333
query63 310 274 286 274
query64 5038 1406 1093 1093
query65 3838 3702 3762 3702
query66 1424 435 346 346
query67 15400 14671 15878 14671
query68 3250 1053 717 717
query69 503 362 326 326
query70 969 943 888 888
query71 346 300 285 285
query72 6280 3553 3402 3402
query73 699 729 297 297
query74 8797 8752 8620 8620
query75 2802 2804 2481 2481
query76 3875 1083 659 659
query77 517 384 273 273
query78 9814 10119 9177 9177
query79 964 915 599 599
query80 1153 572 483 483
query81 552 266 230 230
query82 414 145 112 112
query83 358 254 234 234
query84 258 126 106 106
query85 1029 515 454 454
query86 386 300 293 293
query87 2868 2872 2755 2755
query88 3223 2223 2183 2183
query89 381 355 322 322
query90 1916 156 155 155
query91 176 165 153 153
query92 69 65 63 63
query93 1051 896 539 539
query94 648 329 292 292
query95 583 325 365 325
query96 580 475 206 206
query97 2314 2372 2289 2289
query98 218 205 195 195
query99 584 559 522 522
Total cold run time: 250106 ms
Total hot run time: 172249 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3718199059
PR approved by anyone and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3723024245
<details>
<summary>ClickBench: <b>Total hot run time: 26.85 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 a418ce4593bb2e84eb5becd839d43754d380558f, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.04
query3 0.25 0.09 0.09
query4 1.61 0.12 0.12
query5 0.29 0.28 0.26
query6 1.14 0.68 0.66
query7 0.03 0.02 0.03
query8 0.05 0.03 0.04
query9 0.57 0.50 0.49
query10 0.55 0.56 0.54
query11 0.14 0.10 0.09
query12 0.14 0.10 0.10
query13 0.61 0.57 0.59
query14 0.96 0.96 0.95
query15 0.78 0.77 0.79
query16 0.39 0.40 0.39
query17 0.99 1.04 1.03
query18 0.23 0.22 0.21
query19 1.94 1.89 1.88
query20 0.02 0.01 0.01
query21 15.45 0.27 0.14
query22 5.22 0.05 0.05
query23 16.00 0.29 0.10
query24 2.42 0.61 0.20
query25 0.10 0.06 0.06
query26 0.14 0.14 0.14
query27 0.07 0.05 0.05
query28 5.11 1.04 0.87
query29 12.62 3.97 3.16
query30 0.27 0.14 0.12
query31 2.83 0.63 0.40
query32 3.24 0.57 0.45
query33 3.04 3.04 3.05
query34 16.65 5.08 4.45
query35 4.49 4.52 4.51
query36 0.65 0.50 0.48
query37 0.10 0.06 0.07
query38 0.07 0.05 0.03
query39 0.04 0.03 0.03
query40 0.16 0.15 0.13
query41 0.08 0.03 0.03
query42 0.04 0.03 0.02
query43 0.04 0.04 0.03
Total cold run time: 99.67 s
Total hot run time: 26.85 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3723003747
<details>
<summary>TPC-DS: <b>Total hot run time: 172567 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 a418ce4593bb2e84eb5becd839d43754d380558f, data reload: false
query5 4405 591 441 441
query6 334 233 211 211
query7 4215 455 266 266
query8 328 247 235 235
query9 8769 2639 2653 2639
query10 479 372 336 336
query11 15157 15187 14962 14962
query12 169 118 124 118
query13 1262 491 398 398
query14 6025 2975 2761 2761
query14_1 2718 2679 2733 2679
query15 198 192 177 177
query16 999 396 451 396
query17 1117 698 587 587
query18 2447 450 348 348
query19 233 223 201 201
query20 124 120 115 115
query21 214 141 120 120
query22 3992 4103 3760 3760
query23 15930 15676 15379 15379
query23_1 15334 15475 15350 15350
query24 7385 1568 1173 1173
query24_1 1214 1175 1181 1175
query25 574 478 442 442
query26 1236 274 166 166
query27 2750 472 294 294
query28 4492 2143 2152 2143
query29 843 573 465 465
query30 308 246 213 213
query31 781 640 567 567
query32 79 70 72 70
query33 564 345 303 303
query34 892 886 522 522
query35 726 763 703 703
query36 872 869 822 822
query37 124 93 80 80
query38 2711 2664 2632 2632
query39 784 776 738 738
query39_1 697 734 713 713
query40 218 133 117 117
query41 64 63 65 63
query42 105 103 103 103
query43 447 442 430 430
query44 1343 731 722 722
query45 189 186 183 183
query46 870 979 592 592
query47 1458 1468 1384 1384
query48 309 325 235 235
query49 600 417 327 327
query50 640 270 199 199
query51 3791 3761 3800 3761
query52 106 110 98 98
query53 281 330 277 277
query54 274 256 247 247
query55 78 76 74 74
query56 283 295 286 286
query57 1005 1017 905 905
query58 268 253 252 252
query59 2122 2194 2066 2066
query60 323 316 296 296
query61 176 160 161 160
query62 397 359 311 311
query63 304 270 277 270
query64 5071 1297 1028 1028
query65 3786 3705 3749 3705
query66 1432 402 301 301
query67 15659 14816 14909 14816
query68 6065 991 706 706
query69 507 342 306 306
query70 1073 991 919 919
query71 361 302 278 278
query72 6090 3372 3403 3372
query73 762 718 298 298
query74 8777 8786 8614 8614
query75 2816 2819 2457 2457
query76 3848 1042 632 632
query77 504 404 272 272
query78 9726 9863 9189 9189
query79 1632 925 590 590
query80 1377 574 488 488
query81 572 262 236 236
query82 403 141 110 110
query83 274 255 241 241
query84 257 120 105 105
query85 921 514 451 451
query86 359 323 338 323
query87 2972 2867 2765 2765
query88 3229 2226 2220 2220
query89 374 349 339 339
query90 2010 155 146 146
query91 175 167 147 147
query92 74 67 61 61
query93 1181 918 530 530
query94 651 302 301 301
query95 567 336 369 336
query96 605 457 202 202
query97 2347 2360 2305 2305
query98 244 200 206 200
query99 588 613 518 518
Total cold run time: 253369 ms
Total hot run time: 172567 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "Gabriel39 (via GitHub)" <gi...@apache.org>.
Gabriel39 commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3717723125
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3718198947
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3722961854
<details>
<summary>TPC-H: <b>Total hot run time: 31846 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 a418ce4593bb2e84eb5becd839d43754d380558f, data reload: false
------ Round 1 ----------------------------------
q1 17609 4202 4035 4035
q2 2030 350 241 241
q3 10160 1243 695 695
q4 10219 882 318 318
q5 7530 2068 1887 1887
q6 193 177 140 140
q7 946 792 663 663
q8 9294 1415 1154 1154
q9 4834 4558 4599 4558
q10 6781 1806 1396 1396
q11 514 298 282 282
q12 684 751 581 581
q13 17791 3845 3071 3071
q14 289 295 280 280
q15 582 503 497 497
q16 679 680 620 620
q17 683 841 460 460
q18 6582 6529 6620 6529
q19 1139 1077 635 635
q20 435 387 281 281
q21 3248 2581 2445 2445
q22 1117 1110 1078 1078
Total cold run time: 103339 ms
Total hot run time: 31846 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4310 4329 4241 4241
q2 345 418 344 344
q3 2265 2762 2461 2461
q4 1396 1828 1394 1394
q5 4548 4401 4363 4363
q6 219 176 127 127
q7 1908 1932 1820 1820
q8 2700 2326 2406 2326
q9 7208 7041 7053 7041
q10 2509 2883 2229 2229
q11 565 467 446 446
q12 680 787 629 629
q13 3689 4063 3126 3126
q14 266 309 267 267
q15 530 493 482 482
q16 606 638 625 625
q17 1089 1260 1331 1260
q18 7540 7345 7131 7131
q19 838 808 795 795
q20 1857 1961 1833 1833
q21 4502 4216 4161 4161
q22 1080 1025 970 970
Total cold run time: 50650 ms
Total hot run time: 48071 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3721972868
<details>
<summary>TPC-H: <b>Total hot run time: 32241 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 7011528d7d59c6d0c558d02c028ef02e91962d6b, data reload: false
------ Round 1 ----------------------------------
q1 17642 4280 4087 4087
q2 2023 393 246 246
q3 10132 1347 743 743
q4 10276 910 324 324
q5 8436 2116 1913 1913
q6 238 178 137 137
q7 952 830 657 657
q8 9300 1408 1193 1193
q9 5020 4520 4678 4520
q10 6867 1804 1442 1442
q11 519 305 287 287
q12 711 746 579 579
q13 17787 3897 3080 3080
q14 294 304 282 282
q15 575 510 508 508
q16 689 686 632 632
q17 703 849 498 498
q18 6778 6599 7052 6599
q19 1666 1062 626 626
q20 419 377 258 258
q21 3257 2608 2570 2570
q22 1173 1106 1060 1060
Total cold run time: 105457 ms
Total hot run time: 32241 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4436 4251 4233 4233
q2 333 422 307 307
q3 2315 2754 2531 2531
q4 1426 1908 1405 1405
q5 4593 4446 4465 4446
q6 210 168 129 129
q7 2004 1847 1985 1847
q8 2520 2371 2375 2371
q9 7161 7085 7382 7085
q10 2535 2762 2270 2270
q11 544 471 452 452
q12 683 767 598 598
q13 3609 3810 3073 3073
q14 265 277 251 251
q15 527 497 482 482
q16 613 670 619 619
q17 1111 1257 1315 1257
q18 7521 7336 7366 7336
q19 830 797 847 797
q20 1881 1988 1826 1826
q21 4452 4195 4181 4181
q22 1060 1045 987 987
Total cold run time: 50629 ms
Total hot run time: 48483 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "Gabriel39 (via GitHub)" <gi...@apache.org>.
Gabriel39 commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3718143392
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3718349338
<details>
<summary>TPC-H: <b>Total hot run time: 31556 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 e4c2db599d158a3cd2402180a17d58ca17f5a201, data reload: false
------ Round 1 ----------------------------------
q1 17610 4210 4066 4066
q2 2053 364 251 251
q3 10128 1249 687 687
q4 10199 830 320 320
q5 7514 2097 1841 1841
q6 204 177 142 142
q7 913 789 649 649
q8 9272 1318 1175 1175
q9 4997 4477 4554 4477
q10 6795 1780 1387 1387
q11 499 280 279 279
q12 668 748 611 611
q13 17796 3837 3078 3078
q14 290 291 273 273
q15 592 520 510 510
q16 686 662 639 639
q17 688 747 618 618
q18 6836 6366 6366 6366
q19 1120 962 603 603
q20 402 365 255 255
q21 2983 2439 2355 2355
q22 1015 1003 974 974
Total cold run time: 103260 ms
Total hot run time: 31556 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4100 4045 4068 4045
q2 332 402 303 303
q3 2066 2636 2223 2223
q4 1362 1716 1320 1320
q5 4117 3983 4093 3983
q6 214 172 129 129
q7 1839 1795 1655 1655
q8 2787 2475 2377 2377
q9 7305 7216 7140 7140
q10 2507 2710 2302 2302
q11 555 497 455 455
q12 749 793 605 605
q13 3686 4051 3308 3308
q14 314 315 285 285
q15 534 503 595 503
q16 719 679 682 679
q17 1304 1313 1316 1313
q18 8109 7859 7751 7751
q19 910 856 898 856
q20 2077 2068 1934 1934
q21 4782 4536 4225 4225
q22 1116 1017 978 978
Total cold run time: 51484 ms
Total hot run time: 48369 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "Gabriel39 (via GitHub)" <gi...@apache.org>.
Gabriel39 commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3722795585
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "Gabriel39 (via GitHub)" <gi...@apache.org>.
Gabriel39 commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3721674375
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3717999133
<details>
<summary>TPC-H: <b>Total hot run time: 31968 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 b457764ba9eb27c1d99f152503f675cec5030267, data reload: false
------ Round 1 ----------------------------------
q1 17606 4188 4053 4053
q2 2057 360 251 251
q3 10137 1274 721 721
q4 10206 840 317 317
q5 7495 2112 1853 1853
q6 194 176 136 136
q7 950 774 664 664
q8 9277 1371 1118 1118
q9 4886 4594 4589 4589
q10 6819 1830 1372 1372
q11 531 306 290 290
q12 725 746 586 586
q13 17759 3853 3058 3058
q14 287 289 270 270
q15 580 519 498 498
q16 671 683 641 641
q17 670 798 541 541
q18 6561 6463 6760 6463
q19 1159 1034 657 657
q20 423 390 267 267
q21 3170 2647 2590 2590
q22 1120 1115 1033 1033
Total cold run time: 103283 ms
Total hot run time: 31968 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4292 4237 4217 4217
q2 365 431 329 329
q3 2300 2842 2408 2408
q4 1509 1850 1420 1420
q5 4609 4338 4282 4282
q6 215 166 124 124
q7 2052 1941 1761 1761
q8 2537 2432 2383 2383
q9 7184 7238 6931 6931
q10 2585 2724 2220 2220
q11 552 499 448 448
q12 702 787 704 704
q13 3463 3777 3019 3019
q14 266 274 268 268
q15 519 490 482 482
q16 613 631 593 593
q17 1110 1279 1370 1279
q18 7623 7126 7290 7126
q19 827 782 837 782
q20 1941 1998 1826 1826
q21 4548 4311 4044 4044
q22 1044 1033 969 969
Total cold run time: 50856 ms
Total hot run time: 47615 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3717722916
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3718036133
<details>
<summary>TPC-DS: <b>Total hot run time: 173175 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 b457764ba9eb27c1d99f152503f675cec5030267, data reload: false
query5 4440 590 446 446
query6 330 229 236 229
query7 4216 482 258 258
query8 333 251 239 239
query9 8783 2672 2687 2672
query10 520 363 339 339
query11 15181 15266 14849 14849
query12 181 116 119 116
query13 1267 515 376 376
query14 6209 3019 2757 2757
query14_1 2716 2662 2666 2662
query15 197 195 177 177
query16 995 482 460 460
query17 1115 686 589 589
query18 2523 442 356 356
query19 240 226 205 205
query20 128 120 116 116
query21 217 137 123 123
query22 4099 4130 3827 3827
query23 16205 15512 15336 15336
query23_1 15348 15497 15319 15319
query24 7591 1565 1176 1176
query24_1 1185 1209 1184 1184
query25 569 472 428 428
query26 1254 266 166 166
query27 2761 445 296 296
query28 4550 2151 2146 2146
query29 858 571 475 475
query30 299 246 207 207
query31 817 637 564 564
query32 77 69 71 69
query33 575 350 295 295
query34 898 872 556 556
query35 732 797 714 714
query36 893 883 812 812
query37 178 99 84 84
query38 2731 2700 2678 2678
query39 762 750 734 734
query39_1 700 715 696 696
query40 218 137 122 122
query41 67 65 61 61
query42 107 104 104 104
query43 493 476 402 402
query44 1328 717 722 717
query45 186 185 173 173
query46 833 960 575 575
query47 1391 1399 1375 1375
query48 318 325 237 237
query49 609 422 331 331
query50 620 273 205 205
query51 3771 3744 3776 3744
query52 109 105 97 97
query53 288 327 275 275
query54 281 274 246 246
query55 79 79 73 73
query56 299 288 301 288
query57 1062 995 989 989
query58 275 252 252 252
query59 2184 2261 2110 2110
query60 316 317 304 304
query61 161 197 158 158
query62 409 374 313 313
query63 298 270 276 270
query64 5029 1307 978 978
query65 3816 3706 3712 3706
query66 1419 430 300 300
query67 15351 14970 15419 14970
query68 6963 981 706 706
query69 500 353 309 309
query70 1051 983 965 965
query71 366 302 279 279
query72 6080 3469 3416 3416
query73 773 726 294 294
query74 8753 8838 8581 8581
query75 2830 2762 2502 2502
query76 4087 1066 650 650
query77 531 379 323 323
query78 9635 9850 9160 9160
query79 1253 903 596 596
query80 654 564 481 481
query81 520 264 225 225
query82 214 144 108 108
query83 262 257 251 251
query84 264 122 101 101
query85 905 507 457 457
query86 366 321 286 286
query87 2945 2870 2748 2748
query88 3131 2228 2182 2182
query89 386 363 335 335
query90 2052 158 148 148
query91 180 159 141 141
query92 77 65 61 61
query93 1069 884 542 542
query94 547 314 295 295
query95 599 377 307 307
query96 575 462 202 202
query97 2319 2356 2273 2273
query98 230 197 198 197
query99 583 590 557 557
Total cold run time: 253674 ms
Total hot run time: 173175 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [refactor](predicates) Simplify predicates and profile [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59625:
URL: https://github.com/apache/doris/pull/59625#issuecomment-3718053248
<details>
<summary>ClickBench: <b>Total hot run time: 26.93 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 b457764ba9eb27c1d99f152503f675cec5030267, data reload: false
query1 0.06 0.05 0.05
query2 0.10 0.04 0.04
query3 0.26 0.09 0.09
query4 1.62 0.11 0.11
query5 0.27 0.26 0.26
query6 1.16 0.68 0.65
query7 0.03 0.02 0.02
query8 0.06 0.04 0.05
query9 0.56 0.50 0.50
query10 0.56 0.55 0.56
query11 0.15 0.10 0.10
query12 0.15 0.11 0.11
query13 0.60 0.59 0.59
query14 0.95 0.94 0.96
query15 0.79 0.77 0.80
query16 0.40 0.43 0.40
query17 1.05 1.06 1.01
query18 0.23 0.22 0.21
query19 1.86 1.88 1.85
query20 0.02 0.01 0.02
query21 15.45 0.26 0.13
query22 5.29 0.05 0.04
query23 15.89 0.29 0.10
query24 1.03 0.57 0.32
query25 0.09 0.05 0.08
query26 0.14 0.13 0.13
query27 0.10 0.06 0.05
query28 3.85 1.06 0.89
query29 12.56 3.92 3.19
query30 0.28 0.14 0.11
query31 2.82 0.64 0.41
query32 3.23 0.57 0.46
query33 3.07 3.06 3.09
query34 16.64 5.13 4.43
query35 4.43 4.43 4.48
query36 0.66 0.50 0.49
query37 0.10 0.07 0.06
query38 0.07 0.04 0.04
query39 0.04 0.02 0.02
query40 0.17 0.14 0.14
query41 0.09 0.04 0.03
query42 0.04 0.03 0.02
query43 0.05 0.04 0.03
Total cold run time: 96.97 s
Total hot run time: 26.93 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