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](join) delete code that's useless #37016

Open jacktengg opened 3 days ago

jacktengg commented 3 days ago

Proposed changes

Issue Number: close #xxx

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.

jacktengg commented 3 days ago

run buildall

github-actions[bot] commented 3 days ago

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] commented 3 days ago

clang-tidy review says "All clean, LGTM! :+1:"

doris-robot commented 3 days ago
TPC-H: Total hot run time: 40427 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 6d8866f59e126c45d1be2dca33fc8f99749549ef, data reload: false ------ Round 1 ---------------------------------- q1 17609 4324 4302 4302 q2 2018 189 198 189 q3 10449 1140 1126 1126 q4 10189 891 809 809 q5 7500 2679 2658 2658 q6 219 141 137 137 q7 945 603 607 603 q8 9228 2069 2066 2066 q9 8905 6501 6454 6454 q10 8951 3717 3698 3698 q11 464 242 243 242 q12 422 239 231 231 q13 17764 2960 3018 2960 q14 253 226 212 212 q15 511 485 462 462 q16 529 375 381 375 q17 960 680 635 635 q18 7943 7399 7304 7304 q19 5575 1487 1520 1487 q20 651 320 336 320 q21 4938 3822 3936 3822 q22 385 335 342 335 Total cold run time: 116408 ms Total hot run time: 40427 ms ----- Round 2, with runtime_filter_mode=off ----- q1 4387 4218 4227 4218 q2 360 282 274 274 q3 2956 2864 2785 2785 q4 2011 1739 1706 1706 q5 5697 5481 5473 5473 q6 226 128 128 128 q7 2208 1832 1850 1832 q8 3276 3388 3424 3388 q9 8739 8766 8785 8766 q10 4129 3920 3740 3740 q11 611 505 520 505 q12 861 643 644 643 q13 16071 3180 3179 3179 q14 297 291 287 287 q15 525 485 490 485 q16 490 427 443 427 q17 1827 1513 1504 1504 q18 8161 8017 7797 7797 q19 2069 1649 1717 1649 q20 3118 1869 1840 1840 q21 5175 5002 4720 4720 q22 629 565 545 545 Total cold run time: 73823 ms Total hot run time: 55891 ms ```
doris-robot commented 3 days ago
TPC-DS: Total hot run time: 175278 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 6d8866f59e126c45d1be2dca33fc8f99749549ef, data reload: false query1 915 379 375 375 query2 6454 2400 2260 2260 query3 6643 205 215 205 query4 20125 17466 17484 17466 query5 3699 468 467 467 query6 261 178 172 172 query7 4598 285 293 285 query8 312 279 284 279 query9 8649 2471 2446 2446 query10 576 298 293 293 query11 10668 10262 10245 10245 query12 120 90 84 84 query13 1661 372 369 369 query14 10129 7610 7231 7231 query15 248 191 198 191 query16 7989 307 271 271 query17 1839 546 536 536 query18 2042 279 278 278 query19 193 155 163 155 query20 90 84 85 84 query21 217 135 123 123 query22 4686 4288 4193 4193 query23 34041 33807 33810 33807 query24 10654 2972 2935 2935 query25 607 415 393 393 query26 713 156 153 153 query27 2328 361 330 330 query28 6071 2213 2195 2195 query29 881 690 646 646 query30 248 160 166 160 query31 1000 784 773 773 query32 96 57 56 56 query33 740 285 271 271 query34 854 467 492 467 query35 754 618 611 611 query36 1178 1011 978 978 query37 141 73 74 73 query38 2986 2909 2850 2850 query39 898 836 835 835 query40 209 130 127 127 query41 53 55 50 50 query42 108 102 103 102 query43 571 560 554 554 query44 1115 744 761 744 query45 195 162 162 162 query46 1077 704 702 702 query47 1913 1766 1798 1766 query48 376 297 291 291 query49 907 401 428 401 query50 773 384 393 384 query51 6912 6779 6812 6779 query52 100 93 92 92 query53 357 294 304 294 query54 885 444 443 443 query55 72 74 71 71 query56 288 256 259 256 query57 1144 1079 1038 1038 query58 239 272 263 263 query59 3267 3277 3296 3277 query60 309 269 279 269 query61 94 89 90 89 query62 615 444 433 433 query63 317 292 280 280 query64 8649 2269 1747 1747 query65 3154 3093 3076 3076 query66 749 323 326 323 query67 15523 15116 14867 14867 query68 4588 545 547 545 query69 669 451 385 385 query70 1239 1091 1123 1091 query71 449 269 275 269 query72 9215 5629 5276 5276 query73 746 324 326 324 query74 5916 5600 5663 5600 query75 4106 2660 2644 2644 query76 3015 916 869 869 query77 676 302 306 302 query78 10586 10047 9848 9848 query79 2574 524 526 524 query80 2556 462 456 456 query81 570 226 223 223 query82 1033 108 102 102 query83 329 174 172 172 query84 264 89 84 84 query85 1329 279 329 279 query86 466 317 288 288 query87 3369 3154 3123 3123 query88 4136 2366 2345 2345 query89 460 375 387 375 query90 1821 187 193 187 query91 127 97 97 97 query92 58 51 48 48 query93 2632 531 524 524 query94 1177 194 190 190 query95 400 311 308 308 query96 592 263 267 263 query97 3253 3084 3160 3084 query98 221 198 195 195 query99 1156 847 837 837 Total cold run time: 276003 ms Total hot run time: 175278 ms ```
doris-robot commented 3 days ago
ClickBench: Total hot run time: 30.89 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 6d8866f59e126c45d1be2dca33fc8f99749549ef, data reload: false query1 0.04 0.04 0.03 query2 0.08 0.04 0.04 query3 0.23 0.05 0.05 query4 1.67 0.08 0.07 query5 0.50 0.48 0.49 query6 1.13 0.74 0.72 query7 0.03 0.01 0.02 query8 0.05 0.04 0.04 query9 0.54 0.50 0.49 query10 0.55 0.54 0.55 query11 0.16 0.11 0.11 query12 0.14 0.13 0.12 query13 0.58 0.58 0.59 query14 0.75 0.77 0.78 query15 0.84 0.81 0.80 query16 0.37 0.36 0.37 query17 0.99 0.96 0.95 query18 0.22 0.25 0.24 query19 1.76 1.74 1.78 query20 0.02 0.01 0.01 query21 15.44 0.74 0.66 query22 3.87 6.80 2.22 query23 18.34 1.38 1.19 query24 2.06 0.25 0.22 query25 0.16 0.09 0.08 query26 0.27 0.17 0.18 query27 0.07 0.08 0.09 query28 13.21 1.02 1.00 query29 12.57 3.36 3.30 query30 0.26 0.06 0.06 query31 2.85 0.39 0.40 query32 3.27 0.47 0.48 query33 2.90 2.90 2.91 query34 16.89 4.44 4.49 query35 4.52 4.49 4.48 query36 0.65 0.46 0.50 query37 0.18 0.16 0.16 query38 0.15 0.14 0.14 query39 0.05 0.04 0.04 query40 0.16 0.15 0.15 query41 0.09 0.05 0.04 query42 0.06 0.05 0.05 query43 0.04 0.04 0.04 Total cold run time: 108.71 s Total hot run time: 30.89 s ```