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.28k forks source link

[Enhancement] (nereids)implement showStoragePolicyCommand in nereids #44393

Open msridhar78 opened 17 hours ago

msridhar78 commented 17 hours ago

What problem does this PR solve?

Issue Number: close #42721

Problem Summary:

[Enhancement] (nereids)implement showStoragePolicyCommand in nereids

Release note

None

Check List (For Author)

Check List (For Reviewer who merge this PR)

doris-robot commented 17 hours 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?
msridhar78 commented 17 hours ago

run buildall

doris-robot commented 17 hours ago
TPC-H: Total hot run time: 40179 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit f1124e44cd4bf27eb85dcc04805cdf8ef39b4e68, data reload: false ------ Round 1 ---------------------------------- q1 17601 7464 7250 7250 q2 2044 175 167 167 q3 10657 1073 1187 1073 q4 10588 812 762 762 q5 7615 2736 2739 2736 q6 241 151 150 150 q7 1003 656 604 604 q8 9217 1871 1892 1871 q9 6598 6390 6407 6390 q10 7044 2331 2323 2323 q11 466 265 260 260 q12 428 231 221 221 q13 17801 3022 3098 3022 q14 247 225 218 218 q15 572 531 521 521 q16 673 607 585 585 q17 987 550 534 534 q18 7469 6972 6864 6864 q19 1338 1008 1026 1008 q20 486 187 182 182 q21 3972 3260 3126 3126 q22 375 316 312 312 Total cold run time: 107422 ms Total hot run time: 40179 ms ----- Round 2, with runtime_filter_mode=off ----- q1 7696 7347 7277 7277 q2 317 225 230 225 q3 2903 2850 2957 2850 q4 2129 1828 1863 1828 q5 5656 5738 5707 5707 q6 224 144 142 142 q7 2247 1800 1785 1785 q8 3413 3575 3542 3542 q9 8922 8956 8956 8956 q10 3611 3538 3586 3538 q11 600 523 513 513 q12 809 612 620 612 q13 10978 3283 3202 3202 q14 291 266 281 266 q15 585 534 530 530 q16 705 647 645 645 q17 1863 1631 1627 1627 q18 8452 7800 7662 7662 q19 1740 1606 1560 1560 q20 2100 1953 1997 1953 q21 5630 5398 5406 5398 q22 653 569 568 568 Total cold run time: 71524 ms Total hot run time: 60386 ms ```
doris-robot commented 16 hours ago
TPC-DS: Total hot run time: 197673 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 f1124e44cd4bf27eb85dcc04805cdf8ef39b4e68, data reload: false query1 1253 974 948 948 query2 6249 2040 2013 2013 query3 10775 4095 4113 4095 query4 68025 28779 23597 23597 query5 4980 468 472 468 query6 410 187 181 181 query7 5518 296 288 288 query8 312 228 221 221 query9 8590 2680 2666 2666 query10 441 251 252 251 query11 17373 15198 15941 15198 query12 157 105 102 102 query13 1445 441 418 418 query14 10519 7362 7596 7362 query15 206 195 221 195 query16 7111 478 502 478 query17 1091 564 573 564 query18 1886 302 305 302 query19 205 153 166 153 query20 124 112 115 112 query21 195 102 106 102 query22 4805 4630 4512 4512 query23 35206 34316 34670 34316 query24 5540 2524 2474 2474 query25 497 444 416 416 query26 642 153 155 153 query27 2109 296 298 296 query28 3974 2484 2441 2441 query29 714 466 451 451 query30 222 152 148 148 query31 1019 842 864 842 query32 66 54 55 54 query33 432 295 278 278 query34 934 522 506 506 query35 856 761 729 729 query36 1106 969 974 969 query37 129 75 77 75 query38 4526 4480 4456 4456 query39 1548 1487 1540 1487 query40 208 103 99 99 query41 81 42 41 41 query42 115 107 101 101 query43 546 525 509 509 query44 1242 878 872 872 query45 201 180 170 170 query46 1168 724 728 724 query47 2067 1984 1979 1979 query48 426 330 340 330 query49 719 398 397 397 query50 845 407 396 396 query51 7439 7247 7164 7164 query52 101 86 86 86 query53 253 176 175 175 query54 502 404 389 389 query55 76 76 75 75 query56 257 242 241 241 query57 1296 1165 1160 1160 query58 221 211 204 204 query59 3165 2942 3042 2942 query60 283 253 254 253 query61 141 132 125 125 query62 774 720 672 672 query63 207 188 187 187 query64 1351 655 648 648 query65 3294 3238 3206 3206 query66 702 300 311 300 query67 16246 15750 15929 15750 query68 4021 581 564 564 query69 429 253 247 247 query70 1182 1152 1110 1110 query71 363 277 255 255 query72 6505 4097 4062 4062 query73 777 358 362 358 query74 10288 9103 9060 9060 query75 3416 2723 2692 2692 query76 1921 992 1106 992 query77 501 277 278 277 query78 10631 9454 9471 9454 query79 1448 597 592 592 query80 861 448 450 448 query81 516 227 233 227 query82 1196 131 116 116 query83 194 159 144 144 query84 283 75 71 71 query85 825 313 300 300 query86 321 300 298 298 query87 4961 4704 4588 4588 query88 3823 2248 2192 2192 query89 418 296 305 296 query90 2021 194 187 187 query91 132 102 110 102 query92 66 51 51 51 query93 1864 545 544 544 query94 751 302 269 269 query95 355 247 243 243 query96 632 274 271 271 query97 2867 2738 2675 2675 query98 209 201 191 191 query99 1658 1292 1285 1285 Total cold run time: 320551 ms Total hot run time: 197673 ms ```
doris-robot commented 16 hours ago
ClickBench: Total hot run time: 33.11 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit f1124e44cd4bf27eb85dcc04805cdf8ef39b4e68, data reload: false query1 0.03 0.03 0.03 query2 0.06 0.04 0.03 query3 0.23 0.08 0.07 query4 1.64 0.10 0.10 query5 0.44 0.42 0.40 query6 1.17 0.66 0.66 query7 0.02 0.01 0.02 query8 0.04 0.03 0.03 query9 0.55 0.52 0.52 query10 0.55 0.56 0.54 query11 0.14 0.10 0.10 query12 0.14 0.11 0.11 query13 0.61 0.60 0.59 query14 2.72 2.85 2.88 query15 0.88 0.83 0.83 query16 0.37 0.38 0.38 query17 1.06 1.08 0.98 query18 0.23 0.22 0.22 query19 1.95 1.87 2.02 query20 0.02 0.01 0.01 query21 15.35 0.60 0.60 query22 2.37 2.32 1.96 query23 16.95 1.08 0.85 query24 2.96 1.73 1.07 query25 0.29 0.24 0.05 query26 0.39 0.13 0.13 query27 0.04 0.04 0.05 query28 10.15 1.11 1.09 query29 12.57 3.28 3.28 query30 0.25 0.07 0.07 query31 2.87 0.39 0.38 query32 3.28 0.47 0.48 query33 3.04 3.07 3.08 query34 17.07 4.47 4.45 query35 4.53 4.50 4.46 query36 0.66 0.50 0.49 query37 0.09 0.06 0.07 query38 0.05 0.04 0.04 query39 0.03 0.03 0.02 query40 0.17 0.13 0.13 query41 0.08 0.03 0.02 query42 0.03 0.02 0.02 query43 0.04 0.03 0.03 Total cold run time: 106.11 s Total hot run time: 33.11 s ```