doris
doris copied to clipboard
[clear](fe) update minimum meta version required to 140
What problem does this PR solve?
- Update minimum meta version required to 140
- Remove the readFields, read, and write methods used for compatibility with meta versions earlier than 140.
Release note
None
Check List (For Author)
-
Test
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [x] No need to test or manual test. Explain why:
- [x] This is a refactor/code format and no logic has been changed.
- [x] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason
-
Behavior changed:
- [x] No.
- [ ] Yes.
-
Does this need documentation?
- [x] 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?
run buildall
run buildall
TPC-H: Total hot run time: 34002 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit c4e5d8e90db8c0d49c7e552206b7ac9898a3684e, data reload: false
------ Round 1 ----------------------------------
q1 26082 5140 5020 5020
q2 1980 281 185 185
q3 10615 1281 709 709
q4 10277 1018 541 541
q5 8635 2423 2321 2321
q6 181 163 135 135
q7 906 738 609 609
q8 9309 1278 1113 1113
q9 6801 5111 5093 5093
q10 6847 2320 1906 1906
q11 482 292 280 280
q12 350 350 220 220
q13 17763 3697 3170 3170
q14 225 231 218 218
q15 570 485 474 474
q16 435 429 373 373
q17 600 850 365 365
q18 7669 7123 7082 7082
q19 1775 984 575 575
q20 331 331 221 221
q21 3874 3197 2435 2435
q22 1067 1031 957 957
Total cold run time: 116774 ms
Total hot run time: 34002 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5171 5088 5062 5062
q2 238 318 221 221
q3 2165 2634 2265 2265
q4 1329 1769 1475 1475
q5 4518 4456 4361 4361
q6 210 172 124 124
q7 1919 1883 1767 1767
q8 2594 2488 2388 2388
q9 7059 7142 7049 7049
q10 3000 3151 2718 2718
q11 597 530 474 474
q12 697 739 623 623
q13 3518 3898 3306 3306
q14 288 302 273 273
q15 514 473 467 467
q16 445 491 458 458
q17 1195 1489 1392 1392
q18 7531 7461 7477 7461
q19 825 846 971 846
q20 1998 2025 1837 1837
q21 4855 4431 4303 4303
q22 1068 1040 1019 1019
Total cold run time: 51734 ms
Total hot run time: 49889 ms
TPC-DS: Total hot run time: 186092 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 c4e5d8e90db8c0d49c7e552206b7ac9898a3684e, data reload: false
query1 998 484 528 484
query2 6594 1822 1799 1799
query3 6750 228 229 228
query4 25895 23801 23037 23037
query5 4327 610 476 476
query6 316 222 202 202
query7 4629 486 298 298
query8 280 228 210 210
query9 8646 2644 2663 2644
query10 498 352 277 277
query11 15413 15346 15006 15006
query12 193 104 108 104
query13 1645 507 398 398
query14 10024 6308 6222 6222
query15 198 208 163 163
query16 7639 611 489 489
query17 1277 764 561 561
query18 2015 394 296 296
query19 185 176 161 161
query20 118 121 116 116
query21 212 118 108 108
query22 4017 4059 4042 4042
query23 34072 33197 33149 33149
query24 8366 2360 2520 2360
query25 524 449 386 386
query26 1227 268 148 148
query27 2778 500 338 338
query28 4289 2127 2127 2127
query29 718 580 455 455
query30 284 217 189 189
query31 941 839 751 751
query32 81 70 64 64
query33 581 384 323 323
query34 790 839 541 541
query35 782 822 739 739
query36 947 984 880 880
query37 109 105 83 83
query38 4064 4078 4046 4046
query39 1513 1422 1381 1381
query40 210 131 113 113
query41 71 66 70 66
query42 126 106 109 106
query43 499 511 475 475
query44 1346 820 817 817
query45 179 183 166 166
query46 824 1015 624 624
query47 1749 1765 1744 1744
query48 383 439 305 305
query49 730 480 406 406
query50 622 668 405 405
query51 4164 4166 4153 4153
query52 114 109 98 98
query53 220 253 187 187
query54 568 569 535 535
query55 87 85 90 85
query56 317 297 270 270
query57 1147 1118 1088 1088
query58 274 255 255 255
query59 2546 2673 2557 2557
query60 323 309 312 309
query61 129 127 126 126
query62 811 710 645 645
query63 228 183 183 183
query64 4226 999 683 683
query65 4202 4129 4170 4129
query66 1062 416 311 311
query67 15961 15650 15427 15427
query68 8453 893 522 522
query69 465 302 266 266
query70 1157 1125 1140 1125
query71 468 324 294 294
query72 5755 4787 4762 4762
query73 727 637 344 344
query74 8916 8795 9108 8795
query75 3902 3251 2695 2695
query76 3684 1183 765 765
query77 785 384 294 294
query78 10085 10055 9447 9447
query79 2811 824 604 604
query80 638 525 479 479
query81 480 257 221 221
query82 459 126 103 103
query83 293 256 247 247
query84 355 103 103 103
query85 790 352 318 318
query86 397 291 278 278
query87 4469 4417 4340 4340
query88 3205 2289 2293 2289
query89 408 317 285 285
query90 1991 210 209 209
query91 143 140 111 111
query92 82 59 60 59
query93 2223 935 589 589
query94 676 411 276 276
query95 380 296 281 281
query96 491 574 284 284
query97 2719 2782 2666 2666
query98 241 209 206 206
query99 1430 1400 1286 1286
Total cold run time: 276131 ms
Total hot run time: 186092 ms
ClickBench: Total hot run time: 29.35 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit c4e5d8e90db8c0d49c7e552206b7ac9898a3684e, data reload: false
query1 0.04 0.04 0.03
query2 0.13 0.10 0.11
query3 0.25 0.19 0.20
query4 1.61 0.20 0.19
query5 0.45 0.45 0.43
query6 1.40 0.65 0.66
query7 0.02 0.02 0.01
query8 0.04 0.05 0.03
query9 0.57 0.52 0.53
query10 0.56 0.59 0.56
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.62 0.60 0.60
query14 0.79 0.81 0.80
query15 0.88 0.85 0.86
query16 0.39 0.39 0.38
query17 1.02 1.03 1.06
query18 0.23 0.21 0.21
query19 1.93 1.78 1.84
query20 0.01 0.01 0.01
query21 15.43 0.91 0.54
query22 0.77 1.16 0.64
query23 14.96 1.37 0.63
query24 7.20 1.21 1.07
query25 0.50 0.26 0.11
query26 0.53 0.16 0.13
query27 0.06 0.05 0.04
query28 9.70 0.93 0.43
query29 12.55 3.96 3.34
query30 0.25 0.09 0.07
query31 2.81 0.60 0.39
query32 3.22 0.56 0.47
query33 3.04 3.07 3.09
query34 15.75 5.10 4.53
query35 4.46 4.54 4.47
query36 0.68 0.49 0.49
query37 0.09 0.06 0.06
query38 0.06 0.04 0.04
query39 0.03 0.03 0.02
query40 0.17 0.14 0.13
query41 0.07 0.03 0.03
query42 0.03 0.03 0.02
query43 0.04 0.04 0.03
Total cold run time: 103.65 s
Total hot run time: 29.35 s
FE UT Coverage Report
Increment line coverage 49.64% (68/137) :tada:
Increment coverage report
Complete coverage report
run buildall
run buildall
run buildall
FE UT Coverage Report
Increment line coverage 50.75% (68/134) :tada:
Increment coverage report
Complete coverage report
run buildall
TPC-H: Total hot run time: 34647 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 7caf6f98821cfc4098d79a04ba3b0502d8628953, data reload: false
------ Round 1 ----------------------------------
q1 17601 5173 5009 5009
q2 1931 289 184 184
q3 10301 1334 733 733
q4 10213 1023 513 513
q5 7501 2397 2288 2288
q6 183 167 131 131
q7 901 748 600 600
q8 9318 1373 1068 1068
q9 6887 5072 5142 5072
q10 6888 2393 1964 1964
q11 505 287 292 287
q12 347 356 213 213
q13 17776 3724 3138 3138
q14 228 238 214 214
q15 554 503 490 490
q16 432 432 373 373
q17 584 877 368 368
q18 7530 7248 7247 7247
q19 1097 975 551 551
q20 326 340 229 229
q21 4147 3238 2990 2990
q22 1080 1009 985 985
Total cold run time: 106330 ms
Total hot run time: 34647 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5091 5061 5034 5034
q2 245 323 227 227
q3 2165 2695 2289 2289
q4 1377 1859 1354 1354
q5 4253 4100 4468 4100
q6 216 166 129 129
q7 1967 1949 1826 1826
q8 2640 2600 2503 2503
q9 7169 7089 7186 7089
q10 3083 3285 2864 2864
q11 578 515 499 499
q12 693 761 603 603
q13 3471 3882 3351 3351
q14 305 289 280 280
q15 557 524 511 511
q16 451 500 444 444
q17 1145 1547 1424 1424
q18 7727 7472 7343 7343
q19 811 813 878 813
q20 2034 2046 1911 1911
q21 4979 4532 4282 4282
q22 1086 1041 981 981
Total cold run time: 52043 ms
Total hot run time: 49857 ms
TPC-DS: Total hot run time: 186460 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 7caf6f98821cfc4098d79a04ba3b0502d8628953, data reload: false
query1 988 400 376 376
query2 6535 1900 1850 1850
query3 6741 228 212 212
query4 26575 23440 23466 23440
query5 4370 648 480 480
query6 301 208 194 194
query7 4622 498 298 298
query8 273 228 219 219
query9 8631 2693 2703 2693
query10 471 343 285 285
query11 15467 15054 14913 14913
query12 152 109 107 107
query13 1669 554 420 420
query14 8758 6266 6237 6237
query15 206 205 174 174
query16 7425 666 490 490
query17 1238 718 587 587
query18 1981 409 323 323
query19 208 190 172 172
query20 128 119 125 119
query21 218 187 110 110
query22 4076 4149 4112 4112
query23 33992 33037 33201 33037
query24 8416 2350 2379 2350
query25 543 450 414 414
query26 1237 268 152 152
query27 2725 503 350 350
query28 4288 2172 2148 2148
query29 736 571 427 427
query30 289 219 189 189
query31 922 859 728 728
query32 72 65 69 65
query33 557 376 331 331
query34 801 850 552 552
query35 781 827 730 730
query36 942 994 873 873
query37 116 98 80 80
query38 4074 4099 3991 3991
query39 1478 1411 1416 1411
query40 211 121 103 103
query41 62 71 70 70
query42 123 110 115 110
query43 487 510 488 488
query44 1299 837 808 808
query45 178 172 168 168
query46 839 1020 629 629
query47 1724 1779 1732 1732
query48 384 433 307 307
query49 754 485 423 423
query50 646 670 399 399
query51 4140 4156 4153 4153
query52 110 108 102 102
query53 223 250 186 186
query54 581 593 508 508
query55 84 78 82 78
query56 309 306 312 306
query57 1157 1228 1109 1109
query58 276 263 257 257
query59 2725 2674 2678 2674
query60 334 321 311 311
query61 122 127 124 124
query62 819 747 635 635
query63 226 184 188 184
query64 4281 1011 659 659
query65 4280 4163 4218 4163
query66 1147 419 321 321
query67 15984 15485 15684 15485
query68 8079 893 535 535
query69 482 304 274 274
query70 1193 1076 1122 1076
query71 484 315 302 302
query72 5351 4738 4793 4738
query73 721 614 351 351
query74 8929 8853 8847 8847
query75 3894 3204 2673 2673
query76 3730 1190 773 773
query77 775 377 293 293
query78 9996 10168 9352 9352
query79 2757 833 586 586
query80 625 511 459 459
query81 470 269 233 233
query82 472 134 100 100
query83 282 259 241 241
query84 289 108 83 83
query85 783 370 318 318
query86 339 325 299 299
query87 4417 4461 4261 4261
query88 3070 2302 2261 2261
query89 405 324 284 284
query90 1947 273 209 209
query91 149 145 111 111
query92 72 70 63 63
query93 1498 944 590 590
query94 681 418 311 311
query95 379 297 283 283
query96 506 579 280 280
query97 2706 2774 2684 2684
query98 218 211 204 204
query99 1454 1406 1255 1255
Total cold run time: 273660 ms
Total hot run time: 186460 ms
ClickBench: Total hot run time: 29.58 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 7caf6f98821cfc4098d79a04ba3b0502d8628953, data reload: false
query1 0.04 0.04 0.03
query2 0.06 0.04 0.03
query3 0.24 0.08 0.06
query4 1.62 0.10 0.10
query5 0.42 0.42 0.40
query6 1.17 0.67 0.66
query7 0.02 0.02 0.02
query8 0.04 0.03 0.04
query9 0.58 0.54 0.51
query10 0.57 0.58 0.57
query11 0.16 0.11 0.11
query12 0.16 0.11 0.12
query13 0.62 0.61 0.62
query14 0.80 0.80 0.83
query15 0.90 0.87 0.88
query16 0.40 0.39 0.38
query17 1.04 1.08 1.06
query18 0.23 0.22 0.21
query19 1.98 1.89 1.86
query20 0.01 0.01 0.01
query21 15.41 0.93 0.54
query22 0.75 1.20 0.67
query23 14.95 1.37 0.64
query24 7.35 1.60 0.75
query25 0.48 0.22 0.06
query26 0.52 0.17 0.13
query27 0.07 0.06 0.06
query28 9.89 0.86 0.43
query29 12.53 3.96 3.35
query30 0.26 0.09 0.06
query31 2.82 0.61 0.38
query32 3.23 0.54 0.48
query33 3.14 3.12 3.10
query34 16.09 5.47 4.82
query35 4.86 4.92 4.86
query36 0.68 0.49 0.49
query37 0.09 0.07 0.07
query38 0.05 0.04 0.04
query39 0.03 0.03 0.02
query40 0.18 0.14 0.13
query41 0.08 0.02 0.02
query42 0.03 0.03 0.02
query43 0.04 0.04 0.03
Total cold run time: 104.59 s
Total hot run time: 29.58 s
run performance
TPC-H: Total hot run time: 33877 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit d696745a136cbb5fc56e20a14e9a27e679db4179, data reload: false
------ Round 1 ----------------------------------
q1 17687 5269 5022 5022
q2 1931 294 191 191
q3 10595 1337 689 689
q4 10248 1017 540 540
q5 7894 2343 2331 2331
q6 183 162 130 130
q7 877 724 623 623
q8 9303 1280 1036 1036
q9 6732 5068 5115 5068
q10 6888 2387 1963 1963
q11 514 286 278 278
q12 351 345 211 211
q13 17787 3681 3043 3043
q14 242 232 205 205
q15 560 479 479 479
q16 423 439 371 371
q17 605 836 388 388
q18 8217 7225 7363 7225
q19 1429 931 545 545
q20 331 329 227 227
q21 3747 3187 2342 2342
q22 1029 1013 970 970
Total cold run time: 107573 ms
Total hot run time: 33877 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5073 5002 5054 5002
q2 242 326 226 226
q3 2176 2624 2269 2269
q4 1322 1775 1385 1385
q5 4189 4073 4356 4073
q6 225 173 128 128
q7 1993 1883 1705 1705
q8 2536 2577 2427 2427
q9 7065 7096 7069 7069
q10 3067 3245 2817 2817
q11 582 502 508 502
q12 659 771 604 604
q13 3494 3883 3359 3359
q14 285 295 275 275
q15 515 482 473 473
q16 476 469 444 444
q17 1112 1568 1387 1387
q18 7504 7052 7113 7052
q19 745 733 885 733
q20 1892 1992 1869 1869
q21 4723 4262 4231 4231
q22 1062 1017 973 973
Total cold run time: 50937 ms
Total hot run time: 49003 ms
TPC-DS: Total hot run time: 185507 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 d696745a136cbb5fc56e20a14e9a27e679db4179, data reload: false
query1 978 384 378 378
query2 6524 1818 1807 1807
query3 6758 225 226 225
query4 26470 23768 23299 23299
query5 4310 624 480 480
query6 301 210 211 210
query7 4636 491 286 286
query8 269 222 223 222
query9 8632 2617 2598 2598
query10 494 327 275 275
query11 15697 15017 14896 14896
query12 159 109 104 104
query13 1657 528 428 428
query14 9429 6205 6245 6205
query15 199 195 171 171
query16 7466 630 483 483
query17 1213 733 569 569
query18 1997 420 311 311
query19 196 189 170 170
query20 124 115 118 115
query21 214 123 115 115
query22 4126 4286 4008 4008
query23 34097 32875 33008 32875
query24 8405 2355 2351 2351
query25 538 452 401 401
query26 1239 266 152 152
query27 2752 501 343 343
query28 4318 2107 2089 2089
query29 754 547 438 438
query30 284 217 187 187
query31 950 855 758 758
query32 71 63 59 59
query33 555 356 317 317
query34 791 868 526 526
query35 782 805 724 724
query36 953 977 876 876
query37 105 96 72 72
query38 4086 4076 4054 4054
query39 1479 1438 1397 1397
query40 214 124 105 105
query41 68 58 61 58
query42 122 112 104 104
query43 493 482 446 446
query44 1286 821 825 821
query45 183 172 166 166
query46 833 1038 618 618
query47 1755 1821 1708 1708
query48 375 413 305 305
query49 739 468 403 403
query50 638 672 398 398
query51 4075 4245 4090 4090
query52 113 111 95 95
query53 222 246 189 189
query54 562 564 494 494
query55 82 85 85 85
query56 324 306 289 289
query57 1191 1189 1127 1127
query58 273 251 246 246
query59 2579 2767 2542 2542
query60 332 342 297 297
query61 127 124 129 124
query62 828 713 660 660
query63 221 184 182 182
query64 4311 1004 677 677
query65 4268 4192 4212 4192
query66 1103 405 327 327
query67 15929 15573 15498 15498
query68 8248 877 534 534
query69 470 304 278 278
query70 1153 1100 1118 1100
query71 469 323 301 301
query72 5854 4790 4905 4790
query73 761 683 430 430
query74 8830 8904 8709 8709
query75 3849 3175 2698 2698
query76 3717 1177 758 758
query77 808 378 290 290
query78 9945 10038 9338 9338
query79 3016 829 577 577
query80 657 570 428 428
query81 504 258 224 224
query82 482 141 94 94
query83 282 252 233 233
query84 295 105 91 91
query85 798 356 316 316
query86 390 309 279 279
query87 4338 4404 4305 4305
query88 3420 2257 2245 2245
query89 395 317 282 282
query90 1870 201 205 201
query91 146 151 115 115
query92 74 60 60 60
query93 2393 940 587 587
query94 665 410 294 294
query95 367 290 284 284
query96 483 564 278 278
query97 2704 2740 2666 2666
query98 234 208 209 208
query99 1439 1408 1294 1294
Total cold run time: 276310 ms
Total hot run time: 185507 ms
ClickBench: Total hot run time: 30.13 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit d696745a136cbb5fc56e20a14e9a27e679db4179, data reload: false
query1 0.03 0.03 0.02
query2 0.11 0.05 0.05
query3 0.29 0.06 0.07
query4 1.60 0.08 0.09
query5 0.42 0.41 0.40
query6 1.17 0.66 0.66
query7 0.02 0.02 0.02
query8 0.05 0.05 0.05
query9 0.61 0.52 0.53
query10 0.57 0.59 0.56
query11 0.24 0.13 0.13
query12 0.26 0.14 0.14
query13 0.64 0.63 0.62
query14 0.81 0.82 0.84
query15 1.00 0.89 0.88
query16 0.39 0.40 0.36
query17 1.08 1.09 1.09
query18 0.24 0.23 0.23
query19 2.02 1.85 1.83
query20 0.01 0.01 0.01
query21 15.40 0.98 0.66
query22 0.92 1.07 0.78
query23 14.74 1.57 0.77
query24 5.47 0.59 0.29
query25 0.16 0.09 0.09
query26 0.56 0.22 0.18
query27 0.09 0.08 0.08
query28 11.05 1.27 0.59
query29 12.55 4.23 3.44
query30 0.27 0.08 0.06
query31 2.82 0.65 0.43
query32 3.23 0.60 0.51
query33 3.13 3.13 3.10
query34 16.62 5.49 4.71
query35 4.77 4.74 4.74
query36 0.65 0.52 0.50
query37 0.20 0.17 0.17
query38 0.17 0.16 0.15
query39 0.06 0.04 0.05
query40 0.21 0.17 0.17
query41 0.11 0.06 0.05
query42 0.06 0.05 0.05
query43 0.05 0.04 0.05
Total cold run time: 104.85 s
Total hot run time: 30.13 s
run buildall
run buildall
TPC-H: Total hot run time: 34106 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 49c28b284333707f2a0f95536d2aabbd8ee05fc8, data reload: false
------ Round 1 ----------------------------------
q1 17688 5227 5031 5031
q2 1937 299 186 186
q3 10525 1300 724 724
q4 10245 1009 523 523
q5 7691 2395 2250 2250
q6 182 162 131 131
q7 911 740 623 623
q8 9306 1266 1137 1137
q9 6734 5079 5087 5079
q10 6915 2376 1980 1980
q11 502 291 277 277
q12 347 359 225 225
q13 17792 3700 3134 3134
q14 227 234 216 216
q15 564 476 492 476
q16 447 448 379 379
q17 598 862 377 377
q18 7670 7133 7217 7133
q19 1910 969 583 583
q20 356 337 223 223
q21 3699 3158 2445 2445
q22 1043 1009 974 974
Total cold run time: 107289 ms
Total hot run time: 34106 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5171 4998 5075 4998
q2 245 324 223 223
q3 2138 2645 2314 2314
q4 1381 1802 1422 1422
q5 4279 4147 4439 4147
q6 214 173 133 133
q7 2024 1886 1788 1788
q8 2582 2504 2523 2504
q9 7127 7043 7135 7043
q10 3138 3287 2832 2832
q11 577 541 504 504
q12 691 771 652 652
q13 3525 3922 3312 3312
q14 278 313 282 282
q15 526 492 469 469
q16 450 496 436 436
q17 1156 1483 1394 1394
q18 7296 7174 7130 7130
q19 824 826 842 826
q20 1895 1975 1865 1865
q21 4816 4346 4315 4315
q22 1035 1002 995 995
Total cold run time: 51368 ms
Total hot run time: 49584 ms
TPC-DS: Total hot run time: 186517 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 49c28b284333707f2a0f95536d2aabbd8ee05fc8, data reload: false
query1 1000 395 398 395
query2 6536 2005 1917 1917
query3 6759 223 221 221
query4 26557 23373 23146 23146
query5 4386 628 468 468
query6 312 210 200 200
query7 4638 508 310 310
query8 279 231 227 227
query9 8635 2666 2678 2666
query10 512 337 272 272
query11 15890 15052 14855 14855
query12 166 108 106 106
query13 1645 546 405 405
query14 9618 6349 6144 6144
query15 207 187 181 181
query16 7501 637 445 445
query17 1177 705 578 578
query18 2013 391 312 312
query19 199 187 162 162
query20 124 117 112 112
query21 215 132 112 112
query22 4143 4044 4113 4044
query23 34101 33138 33086 33086
query24 8503 2395 2410 2395
query25 538 457 395 395
query26 1233 279 154 154
query27 2767 518 356 356
query28 4316 2158 2147 2147
query29 748 562 438 438
query30 296 230 193 193
query31 930 875 758 758
query32 72 62 66 62
query33 565 366 339 339
query34 795 846 549 549
query35 790 835 704 704
query36 960 969 888 888
query37 105 102 76 76
query38 4114 4205 4110 4110
query39 1489 1412 1402 1402
query40 213 124 111 111
query41 66 60 58 58
query42 126 114 115 114
query43 529 515 498 498
query44 1374 849 842 842
query45 179 183 170 170
query46 849 1027 636 636
query47 1760 1798 1763 1763
query48 401 470 319 319
query49 762 516 422 422
query50 675 667 419 419
query51 4161 4149 4093 4093
query52 114 111 100 100
query53 232 258 193 193
query54 581 571 501 501
query55 88 84 87 84
query56 308 289 301 289
query57 1212 1190 1131 1131
query58 266 284 263 263
query59 2802 2761 2701 2701
query60 354 321 312 312
query61 127 130 131 130
query62 802 730 666 666
query63 236 207 197 197
query64 4413 1109 778 778
query65 4287 4159 4199 4159
query66 1119 434 346 346
query67 15805 15515 15232 15232
query68 7832 909 548 548
query69 495 326 343 326
query70 1182 1156 1156 1156
query71 442 330 310 310
query72 5580 4827 5037 4827
query73 725 696 367 367
query74 8917 9111 8622 8622
query75 3621 3188 2695 2695
query76 3385 1194 754 754
query77 748 396 305 305
query78 10097 10299 9342 9342
query79 2285 840 585 585
query80 585 514 487 487
query81 507 269 221 221
query82 481 131 101 101
query83 266 255 232 232
query84 260 112 95 95
query85 812 354 315 315
query86 389 322 299 299
query87 4428 4486 4521 4486
query88 4015 2344 2302 2302
query89 393 308 295 295
query90 1947 221 212 212
query91 144 144 114 114
query92 72 64 58 58
query93 1872 1000 615 615
query94 717 405 304 304
query95 384 299 293 293
query96 503 578 289 289
query97 2713 2776 2651 2651
query98 237 216 206 206
query99 1561 1412 1248 1248
Total cold run time: 276270 ms
Total hot run time: 186517 ms
ClickBench: Total hot run time: 30.46 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 49c28b284333707f2a0f95536d2aabbd8ee05fc8, data reload: false
query1 0.04 0.03 0.03
query2 0.11 0.04 0.05
query3 0.30 0.06 0.06
query4 1.62 0.08 0.07
query5 0.42 0.41 0.41
query6 1.16 0.67 0.67
query7 0.02 0.02 0.02
query8 0.06 0.05 0.05
query9 0.64 0.53 0.55
query10 0.58 0.59 0.58
query11 0.25 0.13 0.12
query12 0.25 0.13 0.13
query13 0.65 0.63 0.63
query14 0.81 0.86 0.84
query15 1.00 0.89 0.89
query16 0.38 0.38 0.39
query17 1.08 1.07 1.11
query18 0.25 0.23 0.23
query19 2.00 1.85 1.88
query20 0.01 0.01 0.02
query21 15.41 0.96 0.67
query22 0.95 1.04 0.86
query23 14.68 1.49 0.78
query24 5.28 0.59 0.30
query25 0.16 0.10 0.09
query26 0.56 0.22 0.18
query27 0.09 0.09 0.08
query28 11.05 1.23 0.60
query29 12.56 4.16 3.47
query30 0.29 0.09 0.07
query31 2.83 0.62 0.43
query32 3.24 0.59 0.51
query33 3.09 3.14 3.12
query34 16.79 5.42 4.75
query35 4.80 4.75 4.77
query36 0.64 0.51 0.54
query37 0.20 0.17 0.16
query38 0.17 0.17 0.16
query39 0.05 0.05 0.04
query40 0.20 0.17 0.17
query41 0.11 0.05 0.06
query42 0.06 0.06 0.05
query43 0.06 0.05 0.05
Total cold run time: 104.9 s
Total hot run time: 30.46 s
PR approved by at least one committer and no changes requested.
PR approved by anyone and no changes requested.