apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
11.8k stars 3.11k forks source link

[chore](upgrade) turn off fallback_to_original_planner when upgrade #37005

Closed morrySnow closed 3 days ago

morrySnow commented 3 days ago

upgrade from 2.1 or ealier version to 3.0.x will

doris-robot commented 3 days ago

Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR

Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.

morrySnow commented 3 days ago

run buildall

doris-robot commented 3 days ago
TPC-H: Total hot run time: 39470 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit d69e61e8704bd6675cdbaa9364ed97d5ba61725a, data reload: false ------ Round 1 ---------------------------------- q1 17629 4363 4274 4274 q2 2007 187 192 187 q3 10434 1222 1065 1065 q4 10184 879 742 742 q5 7478 2595 2621 2595 q6 211 135 136 135 q7 934 584 578 578 q8 9237 2044 2042 2042 q9 8961 6466 6464 6464 q10 9046 3708 3685 3685 q11 443 236 232 232 q12 448 236 230 230 q13 17792 2982 2948 2948 q14 267 230 211 211 q15 509 471 491 471 q16 493 361 368 361 q17 959 727 640 640 q18 7858 7341 7375 7341 q19 7088 1485 1450 1450 q20 643 330 338 330 q21 4843 3151 3190 3151 q22 397 338 341 338 Total cold run time: 117861 ms Total hot run time: 39470 ms ----- Round 2, with runtime_filter_mode=off ----- q1 4373 4210 4224 4210 q2 371 282 277 277 q3 2975 2861 2852 2852 q4 1968 1717 1676 1676 q5 5626 5509 5468 5468 q6 219 130 131 130 q7 2213 1872 1847 1847 q8 3271 3387 3416 3387 q9 8641 8593 8750 8593 q10 4139 3841 3649 3649 q11 572 497 499 497 q12 834 667 608 608 q13 16189 3181 3206 3181 q14 298 271 287 271 q15 528 488 489 488 q16 486 424 428 424 q17 1788 1522 1497 1497 q18 8143 7930 7661 7661 q19 1799 1715 1495 1495 q20 2132 1848 1834 1834 q21 5209 4973 4772 4772 q22 624 553 587 553 Total cold run time: 72398 ms Total hot run time: 55370 ms ```
doris-robot commented 3 days ago
TPC-DS: Total hot run time: 174499 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 d69e61e8704bd6675cdbaa9364ed97d5ba61725a, data reload: false query1 909 375 372 372 query2 6442 2384 2371 2371 query3 6638 204 216 204 query4 19329 17641 17371 17371 query5 3668 459 485 459 query6 278 170 158 158 query7 4592 290 300 290 query8 310 290 298 290 query9 8533 2464 2430 2430 query10 557 302 292 292 query11 10416 9977 10098 9977 query12 117 88 83 83 query13 1655 365 362 362 query14 9689 7858 7532 7532 query15 227 190 188 188 query16 7546 262 262 262 query17 1923 542 532 532 query18 1220 278 267 267 query19 196 149 152 149 query20 88 86 85 85 query21 214 128 131 128 query22 4549 4039 3935 3935 query23 33868 33619 33786 33619 query24 10634 2836 2883 2836 query25 597 384 373 373 query26 714 156 150 150 query27 2256 319 323 319 query28 6564 2182 2174 2174 query29 909 634 646 634 query30 243 162 153 153 query31 954 786 787 786 query32 96 57 54 54 query33 756 282 326 282 query34 1053 467 478 467 query35 749 659 643 643 query36 1141 996 971 971 query37 140 80 72 72 query38 2973 2886 2828 2828 query39 884 846 845 845 query40 200 127 120 120 query41 55 53 53 53 query42 121 97 100 97 query43 578 523 545 523 query44 1196 751 741 741 query45 191 163 162 162 query46 1096 702 697 697 query47 1862 1807 1764 1764 query48 370 306 297 297 query49 843 425 419 419 query50 760 382 390 382 query51 6938 6829 6795 6795 query52 104 94 94 94 query53 353 285 281 281 query54 910 444 439 439 query55 74 74 72 72 query56 280 255 259 255 query57 1134 1048 1036 1036 query58 252 238 235 235 query59 3365 3218 3239 3218 query60 293 268 282 268 query61 96 94 92 92 query62 637 445 426 426 query63 315 293 283 283 query64 8829 2346 1758 1758 query65 3257 3120 3124 3120 query66 804 324 325 324 query67 15435 14955 14807 14807 query68 4504 542 541 541 query69 495 404 349 349 query70 1146 1097 1135 1097 query71 395 282 271 271 query72 6921 5404 5727 5404 query73 743 322 318 318 query74 5910 5531 5426 5426 query75 3312 2677 2681 2677 query76 2306 982 892 892 query77 431 303 298 298 query78 10748 9850 9825 9825 query79 2290 519 521 519 query80 1033 471 460 460 query81 580 218 220 218 query82 679 101 102 101 query83 321 167 169 167 query84 233 87 88 87 query85 1605 286 273 273 query86 470 328 340 328 query87 3317 3152 3145 3145 query88 4234 2346 2334 2334 query89 476 380 382 380 query90 1756 188 187 187 query91 128 100 100 100 query92 59 50 47 47 query93 2172 524 513 513 query94 1102 187 182 182 query95 396 309 323 309 query96 596 268 263 263 query97 3215 3044 3073 3044 query98 207 200 197 197 query99 1283 866 846 846 Total cold run time: 267038 ms Total hot run time: 174499 ms ```
doris-robot commented 3 days ago
ClickBench: Total hot run time: 30.6 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit d69e61e8704bd6675cdbaa9364ed97d5ba61725a, data reload: false query1 0.04 0.03 0.03 query2 0.07 0.04 0.04 query3 0.23 0.06 0.05 query4 1.67 0.07 0.07 query5 0.51 0.48 0.50 query6 1.14 0.72 0.72 query7 0.02 0.02 0.01 query8 0.06 0.04 0.04 query9 0.54 0.49 0.49 query10 0.53 0.54 0.55 query11 0.16 0.12 0.11 query12 0.14 0.12 0.12 query13 0.60 0.59 0.60 query14 0.75 0.78 0.78 query15 0.84 0.80 0.80 query16 0.38 0.36 0.37 query17 1.02 1.00 0.97 query18 0.21 0.25 0.23 query19 1.83 1.72 1.71 query20 0.01 0.00 0.00 query21 15.43 0.74 0.64 query22 3.90 7.66 1.98 query23 18.29 1.42 1.33 query24 2.18 0.22 0.21 query25 0.15 0.09 0.08 query26 0.26 0.18 0.17 query27 0.09 0.08 0.08 query28 13.18 1.02 0.99 query29 12.56 3.28 3.26 query30 0.25 0.06 0.05 query31 2.86 0.39 0.38 query32 3.29 0.45 0.48 query33 2.89 2.92 2.92 query34 17.05 4.44 4.40 query35 4.48 4.47 4.48 query36 0.65 0.46 0.46 query37 0.19 0.16 0.15 query38 0.15 0.14 0.15 query39 0.04 0.03 0.04 query40 0.17 0.15 0.15 query41 0.09 0.04 0.04 query42 0.05 0.05 0.04 query43 0.05 0.04 0.04 Total cold run time: 109 s Total hot run time: 30.6 s ```
github-actions[bot] commented 3 days ago

PR approved by at least one committer and no changes requested.

github-actions[bot] commented 3 days ago

PR approved by anyone and no changes requested.