search

apache / doris

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

Revert "[Fix](log)To avoid SLF4J multiple binding issues and unnecessary dependency propagation." #44347

Closed morningman closed 1 day ago

morningman commented 1 day ago

Reverts apache/doris#44310

doris-robot commented 1 day ago

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:

  1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
  2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
  3. What features were added. Why was this function added?
  4. Which code was refactored and why was this part of the code refactored?
  5. Which functions were optimized and what is the difference before and after the optimization?
morningman commented 1 day ago

run buildall

github-actions[bot] commented 1 day ago

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

github-actions[bot] commented 1 day ago

PR approved by anyone and no changes requested.

doris-robot commented 1 day ago
TPC-H: Total hot run time: 39927 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1f70110afc2a453d1cceaa1f828f875b5c4558f7, data reload: false ------ Round 1 ---------------------------------- q1 17570 7455 7498 7455 q2 2046 175 166 166 q3 10595 1059 1201 1059 q4 10492 746 753 746 q5 7613 2691 2671 2671 q6 235 151 147 147 q7 982 626 605 605 q8 9265 1845 1907 1845 q9 6503 6465 6417 6417 q10 7014 2344 2323 2323 q11 473 261 272 261 q12 437 218 226 218 q13 17770 3040 3015 3015 q14 239 217 212 212 q15 570 538 515 515 q16 668 583 570 570 q17 982 597 572 572 q18 7295 6687 6656 6656 q19 1340 1088 923 923 q20 457 185 182 182 q21 4014 3059 3237 3059 q22 364 312 310 310 Total cold run time: 106924 ms Total hot run time: 39927 ms ----- Round 2, with runtime_filter_mode=off ----- q1 7295 7232 7231 7231 q2 327 232 226 226 q3 2949 2831 2973 2831 q4 2048 1777 1779 1777 q5 5723 5653 5706 5653 q6 221 140 141 140 q7 2254 1799 1823 1799 q8 3476 3595 3511 3511 q9 8904 8905 8846 8846 q10 3614 3560 3544 3544 q11 606 508 516 508 q12 813 646 644 644 q13 12212 3240 3200 3200 q14 312 281 280 280 q15 568 514 526 514 q16 670 646 634 634 q17 1854 1632 1619 1619 q18 8242 7816 7703 7703 q19 1724 1619 1656 1619 q20 2105 1876 1853 1853 q21 5536 5359 5399 5359 q22 678 592 582 582 Total cold run time: 72131 ms Total hot run time: 60073 ms ```
hello-stephen commented 1 day ago

skip buildall

doris-robot commented 1 day ago
TPC-DS: Total hot run time: 195433 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 1f70110afc2a453d1cceaa1f828f875b5c4558f7, data reload: false query1 1254 960 957 957 query2 6274 2209 2163 2163 query3 10890 4103 4040 4040 query4 67456 28720 23611 23611 query5 5007 467 470 467 query6 397 189 180 180 query7 5482 293 296 293 query8 300 201 215 201 query9 8651 2663 2655 2655 query10 447 239 239 239 query11 16994 15164 15921 15164 query12 153 99 106 99 query13 1468 418 430 418 query14 10897 7240 6652 6652 query15 213 198 192 192 query16 7097 469 497 469 query17 1057 581 607 581 query18 1792 306 295 295 query19 204 160 155 155 query20 122 117 113 113 query21 203 106 104 104 query22 4683 4491 4445 4445 query23 34555 34311 34177 34177 query24 5338 2406 2446 2406 query25 480 383 391 383 query26 641 150 152 150 query27 1692 282 290 282 query28 3993 2488 2398 2398 query29 654 409 399 399 query30 212 145 143 143 query31 987 798 816 798 query32 66 54 59 54 query33 456 274 276 274 query34 959 501 511 501 query35 819 713 733 713 query36 1079 952 966 952 query37 126 73 94 73 query38 4265 4241 4253 4241 query39 1448 1433 1378 1378 query40 199 94 96 94 query41 44 42 46 42 query42 107 107 97 97 query43 547 509 492 492 query44 1178 806 802 802 query45 178 160 157 157 query46 1177 707 684 684 query47 1969 1863 1901 1863 query48 412 319 310 310 query49 725 385 389 385 query50 829 372 386 372 query51 7295 7045 7085 7045 query52 102 85 91 85 query53 261 175 178 175 query54 512 407 396 396 query55 80 76 74 74 query56 271 264 245 245 query57 1314 1193 1154 1154 query58 220 217 208 208 query59 3408 3226 3011 3011 query60 272 271 243 243 query61 111 105 111 105 query62 827 687 692 687 query63 211 186 186 186 query64 1363 668 630 630 query65 3346 3206 3219 3206 query66 696 306 313 306 query67 16031 15687 15792 15687 query68 4042 566 555 555 query69 439 252 257 252 query70 1191 1139 1081 1081 query71 372 252 256 252 query72 6526 4062 3997 3997 query73 767 353 361 353 query74 10308 8976 8969 8969 query75 3434 2652 2651 2651 query76 1767 1029 1015 1015 query77 514 299 268 268 query78 10490 9531 9405 9405 query79 2126 607 603 603 query80 1414 427 427 427 query81 526 231 239 231 query82 1258 116 117 116 query83 177 152 148 148 query84 275 71 72 71 query85 979 308 365 308 query86 398 306 306 306 query87 4617 4508 4549 4508 query88 3513 2195 2156 2156 query89 435 295 292 292 query90 1987 187 185 185 query91 137 100 172 100 query92 68 50 51 50 query93 2942 543 544 543 query94 847 301 297 297 query95 352 265 245 245 query96 620 282 285 282 query97 2885 2700 2689 2689 query98 212 200 200 200 query99 1620 1333 1322 1322 Total cold run time: 319734 ms Total hot run time: 195433 ms ```
doris-robot commented 1 day ago
ClickBench: Total hot run time: 33.07 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1f70110afc2a453d1cceaa1f828f875b5c4558f7, data reload: false query1 0.04 0.04 0.03 query2 0.06 0.03 0.04 query3 0.22 0.07 0.07 query4 1.62 0.10 0.10 query5 0.41 0.41 0.42 query6 1.14 0.66 0.65 query7 0.03 0.02 0.01 query8 0.04 0.03 0.03 query9 0.58 0.50 0.50 query10 0.54 0.55 0.57 query11 0.14 0.10 0.11 query12 0.14 0.11 0.11 query13 0.60 0.61 0.59 query14 2.69 2.86 2.88 query15 0.89 0.84 0.82 query16 0.39 0.39 0.39 query17 1.05 1.02 1.04 query18 0.21 0.19 0.21 query19 1.97 1.87 1.99 query20 0.02 0.00 0.01 query21 15.36 0.59 0.58 query22 2.81 1.92 1.86 query23 17.01 1.02 0.81 query24 3.13 1.38 1.39 query25 0.28 0.05 0.13 query26 0.52 0.13 0.14 query27 0.05 0.04 0.06 query28 10.14 1.11 1.08 query29 12.60 3.22 3.16 query30 0.25 0.06 0.06 query31 2.87 0.40 0.37 query32 3.27 0.46 0.47 query33 3.15 2.97 3.02 query34 17.14 4.50 4.49 query35 4.55 4.53 4.49 query36 0.66 0.49 0.49 query37 0.09 0.06 0.06 query38 0.04 0.04 0.04 query39 0.04 0.02 0.02 query40 0.15 0.14 0.13 query41 0.07 0.02 0.02 query42 0.04 0.02 0.02 query43 0.04 0.03 0.03 Total cold run time: 107.04 s Total hot run time: 33.07 s ```