doris
doris copied to clipboard
apache
[fix](Nereids) Fix ClassCastException when HAVING clause contains subquery
What problem does this PR solve?
usercase Issue Number: close #58937
Related PR: #xxx
Problem Summary:
Release note
None
Check List (For Author)
-
Test
- [x] 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: 36566 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit b52fa36e6bee47b2ac7bf0514b9b8010aa55e522, data reload: false
------ Round 1 ----------------------------------
q1 17610 4217 4058 4058
q2 2068 349 238 238
q3 10144 1313 737 737
q4 10201 762 315 315
q5 7567 2129 1906 1906
q6 184 169 136 136
q7 1018 858 725 725
q8 9363 1442 1129 1129
q9 6946 5337 5265 5265
q10 6866 2393 1977 1977
q11 521 314 298 298
q12 669 734 581 581
q13 17803 3671 3009 3009
q14 289 289 268 268
q15 578 533 534 533
q16 957 915 876 876
q17 693 840 494 494
q18 7549 7849 7815 7815
q19 1145 998 638 638
q20 425 391 259 259
q21 4641 4315 4262 4262
q22 1117 1075 1047 1047
Total cold run time: 108354 ms
Total hot run time: 36566 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4377 4209 4656 4209
q2 346 395 330 330
q3 2379 2974 2491 2491
q4 1386 1859 1463 1463
q5 4657 4589 4488 4488
q6 213 168 129 129
q7 1970 2044 1859 1859
q8 2666 2525 2487 2487
q9 7498 7493 7519 7493
q10 3033 3239 2721 2721
q11 574 521 479 479
q12 644 716 580 580
q13 3323 3711 3065 3065
q14 268 282 254 254
q15 540 488 500 488
q16 851 886 876 876
q17 1116 1369 1338 1338
q18 7427 7220 7040 7040
q19 832 820 833 820
q20 1938 2002 1816 1816
q21 4631 4305 4215 4215
q22 1053 1031 1013 1013
Total cold run time: 51722 ms
Total hot run time: 49654 ms
TPC-DS: Total hot run time: 181706 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 b52fa36e6bee47b2ac7bf0514b9b8010aa55e522, data reload: false
query5 5197 644 469 469
query6 324 233 231 231
query7 4222 457 281 281
query8 296 278 238 238
query9 8779 2588 2570 2570
query10 565 378 325 325
query11 15279 15252 14625 14625
query12 196 119 115 115
query13 1275 506 402 402
query14 6554 3261 3084 3084
query14_1 2910 3036 2972 2972
query15 211 200 185 185
query16 966 465 463 463
query17 1102 682 586 586
query18 2703 446 350 350
query19 227 226 205 205
query20 119 115 111 111
query21 222 149 113 113
query22 3821 3898 3907 3898
query23 16459 16125 15989 15989
query23_1 15884 16091 15930 15930
query24 7260 1631 1232 1232
query24_1 1259 1223 1270 1223
query25 550 492 413 413
query26 1245 312 159 159
query27 2718 477 307 307
query28 4438 2159 2154 2154
query29 770 547 454 454
query30 324 245 225 225
query31 847 705 638 638
query32 73 68 73 68
query33 559 336 284 284
query34 891 891 550 550
query35 769 820 728 728
query36 855 903 817 817
query37 133 96 76 76
query38 3825 3841 3768 3768
query39 758 736 732 732
query39_1 697 698 695 695
query40 226 141 129 129
query41 68 66 66 66
query42 107 104 106 104
query43 426 428 403 403
query44 1337 745 749 745
query45 193 191 181 181
query46 879 986 636 636
query47 1663 1716 1606 1606
query48 315 332 246 246
query49 626 425 357 357
query50 672 302 225 225
query51 3918 3831 3871 3831
query52 110 117 104 104
query53 321 361 296 296
query54 300 270 255 255
query55 79 77 75 75
query56 315 310 296 296
query57 1146 1155 1066 1066
query58 276 264 245 245
query59 2395 2458 2359 2359
query60 332 328 310 310
query61 197 193 194 193
query62 709 708 647 647
query63 335 310 317 310
query64 4962 1312 1039 1039
query65 3985 3941 3930 3930
query66 1385 439 336 336
query67 15034 14979 14840 14840
query68 3340 1069 762 762
query69 478 348 318 318
query70 1000 1012 998 998
query71 367 315 291 291
query72 6232 5109 5350 5109
query73 666 659 309 309
query74 8865 8859 8550 8550
query75 3550 3533 3182 3182
query76 3765 1143 777 777
query77 526 399 286 286
query78 9388 9677 8849 8849
query79 1045 898 636 636
query80 1060 669 558 558
query81 554 278 238 238
query82 201 136 104 104
query83 371 255 247 247
query84 251 119 99 99
query85 950 516 463 463
query86 353 299 304 299
query87 4096 4097 3958 3958
query88 3191 2286 2271 2271
query89 473 416 399 399
query90 1887 162 158 158
query91 180 179 142 142
query92 78 65 69 65
query93 993 929 572 572
query94 481 325 286 286
query95 575 339 318 318
query96 602 465 216 216
query97 2573 2673 2584 2584
query98 206 200 198 198
query99 1289 1302 1200 1200
Total cold run time: 257251 ms
Total hot run time: 181706 ms
ClickBench: Total hot run time: 27.35 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit b52fa36e6bee47b2ac7bf0514b9b8010aa55e522, data reload: false
query1 0.05 0.05 0.05
query2 0.11 0.05 0.05
query3 0.26 0.08 0.08
query4 1.61 0.12 0.11
query5 0.27 0.25 0.25
query6 1.16 0.64 0.63
query7 0.04 0.03 0.03
query8 0.05 0.04 0.04
query9 0.56 0.51 0.50
query10 0.55 0.56 0.55
query11 0.17 0.11 0.12
query12 0.14 0.11 0.11
query13 0.62 0.60 0.61
query14 0.97 0.99 1.00
query15 0.82 0.79 0.82
query16 0.39 0.41 0.42
query17 1.00 1.04 1.02
query18 0.23 0.22 0.22
query19 1.85 1.86 1.79
query20 0.02 0.01 0.02
query21 15.49 0.31 0.14
query22 4.69 0.05 0.05
query23 16.07 0.28 0.10
query24 1.22 0.25 0.57
query25 0.08 0.10 0.08
query26 0.14 0.14 0.13
query27 0.06 0.05 0.04
query28 4.18 1.22 1.02
query29 12.62 4.07 3.30
query30 0.27 0.14 0.12
query31 2.80 0.63 0.38
query32 3.23 0.55 0.46
query33 2.97 3.01 3.05
query34 16.74 5.21 4.56
query35 4.53 4.54 4.54
query36 0.65 0.49 0.49
query37 0.12 0.07 0.06
query38 0.07 0.05 0.03
query39 0.05 0.03 0.03
query40 0.17 0.14 0.13
query41 0.09 0.04 0.03
query42 0.04 0.03 0.03
query43 0.04 0.03 0.04
Total cold run time: 97.19 s
Total hot run time: 27.35 s
TPC-H: Total hot run time: 35309 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 673f995907f0ed9322f346bf0179c62da3b149b8, data reload: false
------ Round 1 ----------------------------------
q1 17633 4147 4051 4051
q2 2031 361 241 241
q3 10155 1340 764 764
q4 10204 827 316 316
q5 7538 2099 1933 1933
q6 183 171 140 140
q7 999 874 712 712
q8 9394 1410 1142 1142
q9 6857 5299 5550 5299
q10 6795 2409 1972 1972
q11 553 312 288 288
q12 652 754 582 582
q13 17772 3653 3015 3015
q14 287 291 279 279
q15 602 539 517 517
q16 951 915 887 887
q17 727 826 487 487
q18 7506 7160 6990 6990
q19 1228 963 608 608
q20 401 366 264 264
q21 4324 4091 3844 3844
q22 1047 1015 978 978
Total cold run time: 107839 ms
Total hot run time: 35309 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4057 4021 4089 4021
q2 339 396 324 324
q3 2150 2729 2347 2347
q4 1347 1745 1337 1337
q5 4294 4148 4166 4148
q6 209 165 127 127
q7 1906 1801 1712 1712
q8 2546 2404 2393 2393
q9 6983 6960 7022 6960
q10 2926 3082 2665 2665
q11 579 505 483 483
q12 651 715 567 567
q13 3306 3639 3025 3025
q14 273 286 272 272
q15 550 507 521 507
q16 900 925 854 854
q17 1103 1368 1395 1368
q18 7390 7032 6963 6963
q19 840 823 848 823
q20 1966 1998 1800 1800
q21 4774 4394 4284 4284
q22 1077 1026 979 979
Total cold run time: 50166 ms
Total hot run time: 47959 ms
TPC-DS: Total hot run time: 182071 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 673f995907f0ed9322f346bf0179c62da3b149b8, data reload: false
query5 5891 645 488 488
query6 338 240 218 218
query7 4213 477 288 288
query8 305 253 242 242
query9 8801 2591 2606 2591
query10 502 376 322 322
query11 15371 14915 14850 14850
query12 185 121 117 117
query13 1263 484 388 388
query14 7748 3414 3083 3083
query14_1 2916 2983 2931 2931
query15 276 206 180 180
query16 858 489 471 471
query17 1268 717 631 631
query18 2690 433 339 339
query19 274 233 204 204
query20 126 127 118 118
query21 226 143 116 116
query22 3853 3952 3780 3780
query23 16586 16087 15954 15954
query23_1 15980 16035 16047 16035
query24 6924 1684 1239 1239
query24_1 1275 1257 1261 1257
query25 543 506 431 431
query26 1235 271 169 169
query27 2719 480 309 309
query28 4510 2169 2165 2165
query29 846 565 444 444
query30 320 246 217 217
query31 815 713 660 660
query32 79 72 70 70
query33 536 344 302 302
query34 887 904 568 568
query35 790 819 746 746
query36 880 916 827 827
query37 138 94 79 79
query38 3874 3912 3761 3761
query39 764 743 716 716
query39_1 691 725 695 695
query40 222 153 127 127
query41 70 63 62 62
query42 118 109 105 105
query43 449 451 409 409
query44 1377 770 757 757
query45 199 195 186 186
query46 919 999 632 632
query47 1654 1674 1607 1607
query48 324 340 252 252
query49 653 443 382 382
query50 682 298 231 231
query51 3841 3815 3842 3815
query52 117 116 106 106
query53 334 370 302 302
query54 298 267 295 267
query55 84 80 76 76
query56 320 330 313 313
query57 1139 1132 1071 1071
query58 275 280 255 255
query59 2343 2564 2401 2401
query60 332 320 289 289
query61 157 159 159 159
query62 716 677 641 641
query63 340 306 313 306
query64 4949 1307 1034 1034
query65 4048 3933 3945 3933
query66 1361 449 327 327
query67 14883 14887 14793 14793
query68 2752 1060 791 791
query69 477 376 334 334
query70 1027 990 992 990
query71 369 325 303 303
query72 6429 5263 5290 5263
query73 522 613 312 312
query74 8745 8882 8610 8610
query75 3536 3599 3221 3221
query76 2846 1180 793 793
query77 387 412 313 313
query78 9663 9806 8893 8893
query79 1097 944 627 627
query80 1432 667 580 580
query81 565 272 244 244
query82 1005 136 108 108
query83 347 263 243 243
query84 257 127 102 102
query85 1019 521 466 466
query86 476 297 281 281
query87 4104 4025 4018 4018
query88 3429 2308 2308 2308
query89 478 434 405 405
query90 1936 166 160 160
query91 176 170 149 149
query92 69 75 65 65
query93 1166 932 569 569
query94 626 307 279 279
query95 560 334 377 334
query96 597 482 216 216
query97 2574 2704 2553 2553
query98 215 213 192 192
query99 1291 1286 1228 1228
Total cold run time: 260018 ms
Total hot run time: 182071 ms
ClickBench: Total hot run time: 27.47 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 673f995907f0ed9322f346bf0179c62da3b149b8, data reload: false
query1 0.06 0.05 0.05
query2 0.10 0.05 0.05
query3 0.25 0.08 0.09
query4 1.62 0.11 0.10
query5 0.26 0.26 0.27
query6 1.16 0.65 0.64
query7 0.04 0.03 0.02
query8 0.05 0.04 0.04
query9 0.55 0.50 0.51
query10 0.56 0.55 0.55
query11 0.16 0.12 0.11
query12 0.14 0.11 0.12
query13 0.62 0.60 0.62
query14 1.02 0.98 0.98
query15 0.82 0.80 0.81
query16 0.40 0.41 0.42
query17 1.03 1.06 1.01
query18 0.23 0.22 0.22
query19 1.89 1.84 1.78
query20 0.02 0.01 0.02
query21 15.44 0.29 0.14
query22 4.72 0.05 0.05
query23 15.92 0.28 0.10
query24 1.26 0.37 0.33
query25 0.11 0.05 0.07
query26 0.14 0.13 0.13
query27 0.06 0.04 0.05
query28 3.79 1.24 1.03
query29 12.62 4.06 3.38
query30 0.30 0.15 0.12
query31 2.82 0.64 0.40
query32 3.23 0.56 0.46
query33 3.07 3.08 3.02
query34 17.11 5.26 4.49
query35 4.58 4.55 4.56
query36 0.65 0.50 0.49
query37 0.12 0.07 0.07
query38 0.07 0.05 0.04
query39 0.04 0.03 0.04
query40 0.17 0.14 0.14
query41 0.08 0.03 0.03
query42 0.04 0.03 0.03
query43 0.04 0.03 0.03
Total cold run time: 97.36 s
Total hot run time: 27.47 s
FE UT Coverage Report
Increment line coverage 100.00% (4/4) :tada:
Increment coverage report
Complete coverage report
FE Regression Coverage Report
Increment line coverage 100.00% (4/4) :tada:
Increment coverage report
Complete coverage report
PR approved by at least one committer and no changes requested.
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
TPC-H: Total hot run time: 36091 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 34e6de950016af63aa2dc64adecd3f865664fa71, data reload: false
------ Round 1 ----------------------------------
q1 17612 4250 4064 4064
q2 2058 373 234 234
q3 10167 1303 750 750
q4 10216 874 317 317
q5 7539 2168 1899 1899
q6 190 169 137 137
q7 1002 845 711 711
q8 9363 1448 1136 1136
q9 7090 5298 5356 5298
q10 6790 2397 1954 1954
q11 537 328 303 303
q12 684 745 576 576
q13 17778 3644 3063 3063
q14 310 305 273 273
q15 582 517 501 501
q16 687 677 640 640
q17 702 760 587 587
q18 7525 7686 7820 7686
q19 1293 1048 637 637
q20 448 380 238 238
q21 4549 4326 4086 4086
q22 1168 1136 1001 1001
Total cold run time: 108290 ms
Total hot run time: 36091 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4295 4201 4251 4201
q2 327 419 324 324
q3 2235 2948 2524 2524
q4 1401 2008 1358 1358
q5 4429 4438 4533 4438
q6 213 163 123 123
q7 2007 2149 1831 1831
q8 2614 2499 2496 2496
q9 7570 7554 7544 7544
q10 3114 3256 2851 2851
q11 587 502 480 480
q12 712 748 615 615
q13 3394 3626 3065 3065
q14 273 273 275 273
q15 525 488 491 488
q16 619 662 610 610
q17 1108 1334 1328 1328
q18 7325 7222 7171 7171
q19 813 798 818 798
q20 1896 1953 1804 1804
q21 4600 4298 4155 4155
q22 1100 1044 982 982
Total cold run time: 51157 ms
Total hot run time: 49459 ms
TPC-DS: Total hot run time: 179177 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 34e6de950016af63aa2dc64adecd3f865664fa71, data reload: false
query5 5221 612 457 457
query6 345 240 227 227
query7 4224 474 306 306
query8 317 248 242 242
query9 8790 2598 2565 2565
query10 522 361 329 329
query11 15719 15032 14914 14914
query12 196 118 116 116
query13 1290 523 391 391
query14 7038 3259 3017 3017
query14_1 2919 2921 2861 2861
query15 210 196 184 184
query16 899 485 457 457
query17 1128 726 614 614
query18 2724 449 361 361
query19 241 230 211 211
query20 117 119 114 114
query21 223 138 121 121
query22 4000 4056 3999 3999
query23 16792 16201 16108 16108
query23_1 16246 16165 16033 16033
query24 7232 1665 1232 1232
query24_1 1266 1242 1233 1233
query25 613 500 464 464
query26 1244 273 172 172
query27 2735 475 310 310
query28 4439 2149 2136 2136
query29 822 592 482 482
query30 326 251 218 218
query31 808 700 646 646
query32 80 75 70 70
query33 580 356 301 301
query34 921 936 548 548
query35 806 865 718 718
query36 878 922 789 789
query37 142 99 73 73
query38 2869 2824 2799 2799
query39 739 727 701 701
query39_1 704 687 696 687
query40 222 138 123 123
query41 65 62 63 62
query42 108 105 103 103
query43 431 437 410 410
query44 1310 747 740 740
query45 194 189 186 186
query46 878 988 614 614
query47 1684 1708 1629 1629
query48 321 322 250 250
query49 640 442 346 346
query50 659 296 222 222
query51 3996 3836 3862 3836
query52 109 110 101 101
query53 321 356 289 289
query54 294 280 249 249
query55 78 75 70 70
query56 290 294 299 294
query57 1160 1150 1091 1091
query58 283 253 254 253
query59 2316 2477 2447 2447
query60 328 343 291 291
query61 164 162 162 162
query62 723 684 623 623
query63 328 293 299 293
query64 4988 1311 1024 1024
query65 4003 3973 3991 3973
query66 1388 455 314 314
query67 15513 15000 14849 14849
query68 8593 1009 730 730
query69 488 364 317 317
query70 1111 1038 982 982
query71 362 308 288 288
query72 6037 4999 4970 4970
query73 666 564 311 311
query74 8884 8956 8618 8618
query75 3185 3125 2773 2773
query76 3922 1153 745 745
query77 541 388 296 296
query78 9632 9568 8811 8811
query79 1622 891 597 597
query80 728 650 555 555
query81 523 267 239 239
query82 510 135 107 107
query83 277 259 254 254
query84 272 128 104 104
query85 930 512 481 481
query86 386 288 279 279
query87 3048 3014 2934 2934
query88 4363 2280 2285 2280
query89 466 421 391 391
query90 2241 164 159 159
query91 181 176 148 148
query92 86 67 67 67
query93 1740 907 545 545
query94 476 316 275 275
query95 574 393 318 318
query96 599 469 209 209
query97 2280 2270 2217 2217
query98 218 195 192 192
query99 1307 1311 1242 1242
Total cold run time: 265498 ms
Total hot run time: 179177 ms
ClickBench: Total hot run time: 27.16 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 34e6de950016af63aa2dc64adecd3f865664fa71, data reload: false
query1 0.06 0.05 0.05
query2 0.10 0.04 0.04
query3 0.26 0.09 0.08
query4 1.61 0.12 0.10
query5 0.27 0.25 0.26
query6 1.17 0.63 0.62
query7 0.03 0.03 0.03
query8 0.06 0.04 0.04
query9 0.57 0.51 0.51
query10 0.56 0.56 0.56
query11 0.16 0.11 0.11
query12 0.16 0.11 0.12
query13 0.62 0.60 0.60
query14 1.00 0.99 0.98
query15 0.82 0.79 0.81
query16 0.39 0.40 0.39
query17 1.07 1.10 1.04
query18 0.24 0.22 0.22
query19 1.96 1.89 1.79
query20 0.02 0.01 0.02
query21 15.44 0.28 0.14
query22 4.88 0.06 0.04
query23 15.99 0.28 0.10
query24 1.86 0.25 0.23
query25 0.11 0.07 0.06
query26 0.14 0.14 0.13
query27 0.06 0.06 0.04
query28 4.34 1.22 1.02
query29 12.60 4.03 3.28
query30 0.28 0.14 0.12
query31 2.82 0.63 0.41
query32 3.22 0.55 0.48
query33 2.99 3.03 2.96
query34 16.81 5.17 4.50
query35 4.60 4.50 4.61
query36 0.67 0.50 0.48
query37 0.11 0.07 0.06
query38 0.07 0.04 0.04
query39 0.05 0.03 0.03
query40 0.17 0.15 0.13
query41 0.09 0.04 0.03
query42 0.05 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 98.52 s
Total hot run time: 27.16 s
FE UT Coverage Report
Increment line coverage 71.43% (20/28) :tada:
Increment coverage report
Complete coverage report
FE Regression Coverage Report
Increment line coverage 71.43% (20/28) :tada:
Increment coverage report
Complete coverage report
TPC-H: Total hot run time: 35915 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 8f63e72fb969e848db1b9cc7712e0e66b30ffaa6, data reload: false
------ Round 1 ----------------------------------
q1 17636 4228 4035 4035
q2 2038 342 231 231
q3 10189 1294 728 728
q4 10220 844 323 323
q5 7522 2153 1881 1881
q6 183 164 134 134
q7 1009 836 704 704
q8 9341 1428 1130 1130
q9 7070 5360 5344 5344
q10 6831 2393 1929 1929
q11 519 319 302 302
q12 664 699 586 586
q13 17779 3707 3025 3025
q14 291 289 285 285
q15 606 519 521 519
q16 693 665 622 622
q17 703 826 515 515
q18 7607 7561 7913 7561
q19 1327 1007 628 628
q20 442 396 259 259
q21 4655 4123 4140 4123
q22 1105 1066 1051 1051
Total cold run time: 108430 ms
Total hot run time: 35915 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4324 4237 4304 4237
q2 337 420 318 318
q3 2562 2960 2512 2512
q4 1309 1922 1375 1375
q5 4595 4448 4466 4448
q6 200 166 125 125
q7 1988 1951 1785 1785
q8 2726 2508 2498 2498
q9 7476 7455 7770 7455
q10 3036 3122 2630 2630
q11 569 493 472 472
q12 667 683 577 577
q13 3366 3624 3037 3037
q14 281 275 269 269
q15 530 498 488 488
q16 611 646 589 589
q17 1129 1339 1339 1339
q18 7240 7193 7059 7059
q19 837 802 838 802
q20 1872 1946 1799 1799
q21 4557 4305 4139 4139
q22 1063 1033 994 994
Total cold run time: 51275 ms
Total hot run time: 48947 ms
TPC-DS: Total hot run time: 179260 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 8f63e72fb969e848db1b9cc7712e0e66b30ffaa6, data reload: false
query5 5388 653 490 490
query6 347 251 217 217
query7 4219 465 296 296
query8 306 262 243 243
query9 8788 2605 2616 2605
query10 544 373 325 325
query11 15526 14688 15053 14688
query12 201 121 118 118
query13 1264 498 395 395
query14 6609 3319 3069 3069
query14_1 3016 3007 2965 2965
query15 218 204 183 183
query16 942 488 465 465
query17 1145 729 582 582
query18 2699 432 334 334
query19 226 229 205 205
query20 122 117 110 110
query21 222 140 126 126
query22 3947 3886 3778 3778
query23 16472 16081 16082 16081
query23_1 16017 16021 16025 16021
query24 7234 1661 1262 1262
query24_1 1255 1244 1284 1244
query25 562 462 423 423
query26 1253 276 162 162
query27 2734 473 310 310
query28 4456 2159 2178 2159
query29 846 546 449 449
query30 315 248 230 230
query31 817 719 611 611
query32 79 75 68 68
query33 532 347 319 319
query34 917 917 554 554
query35 810 826 733 733
query36 867 897 832 832
query37 131 95 79 79
query38 2838 2933 2813 2813
query39 756 742 731 731
query39_1 698 698 717 698
query40 224 143 124 124
query41 71 63 63 63
query42 111 110 108 108
query43 437 433 393 393
query44 1376 752 740 740
query45 197 194 183 183
query46 879 991 608 608
query47 1640 1685 1639 1639
query48 322 335 248 248
query49 616 434 360 360
query50 692 300 226 226
query51 3827 3820 3778 3778
query52 105 112 102 102
query53 324 357 308 308
query54 298 277 258 258
query55 81 76 73 73
query56 312 309 313 309
query57 1130 1118 1080 1080
query58 281 258 262 258
query59 2373 2426 2377 2377
query60 313 327 296 296
query61 165 160 192 160
query62 763 665 629 629
query63 335 302 308 302
query64 5103 1436 1133 1133
query65 4014 3956 3920 3920
query66 1389 479 340 340
query67 15171 15067 14857 14857
query68 5671 1014 736 736
query69 516 364 327 327
query70 1107 1014 976 976
query71 382 330 297 297
query72 6241 4965 5059 4965
query73 693 639 311 311
query74 8794 8918 8656 8656
query75 3186 3132 2797 2797
query76 3905 1163 776 776
query77 496 412 303 303
query78 9476 9630 8862 8862
query79 1629 948 623 623
query80 1448 657 575 575
query81 585 280 234 234
query82 414 137 109 109
query83 297 259 253 253
query84 262 123 105 105
query85 966 517 467 467
query86 466 318 285 285
query87 3029 3105 2984 2984
query88 3279 2299 2281 2281
query89 474 440 394 394
query90 2049 164 160 160
query91 178 163 150 150
query92 76 70 71 70
query93 1572 929 574 574
query94 551 302 282 282
query95 574 330 316 316
query96 598 470 208 208
query97 2294 2269 2191 2191
query98 211 191 194 191
query99 1283 1280 1225 1225
Total cold run time: 260287 ms
Total hot run time: 179260 ms
ClickBench: Total hot run time: 27.32 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 8f63e72fb969e848db1b9cc7712e0e66b30ffaa6, data reload: false
query1 0.05 0.06 0.05
query2 0.09 0.04 0.04
query3 0.25 0.09 0.09
query4 1.62 0.11 0.10
query5 0.27 0.24 0.26
query6 1.14 0.63 0.62
query7 0.03 0.03 0.02
query8 0.06 0.04 0.04
query9 0.55 0.51 0.51
query10 0.56 0.56 0.55
query11 0.17 0.10 0.11
query12 0.15 0.12 0.12
query13 0.61 0.59 0.61
query14 1.00 0.99 1.00
query15 0.81 0.79 0.82
query16 0.39 0.42 0.40
query17 1.07 1.06 1.06
query18 0.23 0.21 0.22
query19 1.93 1.85 1.82
query20 0.01 0.01 0.01
query21 15.43 0.27 0.14
query22 4.67 0.04 0.05
query23 16.02 0.28 0.11
query24 1.44 0.68 0.23
query25 0.09 0.06 0.07
query26 0.14 0.14 0.13
query27 0.06 0.04 0.05
query28 4.26 1.21 1.03
query29 12.59 4.15 3.28
query30 0.28 0.14 0.12
query31 2.82 0.62 0.40
query32 3.23 0.55 0.45
query33 3.03 3.02 3.05
query34 16.55 5.19 4.58
query35 4.62 4.51 4.55
query36 0.67 0.50 0.49
query37 0.11 0.06 0.06
query38 0.07 0.04 0.04
query39 0.05 0.03 0.03
query40 0.17 0.14 0.13
query41 0.08 0.03 0.03
query42 0.04 0.02 0.02
query43 0.05 0.04 0.03
Total cold run time: 97.46 s
Total hot run time: 27.32 s
FE UT Coverage Report
Increment line coverage 71.43% (20/28) :tada:
Increment coverage report
Complete coverage report
FE Regression Coverage Report
Increment line coverage 71.43% (20/28) :tada:
Increment coverage report
Complete coverage report
FE Regression Coverage Report
Increment line coverage 71.43% (20/28) :tada:
Increment coverage report
Complete coverage report
TPC-H: Total hot run time: 35998 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 0db36a094eca7a6f7c8cb95c72f2b555ebe0533d, data reload: false
------ Round 1 ----------------------------------
q1 17672 4175 4041 4041
q2 2074 342 235 235
q3 10152 1300 741 741
q4 10214 843 314 314
q5 7542 2150 1862 1862
q6 182 168 135 135
q7 997 863 711 711
q8 9362 1449 1199 1199
q9 7023 5342 5325 5325
q10 6793 2401 1973 1973
q11 529 319 304 304
q12 642 737 560 560
q13 17771 3680 3019 3019
q14 296 304 279 279
q15 593 525 517 517
q16 685 658 627 627
q17 678 766 569 569
q18 7365 7367 7850 7367
q19 1123 996 624 624
q20 418 392 255 255
q21 4691 4306 4317 4306
q22 1092 1054 1035 1035
Total cold run time: 107894 ms
Total hot run time: 35998 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4191 4353 4280 4280
q2 331 396 332 332
q3 2378 2743 2518 2518
q4 1472 1945 1375 1375
q5 4602 4579 4433 4433
q6 220 176 125 125
q7 1993 2099 1803 1803
q8 2678 2530 2519 2519
q9 7539 7577 7500 7500
q10 3084 3305 2795 2795
q11 617 544 502 502
q12 673 764 655 655
q13 3327 3677 3046 3046
q14 270 292 255 255
q15 535 490 486 486
q16 609 639 590 590
q17 1117 1425 1330 1330
q18 7385 7189 7028 7028
q19 856 808 816 808
q20 1917 1972 1793 1793
q21 4759 4276 4216 4216
q22 1090 1021 970 970
Total cold run time: 51643 ms
Total hot run time: 49359 ms
TPC-DS: Total hot run time: 177814 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 0db36a094eca7a6f7c8cb95c72f2b555ebe0533d, data reload: false
query5 4857 603 457 457
query6 337 260 235 235
query7 4226 463 276 276
query8 311 246 241 241
query9 8791 2575 2541 2541
query10 508 385 341 341
query11 15491 14719 14426 14426
query12 182 118 110 110
query13 1273 512 421 421
query14 6180 3258 3025 3025
query14_1 2924 2888 2961 2888
query15 205 196 180 180
query16 891 478 458 458
query17 1130 749 609 609
query18 2644 421 332 332
query19 222 218 209 209
query20 119 113 110 110
query21 218 135 114 114
query22 3995 3874 3881 3874
query23 16571 16355 15912 15912
query23_1 16173 16117 15942 15942
query24 7316 1696 1259 1259
query24_1 1225 1224 1223 1223
query25 552 524 413 413
query26 1246 263 157 157
query27 2775 472 307 307
query28 4451 2153 2140 2140
query29 804 528 434 434
query30 319 241 213 213
query31 847 698 637 637
query32 79 70 70 70
query33 550 339 287 287
query34 899 900 534 534
query35 786 831 719 719
query36 846 922 840 840
query37 128 103 88 88
query38 2840 2829 2801 2801
query39 781 729 745 729
query39_1 694 709 682 682
query40 230 137 118 118
query41 68 64 66 64
query42 108 104 102 102
query43 437 427 406 406
query44 1319 745 738 738
query45 194 189 184 184
query46 868 984 618 618
query47 1665 1704 1604 1604
query48 310 329 255 255
query49 627 432 347 347
query50 669 286 219 219
query51 3828 3820 3796 3796
query52 103 107 103 103
query53 327 362 301 301
query54 290 254 246 246
query55 79 74 70 70
query56 299 299 282 282
query57 1129 1122 1060 1060
query58 272 260 256 256
query59 2370 2442 2328 2328
query60 312 312 289 289
query61 166 151 178 151
query62 725 712 621 621
query63 336 302 311 302
query64 5135 1430 1124 1124
query65 4010 4027 4020 4020
query66 1445 466 331 331
query67 14977 15221 14741 14741
query68 6124 1007 737 737
query69 524 352 319 319
query70 1093 1020 966 966
query71 380 317 292 292
query72 6189 4971 4857 4857
query73 654 545 306 306
query74 8750 8658 8569 8569
query75 3177 3115 2748 2748
query76 3904 1148 759 759
query77 521 397 281 281
query78 9494 9515 8952 8952
query79 1296 882 623 623
query80 695 656 549 549
query81 519 265 237 237
query82 224 140 103 103
query83 262 251 234 234
query84 257 121 103 103
query85 909 504 464 464
query86 386 283 286 283
query87 3037 3009 2952 2952
query88 3223 2262 2259 2259
query89 465 417 395 395
query90 2177 164 158 158
query91 177 166 141 141
query92 82 68 60 60
query93 1415 919 551 551
query94 473 304 296 296
query95 583 321 360 321
query96 597 470 210 210
query97 2305 2324 2203 2203
query98 215 190 194 190
query99 1307 1282 1262 1262
Total cold run time: 257918 ms
Total hot run time: 177814 ms