You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "seawinde (via GitHub)" <gi...@apache.org> on 2024/06/05 04:17:19 UTC
[PR] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
seawinde opened a new pull request, #35897:
URL: https://github.com/apache/doris/pull/35897
## Proposed changes
Set query rewrite by materialized view default enable
As before, if want to use query reweirte by async materialized view, must run` SET enable_materialized_view_rewrite=true;`
After this, not need
--
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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2154486852
<details>
<summary>ClickBench: <b>Total hot run time: 31.48 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 28fa036f4c96bbdc83c529fccc2adedb6f209422, data reload: false
query1 0.04 0.04 0.04
query2 0.09 0.04 0.04
query3 0.23 0.05 0.06
query4 1.66 0.08 0.08
query5 0.49 0.48 0.50
query6 1.13 0.73 0.72
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.53 0.48 0.50
query10 0.54 0.55 0.55
query11 0.15 0.11 0.12
query12 0.15 0.12 0.11
query13 0.59 0.59 0.61
query14 0.80 0.79 0.81
query15 0.83 0.82 0.82
query16 0.36 0.35 0.35
query17 0.96 1.02 0.95
query18 0.21 0.24 0.24
query19 1.82 1.78 1.76
query20 0.02 0.01 0.02
query21 15.64 0.69 0.64
query22 4.27 6.40 2.86
query23 18.32 1.51 1.26
query24 2.07 0.22 0.22
query25 0.16 0.09 0.08
query26 0.28 0.17 0.17
query27 0.08 0.08 0.08
query28 13.25 1.02 1.00
query29 13.16 3.30 3.27
query30 0.25 0.06 0.05
query31 2.86 0.39 0.40
query32 3.26 0.48 0.48
query33 2.87 2.93 2.90
query34 17.08 4.36 4.41
query35 4.52 4.47 4.47
query36 0.64 0.48 0.46
query37 0.18 0.16 0.15
query38 0.15 0.15 0.14
query39 0.04 0.03 0.03
query40 0.20 0.15 0.14
query41 0.09 0.06 0.04
query42 0.06 0.04 0.05
query43 0.05 0.03 0.03
Total cold run time: 110.15 s
Total hot run time: 31.48 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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2151383271
<details>
<summary>TPC-DS: <b>Total hot run time: 172770 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 3c1417046d721c38602f3253875e7da382c00331, data reload: false
query1 922 375 388 375
query2 6441 2473 2358 2358
query3 6650 224 213 213
query4 19979 17384 17419 17384
query5 4137 456 459 456
query6 247 160 154 154
query7 4589 306 314 306
query8 303 278 281 278
query9 8617 2431 2409 2409
query10 455 312 290 290
query11 10531 10014 9997 9997
query12 146 83 91 83
query13 1637 362 360 360
query14 9925 7535 6883 6883
query15 237 182 186 182
query16 7706 268 263 263
query17 1289 515 507 507
query18 1952 273 274 273
query19 194 147 153 147
query20 92 82 81 81
query21 204 130 128 128
query22 4466 4115 4097 4097
query23 33719 33058 33223 33058
query24 11164 2870 2715 2715
query25 624 353 396 353
query26 1492 156 156 156
query27 3026 322 324 322
query28 7547 2022 2023 2022
query29 995 607 601 601
query30 281 150 147 147
query31 952 742 728 728
query32 97 58 55 55
query33 762 292 279 279
query34 943 487 478 478
query35 748 658 623 623
query36 1075 952 947 947
query37 161 71 76 71
query38 2856 2764 2752 2752
query39 887 796 805 796
query40 224 131 129 129
query41 60 55 54 54
query42 117 100 99 99
query43 574 538 553 538
query44 1202 735 751 735
query45 196 163 171 163
query46 1067 706 709 706
query47 1832 1770 1761 1761
query48 391 334 297 297
query49 1055 411 404 404
query50 783 400 387 387
query51 6765 6698 6690 6690
query52 104 99 95 95
query53 356 288 289 288
query54 849 449 446 446
query55 75 75 74 74
query56 282 271 269 269
query57 1132 1069 1056 1056
query58 259 246 275 246
query59 3526 3249 3095 3095
query60 326 281 285 281
query61 111 89 87 87
query62 651 446 439 439
query63 313 293 286 286
query64 9350 2249 1820 1820
query65 3156 3111 3130 3111
query66 1001 333 346 333
query67 15379 14858 14768 14768
query68 4596 539 548 539
query69 502 322 334 322
query70 1130 1116 1036 1036
query71 401 286 281 281
query72 7105 5868 5510 5510
query73 758 324 317 317
query74 5936 5555 5503 5503
query75 3434 2686 2653 2653
query76 2754 978 859 859
query77 441 301 302 301
query78 10181 9805 9849 9805
query79 2332 515 506 506
query80 1066 489 471 471
query81 547 222 222 222
query82 1090 108 102 102
query83 210 181 184 181
query84 272 90 93 90
query85 1452 276 270 270
query86 463 338 307 307
query87 3247 3107 3123 3107
query88 3935 2344 2339 2339
query89 488 395 393 393
query90 1866 195 193 193
query91 124 100 96 96
query92 57 50 52 50
query93 2403 508 505 505
query94 1217 193 186 186
query95 418 317 313 313
query96 596 268 265 265
query97 3201 3058 3022 3022
query98 213 198 198 198
query99 1243 844 844 844
Total cold run time: 272862 ms
Total hot run time: 172770 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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2154477855
<details>
<summary>TPC-DS: <b>Total hot run time: 171293 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 28fa036f4c96bbdc83c529fccc2adedb6f209422, data reload: false
query1 926 371 371 371
query2 7680 2359 2258 2258
query3 6643 209 205 205
query4 19580 17341 17347 17341
query5 4194 464 464 464
query6 257 159 165 159
query7 4583 294 294 294
query8 330 292 299 292
query9 8628 2429 2389 2389
query10 441 296 274 274
query11 10542 9886 9977 9886
query12 144 95 84 84
query13 1640 365 351 351
query14 10154 6898 6153 6153
query15 226 192 184 184
query16 7486 279 271 271
query17 1380 536 532 532
query18 1894 285 283 283
query19 204 162 164 162
query20 97 88 84 84
query21 214 129 133 129
query22 4321 3968 3967 3967
query23 33849 33219 33119 33119
query24 12387 2759 2846 2759
query25 701 377 413 377
query26 1774 153 152 152
query27 3066 316 320 316
query28 7321 2040 2042 2040
query29 1200 624 596 596
query30 275 157 157 157
query31 975 744 718 718
query32 99 56 62 56
query33 790 279 285 279
query34 1031 479 477 477
query35 782 611 646 611
query36 1110 964 943 943
query37 298 75 72 72
query38 2898 2719 2749 2719
query39 856 802 798 798
query40 282 127 124 124
query41 63 57 54 54
query42 124 100 100 100
query43 587 576 546 546
query44 1238 721 740 721
query45 198 172 168 168
query46 1076 695 701 695
query47 1848 1773 1787 1773
query48 365 298 291 291
query49 1198 417 415 415
query50 790 399 402 399
query51 6793 6681 6663 6663
query52 100 96 89 89
query53 362 310 294 294
query54 910 457 443 443
query55 80 73 73 73
query56 279 259 254 254
query57 1124 1014 1043 1014
query58 254 265 237 237
query59 3477 3411 3190 3190
query60 294 282 292 282
query61 93 93 92 92
query62 669 443 438 438
query63 321 296 298 296
query64 10016 2290 1786 1786
query65 3198 3148 3154 3148
query66 1379 338 336 336
query67 15393 14905 14852 14852
query68 4548 553 544 544
query69 454 297 304 297
query70 1112 1132 1218 1132
query71 433 278 294 278
query72 7022 5109 6098 5109
query73 765 327 323 323
query74 5916 5453 5486 5453
query75 3388 2666 2667 2666
query76 2702 954 868 868
query77 442 293 292 292
query78 10273 9899 9777 9777
query79 2559 508 525 508
query80 2253 471 462 462
query81 564 219 220 219
query82 847 100 102 100
query83 319 173 174 173
query84 267 82 85 82
query85 2235 289 279 279
query86 494 308 299 299
query87 3235 3108 3038 3038
query88 4119 2327 2382 2327
query89 477 395 396 395
query90 1831 184 189 184
query91 128 100 101 100
query92 63 48 49 48
query93 2466 519 503 503
query94 1292 188 185 185
query95 420 312 308 308
query96 602 261 264 261
query97 3193 2963 3039 2963
query98 225 201 195 195
query99 1191 830 859 830
Total cold run time: 279322 ms
Total hot run time: 171293 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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2160013506
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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2148822468
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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2154459388
<details>
<summary>TPC-H: <b>Total hot run time: 40092 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 28fa036f4c96bbdc83c529fccc2adedb6f209422, data reload: false
------ Round 1 ----------------------------------
q1 18038 4805 4427 4427
q2 2694 189 191 189
q3 11719 1161 1234 1161
q4 10777 715 766 715
q5 7621 2684 2663 2663
q6 224 136 138 136
q7 964 642 603 603
q8 9241 2081 2098 2081
q9 9002 6482 6449 6449
q10 8798 3720 3732 3720
q11 455 248 240 240
q12 405 241 228 228
q13 18700 2963 2977 2963
q14 271 229 222 222
q15 524 488 472 472
q16 550 380 376 376
q17 971 758 706 706
q18 7920 7458 7397 7397
q19 4532 1499 1524 1499
q20 669 311 308 308
q21 5088 3204 3231 3204
q22 394 335 333 333
Total cold run time: 119557 ms
Total hot run time: 40092 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4431 4199 4215 4199
q2 367 267 279 267
q3 2968 2713 2712 2712
q4 1865 1567 1666 1567
q5 5273 5269 5249 5249
q6 215 125 131 125
q7 2053 1741 1710 1710
q8 3175 3351 3317 3317
q9 8341 8321 8334 8321
q10 3865 3671 3639 3639
q11 567 487 492 487
q12 758 620 597 597
q13 16697 2936 3004 2936
q14 294 254 270 254
q15 514 472 482 472
q16 465 410 415 410
q17 1785 1486 1490 1486
q18 7652 7611 7327 7327
q19 1649 1540 1484 1484
q20 1983 1771 1761 1761
q21 4867 4597 4798 4597
q22 624 548 536 536
Total cold run time: 70408 ms
Total hot run time: 53453 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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "JackyWoo (via GitHub)" <gi...@apache.org>.
JackyWoo commented on code in PR #35897:
URL: https://github.com/apache/doris/pull/35897#discussion_r3200597153
##########
fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java:
##########
@@ -1738,7 +1738,7 @@ public void setEnableLeftZigZag(boolean enableLeftZigZag) {
description = {"当物化视图不足以提供查询的全部数据时，是否允许基表和物化视图 union 来响应查询",
"When the materialized view is not enough to provide all the data for the query, "
+ "whether to allow the union of the base table and the materialized view to "
- + "respond to the query"})
+ + "respond to the query"}, varType = VariableAnnotation.REMOVED)
Review Comment:
Why mark the config removed which is still active?
--
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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2151387523
<details>
<summary>ClickBench: <b>Total hot run time: 31.18 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 3c1417046d721c38602f3253875e7da382c00331, data reload: false
query1 0.04 0.03 0.04
query2 0.08 0.03 0.04
query3 0.23 0.05 0.06
query4 1.66 0.08 0.08
query5 0.50 0.49 0.48
query6 1.12 0.73 0.73
query7 0.02 0.02 0.02
query8 0.06 0.04 0.04
query9 0.53 0.48 0.49
query10 0.54 0.54 0.54
query11 0.15 0.11 0.11
query12 0.14 0.12 0.12
query13 0.60 0.60 0.60
query14 0.78 0.78 0.78
query15 0.82 0.79 0.81
query16 0.35 0.36 0.36
query17 1.03 1.04 1.03
query18 0.22 0.25 0.24
query19 1.80 1.68 1.86
query20 0.01 0.01 0.02
query21 15.43 0.69 0.66
query22 4.62 6.32 2.37
query23 18.31 1.36 1.27
query24 2.18 0.21 0.20
query25 0.16 0.07 0.09
query26 0.28 0.17 0.18
query27 0.09 0.08 0.08
query28 13.21 1.02 0.99
query29 13.21 3.32 3.32
query30 0.24 0.06 0.05
query31 2.87 0.40 0.38
query32 3.28 0.46 0.47
query33 2.89 2.91 2.94
query34 16.95 4.51 4.48
query35 4.49 4.53 4.62
query36 0.66 0.47 0.48
query37 0.16 0.15 0.15
query38 0.14 0.15 0.13
query39 0.04 0.03 0.03
query40 0.17 0.14 0.15
query41 0.09 0.05 0.05
query42 0.05 0.04 0.04
query43 0.04 0.03 0.03
Total cold run time: 110.24 s
Total hot run time: 31.18 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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #35897:
URL: https://github.com/apache/doris/pull/35897
--
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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2151348762
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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2151936164
<details>
<summary>TPC-H: <b>Total hot run time: 39864 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 2e5a32c46f2f3f644ed9b5857f57bacf8bdb7d39, data reload: false
------ Round 1 ----------------------------------
q1 18014 4570 4389 4389
q2 2637 198 206 198
q3 11756 1208 1143 1143
q4 10181 837 783 783
q5 7606 2722 2668 2668
q6 227 138 137 137
q7 978 604 599 599
q8 9253 2075 2061 2061
q9 9046 6512 6486 6486
q10 8924 3653 3689 3653
q11 489 235 230 230
q12 435 231 230 230
q13 18961 2948 2969 2948
q14 272 220 228 220
q15 515 471 476 471
q16 520 384 375 375
q17 973 690 642 642
q18 8085 7393 7440 7393
q19 7025 1566 1446 1446
q20 662 306 317 306
q21 4945 3163 3151 3151
q22 392 335 338 335
Total cold run time: 121896 ms
Total hot run time: 39864 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4372 4264 4257 4257
q2 361 266 275 266
q3 2996 2720 2747 2720
q4 1867 1562 1534 1534
q5 5283 5276 5270 5270
q6 214 125 127 125
q7 2128 1746 1737 1737
q8 3185 3347 3332 3332
q9 8360 8340 8363 8340
q10 3844 3650 3686 3650
q11 571 476 488 476
q12 758 580 569 569
q13 17672 3010 2999 2999
q14 307 262 272 262
q15 521 487 470 470
q16 494 413 402 402
q17 1804 1475 1477 1475
q18 7718 7410 7332 7332
q19 1701 1534 1516 1516
q20 1995 1799 1746 1746
q21 4942 4603 4744 4603
q22 635 520 533 520
Total cold run time: 71728 ms
Total hot run time: 53601 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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2160013449
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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2151966744
<details>
<summary>ClickBench: <b>Total hot run time: 30.49 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 2e5a32c46f2f3f644ed9b5857f57bacf8bdb7d39, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.04 0.04
query3 0.23 0.05 0.05
query4 1.68 0.10 0.08
query5 0.51 0.49 0.50
query6 1.12 0.72 0.71
query7 0.02 0.01 0.02
query8 0.04 0.04 0.05
query9 0.54 0.48 0.50
query10 0.54 0.56 0.54
query11 0.16 0.11 0.12
query12 0.14 0.12 0.12
query13 0.59 0.58 0.58
query14 0.76 0.80 0.79
query15 0.83 0.80 0.82
query16 0.37 0.38 0.37
query17 1.03 0.96 1.02
query18 0.21 0.25 0.24
query19 1.87 1.67 1.71
query20 0.01 0.01 0.01
query21 15.44 0.71 0.68
query22 4.46 6.77 1.85
query23 18.25 1.48 1.31
query24 2.11 0.23 0.22
query25 0.16 0.08 0.08
query26 0.28 0.17 0.18
query27 0.08 0.08 0.09
query28 13.25 1.02 1.01
query29 12.72 3.21 3.27
query30 0.24 0.06 0.06
query31 2.86 0.40 0.38
query32 3.31 0.48 0.47
query33 2.87 2.91 2.87
query34 17.11 4.39 4.42
query35 4.48 4.53 4.57
query36 0.65 0.48 0.49
query37 0.17 0.15 0.16
query38 0.16 0.14 0.14
query39 0.05 0.03 0.04
query40 0.16 0.14 0.14
query41 0.08 0.05 0.05
query42 0.05 0.04 0.04
query43 0.04 0.03 0.03
Total cold run time: 109.75 s
Total hot run time: 30.49 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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2151954840
<details>
<summary>TPC-DS: <b>Total hot run time: 172306 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 2e5a32c46f2f3f644ed9b5857f57bacf8bdb7d39, data reload: false
query1 927 380 392 380
query2 6466 2378 2371 2371
query3 6647 212 211 211
query4 20578 17226 17325 17226
query5 4107 452 471 452
query6 246 166 170 166
query7 4592 302 295 295
query8 344 281 303 281
query9 8544 2415 2397 2397
query10 448 303 278 278
query11 10424 9968 9951 9951
query12 140 90 86 86
query13 1636 397 358 358
query14 10015 6881 6994 6881
query15 227 186 186 186
query16 7666 266 271 266
query17 1346 531 527 527
query18 1953 269 273 269
query19 206 154 153 153
query20 89 86 82 82
query21 206 133 126 126
query22 4449 3952 3939 3939
query23 33756 32951 32864 32864
query24 12203 2882 2806 2806
query25 663 359 352 352
query26 1757 159 158 158
query27 2986 320 322 320
query28 7639 2053 2050 2050
query29 1106 622 608 608
query30 298 151 146 146
query31 945 779 736 736
query32 95 52 57 52
query33 768 287 275 275
query34 972 465 479 465
query35 746 618 618 618
query36 1091 957 944 944
query37 159 74 74 74
query38 2888 2737 2729 2729
query39 869 782 795 782
query40 285 134 132 132
query41 56 53 53 53
query42 121 101 99 99
query43 588 533 547 533
query44 1224 729 738 729
query45 201 155 168 155
query46 1080 745 734 734
query47 1838 1742 1737 1737
query48 381 304 287 287
query49 1195 418 417 417
query50 797 397 393 393
query51 6763 6692 6694 6692
query52 114 92 92 92
query53 352 286 292 286
query54 1009 454 439 439
query55 77 75 73 73
query56 289 258 267 258
query57 1169 1072 1080 1072
query58 259 242 252 242
query59 3627 3166 3124 3124
query60 320 282 268 268
query61 99 116 112 112
query62 654 461 446 446
query63 328 295 298 295
query64 9923 2222 1746 1746
query65 3178 3116 3104 3104
query66 1376 357 332 332
query67 15486 14898 14789 14789
query68 4578 556 567 556
query69 450 357 306 306
query70 1158 1043 1067 1043
query71 405 284 276 276
query72 7044 5587 5538 5538
query73 750 329 328 328
query74 5919 5529 5516 5516
query75 3403 2647 2713 2647
query76 2482 938 942 938
query77 442 290 296 290
query78 10289 9990 9813 9813
query79 2223 526 529 526
query80 1025 478 488 478
query81 577 228 224 224
query82 708 104 105 104
query83 225 172 175 172
query84 247 86 84 84
query85 2006 338 271 271
query86 488 282 302 282
query87 3237 3069 3157 3069
query88 4005 2353 2349 2349
query89 490 404 388 388
query90 1812 191 191 191
query91 129 120 100 100
query92 65 49 50 49
query93 2339 526 509 509
query94 1213 185 190 185
query95 406 306 313 306
query96 613 272 262 262
query97 3135 3065 2977 2977
query98 231 202 201 201
query99 1197 829 849 829
Total cold run time: 276277 ms
Total hot run time: 172306 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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2151800652
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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2154417163
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] [opt](mtmv) Set query rewrite by materialized view default enable [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35897:
URL: https://github.com/apache/doris/pull/35897#issuecomment-2151375234
<details>
<summary>TPC-H: <b>Total hot run time: 41633 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 3c1417046d721c38602f3253875e7da382c00331, data reload: false
------ Round 1 ----------------------------------
q1 17610 4410 4280 4280
q2 2025 189 188 188
q3 10452 1210 1109 1109
q4 10199 844 755 755
q5 7481 2710 2741 2710
q6 223 140 138 138
q7 955 633 621 621
q8 9239 2154 2136 2136
q9 9298 6769 6743 6743
q10 10183 3938 3894 3894
q11 443 235 251 235
q12 469 244 247 244
q13 17241 3194 3281 3194
q14 268 208 229 208
q15 520 473 473 473
q16 495 396 381 381
q17 966 673 637 637
q18 8424 7705 7879 7705
q19 8347 1361 1563 1361
q20 673 321 313 313
q21 5125 4010 3979 3979
q22 408 338 329 329
Total cold run time: 121044 ms
Total hot run time: 41633 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4675 4417 4502 4417
q2 364 272 260 260
q3 3168 2946 2938 2938
q4 1938 1653 1607 1607
q5 5487 5467 5467 5467
q6 226 128 131 128
q7 2209 1851 1843 1843
q8 3220 3435 3360 3360
q9 8714 8700 8737 8700
q10 4092 3790 3770 3770
q11 592 483 502 483
q12 839 670 634 634
q13 16765 3132 3182 3132
q14 300 260 270 260
q15 518 482 470 470
q16 476 424 430 424
q17 1850 1517 1510 1510
q18 8000 7491 7321 7321
q19 1737 1547 1573 1547
q20 2074 1768 1776 1768
q21 5615 4845 4670 4670
q22 613 549 538 538
Total cold run time: 73472 ms
Total hot run time: 55247 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