doris
doris copied to clipboard
apache
[fix](analyzer) fix some fill up missing slot errors and make some error hint happy
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: 36410 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit aed98fa4b3880749c07bd92d9be90e6a5b7d8c93, data reload: false
------ Round 1 ----------------------------------
q1 17623 4203 4214 4203
q2 2027 353 238 238
q3 10153 1322 772 772
q4 10213 823 314 314
q5 7493 2161 1965 1965
q6 196 176 139 139
q7 1024 857 713 713
q8 9363 1498 1281 1281
q9 7009 5399 5484 5399
q10 6900 2419 2004 2004
q11 513 329 306 306
q12 681 790 601 601
q13 18505 3847 3184 3184
q14 300 320 272 272
q15 590 540 531 531
q16 980 951 892 892
q17 725 851 561 561
q18 7720 7263 7305 7263
q19 1132 980 633 633
q20 400 374 252 252
q21 4280 4024 3940 3940
q22 1008 1003 947 947
Total cold run time: 108835 ms
Total hot run time: 36410 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4210 4073 4078 4073
q2 318 414 320 320
q3 2160 2727 2372 2372
q4 1360 1789 1320 1320
q5 4658 4873 4631 4631
q6 224 179 134 134
q7 2019 1933 1858 1858
q8 2729 2465 2547 2465
q9 7485 7427 7603 7427
q10 3057 3297 2872 2872
q11 686 532 499 499
q12 840 832 642 642
q13 3648 4016 3499 3499
q14 307 327 289 289
q15 552 524 512 512
q16 919 928 930 928
q17 1268 1524 1548 1524
q18 7929 7804 7487 7487
q19 950 890 869 869
q20 1955 1952 1849 1849
q21 4778 4376 4244 4244
q22 1107 1033 976 976
Total cold run time: 53159 ms
Total hot run time: 50790 ms
TPC-DS: Total hot run time: 181179 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 aed98fa4b3880749c07bd92d9be90e6a5b7d8c93, data reload: false
query5 5122 641 476 476
query6 328 224 214 214
query7 4229 464 282 282
query8 314 263 240 240
query9 8782 2586 2587 2586
query10 576 402 338 338
query11 15118 15181 14459 14459
query12 192 119 114 114
query13 1272 514 401 401
query14 6736 3242 3024 3024
query14_1 2921 2970 2976 2970
query15 218 209 194 194
query16 890 452 447 447
query17 1124 720 616 616
query18 2711 453 359 359
query19 234 238 212 212
query20 124 111 114 111
query21 226 143 118 118
query22 3963 3952 3906 3906
query23 16526 16135 16029 16029
query23_1 15918 16030 16003 16003
query24 7295 1662 1227 1227
query24_1 1239 1258 1264 1258
query25 601 511 442 442
query26 1247 272 165 165
query27 2738 468 312 312
query28 4468 2150 2163 2150
query29 824 573 509 509
query30 311 229 212 212
query31 814 701 629 629
query32 74 73 67 67
query33 532 338 298 298
query34 892 893 532 532
query35 780 817 716 716
query36 876 927 803 803
query37 133 90 76 76
query38 3838 3902 3867 3867
query39 755 747 722 722
query39_1 700 706 691 691
query40 218 137 122 122
query41 68 66 61 61
query42 106 107 107 107
query43 435 434 397 397
query44 1318 769 754 754
query45 196 195 184 184
query46 893 987 626 626
query47 1679 1722 1615 1615
query48 312 336 250 250
query49 615 441 399 399
query50 664 310 220 220
query51 3761 3828 3891 3828
query52 104 107 99 99
query53 321 357 293 293
query54 294 264 260 260
query55 79 76 73 73
query56 300 310 288 288
query57 1135 1145 1076 1076
query58 273 254 255 254
query59 2316 2487 2391 2391
query60 312 315 292 292
query61 162 158 162 158
query62 696 683 606 606
query63 325 297 311 297
query64 4958 1311 993 993
query65 3960 3929 3998 3929
query66 1397 434 335 335
query67 15224 15166 14777 14777
query68 7633 1006 738 738
query69 507 353 309 309
query70 1086 993 990 990
query71 348 321 285 285
query72 6141 5002 4855 4855
query73 687 591 306 306
query74 8702 8793 8592 8592
query75 3596 3539 3180 3180
query76 3901 1159 789 789
query77 523 395 299 299
query78 9427 9581 8892 8892
query79 1645 881 624 624
query80 728 671 562 562
query81 497 270 232 232
query82 412 139 107 107
query83 267 253 238 238
query84 262 127 100 100
query85 908 508 475 475
query86 320 303 283 283
query87 4003 4074 3986 3986
query88 3214 2299 2292 2292
query89 467 426 400 400
query90 2023 158 148 148
query91 171 174 171 171
query92 72 71 67 67
query93 1174 912 572 572
query94 494 305 270 270
query95 569 341 321 321
query96 597 467 213 213
query97 2575 2677 2564 2564
query98 210 205 204 204
query99 1287 1318 1197 1197
Total cold run time: 262172 ms
Total hot run time: 181179 ms
ClickBench: Total hot run time: 27.6 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit aed98fa4b3880749c07bd92d9be90e6a5b7d8c93, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.04
query3 0.26 0.09 0.10
query4 1.61 0.12 0.11
query5 0.28 0.26 0.25
query6 1.15 0.64 0.64
query7 0.04 0.03 0.02
query8 0.06 0.04 0.04
query9 0.57 0.51 0.51
query10 0.53 0.56 0.55
query11 0.16 0.11 0.12
query12 0.14 0.12 0.12
query13 0.61 0.60 0.60
query14 1.00 1.00 0.99
query15 0.81 0.79 0.81
query16 0.39 0.39 0.41
query17 0.99 1.04 1.04
query18 0.24 0.22 0.22
query19 1.93 1.84 1.91
query20 0.01 0.01 0.01
query21 15.44 0.28 0.13
query22 4.69 0.05 0.05
query23 15.99 0.28 0.11
query24 1.41 0.32 0.42
query25 0.06 0.06 0.05
query26 0.14 0.13 0.13
query27 0.05 0.05 0.05
query28 3.71 1.22 1.04
query29 12.61 3.96 3.28
query30 0.29 0.13 0.12
query31 2.83 0.65 0.42
query32 3.23 0.56 0.47
query33 3.01 3.05 3.03
query34 16.89 5.17 4.60
query35 4.56 4.53 4.53
query36 0.67 0.49 0.50
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.14
query41 0.09 0.04 0.03
query42 0.05 0.03 0.03
query43 0.04 0.04 0.04
Total cold run time: 97.09 s
Total hot run time: 27.6 s
FE Regression Coverage Report
Increment line coverage 85.12% (183/215) :tada:
Increment coverage report
Complete coverage report
