You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "924060929 (via GitHub)" <gi...@apache.org> on 2024/07/03 09:14:23 UTC
[PR] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
924060929 opened a new pull request, #37219:
URL: https://github.com/apache/doris/pull/37219
Default set enable_nereids_distribute_planner=true
--
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2219454383
<details>
<summary>TPC-DS: <b>Total hot run time: 170924 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 81c3cd23723182cce8b3737495bf982244bdffde, data reload: false
query1 918 367 365 365
query2 6370 2399 2410 2399
query3 6643 208 219 208
query4 28250 17364 17265 17265
query5 3672 459 493 459
query6 267 172 169 169
query7 4570 301 283 283
query8 319 293 288 288
query9 8560 2380 2360 2360
query10 433 302 267 267
query11 10571 9899 10205 9899
query12 116 84 82 82
query13 1645 386 377 377
query14 10251 7739 7040 7040
query15 236 197 195 195
query16 7695 307 310 307
query17 1802 531 518 518
query18 1819 270 270 270
query19 196 149 149 149
query20 87 82 81 81
query21 201 130 125 125
query22 4400 3967 4029 3967
query23 33972 33626 33729 33626
query24 11340 3083 3102 3083
query25 616 363 370 363
query26 1190 158 157 157
query27 2394 280 280 280
query28 6824 2148 2118 2118
query29 910 623 633 623
query30 269 147 150 147
query31 1197 912 892 892
query32 99 56 55 55
query33 777 305 309 305
query34 1031 480 500 480
query35 705 588 616 588
query36 1144 971 929 929
query37 162 84 88 84
query38 2942 2908 2795 2795
query39 934 862 815 815
query40 207 125 122 122
query41 54 53 51 51
query42 115 99 100 99
query43 568 536 527 527
query44 1188 736 786 736
query45 201 171 167 167
query46 1122 736 703 703
query47 1837 1772 1759 1759
query48 384 297 303 297
query49 893 409 404 404
query50 783 391 399 391
query51 6888 6648 6607 6607
query52 104 100 90 90
query53 355 289 285 285
query54 907 448 442 442
query55 73 70 79 70
query56 277 261 265 261
query57 1105 1090 1045 1045
query58 234 243 240 240
query59 3551 3310 3268 3268
query60 299 289 281 281
query61 95 111 89 89
query62 795 650 657 650
query63 316 324 296 296
query64 9480 2164 1622 1622
query65 3159 3122 3150 3122
query66 741 321 331 321
query67 15477 15025 14790 14790
query68 4488 544 546 544
query69 535 409 340 340
query70 1147 1071 1149 1071
query71 417 283 279 279
query72 7146 5671 2840 2840
query73 723 323 325 323
query74 5820 5463 5457 5457
query75 3435 2646 2675 2646
query76 2801 1013 978 978
query77 440 301 294 294
query78 9427 8988 8780 8780
query79 2233 513 509 509
query80 2174 469 474 469
query81 585 215 216 215
query82 744 141 141 141
query83 270 166 166 166
query84 251 86 82 82
query85 1907 304 290 290
query86 453 353 352 352
query87 3265 3147 3081 3081
query88 4525 2443 2440 2440
query89 477 384 399 384
query90 1814 188 182 182
query91 131 98 100 98
query92 59 49 48 48
query93 2362 504 511 504
query94 1114 209 210 209
query95 408 315 374 315
query96 598 267 271 267
query97 3184 2995 3040 2995
query98 229 200 199 199
query99 1499 1278 1289 1278
Total cold run time: 281396 ms
Total hot run time: 170924 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2217875860
<details>
<summary>ClickBench: <b>Total hot run time: 30.52 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 a98798cffdad6d3c0fc479a06e5f93d559b6707c, data reload: false
query1 0.04 0.04 0.03
query2 0.07 0.03 0.04
query3 0.23 0.06 0.06
query4 1.67 0.07 0.08
query5 0.50 0.48 0.48
query6 1.13 0.73 0.72
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.55 0.48 0.47
query10 0.54 0.53 0.53
query11 0.16 0.11 0.12
query12 0.14 0.11 0.12
query13 0.60 0.59 0.58
query14 0.75 0.78 0.75
query15 0.86 0.84 0.81
query16 0.36 0.37 0.37
query17 0.97 0.97 1.01
query18 0.24 0.22 0.22
query19 1.86 1.72 1.73
query20 0.01 0.01 0.02
query21 15.42 0.75 0.66
query22 3.84 7.60 1.84
query23 18.21 1.36 1.39
query24 2.10 0.25 0.22
query25 0.17 0.08 0.09
query26 0.30 0.20 0.20
query27 0.46 0.22 0.22
query28 13.24 1.01 1.00
query29 12.63 3.31 3.29
query30 0.26 0.05 0.07
query31 2.85 0.40 0.39
query32 3.26 0.48 0.47
query33 2.84 2.92 2.90
query34 17.09 4.30 4.40
query35 4.40 4.41 4.47
query36 0.64 0.47 0.48
query37 0.18 0.16 0.15
query38 0.15 0.14 0.15
query39 0.04 0.03 0.04
query40 0.16 0.11 0.12
query41 0.10 0.05 0.05
query42 0.07 0.05 0.06
query43 0.04 0.04 0.04
Total cold run time: 109.2 s
Total hot run time: 30.52 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2216305606
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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2235772658
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2209207491
<details>
<summary>TPC-DS: <b>Total hot run time: 170550 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 a3fe2c75cf58d17c15221d8685807c0e747a9fdc, data reload: false
query1 930 367 359 359
query2 6489 2436 2391 2391
query3 6655 201 209 201
query4 28274 17444 17262 17262
query5 4191 492 481 481
query6 281 177 171 171
query7 4587 315 302 302
query8 323 306 304 304
query9 8589 2398 2380 2380
query10 605 299 270 270
query11 10759 10137 10076 10076
query12 135 87 85 85
query13 1645 366 364 364
query14 10274 7749 7743 7743
query15 242 193 192 192
query16 7788 316 339 316
query17 1750 558 528 528
query18 1855 281 274 274
query19 192 150 148 148
query20 87 83 83 83
query21 210 125 126 125
query22 4420 4116 4153 4116
query23 33723 33199 32989 32989
query24 12038 3032 2990 2990
query25 664 356 351 351
query26 1718 160 162 160
query27 2899 315 317 315
query28 7557 2083 2073 2073
query29 1059 622 609 609
query30 276 140 144 140
query31 1137 884 898 884
query32 91 52 56 52
query33 773 343 304 304
query34 883 464 462 462
query35 775 648 611 611
query36 1095 950 941 941
query37 149 72 71 71
query38 2851 2821 2853 2821
query39 855 793 790 790
query40 273 124 122 122
query41 54 44 53 44
query42 113 95 96 95
query43 582 555 538 538
query44 1228 729 727 727
query45 197 173 169 169
query46 1108 720 730 720
query47 1914 1791 1806 1791
query48 373 294 309 294
query49 1169 412 412 412
query50 773 394 408 394
query51 6812 6782 6748 6748
query52 112 89 93 89
query53 351 287 290 287
query54 994 444 439 439
query55 77 74 74 74
query56 307 297 314 297
query57 1140 1077 1063 1063
query58 254 233 243 233
query59 3505 3237 3010 3010
query60 300 277 281 277
query61 95 93 91 91
query62 638 435 427 427
query63 321 295 300 295
query64 9833 2273 1786 1786
query65 3373 3154 3102 3102
query66 1398 331 315 315
query67 15698 14973 14872 14872
query68 4603 542 558 542
query69 475 314 317 314
query70 1202 1093 1069 1069
query71 372 268 281 268
query72 7076 2850 2650 2650
query73 728 318 326 318
query74 5952 5560 5406 5406
query75 3365 2658 2673 2658
query76 2313 962 943 943
query77 466 299 298 298
query78 9411 8812 8878 8812
query79 2706 508 511 508
query80 2067 481 475 475
query81 582 220 225 220
query82 912 110 104 104
query83 284 188 178 178
query84 281 84 96 84
query85 2099 342 342 342
query86 480 340 361 340
query87 3316 3114 3123 3114
query88 3610 2394 2373 2373
query89 465 384 377 377
query90 1823 186 186 186
query91 140 111 114 111
query92 66 52 53 52
query93 3421 509 515 509
query94 1207 222 225 222
query95 432 333 329 329
query96 599 273 268 268
query97 3203 3005 3013 3005
query98 231 205 200 200
query99 1191 870 830 830
Total cold run time: 286894 ms
Total hot run time: 170550 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213673495
<details>
<summary>TPC-H: <b>Total hot run time: 40134 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 ad9c454538f28257e5595f971dfacfa815b7ce7a, data reload: false
------ Round 1 ----------------------------------
q1 18469 4470 4373 4373
q2 2019 191 188 188
q3 10521 1149 1131 1131
q4 10206 785 737 737
q5 7550 2632 2557 2557
q6 222 139 136 136
q7 955 592 616 592
q8 9219 2055 2095 2055
q9 8976 6965 7004 6965
q10 8866 3745 3735 3735
q11 459 231 238 231
q12 407 234 237 234
q13 17746 2996 2979 2979
q14 266 228 231 228
q15 513 490 480 480
q16 521 368 374 368
q17 963 704 646 646
q18 8262 7394 7394 7394
q19 5317 1493 1308 1308
q20 640 310 311 310
q21 4878 3157 3212 3157
q22 391 337 330 330
Total cold run time: 117366 ms
Total hot run time: 40134 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4428 4411 4224 4224
q2 392 278 278 278
q3 3024 2798 2744 2744
q4 1870 1573 1595 1573
q5 5239 5272 5267 5267
q6 225 135 130 130
q7 2114 1798 1785 1785
q8 3183 3335 3313 3313
q9 8799 8856 8848 8848
q10 3853 3641 3616 3616
q11 577 493 481 481
q12 784 646 642 642
q13 16358 3021 2971 2971
q14 291 258 274 258
q15 514 466 473 466
q16 452 412 428 412
q17 1786 1500 1467 1467
q18 7715 7425 7393 7393
q19 1710 1578 1522 1522
q20 2117 1933 1906 1906
q21 4927 4741 4838 4741
q22 619 566 566 566
Total cold run time: 70977 ms
Total hot run time: 54603 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233229159
<details>
<summary>TPC-H: <b>Total hot run time: 39971 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 b31626e7b70e491725adbebdc744075fe3e1e569, data reload: false
------ Round 1 ----------------------------------
q1 17620 4358 4323 4323
q2 2013 188 179 179
q3 10483 1224 1199 1199
q4 10200 750 791 750
q5 7539 2693 2733 2693
q6 222 136 138 136
q7 964 600 585 585
q8 9207 2126 2057 2057
q9 8789 6539 6584 6539
q10 8688 3719 3783 3719
q11 444 231 229 229
q12 515 225 225 225
q13 17765 2974 2979 2974
q14 276 231 248 231
q15 520 482 481 481
q16 486 375 377 375
q17 957 696 641 641
q18 7995 7522 7461 7461
q19 5519 1421 1458 1421
q20 704 337 326 326
q21 4946 3149 3939 3149
q22 347 278 300 278
Total cold run time: 116199 ms
Total hot run time: 39971 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4405 4292 4316 4292
q2 359 269 272 269
q3 2969 2908 2849 2849
q4 2003 1718 1688 1688
q5 5695 5529 5488 5488
q6 224 138 130 130
q7 2168 1887 1867 1867
q8 3272 3399 3434 3399
q9 8769 8757 8920 8757
q10 4070 3918 3793 3793
q11 616 511 491 491
q12 815 642 634 634
q13 15901 3215 3199 3199
q14 291 292 293 292
q15 518 493 475 475
q16 498 458 443 443
q17 1829 1532 1499 1499
q18 8125 8000 7761 7761
q19 1753 1649 1437 1437
q20 2174 1862 1870 1862
q21 5056 4883 4842 4842
q22 599 543 495 495
Total cold run time: 72109 ms
Total hot run time: 55962 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 merged PR #37219:
URL: https://github.com/apache/doris/pull/37219
--
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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233524071
<details>
<summary>TPC-H: <b>Total hot run time: 40183 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 fefda54c48d704b9126fd1d1996f0fe633930111, data reload: false
------ Round 1 ----------------------------------
q1 18009 4736 4395 4395
q2 2269 189 190 189
q3 10469 1177 1060 1060
q4 10179 737 751 737
q5 7572 2709 2679 2679
q6 223 142 139 139
q7 964 600 612 600
q8 9215 2087 2107 2087
q9 8878 6553 6527 6527
q10 8773 3892 3871 3871
q11 468 244 240 240
q12 400 235 222 222
q13 17827 3007 2951 2951
q14 276 240 232 232
q15 526 488 492 488
q16 489 389 380 380
q17 979 649 650 649
q18 8195 7644 7517 7517
q19 6747 1415 1389 1389
q20 695 326 344 326
q21 4833 3228 3967 3228
q22 346 285 277 277
Total cold run time: 118332 ms
Total hot run time: 40183 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4404 4281 4281 4281
q2 370 272 250 250
q3 2972 2759 2767 2759
q4 1875 1596 1582 1582
q5 5305 5361 5291 5291
q6 215 131 131 131
q7 2089 1724 1630 1630
q8 3186 3347 3295 3295
q9 8400 8364 8278 8278
q10 3880 3632 3760 3632
q11 570 499 498 498
q12 783 613 605 605
q13 17664 2978 2966 2966
q14 311 264 281 264
q15 529 475 465 465
q16 477 416 433 416
q17 1771 1494 1486 1486
q18 7668 7573 7400 7400
q19 1721 1367 1462 1367
q20 1998 1822 1775 1775
q21 5993 4626 4625 4625
q22 592 483 493 483
Total cold run time: 72773 ms
Total hot run time: 53479 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2236545312
<details>
<summary>ClickBench: <b>Total hot run time: 30.27 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit a6176d993f8781ee162a1a9c8336154e46724ff6, 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.08 0.08
query5 0.50 0.47 0.50
query6 1.13 0.72 0.72
query7 0.02 0.02 0.01
query8 0.05 0.04 0.05
query9 0.55 0.48 0.49
query10 0.55 0.53 0.55
query11 0.15 0.11 0.12
query12 0.15 0.12 0.12
query13 0.59 0.59 0.59
query14 0.74 0.80 0.75
query15 0.86 0.82 0.82
query16 0.36 0.36 0.37
query17 0.98 0.95 0.95
query18 0.23 0.23 0.22
query19 1.81 1.70 1.73
query20 0.03 0.01 0.00
query21 15.43 0.74 0.66
query22 3.67 7.73 1.82
query23 18.32 1.31 1.22
query24 2.13 0.26 0.22
query25 0.14 0.08 0.08
query26 0.29 0.22 0.21
query27 0.46 0.23 0.23
query28 13.19 1.02 0.99
query29 12.65 3.30 3.29
query30 0.25 0.06 0.05
query31 2.88 0.39 0.40
query32 3.25 0.47 0.46
query33 2.89 2.90 2.94
query34 17.18 4.40 4.31
query35 4.46 4.39 4.32
query36 0.65 0.48 0.50
query37 0.18 0.15 0.15
query38 0.16 0.14 0.15
query39 0.04 0.03 0.04
query40 0.15 0.11 0.12
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.3 s
Total hot run time: 30.27 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2217863480
<details>
<summary>TPC-DS: <b>Total hot run time: 175033 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 a98798cffdad6d3c0fc479a06e5f93d559b6707c, data reload: false
query1 908 380 372 372
query2 6292 2508 2454 2454
query3 6640 203 213 203
query4 27739 17659 17327 17327
query5 3527 477 483 477
query6 275 174 166 166
query7 4579 291 289 289
query8 320 306 312 306
query9 8493 2373 2358 2358
query10 436 284 264 264
query11 11884 10160 10063 10063
query12 115 82 80 80
query13 1653 387 378 378
query14 8668 7732 7683 7683
query15 236 192 190 190
query16 7791 302 296 296
query17 1794 562 530 530
query18 1923 279 271 271
query19 202 147 154 147
query20 89 82 83 82
query21 203 134 126 126
query22 4357 3921 4040 3921
query23 34897 33624 33726 33624
query24 10733 3146 3136 3136
query25 566 390 360 360
query26 800 158 158 158
query27 2402 282 285 282
query28 7302 2127 2119 2119
query29 884 640 648 640
query30 276 146 146 146
query31 1180 890 931 890
query32 101 54 55 54
query33 732 305 311 305
query34 1073 489 492 489
query35 713 604 594 594
query36 1122 978 962 962
query37 144 82 86 82
query38 2928 2862 2790 2790
query39 914 876 846 846
query40 204 122 124 122
query41 52 49 50 49
query42 119 94 99 94
query43 556 547 568 547
query44 1221 731 749 731
query45 198 169 171 169
query46 1117 762 745 745
query47 1840 1786 1737 1737
query48 380 307 299 299
query49 924 418 401 401
query50 784 395 397 395
query51 6936 6703 6758 6703
query52 108 91 93 91
query53 352 287 287 287
query54 864 446 447 446
query55 76 73 74 73
query56 287 256 261 256
query57 1157 1028 1015 1015
query58 249 241 243 241
query59 3408 3102 3371 3102
query60 303 311 272 272
query61 93 91 95 91
query62 802 652 653 652
query63 314 292 289 289
query64 9406 2220 1636 1636
query65 3228 3113 3128 3113
query66 801 319 326 319
query67 15392 15052 14913 14913
query68 4504 559 550 550
query69 527 422 338 338
query70 1097 1113 1101 1101
query71 396 277 275 275
query72 6763 5708 5777 5708
query73 727 325 327 325
query74 5854 5490 5553 5490
query75 3377 2673 2675 2673
query76 2726 1054 999 999
query77 441 289 359 289
query78 9493 8923 8771 8771
query79 3027 510 518 510
query80 2014 493 480 480
query81 611 226 221 221
query82 814 143 135 135
query83 323 174 172 172
query84 264 88 86 86
query85 1824 300 298 298
query86 481 340 406 340
query87 3288 3072 3063 3063
query88 4790 2435 2450 2435
query89 484 376 383 376
query90 1795 186 187 186
query91 132 99 101 99
query92 67 49 48 48
query93 4697 522 510 510
query94 1156 211 212 211
query95 407 315 323 315
query96 601 270 268 268
query97 3186 3004 3019 3004
query98 219 204 194 194
query99 1795 1315 1386 1315
Total cold run time: 283942 ms
Total hot run time: 175033 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2214152186
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2222018310
<details>
<summary>TPC-DS: <b>Total hot run time: 176216 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 bc34db22a1d38074beacfa9870a10401e3428b05, data reload: false
query1 912 370 362 362
query2 6367 2390 2228 2228
query3 6647 207 217 207
query4 21177 17384 17192 17192
query5 3755 489 471 471
query6 276 191 156 156
query7 4573 288 283 283
query8 324 279 277 277
query9 8462 2398 2382 2382
query10 437 264 273 264
query11 12149 10011 10074 10011
query12 113 82 79 79
query13 1647 363 355 355
query14 9958 7571 7641 7571
query15 230 188 194 188
query16 7383 308 313 308
query17 1377 530 518 518
query18 1927 271 263 263
query19 194 150 153 150
query20 91 87 82 82
query21 205 124 124 124
query22 4462 4091 4153 4091
query23 33808 33516 33687 33516
query24 11155 3057 3084 3057
query25 595 384 412 384
query26 700 154 154 154
query27 2366 284 282 282
query28 6190 2154 2142 2142
query29 855 641 611 611
query30 241 155 152 152
query31 1139 975 902 902
query32 99 53 52 52
query33 650 295 308 295
query34 866 483 498 483
query35 726 635 625 625
query36 1178 981 981 981
query37 147 86 92 86
query38 3045 2889 2837 2837
query39 893 849 806 806
query40 215 130 119 119
query41 58 51 52 51
query42 112 106 116 106
query43 608 578 543 543
query44 1069 728 734 728
query45 204 173 174 173
query46 1139 785 730 730
query47 1859 1793 1807 1793
query48 370 298 309 298
query49 846 446 419 419
query50 775 388 389 388
query51 6908 6795 6835 6795
query52 101 92 92 92
query53 358 290 287 287
query54 852 458 456 456
query55 79 77 78 77
query56 305 286 289 286
query57 1135 1070 1080 1070
query58 258 243 258 243
query59 3480 3147 3349 3147
query60 319 300 286 286
query61 119 113 116 113
query62 823 684 660 660
query63 326 292 291 291
query64 9576 2349 7567 2349
query65 3170 3110 3164 3110
query66 801 335 329 329
query67 15739 15116 15170 15116
query68 5845 573 556 556
query69 718 439 353 353
query70 1190 1118 1170 1118
query71 477 282 276 276
query72 8701 5983 5952 5952
query73 746 318 319 318
query74 5900 5562 5509 5509
query75 3898 2698 2732 2698
query76 3532 979 989 979
query77 631 303 315 303
query78 9738 9026 9035 9026
query79 8162 526 523 523
query80 2439 466 464 464
query81 597 220 219 219
query82 1316 171 131 131
query83 280 169 165 165
query84 269 84 79 79
query85 1371 303 291 291
query86 452 349 337 337
query87 3306 3076 3134 3076
query88 5025 2373 2362 2362
query89 490 392 389 389
query90 1942 193 186 186
query91 129 98 102 98
query92 57 49 48 48
query93 6304 518 504 504
query94 1286 211 243 211
query95 402 308 310 308
query96 615 275 274 274
query97 3214 3055 3032 3032
query98 218 195 199 195
query99 1549 1254 1283 1254
Total cold run time: 289722 ms
Total hot run time: 176216 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2222023613
<details>
<summary>ClickBench: <b>Total hot run time: 30.7 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 bc34db22a1d38074beacfa9870a10401e3428b05, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.04
query3 0.23 0.05 0.05
query4 1.68 0.08 0.08
query5 0.50 0.50 0.48
query6 1.14 0.73 0.73
query7 0.02 0.02 0.01
query8 0.05 0.05 0.05
query9 0.55 0.47 0.48
query10 0.54 0.55 0.54
query11 0.15 0.11 0.11
query12 0.14 0.12 0.12
query13 0.60 0.58 0.59
query14 0.77 0.77 0.81
query15 0.84 0.80 0.80
query16 0.34 0.36 0.35
query17 0.99 0.97 1.02
query18 0.22 0.22 0.22
query19 1.76 1.72 1.69
query20 0.02 0.01 0.01
query21 15.39 0.77 0.66
query22 3.64 7.86 1.94
query23 18.22 1.36 1.28
query24 2.09 0.24 0.23
query25 0.15 0.09 0.09
query26 0.30 0.21 0.21
query27 0.45 0.23 0.23
query28 13.22 1.02 1.00
query29 12.62 3.30 3.30
query30 0.25 0.06 0.06
query31 2.85 0.40 0.38
query32 3.27 0.47 0.46
query33 2.89 2.90 2.96
query34 17.04 4.36 4.36
query35 4.45 4.47 4.46
query36 0.65 0.47 0.46
query37 0.18 0.15 0.16
query38 0.15 0.15 0.15
query39 0.04 0.04 0.04
query40 0.14 0.12 0.12
query41 0.09 0.04 0.05
query42 0.06 0.04 0.05
query43 0.05 0.04 0.04
Total cold run time: 108.85 s
Total hot run time: 30.7 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2209187506
<details>
<summary>TPC-H: <b>Total hot run time: 39885 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 a3fe2c75cf58d17c15221d8685807c0e747a9fdc, data reload: false
------ Round 1 ----------------------------------
q1 17624 4761 4274 4274
q2 2025 198 200 198
q3 10501 1206 1009 1009
q4 10194 820 679 679
q5 7685 2610 2589 2589
q6 221 141 161 141
q7 969 610 616 610
q8 9259 2083 2056 2056
q9 8869 6989 6936 6936
q10 8914 3662 3678 3662
q11 443 236 238 236
q12 481 234 235 234
q13 17744 2936 2927 2927
q14 258 218 218 218
q15 520 478 481 478
q16 497 399 376 376
q17 947 730 608 608
q18 8064 7394 7286 7286
q19 5073 1538 1559 1538
q20 653 307 301 301
q21 4868 3182 3903 3182
q22 398 347 350 347
Total cold run time: 116207 ms
Total hot run time: 39885 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4326 4269 4201 4201
q2 386 270 280 270
q3 3029 2741 2730 2730
q4 1858 1572 1589 1572
q5 5233 5255 5229 5229
q6 216 134 133 133
q7 2084 1758 1787 1758
q8 3221 3351 3298 3298
q9 8811 8738 8861 8738
q10 3859 3673 3638 3638
q11 602 496 475 475
q12 825 613 591 591
q13 17457 2967 2983 2967
q14 300 267 261 261
q15 524 479 483 479
q16 462 403 415 403
q17 1760 1464 1450 1450
q18 7631 7652 7483 7483
q19 1725 1478 1563 1478
q20 2103 1935 1930 1930
q21 4840 4782 4686 4686
q22 662 599 561 561
Total cold run time: 71914 ms
Total hot run time: 54331 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2214213389
<details>
<summary>TPC-H: <b>Total hot run time: 40403 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 02f946f997525a2811978c81d9b016685981aca5, data reload: false
------ Round 1 ----------------------------------
q1 18081 4482 4379 4379
q2 2778 203 198 198
q3 10937 1281 1120 1120
q4 10793 786 732 732
q5 7806 2701 2692 2692
q6 226 138 137 137
q7 981 621 619 619
q8 9350 2078 2050 2050
q9 9145 7020 7002 7002
q10 9028 3739 3699 3699
q11 456 235 242 235
q12 417 237 236 236
q13 17767 2975 2999 2975
q14 273 232 221 221
q15 519 489 505 489
q16 505 396 378 378
q17 986 603 651 603
q18 8118 7529 7470 7470
q19 7280 1563 1442 1442
q20 664 329 305 305
q21 4945 3192 3085 3085
q22 396 348 336 336
Total cold run time: 121451 ms
Total hot run time: 40403 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4363 4253 4244 4244
q2 390 287 271 271
q3 2993 2782 2705 2705
q4 1841 1600 1578 1578
q5 5217 5227 5241 5227
q6 225 129 131 129
q7 2133 1730 1768 1730
q8 3167 3312 3341 3312
q9 8676 8773 8853 8773
q10 3876 3666 3633 3633
q11 600 480 493 480
q12 784 602 600 600
q13 16369 2961 2986 2961
q14 304 264 264 264
q15 522 478 473 473
q16 458 417 424 417
q17 1773 1469 1485 1469
q18 7666 7424 7323 7323
q19 1685 1689 1606 1606
q20 2111 1919 1888 1888
q21 5029 4844 4943 4844
q22 627 584 584 584
Total cold run time: 70809 ms
Total hot run time: 54511 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2220165685
<details>
<summary>TPC-H: <b>Total hot run time: 40418 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 7bb9003a5fa356f5eec1a4d2a31f148e5d0d0a4f, data reload: false
------ Round 1 ----------------------------------
q1 17996 4437 4333 4333
q2 2317 191 187 187
q3 10463 1223 1145 1145
q4 10194 729 742 729
q5 7551 2636 2554 2554
q6 216 136 141 136
q7 952 605 599 599
q8 9228 2058 2047 2047
q9 9054 6952 6904 6904
q10 8951 3685 3717 3685
q11 477 247 248 247
q12 401 233 232 232
q13 17766 3023 2990 2990
q14 266 227 220 220
q15 544 492 487 487
q16 502 384 372 372
q17 958 721 770 721
q18 8055 7529 7490 7490
q19 7648 1525 1557 1525
q20 632 314 319 314
q21 4935 3159 3305 3159
q22 393 346 342 342
Total cold run time: 119499 ms
Total hot run time: 40418 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4380 4191 4277 4191
q2 395 282 280 280
q3 3016 2779 2745 2745
q4 1847 1633 1591 1591
q5 5233 5252 5242 5242
q6 213 133 134 133
q7 2087 1785 1754 1754
q8 3195 3346 3287 3287
q9 8733 8821 8844 8821
q10 3893 3655 3702 3655
q11 572 488 493 488
q12 789 650 609 609
q13 17206 3002 2978 2978
q14 297 267 256 256
q15 523 480 481 480
q16 459 412 431 412
q17 1755 1463 1449 1449
q18 7536 7565 7402 7402
q19 1680 1601 1511 1511
q20 2120 1926 1913 1913
q21 4817 4859 4717 4717
q22 642 575 592 575
Total cold run time: 71388 ms
Total hot run time: 54489 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2216833079
<details>
<summary>TPC-H: <b>Total hot run time: 40730 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 69faef1bcbfe3387c5ae4028139c2f9bd1acddf2, data reload: false
------ Round 1 ----------------------------------
q1 17876 4394 4373 4373
q2 2531 196 188 188
q3 11540 1240 1205 1205
q4 10637 771 794 771
q5 9774 2631 2654 2631
q6 218 134 136 134
q7 950 603 607 603
q8 9227 2095 2115 2095
q9 9193 6974 6987 6974
q10 8934 3691 3720 3691
q11 467 234 238 234
q12 394 230 225 225
q13 17743 2997 2961 2961
q14 264 236 227 227
q15 524 491 487 487
q16 503 375 376 375
q17 958 680 703 680
q18 8098 7519 7552 7519
q19 1702 1481 1507 1481
q20 624 321 322 321
q21 5082 3207 3928 3207
q22 406 348 350 348
Total cold run time: 117645 ms
Total hot run time: 40730 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4340 4254 4235 4235
q2 376 273 274 273
q3 3009 2802 2799 2799
q4 1844 1579 1623 1579
q5 5224 5247 5215 5215
q6 219 129 129 129
q7 2119 1706 1758 1706
q8 3168 3347 3318 3318
q9 8846 8845 8850 8845
q10 3893 3594 3618 3594
q11 590 469 507 469
q12 783 621 603 603
q13 16335 2966 2960 2960
q14 293 276 250 250
q15 520 483 464 464
q16 470 405 411 405
q17 1747 1454 1456 1454
q18 7640 7529 7427 7427
q19 1682 1565 1517 1517
q20 2129 1924 1926 1924
q21 4894 4727 4766 4727
q22 648 579 582 579
Total cold run time: 70769 ms
Total hot run time: 54472 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2236163499
<details>
<summary>TPC-H: <b>Total hot run time: 40171 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 d7ee26d860c265f3b6b320d591a8108ff33692fa, data reload: false
------ Round 1 ----------------------------------
q1 17699 4573 4318 4318
q2 2034 195 194 194
q3 10519 1214 1156 1156
q4 10214 814 713 713
q5 7540 2755 2722 2722
q6 225 138 140 138
q7 962 597 599 597
q8 9220 2104 2086 2086
q9 8785 6564 6565 6564
q10 8809 3813 3776 3776
q11 457 240 241 240
q12 387 224 222 222
q13 17752 3019 3013 3013
q14 280 234 236 234
q15 519 484 480 480
q16 515 383 382 382
q17 987 684 668 668
q18 8221 7523 7486 7486
q19 6738 1431 1398 1398
q20 714 333 344 333
q21 5064 3158 3282 3158
q22 356 296 293 293
Total cold run time: 117997 ms
Total hot run time: 40171 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4419 4292 4249 4249
q2 366 269 265 265
q3 3038 2913 2981 2913
q4 2021 1785 1724 1724
q5 5553 5578 5475 5475
q6 219 133 137 133
q7 2319 1857 1876 1857
q8 3320 3475 3424 3424
q9 8819 8975 8829 8829
q10 4144 3768 3894 3768
q11 594 516 510 510
q12 836 659 656 656
q13 17127 3131 3166 3131
q14 317 291 299 291
q15 530 502 495 495
q16 473 445 438 438
q17 1818 1531 1495 1495
q18 8283 8276 7783 7783
q19 1731 1563 1634 1563
q20 2127 1890 1858 1858
q21 6331 4701 5059 4701
q22 590 525 527 525
Total cold run time: 74975 ms
Total hot run time: 56083 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2236532789
<details>
<summary>TPC-DS: <b>Total hot run time: 174589 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 a6176d993f8781ee162a1a9c8336154e46724ff6, data reload: false
query1 926 374 368 368
query2 6451 1918 1905 1905
query3 6630 210 211 210
query4 24901 17523 17436 17436
query5 3633 471 488 471
query6 272 174 160 160
query7 4583 290 286 286
query8 247 197 196 196
query9 8635 2517 2490 2490
query10 452 302 267 267
query11 11675 10176 10207 10176
query12 115 83 82 82
query13 1637 365 355 355
query14 10132 7711 7574 7574
query15 225 170 166 166
query16 7727 322 307 307
query17 1800 560 547 547
query18 1968 280 279 279
query19 189 143 146 143
query20 90 81 80 80
query21 204 132 130 130
query22 4429 4052 4001 4001
query23 34299 34215 33693 33693
query24 10549 2960 2976 2960
query25 606 421 436 421
query26 716 164 157 157
query27 2276 279 281 279
query28 6103 2133 2119 2119
query29 902 630 645 630
query30 252 150 157 150
query31 984 770 799 770
query32 94 57 57 57
query33 663 287 306 287
query34 900 505 518 505
query35 696 619 585 585
query36 1138 984 955 955
query37 140 83 80 80
query38 3014 2939 2873 2873
query39 870 823 820 820
query40 197 121 122 121
query41 47 44 45 44
query42 117 101 95 95
query43 518 466 475 466
query44 1078 740 731 731
query45 189 164 157 157
query46 1084 729 738 729
query47 1915 1803 1829 1803
query48 368 288 296 288
query49 836 411 410 410
query50 775 388 389 388
query51 6819 6805 6689 6689
query52 104 95 93 93
query53 352 286 285 285
query54 853 452 453 452
query55 74 71 73 71
query56 288 260 276 260
query57 1135 1057 1079 1057
query58 232 248 256 248
query59 2881 2753 2617 2617
query60 302 275 279 275
query61 108 94 92 92
query62 821 657 643 643
query63 314 280 282 280
query64 9121 2202 1661 1661
query65 3138 3091 3087 3087
query66 738 336 327 327
query67 15391 15038 15218 15038
query68 4543 557 550 550
query69 520 414 328 328
query70 1148 1148 1139 1139
query71 368 285 285 285
query72 7008 5689 5550 5550
query73 741 329 327 327
query74 6178 5756 5715 5715
query75 3405 2694 2726 2694
query76 2140 960 914 914
query77 476 301 306 301
query78 9662 9103 9326 9103
query79 2274 528 522 522
query80 2270 475 476 475
query81 597 223 222 222
query82 1024 134 137 134
query83 293 172 165 165
query84 264 90 90 90
query85 1206 320 303 303
query86 465 313 285 285
query87 3365 3120 3174 3120
query88 3135 2461 2444 2444
query89 474 388 373 373
query90 1744 192 193 192
query91 130 100 186 100
query92 58 49 47 47
query93 2177 518 513 513
query94 1185 221 216 216
query95 403 328 321 321
query96 602 277 275 275
query97 3212 3058 3079 3058
query98 220 195 192 192
query99 1500 1259 1263 1259
Total cold run time: 273705 ms
Total hot run time: 174589 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2205679252
<details>
<summary>ClickBench: <b>Total hot run time: 30.7 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 4f13a9e0b78bf6f4c687931b863d8afe6f99cb91, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.05
query3 0.23 0.05 0.05
query4 1.67 0.10 0.09
query5 0.49 0.49 0.48
query6 1.16 0.72 0.73
query7 0.02 0.02 0.01
query8 0.05 0.04 0.05
query9 0.56 0.49 0.48
query10 0.55 0.55 0.54
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.59 0.59 0.60
query14 0.78 0.80 0.77
query15 0.85 0.81 0.83
query16 0.36 0.37 0.34
query17 0.95 0.96 1.00
query18 0.24 0.23 0.26
query19 1.79 1.74 1.68
query20 0.01 0.01 0.01
query21 15.43 0.78 0.67
query22 4.47 7.27 2.02
query23 18.26 1.44 1.28
query24 2.08 0.24 0.25
query25 0.15 0.08 0.08
query26 0.27 0.17 0.17
query27 0.08 0.08 0.09
query28 13.22 1.03 1.03
query29 12.60 3.35 3.35
query30 0.26 0.06 0.06
query31 2.86 0.39 0.39
query32 3.27 0.49 0.47
query33 2.91 2.94 2.88
query34 17.12 4.39 4.41
query35 4.52 4.52 4.42
query36 0.64 0.48 0.49
query37 0.20 0.17 0.16
query38 0.16 0.15 0.16
query39 0.05 0.03 0.03
query40 0.18 0.14 0.14
query41 0.09 0.04 0.05
query42 0.06 0.04 0.04
query43 0.04 0.03 0.04
Total cold run time: 109.65 s
Total hot run time: 30.7 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2220122050
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213674973
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2219514817
<details>
<summary>TPC-H: <b>Total hot run time: 40823 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 ab3ecd0af0335b7b3fe9368368f0174328232f33, data reload: false
------ Round 1 ----------------------------------
q1 17614 4472 4268 4268
q2 2019 191 201 191
q3 10426 1199 1137 1137
q4 10189 882 835 835
q5 7573 2715 2580 2580
q6 223 139 139 139
q7 967 593 604 593
q8 9230 2131 2100 2100
q9 9153 7066 7061 7061
q10 9030 3724 3749 3724
q11 458 244 236 236
q12 425 232 221 221
q13 18642 2986 2998 2986
q14 267 239 225 225
q15 535 487 513 487
q16 520 389 383 383
q17 990 709 760 709
q18 8050 7667 7580 7580
q19 7985 1473 1543 1473
q20 713 311 317 311
q21 4819 3312 3240 3240
q22 399 344 344 344
Total cold run time: 120227 ms
Total hot run time: 40823 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4375 4246 4239 4239
q2 387 278 271 271
q3 3007 2799 2751 2751
q4 1846 1595 1572 1572
q5 5262 5234 5270 5234
q6 221 129 132 129
q7 2178 1819 1775 1775
q8 3206 3364 3323 3323
q9 8862 8844 8754 8754
q10 3871 3777 3642 3642
q11 576 475 489 475
q12 805 655 591 591
q13 16575 3028 2941 2941
q14 291 275 263 263
q15 523 474 479 474
q16 477 398 414 398
q17 1794 1486 1464 1464
q18 7675 7571 7532 7532
q19 1770 1595 1532 1532
q20 2209 1926 1910 1910
q21 4911 4927 4750 4750
q22 665 588 573 573
Total cold run time: 71486 ms
Total hot run time: 54593 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233262044
<details>
<summary>ClickBench: <b>Total hot run time: 30.43 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 b31626e7b70e491725adbebdc744075fe3e1e569, data reload: false
query1 0.03 0.03 0.03
query2 0.08 0.04 0.05
query3 0.23 0.05 0.04
query4 1.68 0.07 0.07
query5 0.48 0.49 0.49
query6 1.14 0.73 0.71
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.56 0.49 0.50
query10 0.55 0.54 0.55
query11 0.15 0.11 0.12
query12 0.15 0.12 0.12
query13 0.60 0.58 0.58
query14 0.76 0.77 0.78
query15 0.84 0.82 0.82
query16 0.36 0.36 0.37
query17 0.96 0.96 1.03
query18 0.22 0.22 0.21
query19 1.76 1.75 1.64
query20 0.01 0.01 0.01
query21 15.41 0.73 0.66
query22 4.28 6.89 1.70
query23 18.29 1.41 1.30
query24 2.10 0.22 0.21
query25 0.16 0.08 0.09
query26 0.29 0.21 0.21
query27 0.45 0.23 0.23
query28 13.42 1.02 1.00
query29 12.65 3.33 3.33
query30 0.25 0.06 0.06
query31 2.88 0.40 0.38
query32 3.24 0.48 0.47
query33 2.91 2.93 2.90
query34 17.23 4.36 4.39
query35 4.42 4.45 4.50
query36 0.65 0.47 0.47
query37 0.19 0.15 0.16
query38 0.15 0.15 0.15
query39 0.05 0.03 0.04
query40 0.15 0.12 0.12
query41 0.10 0.05 0.05
query42 0.06 0.05 0.05
query43 0.05 0.04 0.03
Total cold run time: 110.01 s
Total hot run time: 30.43 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233158248
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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2236183172
<details>
<summary>TPC-DS: <b>Total hot run time: 175497 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 d7ee26d860c265f3b6b320d591a8108ff33692fa, data reload: false
query1 916 370 368 368
query2 6375 1908 1915 1908
query3 6662 204 213 204
query4 28551 17722 17550 17550
query5 3677 491 484 484
query6 266 174 167 167
query7 4589 293 289 289
query8 238 206 189 189
query9 8641 2521 2482 2482
query10 430 281 266 266
query11 12108 10244 10145 10145
query12 119 84 89 84
query13 1637 364 364 364
query14 9282 7709 7631 7631
query15 210 168 171 168
query16 7558 319 315 315
query17 1362 532 524 524
query18 1904 282 287 282
query19 211 141 148 141
query20 87 82 79 79
query21 203 122 124 122
query22 4528 4206 4180 4180
query23 34056 33745 33769 33745
query24 11424 2921 2926 2921
query25 614 393 402 393
query26 780 150 148 148
query27 2277 277 276 276
query28 6098 2118 2138 2118
query29 873 636 659 636
query30 257 155 167 155
query31 993 775 788 775
query32 100 52 53 52
query33 762 300 292 292
query34 1025 487 509 487
query35 680 603 590 590
query36 1105 982 983 982
query37 152 85 87 85
query38 2951 2888 2828 2828
query39 877 861 856 856
query40 209 124 119 119
query41 47 45 51 45
query42 115 102 94 94
query43 508 488 462 462
query44 1265 732 735 732
query45 204 164 162 162
query46 1103 745 724 724
query47 1897 1778 1812 1778
query48 368 295 312 295
query49 852 427 458 427
query50 779 391 388 388
query51 6893 6826 6677 6677
query52 101 94 97 94
query53 366 292 283 283
query54 880 448 450 448
query55 77 72 71 71
query56 276 271 280 271
query57 1142 1061 1060 1060
query58 243 289 274 274
query59 2919 2727 2801 2727
query60 312 273 286 273
query61 97 91 97 91
query62 798 645 633 633
query63 321 284 284 284
query64 9177 2274 7454 2274
query65 3144 3092 3113 3092
query66 709 330 338 330
query67 15719 15069 15012 15012
query68 5627 554 565 554
query69 672 419 347 347
query70 1214 1140 1147 1140
query71 440 278 280 278
query72 8068 5917 5700 5700
query73 774 331 327 327
query74 6037 5722 5685 5685
query75 3455 2700 2711 2700
query76 3155 992 892 892
query77 631 312 303 303
query78 10008 8985 8923 8923
query79 3552 524 523 523
query80 2183 484 477 477
query81 577 227 217 217
query82 1346 143 149 143
query83 276 160 168 160
query84 276 94 83 83
query85 1256 426 297 297
query86 448 322 273 273
query87 3275 3108 3083 3083
query88 4457 2489 2465 2465
query89 482 385 383 383
query90 1735 192 192 192
query91 125 100 104 100
query92 55 48 52 48
query93 4806 522 518 518
query94 1069 213 220 213
query95 399 322 323 322
query96 606 280 277 277
query97 3190 3029 3038 3029
query98 212 202 192 192
query99 1538 1277 1252 1252
Total cold run time: 287043 ms
Total hot run time: 175497 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2209216547
<details>
<summary>ClickBench: <b>Total hot run time: 30.54 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 a3fe2c75cf58d17c15221d8685807c0e747a9fdc, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.04 0.04
query3 0.22 0.05 0.05
query4 1.67 0.09 0.08
query5 0.52 0.49 0.48
query6 1.13 0.73 0.72
query7 0.03 0.01 0.01
query8 0.05 0.04 0.05
query9 0.55 0.49 0.48
query10 0.54 0.54 0.54
query11 0.15 0.12 0.11
query12 0.15 0.13 0.13
query13 0.59 0.58 0.58
query14 0.77 0.76 0.80
query15 0.84 0.83 0.81
query16 0.37 0.37 0.35
query17 0.94 0.94 0.98
query18 0.21 0.26 0.24
query19 1.79 1.71 1.68
query20 0.01 0.00 0.01
query21 15.43 0.74 0.66
query22 4.21 7.01 1.99
query23 18.31 1.37 1.20
query24 2.17 0.22 0.22
query25 0.16 0.09 0.08
query26 0.29 0.20 0.21
query27 0.46 0.24 0.24
query28 13.20 1.00 1.00
query29 12.60 3.31 3.32
query30 0.25 0.06 0.05
query31 2.86 0.38 0.38
query32 3.26 0.49 0.47
query33 2.87 2.91 2.92
query34 17.12 4.34 4.34
query35 4.41 4.38 4.39
query36 0.66 0.47 0.51
query37 0.18 0.16 0.15
query38 0.15 0.14 0.14
query39 0.04 0.03 0.04
query40 0.15 0.12 0.12
query41 0.09 0.05 0.05
query42 0.06 0.04 0.05
query43 0.04 0.04 0.04
Total cold run time: 109.61 s
Total hot run time: 30.54 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233250792
<details>
<summary>TPC-DS: <b>Total hot run time: 173573 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 b31626e7b70e491725adbebdc744075fe3e1e569, data reload: false
query1 919 374 357 357
query2 6599 1793 1826 1793
query3 6650 215 225 215
query4 28285 17592 17238 17238
query5 3676 492 448 448
query6 265 170 160 160
query7 4579 294 282 282
query8 233 191 184 184
query9 8488 2370 2366 2366
query10 436 282 281 281
query11 11299 9950 10087 9950
query12 118 88 84 84
query13 1653 369 373 369
query14 10062 7730 7955 7730
query15 226 168 173 168
query16 7742 321 320 320
query17 1530 584 532 532
query18 1981 285 279 279
query19 206 154 156 154
query20 95 83 87 83
query21 203 131 124 124
query22 4585 4114 3942 3942
query23 34718 33615 33603 33603
query24 10884 2876 2943 2876
query25 577 389 383 383
query26 702 149 148 148
query27 2260 279 279 279
query28 5604 2031 2054 2031
query29 897 632 639 632
query30 256 151 150 150
query31 979 763 760 760
query32 96 53 54 53
query33 654 306 280 280
query34 909 490 504 490
query35 677 599 576 576
query36 1118 924 972 924
query37 143 91 87 87
query38 2903 2875 2824 2824
query39 913 840 867 840
query40 206 146 121 121
query41 47 44 52 44
query42 116 104 99 99
query43 511 455 466 455
query44 1093 712 727 712
query45 194 160 161 160
query46 1092 745 729 729
query47 1844 1749 1754 1749
query48 367 288 285 285
query49 820 402 414 402
query50 783 394 382 382
query51 6860 6854 6693 6693
query52 106 99 87 87
query53 354 289 287 287
query54 876 461 445 445
query55 74 74 76 74
query56 282 260 266 260
query57 1157 1061 1036 1036
query58 265 251 257 251
query59 2910 2617 2768 2617
query60 326 278 280 278
query61 94 94 94 94
query62 754 630 634 630
query63 326 284 289 284
query64 9143 2229 7452 2229
query65 3153 3107 3100 3100
query66 709 329 327 327
query67 15607 15134 15112 15112
query68 4470 552 549 549
query69 505 339 335 335
query70 1123 1149 1159 1149
query71 363 317 276 276
query72 7131 5358 5566 5358
query73 742 324 324 324
query74 6109 5660 5660 5660
query75 3386 2675 2674 2674
query76 2118 935 942 935
query77 473 305 296 296
query78 11084 9073 8983 8983
query79 3110 509 516 509
query80 2620 475 467 467
query81 593 219 225 219
query82 782 138 141 138
query83 296 169 173 169
query84 279 100 82 82
query85 1762 315 351 315
query86 470 292 310 292
query87 3247 3093 3099 3093
query88 4378 2354 2337 2337
query89 479 375 374 374
query90 1777 188 189 188
query91 132 98 107 98
query92 60 49 50 49
query93 3871 501 498 498
query94 1075 212 211 211
query95 410 331 314 314
query96 600 280 269 269
query97 3236 3044 3039 3039
query98 220 207 190 190
query99 1578 1257 1246 1246
Total cold run time: 282668 ms
Total hot run time: 173573 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2238072349
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2219529809
<details>
<summary>ClickBench: <b>Total hot run time: 30.66 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 ab3ecd0af0335b7b3fe9368368f0174328232f33, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.68 0.06 0.07
query5 0.52 0.48 0.48
query6 1.14 0.73 0.72
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.55 0.49 0.49
query10 0.56 0.54 0.54
query11 0.15 0.11 0.11
query12 0.14 0.12 0.12
query13 0.60 0.58 0.58
query14 0.77 0.77 0.76
query15 0.85 0.81 0.81
query16 0.36 0.37 0.37
query17 0.98 0.99 0.98
query18 0.23 0.23 0.23
query19 1.82 1.76 1.81
query20 0.01 0.01 0.01
query21 15.39 0.76 0.69
query22 4.30 7.66 1.95
query23 18.24 1.40 1.27
query24 2.20 0.24 0.22
query25 0.16 0.08 0.08
query26 0.29 0.21 0.21
query27 0.45 0.23 0.23
query28 13.29 1.03 1.00
query29 12.67 3.31 3.28
query30 0.25 0.06 0.05
query31 2.86 0.39 0.39
query32 3.27 0.49 0.47
query33 2.90 2.89 2.93
query34 17.03 4.42 4.30
query35 4.46 4.39 4.40
query36 0.65 0.47 0.50
query37 0.19 0.15 0.15
query38 0.15 0.15 0.15
query39 0.05 0.04 0.03
query40 0.15 0.12 0.12
query41 0.09 0.05 0.05
query42 0.06 0.05 0.05
query43 0.05 0.04 0.03
Total cold run time: 109.92 s
Total hot run time: 30.66 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2214257565
<details>
<summary>ClickBench: <b>Total hot run time: 31.24 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 02f946f997525a2811978c81d9b016685981aca5, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.03 0.04
query3 0.23 0.05 0.06
query4 1.65 0.07 0.07
query5 0.49 0.47 0.50
query6 1.14 0.73 0.73
query7 0.03 0.02 0.01
query8 0.06 0.05 0.05
query9 0.54 0.48 0.49
query10 0.54 0.54 0.55
query11 0.16 0.11 0.12
query12 0.15 0.12 0.13
query13 0.59 0.58 0.57
query14 0.77 0.78 0.77
query15 0.84 0.82 0.82
query16 0.36 0.37 0.37
query17 0.99 0.95 0.99
query18 0.22 0.22 0.21
query19 1.89 1.66 1.72
query20 0.01 0.01 0.02
query21 15.41 0.74 0.64
query22 3.95 7.17 2.67
query23 18.29 1.47 1.32
query24 2.09 0.21 0.22
query25 0.15 0.09 0.09
query26 0.30 0.21 0.21
query27 0.45 0.22 0.23
query28 13.30 1.02 0.99
query29 12.66 3.24 3.26
query30 0.24 0.06 0.06
query31 2.85 0.37 0.39
query32 3.30 0.47 0.47
query33 2.84 2.94 2.92
query34 16.89 4.30 4.33
query35 4.39 4.42 4.42
query36 0.65 0.49 0.49
query37 0.18 0.15 0.16
query38 0.16 0.14 0.15
query39 0.04 0.03 0.04
query40 0.15 0.13 0.12
query41 0.09 0.05 0.04
query42 0.06 0.05 0.05
query43 0.05 0.04 0.05
Total cold run time: 109.26 s
Total hot run time: 31.24 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2210319749
<details>
<summary>TPC-H: <b>Total hot run time: 40637 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 a2b6bdc87e867fbb7b9b0575bba803b8acd8e464, data reload: false
------ Round 1 ----------------------------------
q1 17873 4498 4436 4436
q2 2668 204 198 198
q3 12242 1156 1178 1156
q4 10698 777 733 733
q5 8067 2708 2652 2652
q6 229 141 142 141
q7 950 601 621 601
q8 9224 2089 2139 2089
q9 9191 7025 6990 6990
q10 8939 3780 3738 3738
q11 450 246 244 244
q12 414 235 227 227
q13 17766 2951 2993 2951
q14 277 220 227 220
q15 530 492 474 474
q16 516 376 386 376
q17 981 781 765 765
q18 8006 7518 7421 7421
q19 6971 1536 1387 1387
q20 662 335 343 335
q21 5129 3150 3871 3150
q22 415 353 356 353
Total cold run time: 122198 ms
Total hot run time: 40637 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4416 4234 4287 4234
q2 375 283 275 275
q3 3005 2827 2729 2729
q4 1913 1569 1585 1569
q5 5260 5258 5259 5258
q6 223 137 138 137
q7 2152 1721 1717 1717
q8 3332 3388 3340 3340
q9 8873 8852 8871 8852
q10 3906 3715 3665 3665
q11 591 494 505 494
q12 801 604 612 604
q13 16559 2956 3002 2956
q14 284 266 279 266
q15 524 496 478 478
q16 480 411 430 411
q17 1791 1497 1475 1475
q18 7742 7482 7279 7279
q19 1718 1661 1634 1634
q20 2097 1904 1876 1876
q21 4915 4855 4696 4696
q22 668 568 570 568
Total cold run time: 71625 ms
Total hot run time: 54513 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2217838215
<details>
<summary>TPC-H: <b>Total hot run time: 40524 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 a98798cffdad6d3c0fc479a06e5f93d559b6707c, data reload: false
------ Round 1 ----------------------------------
q1 17620 4291 4280 4280
q2 2018 191 184 184
q3 10457 1229 1002 1002
q4 10204 987 751 751
q5 7752 2639 2526 2526
q6 230 141 140 140
q7 952 597 619 597
q8 9224 2084 2066 2066
q9 9083 7004 6918 6918
q10 9049 3759 3712 3712
q11 459 245 241 241
q12 451 245 233 233
q13 17962 3004 3099 3004
q14 271 220 224 220
q15 539 486 483 483
q16 500 397 373 373
q17 955 703 677 677
q18 8066 7726 7960 7726
q19 10776 1600 1477 1477
q20 653 325 322 322
q21 5021 3917 3252 3252
q22 404 340 350 340
Total cold run time: 122646 ms
Total hot run time: 40524 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4434 4320 4419 4320
q2 388 304 297 297
q3 3223 2921 3038 2921
q4 1928 1702 1745 1702
q5 5447 5437 5557 5437
q6 237 137 136 136
q7 2173 1914 1828 1828
q8 3261 3390 3383 3383
q9 9317 9280 9178 9178
q10 4118 3827 3789 3789
q11 606 502 497 497
q12 821 641 629 629
q13 16475 3189 3211 3189
q14 289 263 270 263
q15 539 482 492 482
q16 476 424 436 424
q17 1835 1615 1508 1508
q18 8168 8026 7655 7655
q19 1796 1661 1631 1631
q20 2322 2034 1912 1912
q21 7134 4889 4925 4889
q22 704 570 564 564
Total cold run time: 75691 ms
Total hot run time: 56634 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2216776271
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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2235841239
<details>
<summary>TPC-DS: <b>Total hot run time: 173310 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 05684013b5e2bce47815518ae03396a426c435f4, data reload: false
query1 914 378 370 370
query2 6449 1990 1855 1855
query3 6636 210 220 210
query4 28494 17295 17136 17136
query5 3670 497 499 497
query6 279 187 177 177
query7 4599 304 310 304
query8 238 205 197 197
query9 8580 2505 2475 2475
query10 455 315 260 260
query11 10933 10132 10001 10001
query12 114 85 82 82
query13 1629 363 364 363
query14 10211 7697 7534 7534
query15 210 169 167 167
query16 7723 321 312 312
query17 1786 553 527 527
query18 1965 283 270 270
query19 201 150 146 146
query20 110 79 86 79
query21 200 126 124 124
query22 4477 4115 3944 3944
query23 34153 33803 33629 33629
query24 10567 2874 2936 2874
query25 610 388 408 388
query26 708 155 152 152
query27 2261 281 281 281
query28 5827 2116 2129 2116
query29 907 628 645 628
query30 264 155 153 153
query31 979 773 774 773
query32 93 54 55 54
query33 659 301 317 301
query34 895 509 533 509
query35 691 579 609 579
query36 1128 979 992 979
query37 182 85 88 85
query38 2900 2839 2870 2839
query39 906 841 842 841
query40 213 123 127 123
query41 45 43 45 43
query42 114 97 98 97
query43 511 472 474 472
query44 1081 745 721 721
query45 197 158 161 158
query46 1087 731 731 731
query47 1838 1755 1789 1755
query48 372 305 301 301
query49 847 401 412 401
query50 810 407 409 407
query51 6904 6867 6634 6634
query52 101 96 99 96
query53 369 292 291 291
query54 874 453 450 450
query55 76 75 74 74
query56 288 263 269 263
query57 1160 1042 1104 1042
query58 252 244 246 244
query59 2937 2669 2808 2669
query60 302 272 286 272
query61 94 93 93 93
query62 797 647 643 643
query63 320 285 284 284
query64 9131 2263 1681 1681
query65 3318 3083 3065 3065
query66 760 338 345 338
query67 15407 14981 14951 14951
query68 4510 556 556 556
query69 563 384 365 365
query70 1169 1104 1116 1104
query71 380 290 296 290
query72 7346 5675 5301 5301
query73 756 337 330 330
query74 6118 5709 5670 5670
query75 3400 2708 2700 2700
query76 2174 939 939 939
query77 463 312 310 310
query78 9688 8968 8916 8916
query79 2378 538 524 524
query80 2191 490 477 477
query81 610 227 226 226
query82 906 137 129 129
query83 283 167 164 164
query84 257 89 89 89
query85 1905 326 294 294
query86 462 326 318 318
query87 3261 3087 3115 3087
query88 4215 2467 2475 2467
query89 467 394 378 378
query90 1721 202 198 198
query91 128 100 99 99
query92 64 51 51 51
query93 3250 528 521 521
query94 1108 223 224 223
query95 414 331 326 326
query96 603 280 275 275
query97 3271 3071 3021 3021
query98 223 207 199 199
query99 1487 1253 1291 1253
Total cold run time: 279579 ms
Total hot run time: 173310 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2216853440
<details>
<summary>TPC-DS: <b>Total hot run time: 172840 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 69faef1bcbfe3387c5ae4028139c2f9bd1acddf2, data reload: false
query1 919 368 356 356
query2 6454 2432 2328 2328
query3 6676 205 223 205
query4 28519 17400 17281 17281
query5 4225 472 461 461
query6 260 185 157 157
query7 4575 292 289 289
query8 308 302 296 296
query9 8427 2409 2411 2409
query10 444 289 273 273
query11 11836 9957 10046 9957
query12 135 90 82 82
query13 1647 371 366 366
query14 10307 7884 7661 7661
query15 238 190 198 190
query16 7848 330 328 328
query17 1748 578 544 544
query18 1903 289 282 282
query19 204 154 154 154
query20 92 83 83 83
query21 209 133 169 133
query22 4384 4063 3920 3920
query23 33669 32945 32798 32798
query24 12177 3036 2992 2992
query25 636 358 351 351
query26 1634 154 151 151
query27 2769 258 267 258
query28 7426 2078 2071 2071
query29 1015 647 613 613
query30 280 141 138 138
query31 1123 817 886 817
query32 88 51 59 51
query33 758 303 294 294
query34 943 477 493 477
query35 689 572 591 572
query36 1119 945 907 907
query37 266 83 89 83
query38 2845 2731 2711 2711
query39 857 776 795 776
query40 300 120 114 114
query41 54 51 47 47
query42 111 94 95 94
query43 602 529 551 529
query44 1222 704 709 704
query45 199 177 168 168
query46 1100 748 767 748
query47 1861 1770 1781 1770
query48 358 295 302 295
query49 1196 402 404 402
query50 777 406 414 406
query51 6992 6722 6768 6722
query52 105 100 92 92
query53 359 282 284 282
query54 986 441 447 441
query55 74 72 74 72
query56 286 263 282 263
query57 1159 1051 1033 1033
query58 237 234 251 234
query59 3280 3014 3305 3014
query60 312 277 266 266
query61 96 96 96 96
query62 805 628 626 626
query63 332 286 283 283
query64 10466 2211 1662 1662
query65 3189 3144 3143 3143
query66 1371 332 329 329
query67 15251 14950 14938 14938
query68 4652 548 539 539
query69 508 326 331 326
query70 1161 1152 1053 1053
query71 380 281 283 281
query72 7822 5764 5375 5375
query73 759 333 332 332
query74 5888 5533 5543 5533
query75 3433 2697 2683 2683
query76 3031 1009 950 950
query77 490 300 304 300
query78 9586 8813 8748 8748
query79 2612 511 501 501
query80 1908 468 465 465
query81 588 222 214 214
query82 959 134 133 133
query83 301 171 174 171
query84 286 84 98 84
query85 2106 294 298 294
query86 483 348 374 348
query87 3280 3070 3113 3070
query88 3561 2435 2422 2422
query89 477 378 404 378
query90 1934 189 197 189
query91 192 105 101 101
query92 60 48 47 47
query93 3429 500 503 500
query94 1346 213 211 211
query95 411 326 318 318
query96 592 278 268 268
query97 3209 2990 3002 2990
query98 221 196 205 196
query99 1569 1232 1251 1232
Total cold run time: 289966 ms
Total hot run time: 172840 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2217733018
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213373655
<details>
<summary>TPC-H: <b>Total hot run time: 40508 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 968b00fe8464ffab59ba455a2ab7a2aeffee1005, data reload: false
------ Round 1 ----------------------------------
q1 17589 4573 4322 4322
q2 2025 193 188 188
q3 10445 1267 1137 1137
q4 10199 803 874 803
q5 7524 2658 2614 2614
q6 222 138 137 137
q7 962 601 597 597
q8 9225 2100 2105 2100
q9 9182 7064 7005 7005
q10 9077 3760 3726 3726
q11 457 240 241 240
q12 444 232 241 232
q13 17763 3024 3026 3024
q14 273 222 220 220
q15 516 500 482 482
q16 509 393 390 390
q17 969 656 616 616
q18 8105 7538 7364 7364
q19 6914 1560 1501 1501
q20 674 325 294 294
q21 4868 3178 3944 3178
q22 401 345 338 338
Total cold run time: 118343 ms
Total hot run time: 40508 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4395 4257 4223 4223
q2 401 303 280 280
q3 3171 2973 3008 2973
q4 1955 1750 1718 1718
q5 5517 5465 5433 5433
q6 226 139 135 135
q7 2279 1864 1867 1864
q8 3323 3469 3432 3432
q9 9343 9422 9454 9422
q10 4010 3791 3861 3791
q11 606 506 493 493
q12 805 630 659 630
q13 16875 3251 3221 3221
q14 308 293 272 272
q15 553 482 483 482
q16 485 434 427 427
q17 1820 1549 1540 1540
q18 8090 8022 7744 7744
q19 1806 1596 1625 1596
q20 2191 2038 2022 2022
q21 5273 4761 4946 4761
q22 638 566 612 566
Total cold run time: 74070 ms
Total hot run time: 57025 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2222006940
<details>
<summary>TPC-H: <b>Total hot run time: 40325 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 bc34db22a1d38074beacfa9870a10401e3428b05, data reload: false
------ Round 1 ----------------------------------
q1 17612 4286 4253 4253
q2 2015 191 181 181
q3 10474 1222 1190 1190
q4 10190 822 731 731
q5 7562 2630 2638 2630
q6 218 137 138 137
q7 950 590 600 590
q8 9226 2081 2047 2047
q9 9078 6904 6918 6904
q10 8727 3775 3787 3775
q11 448 236 238 236
q12 399 235 233 233
q13 17760 2976 2971 2971
q14 282 237 251 237
q15 522 483 498 483
q16 506 387 372 372
q17 954 670 753 670
q18 8082 7491 7515 7491
q19 2289 1562 1440 1440
q20 624 296 308 296
q21 4971 3288 3131 3131
q22 388 347 327 327
Total cold run time: 113277 ms
Total hot run time: 40325 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4525 4281 4280 4280
q2 390 292 279 279
q3 3010 2814 2914 2814
q4 1986 1714 1677 1677
q5 5557 5545 5542 5542
q6 227 134 141 134
q7 2249 1799 1907 1799
q8 3325 3400 3346 3346
q9 9362 9254 9373 9254
q10 4099 3914 3845 3845
q11 601 480 501 480
q12 804 699 644 644
q13 16915 3177 3188 3177
q14 310 306 302 302
q15 554 505 510 505
q16 502 430 448 430
q17 1796 1500 1487 1487
q18 8183 8087 7856 7856
q19 1872 1578 1528 1528
q20 3009 2006 1984 1984
q21 7996 4755 4896 4755
q22 619 565 564 564
Total cold run time: 77891 ms
Total hot run time: 56682 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2205653933
<details>
<summary>TPC-DS: <b>Total hot run time: 177967 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 4f13a9e0b78bf6f4c687931b863d8afe6f99cb91, data reload: false
query1 926 377 365 365
query2 6430 2508 2332 2332
query3 6629 204 210 204
query4 28385 17350 17293 17293
query5 3655 470 466 466
query6 248 182 165 165
query7 4568 302 304 302
query8 310 291 299 291
query9 8610 2365 2362 2362
query10 580 305 274 274
query11 11370 10028 9855 9855
query12 118 92 82 82
query13 1652 372 374 372
query14 10291 8058 7894 7894
query15 260 195 192 192
query16 7964 281 284 281
query17 1845 576 532 532
query18 2070 286 283 283
query19 201 154 154 154
query20 92 84 83 83
query21 207 142 133 133
query22 4290 3987 4027 3987
query23 34484 33863 33686 33686
query24 11179 3155 3073 3073
query25 602 421 402 402
query26 704 173 167 167
query27 2260 324 335 324
query28 6044 2135 2098 2098
query29 902 675 641 641
query30 244 152 153 152
query31 1112 965 989 965
query32 103 58 65 58
query33 758 333 328 328
query34 912 483 499 483
query35 809 665 692 665
query36 1145 973 970 970
query37 141 75 75 75
query38 2857 2770 2736 2736
query39 3958 3883 3870 3870
query40 203 130 124 124
query41 52 51 51 51
query42 123 99 96 96
query43 579 551 573 551
query44 1320 743 735 735
query45 204 165 173 165
query46 1117 751 742 742
query47 1809 1732 1758 1732
query48 387 306 304 304
query49 841 421 425 421
query50 770 388 377 377
query51 6910 6875 6701 6701
query52 105 90 94 90
query53 362 285 283 283
query54 950 465 451 451
query55 74 75 75 75
query56 287 256 271 256
query57 1133 1022 1051 1022
query58 247 249 236 236
query59 3481 3133 3089 3089
query60 312 275 277 275
query61 94 90 94 90
query62 605 445 472 445
query63 323 293 290 290
query64 8533 2266 1790 1790
query65 3183 3117 3124 3117
query66 705 328 323 323
query67 15567 14945 15093 14945
query68 6148 557 557 557
query69 716 421 352 352
query70 1217 1153 1113 1113
query71 511 287 288 287
query72 8862 5104 5926 5104
query73 808 327 329 327
query74 6146 5485 5442 5442
query75 5202 2689 2675 2675
query76 4697 986 903 903
query77 809 305 308 305
query78 10607 9725 9789 9725
query79 7528 530 542 530
query80 1085 503 488 488
query81 578 225 224 224
query82 1266 107 102 102
query83 369 172 173 172
query84 271 87 85 85
query85 1314 338 304 304
query86 445 353 351 351
query87 3344 3115 3071 3071
query88 4724 2451 2487 2451
query89 510 393 399 393
query90 1974 196 192 192
query91 133 104 102 102
query92 66 51 51 51
query93 6061 522 520 520
query94 1219 204 193 193
query95 417 333 323 323
query96 651 276 272 272
query97 3207 3028 2969 2969
query98 226 206 194 194
query99 1110 856 819 819
Total cold run time: 301412 ms
Total hot run time: 177967 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2209143437
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213707927
<details>
<summary>TPC-H: <b>Total hot run time: 40426 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 177e8dc65f997a988ac9a67c6185a4b9cb6d02a9, data reload: false
------ Round 1 ----------------------------------
q1 17599 4278 4253 4253
q2 2012 189 182 182
q3 10922 1250 1084 1084
q4 10771 804 773 773
q5 7658 2710 2670 2670
q6 227 141 140 140
q7 981 610 612 610
q8 9483 2123 2099 2099
q9 9172 7129 7089 7089
q10 9014 3698 3696 3696
q11 446 238 236 236
q12 416 231 227 227
q13 18799 2970 2960 2960
q14 263 223 228 223
q15 528 490 489 489
q16 529 383 371 371
q17 982 663 631 631
q18 8096 7572 7509 7509
q19 2717 1346 1571 1346
q20 652 308 302 302
q21 4994 3205 3200 3200
q22 404 336 342 336
Total cold run time: 116665 ms
Total hot run time: 40426 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4368 4247 4212 4212
q2 390 278 284 278
q3 3026 2948 2891 2891
q4 1949 1713 1688 1688
q5 5484 5410 5491 5410
q6 228 132 133 132
q7 2250 1854 1866 1854
q8 3319 3439 3380 3380
q9 9006 9321 9169 9169
q10 4084 3853 3804 3804
q11 603 492 516 492
q12 806 635 630 630
q13 16608 3183 3256 3183
q14 314 274 285 274
q15 540 491 487 487
q16 492 443 434 434
q17 1827 1528 1484 1484
q18 8164 8009 7665 7665
q19 1703 1408 1536 1408
q20 2181 1999 2019 1999
q21 5020 4920 4992 4920
q22 629 590 572 572
Total cold run time: 72991 ms
Total hot run time: 56366 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2235851113
<details>
<summary>ClickBench: <b>Total hot run time: 30.55 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 05684013b5e2bce47815518ae03396a426c435f4, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.04 0.04
query3 0.22 0.05 0.05
query4 1.68 0.08 0.08
query5 0.50 0.50 0.47
query6 1.14 0.73 0.73
query7 0.02 0.01 0.01
query8 0.06 0.04 0.04
query9 0.55 0.50 0.49
query10 0.53 0.53 0.54
query11 0.15 0.12 0.12
query12 0.14 0.12 0.12
query13 0.59 0.59 0.59
query14 0.75 0.78 0.78
query15 0.86 0.82 0.81
query16 0.36 0.35 0.40
query17 0.95 1.03 0.96
query18 0.22 0.21 0.22
query19 1.78 1.79 1.82
query20 0.01 0.01 0.01
query21 15.40 0.76 0.66
query22 4.81 6.87 1.79
query23 18.29 1.33 1.22
query24 2.08 0.22 0.22
query25 0.15 0.09 0.08
query26 0.31 0.22 0.20
query27 0.45 0.24 0.23
query28 13.27 1.02 1.01
query29 12.64 3.27 3.28
query30 0.26 0.06 0.06
query31 2.86 0.38 0.39
query32 3.29 0.49 0.47
query33 2.89 2.90 2.91
query34 16.95 4.35 4.42
query35 4.40 4.43 4.44
query36 0.65 0.47 0.49
query37 0.18 0.16 0.16
query38 0.15 0.15 0.15
query39 0.04 0.04 0.03
query40 0.15 0.12 0.12
query41 0.09 0.05 0.05
query42 0.05 0.06 0.05
query43 0.05 0.04 0.04
Total cold run time: 110.03 s
Total hot run time: 30.55 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2235822364
<details>
<summary>TPC-H: <b>Total hot run time: 39767 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 05684013b5e2bce47815518ae03396a426c435f4, data reload: false
------ Round 1 ----------------------------------
q1 17616 4428 4314 4314
q2 2006 192 192 192
q3 10469 1178 1135 1135
q4 10200 761 899 761
q5 7563 2681 2686 2681
q6 219 134 135 134
q7 940 593 603 593
q8 9217 2084 2066 2066
q9 8686 6560 6539 6539
q10 8849 3778 3793 3778
q11 454 241 238 238
q12 436 224 222 222
q13 18525 2971 2975 2971
q14 271 242 236 236
q15 530 479 488 479
q16 500 396 378 378
q17 971 667 755 667
q18 8158 7330 7351 7330
q19 7892 1493 1330 1330
q20 693 324 331 324
q21 4850 3110 3943 3110
q22 356 296 289 289
Total cold run time: 119401 ms
Total hot run time: 39767 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4460 4270 4351 4270
q2 376 275 264 264
q3 3145 2901 2969 2901
q4 1956 1717 1735 1717
q5 5540 5529 5458 5458
q6 240 135 134 134
q7 2289 1847 1841 1841
q8 3270 3433 3395 3395
q9 8792 8870 8776 8776
q10 4168 3772 3908 3772
q11 592 506 513 506
q12 814 622 619 619
q13 15901 3178 3175 3175
q14 313 291 296 291
q15 523 493 475 475
q16 495 451 460 451
q17 1824 1530 1496 1496
q18 8220 7835 7879 7835
q19 1743 1609 1416 1416
q20 2154 1888 1852 1852
q21 9546 4670 4729 4670
q22 623 522 488 488
Total cold run time: 76984 ms
Total hot run time: 55802 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2206666002
<details>
<summary>ClickBench: <b>Total hot run time: 30.63 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 bf9df876fde9280d97794bf2c5998e1d07d59b67, data reload: false
query1 0.03 0.03 0.03
query2 0.08 0.03 0.03
query3 0.23 0.05 0.04
query4 1.66 0.07 0.06
query5 0.50 0.48 0.48
query6 1.14 0.73 0.74
query7 0.02 0.01 0.01
query8 0.05 0.04 0.05
query9 0.55 0.48 0.48
query10 0.55 0.53 0.55
query11 0.16 0.11 0.11
query12 0.16 0.12 0.12
query13 0.60 0.58 0.59
query14 0.78 0.77 0.78
query15 0.87 0.82 0.81
query16 0.37 0.36 0.37
query17 1.01 1.02 1.04
query18 0.23 0.24 0.26
query19 1.82 1.70 1.74
query20 0.02 0.01 0.01
query21 15.45 0.79 0.65
query22 3.83 7.19 2.08
query23 18.29 1.45 1.18
query24 2.14 0.25 0.22
query25 0.15 0.09 0.08
query26 0.27 0.17 0.17
query27 0.08 0.08 0.08
query28 13.17 1.01 0.99
query29 12.63 3.26 3.26
query30 0.26 0.06 0.06
query31 2.88 0.40 0.39
query32 3.25 0.49 0.48
query33 2.86 2.91 2.92
query34 17.12 4.45 4.41
query35 4.51 4.51 4.46
query36 0.66 0.46 0.48
query37 0.18 0.15 0.15
query38 0.15 0.15 0.15
query39 0.04 0.03 0.03
query40 0.17 0.15 0.14
query41 0.08 0.05 0.06
query42 0.05 0.05 0.04
query43 0.04 0.04 0.04
Total cold run time: 109.09 s
Total hot run time: 30.63 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2219524533
<details>
<summary>TPC-DS: <b>Total hot run time: 174087 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 ab3ecd0af0335b7b3fe9368368f0174328232f33, data reload: false
query1 924 390 368 368
query2 6464 2346 2305 2305
query3 6666 207 213 207
query4 25762 17566 17362 17362
query5 4224 496 503 496
query6 269 177 171 171
query7 4591 306 297 297
query8 317 304 293 293
query9 8419 2384 2363 2363
query10 442 278 264 264
query11 11441 9958 10057 9958
query12 135 80 80 80
query13 1630 382 375 375
query14 10265 7913 8025 7913
query15 235 193 195 193
query16 7794 303 303 303
query17 1782 543 520 520
query18 1948 289 278 278
query19 210 178 152 152
query20 92 86 89 86
query21 209 130 134 130
query22 4260 4060 4002 4002
query23 33762 33230 33123 33123
query24 11149 2993 3037 2993
query25 635 386 388 386
query26 1403 150 148 148
query27 2773 267 274 267
query28 7432 2070 2062 2062
query29 953 632 609 609
query30 263 143 142 142
query31 1126 928 909 909
query32 95 53 55 53
query33 758 303 293 293
query34 951 474 478 474
query35 688 607 599 599
query36 1107 908 944 908
query37 156 81 78 78
query38 2862 2766 2719 2719
query39 859 804 788 788
query40 271 123 122 122
query41 51 52 51 51
query42 119 98 107 98
query43 574 557 578 557
query44 1245 750 737 737
query45 205 175 173 173
query46 1120 739 779 739
query47 1871 1770 1759 1759
query48 375 313 302 302
query49 1089 410 416 410
query50 814 411 414 411
query51 6892 6845 6761 6761
query52 103 97 88 88
query53 366 314 292 292
query54 1027 461 448 448
query55 77 77 76 76
query56 304 283 320 283
query57 1146 1068 1063 1063
query58 255 236 241 236
query59 3410 3245 3131 3131
query60 299 275 273 273
query61 95 94 91 91
query62 824 655 666 655
query63 325 291 298 291
query64 10672 2261 1662 1662
query65 3207 3133 3122 3122
query66 1396 351 342 342
query67 15457 14880 14883 14880
query68 4623 571 560 560
query69 473 312 331 312
query70 1171 1155 1097 1097
query71 377 281 278 278
query72 7059 5638 5292 5292
query73 762 325 326 325
query74 5838 5480 5565 5480
query75 3416 2686 2648 2648
query76 2699 964 1044 964
query77 452 313 307 307
query78 9396 8934 8837 8837
query79 2174 522 515 515
query80 2223 512 548 512
query81 587 217 221 217
query82 794 132 135 132
query83 276 171 166 166
query84 257 90 83 83
query85 2187 297 298 297
query86 491 365 385 365
query87 3227 3110 3058 3058
query88 4252 2460 2442 2442
query89 485 396 384 384
query90 1846 191 182 182
query91 128 102 104 102
query92 62 49 49 49
query93 2622 519 513 513
query94 1253 215 211 211
query95 402 315 306 306
query96 600 272 266 266
query97 3208 3025 3003 3003
query98 222 199 190 190
query99 1611 1301 1274 1274
Total cold run time: 283813 ms
Total hot run time: 174087 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2219348605
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2210334324
<details>
<summary>TPC-DS: <b>Total hot run time: 173733 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 a2b6bdc87e867fbb7b9b0575bba803b8acd8e464, data reload: false
query1 930 375 374 374
query2 6475 2507 2517 2507
query3 6683 205 218 205
query4 27914 17486 17261 17261
query5 4170 495 505 495
query6 286 184 159 159
query7 4593 305 302 302
query8 316 283 295 283
query9 8655 2471 2433 2433
query10 602 290 276 276
query11 10464 9995 10128 9995
query12 140 92 82 82
query13 1653 373 380 373
query14 10459 8222 6735 6735
query15 238 189 203 189
query16 7850 341 312 312
query17 1737 570 542 542
query18 2025 290 288 288
query19 214 161 160 160
query20 90 87 84 84
query21 216 128 127 127
query22 4545 4141 4126 4126
query23 33745 33194 33105 33105
query24 12067 3011 3047 3011
query25 664 393 393 393
query26 1677 164 162 162
query27 2934 323 339 323
query28 7612 2115 2100 2100
query29 989 645 641 641
query30 278 149 146 146
query31 1152 937 962 937
query32 101 55 56 55
query33 775 320 332 320
query34 880 492 483 483
query35 759 647 623 623
query36 1056 974 922 922
query37 148 79 77 77
query38 2865 2706 2767 2706
query39 895 800 798 798
query40 271 130 128 128
query41 54 50 53 50
query42 123 101 101 101
query43 606 574 578 574
query44 1188 734 726 726
query45 204 165 169 165
query46 1124 753 752 752
query47 1888 1770 1789 1770
query48 367 298 314 298
query49 1193 428 438 428
query50 783 394 405 394
query51 6905 6889 6884 6884
query52 107 94 101 94
query53 370 298 305 298
query54 1000 469 461 461
query55 77 73 78 73
query56 309 293 290 290
query57 1163 1045 1049 1045
query58 261 246 370 246
query59 3453 3170 3298 3170
query60 316 277 275 275
query61 101 88 115 88
query62 638 445 451 445
query63 322 292 299 292
query64 9913 2258 1769 1769
query65 3369 3099 3115 3099
query66 1439 343 334 334
query67 15727 15081 14972 14972
query68 6956 557 555 555
query69 723 450 342 342
query70 1204 1124 1123 1123
query71 551 285 282 282
query72 8863 5659 5901 5659
query73 796 323 324 323
query74 6046 5626 5543 5543
query75 4783 2670 2697 2670
query76 4860 1006 1007 1006
query77 761 312 312 312
query78 9540 8832 9020 8832
query79 8824 516 514 514
query80 1019 470 465 465
query81 589 228 230 228
query82 751 106 105 105
query83 358 171 168 168
query84 265 85 84 84
query85 1407 291 287 287
query86 464 374 344 344
query87 3296 3087 3081 3081
query88 4694 2515 2433 2433
query89 535 383 390 383
query90 2055 189 189 189
query91 129 102 97 97
query92 67 47 49 47
query93 7074 510 502 502
query94 1329 213 207 207
query95 406 320 317 317
query96 605 268 272 268
query97 3204 3017 3006 3006
query98 221 198 188 188
query99 1180 842 875 842
Total cold run time: 305678 ms
Total hot run time: 173733 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2236509760
<details>
<summary>TPC-H: <b>Total hot run time: 39743 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 a6176d993f8781ee162a1a9c8336154e46724ff6, data reload: false
------ Round 1 ----------------------------------
q1 17615 4380 4251 4251
q2 2018 192 187 187
q3 10469 1155 1097 1097
q4 10188 751 786 751
q5 7518 2693 2642 2642
q6 220 137 139 137
q7 939 610 608 608
q8 9228 2040 2046 2040
q9 8720 6563 6524 6524
q10 8885 3736 3766 3736
q11 455 250 236 236
q12 413 229 229 229
q13 17777 3011 2980 2980
q14 280 226 242 226
q15 538 483 497 483
q16 481 389 385 385
q17 953 638 679 638
q18 8041 7478 7375 7375
q19 3524 1408 1385 1385
q20 630 326 338 326
q21 4999 3236 3221 3221
q22 350 286 293 286
Total cold run time: 114241 ms
Total hot run time: 39743 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4356 4232 4214 4214
q2 359 270 266 266
q3 2961 2749 2792 2749
q4 1981 1682 1726 1682
q5 5602 5630 5479 5479
q6 229 138 139 138
q7 2218 1834 1797 1797
q8 3274 3407 3397 3397
q9 8656 8735 8859 8735
q10 4078 3919 3802 3802
q11 572 493 491 491
q12 808 634 648 634
q13 15867 3180 3195 3180
q14 309 301 284 284
q15 535 504 487 487
q16 501 449 441 441
q17 1781 1542 1492 1492
q18 8077 8020 7762 7762
q19 2506 1570 1560 1560
q20 2148 1884 1924 1884
q21 9758 4969 4954 4954
q22 575 502 535 502
Total cold run time: 77151 ms
Total hot run time: 55930 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233476394
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233078805
run bulidall
--
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233101240
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2232829315
<details>
<summary>ClickBench: <b>Total hot run time: 30.43 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 adee2219ff4137e4c3fc5b841c587351c40f90aa, data reload: false
query1 0.04 0.03 0.04
query2 0.08 0.04 0.05
query3 0.23 0.05 0.06
query4 1.68 0.08 0.09
query5 0.49 0.56 0.48
query6 1.14 0.74 0.73
query7 0.02 0.01 0.02
query8 0.05 0.05 0.04
query9 0.57 0.48 0.50
query10 0.56 0.55 0.54
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.59 0.60 0.60
query14 0.77 0.77 0.78
query15 0.86 0.81 0.82
query16 0.37 0.37 0.35
query17 0.95 1.05 0.98
query18 0.23 0.21 0.22
query19 1.82 1.78 1.71
query20 0.01 0.01 0.01
query21 15.43 0.74 0.66
query22 4.56 7.60 1.56
query23 18.25 1.42 1.34
query24 2.13 0.22 0.22
query25 0.15 0.08 0.09
query26 0.30 0.22 0.22
query27 0.45 0.23 0.23
query28 13.24 1.02 1.00
query29 12.59 3.31 3.31
query30 0.25 0.06 0.05
query31 2.87 0.40 0.39
query32 3.26 0.49 0.48
query33 2.90 2.97 2.93
query34 16.96 4.35 4.36
query35 4.45 4.40 4.40
query36 0.65 0.48 0.46
query37 0.19 0.17 0.16
query38 0.16 0.15 0.15
query39 0.04 0.04 0.03
query40 0.15 0.12 0.12
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.95 s
Total hot run time: 30.43 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233548481
<details>
<summary>TPC-DS: <b>Total hot run time: 172760 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 fefda54c48d704b9126fd1d1996f0fe633930111, data reload: false
query1 929 376 373 373
query2 6603 1818 1803 1803
query3 6645 210 216 210
query4 28331 17344 17312 17312
query5 4208 490 490 490
query6 287 170 166 166
query7 4591 287 301 287
query8 250 198 195 195
query9 8646 2395 2367 2367
query10 452 273 267 267
query11 11508 9980 10054 9980
query12 138 88 80 80
query13 1635 374 358 358
query14 10162 8048 7878 7878
query15 240 163 164 163
query16 7735 327 308 308
query17 1796 531 553 531
query18 1740 272 274 272
query19 196 156 147 147
query20 92 80 79 79
query21 206 128 130 128
query22 4280 4035 4058 4035
query23 33627 32998 33084 32998
query24 11361 2818 2874 2818
query25 646 361 370 361
query26 1304 146 143 143
query27 2786 268 269 268
query28 7226 1986 1975 1975
query29 916 625 600 600
query30 286 150 150 150
query31 955 740 743 740
query32 95 53 54 53
query33 776 293 300 293
query34 932 501 500 500
query35 706 596 566 566
query36 1123 938 923 923
query37 155 83 81 81
query38 2885 2758 2729 2729
query39 873 804 807 804
query40 289 122 120 120
query41 47 48 45 45
query42 116 101 101 101
query43 502 477 457 457
query44 1222 737 724 724
query45 196 200 156 156
query46 1098 736 746 736
query47 1863 1762 1758 1758
query48 365 292 286 286
query49 1080 410 398 398
query50 777 402 399 399
query51 6876 6907 6771 6771
query52 99 98 87 87
query53 361 288 296 288
query54 1051 439 445 439
query55 74 73 73 73
query56 290 265 263 263
query57 1167 1048 1044 1044
query58 258 242 245 242
query59 2832 2697 2738 2697
query60 315 277 327 277
query61 98 95 96 95
query62 857 653 664 653
query63 320 289 289 289
query64 10634 2261 1669 1669
query65 3176 3087 3108 3087
query66 1210 332 329 329
query67 15337 14991 15031 14991
query68 4581 540 542 540
query69 641 457 344 344
query70 1187 1052 1135 1052
query71 417 285 280 280
query72 7765 5625 5731 5625
query73 763 323 325 323
query74 6380 5630 5662 5630
query75 3380 2698 2740 2698
query76 2715 968 907 907
query77 662 304 302 302
query78 9498 8976 9030 8976
query79 2636 522 525 522
query80 2216 469 464 464
query81 593 227 217 217
query82 764 130 128 128
query83 288 169 167 167
query84 264 90 86 86
query85 1899 302 303 302
query86 468 301 322 301
query87 3291 3098 3066 3066
query88 3877 2384 2394 2384
query89 498 387 386 386
query90 1801 204 198 198
query91 143 116 112 112
query92 66 51 55 51
query93 2004 499 500 499
query94 1086 222 225 222
query95 420 330 325 325
query96 603 269 279 269
query97 3245 3007 3059 3007
query98 218 201 201 201
query99 1488 1292 1271 1271
Total cold run time: 285689 ms
Total hot run time: 172760 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233560198
<details>
<summary>ClickBench: <b>Total hot run time: 31.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 fefda54c48d704b9126fd1d1996f0fe633930111, 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.06 0.07
query5 0.49 0.49 0.47
query6 1.14 0.72 0.73
query7 0.01 0.02 0.01
query8 0.05 0.04 0.04
query9 0.54 0.48 0.50
query10 0.56 0.55 0.54
query11 0.15 0.11 0.11
query12 0.15 0.12 0.12
query13 0.59 0.58 0.59
query14 0.75 0.77 0.77
query15 0.85 0.81 0.82
query16 0.37 0.36 0.38
query17 0.95 0.97 0.99
query18 0.23 0.22 0.22
query19 1.84 1.67 1.69
query20 0.02 0.01 0.01
query21 15.40 0.74 0.65
query22 4.25 6.03 2.94
query23 18.30 1.44 1.21
query24 2.05 0.23 0.26
query25 0.16 0.08 0.08
query26 0.30 0.22 0.21
query27 0.46 0.23 0.23
query28 13.31 1.03 0.99
query29 12.66 3.33 3.33
query30 0.25 0.06 0.05
query31 2.88 0.39 0.40
query32 3.26 0.48 0.48
query33 2.89 2.95 2.87
query34 17.05 4.34 4.37
query35 4.39 4.43 4.37
query36 0.66 0.46 0.46
query37 0.19 0.16 0.16
query38 0.15 0.15 0.15
query39 0.04 0.04 0.04
query40 0.15 0.13 0.13
query41 0.09 0.05 0.05
query42 0.06 0.04 0.05
query43 0.05 0.03 0.03
Total cold run time: 109.72 s
Total hot run time: 31.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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2236396660
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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2236192140
<details>
<summary>ClickBench: <b>Total hot run time: 30.93 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit d7ee26d860c265f3b6b320d591a8108ff33692fa, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.04 0.04
query3 0.22 0.06 0.05
query4 1.67 0.07 0.08
query5 0.53 0.52 0.48
query6 1.14 0.73 0.73
query7 0.02 0.02 0.02
query8 0.04 0.04 0.04
query9 0.55 0.49 0.49
query10 0.56 0.54 0.53
query11 0.15 0.11 0.11
query12 0.15 0.12 0.12
query13 0.60 0.59 0.58
query14 0.76 0.78 0.76
query15 0.86 0.82 0.82
query16 0.37 0.38 0.37
query17 1.03 1.03 1.05
query18 0.23 0.22 0.22
query19 1.89 1.84 1.82
query20 0.02 0.01 0.01
query21 15.42 0.75 0.67
query22 4.52 6.55 2.12
query23 18.29 1.30 1.30
query24 2.15 0.23 0.21
query25 0.16 0.08 0.08
query26 0.30 0.20 0.21
query27 0.45 0.23 0.23
query28 13.29 1.01 1.00
query29 12.61 3.34 3.28
query30 0.25 0.06 0.06
query31 2.86 0.38 0.38
query32 3.30 0.45 0.46
query33 2.82 2.93 2.86
query34 16.82 4.34 4.37
query35 4.41 4.41 4.40
query36 0.66 0.46 0.48
query37 0.19 0.16 0.15
query38 0.16 0.14 0.14
query39 0.04 0.04 0.03
query40 0.15 0.11 0.11
query41 0.09 0.05 0.05
query42 0.05 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 109.95 s
Total hot run time: 30.93 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2236095760
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213317076
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2205616186
<details>
<summary>TPC-H: <b>Total hot run time: 40096 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 4f13a9e0b78bf6f4c687931b863d8afe6f99cb91, data reload: false
------ Round 1 ----------------------------------
q1 17650 4494 4288 4288
q2 2020 203 194 194
q3 10510 1198 1069 1069
q4 10201 897 749 749
q5 7545 2648 2595 2595
q6 223 136 139 136
q7 966 605 626 605
q8 9247 2085 2112 2085
q9 8962 6974 7001 6974
q10 8953 3715 3726 3715
q11 462 233 225 225
q12 462 227 231 227
q13 17754 2989 2983 2983
q14 261 224 234 224
q15 530 488 474 474
q16 506 390 369 369
q17 965 585 627 585
q18 8038 7309 7427 7309
q19 7261 1447 1424 1424
q20 637 306 294 294
q21 5001 3234 3248 3234
q22 390 341 338 338
Total cold run time: 118544 ms
Total hot run time: 40096 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4378 4219 4235 4219
q2 374 278 270 270
q3 3045 2969 2984 2969
q4 1937 1771 1766 1766
q5 5526 5484 5385 5385
q6 232 140 131 131
q7 2242 1842 1870 1842
q8 3274 3461 3413 3413
q9 9255 9340 9286 9286
q10 4160 3822 3880 3822
q11 584 516 497 497
q12 839 637 635 635
q13 15900 3216 3266 3216
q14 303 295 266 266
q15 540 485 479 479
q16 489 417 426 417
q17 1867 1545 1499 1499
q18 8194 7958 7748 7748
q19 3452 1621 1665 1621
q20 2245 2007 1986 1986
q21 5032 4925 4928 4925
q22 653 567 575 567
Total cold run time: 74521 ms
Total hot run time: 56959 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2210239882
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2209154999
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2205509286
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2219491143
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2214242581
<details>
<summary>TPC-DS: <b>Total hot run time: 171116 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 02f946f997525a2811978c81d9b016685981aca5, data reload: false
query1 926 374 369 369
query2 6443 2491 2301 2301
query3 6652 204 212 204
query4 28646 17399 17264 17264
query5 4175 484 480 480
query6 280 178 176 176
query7 4579 292 285 285
query8 312 312 279 279
query9 8716 2398 2380 2380
query10 611 324 282 282
query11 11612 10060 10075 10060
query12 140 83 79 79
query13 1644 376 364 364
query14 10566 8142 7602 7602
query15 230 190 192 190
query16 7493 304 304 304
query17 1798 557 548 548
query18 1982 269 262 262
query19 193 150 145 145
query20 89 80 79 79
query21 209 136 130 130
query22 4443 4204 4004 4004
query23 33639 33068 33179 33068
query24 10775 3018 2993 2993
query25 628 353 347 347
query26 1497 152 142 142
query27 2750 267 266 266
query28 7474 2051 2047 2047
query29 884 618 612 612
query30 271 148 146 146
query31 1092 898 930 898
query32 97 54 58 54
query33 755 290 289 289
query34 978 459 474 459
query35 725 581 602 581
query36 1113 933 946 933
query37 142 78 79 78
query38 2849 2770 2728 2728
query39 843 794 795 794
query40 281 119 119 119
query41 57 50 53 50
query42 113 98 105 98
query43 577 562 553 553
query44 1160 715 725 715
query45 204 172 168 168
query46 1108 722 728 722
query47 1887 1784 1783 1783
query48 379 297 290 290
query49 1146 420 411 411
query50 772 393 394 393
query51 6919 6756 6765 6756
query52 97 93 92 92
query53 357 287 289 287
query54 911 445 443 443
query55 76 73 74 73
query56 283 303 272 272
query57 1140 1005 1030 1005
query58 254 254 244 244
query59 3378 3076 3310 3076
query60 304 269 277 269
query61 95 93 93 93
query62 807 634 637 634
query63 308 287 299 287
query64 10439 2190 1688 1688
query65 3221 3112 3106 3106
query66 1081 326 323 323
query67 15892 15230 15181 15181
query68 4632 540 542 540
query69 574 408 333 333
query70 1160 1109 1137 1109
query71 405 272 276 272
query72 7263 5570 2808 2808
query73 754 322 312 312
query74 5950 5482 5537 5482
query75 3355 2700 2715 2700
query76 2960 1001 1001 1001
query77 658 304 299 299
query78 9408 8958 8886 8886
query79 2694 513 508 508
query80 2532 464 458 458
query81 585 219 226 219
query82 824 147 129 129
query83 287 170 167 167
query84 276 89 86 86
query85 2187 373 291 291
query86 479 321 342 321
query87 3283 3091 3108 3091
query88 4213 2337 2326 2326
query89 460 374 366 366
query90 1855 183 184 183
query91 128 98 98 98
query92 64 49 48 48
query93 2450 505 497 497
query94 1241 207 205 205
query95 398 310 311 310
query96 587 266 264 264
query97 3193 2970 3026 2970
query98 223 200 196 196
query99 1664 1305 1288 1288
Total cold run time: 288239 ms
Total hot run time: 171116 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2216372546
<details>
<summary>ClickBench: <b>Total hot run time: 30.74 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 915138e801ca0a8749f077c0d6448b16add93118, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.04
query3 0.23 0.04 0.04
query4 1.67 0.08 0.09
query5 0.51 0.49 0.49
query6 1.12 0.72 0.72
query7 0.02 0.01 0.01
query8 0.05 0.04 0.05
query9 0.55 0.49 0.49
query10 0.54 0.56 0.56
query11 0.15 0.11 0.11
query12 0.15 0.12 0.11
query13 0.59 0.58 0.59
query14 0.76 0.76 0.77
query15 0.85 0.81 0.80
query16 0.38 0.37 0.37
query17 1.05 1.03 1.06
query18 0.23 0.21 0.22
query19 1.91 1.66 1.75
query20 0.01 0.02 0.01
query21 15.41 0.76 0.66
query22 3.98 7.14 2.11
query23 18.29 1.34 1.26
query24 2.04 0.23 0.22
query25 0.16 0.10 0.09
query26 0.28 0.22 0.21
query27 0.46 0.25 0.23
query28 13.37 1.02 1.00
query29 12.57 3.24 3.26
query30 0.26 0.06 0.06
query31 2.86 0.39 0.38
query32 3.28 0.46 0.46
query33 2.94 2.94 2.93
query34 16.97 4.34 4.35
query35 4.39 4.44 4.37
query36 0.65 0.48 0.49
query37 0.18 0.16 0.15
query38 0.15 0.15 0.14
query39 0.04 0.03 0.03
query40 0.16 0.12 0.12
query41 0.09 0.05 0.06
query42 0.05 0.05 0.04
query43 0.04 0.03 0.04
Total cold run time: 109.51 s
Total hot run time: 30.74 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2219437530
<details>
<summary>TPC-H: <b>Total hot run time: 40049 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 81c3cd23723182cce8b3737495bf982244bdffde, data reload: false
------ Round 1 ----------------------------------
q1 17634 4773 4254 4254
q2 2020 206 185 185
q3 10442 1176 1057 1057
q4 10188 769 837 769
q5 7554 2627 2539 2539
q6 219 139 143 139
q7 969 605 603 603
q8 9239 2058 2070 2058
q9 9603 7008 6944 6944
q10 8970 3728 3680 3680
q11 461 231 242 231
q12 462 235 230 230
q13 17756 3020 2989 2989
q14 267 231 233 231
q15 533 484 495 484
q16 501 389 383 383
q17 953 676 727 676
q18 8023 7355 7374 7355
q19 4391 1473 1336 1336
q20 634 319 310 310
q21 4916 3247 3979 3247
q22 399 349 355 349
Total cold run time: 116134 ms
Total hot run time: 40049 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4447 4224 4187 4187
q2 396 280 294 280
q3 2953 2888 2938 2888
q4 1998 1661 1703 1661
q5 5539 5462 5419 5419
q6 228 136 135 135
q7 2223 1893 1856 1856
q8 3264 3418 3411 3411
q9 9252 9314 9252 9252
q10 4052 3861 3865 3861
q11 581 515 501 501
q12 808 663 627 627
q13 16940 3162 3217 3162
q14 300 286 271 271
q15 530 499 484 484
q16 478 426 416 416
q17 1816 1529 1502 1502
q18 8121 7872 7907 7872
q19 2528 1586 1644 1586
q20 2414 2022 2019 2019
q21 4973 4701 5030 4701
q22 675 561 586 561
Total cold run time: 74516 ms
Total hot run time: 56652 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2217071417
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2219347983
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2220191374
<details>
<summary>TPC-DS: <b>Total hot run time: 174047 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 7bb9003a5fa356f5eec1a4d2a31f148e5d0d0a4f, data reload: false
query1 926 398 379 379
query2 6575 2421 2248 2248
query3 6652 212 211 211
query4 25967 17890 17271 17271
query5 4207 476 479 476
query6 263 194 157 157
query7 4577 285 283 283
query8 321 303 300 300
query9 8570 2372 2364 2364
query10 452 295 272 272
query11 10683 9956 10033 9956
query12 139 88 79 79
query13 1652 379 383 379
query14 10129 7776 7139 7139
query15 234 200 205 200
query16 7922 314 321 314
query17 1774 568 536 536
query18 2042 299 293 293
query19 212 153 160 153
query20 93 82 87 82
query21 208 139 132 132
query22 4330 4092 4013 4013
query23 33895 33149 33012 33012
query24 12167 3085 3079 3079
query25 677 387 374 374
query26 1766 154 149 149
query27 2950 270 275 270
query28 7705 2054 2030 2030
query29 1086 664 635 635
query30 289 146 162 146
query31 1127 903 938 903
query32 102 57 57 57
query33 773 325 323 323
query34 904 499 500 499
query35 714 613 597 597
query36 1074 947 939 939
query37 287 85 78 78
query38 2887 2723 2708 2708
query39 879 807 833 807
query40 279 126 121 121
query41 56 50 52 50
query42 123 101 101 101
query43 607 558 569 558
query44 1245 742 746 742
query45 197 173 172 172
query46 1108 752 782 752
query47 1868 1753 1797 1753
query48 375 308 308 308
query49 1211 433 439 433
query50 784 399 409 399
query51 6909 6778 6766 6766
query52 109 92 97 92
query53 369 289 312 289
query54 916 480 455 455
query55 74 75 78 75
query56 411 258 289 258
query57 1179 1026 1032 1026
query58 268 239 239 239
query59 3567 3293 3314 3293
query60 300 287 284 284
query61 94 95 97 95
query62 821 648 666 648
query63 308 288 296 288
query64 10556 2181 1616 1616
query65 3286 3153 3141 3141
query66 1393 335 331 331
query67 15549 14901 14853 14853
query68 9400 573 568 568
query69 726 442 361 361
query70 1445 1073 1044 1044
query71 532 283 284 283
query72 8734 6013 5792 5792
query73 2230 324 322 322
query74 6005 5423 5492 5423
query75 5221 2712 2722 2712
query76 5476 1092 966 966
query77 723 297 301 297
query78 9996 9026 9038 9026
query79 7850 517 514 514
query80 1033 471 468 468
query81 588 230 225 225
query82 296 131 140 131
query83 260 168 170 168
query84 281 88 88 88
query85 1018 305 298 298
query86 382 359 348 348
query87 3291 3153 3078 3078
query88 4575 2468 2450 2450
query89 516 379 379 379
query90 1975 189 185 185
query91 132 101 100 100
query92 62 49 50 49
query93 5974 516 517 516
query94 1279 218 214 214
query95 403 322 314 314
query96 612 278 274 274
query97 3234 3045 3004 3004
query98 232 208 200 200
query99 1490 1321 1269 1269
Total cold run time: 307143 ms
Total hot run time: 174047 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2221961644
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2216364986
<details>
<summary>TPC-DS: <b>Total hot run time: 175238 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 915138e801ca0a8749f077c0d6448b16add93118, data reload: false
query1 917 375 364 364
query2 6344 2383 2457 2383
query3 6638 205 216 205
query4 25377 17434 17260 17260
query5 3649 464 473 464
query6 269 181 166 166
query7 4589 285 280 280
query8 323 308 301 301
query9 8577 2415 2394 2394
query10 575 312 293 293
query11 10671 10161 10106 10106
query12 116 85 81 81
query13 1650 369 368 368
query14 8702 8028 7963 7963
query15 247 204 190 190
query16 7467 297 302 297
query17 1810 543 527 527
query18 1567 279 289 279
query19 198 144 150 144
query20 92 81 81 81
query21 201 129 126 126
query22 4336 4144 3982 3982
query23 33966 34045 33654 33654
query24 10575 3087 3064 3064
query25 540 379 361 361
query26 694 156 151 151
query27 2179 263 270 263
query28 6292 2153 2113 2113
query29 878 632 621 621
query30 289 152 153 152
query31 1149 914 949 914
query32 92 77 53 53
query33 656 297 295 295
query34 885 505 487 487
query35 696 608 612 608
query36 1142 994 1001 994
query37 139 85 87 85
query38 2984 2818 2818 2818
query39 908 849 854 849
query40 200 123 124 123
query41 55 49 52 49
query42 116 106 107 106
query43 626 561 552 552
query44 1069 747 728 728
query45 205 169 176 169
query46 1101 773 760 760
query47 1870 1759 1779 1759
query48 357 293 293 293
query49 885 441 413 413
query50 785 393 400 393
query51 6829 6777 6777 6777
query52 103 91 91 91
query53 366 293 296 293
query54 878 442 462 442
query55 74 75 71 71
query56 280 263 265 263
query57 1127 1065 1031 1031
query58 241 231 252 231
query59 3377 3271 3417 3271
query60 321 285 282 282
query61 99 94 96 94
query62 785 637 634 634
query63 317 291 292 291
query64 9205 2254 1617 1617
query65 3183 3117 3112 3112
query66 751 327 323 323
query67 15439 15127 14922 14922
query68 4492 534 561 534
query69 525 401 342 342
query70 1156 1168 1066 1066
query71 364 283 283 283
query72 6714 5648 4716 4716
query73 740 318 332 318
query74 5862 5529 5517 5517
query75 3339 2684 2654 2654
query76 2253 1127 1001 1001
query77 497 307 312 307
query78 9569 10660 9495 9495
query79 2604 514 516 514
query80 998 481 473 473
query81 591 224 224 224
query82 337 134 137 134
query83 333 171 174 171
query84 274 83 84 83
query85 797 303 294 294
query86 486 343 348 343
query87 3339 3132 3122 3122
query88 3548 2327 2340 2327
query89 490 384 377 377
query90 1742 190 190 190
query91 131 107 102 102
query92 65 49 50 49
query93 1776 498 497 497
query94 1006 231 206 206
query95 397 319 313 313
query96 590 266 271 266
query97 3185 3104 3014 3014
query98 224 201 198 198
query99 1666 1310 1282 1282
Total cold run time: 269113 ms
Total hot run time: 175238 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2205508941
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213615264
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213746595
<details>
<summary>TPC-DS: <b>Total hot run time: 175182 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 177e8dc65f997a988ac9a67c6185a4b9cb6d02a9, data reload: false
query1 918 364 366 364
query2 6189 2280 2372 2280
query3 6649 201 216 201
query4 24743 17544 17211 17211
query5 3731 502 498 498
query6 288 184 181 181
query7 4581 306 296 296
query8 337 292 302 292
query9 8580 2403 2363 2363
query10 602 311 285 285
query11 10696 10100 9907 9907
query12 146 88 79 79
query13 1672 379 391 379
query14 10253 7804 7789 7789
query15 240 194 196 194
query16 7895 314 320 314
query17 1780 566 542 542
query18 2022 289 292 289
query19 204 156 159 156
query20 94 85 86 85
query21 215 130 134 130
query22 4414 4106 3915 3915
query23 33997 33546 33827 33546
query24 12101 3173 3153 3153
query25 678 440 417 417
query26 1781 164 161 161
query27 2893 287 286 286
query28 7502 2175 2162 2162
query29 1060 671 658 658
query30 244 149 147 147
query31 1181 930 922 922
query32 99 60 83 60
query33 773 343 331 331
query34 896 509 500 500
query35 752 664 639 639
query36 1143 988 983 983
query37 301 90 85 85
query38 2906 2807 2804 2804
query39 877 817 806 806
query40 256 132 131 131
query41 57 53 53 53
query42 123 102 100 100
query43 596 518 537 518
query44 1166 753 742 742
query45 211 171 175 171
query46 1124 776 768 768
query47 1871 1902 1762 1762
query48 382 300 303 300
query49 934 438 437 437
query50 768 396 399 396
query51 6886 6830 6792 6792
query52 108 93 89 89
query53 359 303 292 292
query54 922 467 451 451
query55 75 75 73 73
query56 292 268 268 268
query57 1181 1059 1047 1047
query58 245 232 248 232
query59 3545 3160 3091 3091
query60 306 275 274 274
query61 95 96 96 96
query62 801 652 629 629
query63 323 290 297 290
query64 10349 2262 1652 1652
query65 3197 3137 3165 3137
query66 1232 319 329 319
query67 15852 14772 14850 14772
query68 8935 618 576 576
query69 781 441 369 369
query70 1328 1050 1125 1050
query71 548 292 280 280
query72 9295 5550 5969 5550
query73 2214 327 328 327
query74 6078 5485 5531 5485
query75 5967 2700 2654 2654
query76 5548 1057 1036 1036
query77 771 307 314 307
query78 9647 9074 8953 8953
query79 7718 536 523 523
query80 2139 500 499 499
query81 596 218 228 218
query82 279 139 131 131
query83 298 170 172 170
query84 281 89 86 86
query85 996 294 294 294
query86 351 333 342 333
query87 3391 3081 3083 3081
query88 4947 2460 2479 2460
query89 533 381 373 373
query90 2090 187 188 187
query91 130 100 103 100
query92 62 50 50 50
query93 5893 530 522 522
query94 1391 217 212 212
query95 407 315 308 308
query96 619 269 269 269
query97 3188 3005 3025 3005
query98 215 201 186 186
query99 1736 1311 1296 1296
Total cold run time: 307061 ms
Total hot run time: 175182 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213756552
<details>
<summary>ClickBench: <b>Total hot run time: 30.63 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 177e8dc65f997a988ac9a67c6185a4b9cb6d02a9, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.03 0.03
query3 0.22 0.05 0.05
query4 1.68 0.07 0.06
query5 0.51 0.50 0.50
query6 1.14 0.73 0.73
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.55 0.50 0.49
query10 0.55 0.56 0.54
query11 0.15 0.11 0.11
query12 0.15 0.13 0.12
query13 0.59 0.59 0.58
query14 0.80 0.80 0.76
query15 0.85 0.81 0.81
query16 0.37 0.37 0.37
query17 1.04 0.98 1.05
query18 0.22 0.21 0.21
query19 1.76 1.73 1.69
query20 0.02 0.01 0.01
query21 15.40 0.75 0.65
query22 4.18 7.62 1.90
query23 18.30 1.47 1.40
query24 2.11 0.22 0.23
query25 0.17 0.09 0.08
query26 0.30 0.21 0.20
query27 0.45 0.24 0.22
query28 13.32 1.01 0.99
query29 12.60 3.28 3.28
query30 0.26 0.06 0.05
query31 2.87 0.38 0.38
query32 3.29 0.48 0.47
query33 2.85 2.88 2.94
query34 17.27 4.39 4.37
query35 4.46 4.40 4.41
query36 0.64 0.47 0.48
query37 0.18 0.16 0.15
query38 0.15 0.15 0.14
query39 0.04 0.03 0.04
query40 0.15 0.13 0.11
query41 0.10 0.04 0.05
query42 0.05 0.05 0.04
query43 0.05 0.04 0.04
Total cold run time: 109.98 s
Total hot run time: 30.63 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2214166009
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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2235247631
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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2235247679
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2220203063
<details>
<summary>ClickBench: <b>Total hot run time: 30.53 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 7bb9003a5fa356f5eec1a4d2a31f148e5d0d0a4f, data reload: false
query1 0.04 0.03 0.04
query2 0.08 0.04 0.04
query3 0.22 0.05 0.04
query4 1.67 0.07 0.07
query5 0.51 0.49 0.49
query6 1.14 0.73 0.73
query7 0.02 0.02 0.02
query8 0.06 0.04 0.04
query9 0.55 0.49 0.49
query10 0.56 0.55 0.56
query11 0.16 0.12 0.12
query12 0.15 0.12 0.12
query13 0.60 0.59 0.59
query14 0.74 0.79 0.78
query15 0.85 0.81 0.82
query16 0.38 0.37 0.37
query17 1.03 1.05 1.02
query18 0.23 0.22 0.21
query19 1.91 1.67 1.85
query20 0.02 0.01 0.01
query21 15.41 0.77 0.66
query22 4.61 7.27 1.78
query23 18.28 1.35 1.30
query24 2.21 0.23 0.22
query25 0.16 0.08 0.08
query26 0.30 0.20 0.20
query27 0.45 0.23 0.22
query28 13.26 1.01 0.99
query29 12.64 3.35 3.39
query30 0.27 0.05 0.06
query31 2.85 0.40 0.40
query32 3.25 0.48 0.46
query33 2.86 2.94 2.89
query34 17.15 4.34 4.32
query35 4.42 4.38 4.36
query36 0.67 0.47 0.47
query37 0.18 0.15 0.15
query38 0.16 0.15 0.14
query39 0.05 0.04 0.04
query40 0.15 0.12 0.13
query41 0.10 0.04 0.05
query42 0.05 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 110.45 s
Total hot run time: 30.53 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2210341343
<details>
<summary>ClickBench: <b>Total hot run time: 31.21 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 a2b6bdc87e867fbb7b9b0575bba803b8acd8e464, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.04 0.04
query3 0.23 0.06 0.05
query4 1.66 0.07 0.07
query5 0.50 0.49 0.49
query6 1.13 0.73 0.72
query7 0.02 0.02 0.02
query8 0.05 0.04 0.05
query9 0.53 0.51 0.49
query10 0.55 0.54 0.55
query11 0.15 0.12 0.12
query12 0.15 0.12 0.12
query13 0.59 0.59 0.58
query14 0.77 0.76 0.78
query15 0.85 0.81 0.81
query16 0.37 0.38 0.36
query17 0.98 1.04 1.02
query18 0.23 0.25 0.25
query19 1.80 1.66 1.69
query20 0.01 0.01 0.01
query21 15.39 0.74 0.64
query22 4.24 7.03 2.40
query23 18.32 1.37 1.30
query24 2.14 0.23 0.21
query25 0.16 0.08 0.08
query26 0.30 0.22 0.20
query27 0.46 0.24 0.23
query28 13.21 1.02 1.00
query29 12.59 3.38 3.34
query30 0.26 0.06 0.05
query31 2.92 0.39 0.38
query32 3.26 0.48 0.47
query33 2.86 2.92 2.93
query34 17.16 4.35 4.44
query35 4.44 4.40 4.49
query36 0.65 0.47 0.47
query37 0.18 0.17 0.16
query38 0.15 0.15 0.16
query39 0.04 0.04 0.03
query40 0.16 0.12 0.12
query41 0.09 0.05 0.05
query42 0.06 0.05 0.04
query43 0.05 0.04 0.04
Total cold run time: 109.77 s
Total hot run time: 31.21 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2206600692
<details>
<summary>TPC-H: <b>Total hot run time: 40347 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 bf9df876fde9280d97794bf2c5998e1d07d59b67, data reload: false
------ Round 1 ----------------------------------
q1 17618 4690 4298 4298
q2 2024 191 188 188
q3 10464 1189 1027 1027
q4 10186 757 820 757
q5 7553 2673 2658 2658
q6 225 140 142 140
q7 972 601 600 600
q8 9253 2134 2103 2103
q9 9199 6926 6972 6926
q10 8953 3708 3695 3695
q11 524 238 240 238
q12 463 237 232 232
q13 18737 3002 3005 3002
q14 286 227 232 227
q15 526 488 501 488
q16 507 394 371 371
q17 985 656 636 636
q18 8037 7462 7384 7384
q19 3940 1547 1514 1514
q20 657 320 294 294
q21 5038 3221 3435 3221
q22 408 351 348 348
Total cold run time: 116555 ms
Total hot run time: 40347 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4492 4272 4301 4272
q2 387 288 280 280
q3 3008 2988 3018 2988
q4 2008 1655 1732 1655
q5 5639 5539 5464 5464
q6 231 133 136 133
q7 2224 1904 1893 1893
q8 3314 3427 3468 3427
q9 9212 9291 9287 9287
q10 4116 3763 3846 3763
q11 600 500 500 500
q12 808 655 673 655
q13 16434 3223 3253 3223
q14 309 285 279 279
q15 536 479 504 479
q16 496 428 429 428
q17 1841 1526 1501 1501
q18 8244 8114 7862 7862
q19 3806 1713 1591 1591
q20 2379 2007 1977 1977
q21 9667 4959 4907 4907
q22 684 614 585 585
Total cold run time: 80435 ms
Total hot run time: 57149 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213423492
<details>
<summary>ClickBench: <b>Total hot run time: 30.68 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 968b00fe8464ffab59ba455a2ab7a2aeffee1005, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.03 0.03
query3 0.22 0.05 0.05
query4 1.68 0.09 0.08
query5 0.51 0.49 0.48
query6 1.13 0.73 0.73
query7 0.03 0.01 0.01
query8 0.05 0.05 0.04
query9 0.55 0.49 0.48
query10 0.53 0.54 0.54
query11 0.16 0.12 0.11
query12 0.15 0.12 0.12
query13 0.59 0.58 0.60
query14 0.77 0.79 0.77
query15 0.85 0.82 0.82
query16 0.37 0.35 0.36
query17 1.03 1.06 1.05
query18 0.20 0.23 0.25
query19 1.76 1.80 1.78
query20 0.01 0.00 0.00
query21 15.39 0.75 0.66
query22 4.93 7.26 1.72
query23 18.36 1.47 1.35
query24 2.09 0.22 0.23
query25 0.15 0.08 0.08
query26 0.32 0.21 0.20
query27 0.45 0.23 0.23
query28 13.34 1.01 1.01
query29 12.64 3.31 3.29
query30 0.25 0.06 0.05
query31 2.88 0.38 0.38
query32 3.28 0.47 0.48
query33 2.92 2.91 2.95
query34 17.03 4.37 4.35
query35 4.46 4.45 4.44
query36 0.66 0.46 0.47
query37 0.18 0.16 0.15
query38 0.16 0.14 0.15
query39 0.04 0.04 0.04
query40 0.15 0.12 0.12
query41 0.09 0.05 0.05
query42 0.06 0.05 0.04
query43 0.04 0.04 0.04
Total cold run time: 110.58 s
Total hot run time: 30.68 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2216864248
<details>
<summary>ClickBench: <b>Total hot run time: 30.93 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 69faef1bcbfe3387c5ae4028139c2f9bd1acddf2, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.03 0.04
query3 0.23 0.05 0.06
query4 1.68 0.07 0.07
query5 0.50 0.48 0.48
query6 1.14 0.74 0.72
query7 0.03 0.02 0.01
query8 0.05 0.05 0.04
query9 0.54 0.48 0.48
query10 0.55 0.55 0.54
query11 0.15 0.12 0.11
query12 0.14 0.11 0.12
query13 0.59 0.59 0.58
query14 0.75 0.76 0.78
query15 0.86 0.82 0.80
query16 0.37 0.37 0.36
query17 0.93 0.99 0.95
query18 0.23 0.22 0.22
query19 1.75 1.71 1.70
query20 0.01 0.01 0.01
query21 15.39 0.76 0.66
query22 4.88 5.40 2.35
query23 18.37 1.39 1.25
query24 2.18 0.24 0.21
query25 0.14 0.08 0.09
query26 0.30 0.21 0.21
query27 0.46 0.24 0.24
query28 13.23 1.03 1.01
query29 12.59 3.39 3.32
query30 0.26 0.06 0.06
query31 2.87 0.39 0.38
query32 3.28 0.47 0.47
query33 2.92 2.93 2.92
query34 17.07 4.34 4.29
query35 4.39 4.40 4.44
query36 0.65 0.46 0.47
query37 0.18 0.16 0.15
query38 0.15 0.14 0.14
query39 0.04 0.04 0.03
query40 0.16 0.11 0.13
query41 0.09 0.05 0.05
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 110.32 s
Total hot run time: 30.93 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213407108
<details>
<summary>TPC-DS: <b>Total hot run time: 174263 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 968b00fe8464ffab59ba455a2ab7a2aeffee1005, data reload: false
query1 918 385 366 366
query2 6362 2425 2315 2315
query3 6634 205 217 205
query4 26666 17447 17288 17288
query5 3752 488 493 488
query6 292 176 156 156
query7 4583 304 295 295
query8 303 282 269 269
query9 8468 2358 2339 2339
query10 552 289 267 267
query11 10677 10120 10200 10120
query12 114 84 83 83
query13 1651 375 371 371
query14 10082 7735 7700 7700
query15 236 194 192 192
query16 7703 313 297 297
query17 1794 558 557 557
query18 1884 303 274 274
query19 194 148 155 148
query20 93 88 84 84
query21 211 131 125 125
query22 4354 4015 3976 3976
query23 33800 33762 33689 33689
query24 11805 3154 3057 3057
query25 675 379 379 379
query26 1762 171 172 171
query27 2867 341 336 336
query28 8167 2142 2138 2138
query29 1058 653 646 646
query30 236 150 145 145
query31 1191 966 913 913
query32 97 76 52 52
query33 743 301 311 301
query34 898 494 490 490
query35 780 670 667 667
query36 1150 963 998 963
query37 180 82 80 80
query38 2957 2759 2741 2741
query39 840 796 783 783
query40 245 134 122 122
query41 52 49 49 49
query42 122 93 96 93
query43 581 530 520 520
query44 1233 741 730 730
query45 211 175 167 167
query46 1113 765 707 707
query47 1877 1806 1777 1777
query48 379 316 310 310
query49 947 438 428 428
query50 769 383 391 383
query51 6898 6748 6770 6748
query52 105 94 91 91
query53 365 291 300 291
query54 966 475 459 459
query55 74 76 75 75
query56 304 295 289 289
query57 1165 1062 1061 1061
query58 270 275 255 255
query59 3322 3166 3071 3071
query60 292 273 274 273
query61 95 96 92 92
query62 597 454 447 447
query63 320 287 287 287
query64 10316 2221 1647 1647
query65 3230 3134 3146 3134
query66 1248 340 361 340
query67 15418 15040 14831 14831
query68 5891 570 572 570
query69 687 410 351 351
query70 1209 1190 1128 1128
query71 454 279 269 269
query72 7161 5566 5493 5493
query73 768 328 321 321
query74 5898 5608 5497 5497
query75 3797 2659 2748 2659
query76 3542 913 972 913
query77 657 303 297 297
query78 9506 8921 8850 8850
query79 3052 513 512 512
query80 2327 494 482 482
query81 614 227 230 227
query82 1348 108 100 100
query83 303 180 172 172
query84 281 87 84 84
query85 1452 293 278 278
query86 471 393 346 346
query87 3275 3116 3088 3088
query88 4650 2461 2442 2442
query89 482 390 391 390
query90 1784 188 188 188
query91 128 98 98 98
query92 58 48 47 47
query93 4150 516 513 513
query94 1115 203 207 203
query95 405 306 313 306
query96 615 267 263 263
query97 3202 3011 3043 3011
query98 296 204 194 194
query99 1198 828 840 828
Total cold run time: 290019 ms
Total hot run time: 174263 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2213642256
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2216350616
<details>
<summary>TPC-H: <b>Total hot run time: 39881 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 915138e801ca0a8749f077c0d6448b16add93118, data reload: false
------ Round 1 ----------------------------------
q1 17669 4348 4218 4218
q2 2013 189 184 184
q3 10527 1187 1046 1046
q4 10197 847 710 710
q5 7553 2634 2555 2555
q6 219 138 134 134
q7 948 595 592 592
q8 9233 2046 2034 2034
q9 9025 6935 6888 6888
q10 8841 3706 3736 3706
q11 472 236 241 236
q12 440 226 230 226
q13 17783 3005 3010 3005
q14 273 222 221 221
q15 538 492 501 492
q16 497 369 369 369
q17 962 644 618 618
q18 7864 7500 7439 7439
q19 7965 1540 1386 1386
q20 617 312 310 310
q21 4811 3230 3171 3171
q22 389 347 341 341
Total cold run time: 118836 ms
Total hot run time: 39881 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4358 4237 4339 4237
q2 382 279 275 275
q3 3010 2952 2957 2952
q4 2008 1682 1754 1682
q5 5529 5444 5362 5362
q6 232 130 127 127
q7 2212 1866 1875 1866
q8 3202 3402 3404 3402
q9 9177 9276 9230 9230
q10 4140 3747 3863 3747
q11 584 504 486 486
q12 782 639 641 639
q13 16441 3168 3252 3168
q14 301 281 276 276
q15 522 495 478 478
q16 468 425 422 422
q17 1822 1524 1493 1493
q18 8248 8110 7809 7809
q19 1785 1419 1612 1419
q20 2349 1995 2027 1995
q21 5057 4724 5022 4724
q22 680 589 613 589
Total cold run time: 73289 ms
Total hot run time: 56378 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2206219619
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2219458804
<details>
<summary>ClickBench: <b>Total hot run time: 30.5 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 81c3cd23723182cce8b3737495bf982244bdffde, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.04
query3 0.22 0.06 0.06
query4 1.65 0.07 0.08
query5 0.51 0.49 0.48
query6 1.14 0.73 0.72
query7 0.02 0.02 0.01
query8 0.05 0.05 0.04
query9 0.55 0.50 0.49
query10 0.55 0.53 0.56
query11 0.15 0.12 0.11
query12 0.14 0.11 0.12
query13 0.62 0.58 0.58
query14 0.75 0.78 0.76
query15 0.84 0.82 0.82
query16 0.37 0.36 0.37
query17 0.98 1.05 0.95
query18 0.24 0.23 0.23
query19 1.82 1.80 1.73
query20 0.01 0.01 0.01
query21 15.39 0.75 0.66
query22 3.76 8.01 1.77
query23 18.28 1.43 1.29
query24 2.14 0.23 0.22
query25 0.16 0.09 0.09
query26 0.29 0.21 0.20
query27 0.45 0.23 0.23
query28 13.29 1.03 1.00
query29 12.58 3.33 3.34
query30 0.25 0.06 0.06
query31 2.87 0.39 0.38
query32 3.27 0.48 0.48
query33 2.92 2.89 2.89
query34 17.10 4.35 4.35
query35 4.41 4.36 4.40
query36 0.66 0.49 0.47
query37 0.19 0.15 0.16
query38 0.14 0.14 0.16
query39 0.04 0.03 0.04
query40 0.15 0.13 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.27 s
Total hot run time: 30.5 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] [enhancement](nereids) enhancement distribute planner for data distribution [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2233148339
<details>
<summary>TPC-H: <b>Total hot run time: 39789 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 b614b2b8a83c51d588cc947d1e68e6ec2248d0ae, data reload: false
------ Round 1 ----------------------------------
q1 17619 4330 4264 4264
q2 2011 211 184 184
q3 11415 1245 1085 1085
q4 10538 835 857 835
q5 8474 2743 2663 2663
q6 223 143 139 139
q7 976 620 613 613
q8 9246 2069 2103 2069
q9 8917 6684 6606 6606
q10 8696 3757 3727 3727
q11 464 230 242 230
q12 394 221 224 221
q13 17770 2966 2980 2966
q14 270 246 247 246
q15 522 476 509 476
q16 512 388 376 376
q17 960 721 596 596
q18 8058 7486 7410 7410
q19 5280 1319 1398 1319
q20 692 326 328 326
q21 4893 3159 3229 3159
q22 351 279 286 279
Total cold run time: 118281 ms
Total hot run time: 39789 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4367 4300 4243 4243
q2 377 267 283 267
q3 3006 2933 2937 2933
q4 2002 1719 1714 1714
q5 5509 5525 5446 5446
q6 235 132 129 129
q7 2242 1848 1840 1840
q8 3276 3420 3426 3420
q9 8663 8738 8693 8693
q10 4055 3840 3830 3830
q11 612 479 491 479
q12 794 640 654 640
q13 16614 3225 3179 3179
q14 323 279 290 279
q15 545 494 474 474
q16 499 448 434 434
q17 1833 1549 1523 1523
q18 8030 7935 7672 7672
q19 1685 1499 1625 1499
q20 2023 1844 1864 1844
q21 5015 4890 4825 4825
q22 599 517 509 509
Total cold run time: 72304 ms
Total hot run time: 55872 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2232754467
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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2232793190
<details>
<summary>TPC-H: <b>Total hot run time: 39889 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 adee2219ff4137e4c3fc5b841c587351c40f90aa, data reload: false
------ Round 1 ----------------------------------
q1 14566 4361 4256 4256
q2 525 198 189 189
q3 1418 1079 1100 1079
q4 1446 718 811 718
q5 2762 2679 2893 2679
q6 281 144 144 144
q7 983 620 606 606
q8 2019 2066 2071 2066
q9 6946 6889 6817 6817
q10 3937 3769 3751 3751
q11 456 241 239 239
q12 402 224 218 218
q13 17748 3036 2989 2989
q14 269 238 235 235
q15 522 475 493 475
q16 473 411 380 380
q17 961 718 608 608
q18 8249 7383 7534 7383
q19 1565 1369 1408 1369
q20 691 314 315 314
q21 9461 3087 3252 3087
q22 359 299 287 287
Total cold run time: 76039 ms
Total hot run time: 39889 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4317 4533 4232 4232
q2 381 281 280 280
q3 3016 2751 2767 2751
q4 1936 1624 1617 1617
q5 5300 5332 5298 5298
q6 220 132 132 132
q7 2169 1752 1737 1737
q8 3208 3351 3375 3351
q9 9292 9238 9189 9189
q10 4082 3844 3970 3844
q11 602 505 498 498
q12 854 634 649 634
q13 17528 3194 3351 3194
q14 344 297 297 297
q15 551 503 486 486
q16 505 457 462 457
q17 1807 1563 1538 1538
q18 8157 7976 7844 7844
q19 2374 1447 1665 1447
q20 2228 2061 1979 1979
q21 5086 5051 4977 4977
q22 647 569 542 542
Total cold run time: 74604 ms
Total hot run time: 56324 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] [chore](nereids) Default set enable_nereids_distribute_planner=true [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37219:
URL: https://github.com/apache/doris/pull/37219#issuecomment-2232817927
<details>
<summary>TPC-DS: <b>Total hot run time: 174437 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 adee2219ff4137e4c3fc5b841c587351c40f90aa, data reload: false
query1 909 374 361 361
query2 6277 1913 1828 1828
query3 6656 206 213 206
query4 28470 17585 17460 17460
query5 3839 497 507 497
query6 251 168 172 168
query7 4575 292 283 283
query8 249 193 199 193
query9 8824 2436 2409 2409
query10 438 323 271 271
query11 11649 10287 10081 10081
query12 115 88 84 84
query13 1651 370 371 370
query14 10404 7121 9119 7121
query15 234 180 186 180
query16 8067 337 325 325
query17 1722 566 550 550
query18 2076 288 291 288
query19 214 162 162 162
query20 95 87 87 87
query21 211 138 130 130
query22 4501 4037 3921 3921
query23 34237 33857 33674 33674
query24 10771 3115 3157 3115
query25 598 414 422 414
query26 699 169 159 159
query27 2242 305 292 292
query28 6271 2122 2124 2122
query29 919 747 605 605
query30 195 152 152 152
query31 1106 1007 913 913
query32 95 57 55 55
query33 674 316 311 311
query34 887 496 491 491
query35 704 636 604 604
query36 1126 963 970 963
query37 146 85 83 83
query38 2937 2795 2793 2793
query39 928 872 890 872
query40 211 124 124 124
query41 48 42 42 42
query42 131 105 105 105
query43 505 473 479 473
query44 1114 766 778 766
query45 210 176 163 163
query46 1124 764 790 764
query47 1866 1739 1737 1737
query48 366 298 287 287
query49 832 415 422 415
query50 814 394 395 394
query51 6890 6798 6730 6730
query52 108 93 93 93
query53 360 290 292 290
query54 863 453 455 453
query55 77 72 73 72
query56 302 279 268 268
query57 1141 1051 1041 1041
query58 245 246 251 246
query59 2914 2662 2758 2662
query60 311 283 283 283
query61 97 96 122 96
query62 798 646 649 646
query63 322 288 297 288
query64 9220 2258 1664 1664
query65 3207 3130 3160 3130
query66 696 329 328 328
query67 15553 14978 15024 14978
query68 6186 572 545 545
query69 709 458 358 358
query70 1230 1107 1135 1107
query71 501 294 284 284
query72 7774 5870 5890 5870
query73 805 326 317 317
query74 6086 5695 5636 5636
query75 4444 2689 2669 2669
query76 4613 982 1019 982
query77 793 311 307 307
query78 9992 9204 8917 8917
query79 6252 518 530 518
query80 2388 485 483 483
query81 595 230 273 230
query82 810 150 143 143
query83 314 169 170 169
query84 274 81 89 81
query85 1308 304 293 293
query86 464 381 351 351
query87 3303 3121 3101 3101
query88 4495 2377 2365 2365
query89 500 389 389 389
query90 1935 206 194 194
query91 131 99 102 99
query92 65 48 50 48
query93 5720 522 513 513
query94 1150 223 213 213
query95 406 313 322 313
query96 619 270 314 270
query97 3181 3090 3088 3088
query98 225 195 191 191
query99 1530 1278 1262 1262
Total cold run time: 295085 ms
Total hot run time: 174437 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