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/09/06 09:25:51 UTC
[PR] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
seawinde opened a new pull request, #40485:
URL: https://github.com/apache/doris/pull/40485
## Proposed changes
This is brought by https://github.com/apache/doris/pull/35562
if partition mv def is as following:
```sql
CREATE MATERIALIZED VIEW mv1
BUILD IMMEDIATE REFRESH COMPLETE ON MANUAL
PARTITION BY (upgrade_day)
DISTRIBUTED BY RANDOM BUCKETS 2
PROPERTIES ('replication_num' = '1')
AS
select t1.upgrade_day, t2.batch_no, count(*)
from test2 t2 join test1 t1 on
t1.upgrade_day = t2.upgrade_day
group by t1.upgrade_day, t2.batch_no;
```
the mv related partition table should `test1`, but now is `test2`, this pr fix this.
--
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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #40485:
URL: https://github.com/apache/doris/pull/40485
--
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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2344209718
<details>
<summary>TPC-DS: <b>Total hot run time: 197486 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 4d16e1b582a89ffbd7252095b8bdbbde6d2e6fff, data reload: false
query1 1263 879 875 875
query2 6296 1930 1927 1927
query3 10589 4119 3897 3897
query4 60596 24623 23296 23296
query5 4981 520 490 490
query6 399 169 172 169
query7 5617 299 292 292
query8 317 219 219 219
query9 7497 2509 2504 2504
query10 406 278 270 270
query11 17415 15079 15198 15079
query12 162 108 108 108
query13 1457 398 448 398
query14 9646 7394 6964 6964
query15 211 188 174 174
query16 6869 475 440 440
query17 1087 567 566 566
query18 1578 315 291 291
query19 212 159 149 149
query20 119 111 112 111
query21 218 105 104 104
query22 4663 4733 4813 4733
query23 34343 33522 33577 33522
query24 6024 2894 2829 2829
query25 479 366 383 366
query26 609 150 148 148
query27 1617 273 271 271
query28 3900 2059 2059 2059
query29 641 405 403 403
query30 212 150 164 150
query31 924 758 787 758
query32 102 52 50 50
query33 442 280 285 280
query34 881 468 462 462
query35 837 712 721 712
query36 1032 939 919 919
query37 147 86 84 84
query38 4038 3948 3982 3948
query39 1475 1410 1440 1410
query40 197 119 113 113
query41 46 47 45 45
query42 111 94 94 94
query43 498 458 470 458
query44 1051 746 730 730
query45 194 165 171 165
query46 1082 722 744 722
query47 1926 1838 1805 1805
query48 376 285 288 285
query49 759 428 432 428
query50 829 409 399 399
query51 7021 6949 6887 6887
query52 100 87 86 86
query53 255 185 179 179
query54 561 459 444 444
query55 77 107 73 73
query56 271 258 257 257
query57 1213 1049 1068 1049
query58 217 235 236 235
query59 3033 2824 2741 2741
query60 292 261 264 261
query61 99 99 102 99
query62 735 637 652 637
query63 215 182 186 182
query64 1345 697 674 674
query65 3229 3141 3131 3131
query66 669 329 340 329
query67 15782 15500 15398 15398
query68 1309 843 836 836
query69 418 318 319 318
query70 1153 1210 1170 1170
query71 339 334 331 331
query72 4568 3542 3686 3542
query73 573 565 568 565
query74 9129 8909 8930 8909
query75 3036 2949 2981 2949
query76 971 847 841 841
query77 402 392 394 392
query78 9215 9251 9260 9251
query79 892 891 840 840
query80 795 809 775 775
query81 492 264 260 260
query82 260 261 262 261
query83 189 187 186 186
query84 190 109 103 103
query85 657 400 381 381
query86 333 317 303 303
query87 4467 4391 4595 4391
query88 4160 4013 4020 4013
query89 375 363 362 362
query90 842 304 303 303
query91 122 123 125 123
query92 77 76 73 73
query93 908 886 891 886
query94 408 352 366 352
query95 419 414 410 410
query96 466 464 468 464
query97 3092 3083 3079 3079
query98 229 260 229 229
query99 1345 1295 1255 1255
Total cold run time: 293315 ms
Total hot run time: 197486 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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2337274865
<details>
<summary>ClickBench: <b>Total hot run time: 31.22 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 e8e82ab1cbdff7ab403f1e5e9cc05eb4cf537132, data reload: false
query1 0.05 0.04 0.03
query2 0.07 0.04 0.04
query3 0.23 0.05 0.04
query4 1.68 0.08 0.07
query5 0.52 0.51 0.50
query6 1.14 0.73 0.73
query7 0.02 0.01 0.02
query8 0.06 0.05 0.05
query9 0.55 0.49 0.48
query10 0.54 0.56 0.54
query11 0.15 0.12 0.12
query12 0.14 0.12 0.13
query13 0.60 0.58 0.58
query14 1.40 1.43 1.44
query15 0.85 0.83 0.83
query16 0.38 0.37 0.38
query17 1.01 1.05 1.01
query18 0.21 0.20 0.21
query19 1.98 1.76 1.81
query20 0.01 0.01 0.01
query21 15.39 0.67 0.66
query22 4.08 7.94 1.67
query23 18.27 1.36 1.24
query24 2.14 0.23 0.21
query25 0.16 0.08 0.08
query26 0.28 0.18 0.18
query27 0.08 0.08 0.07
query28 13.29 1.02 1.01
query29 12.64 3.34 3.33
query30 0.25 0.05 0.06
query31 2.89 0.40 0.40
query32 3.24 0.48 0.48
query33 2.93 2.99 3.04
query34 17.20 4.44 4.48
query35 4.44 4.49 4.45
query36 0.66 0.46 0.47
query37 0.18 0.15 0.15
query38 0.16 0.14 0.15
query39 0.05 0.04 0.04
query40 0.16 0.13 0.12
query41 0.09 0.04 0.04
query42 0.06 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 110.28 s
Total hot run time: 31.22 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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2337265763
<details>
<summary>TPC-DS: <b>Total hot run time: 196960 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 e8e82ab1cbdff7ab403f1e5e9cc05eb4cf537132, data reload: false
query1 1245 899 897 897
query2 6462 1875 1850 1850
query3 10751 4082 4005 4005
query4 60113 29144 23328 23328
query5 5048 499 495 495
query6 398 164 163 163
query7 5629 327 302 302
query8 318 222 223 222
query9 7668 2488 2495 2488
query10 408 279 266 266
query11 17387 15049 15445 15049
query12 148 107 104 104
query13 1437 394 390 390
query14 10748 7427 7000 7000
query15 222 182 177 177
query16 6806 485 496 485
query17 1077 567 619 567
query18 1344 295 300 295
query19 209 157 159 157
query20 118 114 112 112
query21 210 106 105 105
query22 4747 4412 4654 4412
query23 35169 33441 33512 33441
query24 6004 2875 2866 2866
query25 492 378 386 378
query26 620 151 155 151
query27 1634 280 285 280
query28 4228 2117 2096 2096
query29 654 417 422 417
query30 226 157 156 156
query31 955 813 805 805
query32 71 55 54 54
query33 408 292 285 285
query34 904 487 494 487
query35 817 722 700 700
query36 1061 942 919 919
query37 142 82 86 82
query38 3979 3898 3949 3898
query39 1432 1403 1413 1403
query40 205 116 115 115
query41 46 43 45 43
query42 118 94 95 94
query43 510 469 451 451
query44 1121 767 737 737
query45 195 165 164 164
query46 1094 744 749 744
query47 1889 1786 1820 1786
query48 374 297 288 288
query49 765 443 444 443
query50 822 413 459 413
query51 7038 6932 6904 6904
query52 98 86 87 86
query53 257 178 177 177
query54 559 454 444 444
query55 75 74 76 74
query56 280 260 264 260
query57 1207 1075 1063 1063
query58 215 253 224 224
query59 2918 2658 2778 2658
query60 290 266 266 266
query61 101 101 108 101
query62 754 659 646 646
query63 219 183 188 183
query64 1333 715 674 674
query65 3228 3188 3133 3133
query66 654 346 348 346
query67 15865 15404 15180 15180
query68 1775 560 569 560
query69 417 280 281 280
query70 1179 1131 1050 1050
query71 337 278 274 274
query72 4676 3979 4010 3979
query73 748 326 328 326
query74 9123 8819 8879 8819
query75 3353 2729 2734 2729
query76 1374 982 977 977
query77 535 331 318 318
query78 9910 9674 9366 9366
query79 982 952 874 874
query80 1016 840 904 840
query81 542 267 268 267
query82 1384 266 272 266
query83 248 187 193 187
query84 266 107 106 106
query85 709 411 392 392
query86 314 310 315 310
query87 4356 4350 4257 4257
query88 4525 4140 4139 4139
query89 393 375 372 372
query90 1888 321 316 316
query91 122 127 129 127
query92 78 80 81 80
query93 974 953 938 938
query94 679 363 357 357
query95 456 418 420 418
query96 479 476 475 475
query97 3140 3081 3127 3081
query98 297 226 221 221
query99 1521 1275 1292 1275
Total cold run time: 301315 ms
Total hot run time: 196960 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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2337191668
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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2333716820
<details>
<summary>TPC-H: <b>Total hot run time: 37867 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 cfee95d05fd9bff5de5dc775b3786043fed0dccf, data reload: false
------ Round 1 ----------------------------------
q1 17625 4480 4319 4319
q2 2026 186 185 185
q3 11837 906 1088 906
q4 10512 672 759 672
q5 7770 2831 2833 2831
q6 228 139 138 138
q7 963 620 594 594
q8 9321 2082 2033 2033
q9 7244 6525 6565 6525
q10 7026 2252 2216 2216
q11 466 250 243 243
q12 387 222 220 220
q13 18032 3132 3088 3088
q14 283 244 237 237
q15 539 489 481 481
q16 516 445 425 425
q17 976 687 742 687
q18 7388 6885 7000 6885
q19 1397 986 1057 986
q20 678 341 347 341
q21 4527 3020 2828 2828
q22 1155 1044 1027 1027
Total cold run time: 110896 ms
Total hot run time: 37867 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4422 4372 4350 4350
q2 380 285 264 264
q3 2921 2710 2743 2710
q4 2001 1746 1754 1746
q5 5787 5860 5945 5860
q6 235 140 140 140
q7 2277 1847 1844 1844
q8 3289 3435 3503 3435
q9 8958 9153 8993 8993
q10 3795 3458 3342 3342
q11 620 514 502 502
q12 879 725 746 725
q13 14385 3345 3426 3345
q14 309 306 281 281
q15 562 490 501 490
q16 520 501 484 484
q17 1838 1576 1553 1553
q18 8329 7939 8001 7939
q19 1754 1649 1588 1588
q20 2142 1914 1911 1911
q21 5784 5555 5575 5555
q22 1141 1080 1058 1058
Total cold run time: 72328 ms
Total hot run time: 58115 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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2344230991
<details>
<summary>ClickBench: <b>Total hot run time: 32.05 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 4d16e1b582a89ffbd7252095b8bdbbde6d2e6fff, data reload: false
query1 0.05 0.05 0.04
query2 0.08 0.04 0.04
query3 0.23 0.05 0.06
query4 1.65 0.08 0.08
query5 0.51 0.49 0.50
query6 1.13 0.73 0.73
query7 0.02 0.01 0.02
query8 0.05 0.04 0.05
query9 0.54 0.49 0.49
query10 0.54 0.55 0.53
query11 0.16 0.11 0.12
query12 0.14 0.12 0.12
query13 0.60 0.59 0.60
query14 1.41 1.43 1.41
query15 0.85 0.83 0.81
query16 0.36 0.36 0.37
query17 1.04 1.06 1.05
query18 0.17 0.17 0.17
query19 1.81 1.86 1.79
query20 0.02 0.01 0.01
query21 15.38 0.68 0.67
query22 4.85 5.95 2.36
query23 18.27 1.38 1.23
query24 2.13 0.24 0.21
query25 0.14 0.09 0.07
query26 0.27 0.18 0.17
query27 0.08 0.08 0.09
query28 13.20 1.02 1.00
query29 12.69 3.49 3.48
query30 0.25 0.05 0.05
query31 2.88 0.39 0.40
query32 3.25 0.49 0.48
query33 3.00 3.05 3.00
query34 17.12 4.42 4.50
query35 4.46 4.46 4.47
query36 0.66 0.48 0.46
query37 0.19 0.15 0.15
query38 0.15 0.15 0.15
query39 0.04 0.04 0.04
query40 0.16 0.13 0.12
query41 0.10 0.05 0.05
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 110.73 s
Total hot run time: 32.05 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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2333643087
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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2337618948
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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2333738721
<details>
<summary>TPC-DS: <b>Total hot run time: 192311 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 cfee95d05fd9bff5de5dc775b3786043fed0dccf, data reload: false
query1 1255 893 888 888
query2 6320 1953 1920 1920
query3 10763 3984 4020 3984
query4 59941 24436 23126 23126
query5 5462 511 507 507
query6 417 177 169 169
query7 5793 298 289 289
query8 336 228 223 223
query9 9295 2468 2443 2443
query10 498 281 250 250
query11 17942 14993 15276 14993
query12 158 103 99 99
query13 1592 401 388 388
query14 10275 7075 7217 7075
query15 228 182 173 173
query16 7169 490 497 490
query17 1154 599 600 599
query18 1520 304 311 304
query19 297 170 154 154
query20 132 119 117 117
query21 214 106 107 106
query22 4537 4440 4662 4440
query23 34305 33374 33430 33374
query24 5977 2835 2847 2835
query25 550 402 400 400
query26 692 173 157 157
query27 1777 277 274 274
query28 3663 2030 2015 2015
query29 673 421 421 421
query30 238 154 156 154
query31 927 774 768 768
query32 91 54 63 54
query33 483 293 289 289
query34 867 474 467 467
query35 855 726 734 726
query36 1087 911 940 911
query37 151 94 85 85
query38 3935 3840 3855 3840
query39 1440 1425 1394 1394
query40 201 115 117 115
query41 49 49 49 49
query42 121 96 96 96
query43 500 478 486 478
query44 1074 758 743 743
query45 194 162 168 162
query46 1092 754 745 745
query47 1918 1804 1862 1804
query48 378 296 305 296
query49 780 451 464 451
query50 826 404 403 403
query51 7053 6915 6960 6915
query52 110 87 87 87
query53 248 179 177 177
query54 562 453 460 453
query55 77 77 75 75
query56 289 267 265 265
query57 1224 1065 1104 1065
query58 232 331 293 293
query59 2943 2857 2724 2724
query60 286 265 276 265
query61 100 97 100 97
query62 726 671 641 641
query63 220 187 184 184
query64 2799 681 648 648
query65 3228 3142 3169 3142
query66 692 337 342 337
query67 15692 15178 15211 15178
query68 4403 575 563 563
query69 429 275 269 269
query70 1165 1070 1100 1070
query71 363 272 268 268
query72 6686 3982 3883 3883
query73 746 316 315 315
query74 9259 8882 8728 8728
query75 3347 2655 2722 2655
query76 1966 995 1032 995
query77 560 319 321 319
query78 9724 9236 9361 9236
query79 1058 534 511 511
query80 856 492 496 492
query81 570 230 230 230
query82 276 134 139 134
query83 257 148 147 147
query84 253 73 76 73
query85 943 287 275 275
query86 333 291 301 291
query87 4449 4404 4298 4298
query88 3345 2272 2296 2272
query89 392 282 277 277
query90 2036 184 184 184
query91 119 96 99 96
query92 57 47 48 47
query93 1389 536 542 536
query94 781 309 285 285
query95 345 244 250 244
query96 584 259 264 259
query97 3182 3068 3068 3068
query98 214 201 202 201
query99 1567 1301 1324 1301
Total cold run time: 308277 ms
Total hot run time: 192311 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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2337244557
<details>
<summary>TPC-H: <b>Total hot run time: 38424 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 e8e82ab1cbdff7ab403f1e5e9cc05eb4cf537132, data reload: false
------ Round 1 ----------------------------------
q1 17810 4410 4292 4292
q2 2030 191 187 187
q3 11906 997 1169 997
q4 10498 694 781 694
q5 7733 2880 2838 2838
q6 231 139 136 136
q7 965 626 613 613
q8 10120 2079 2113 2079
q9 7094 6620 6628 6620
q10 7011 2213 2265 2213
q11 465 248 244 244
q12 394 221 223 221
q13 18916 3147 3263 3147
q14 293 264 258 258
q15 541 477 500 477
q16 558 456 463 456
q17 1000 689 685 685
q18 9171 7448 7075 7075
q19 1398 1052 1060 1052
q20 707 338 341 338
q21 4134 3116 2769 2769
q22 1192 1038 1033 1033
Total cold run time: 114167 ms
Total hot run time: 38424 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4412 4375 4355 4355
q2 381 272 266 266
q3 2853 2645 2625 2625
q4 1956 1732 1750 1732
q5 5742 5799 5662 5662
q6 226 133 130 130
q7 2230 1855 1830 1830
q8 3339 3531 3456 3456
q9 8920 8842 8964 8842
q10 3640 3313 3317 3313
q11 611 508 504 504
q12 863 613 627 613
q13 17116 3276 3291 3276
q14 322 284 316 284
q15 535 499 500 499
q16 555 497 502 497
q17 1858 1559 1525 1525
q18 8124 7917 7911 7911
q19 1722 1483 1597 1483
q20 2175 1907 1966 1907
q21 5706 5458 5358 5358
q22 1118 1043 1043 1043
Total cold run time: 74404 ms
Total hot run time: 57111 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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2344163956
<details>
<summary>TPC-H: <b>Total hot run time: 38033 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 4d16e1b582a89ffbd7252095b8bdbbde6d2e6fff, data reload: false
------ Round 1 ----------------------------------
q1 17628 4524 4366 4366
q2 2029 212 186 186
q3 11922 951 1124 951
q4 10531 655 811 655
q5 7760 2902 2884 2884
q6 231 142 137 137
q7 970 618 592 592
q8 9551 2105 2145 2105
q9 8157 6566 6564 6564
q10 6995 2234 2193 2193
q11 443 239 242 239
q12 393 218 220 218
q13 19002 3059 3107 3059
q14 295 238 237 237
q15 533 507 476 476
q16 524 425 439 425
q17 1010 713 724 713
q18 7439 7054 6867 6867
q19 1388 1078 1029 1029
q20 698 325 353 325
q21 3948 3106 2792 2792
q22 1108 1025 1020 1020
Total cold run time: 112555 ms
Total hot run time: 38033 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4376 4304 4321 4304
q2 405 298 275 275
q3 2891 2662 2660 2660
q4 1938 1685 1741 1685
q5 5719 5746 5841 5746
q6 237 142 134 134
q7 2241 1850 1873 1850
q8 3329 3535 3532 3532
q9 8909 8924 8844 8844
q10 3673 3415 3369 3369
q11 612 504 516 504
q12 862 704 675 675
q13 14974 3276 3347 3276
q14 328 284 305 284
q15 545 499 512 499
q16 572 492 505 492
q17 1860 1569 1549 1549
q18 8233 7936 7935 7935
q19 1743 1587 1640 1587
q20 2295 1924 1923 1923
q21 5740 5484 5451 5451
q22 1112 1067 1044 1044
Total cold run time: 72594 ms
Total hot run time: 57618 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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2333747922
<details>
<summary>ClickBench: <b>Total hot run time: 31.27 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit cfee95d05fd9bff5de5dc775b3786043fed0dccf, data reload: false
query1 0.05 0.04 0.04
query2 0.09 0.04 0.04
query3 0.23 0.05 0.05
query4 1.68 0.07 0.07
query5 0.52 0.51 0.49
query6 1.13 0.74 0.75
query7 0.02 0.02 0.01
query8 0.05 0.04 0.04
query9 0.54 0.49 0.50
query10 0.54 0.56 0.54
query11 0.15 0.11 0.11
query12 0.15 0.12 0.12
query13 0.59 0.60 0.59
query14 1.40 1.41 1.42
query15 0.83 0.82 0.82
query16 0.38 0.38 0.37
query17 1.01 1.02 1.01
query18 0.21 0.21 0.20
query19 1.94 1.77 1.86
query20 0.01 0.01 0.01
query21 15.40 0.66 0.66
query22 4.71 7.38 1.57
query23 18.27 1.45 1.31
query24 2.05 0.23 0.24
query25 0.15 0.09 0.08
query26 0.28 0.18 0.17
query27 0.08 0.08 0.08
query28 13.18 1.04 1.00
query29 12.58 3.34 3.33
query30 0.26 0.06 0.05
query31 2.89 0.40 0.39
query32 3.24 0.49 0.47
query33 2.95 2.98 3.00
query34 17.28 4.45 4.45
query35 4.50 4.50 4.48
query36 0.67 0.50 0.50
query37 0.18 0.17 0.16
query38 0.15 0.14 0.15
query39 0.04 0.04 0.03
query40 0.16 0.13 0.13
query41 0.10 0.05 0.05
query42 0.06 0.06 0.05
query43 0.04 0.04 0.04
Total cold run time: 110.74 s
Total hot run time: 31.27 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2333645600
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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2344007109
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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2337619012
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] [fix](mtmv) Fix partition trace wrong when partition name is same from both side of join [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #40485:
URL: https://github.com/apache/doris/pull/40485#issuecomment-2343248807
run p0
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org