doris
doris copied to clipboard
[Chore](nereids) Remove AdminStmt
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?
run buildall
TPC-H: Total hot run time: 33611 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 608bbef1d1bd51ea44fac859d95efd6ccd878274, data reload: false
------ Round 1 ----------------------------------
q1 17587 5246 4933 4933
q2 1919 273 187 187
q3 10359 1288 699 699
q4 10214 993 532 532
q5 7608 2399 2329 2329
q6 182 168 128 128
q7 906 739 604 604
q8 9296 1305 1106 1106
q9 6816 5062 5072 5062
q10 6933 2375 1965 1965
q11 482 287 279 279
q12 345 348 215 215
q13 17786 3700 3057 3057
q14 220 238 212 212
q15 563 475 484 475
q16 430 418 377 377
q17 574 870 354 354
q18 7587 7258 7062 7062
q19 2170 1053 552 552
q20 327 329 218 218
q21 3632 2591 2327 2327
q22 1040 1016 938 938
Total cold run time: 106976 ms
Total hot run time: 33611 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5143 5091 5115 5091
q2 242 321 220 220
q3 2172 2668 2312 2312
q4 1354 1762 1403 1403
q5 4234 4099 4318 4099
q6 219 172 129 129
q7 2069 1965 1806 1806
q8 2568 2569 2480 2480
q9 7152 7027 7161 7027
q10 3107 3314 2857 2857
q11 574 531 481 481
q12 673 798 624 624
q13 3451 3913 3286 3286
q14 284 285 267 267
q15 516 482 481 481
q16 443 476 431 431
q17 1152 1573 1375 1375
q18 7554 7210 7025 7025
q19 771 801 864 801
q20 1910 1978 1864 1864
q21 4712 4343 4334 4334
q22 1054 1030 998 998
Total cold run time: 51354 ms
Total hot run time: 49391 ms
TPC-DS: Total hot run time: 186851 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 608bbef1d1bd51ea44fac859d95efd6ccd878274, data reload: false
query1 1001 382 388 382
query2 6530 1954 1933 1933
query3 6743 225 223 223
query4 26601 23299 23436 23299
query5 4313 625 460 460
query6 302 209 196 196
query7 4623 510 298 298
query8 277 234 225 225
query9 8671 2655 2656 2655
query10 468 352 296 296
query11 15914 15151 14951 14951
query12 159 108 108 108
query13 1690 533 422 422
query14 9676 6233 6187 6187
query15 215 193 178 178
query16 7469 629 474 474
query17 1195 740 599 599
query18 2026 410 317 317
query19 199 196 174 174
query20 124 122 115 115
query21 212 134 119 119
query22 4046 4091 4114 4091
query23 34057 33210 33359 33210
query24 8489 2383 2406 2383
query25 536 456 397 397
query26 1245 274 152 152
query27 2745 505 345 345
query28 4338 2140 2134 2134
query29 728 535 429 429
query30 292 222 194 194
query31 936 818 766 766
query32 73 64 64 64
query33 555 404 301 301
query34 801 839 540 540
query35 775 816 765 765
query36 948 998 905 905
query37 109 101 74 74
query38 4180 4248 4063 4063
query39 1494 1448 1437 1437
query40 219 121 108 108
query41 63 59 58 58
query42 121 110 111 110
query43 523 541 494 494
query44 1351 864 846 846
query45 176 175 166 166
query46 847 1024 631 631
query47 1753 1817 1711 1711
query48 404 418 319 319
query49 744 504 446 446
query50 655 679 418 418
query51 4097 4128 4107 4107
query52 108 108 103 103
query53 236 261 185 185
query54 580 570 506 506
query55 89 84 86 84
query56 309 310 303 303
query57 1182 1215 1131 1131
query58 263 261 256 256
query59 2702 2774 2709 2709
query60 326 315 303 303
query61 123 126 124 124
query62 782 731 658 658
query63 227 190 189 189
query64 4285 994 697 697
query65 4282 4201 4205 4201
query66 1092 422 365 365
query67 15723 15614 15410 15410
query68 8055 900 529 529
query69 470 328 266 266
query70 1246 1136 1141 1136
query71 468 326 297 297
query72 5676 4647 4759 4647
query73 684 629 354 354
query74 9074 9215 8833 8833
query75 3866 3212 2700 2700
query76 3717 1182 761 761
query77 783 442 309 309
query78 10007 10148 9267 9267
query79 2531 816 576 576
query80 617 499 443 443
query81 494 322 233 233
query82 453 126 94 94
query83 287 243 236 236
query84 297 116 96 96
query85 832 359 301 301
query86 391 310 282 282
query87 4424 4497 4408 4408
query88 3325 2311 2286 2286
query89 385 333 287 287
query90 1865 206 206 206
query91 141 138 110 110
query92 78 63 60 60
query93 1849 957 594 594
query94 665 412 313 313
query95 375 302 290 290
query96 489 576 280 280
query97 2720 2749 2681 2681
query98 240 209 203 203
query99 1436 1419 1274 1274
Total cold run time: 275957 ms
Total hot run time: 186851 ms
FE UT Coverage Report
Increment line coverage 0.00% (0/1) :tada:
Increment coverage report
Complete coverage report
run buildall
FE UT Coverage Report
Increment line coverage 0.00% (0/1) :tada:
Increment coverage report
Complete coverage report
TPC-H: Total hot run time: 33763 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 22b0682681a29b2a5791840d76ff2f28008ae327, data reload: false
------ Round 1 ----------------------------------
q1 17638 5296 5033 5033
q2 1929 320 182 182
q3 10349 1296 722 722
q4 10226 992 528 528
q5 7575 2359 2302 2302
q6 187 163 130 130
q7 905 722 614 614
q8 9296 1300 1089 1089
q9 6870 5114 5081 5081
q10 6870 2372 1966 1966
q11 481 287 262 262
q12 343 347 216 216
q13 17762 3646 3081 3081
q14 231 226 211 211
q15 554 469 478 469
q16 415 451 370 370
q17 592 853 379 379
q18 7738 7046 7079 7046
q19 2077 957 559 559
q20 331 341 218 218
q21 3732 3144 2320 2320
q22 1027 1030 985 985
Total cold run time: 107128 ms
Total hot run time: 33763 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5283 5100 5097 5097
q2 255 332 231 231
q3 2159 2670 2288 2288
q4 1398 1832 1388 1388
q5 4238 4104 4361 4104
q6 214 173 131 131
q7 1985 1954 1779 1779
q8 2563 2629 2517 2517
q9 7221 7063 7161 7063
q10 3113 3257 2828 2828
q11 569 500 495 495
q12 682 778 656 656
q13 3523 3852 3266 3266
q14 301 307 284 284
q15 517 481 472 472
q16 437 476 455 455
q17 1165 1597 1337 1337
q18 7447 7177 7085 7085
q19 783 723 799 723
q20 1923 1994 1822 1822
q21 4787 4365 4268 4268
q22 1088 1058 1013 1013
Total cold run time: 51651 ms
Total hot run time: 49302 ms
TPC-DS: Total hot run time: 184985 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 22b0682681a29b2a5791840d76ff2f28008ae327, data reload: false
query1 976 393 382 382
query2 6513 1898 1873 1873
query3 6753 227 218 218
query4 26409 23551 22990 22990
query5 4340 617 450 450
query6 299 208 196 196
query7 4629 489 287 287
query8 284 237 210 210
query9 8621 2602 2622 2602
query10 488 340 273 273
query11 15291 15010 14794 14794
query12 155 112 109 109
query13 1663 541 408 408
query14 8905 6084 6254 6084
query15 205 182 170 170
query16 7293 642 494 494
query17 1215 721 595 595
query18 2006 414 317 317
query19 197 199 162 162
query20 127 120 118 118
query21 219 136 109 109
query22 4088 4205 4075 4075
query23 34325 32948 33133 32948
query24 8439 2373 2391 2373
query25 527 453 381 381
query26 784 275 148 148
query27 2731 508 348 348
query28 4303 2108 2092 2092
query29 706 546 430 430
query30 282 212 188 188
query31 920 838 778 778
query32 74 67 64 64
query33 540 366 316 316
query34 799 844 532 532
query35 796 808 722 722
query36 932 978 875 875
query37 109 99 73 73
query38 4102 4236 4043 4043
query39 1496 1407 1411 1407
query40 206 127 125 125
query41 60 62 54 54
query42 127 104 105 104
query43 502 496 497 496
query44 1315 822 812 812
query45 175 177 167 167
query46 831 999 614 614
query47 1796 1794 1707 1707
query48 378 430 303 303
query49 693 479 393 393
query50 650 686 407 407
query51 4173 4254 4075 4075
query52 115 105 102 102
query53 227 249 181 181
query54 561 567 487 487
query55 83 89 83 83
query56 287 285 273 273
query57 1168 1213 1145 1145
query58 258 263 251 251
query59 2674 2750 2652 2652
query60 345 321 302 302
query61 131 124 126 124
query62 828 752 640 640
query63 224 182 182 182
query64 3390 1031 676 676
query65 4249 4193 4176 4176
query66 1022 407 310 310
query67 15689 15630 15345 15345
query68 7984 875 516 516
query69 490 303 276 276
query70 1224 1195 1131 1131
query71 467 320 291 291
query72 5502 4690 4737 4690
query73 702 581 349 349
query74 8880 8924 8827 8827
query75 3900 3212 2648 2648
query76 3637 1187 747 747
query77 773 362 296 296
query78 10036 10208 9348 9348
query79 1939 822 572 572
query80 561 512 427 427
query81 480 258 229 229
query82 414 130 94 94
query83 254 248 229 229
query84 251 119 95 95
query85 797 343 318 318
query86 342 300 288 288
query87 4413 4442 4267 4267
query88 3341 2283 2276 2276
query89 388 312 281 281
query90 1920 211 208 208
query91 138 141 124 124
query92 76 62 60 60
query93 1129 924 579 579
query94 663 442 302 302
query95 368 294 275 275
query96 488 611 281 281
query97 2725 2732 2619 2619
query98 235 217 199 199
query99 1466 1397 1323 1323
Total cold run time: 270681 ms
Total hot run time: 184985 ms
ClickBench: Total hot run time: 29.15 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 22b0682681a29b2a5791840d76ff2f28008ae327, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.04 0.03
query3 0.24 0.07 0.07
query4 1.60 0.11 0.11
query5 0.43 0.43 0.43
query6 1.17 0.66 0.66
query7 0.02 0.02 0.02
query8 0.04 0.03 0.04
query9 0.60 0.52 0.52
query10 0.58 0.58 0.56
query11 0.15 0.11 0.11
query12 0.14 0.11 0.12
query13 0.63 0.61 0.60
query14 0.80 0.81 0.82
query15 0.88 0.86 0.90
query16 0.39 0.38 0.38
query17 1.07 1.03 1.06
query18 0.22 0.21 0.21
query19 1.95 1.84 1.86
query20 0.02 0.01 0.01
query21 15.46 0.92 0.53
query22 0.75 1.17 0.63
query23 14.99 1.36 0.62
query24 6.73 1.96 0.33
query25 0.29 0.08 0.11
query26 0.57 0.18 0.14
query27 0.06 0.06 0.05
query28 9.28 0.91 0.45
query29 12.58 3.97 3.39
query30 0.26 0.09 0.06
query31 2.82 0.59 0.39
query32 3.23 0.55 0.49
query33 3.11 3.07 3.17
query34 16.23 5.38 4.85
query35 4.85 4.89 4.82
query36 0.73 0.49 0.49
query37 0.09 0.06 0.06
query38 0.06 0.04 0.04
query39 0.03 0.03 0.03
query40 0.17 0.14 0.14
query41 0.08 0.02 0.02
query42 0.03 0.02 0.03
query43 0.04 0.04 0.03
Total cold run time: 103.46 s
Total hot run time: 29.15 s
run buildall
TPC-H: Total hot run time: 33572 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit b42532bc8ebb7987b276c1c2317fbda017466ae2, data reload: false
------ Round 1 ----------------------------------
q1 17576 5213 5077 5077
q2 1960 297 206 206
q3 10250 1245 718 718
q4 10240 985 511 511
q5 7542 2399 2279 2279
q6 180 162 130 130
q7 906 729 588 588
q8 9304 1344 969 969
q9 6783 5078 5151 5078
q10 6927 2383 1971 1971
q11 492 295 271 271
q12 332 346 214 214
q13 17762 3680 3072 3072
q14 242 229 219 219
q15 570 476 488 476
q16 431 426 365 365
q17 581 852 363 363
q18 7609 7126 7008 7008
q19 1876 936 554 554
q20 345 333 220 220
q21 3683 2595 2322 2322
q22 1051 1042 961 961
Total cold run time: 106642 ms
Total hot run time: 33572 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5213 5041 5067 5041
q2 247 317 227 227
q3 2158 2681 2251 2251
q4 1323 1791 1349 1349
q5 4230 4119 4367 4119
q6 212 173 130 130
q7 2060 1894 1743 1743
q8 2617 2567 2541 2541
q9 7191 7124 7001 7001
q10 3049 3248 2837 2837
q11 572 511 487 487
q12 681 762 617 617
q13 3541 4044 3283 3283
q14 283 284 273 273
q15 531 482 478 478
q16 428 493 432 432
q17 1146 1603 1380 1380
q18 7682 7161 7100 7100
q19 785 798 919 798
q20 1945 2011 1810 1810
q21 4762 4469 4415 4415
q22 1054 1011 986 986
Total cold run time: 51710 ms
Total hot run time: 49298 ms
TPC-DS: Total hot run time: 185487 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 b42532bc8ebb7987b276c1c2317fbda017466ae2, data reload: false
query1 1009 388 400 388
query2 6528 1796 1780 1780
query3 6738 217 212 212
query4 26566 23675 22973 22973
query5 4367 614 453 453
query6 300 197 183 183
query7 4641 503 287 287
query8 276 218 201 201
query9 8625 2591 2625 2591
query10 500 325 287 287
query11 15358 15196 14826 14826
query12 158 114 105 105
query13 1670 547 409 409
query14 9506 6108 6129 6108
query15 208 199 168 168
query16 7411 647 476 476
query17 1211 718 586 586
query18 2027 414 315 315
query19 205 193 176 176
query20 121 116 115 115
query21 218 143 113 113
query22 4173 4235 4133 4133
query23 34028 33068 33274 33068
query24 7806 2401 2358 2358
query25 547 456 392 392
query26 1226 265 151 151
query27 2636 478 342 342
query28 4390 2107 2084 2084
query29 768 542 446 446
query30 284 223 192 192
query31 913 864 752 752
query32 70 71 61 61
query33 556 369 302 302
query34 803 853 526 526
query35 777 859 748 748
query36 953 961 879 879
query37 110 102 75 75
query38 4139 4149 4054 4054
query39 1454 1410 1404 1404
query40 210 118 107 107
query41 64 59 59 59
query42 135 105 104 104
query43 495 493 467 467
query44 1304 823 818 818
query45 182 176 168 168
query46 828 1035 644 644
query47 1747 1793 1727 1727
query48 380 421 308 308
query49 745 482 401 401
query50 619 695 402 402
query51 4196 4054 4083 4054
query52 114 111 100 100
query53 235 250 184 184
query54 561 560 502 502
query55 88 83 80 80
query56 323 321 293 293
query57 1168 1195 1132 1132
query58 261 258 263 258
query59 2551 2587 2560 2560
query60 326 322 327 322
query61 129 119 123 119
query62 805 746 669 669
query63 221 178 187 178
query64 4324 992 660 660
query65 4259 4197 4157 4157
query66 1158 413 314 314
query67 15687 15691 15535 15535
query68 8181 888 524 524
query69 462 312 270 270
query70 1188 1084 1068 1068
query71 466 338 302 302
query72 5591 4737 4873 4737
query73 746 632 347 347
query74 8898 9102 8656 8656
query75 3827 3199 2683 2683
query76 3697 1207 767 767
query77 766 390 276 276
query78 9987 10189 9600 9600
query79 2607 795 572 572
query80 605 516 445 445
query81 503 257 227 227
query82 644 126 98 98
query83 253 252 236 236
query84 249 115 86 86
query85 800 367 311 311
query86 387 308 279 279
query87 4433 4498 4397 4397
query88 3751 2363 2279 2279
query89 402 320 289 289
query90 1845 212 219 212
query91 152 137 111 111
query92 82 63 62 62
query93 1675 970 584 584
query94 680 430 309 309
query95 375 299 291 291
query96 497 559 285 285
query97 2688 2685 2660 2660
query98 237 207 203 203
query99 1429 1426 1280 1280
Total cold run time: 274494 ms
Total hot run time: 185487 ms
ClickBench: Total hot run time: 29.56 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit b42532bc8ebb7987b276c1c2317fbda017466ae2, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.03 0.04
query3 0.24 0.07 0.07
query4 1.60 0.10 0.10
query5 0.44 0.44 0.43
query6 1.16 0.65 0.67
query7 0.03 0.02 0.01
query8 0.04 0.04 0.04
query9 0.59 0.51 0.52
query10 0.57 0.58 0.56
query11 0.16 0.11 0.11
query12 0.16 0.11 0.12
query13 0.64 0.61 0.61
query14 0.81 0.82 0.82
query15 0.91 0.86 0.89
query16 0.39 0.41 0.41
query17 1.04 1.05 1.10
query18 0.22 0.21 0.21
query19 1.94 1.81 1.82
query20 0.01 0.01 0.01
query21 15.38 0.94 0.55
query22 0.76 1.06 0.59
query23 15.11 1.40 0.59
query24 6.86 1.91 0.85
query25 0.49 0.24 0.07
query26 0.56 0.16 0.16
query27 0.06 0.05 0.05
query28 9.77 0.95 0.46
query29 12.54 4.02 3.33
query30 0.25 0.09 0.07
query31 2.84 0.63 0.39
query32 3.23 0.58 0.48
query33 3.15 3.09 3.10
query34 16.14 5.43 4.76
query35 4.88 4.86 4.85
query36 0.69 0.51 0.49
query37 0.09 0.06 0.06
query38 0.06 0.04 0.04
query39 0.03 0.03 0.03
query40 0.17 0.14 0.14
query41 0.08 0.03 0.03
query42 0.03 0.03 0.02
query43 0.04 0.03 0.03
Total cold run time: 104.28 s
Total hot run time: 29.56 s
run buildall
run buildall
TPC-H: Total hot run time: 34509 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit ae754393ce1982c9593ec75101067fc9c478d909, data reload: false
------ Round 1 ----------------------------------
q1 17634 5203 5059 5059
q2 1942 291 203 203
q3 10311 1320 764 764
q4 10293 1008 562 562
q5 8655 2350 2452 2350
q6 233 171 138 138
q7 929 766 628 628
q8 9317 1506 1198 1198
q9 6861 5126 5241 5126
q10 6903 2410 1957 1957
q11 481 307 289 289
q12 357 355 228 228
q13 17800 3721 3128 3128
q14 242 232 225 225
q15 583 480 481 480
q16 441 435 386 386
q17 627 862 423 423
q18 7442 7294 7167 7167
q19 1628 975 552 552
q20 336 346 243 243
q21 4159 3314 2434 2434
q22 1099 1062 969 969
Total cold run time: 108273 ms
Total hot run time: 34509 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5147 5095 5139 5095
q2 249 330 227 227
q3 2177 2751 2305 2305
q4 1396 1792 1370 1370
q5 4252 4377 4393 4377
q6 216 171 133 133
q7 2019 1899 1770 1770
q8 2569 2616 2510 2510
q9 7253 7225 7074 7074
q10 3090 3232 2835 2835
q11 563 522 483 483
q12 704 795 651 651
q13 3568 3879 3302 3302
q14 276 291 281 281
q15 526 477 474 474
q16 442 505 466 466
q17 1182 1537 1412 1412
q18 7691 7266 7069 7069
q19 794 802 848 802
q20 1915 1970 1885 1885
q21 4710 4470 4361 4361
q22 1090 1103 1012 1012
Total cold run time: 51829 ms
Total hot run time: 49894 ms
TPC-DS: Total hot run time: 185986 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 ae754393ce1982c9593ec75101067fc9c478d909, data reload: false
query1 997 398 387 387
query2 6539 1818 1782 1782
query3 6753 226 220 220
query4 26246 23801 23084 23084
query5 4389 644 472 472
query6 304 213 218 213
query7 4628 505 316 316
query8 269 232 214 214
query9 8624 2662 2660 2660
query10 502 335 284 284
query11 15546 15078 14810 14810
query12 166 110 110 110
query13 1666 547 415 415
query14 9125 6181 6314 6181
query15 199 195 181 181
query16 7503 630 471 471
query17 1205 730 595 595
query18 2075 423 325 325
query19 205 206 165 165
query20 120 119 117 117
query21 216 125 111 111
query22 4139 4194 4078 4078
query23 34201 33442 33087 33087
query24 8548 2352 2379 2352
query25 556 458 402 402
query26 1220 272 149 149
query27 2737 507 350 350
query28 4331 2118 2122 2118
query29 745 552 439 439
query30 291 215 189 189
query31 935 826 764 764
query32 72 63 63 63
query33 569 379 343 343
query34 801 862 529 529
query35 783 841 768 768
query36 922 976 873 873
query37 113 101 75 75
query38 4166 4171 4125 4125
query39 1656 1435 1442 1435
query40 219 123 106 106
query41 63 58 60 58
query42 125 113 106 106
query43 496 504 485 485
query44 1297 818 823 818
query45 185 175 171 171
query46 867 1008 622 622
query47 1733 1811 1720 1720
query48 402 418 311 311
query49 745 494 389 389
query50 634 687 407 407
query51 4152 4131 4103 4103
query52 114 112 106 106
query53 229 252 190 190
query54 582 569 505 505
query55 89 91 89 89
query56 301 312 299 299
query57 1172 1221 1109 1109
query58 269 266 283 266
query59 2547 2675 2477 2477
query60 336 328 313 313
query61 128 132 119 119
query62 815 706 645 645
query63 233 187 194 187
query64 4318 1012 667 667
query65 4298 4154 4178 4154
query66 1114 415 334 334
query67 16399 15909 15485 15485
query68 8257 889 536 536
query69 485 302 270 270
query70 1217 1120 1050 1050
query71 497 346 312 312
query72 5742 4820 4781 4781
query73 679 614 358 358
query74 9285 9145 9050 9050
query75 3900 3199 2680 2680
query76 3727 1258 769 769
query77 800 406 296 296
query78 10048 10149 9268 9268
query79 2559 783 585 585
query80 625 504 444 444
query81 504 260 231 231
query82 452 135 98 98
query83 289 249 226 226
query84 296 99 83 83
query85 787 348 310 310
query86 383 314 283 283
query87 4436 4365 4394 4365
query88 3612 2265 2248 2248
query89 380 307 284 284
query90 1852 246 207 207
query91 140 144 113 113
query92 82 60 59 59
query93 1951 963 591 591
query94 663 414 312 312
query95 380 290 285 285
query96 492 570 278 278
query97 2759 2830 2655 2655
query98 238 215 205 205
query99 1443 1438 1261 1261
Total cold run time: 276884 ms
Total hot run time: 185986 ms
ClickBench: Total hot run time: 29.73 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit ae754393ce1982c9593ec75101067fc9c478d909, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.04 0.03
query3 0.24 0.07 0.06
query4 1.61 0.10 0.11
query5 0.43 0.44 0.43
query6 1.18 0.66 0.66
query7 0.02 0.02 0.01
query8 0.04 0.04 0.04
query9 0.58 0.50 0.52
query10 0.57 0.58 0.57
query11 0.16 0.11 0.12
query12 0.15 0.11 0.12
query13 0.64 0.63 0.61
query14 0.80 0.86 0.81
query15 0.90 0.86 0.88
query16 0.38 0.39 0.41
query17 1.04 1.01 1.05
query18 0.23 0.22 0.21
query19 2.00 1.81 1.91
query20 0.02 0.01 0.01
query21 15.39 0.89 0.54
query22 0.76 1.19 0.67
query23 14.98 1.36 0.63
query24 6.91 1.23 0.98
query25 0.54 0.26 0.09
query26 0.61 0.16 0.15
query27 0.08 0.06 0.05
query28 9.69 0.89 0.44
query29 12.56 4.04 3.34
query30 0.27 0.09 0.06
query31 2.82 0.61 0.41
query32 3.23 0.57 0.46
query33 3.10 3.07 3.06
query34 16.15 5.42 4.83
query35 4.90 4.86 4.84
query36 0.70 0.53 0.48
query37 0.09 0.07 0.07
query38 0.05 0.04 0.03
query39 0.04 0.03 0.02
query40 0.17 0.15 0.14
query41 0.09 0.03 0.03
query42 0.03 0.02 0.02
query43 0.04 0.03 0.03
Total cold run time: 104.3 s
Total hot run time: 29.73 s
PR approved by at least one committer and no changes requested.
PR approved by anyone and no changes requested.