Re: [PR] branch-3.0: [feat](hive) add catalog level schema cache property #50958 [doris]
morningman commented on PR #51011: URL: https://github.com/apache/doris/pull/51011#issuecomment-2892718815 Do not merge now -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [feat](hive) add catalog level schema cache property #50958 [doris]
doris-robot commented on PR #51011: URL: https://github.com/apache/doris/pull/51011#issuecomment-2889571436 TPC-DS: Total hot run time: 198549 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 be6a790d5424611c006d4413e1205abf8ff38569, data reload: false query1 1277905 917 905 query2 6320201319421942 query3 10803 440241774177 query4 61119 29594 23814 23814 query5 5215483 468 468 query6 398 174 173 173 query7 5440308 306 306 query8 301 228 211 211 query9 8161258125732573 query10 453 276 259 259 query11 17734 15187 15687 15187 query12 163 105 104 104 query13 1466451 455 451 query14 10654 773674657465 query15 210 182 185 182 query16 7116494 506 494 query17 1214593 633 593 query18 1937322 321 321 query19 220 161 173 161 query20 122 113 112 112 query21 202 101 107 101 query22 4730455945854559 query23 35717 34155 34797 34155 query24 6223299030632990 query25 520 383 406 383 query26 659 169 168 168 query27 1937365 359 359 query28 4296242324182418 query29 713 464 431 431 query30 240 167 163 163 query31 1020830 837 830 query32 66 59 54 54 query33 465 301 302 301 query34 928 542 509 509 query35 872 736 722 722 query36 1097949 949 949 query37 114 64 74 64 query38 4066401439923992 query39 1536147715051477 query40 211 102 106 102 query41 54 51 51 51 query42 126 106 109 106 query43 551 490 500 490 query44 1229830 829 829 query45 192 173 176 173 query46 1180775 771 771 query47 2010190519241905 query48 493 390 399 390 query49 752 429 434 429 query50 837 441 449 441 query51 7519720372397203 query52 106 90 89 89 query53 272 194 194 194 query54 585 460 475 460 query55 78 74 76 74 query56 271 257 257 257 query57 1264115011421142 query58 239 233 219 219 query59 3187301230173012 query60 296 263 263 263 query61 136 121 107 107 query62 790 706 702 702 query63 235 201 211 201 query64 1405671 627 627 query65 3272320132373201 query66 635 300 291 291 query67 16018 15560 15546 15546 query68 4129577 580 577 query69 415 268 269 268 query70 1152113411421134 query71 322 265 255 255 query72 6127422042084208 query73 762 351 355 351 query74 10085 893892118938 query75 3374269127572691 query76 1906100110151001 query77 544 277 275 275 query78 10607 968495959595 query79 2078606 608 606 query80 1384442 425 425 query81 526 240 238 238 query82 124290 88 88 query83 279 140 160 140 query84 280 77 82 77 query85 1052302 294 294 query86 377 309 298 298 query87 4445426143064261 query88 3699239223692369 query89 414 290 295 290 query90 1931186 188 186 query91 191 146 151 146 query92 60 51 51 51 query93 2947565 552 552 query94 751 308 291 291 query95 364 265 254 254 query96 631 276 280 276 query97 3325317231283128 query98 225 201 197 197 query99 1608129113101291 Total cold run time: 316899 ms Total hot run time: 198549 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go t
Re: [PR] branch-3.0: [feat](hive) add catalog level schema cache property #50958 [doris]
doris-robot commented on PR #51011: URL: https://github.com/apache/doris/pull/51011#issuecomment-2889577892 ClickBench: Total hot run time: 31.74 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit be6a790d5424611c006d4413e1205abf8ff38569, data reload: false query1 0.040.030.02 query2 0.070.030.03 query3 0.230.070.06 query4 1.620.100.10 query5 0.530.530.51 query6 1.140.740.73 query7 0.020.020.02 query8 0.040.040.03 query9 0.560.500.51 query10 0.570.550.59 query11 0.140.110.10 query12 0.140.110.11 query13 0.610.590.59 query14 2.782.762.78 query15 0.880.820.81 query16 0.390.390.40 query17 1.071.061.02 query18 0.250.210.21 query19 1.961.902.00 query20 0.010.010.02 query21 15.35 0.600.59 query22 2.971.691.80 query23 16.93 1.090.90 query24 3.432.030.59 query25 0.240.150.22 query26 0.330.130.13 query27 0.040.040.03 query28 9.610.490.44 query29 12.60 3.193.16 query30 0.250.060.06 query31 2.890.390.38 query32 3.260.460.46 query33 2.972.993.04 query34 17.11 4.484.49 query35 4.544.544.47 query36 0.650.490.48 query37 0.090.060.06 query38 0.040.040.03 query39 0.030.030.02 query40 0.170.130.12 query41 0.080.030.02 query42 0.040.020.02 query43 0.040.030.02 Total cold run time: 106.71 s Total hot run time: 31.74 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [feat](hive) add catalog level schema cache property #50958 [doris]
doris-robot commented on PR #51011: URL: https://github.com/apache/doris/pull/51011#issuecomment-2889556012 TPC-H: Total hot run time: 39801 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit be6a790d5424611c006d4413e1205abf8ff38569, data reload: false -- Round 1 -- q1 17576 672165646564 q2 2085165 161 161 q3 10797 106711161067 q4 10548 745 677 677 q5 7750291727392739 q6 218 133 128 128 q7 957 616 610 610 q8 9358192320241923 q9 6652636164166361 q10 7045226923022269 q11 465 260 264 260 q12 406 219 213 213 q13 17791 296329592959 q14 240 205 204 204 q15 501 467 467 467 q16 659 591 583 583 q17 990 571 553 553 q18 7138669566736673 q19 1504105510831055 q20 483 209 212 209 q21 4114312233073122 q22 1136102310041004 Total cold run time: 108413 ms Total hot run time: 39801 ms - Round 2, with runtime_filter_mode=off - q1 6651657265746572 q2 328 235 237 235 q3 2861279528962795 q4 2027180317671767 q5 5787573056935693 q6 215 128 124 124 q7 2224180818641808 q8 3345359738403597 q9 9028881789028817 q10 3549350935053505 q11 599 508 495 495 q12 783 605 624 605 q13 8266316731823167 q14 286 289 280 280 q15 505 473 462 462 q16 673 659 654 654 q17 1827162015981598 q18 8120781478077807 q19 1690160715581558 q20 2042182118401821 q21 5513538753275327 q22 1096106010521052 Total cold run time: 67415 ms Total hot run time: 59739 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [feat](hive) add catalog level schema cache property #50958 [doris]
hello-stephen commented on PR #51011: URL: https://github.com/apache/doris/pull/51011#issuecomment-2889515868 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/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? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [feat](hive) add catalog level schema cache property #50958 [doris]
dataroaring closed pull request #51011: branch-3.0: [feat](hive) add catalog level schema cache property #50958 URL: https://github.com/apache/doris/pull/51011 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [feat](hive) add catalog level schema cache property #50958 [doris]
hello-stephen commented on PR #51011: URL: https://github.com/apache/doris/pull/51011#issuecomment-2889515920 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
