doris
doris copied to clipboard
apache
[chore](ci) fix some pipeline script
What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
Release note
None
Check List (For Author)
-
Test
- [ ] 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
-
Behavior changed:
- [ ] No.
- [ ] Yes.
-
Does this need documentation?
- [ ] No.
- [ ] Yes.
Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label
Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR.
Please clearly describe your PR:
- What problem was fixed (it's best to include specific error reporting information). How it was fixed.
- Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
- What features were added. Why was this function added?
- Which code was refactored and why was this part of the code refactored?
- Which functions were optimized and what is the difference before and after the optimization?
TPC-H: Total hot run time: 39767 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 0149db38bfdde42ef1886a718b605b9a5b96882e, data reload: false
------ Round 1 ----------------------------------
q1 17625 6716 6556 6556
q2 2054 164 164 164
q3 10762 1059 1191 1059
q4 10526 686 669 669
q5 7747 2820 2791 2791
q6 209 133 129 129
q7 966 613 593 593
q8 9348 1925 1995 1925
q9 6572 6454 6448 6448
q10 7043 2290 2273 2273
q11 462 261 247 247
q12 437 204 203 203
q13 17800 2993 2982 2982
q14 225 205 206 205
q15 516 458 457 457
q16 501 369 370 369
q17 974 624 595 595
q18 7327 6762 6709 6709
q19 1396 1085 1033 1033
q20 478 203 204 203
q21 4266 3176 3152 3152
q22 1103 1005 1005 1005
Total cold run time: 108337 ms
Total hot run time: 39767 ms
----- Round 2, with runtime_filter_mode=off -----
q1 6564 6517 6522 6517
q2 330 231 231 231
q3 2907 2733 2819 2733
q4 2016 1791 1777 1777
q5 5781 5679 5747 5679
q6 209 128 130 128
q7 2210 1763 1833 1763
q8 3341 3588 3522 3522
q9 8972 8713 8825 8713
q10 3567 3558 3507 3507
q11 596 503 481 481
q12 807 614 590 590
q13 10678 3163 3228 3163
q14 304 259 253 253
q15 510 477 463 463
q16 478 427 427 427
q17 1827 1601 1612 1601
q18 8125 7870 7730 7730
q19 1678 1532 1575 1532
q20 2081 1834 1812 1812
q21 5175 4925 4995 4925
q22 1140 1064 1028 1028
Total cold run time: 69296 ms
Total hot run time: 58575 ms
TPC-DS: Total hot run time: 198018 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 0149db38bfdde42ef1886a718b605b9a5b96882e, data reload: false
query1 1285 895 894 894
query2 6292 1939 1920 1920
query3 10986 4627 4521 4521
query4 61108 29418 23658 23658
query5 5249 458 439 439
query6 380 175 185 175
query7 5430 313 314 313
query8 316 237 225 225
query9 8263 2591 2577 2577
query10 442 282 263 263
query11 17472 15330 15525 15330
query12 157 101 106 101
query13 1465 461 440 440
query14 10384 6880 7181 6880
query15 206 179 178 178
query16 7113 496 523 496
query17 1166 604 589 589
query18 1876 338 321 321
query19 210 173 160 160
query20 119 109 118 109
query21 215 108 103 103
query22 4615 4499 4627 4499
query23 34983 34570 34307 34307
query24 6219 2939 2928 2928
query25 586 426 430 426
query26 715 172 168 168
query27 1996 373 355 355
query28 3996 2166 2126 2126
query29 725 481 429 429
query30 244 157 160 157
query31 1017 798 832 798
query32 65 58 56 56
query33 473 289 301 289
query34 948 509 512 509
query35 854 764 736 736
query36 1061 962 987 962
query37 108 67 67 67
query38 4080 3901 3971 3901
query39 1534 1479 1489 1479
query40 204 96 101 96
query41 50 49 49 49
query42 113 98 100 98
query43 540 510 501 501
query44 1168 813 804 804
query45 184 167 173 167
query46 1146 746 729 729
query47 2040 1925 1945 1925
query48 481 372 372 372
query49 731 405 394 394
query50 824 432 448 432
query51 7511 7318 7323 7318
query52 106 89 87 87
query53 259 182 180 180
query54 562 477 490 477
query55 77 81 78 78
query56 269 245 238 238
query57 1331 1228 1221 1221
query58 222 216 230 216
query59 3365 3307 3382 3307
query60 285 267 265 265
query61 124 111 156 111
query62 772 673 669 669
query63 214 190 192 190
query64 1746 688 641 641
query65 3238 3195 3197 3195
query66 713 290 297 290
query67 15888 15419 15811 15419
query68 3392 577 579 577
query69 418 263 264 263
query70 1170 1062 1072 1062
query71 370 237 249 237
query72 6235 4131 3989 3989
query73 764 344 352 344
query74 10202 9195 9267 9195
query75 3338 2639 2679 2639
query76 2068 1065 1072 1065
query77 550 276 263 263
query78 10658 9646 9638 9638
query79 1514 594 603 594
query80 859 418 430 418
query81 495 220 216 216
query82 1267 93 84 84
query83 265 151 141 141
query84 279 81 75 75
query85 943 295 293 293
query86 325 295 302 295
query87 4435 4211 4251 4211
query88 3775 2423 2395 2395
query89 414 292 292 292
query90 1992 183 186 183
query91 186 151 152 151
query92 63 47 49 47
query93 1895 547 545 545
query94 725 308 296 296
query95 343 281 254 254
query96 621 284 287 284
query97 3338 3154 3130 3130
query98 225 210 203 203
query99 1522 1314 1286 1286
Total cold run time: 313162 ms
Total hot run time: 198018 ms
ClickBench: Total hot run time: 30.43 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 0149db38bfdde42ef1886a718b605b9a5b96882e, data reload: false
query1 0.03 0.03 0.03
query2 0.07 0.03 0.04
query3 0.23 0.06 0.07
query4 1.62 0.10 0.10
query5 0.52 0.52 0.51
query6 1.13 0.72 0.73
query7 0.02 0.01 0.04
query8 0.04 0.03 0.04
query9 0.56 0.51 0.50
query10 0.55 0.56 0.56
query11 0.15 0.10 0.11
query12 0.13 0.11 0.11
query13 0.61 0.59 0.59
query14 0.79 0.76 0.80
query15 0.86 0.84 0.82
query16 0.38 0.38 0.38
query17 1.07 1.06 1.08
query18 0.23 0.22 0.23
query19 1.86 1.73 1.76
query20 0.02 0.01 0.01
query21 15.42 0.60 0.59
query22 2.21 2.21 1.65
query23 16.88 1.00 0.78
query24 3.17 1.28 1.48
query25 0.24 0.20 0.16
query26 0.44 0.14 0.14
query27 0.05 0.04 0.04
query28 9.64 0.52 0.46
query29 12.57 3.23 3.22
query30 0.25 0.06 0.07
query31 2.86 0.39 0.39
query32 3.24 0.46 0.47
query33 2.98 3.03 3.02
query34 17.00 4.52 4.54
query35 4.60 4.54 4.55
query36 0.67 0.47 0.47
query37 0.09 0.06 0.06
query38 0.05 0.04 0.04
query39 0.03 0.03 0.03
query40 0.16 0.12 0.12
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.04 0.03
Total cold run time: 103.56 s
Total hot run time: 30.43 s