You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zddr (via GitHub)" <gi...@apache.org> on 2024/07/19 06:59:56 UTC
[PR] [enhance](mtmv)Disable mtmv list rollup [doris]
zddr opened a new pull request, #38124:
URL: https://github.com/apache/doris/pull/38124
Prohibit creating materialized views on partitions where the base table is a list partition
--
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2244129828
run cloud_p1
--
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2238737865
<details>
<summary>TPC-H: <b>Total hot run time: 39637 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 0ddf9c7fcea657a9ec7ae6bd842e4cd312f1afa4, data reload: false
------ Round 1 ----------------------------------
q1 17633 4333 4241 4241
q2 2019 187 187 187
q3 10474 1146 1052 1052
q4 10196 754 765 754
q5 7519 2690 2664 2664
q6 216 140 139 139
q7 949 606 594 594
q8 9225 2056 2077 2056
q9 8839 6535 6547 6535
q10 8854 3717 3754 3717
q11 472 256 243 243
q12 476 223 225 223
q13 17761 3007 2975 2975
q14 270 229 225 225
q15 518 477 487 477
q16 512 380 373 373
q17 958 634 752 634
q18 8119 7459 7449 7449
q19 5906 1493 1343 1343
q20 689 319 330 319
q21 4974 3204 3149 3149
q22 356 288 295 288
Total cold run time: 116935 ms
Total hot run time: 39637 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4406 4271 4272 4271
q2 365 256 265 256
q3 2969 2853 2933 2853
q4 1971 1707 1659 1659
q5 5653 5515 5518 5515
q6 221 131 135 131
q7 2184 1849 1862 1849
q8 3256 3417 3449 3417
q9 8828 8862 8901 8862
q10 4108 3928 3763 3763
q11 629 508 510 508
q12 840 638 643 638
q13 17052 3152 3177 3152
q14 322 286 294 286
q15 544 480 494 480
q16 492 454 454 454
q17 1820 1560 1505 1505
q18 8048 8033 7854 7854
q19 1741 1586 1585 1585
q20 2151 1893 1873 1873
q21 9938 4929 4841 4841
q22 615 513 485 485
Total cold run time: 78153 ms
Total hot run time: 56237 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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2242471703
<details>
<summary>ClickBench: <b>Total hot run time: 31.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 23d69c72f65d4cbd1b04136b756127b76c631686, data reload: false
query1 0.04 0.04 0.03
query2 0.07 0.04 0.05
query3 0.22 0.04 0.05
query4 1.69 0.06 0.08
query5 0.50 0.50 0.49
query6 1.14 0.72 0.73
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.55 0.49 0.48
query10 0.55 0.54 0.55
query11 0.16 0.11 0.12
query12 0.14 0.12 0.11
query13 0.60 0.60 0.58
query14 0.76 0.78 0.77
query15 0.85 0.82 0.83
query16 0.36 0.37 0.37
query17 0.96 1.00 1.01
query18 0.22 0.22 0.22
query19 1.85 1.82 1.70
query20 0.02 0.01 0.01
query21 15.41 0.77 0.64
query22 4.10 6.77 2.57
query23 18.32 1.39 1.28
query24 2.09 0.22 0.22
query25 0.16 0.09 0.08
query26 0.30 0.22 0.22
query27 0.45 0.22 0.23
query28 13.36 1.01 1.01
query29 12.59 3.38 3.37
query30 0.25 0.06 0.05
query31 2.86 0.38 0.39
query32 3.28 0.46 0.47
query33 2.84 2.90 2.94
query34 16.96 4.32 4.33
query35 4.46 4.48 4.41
query36 0.66 0.48 0.49
query37 0.19 0.16 0.17
query38 0.15 0.15 0.14
query39 0.05 0.03 0.04
query40 0.15 0.12 0.12
query41 0.09 0.04 0.04
query42 0.06 0.04 0.04
query43 0.05 0.04 0.04
Total cold run time: 109.58 s
Total hot run time: 31.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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2238683200
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2277449440
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2239283305
<details>
<summary>ClickBench: <b>Total hot run time: 30.33 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 3de1567925c556e169eff21fdea7d3e597022661, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.04 0.04
query3 0.22 0.04 0.05
query4 1.68 0.08 0.08
query5 0.50 0.48 0.51
query6 1.13 0.72 0.73
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.55 0.48 0.49
query10 0.54 0.53 0.55
query11 0.16 0.12 0.11
query12 0.15 0.12 0.12
query13 0.59 0.60 0.58
query14 0.77 0.77 0.77
query15 0.85 0.81 0.80
query16 0.35 0.37 0.36
query17 0.96 1.01 1.03
query18 0.22 0.22 0.21
query19 1.81 1.69 1.74
query20 0.01 0.00 0.00
query21 15.39 0.77 0.66
query22 5.03 7.11 1.77
query23 18.34 1.36 1.35
query24 2.14 0.21 0.22
query25 0.16 0.08 0.08
query26 0.31 0.21 0.21
query27 0.44 0.22 0.22
query28 13.29 1.00 1.01
query29 12.66 3.25 3.28
query30 0.25 0.06 0.06
query31 2.87 0.41 0.38
query32 3.27 0.47 0.46
query33 2.89 2.88 2.84
query34 17.05 4.29 4.32
query35 4.44 4.38 4.51
query36 0.65 0.48 0.49
query37 0.18 0.16 0.16
query38 0.15 0.14 0.14
query39 0.04 0.04 0.03
query40 0.15 0.13 0.12
query41 0.10 0.05 0.05
query42 0.06 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 110.59 s
Total hot run time: 30.33 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #38124:
URL: https://github.com/apache/doris/pull/38124
--
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2241936776
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2242388598
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2259626786
run cloud_p1
--
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2239272052
<details>
<summary>TPC-DS: <b>Total hot run time: 173371 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 3de1567925c556e169eff21fdea7d3e597022661, data reload: false
query1 906 373 357 357
query2 6419 1910 1758 1758
query3 6650 208 219 208
query4 28337 17672 17412 17412
query5 3581 464 463 463
query6 262 185 171 171
query7 4586 279 286 279
query8 249 193 191 191
query9 8518 2442 2422 2422
query10 418 285 269 269
query11 12061 10266 10379 10266
query12 115 84 82 82
query13 1650 364 369 364
query14 10223 6880 7682 6880
query15 227 161 163 161
query16 7743 455 455 455
query17 1528 563 523 523
query18 1961 272 268 268
query19 196 147 149 147
query20 85 81 77 77
query21 198 126 121 121
query22 4494 4357 4181 4181
query23 34125 33668 33449 33449
query24 11170 2894 2958 2894
query25 618 389 372 372
query26 1101 151 151 151
query27 2597 270 274 270
query28 7080 2076 2068 2068
query29 921 630 635 630
query30 251 155 146 146
query31 970 770 752 752
query32 99 51 56 51
query33 761 344 329 329
query34 931 478 486 478
query35 872 791 755 755
query36 1152 977 982 977
query37 140 86 79 79
query38 2940 2868 2815 2815
query39 919 865 831 831
query40 202 117 115 115
query41 46 42 42 42
query42 112 96 98 96
query43 525 463 459 459
query44 1174 739 727 727
query45 193 157 161 157
query46 1083 727 750 727
query47 1880 1778 1779 1778
query48 367 289 296 289
query49 848 396 407 396
query50 777 383 387 383
query51 6936 6870 6814 6814
query52 100 89 90 89
query53 359 287 288 287
query54 932 442 436 436
query55 74 74 73 73
query56 287 258 265 258
query57 1138 1082 1055 1055
query58 249 237 246 237
query59 2865 2582 2525 2525
query60 294 296 273 273
query61 93 92 91 91
query62 790 628 619 619
query63 313 283 291 283
query64 9525 2202 1672 1672
query65 3137 3063 3121 3063
query66 747 321 329 321
query67 15557 15138 14951 14951
query68 4474 551 539 539
query69 595 431 346 346
query70 1185 1138 1130 1130
query71 426 277 273 273
query72 7291 5681 6018 5681
query73 755 323 320 320
query74 6356 5721 5656 5656
query75 3436 2707 2681 2681
query76 2765 904 901 901
query77 622 323 296 296
query78 9636 9141 9083 9083
query79 2440 519 509 509
query80 1336 464 516 464
query81 578 216 219 216
query82 820 136 124 124
query83 199 160 161 160
query84 275 85 83 83
query85 1379 306 309 306
query86 446 306 314 306
query87 3311 3116 3108 3108
query88 3817 2367 2360 2360
query89 469 367 381 367
query90 1803 186 191 186
query91 129 96 100 96
query92 61 47 51 47
query93 2096 511 507 507
query94 1078 271 282 271
query95 396 305 306 305
query96 589 284 267 267
query97 3228 3066 3035 3035
query98 215 200 191 191
query99 1703 1239 1249 1239
Total cold run time: 281566 ms
Total hot run time: 173371 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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2239170938
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2241972249
<details>
<summary>ClickBench: <b>Total hot run time: 30.33 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit b770f0c1a40b1e917fffc936bd3c130996e0ab72, data reload: false
query1 0.04 0.04 0.03
query2 0.07 0.04 0.04
query3 0.23 0.05 0.05
query4 1.67 0.08 0.08
query5 0.50 0.48 0.49
query6 1.13 0.72 0.73
query7 0.02 0.01 0.01
query8 0.06 0.04 0.04
query9 0.54 0.50 0.50
query10 0.55 0.55 0.55
query11 0.15 0.11 0.12
query12 0.15 0.13 0.12
query13 0.62 0.59 0.59
query14 0.77 0.79 0.78
query15 0.86 0.83 0.81
query16 0.36 0.36 0.36
query17 1.02 0.97 0.99
query18 0.25 0.23 0.24
query19 1.77 1.67 1.71
query20 0.02 0.01 0.01
query21 15.39 0.76 0.64
query22 4.28 7.48 1.53
query23 18.27 1.46 1.31
query24 2.13 0.22 0.23
query25 0.17 0.09 0.09
query26 0.31 0.21 0.22
query27 0.45 0.24 0.23
query28 13.23 1.04 1.00
query29 12.61 3.35 3.28
query30 0.26 0.07 0.06
query31 2.85 0.39 0.39
query32 3.29 0.49 0.47
query33 2.91 2.94 2.96
query34 17.00 4.33 4.32
query35 4.43 4.41 4.44
query36 0.65 0.48 0.48
query37 0.19 0.16 0.15
query38 0.16 0.16 0.15
query39 0.05 0.04 0.04
query40 0.15 0.12 0.13
query41 0.09 0.05 0.05
query42 0.06 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 109.76 s
Total hot run time: 30.33 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2239009691
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2238505522
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)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2238506307
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2238682953
run performance
--
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2241959371
<details>
<summary>TPC-H: <b>Total hot run time: 40076 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 b770f0c1a40b1e917fffc936bd3c130996e0ab72, data reload: false
------ Round 1 ----------------------------------
q1 18133 4470 4393 4393
q2 2510 199 193 193
q3 11841 1169 1115 1115
q4 10544 870 765 765
q5 7911 2726 2714 2714
q6 232 145 141 141
q7 974 623 618 618
q8 9239 2051 2079 2051
q9 8872 6581 6515 6515
q10 8692 3780 3734 3734
q11 466 239 239 239
q12 405 226 221 221
q13 17828 2975 2965 2965
q14 276 245 245 245
q15 533 497 506 497
q16 499 378 373 373
q17 970 570 632 570
q18 7962 7480 7494 7480
q19 7255 1424 1476 1424
q20 694 332 344 332
q21 5015 3254 3207 3207
q22 352 284 287 284
Total cold run time: 121203 ms
Total hot run time: 40076 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4389 4282 4317 4282
q2 376 280 267 267
q3 2991 2800 2722 2722
q4 1892 1612 1623 1612
q5 5310 5321 5361 5321
q6 226 131 158 131
q7 2152 1782 1737 1737
q8 3186 3360 3294 3294
q9 8432 8368 8409 8368
q10 3892 3701 3739 3701
q11 583 498 501 498
q12 752 631 598 598
q13 17335 3013 3026 3013
q14 303 273 277 273
q15 549 487 498 487
q16 502 428 434 428
q17 1802 1486 1485 1485
q18 7577 7594 7289 7289
q19 1699 1494 1569 1494
q20 1999 1786 1789 1786
q21 4864 4677 4667 4667
q22 573 488 478 478
Total cold run time: 71384 ms
Total hot run time: 53931 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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2277449502
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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2238756557
<details>
<summary>TPC-DS: <b>Total hot run time: 171954 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 0ddf9c7fcea657a9ec7ae6bd842e4cd312f1afa4, data reload: false
query1 913 375 364 364
query2 6448 1792 1724 1724
query3 6649 204 213 204
query4 28563 17675 17555 17555
query5 3656 468 469 468
query6 262 188 159 159
query7 4584 304 292 292
query8 242 187 188 187
query9 8441 2383 2362 2362
query10 434 287 291 287
query11 12536 10249 10078 10078
query12 114 87 90 87
query13 1642 372 368 368
query14 10217 6109 7737 6109
query15 213 164 167 164
query16 7422 469 494 469
query17 1328 550 549 549
query18 1827 291 283 283
query19 197 199 145 145
query20 85 82 79 79
query21 212 125 134 125
query22 4258 4013 3984 3984
query23 33681 33479 33472 33472
query24 10785 2845 2844 2844
query25 614 398 369 369
query26 711 151 147 147
query27 2246 281 278 278
query28 6104 2058 2045 2045
query29 868 629 624 624
query30 250 153 151 151
query31 1010 778 789 778
query32 98 55 55 55
query33 669 335 317 317
query34 875 483 504 483
query35 848 748 743 743
query36 1135 976 975 975
query37 151 89 86 86
query38 2958 2875 2869 2869
query39 888 868 860 860
query40 237 122 119 119
query41 46 46 47 46
query42 106 98 108 98
query43 471 461 446 446
query44 1047 733 713 713
query45 196 159 159 159
query46 1077 723 723 723
query47 1850 1771 1782 1771
query48 361 285 296 285
query49 845 402 403 402
query50 774 387 379 379
query51 6941 6803 6792 6792
query52 107 90 89 89
query53 360 286 281 281
query54 837 442 436 436
query55 73 70 72 70
query56 279 267 261 261
query57 1129 1021 1045 1021
query58 254 239 258 239
query59 2836 2583 2524 2524
query60 290 270 313 270
query61 102 92 94 92
query62 812 650 635 635
query63 316 286 283 283
query64 9136 2183 1626 1626
query65 3151 3114 3127 3114
query66 744 322 374 322
query67 15397 14838 14946 14838
query68 4725 541 539 539
query69 650 432 365 365
query70 1218 1169 1174 1169
query71 440 279 274 274
query72 7135 5472 5560 5472
query73 757 326 320 320
query74 6213 5658 5696 5658
query75 3596 2670 2744 2670
query76 2819 883 943 883
query77 608 303 297 297
query78 9631 9016 8924 8924
query79 2848 520 513 513
query80 2110 488 473 473
query81 600 219 222 219
query82 1509 136 129 129
query83 312 168 165 165
query84 271 92 86 86
query85 1356 309 364 309
query86 463 322 320 320
query87 3311 3127 3104 3104
query88 4288 2342 2361 2342
query89 470 375 381 375
query90 1726 191 193 191
query91 126 100 97 97
query92 59 49 52 49
query93 2676 500 507 500
query94 1084 295 307 295
query95 392 316 310 310
query96 618 280 265 265
query97 3241 3038 3072 3038
query98 225 204 197 197
query99 1536 1257 1234 1234
Total cold run time: 280921 ms
Total hot run time: 171954 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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2238771318
<details>
<summary>ClickBench: <b>Total hot run time: 30.71 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 0ddf9c7fcea657a9ec7ae6bd842e4cd312f1afa4, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.03
query3 0.22 0.06 0.06
query4 1.65 0.08 0.08
query5 0.50 0.51 0.48
query6 1.14 0.73 0.73
query7 0.02 0.01 0.02
query8 0.06 0.04 0.04
query9 0.57 0.49 0.49
query10 0.54 0.55 0.54
query11 0.16 0.12 0.11
query12 0.15 0.12 0.13
query13 0.60 0.59 0.58
query14 0.75 0.76 0.78
query15 0.85 0.81 0.82
query16 0.38 0.38 0.38
query17 1.05 1.02 1.05
query18 0.23 0.23 0.23
query19 1.90 1.80 1.75
query20 0.02 0.01 0.01
query21 15.39 0.72 0.65
query22 3.73 7.25 2.01
query23 18.30 1.38 1.24
query24 2.16 0.23 0.22
query25 0.16 0.09 0.08
query26 0.32 0.22 0.21
query27 0.45 0.23 0.23
query28 13.23 1.02 1.00
query29 12.59 3.26 3.26
query30 0.26 0.06 0.05
query31 2.88 0.40 0.38
query32 3.26 0.48 0.48
query33 2.93 2.86 2.93
query34 17.16 4.37 4.34
query35 4.41 4.37 4.42
query36 0.66 0.49 0.49
query37 0.19 0.16 0.16
query38 0.16 0.15 0.15
query39 0.05 0.03 0.04
query40 0.16 0.13 0.12
query41 0.09 0.05 0.04
query42 0.06 0.05 0.06
query43 0.05 0.04 0.03
Total cold run time: 109.56 s
Total hot run time: 30.71 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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2239248339
<details>
<summary>TPC-H: <b>Total hot run time: 39619 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 3de1567925c556e169eff21fdea7d3e597022661, data reload: false
------ Round 1 ----------------------------------
q1 17632 4345 4273 4273
q2 2017 188 188 188
q3 10467 1216 1072 1072
q4 10192 781 872 781
q5 7545 2672 2601 2601
q6 224 137 132 132
q7 957 592 591 591
q8 9213 2052 2081 2052
q9 9025 6519 6558 6519
q10 8710 3759 3793 3759
q11 439 234 223 223
q12 460 217 217 217
q13 18614 2971 2975 2971
q14 289 241 245 241
q15 521 500 491 491
q16 509 380 374 374
q17 965 622 681 622
q18 7943 7608 7399 7399
q19 6089 1397 1362 1362
q20 642 322 323 322
q21 4866 3150 3215 3150
q22 341 288 279 279
Total cold run time: 117660 ms
Total hot run time: 39619 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4406 4193 4212 4193
q2 362 265 264 264
q3 3005 2831 2900 2831
q4 2036 1679 1719 1679
q5 5610 5509 5452 5452
q6 224 127 126 126
q7 2183 1851 1817 1817
q8 3212 3363 3411 3363
q9 8714 8740 8842 8740
q10 4057 3850 3781 3781
q11 581 508 497 497
q12 821 603 649 603
q13 15828 3143 3152 3143
q14 348 306 280 280
q15 525 474 495 474
q16 487 453 474 453
q17 1808 1519 1505 1505
q18 8081 7823 7791 7791
q19 1746 1530 1586 1530
q20 2156 1879 1865 1865
q21 5173 4842 4748 4748
q22 586 503 516 503
Total cold run time: 71949 ms
Total hot run time: 55638 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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2242435400
<details>
<summary>TPC-H: <b>Total hot run time: 40100 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 23d69c72f65d4cbd1b04136b756127b76c631686, data reload: false
------ Round 1 ----------------------------------
q1 17958 4437 4369 4369
q2 2404 194 197 194
q3 10571 1220 1090 1090
q4 10191 855 864 855
q5 7561 2684 2667 2667
q6 221 138 138 138
q7 946 609 614 609
q8 9223 2072 2050 2050
q9 8848 6543 6550 6543
q10 8712 3767 3795 3767
q11 446 237 241 237
q12 394 232 228 228
q13 17777 2933 2954 2933
q14 279 233 244 233
q15 539 471 487 471
q16 487 394 390 390
q17 961 669 705 669
q18 8015 7619 7461 7461
q19 6819 1388 1401 1388
q20 698 330 321 321
q21 5082 3219 3201 3201
q22 362 288 286 286
Total cold run time: 118494 ms
Total hot run time: 40100 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4377 4269 4254 4254
q2 385 273 273 273
q3 3050 2687 2745 2687
q4 1928 1631 1583 1583
q5 5332 5336 5295 5295
q6 222 134 133 133
q7 2083 1779 1665 1665
q8 3189 3370 3305 3305
q9 8440 8410 8405 8405
q10 3925 3762 3696 3696
q11 568 509 509 509
q12 743 608 594 594
q13 17388 2984 2987 2984
q14 311 282 262 262
q15 520 481 472 472
q16 468 432 419 419
q17 1792 1498 1459 1459
q18 7532 7539 7267 7267
q19 1656 1532 1528 1528
q20 1978 1769 1811 1769
q21 4849 4701 4853 4701
q22 561 519 498 498
Total cold run time: 71297 ms
Total hot run time: 53758 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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2242460108
<details>
<summary>TPC-DS: <b>Total hot run time: 173854 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 23d69c72f65d4cbd1b04136b756127b76c631686, data reload: false
query1 908 377 368 368
query2 6437 1988 1859 1859
query3 6672 205 213 205
query4 25976 17589 17517 17517
query5 4285 475 470 470
query6 273 171 162 162
query7 4572 292 287 287
query8 243 200 202 200
query9 8450 2474 2443 2443
query10 455 314 283 283
query11 10682 9923 10180 9923
query12 129 88 86 86
query13 1655 372 380 372
query14 10324 7683 7026 7026
query15 216 168 174 168
query16 7829 499 490 490
query17 1331 565 552 552
query18 1964 291 285 285
query19 193 159 161 159
query20 94 85 82 82
query21 220 136 127 127
query22 4369 4001 4022 4001
query23 34243 33148 33299 33148
query24 12270 2899 2926 2899
query25 703 386 418 386
query26 1865 155 151 151
query27 2980 278 277 277
query28 7491 2003 1981 1981
query29 1200 641 628 628
query30 297 154 149 149
query31 960 783 772 772
query32 98 56 57 56
query33 789 363 337 337
query34 909 488 498 488
query35 863 752 749 749
query36 1110 926 940 926
query37 295 84 83 83
query38 2820 2774 2738 2738
query39 901 826 820 820
query40 285 131 126 126
query41 49 46 46 46
query42 125 101 110 101
query43 521 472 465 465
query44 1228 739 726 726
query45 195 163 164 163
query46 1087 737 738 737
query47 1840 1780 1772 1772
query48 366 294 294 294
query49 1196 433 428 428
query50 790 415 410 410
query51 6678 6751 6689 6689
query52 110 91 100 91
query53 366 296 304 296
query54 865 470 464 464
query55 77 77 76 76
query56 315 293 302 293
query57 1178 1091 1036 1036
query58 270 266 398 266
query59 2806 2720 2630 2630
query60 304 282 286 282
query61 98 95 96 95
query62 800 628 663 628
query63 328 295 302 295
query64 10438 2297 1677 1677
query65 3173 3121 3147 3121
query66 1250 334 328 328
query67 15794 15074 14926 14926
query68 9052 557 560 557
query69 748 466 365 365
query70 1246 1137 1095 1095
query71 549 283 284 283
query72 9023 5858 5555 5555
query73 1777 326 336 326
query74 6104 5616 5655 5616
query75 5040 2731 2716 2716
query76 5081 954 963 954
query77 791 320 314 314
query78 11580 9572 10211 9572
query79 11861 534 534 534
query80 1143 508 490 490
query81 584 227 231 227
query82 447 138 131 131
query83 343 169 167 167
query84 274 90 90 90
query85 802 329 300 300
query86 394 333 328 328
query87 3341 3085 3055 3055
query88 5031 2461 2453 2453
query89 493 387 390 387
query90 2196 201 204 201
query91 132 102 101 101
query92 63 49 53 49
query93 4521 499 491 491
query94 1413 298 298 298
query95 415 325 323 323
query96 620 277 275 275
query97 3190 3019 3100 3019
query98 216 202 203 202
query99 1482 1266 1281 1266
Total cold run time: 309555 ms
Total hot run time: 173854 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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2241968102
<details>
<summary>TPC-DS: <b>Total hot run time: 173885 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 b770f0c1a40b1e917fffc936bd3c130996e0ab72, data reload: false
query1 926 376 366 366
query2 6450 1926 1830 1830
query3 6668 210 218 210
query4 27549 17580 17414 17414
query5 4177 475 476 475
query6 293 181 161 161
query7 4596 294 287 287
query8 246 203 198 198
query9 8560 2474 2449 2449
query10 446 286 281 281
query11 11026 10194 10151 10151
query12 133 90 82 82
query13 1648 383 377 377
query14 10477 7748 7523 7523
query15 230 170 169 169
query16 7770 508 468 468
query17 1608 556 550 550
query18 1713 287 282 282
query19 196 149 155 149
query20 93 83 86 83
query21 209 125 126 125
query22 4261 4000 3991 3991
query23 33734 33120 33335 33120
query24 12015 2873 2886 2873
query25 673 385 388 385
query26 1782 161 153 153
query27 2857 278 275 275
query28 7407 2053 2031 2031
query29 1079 649 639 639
query30 291 151 151 151
query31 971 753 770 753
query32 101 54 58 54
query33 802 337 342 337
query34 894 479 491 479
query35 854 775 733 733
query36 1102 899 941 899
query37 276 83 84 83
query38 2909 2771 2747 2747
query39 867 825 829 825
query40 279 130 123 123
query41 48 49 46 46
query42 122 104 101 101
query43 520 469 458 458
query44 1232 732 740 732
query45 190 165 167 165
query46 1086 706 749 706
query47 1861 1753 1777 1753
query48 374 304 293 293
query49 1223 432 434 432
query50 781 401 395 395
query51 6825 6614 6588 6588
query52 111 90 96 90
query53 367 293 286 286
query54 984 460 452 452
query55 78 81 75 75
query56 301 393 278 278
query57 1144 1055 1073 1055
query58 275 255 247 247
query59 2892 2633 2585 2585
query60 325 270 293 270
query61 96 116 95 95
query62 841 639 653 639
query63 318 285 292 285
query64 10501 2188 7451 2188
query65 3152 3121 3136 3121
query66 1331 345 331 331
query67 15668 14777 14865 14777
query68 8799 568 570 568
query69 698 455 374 374
query70 1186 1081 1106 1081
query71 572 289 293 289
query72 8968 5248 5857 5248
query73 1266 335 323 323
query74 6401 5715 5736 5715
query75 5428 2664 2719 2664
query76 5157 896 910 896
query77 767 332 321 321
query78 9837 10082 9415 9415
query79 10407 545 529 529
query80 1439 483 478 478
query81 588 220 220 220
query82 413 131 132 131
query83 352 169 172 169
query84 277 89 87 87
query85 815 316 311 311
query86 405 320 289 289
query87 3326 3136 3093 3093
query88 4708 2428 2397 2397
query89 482 392 383 383
query90 2203 199 190 190
query91 132 101 102 101
query92 65 50 51 50
query93 3582 520 507 507
query94 1355 288 303 288
query95 416 308 320 308
query96 608 279 278 278
query97 3202 3032 3029 3029
query98 222 192 191 191
query99 1544 1238 1291 1238
Total cold run time: 306434 ms
Total hot run time: 173885 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] [enhance](mtmv)Disable mtmv list rollup [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #38124:
URL: https://github.com/apache/doris/pull/38124#issuecomment-2238530590
run performance
--
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