You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "mrhhsg (via GitHub)" <gi...@apache.org> on 2025/04/03 10:33:57 UTC
[PR] [test](ut) add cases about hash join [doris]
mrhhsg opened a new pull request, #49803:
URL: https://github.com/apache/doris/pull/49803
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [test](ut) add cases about hash join [doris]
Posted by "mrhhsg (via GitHub)" <gi...@apache.org>.
mrhhsg commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2797033888
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2785960239
<details>
<summary>TPC-H: <b>Total hot run time: 34493 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 d675c6696322aa4c8ab89f26a000ecfaecfd5b7e, data reload: false
------ Round 1 ----------------------------------
q1 26500 5168 5090 5090
q2 2078 280 186 186
q3 10389 1249 707 707
q4 10223 1042 556 556
q5 7856 2360 2427 2360
q6 183 164 134 134
q7 913 774 629 629
q8 9341 1419 1216 1216
q9 6878 5175 5106 5106
q10 6822 2316 1931 1931
q11 483 296 274 274
q12 356 353 219 219
q13 17752 3801 3095 3095
q14 241 231 223 223
q15 542 470 505 470
q16 634 625 595 595
q17 584 868 356 356
q18 7602 7171 7035 7035
q19 1233 960 577 577
q20 335 356 222 222
q21 4449 3485 2542 2542
q22 1087 1024 970 970
Total cold run time: 116481 ms
Total hot run time: 34493 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5159 5119 5138 5119
q2 236 328 232 232
q3 2130 2637 2235 2235
q4 1484 1967 1530 1530
q5 4566 4460 4345 4345
q6 224 165 123 123
q7 1965 1940 1753 1753
q8 2571 2609 2477 2477
q9 7169 7148 7289 7148
q10 3028 3193 2759 2759
q11 578 522 494 494
q12 681 740 596 596
q13 3570 3963 3333 3333
q14 274 291 285 285
q15 528 498 470 470
q16 651 691 651 651
q17 1158 1542 1356 1356
q18 7739 7533 7311 7311
q19 877 857 954 857
q20 1948 2043 1861 1861
q21 5143 4676 4629 4629
q22 1045 1055 1010 1010
Total cold run time: 52724 ms
Total hot run time: 50574 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] [test](ut) add cases about hash join [doris]
Posted by "mrhhsg (via GitHub)" <gi...@apache.org>.
mrhhsg commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2775284521
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2776152964
<details>
<summary>TPC-H: <b>Total hot run time: 34181 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 4a0adb27536f7e023a4dbd110fe5068d6be143af, data reload: false
------ Round 1 ----------------------------------
q1 25521 5029 5007 5007
q2 2078 271 178 178
q3 10408 1242 700 700
q4 10217 989 519 519
q5 7515 2309 2338 2309
q6 189 164 132 132
q7 894 735 614 614
q8 9315 1301 1079 1079
q9 6835 5177 5085 5085
q10 6819 2296 1896 1896
q11 475 282 263 263
q12 352 348 220 220
q13 17761 3665 3088 3088
q14 233 229 207 207
q15 528 474 476 474
q16 631 630 586 586
q17 581 853 363 363
q18 7608 7167 7091 7091
q19 1236 936 586 586
q20 350 340 239 239
q21 4515 3726 2541 2541
q22 1115 1043 1004 1004
Total cold run time: 115176 ms
Total hot run time: 34181 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5024 5048 5082 5048
q2 238 327 238 238
q3 2128 2666 2281 2281
q4 1435 1823 1415 1415
q5 4454 4443 4420 4420
q6 216 172 128 128
q7 1956 1933 1771 1771
q8 2587 2535 2647 2535
q9 7299 7116 7065 7065
q10 3033 3143 2734 2734
q11 576 500 491 491
q12 680 779 644 644
q13 3484 3994 3337 3337
q14 292 289 257 257
q15 525 470 469 469
q16 646 722 669 669
q17 1150 1567 1361 1361
q18 7797 7527 7557 7527
q19 845 805 896 805
q20 1924 1977 1827 1827
q21 5275 4970 4854 4854
q22 1065 1049 1007 1007
Total cold run time: 52629 ms
Total hot run time: 50883 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2795900081
# BE UT Coverage Report
Increment line coverage `87.50% (7/8)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/07a95114e49761de827284fdfb42fb13fbaacd76_07a95114e49761de827284fdfb42fb13fbaacd76/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/07a95114e49761de827284fdfb42fb13fbaacd76_07a95114e49761de827284fdfb42fb13fbaacd76/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.38% (14084/26887) |
| Line Coverage | 41.32% (122110/295537) |
| Region Coverage | 40.02% (62104/155184) |
| Branch Coverage | 34.69% (31114/89694) |
--
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] [test](ut) add cases about hash join [doris]
Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt commented on code in PR #49803:
URL: https://github.com/apache/doris/pull/49803#discussion_r2041297258
##########
be/src/pipeline/exec/hashjoin_probe_operator.h:
##########
@@ -155,7 +155,8 @@ class HashJoinProbeOperatorX MOCK_REMOVE(final)
bool need_finalize_variant_column() const { return _need_finalize_variant_column; }
bool is_lazy_materialized_column(int column_id) const {
- return _have_other_join_conjunct && !_other_conjunct_refer_column_ids.contains(column_id);
+ return _have_other_join_conjunct &&
Review Comment:
what if _have_other_join_conjunct is false and mark join is 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] [test](ut) add cases about hash join [doris]
Posted by "mrhhsg (via GitHub)" <gi...@apache.org>.
mrhhsg commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2789826498
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2796085627
<details>
<summary>TPC-DS: <b>Total hot run time: 193254 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 07a95114e49761de827284fdfb42fb13fbaacd76, data reload: false
query1 1388 1068 1070 1068
query2 6139 1921 1910 1910
query3 11113 4574 4735 4574
query4 25439 23959 23375 23375
query5 4989 635 471 471
query6 310 226 198 198
query7 3999 491 283 283
query8 287 236 218 218
query9 8518 2586 2594 2586
query10 502 313 266 266
query11 15471 15060 14863 14863
query12 164 121 109 109
query13 1573 531 395 395
query14 9042 6242 6329 6242
query15 198 190 172 172
query16 7580 637 485 485
query17 1154 800 595 595
query18 2056 416 347 347
query19 191 190 161 161
query20 133 124 121 121
query21 208 130 108 108
query22 4379 4579 4308 4308
query23 34566 33702 33326 33326
query24 8577 2440 2402 2402
query25 524 478 399 399
query26 1163 275 154 154
query27 2913 507 338 338
query28 4741 2451 2435 2435
query29 677 570 468 468
query30 270 227 196 196
query31 926 898 805 805
query32 78 69 65 65
query33 568 376 340 340
query34 787 862 528 528
query35 806 863 753 753
query36 974 1013 917 917
query37 122 103 81 81
query38 4263 4310 4234 4234
query39 1501 1437 1460 1437
query40 224 135 118 118
query41 61 57 57 57
query42 123 114 111 111
query43 524 508 489 489
query44 1331 838 834 834
query45 189 177 173 173
query46 842 1045 674 674
query47 1897 1876 1774 1774
query48 389 420 325 325
query49 778 509 439 439
query50 676 714 399 399
query51 4269 4306 4281 4281
query52 114 110 108 108
query53 247 256 185 185
query54 586 595 519 519
query55 82 88 84 84
query56 326 309 297 297
query57 1203 1194 1118 1118
query58 263 264 259 259
query59 2776 2781 2695 2695
query60 342 335 305 305
query61 139 131 128 128
query62 761 734 693 693
query63 235 191 189 189
query64 4272 1090 735 735
query65 4421 4390 4352 4352
query66 949 399 306 306
query67 15581 15302 15153 15153
query68 8393 886 504 504
query69 485 293 274 274
query70 1203 1098 1124 1098
query71 488 320 294 294
query72 5840 4853 4991 4853
query73 723 748 352 352
query74 9153 9072 8907 8907
query75 3947 3192 2697 2697
query76 3800 1192 757 757
query77 796 358 284 284
query78 10043 10221 9261 9261
query79 2385 818 557 557
query80 723 516 440 440
query81 485 257 277 257
query82 479 126 97 97
query83 259 261 231 231
query84 244 108 84 84
query85 782 358 314 314
query86 373 299 293 293
query87 4545 4510 4318 4318
query88 3567 2211 2202 2202
query89 399 314 285 285
query90 1884 211 216 211
query91 146 144 109 109
query92 76 63 54 54
query93 1830 955 567 567
query94 662 410 301 301
query95 366 306 281 281
query96 482 561 272 272
query97 3141 3247 3114 3114
query98 244 214 201 201
query99 1419 1399 1252 1252
Total cold run time: 281251 ms
Total hot run time: 193254 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2797089797
<details>
<summary>TPC-H: <b>Total hot run time: 34199 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 3d643c66c40766f965ce15126ed5f551b02b6986, data reload: false
------ Round 1 ----------------------------------
q1 26009 5048 5062 5048
q2 2072 296 186 186
q3 10385 1237 694 694
q4 10212 1018 528 528
q5 7539 2347 2376 2347
q6 183 165 146 146
q7 908 734 598 598
q8 9325 1264 1091 1091
q9 6946 5149 5050 5050
q10 6818 2297 1879 1879
q11 468 288 276 276
q12 343 361 211 211
q13 17778 3635 3055 3055
q14 231 227 210 210
q15 549 512 517 512
q16 654 611 567 567
q17 587 854 353 353
q18 7580 7257 7226 7226
q19 1222 955 556 556
q20 341 328 215 215
q21 4298 2686 2484 2484
q22 1028 1008 967 967
Total cold run time: 115476 ms
Total hot run time: 34199 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5151 5087 5097 5087
q2 240 329 237 237
q3 2173 2672 2285 2285
q4 1444 1821 1411 1411
q5 4532 4461 4442 4442
q6 226 169 126 126
q7 1942 1966 1737 1737
q8 2610 2575 2515 2515
q9 7059 7148 7050 7050
q10 3003 3189 2746 2746
q11 573 505 489 489
q12 678 765 609 609
q13 3549 3896 3245 3245
q14 290 305 274 274
q15 537 501 514 501
q16 661 687 656 656
q17 1203 1556 1384 1384
q18 7713 7506 7266 7266
q19 841 820 898 820
q20 2021 2049 1888 1888
q21 5347 4802 4583 4583
q22 1064 1022 967 967
Total cold run time: 52857 ms
Total hot run time: 50318 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] [test](ut) add cases about hash join [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #49803:
URL: https://github.com/apache/doris/pull/49803
--
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2796524360
<details>
<summary>TPC-DS: <b>Total hot run time: 193329 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 d32ecb0e6813bcf6480386958214d083919c90f5, data reload: false
query1 1381 1095 1091 1091
query2 6179 1876 1882 1876
query3 10997 4677 4529 4529
query4 54793 25400 23722 23722
query5 5037 525 456 456
query6 333 193 187 187
query7 4896 492 286 286
query8 326 253 230 230
query9 5907 2595 2579 2579
query10 416 325 257 257
query11 15046 15017 14840 14840
query12 157 109 107 107
query13 1036 494 389 389
query14 10152 6388 6286 6286
query15 189 204 181 181
query16 7037 663 521 521
query17 1090 787 590 590
query18 1541 426 325 325
query19 202 197 169 169
query20 134 124 124 124
query21 211 126 109 109
query22 4494 4620 4385 4385
query23 34304 33620 33304 33304
query24 6632 2443 2462 2443
query25 462 467 402 402
query26 720 277 158 158
query27 2359 499 341 341
query28 3301 2469 2449 2449
query29 605 565 431 431
query30 282 233 195 195
query31 877 881 782 782
query32 70 66 60 60
query33 439 377 321 321
query34 771 861 541 541
query35 814 857 798 798
query36 947 1008 894 894
query37 115 116 73 73
query38 4264 4220 4283 4220
query39 1511 1420 1443 1420
query40 221 120 107 107
query41 53 52 50 50
query42 127 111 106 106
query43 508 514 482 482
query44 1319 821 845 821
query45 186 172 169 169
query46 875 1034 658 658
query47 1889 1863 1785 1785
query48 387 417 324 324
query49 692 499 430 430
query50 667 708 410 410
query51 4302 4276 4223 4223
query52 114 104 98 98
query53 239 264 186 186
query54 588 585 542 542
query55 81 88 83 83
query56 318 301 304 301
query57 1161 1202 1121 1121
query58 254 266 287 266
query59 2639 2824 2636 2636
query60 338 316 312 312
query61 127 123 127 123
query62 731 737 671 671
query63 224 183 184 183
query64 1856 1055 684 684
query65 4334 4278 4286 4278
query66 725 398 301 301
query67 15872 15841 15260 15260
query68 6869 870 514 514
query69 548 304 268 268
query70 1194 1058 1071 1058
query71 501 323 293 293
query72 5945 4887 5007 4887
query73 1449 743 350 350
query74 8944 9095 8694 8694
query75 3813 3221 2671 2671
query76 4246 1204 752 752
query77 638 370 290 290
query78 10140 9993 9279 9279
query79 2719 835 577 577
query80 628 515 420 420
query81 496 256 224 224
query82 468 126 101 101
query83 365 259 238 238
query84 292 101 82 82
query85 769 355 312 312
query86 381 301 291 291
query87 4358 4484 4315 4315
query88 3506 2239 2269 2239
query89 400 322 284 284
query90 1822 216 230 216
query91 159 151 111 111
query92 85 59 57 57
query93 2016 957 573 573
query94 647 461 302 302
query95 369 299 287 287
query96 495 586 279 279
query97 3189 3210 3165 3165
query98 229 212 211 211
query99 1436 1399 1308 1308
Total cold run time: 299970 ms
Total hot run time: 193329 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2798774610
<details>
<summary>TPC-H: <b>Total hot run time: 34422 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 d4d5ea245dba2ae101bb514678f3f869f4b930ae, data reload: false
------ Round 1 ----------------------------------
q1 26328 5168 5086 5086
q2 2065 278 186 186
q3 10433 1249 719 719
q4 10271 1021 561 561
q5 8254 2350 2427 2350
q6 198 167 136 136
q7 946 756 618 618
q8 9335 1312 1089 1089
q9 6883 5130 5139 5130
q10 6874 2318 1898 1898
q11 495 285 272 272
q12 353 357 224 224
q13 17787 3665 3106 3106
q14 231 225 217 217
q15 520 489 481 481
q16 623 623 598 598
q17 607 858 361 361
q18 7636 7157 7199 7157
q19 1600 943 587 587
q20 326 315 207 207
q21 4360 3388 2480 2480
q22 1029 1013 959 959
Total cold run time: 117154 ms
Total hot run time: 34422 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5201 5120 5130 5120
q2 243 331 230 230
q3 2160 2652 2261 2261
q4 1452 1971 1492 1492
q5 4536 4423 4371 4371
q6 217 161 128 128
q7 1958 1899 1764 1764
q8 2636 2606 2537 2537
q9 7217 7230 7354 7230
q10 3021 3183 2757 2757
q11 590 498 498 498
q12 723 773 623 623
q13 3534 3908 3327 3327
q14 265 302 265 265
q15 528 489 482 482
q16 667 719 660 660
q17 1165 1472 1382 1382
q18 7830 7494 7452 7452
q19 869 863 960 863
q20 1962 1972 1813 1813
q21 5191 4723 4715 4715
q22 1069 1046 993 993
Total cold run time: 53034 ms
Total hot run time: 50963 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] [test](ut) add cases about hash join [doris]
Posted by "mrhhsg (via GitHub)" <gi...@apache.org>.
mrhhsg commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2798767900
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] [test](ut) add cases about hash join [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2800287900
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] [test](ut) add cases about hash join [doris]
Posted by "mrhhsg (via GitHub)" <gi...@apache.org>.
mrhhsg commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2776026377
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2798778060
<details>
<summary>TPC-DS: <b>Total hot run time: 186427 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 d4d5ea245dba2ae101bb514678f3f869f4b930ae, data reload: false
query1 1012 488 547 488
query2 6526 1873 1835 1835
query3 6748 216 216 216
query4 26185 23641 23357 23357
query5 4326 644 498 498
query6 312 208 204 204
query7 4629 490 282 282
query8 303 248 267 248
query9 8601 2568 2583 2568
query10 482 344 259 259
query11 15947 15062 14857 14857
query12 159 109 110 109
query13 1647 534 395 395
query14 9275 6255 6289 6255
query15 210 209 169 169
query16 7181 618 464 464
query17 1203 720 591 591
query18 1975 395 292 292
query19 201 180 155 155
query20 119 124 113 113
query21 232 119 101 101
query22 4062 4161 4066 4066
query23 33909 32972 32939 32939
query24 8459 2411 2391 2391
query25 552 443 393 393
query26 1250 273 152 152
query27 2755 508 335 335
query28 4351 2429 2395 2395
query29 747 555 423 423
query30 287 221 189 189
query31 963 861 743 743
query32 72 68 63 63
query33 561 368 310 310
query34 810 862 551 551
query35 783 803 737 737
query36 927 965 904 904
query37 125 101 78 78
query38 4168 4249 4171 4171
query39 1451 1402 1388 1388
query40 213 121 108 108
query41 56 56 56 56
query42 126 104 105 104
query43 496 518 466 466
query44 1327 828 808 808
query45 181 172 171 171
query46 840 1015 623 623
query47 1738 1767 1716 1716
query48 362 420 293 293
query49 804 491 417 417
query50 655 674 407 407
query51 4320 4220 4179 4179
query52 105 106 103 103
query53 231 253 183 183
query54 577 585 502 502
query55 83 82 80 80
query56 316 303 292 292
query57 1177 1156 1054 1054
query58 262 264 269 264
query59 2634 2593 2568 2568
query60 354 318 310 310
query61 155 134 124 124
query62 833 756 664 664
query63 222 190 195 190
query64 4486 1112 773 773
query65 4335 4227 4283 4227
query66 1184 434 327 327
query67 15716 15278 15662 15278
query68 7893 879 509 509
query69 463 298 266 266
query70 1182 1117 1084 1084
query71 474 321 308 308
query72 5573 4717 4818 4717
query73 682 615 352 352
query74 8886 9091 8738 8738
query75 3794 3184 2700 2700
query76 3655 1184 743 743
query77 774 392 285 285
query78 10145 10144 9151 9151
query79 2835 809 575 575
query80 625 502 458 458
query81 485 261 221 221
query82 481 126 96 96
query83 292 246 227 227
query84 294 110 83 83
query85 793 349 305 305
query86 345 296 288 288
query87 4462 4460 4344 4344
query88 3392 2255 2247 2247
query89 407 318 285 285
query90 1972 218 218 218
query91 147 139 120 120
query92 73 60 56 56
query93 1721 967 575 575
query94 662 416 302 302
query95 380 300 277 277
query96 489 567 288 288
query97 3141 3265 3143 3143
query98 229 206 207 206
query99 1483 1400 1289 1289
Total cold run time: 275522 ms
Total hot run time: 186427 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2798801717
# BE UT Coverage Report
Increment line coverage `87.50% (7/8)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/d4d5ea245dba2ae101bb514678f3f869f4b930ae_d4d5ea245dba2ae101bb514678f3f869f4b930ae/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/d4d5ea245dba2ae101bb514678f3f869f4b930ae_d4d5ea245dba2ae101bb514678f3f869f4b930ae/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.38% (14083/26884) |
| Line Coverage | 41.31% (122053/295476) |
| Region Coverage | 40.02% (62089/155135) |
| Branch Coverage | 34.69% (31098/89656) |
--
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2797121358
<details>
<summary>TPC-DS: <b>Total hot run time: 185338 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 3d643c66c40766f965ce15126ed5f551b02b6986, data reload: false
query1 998 460 503 460
query2 6560 1905 1884 1884
query3 6743 221 221 221
query4 25847 23915 23339 23339
query5 4355 603 447 447
query6 286 196 189 189
query7 4619 506 277 277
query8 292 228 238 228
query9 8624 2583 2598 2583
query10 487 338 257 257
query11 15535 15053 14803 14803
query12 163 118 106 106
query13 1652 507 401 401
query14 8745 6086 6102 6086
query15 209 187 166 166
query16 7138 595 460 460
query17 921 725 548 548
query18 1963 387 293 293
query19 181 176 160 160
query20 117 114 118 114
query21 204 121 102 102
query22 4039 4047 3968 3968
query23 33845 32939 32913 32913
query24 8415 2340 2406 2340
query25 550 446 399 399
query26 1245 266 145 145
query27 2759 494 330 330
query28 4376 2389 2395 2389
query29 759 549 419 419
query30 285 217 202 202
query31 916 841 735 735
query32 75 68 63 63
query33 568 363 314 314
query34 786 848 504 504
query35 790 815 720 720
query36 950 999 880 880
query37 127 116 79 79
query38 4265 4179 4019 4019
query39 1427 1371 1405 1371
query40 214 116 104 104
query41 55 53 62 53
query42 122 105 102 102
query43 480 501 456 456
query44 1281 803 807 803
query45 181 171 171 171
query46 831 1020 643 643
query47 1712 1791 1713 1713
query48 371 414 296 296
query49 772 506 411 411
query50 652 671 402 402
query51 4150 4193 4071 4071
query52 111 100 93 93
query53 238 250 180 180
query54 582 566 503 503
query55 82 79 82 79
query56 304 322 302 302
query57 1158 1142 1065 1065
query58 290 257 253 253
query59 2615 2590 2540 2540
query60 327 306 332 306
query61 133 127 126 126
query62 783 715 670 670
query63 224 181 186 181
query64 4389 1017 683 683
query65 4282 4234 4214 4214
query66 1131 419 304 304
query67 15800 15266 15147 15147
query68 5418 890 517 517
query69 494 294 319 294
query70 1186 1111 1035 1035
query71 400 310 290 290
query72 5656 4734 4647 4647
query73 659 619 338 338
query74 9040 9365 8998 8998
query75 3174 3219 2676 2676
query76 3168 1162 736 736
query77 475 382 297 297
query78 9948 10231 9254 9254
query79 1700 856 551 551
query80 1210 518 453 453
query81 516 256 230 230
query82 402 130 106 106
query83 258 251 229 229
query84 297 101 77 77
query85 772 354 306 306
query86 322 315 275 275
query87 4405 4502 4336 4336
query88 2788 2215 2205 2205
query89 371 326 283 283
query90 1788 207 205 205
query91 147 145 112 112
query92 65 62 56 56
query93 1123 947 573 573
query94 689 387 307 307
query95 367 286 293 286
query96 498 566 275 275
query97 3101 3192 3115 3115
query98 230 213 200 200
query99 1306 1393 1291 1291
Total cold run time: 267059 ms
Total hot run time: 185338 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] [test](ut) add cases about hash join [doris]
Posted by "mrhhsg (via GitHub)" <gi...@apache.org>.
mrhhsg commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2795962043
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2787311502
# BE UT Coverage Report
Increment line coverage `85.71% (6/7)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/72fa93aafa6d36768bc2cc012ae31e7e9c4ab990_72fa93aafa6d36768bc2cc012ae31e7e9c4ab990/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/72fa93aafa6d36768bc2cc012ae31e7e9c4ab990_72fa93aafa6d36768bc2cc012ae31e7e9c4ab990/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.51% (14097/26845) |
| Line Coverage | 41.44% (122254/294995) |
| Region Coverage | 40.21% (62282/154898) |
| Branch Coverage | 34.92% (31266/89544) |
--
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] [test](ut) add cases about hash join [doris]
Posted by "mrhhsg (via GitHub)" <gi...@apache.org>.
mrhhsg commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2785885441
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2786002392
<details>
<summary>ClickBench: <b>Total hot run time: 30.82 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 d675c6696322aa4c8ab89f26a000ecfaecfd5b7e, data reload: false
query1 0.04 0.04 0.03
query2 0.12 0.11 0.11
query3 0.23 0.19 0.19
query4 1.59 0.20 0.20
query5 0.58 0.59 0.58
query6 1.18 0.71 0.72
query7 0.03 0.02 0.02
query8 0.04 0.04 0.03
query9 0.61 0.53 0.52
query10 0.58 0.58 0.56
query11 0.16 0.11 0.11
query12 0.14 0.11 0.11
query13 0.62 0.60 0.60
query14 2.70 2.74 2.70
query15 0.93 0.85 0.85
query16 0.39 0.39 0.39
query17 1.03 1.06 1.02
query18 0.22 0.20 0.20
query19 1.91 1.94 1.85
query20 0.01 0.01 0.01
query21 15.36 0.86 0.55
query22 0.73 1.18 0.62
query23 15.02 1.38 0.65
query24 7.40 1.61 0.44
query25 0.48 0.24 0.10
query26 0.57 0.15 0.13
query27 0.05 0.05 0.06
query28 9.77 0.86 0.43
query29 12.60 4.02 3.34
query30 0.25 0.09 0.06
query31 2.83 0.59 0.40
query32 3.25 0.54 0.46
query33 3.04 3.08 3.07
query34 15.76 5.12 4.45
query35 4.52 4.51 4.49
query36 0.70 0.50 0.48
query37 0.08 0.06 0.06
query38 0.05 0.04 0.04
query39 0.03 0.02 0.03
query40 0.17 0.13 0.13
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.04 0.03 0.02
Total cold run time: 105.92 s
Total hot run time: 30.82 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2798779619
<details>
<summary>ClickBench: <b>Total hot run time: 31.47 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 d4d5ea245dba2ae101bb514678f3f869f4b930ae, data reload: false
query1 0.04 0.04 0.02
query2 0.12 0.10 0.11
query3 0.25 0.20 0.20
query4 1.59 0.20 0.19
query5 0.61 0.60 0.59
query6 1.17 0.71 0.72
query7 0.02 0.02 0.02
query8 0.04 0.03 0.03
query9 0.58 0.54 0.52
query10 0.57 0.58 0.57
query11 0.16 0.11 0.11
query12 0.15 0.11 0.12
query13 0.62 0.59 0.59
query14 2.78 2.81 2.83
query15 0.94 0.86 0.88
query16 0.38 0.38 0.38
query17 1.02 1.02 1.03
query18 0.21 0.20 0.19
query19 1.87 1.96 1.81
query20 0.01 0.01 0.01
query21 15.40 0.90 0.53
query22 0.74 1.13 0.80
query23 14.85 1.41 0.62
query24 7.23 1.26 1.01
query25 0.45 0.19 0.10
query26 0.68 0.16 0.15
query27 0.05 0.04 0.05
query28 9.41 0.91 0.44
query29 12.57 4.05 3.29
query30 0.25 0.10 0.06
query31 2.82 0.59 0.38
query32 3.23 0.55 0.45
query33 3.10 3.00 3.16
query34 15.76 5.15 4.48
query35 4.50 4.53 4.47
query36 0.67 0.49 0.50
query37 0.09 0.07 0.06
query38 0.05 0.04 0.04
query39 0.03 0.02 0.02
query40 0.16 0.14 0.13
query41 0.08 0.03 0.02
query42 0.04 0.02 0.03
query43 0.04 0.04 0.03
Total cold run time: 105.33 s
Total hot run time: 31.47 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2796062377
<details>
<summary>TPC-H: <b>Total hot run time: 33888 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 07a95114e49761de827284fdfb42fb13fbaacd76, data reload: false
------ Round 1 ----------------------------------
q1 25967 5142 5001 5001
q2 2074 285 185 185
q3 10386 1239 684 684
q4 10393 1018 515 515
q5 7556 2428 2340 2340
q6 200 165 133 133
q7 930 744 626 626
q8 9312 1255 1033 1033
q9 7030 5116 5119 5116
q10 6873 2312 1887 1887
q11 491 283 288 283
q12 346 354 220 220
q13 17782 3677 3053 3053
q14 222 223 213 213
q15 531 489 493 489
q16 620 610 574 574
q17 599 845 359 359
q18 7628 7186 7012 7012
q19 1314 941 545 545
q20 346 343 229 229
q21 4243 3363 2395 2395
q22 1085 1053 996 996
Total cold run time: 115928 ms
Total hot run time: 33888 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5131 5066 5101 5066
q2 243 331 229 229
q3 2142 2656 2263 2263
q4 1419 1842 1484 1484
q5 4454 4405 4357 4357
q6 217 169 125 125
q7 1999 1907 1732 1732
q8 2616 2497 2563 2497
q9 7248 7174 7151 7151
q10 2966 3195 2759 2759
q11 577 496 492 492
q12 718 752 621 621
q13 3483 3914 3295 3295
q14 315 324 263 263
q15 526 476 461 461
q16 644 685 638 638
q17 1144 1592 1363 1363
q18 7759 7638 7420 7420
q19 806 928 1021 928
q20 1921 1961 1820 1820
q21 5307 4839 4784 4784
q22 1141 1070 1053 1053
Total cold run time: 52776 ms
Total hot run time: 50801 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2797134397
<details>
<summary>ClickBench: <b>Total hot run time: 30.47 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 3d643c66c40766f965ce15126ed5f551b02b6986, data reload: false
query1 0.04 0.04 0.03
query2 0.13 0.10 0.11
query3 0.26 0.18 0.19
query4 1.60 0.20 0.10
query5 0.56 0.57 0.56
query6 1.19 0.71 0.72
query7 0.03 0.02 0.02
query8 0.04 0.03 0.03
query9 0.59 0.53 0.51
query10 0.57 0.58 0.57
query11 0.16 0.11 0.11
query12 0.15 0.11 0.11
query13 0.62 0.59 0.59
query14 2.71 2.70 2.80
query15 0.92 0.84 0.88
query16 0.38 0.39 0.38
query17 1.03 1.01 1.05
query18 0.20 0.19 0.20
query19 2.08 1.84 1.76
query20 0.01 0.01 0.01
query21 15.35 0.91 0.55
query22 0.77 1.13 0.64
query23 15.01 1.41 0.64
query24 7.21 1.73 0.35
query25 0.29 0.24 0.13
query26 0.61 0.18 0.14
query27 0.06 0.06 0.05
query28 9.04 0.87 0.42
query29 12.53 3.98 3.30
query30 0.24 0.08 0.06
query31 2.83 0.60 0.38
query32 3.23 0.55 0.48
query33 3.05 3.03 3.04
query34 15.86 5.17 4.51
query35 4.50 4.52 4.47
query36 0.66 0.51 0.47
query37 0.08 0.06 0.06
query38 0.04 0.04 0.04
query39 0.03 0.02 0.02
query40 0.17 0.14 0.14
query41 0.08 0.03 0.03
query42 0.04 0.02 0.03
query43 0.04 0.03 0.03
Total cold run time: 104.99 s
Total hot run time: 30.47 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2797312039
# BE UT Coverage Report
Increment line coverage `87.50% (7/8)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/3d643c66c40766f965ce15126ed5f551b02b6986_3d643c66c40766f965ce15126ed5f551b02b6986/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/3d643c66c40766f965ce15126ed5f551b02b6986_3d643c66c40766f965ce15126ed5f551b02b6986/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.39% (14084/26884) |
| Line Coverage | 41.31% (122066/295476) |
| Region Coverage | 40.03% (62103/155135) |
| Branch Coverage | 34.69% (31099/89656) |
--
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2796492463
<details>
<summary>TPC-H: <b>Total hot run time: 34265 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 d32ecb0e6813bcf6480386958214d083919c90f5, data reload: false
------ Round 1 ----------------------------------
q1 26000 5065 5027 5027
q2 2061 274 176 176
q3 10410 1229 674 674
q4 10220 1012 519 519
q5 7572 2365 2338 2338
q6 187 162 131 131
q7 916 757 604 604
q8 9316 1246 1045 1045
q9 6877 5172 5127 5127
q10 6871 2271 1902 1902
q11 469 277 264 264
q12 351 361 220 220
q13 17767 3611 3105 3105
q14 229 221 211 211
q15 536 485 490 485
q16 638 635 580 580
q17 592 851 352 352
q18 7798 7303 7273 7273
q19 1215 969 551 551
q20 333 332 226 226
q21 4138 3367 2479 2479
q22 1071 993 976 976
Total cold run time: 115567 ms
Total hot run time: 34265 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5135 5090 5073 5073
q2 239 329 232 232
q3 2165 2622 2304 2304
q4 1443 1815 1454 1454
q5 4479 4419 4402 4402
q6 225 171 131 131
q7 1964 1884 1758 1758
q8 2603 2582 2547 2547
q9 7273 7197 7207 7197
q10 2963 3168 2770 2770
q11 586 524 484 484
q12 681 779 593 593
q13 3489 3855 3301 3301
q14 286 299 268 268
q15 514 505 472 472
q16 637 703 664 664
q17 1145 1550 1413 1413
q18 7713 7483 7390 7390
q19 830 789 848 789
q20 1959 1958 1824 1824
q21 5318 4831 4701 4701
q22 1073 1041 1002 1002
Total cold run time: 52720 ms
Total hot run time: 50769 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] [test](ut) add cases about hash join [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2788393035
# BE UT Coverage Report
Increment line coverage `85.71% (6/7)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/47ac59440ef538cb0a82c2f55a9ac580a053d037_47ac59440ef538cb0a82c2f55a9ac580a053d037/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/47ac59440ef538cb0a82c2f55a9ac580a053d037_47ac59440ef538cb0a82c2f55a9ac580a053d037/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.53% (14101/26846) |
| Line Coverage | 41.47% (122366/295082) |
| Region Coverage | 40.23% (62329/154930) |
| Branch Coverage | 34.95% (31300/89556) |
--
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] [test](ut) add cases about hash join [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2786403331
# BE UT Coverage Report
Increment line coverage `85.71% (6/7)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/d675c6696322aa4c8ab89f26a000ecfaecfd5b7e_d675c6696322aa4c8ab89f26a000ecfaecfd5b7e/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/d675c6696322aa4c8ab89f26a000ecfaecfd5b7e_d675c6696322aa4c8ab89f26a000ecfaecfd5b7e/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.49% (14091/26846) |
| Line Coverage | 41.45% (122290/295013) |
| Region Coverage | 40.20% (62278/154906) |
| Branch Coverage | 34.91% (31258/89542) |
--
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2776198536
<details>
<summary>TPC-DS: <b>Total hot run time: 193487 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 4a0adb27536f7e023a4dbd110fe5068d6be143af, data reload: false
query1 1391 1066 1038 1038
query2 6411 1923 1917 1917
query3 11038 4463 4396 4396
query4 53974 25285 23248 23248
query5 5144 507 467 467
query6 347 201 189 189
query7 4926 498 298 298
query8 329 251 234 234
query9 5825 2608 2601 2601
query10 426 323 280 280
query11 15234 15090 14971 14971
query12 162 112 102 102
query13 1032 509 386 386
query14 10147 6364 6349 6349
query15 200 181 178 178
query16 7040 642 459 459
query17 1107 731 627 627
query18 1556 398 314 314
query19 189 197 160 160
query20 125 140 128 128
query21 205 123 108 108
query22 4518 4406 4412 4406
query23 34031 33169 33254 33169
query24 6423 2436 2451 2436
query25 460 465 406 406
query26 726 277 155 155
query27 2259 487 333 333
query28 3263 2443 2449 2443
query29 630 565 439 439
query30 270 231 193 193
query31 891 869 821 821
query32 76 68 64 64
query33 462 366 310 310
query34 814 842 558 558
query35 819 836 796 796
query36 964 971 897 897
query37 146 109 83 83
query38 4252 4260 4177 4177
query39 1504 1419 1445 1419
query40 211 129 108 108
query41 55 52 51 51
query42 127 112 108 108
query43 511 516 493 493
query44 1387 828 848 828
query45 188 180 180 180
query46 878 1066 709 709
query47 1795 1914 1800 1800
query48 390 441 315 315
query49 713 534 445 445
query50 687 706 403 403
query51 4245 4299 4222 4222
query52 115 109 97 97
query53 242 273 197 197
query54 605 583 509 509
query55 80 80 81 80
query56 313 325 287 287
query57 1202 1159 1121 1121
query58 264 285 286 285
query59 2735 2777 2850 2777
query60 340 331 321 321
query61 150 135 132 132
query62 732 758 665 665
query63 242 194 195 194
query64 2319 1117 729 729
query65 4499 4307 4248 4248
query66 1147 399 305 305
query67 15947 15650 15359 15359
query68 9316 731 515 515
query69 565 307 272 272
query70 1232 1125 1093 1093
query71 487 324 282 282
query72 6675 4968 5070 4968
query73 1153 738 367 367
query74 9094 8819 8625 8625
query75 4234 3202 2743 2743
query76 5805 1198 792 792
query77 718 472 278 278
query78 10159 10452 9548 9548
query79 12875 676 560 560
query80 1782 531 437 437
query81 483 264 217 217
query82 472 135 105 105
query83 388 252 246 246
query84 301 113 93 93
query85 820 351 321 321
query86 323 323 292 292
query87 4373 4569 4276 4276
query88 3216 2236 2364 2236
query89 458 314 293 293
query90 2585 216 218 216
query91 143 142 111 111
query92 79 62 55 55
query93 4593 901 581 581
query94 897 401 301 301
query95 380 298 298 298
query96 494 563 276 276
query97 3063 3240 3077 3077
query98 222 214 206 206
query99 1381 1388 1284 1284
Total cold run time: 320201 ms
Total hot run time: 193487 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] [test](ut) add cases about hash join [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2775284412
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2789956796
<details>
<summary>TPC-H: <b>Total hot run time: 34388 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 47ac59440ef538cb0a82c2f55a9ac580a053d037, data reload: false
------ Round 1 ----------------------------------
q1 26153 5186 5014 5014
q2 2076 284 189 189
q3 10654 1273 702 702
q4 10294 1043 550 550
q5 8844 2326 2416 2326
q6 196 163 131 131
q7 953 739 607 607
q8 9300 1402 1078 1078
q9 7042 5163 5126 5126
q10 6819 2297 1912 1912
q11 491 301 276 276
q12 350 354 215 215
q13 17809 3717 3142 3142
q14 222 231 210 210
q15 522 488 475 475
q16 637 619 578 578
q17 618 882 384 384
q18 7701 7228 7193 7193
q19 1257 948 573 573
q20 357 342 231 231
q21 4351 3546 2507 2507
q22 1019 1021 969 969
Total cold run time: 117665 ms
Total hot run time: 34388 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5147 5150 5111 5111
q2 255 334 237 237
q3 2192 2682 2329 2329
q4 1489 1972 1504 1504
q5 4583 4446 4396 4396
q6 212 157 121 121
q7 1977 1905 1770 1770
q8 2572 2706 2597 2597
q9 7247 7149 7229 7149
q10 2958 3161 2753 2753
q11 608 494 494 494
q12 670 754 585 585
q13 3524 3931 3375 3375
q14 278 283 286 283
q15 525 483 504 483
q16 633 698 641 641
q17 1171 1617 1361 1361
q18 7844 7517 7413 7413
q19 800 831 1051 831
q20 1927 1946 1859 1859
q21 5149 4706 4714 4706
q22 1054 1017 959 959
Total cold run time: 52815 ms
Total hot run time: 50957 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2790007808
<details>
<summary>ClickBench: <b>Total hot run time: 30.73 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 47ac59440ef538cb0a82c2f55a9ac580a053d037, data reload: false
query1 0.04 0.04 0.04
query2 0.14 0.10 0.11
query3 0.25 0.19 0.19
query4 1.60 0.20 0.19
query5 0.59 0.59 0.60
query6 1.20 0.71 0.71
query7 0.02 0.02 0.02
query8 0.05 0.03 0.03
query9 0.57 0.52 0.50
query10 0.60 0.58 0.58
query11 0.15 0.11 0.11
query12 0.15 0.11 0.12
query13 0.62 0.61 0.61
query14 2.69 2.73 2.75
query15 0.92 0.85 0.85
query16 0.38 0.37 0.36
query17 1.02 1.06 1.03
query18 0.21 0.19 0.20
query19 1.91 1.96 1.80
query20 0.01 0.01 0.01
query21 15.35 0.89 0.54
query22 0.74 1.11 0.73
query23 14.92 1.39 0.61
query24 7.63 1.08 0.38
query25 0.42 0.23 0.06
query26 0.61 0.16 0.14
query27 0.06 0.05 0.05
query28 8.90 0.88 0.42
query29 12.58 3.99 3.34
query30 0.24 0.09 0.07
query31 2.82 0.58 0.38
query32 3.22 0.53 0.47
query33 3.02 3.09 3.03
query34 15.78 5.07 4.43
query35 4.53 4.54 4.52
query36 0.67 0.50 0.48
query37 0.09 0.06 0.06
query38 0.06 0.04 0.04
query39 0.04 0.02 0.02
query40 0.17 0.14 0.13
query41 0.08 0.03 0.03
query42 0.04 0.02 0.03
query43 0.04 0.04 0.03
Total cold run time: 105.13 s
Total hot run time: 30.73 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2796095921
<details>
<summary>ClickBench: <b>Total hot run time: 31.15 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 07a95114e49761de827284fdfb42fb13fbaacd76, data reload: false
query1 0.04 0.03 0.04
query2 0.12 0.10 0.10
query3 0.25 0.20 0.20
query4 1.60 0.20 0.19
query5 0.61 0.59 0.62
query6 1.19 0.72 0.73
query7 0.03 0.01 0.02
query8 0.04 0.03 0.03
query9 0.57 0.53 0.54
query10 0.57 0.58 0.56
query11 0.15 0.11 0.12
query12 0.15 0.12 0.11
query13 0.62 0.60 0.60
query14 2.66 2.80 2.68
query15 0.93 0.85 0.86
query16 0.39 0.38 0.39
query17 1.04 1.06 0.98
query18 0.21 0.20 0.20
query19 1.84 1.96 1.82
query20 0.02 0.01 0.01
query21 15.35 0.91 0.55
query22 0.75 1.12 0.69
query23 15.06 1.40 0.64
query24 6.93 1.82 0.70
query25 0.49 0.12 0.20
query26 0.62 0.17 0.13
query27 0.06 0.06 0.05
query28 9.13 0.89 0.44
query29 12.53 4.04 3.34
query30 0.25 0.09 0.06
query31 2.83 0.61 0.39
query32 3.23 0.54 0.46
query33 3.07 3.02 3.03
query34 15.73 5.13 4.52
query35 4.56 4.57 4.52
query36 0.69 0.49 0.49
query37 0.08 0.06 0.07
query38 0.06 0.04 0.04
query39 0.03 0.02 0.02
query40 0.18 0.14 0.14
query41 0.07 0.02 0.03
query42 0.03 0.02 0.02
query43 0.04 0.03 0.03
Total cold run time: 104.8 s
Total hot run time: 31.15 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] [test](ut) add cases about hash join [doris]
Posted by "mrhhsg (via GitHub)" <gi...@apache.org>.
mrhhsg commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2796374574
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] [test](ut) add cases about hash join [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2776426781
# BE UT Coverage Report
Increment line coverage ` ` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/4a0adb27536f7e023a4dbd110fe5068d6be143af_4a0adb27536f7e023a4dbd110fe5068d6be143af/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/4a0adb27536f7e023a4dbd110fe5068d6be143af_4a0adb27536f7e023a4dbd110fe5068d6be143af/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.37% (14035/26799) |
| Line Coverage | 41.23% (121380/294364) |
| Region Coverage | 39.98% (61798/154566) |
| Branch Coverage | 34.63% (30911/89262) |
--
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2775410993
<details>
<summary>ClickBench: <b>Total hot run time: 31.6 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 4a46713dcf800efe01d3ec6a0e51a1c635ea8678, data reload: false
query1 0.04 0.05 0.03
query2 0.12 0.11 0.11
query3 0.25 0.19 0.19
query4 1.59 0.20 0.19
query5 0.57 0.56 0.55
query6 1.19 0.71 0.72
query7 0.02 0.02 0.01
query8 0.05 0.03 0.03
query9 0.57 0.52 0.52
query10 0.59 0.58 0.57
query11 0.16 0.10 0.10
query12 0.15 0.12 0.12
query13 0.63 0.59 0.61
query14 2.69 2.73 2.81
query15 0.93 0.83 0.85
query16 0.39 0.38 0.38
query17 1.03 1.04 1.02
query18 0.22 0.20 0.20
query19 2.01 1.88 1.88
query20 0.02 0.01 0.01
query21 15.38 0.90 0.57
query22 0.76 1.14 0.62
query23 15.02 1.38 0.66
query24 6.79 1.63 1.29
query25 0.52 0.08 0.12
query26 0.62 0.16 0.13
query27 0.05 0.04 0.05
query28 9.63 0.86 0.42
query29 12.64 4.01 3.30
query30 0.25 0.09 0.06
query31 2.83 0.60 0.37
query32 3.22 0.54 0.48
query33 3.03 3.10 3.02
query34 15.83 5.12 4.51
query35 4.59 4.51 4.52
query36 0.66 0.50 0.47
query37 0.09 0.06 0.06
query38 0.05 0.04 0.04
query39 0.03 0.02 0.02
query40 0.17 0.14 0.12
query41 0.07 0.03 0.02
query42 0.03 0.02 0.02
query43 0.04 0.04 0.02
Total cold run time: 105.52 s
Total hot run time: 31.6 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] [test](ut) add cases about hash join [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2800287936
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] [test](ut) add cases about hash join [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2796167609
# BE UT Coverage Report
Increment line coverage `87.50% (7/8)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/07a95114e49761de827284fdfb42fb13fbaacd76_07a95114e49761de827284fdfb42fb13fbaacd76/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/07a95114e49761de827284fdfb42fb13fbaacd76_07a95114e49761de827284fdfb42fb13fbaacd76/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.38% (14083/26887) |
| Line Coverage | 41.31% (122084/295537) |
| Region Coverage | 40.02% (62105/155184) |
| Branch Coverage | 34.70% (31120/89694) |
--
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2796535111
<details>
<summary>ClickBench: <b>Total hot run time: 30.98 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 d32ecb0e6813bcf6480386958214d083919c90f5, data reload: false
query1 0.04 0.04 0.03
query2 0.13 0.10 0.11
query3 0.27 0.19 0.20
query4 1.59 0.19 0.19
query5 0.60 0.58 0.59
query6 1.18 0.70 0.72
query7 0.02 0.02 0.02
query8 0.04 0.04 0.04
query9 0.57 0.52 0.52
query10 0.57 0.57 0.56
query11 0.15 0.10 0.11
query12 0.15 0.11 0.11
query13 0.62 0.60 0.59
query14 2.68 2.70 2.70
query15 0.91 0.87 0.84
query16 0.38 0.38 0.40
query17 1.02 1.05 1.02
query18 0.20 0.20 0.19
query19 1.88 1.80 1.91
query20 0.02 0.01 0.01
query21 15.37 0.89 0.55
query22 0.74 1.35 0.91
query23 14.70 1.37 0.62
query24 7.04 1.09 0.60
query25 0.50 0.26 0.08
query26 0.66 0.16 0.13
query27 0.05 0.05 0.05
query28 9.86 0.92 0.42
query29 12.54 4.05 3.32
query30 0.25 0.09 0.06
query31 2.84 0.59 0.37
query32 3.23 0.55 0.47
query33 3.01 3.02 3.03
query34 15.84 5.16 4.41
query35 4.51 4.49 4.50
query36 0.69 0.49 0.49
query37 0.08 0.06 0.06
query38 0.05 0.04 0.03
query39 0.03 0.03 0.02
query40 0.16 0.14 0.14
query41 0.08 0.03 0.02
query42 0.03 0.02 0.02
query43 0.04 0.03 0.03
Total cold run time: 105.32 s
Total hot run time: 30.98 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2790441566
# BE UT Coverage Report
Increment line coverage `85.71% (6/7)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/47ac59440ef538cb0a82c2f55a9ac580a053d037_47ac59440ef538cb0a82c2f55a9ac580a053d037/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/47ac59440ef538cb0a82c2f55a9ac580a053d037_47ac59440ef538cb0a82c2f55a9ac580a053d037/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.60% (14137/26877) |
| Line Coverage | 41.57% (122833/295518) |
| Region Coverage | 40.30% (62534/155174) |
| Branch Coverage | 35.01% (31410/89712) |
--
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2796705006
# BE UT Coverage Report
Increment line coverage `87.50% (7/8)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/d32ecb0e6813bcf6480386958214d083919c90f5_d32ecb0e6813bcf6480386958214d083919c90f5/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/d32ecb0e6813bcf6480386958214d083919c90f5_d32ecb0e6813bcf6480386958214d083919c90f5/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 52.39% (14084/26884) |
| Line Coverage | 41.33% (122108/295476) |
| Region Coverage | 40.03% (62102/155135) |
| Branch Coverage | 34.69% (31105/89656) |
--
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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2785989093
<details>
<summary>TPC-DS: <b>Total hot run time: 186864 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 d675c6696322aa4c8ab89f26a000ecfaecfd5b7e, data reload: false
query1 1017 496 457 457
query2 6546 1952 1903 1903
query3 6751 217 222 217
query4 26303 23529 23320 23320
query5 4299 632 487 487
query6 322 213 198 198
query7 4628 524 283 283
query8 298 251 253 251
query9 8630 2605 2606 2605
query10 459 330 284 284
query11 15789 15296 14983 14983
query12 178 110 113 110
query13 1654 535 396 396
query14 9539 6121 6184 6121
query15 223 189 165 165
query16 7258 628 451 451
query17 1203 745 586 586
query18 1976 418 339 339
query19 206 185 162 162
query20 125 118 116 116
query21 218 128 107 107
query22 4344 4471 4279 4279
query23 33877 32834 32814 32814
query24 8446 2400 2393 2393
query25 525 443 388 388
query26 1231 264 148 148
query27 2746 511 331 331
query28 4363 2401 2385 2385
query29 742 565 426 426
query30 288 217 191 191
query31 999 851 789 789
query32 76 65 65 65
query33 555 365 336 336
query34 802 846 530 530
query35 777 833 736 736
query36 976 999 910 910
query37 123 100 76 76
query38 4122 4037 4049 4037
query39 1459 1421 1420 1420
query40 217 119 111 111
query41 55 53 56 53
query42 125 105 110 105
query43 511 505 490 490
query44 1316 800 807 800
query45 181 170 166 166
query46 836 1038 632 632
query47 1731 1813 1725 1725
query48 365 427 328 328
query49 779 507 412 412
query50 634 698 406 406
query51 4124 4237 4081 4081
query52 111 111 97 97
query53 224 252 180 180
query54 570 593 498 498
query55 88 81 80 80
query56 289 290 302 290
query57 1133 1146 1093 1093
query58 264 257 256 256
query59 2628 2696 2658 2658
query60 356 326 305 305
query61 131 134 138 134
query62 774 734 672 672
query63 220 186 188 186
query64 4284 1024 686 686
query65 4400 4234 4256 4234
query66 1130 416 309 309
query67 15815 15591 15414 15414
query68 7793 891 518 518
query69 461 309 255 255
query70 1175 1107 1087 1087
query71 458 307 298 298
query72 5702 4773 4968 4773
query73 761 696 352 352
query74 8980 9188 8914 8914
query75 3858 3215 2713 2713
query76 3762 1198 764 764
query77 782 377 290 290
query78 10023 9993 9224 9224
query79 3160 845 552 552
query80 700 513 443 443
query81 501 256 222 222
query82 489 126 94 94
query83 297 252 242 242
query84 293 110 85 85
query85 854 349 314 314
query86 388 304 284 284
query87 4567 4625 4254 4254
query88 3506 2191 2201 2191
query89 402 318 277 277
query90 1873 215 211 211
query91 144 152 112 112
query92 84 59 55 55
query93 2172 967 578 578
query94 670 420 300 300
query95 376 298 287 287
query96 488 576 267 267
query97 3160 3262 3205 3205
query98 236 210 205 205
query99 1448 1417 1302 1302
Total cold run time: 276927 ms
Total hot run time: 186864 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2789992117
<details>
<summary>TPC-DS: <b>Total hot run time: 186477 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 47ac59440ef538cb0a82c2f55a9ac580a053d037, data reload: false
query1 1018 479 473 473
query2 6530 1952 1948 1948
query3 6761 216 216 216
query4 26486 23483 23534 23483
query5 4348 622 466 466
query6 306 226 191 191
query7 4621 484 280 280
query8 300 252 244 244
query9 8619 2577 2588 2577
query10 487 317 284 284
query11 15333 15022 14839 14839
query12 157 111 107 107
query13 1658 525 370 370
query14 9297 6125 6118 6118
query15 207 178 165 165
query16 7175 649 484 484
query17 1202 694 553 553
query18 1970 389 300 300
query19 182 177 154 154
query20 117 115 114 114
query21 209 122 102 102
query22 4038 4317 4017 4017
query23 33779 32866 32912 32866
query24 8393 2394 2398 2394
query25 511 438 397 397
query26 1215 274 154 154
query27 2743 497 330 330
query28 4337 2407 2420 2407
query29 746 565 425 425
query30 282 227 190 190
query31 951 868 747 747
query32 75 67 67 67
query33 565 368 309 309
query34 789 846 506 506
query35 798 824 758 758
query36 937 982 895 895
query37 115 105 80 80
query38 4089 4060 4213 4060
query39 1440 1399 1408 1399
query40 214 120 109 109
query41 59 52 52 52
query42 115 103 105 103
query43 504 493 483 483
query44 1319 813 807 807
query45 175 171 172 171
query46 830 1028 616 616
query47 1748 1755 1677 1677
query48 382 406 314 314
query49 789 511 444 444
query50 654 735 405 405
query51 4167 4272 4042 4042
query52 106 102 96 96
query53 228 260 189 189
query54 611 584 510 510
query55 86 89 89 89
query56 342 327 294 294
query57 1144 1136 1076 1076
query58 273 270 269 269
query59 2741 2859 2610 2610
query60 318 312 309 309
query61 129 125 125 125
query62 806 737 666 666
query63 222 182 186 182
query64 4340 1022 749 749
query65 4297 4248 4264 4248
query66 1166 418 323 323
query67 15885 15594 15309 15309
query68 7627 872 513 513
query69 473 292 254 254
query70 1205 1109 1099 1099
query71 467 308 304 304
query72 5570 4738 4818 4738
query73 679 613 339 339
query74 9001 9071 8864 8864
query75 3808 3192 2735 2735
query76 3584 1204 747 747
query77 772 369 297 297
query78 10001 10130 9356 9356
query79 1977 809 559 559
query80 571 510 435 435
query81 471 257 221 221
query82 464 127 99 99
query83 257 254 242 242
query84 238 110 91 91
query85 875 360 314 314
query86 335 304 285 285
query87 4389 4569 4295 4295
query88 3549 2207 2189 2189
query89 388 318 284 284
query90 1963 212 211 211
query91 145 140 117 117
query92 74 59 61 59
query93 1304 949 584 584
query94 647 413 309 309
query95 373 300 279 279
query96 483 573 278 278
query97 3210 3256 3136 3136
query98 233 204 200 200
query99 1373 1382 1308 1308
Total cold run time: 272942 ms
Total hot run time: 186477 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2775358158
<details>
<summary>TPC-H: <b>Total hot run time: 35033 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 4a46713dcf800efe01d3ec6a0e51a1c635ea8678, data reload: false
------ Round 1 ----------------------------------
q1 25630 5145 5056 5056
q2 2065 272 182 182
q3 10399 1259 694 694
q4 10221 1032 534 534
q5 7534 2388 2367 2367
q6 184 162 130 130
q7 921 758 612 612
q8 9317 1316 1082 1082
q9 6849 5158 5161 5158
q10 6810 2316 1915 1915
q11 493 289 262 262
q12 344 357 218 218
q13 17784 3733 3082 3082
q14 234 223 217 217
q15 542 495 497 495
q16 625 609 588 588
q17 571 849 354 354
q18 7858 7221 7171 7171
q19 1217 945 554 554
q20 343 340 221 221
q21 4132 3421 3169 3169
q22 1068 1027 972 972
Total cold run time: 115141 ms
Total hot run time: 35033 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5143 5067 5106 5067
q2 233 332 226 226
q3 2191 2668 2307 2307
q4 1457 1864 1523 1523
q5 4553 4498 4371 4371
q6 202 163 122 122
q7 1989 1870 1743 1743
q8 2578 2546 2521 2521
q9 7239 7134 7122 7122
q10 2988 3196 2766 2766
q11 568 522 488 488
q12 668 752 626 626
q13 3504 3968 3266 3266
q14 280 284 263 263
q15 540 501 483 483
q16 648 684 645 645
q17 1132 1489 1364 1364
q18 7837 7452 7416 7416
q19 796 803 863 803
q20 1941 1971 1841 1841
q21 5307 4700 4729 4700
q22 1107 1032 1033 1032
Total cold run time: 52901 ms
Total hot run time: 50695 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2775399163
<details>
<summary>TPC-DS: <b>Total hot run time: 186469 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 4a46713dcf800efe01d3ec6a0e51a1c635ea8678, data reload: false
query1 1004 486 467 467
query2 6531 1924 1924 1924
query3 6762 227 217 217
query4 26632 23134 23238 23134
query5 4329 644 453 453
query6 311 206 202 202
query7 4630 490 281 281
query8 311 248 250 248
query9 8621 2607 2622 2607
query10 486 309 266 266
query11 15197 15351 14851 14851
query12 163 115 110 110
query13 1658 524 396 396
query14 8827 6179 6158 6158
query15 213 189 166 166
query16 7213 643 476 476
query17 1209 727 583 583
query18 1989 407 304 304
query19 197 202 182 182
query20 124 116 117 116
query21 206 127 109 109
query22 4207 4258 4200 4200
query23 33919 32941 32983 32941
query24 8420 2371 2382 2371
query25 535 440 387 387
query26 1241 267 149 149
query27 2768 497 324 324
query28 4321 2396 2405 2396
query29 811 546 422 422
query30 281 223 199 199
query31 931 855 762 762
query32 69 68 62 62
query33 560 370 308 308
query34 791 857 505 505
query35 828 797 745 745
query36 957 998 876 876
query37 129 105 75 75
query38 4195 4151 4136 4136
query39 1496 1401 1562 1401
query40 212 119 105 105
query41 55 54 53 53
query42 133 108 108 108
query43 491 499 485 485
query44 1300 806 799 799
query45 173 168 165 165
query46 832 1029 615 615
query47 1762 1794 1731 1731
query48 368 406 295 295
query49 786 519 419 419
query50 634 668 400 400
query51 4157 4143 4140 4140
query52 107 105 101 101
query53 227 247 181 181
query54 567 581 499 499
query55 84 87 81 81
query56 289 325 293 293
query57 1159 1145 1089 1089
query58 265 250 267 250
query59 2718 2823 2684 2684
query60 321 322 294 294
query61 132 125 128 125
query62 778 709 656 656
query63 215 178 189 178
query64 4479 1023 697 697
query65 4366 4234 4272 4234
query66 1159 418 309 309
query67 15978 15688 15414 15414
query68 8378 893 518 518
query69 476 312 266 266
query70 1228 1145 1060 1060
query71 500 321 294 294
query72 5581 4716 4727 4716
query73 729 598 347 347
query74 8960 9100 8944 8944
query75 3954 3171 2706 2706
query76 3744 1264 768 768
query77 801 363 296 296
query78 10152 9954 9239 9239
query79 2168 874 566 566
query80 572 571 427 427
query81 491 259 220 220
query82 500 126 103 103
query83 250 263 239 239
query84 244 113 85 85
query85 807 364 320 320
query86 385 304 283 283
query87 4503 4511 4271 4271
query88 3650 2194 2208 2194
query89 378 317 281 281
query90 1860 219 210 210
query91 147 145 112 112
query92 76 62 59 59
query93 1598 945 580 580
query94 674 419 305 305
query95 373 291 285 285
query96 476 561 278 278
query97 3260 3206 3098 3098
query98 237 207 203 203
query99 1392 1412 1287 1287
Total cold run time: 275363 ms
Total hot run time: 186469 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] [test](ut) add cases about hash join [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49803:
URL: https://github.com/apache/doris/pull/49803#issuecomment-2776213598
<details>
<summary>ClickBench: <b>Total hot run time: 31.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 4a0adb27536f7e023a4dbd110fe5068d6be143af, data reload: false
query1 0.04 0.03 0.03
query2 0.13 0.11 0.11
query3 0.26 0.19 0.20
query4 1.59 0.19 0.20
query5 0.60 0.58 0.59
query6 1.18 0.72 0.71
query7 0.02 0.02 0.01
query8 0.04 0.03 0.04
query9 0.60 0.51 0.51
query10 0.57 0.58 0.58
query11 0.15 0.11 0.11
query12 0.15 0.11 0.11
query13 0.62 0.60 0.61
query14 2.77 2.71 2.83
query15 0.93 0.84 0.84
query16 0.38 0.37 0.39
query17 1.03 1.04 1.04
query18 0.22 0.20 0.19
query19 1.88 1.88 1.88
query20 0.01 0.02 0.01
query21 15.35 0.91 0.56
query22 0.75 1.10 0.93
query23 14.72 1.40 0.63
query24 6.96 1.63 1.05
query25 0.49 0.18 0.05
query26 0.53 0.17 0.14
query27 0.05 0.05 0.05
query28 9.38 0.87 0.43
query29 12.52 3.98 3.26
query30 0.24 0.09 0.06
query31 2.82 0.58 0.39
query32 3.24 0.55 0.47
query33 3.06 3.03 3.01
query34 15.54 5.14 4.42
query35 4.49 4.48 4.53
query36 0.67 0.50 0.47
query37 0.09 0.06 0.06
query38 0.05 0.04 0.04
query39 0.03 0.02 0.02
query40 0.17 0.14 0.14
query41 0.09 0.02 0.02
query42 0.04 0.02 0.02
query43 0.04 0.04 0.02
Total cold run time: 104.49 s
Total hot run time: 31.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