Re: [PR] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
morningman merged PR #51057: URL: https://github.com/apache/doris/pull/51057 -- 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] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
github-actions[bot] commented on PR #51057: URL: https://github.com/apache/doris/pull/51057#issuecomment-2898279074 PR approved by at least one committer and no changes requested. -- 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] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
github-actions[bot] commented on PR #51057: URL: https://github.com/apache/doris/pull/51057#issuecomment-2897808417 PR approved by anyone and no changes requested. -- 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] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
doris-robot commented on PR #51057: URL: https://github.com/apache/doris/pull/51057#issuecomment-2893833692 TPC-DS: Total hot run time: 192736 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 119ea919dd85e93d78396033bc52442b29bc7607, data reload: false query1 1385108010741074 query2 6263180017931793 query3 11016 444045814440 query4 53527 24901 23130 23130 query5 5270526 436 436 query6 358 212 222 212 query7 5028516 299 299 query8 358 254 244 244 query9 6415262826282628 query10 446 337 274 274 query11 15035 15082 14855 14855 query12 174 112 113 112 query13 1137520 435 435 query14 10090 626663526266 query15 209 193 184 184 query16 7079652 458 458 query17 1100753 607 607 query18 1570424 329 329 query19 213 196 165 165 query20 132 126 127 126 query21 212 130 105 105 query22 4532444043594359 query23 34328 33531 33609 33531 query24 6627240724472407 query25 489 456 409 409 query26 711 289 149 149 query27 2367520 343 343 query28 3404214521392139 query29 564 587 455 455 query30 281 219 194 194 query31 861 869 789 789 query32 73 66 59 59 query33 466 385 330 330 query34 782 862 546 546 query35 808 813 772 772 query36 952 1033916 916 query37 117 98 80 80 query38 4164426041864186 query39 1545144314561443 query40 213 123 114 114 query41 54 54 51 51 query42 129 115 107 107 query43 493 514 493 493 query44 1336862 850 850 query45 179 173 170 170 query46 867 1032651 651 query47 1906184518481845 query48 407 451 322 322 query49 702 525 437 437 query50 671 729 430 430 query51 4287434343704343 query52 106 111 109 109 query53 239 261 179 179 query54 605 586 529 529 query55 87 85 85 85 query56 301 297 281 281 query57 1188120411321132 query58 281 278 265 265 query59 2800280626672667 query60 343 379 322 322 query61 126 129 120 120 query62 716 703 691 691 query63 221 183 187 183 query64 18441033699 699 query65 4318421442054205 query66 720 389 299 299 query67 16260 15610 15315 15315 query68 6800889 537 537 query69 547 321 275 275 query70 1213109311031093 query71 500 330 294 294 query72 5976476050224760 query73 1323694 367 367 query74 9071918189188918 query75 3906319326662666 query76 42761211743 743 query77 633 389 290 290 query78 10182 10192 95329532 query79 2606784 590 590 query80 674 532 430 430 query81 473 260 218 218 query82 570 124 92 92 query83 253 252 231 231 query84 293 106 87 87 query85 788 457 314 314 query86 390 308 278 278 query87 4433445543384338 query88 3366228823002288 query89 402 334 282 282 query90 1775209 203 203 query91 144 142 114 114 query92 69 55 60 55 query93 2463949 577 577 query94 673 421 309 309 query95 371 293 297 293 query96 504 575 278 278 query97 2743279726262626 query98 229 197 207 197 query99 1434137912881288 Total cold run time: 300567 ms Total hot run time: 192736 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
Re: [PR] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
doris-robot commented on PR #51057: URL: https://github.com/apache/doris/pull/51057#issuecomment-2893797852 TPC-H: Total hot run time: 33805 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 119ea919dd85e93d78396033bc52442b29bc7607, data reload: false -- Round 1 -- q1 26204 506749774977 q2 2054270 173 173 q3 10435 1226682 682 q4 10227 992 515 515 q5 7555230823582308 q6 181 161 133 133 q7 926 734 611 611 q8 9314129411541154 q9 6956517650925092 q10 6884231619061906 q11 493 287 288 287 q12 347 376 218 218 q13 17786 368530503050 q14 224 223 211 211 q15 533 480 473 473 q16 438 437 378 378 q17 594 826 381 381 q18 7702714871527148 q19 1697951 557 557 q20 335 322 219 219 q21 3788318123772377 q22 1041999 955 955 Total cold run time: 115714 ms Total hot run time: 33805 ms - Round 2, with runtime_filter_mode=off - q1 5151505450445044 q2 256 321 234 234 q3 2245270623562356 q4 1377179614851485 q5 4615435243794352 q6 214 166 132 132 q7 2002192617401740 q8 2582251424842484 q9 7276721870297029 q10 3064321827832783 q11 598 527 497 497 q12 683 802 595 595 q13 3526390333053305 q14 271 293 268 268 q15 528 484 486 484 q16 449 490 431 431 q17 1138156613871387 q18 7763760074937493 q19 810 837 967 837 q20 2014199418491849 q21 4748448544884485 q22 1078105010081008 Total cold run time: 52388 ms Total hot run time: 50278 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] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
doris-robot commented on PR #51057: URL: https://github.com/apache/doris/pull/51057#issuecomment-2893847111 ClickBench: Total hot run time: 28.67 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 119ea919dd85e93d78396033bc52442b29bc7607, data reload: false query1 0.030.040.04 query2 0.130.100.12 query3 0.240.200.19 query4 1.600.190.19 query5 0.460.460.43 query6 1.160.670.66 query7 0.020.020.01 query8 0.040.030.03 query9 0.590.510.52 query10 0.570.570.58 query11 0.160.100.11 query12 0.150.110.12 query13 0.610.600.60 query14 0.800.820.82 query15 0.880.860.86 query16 0.380.390.38 query17 1.041.071.05 query18 0.230.210.21 query19 1.921.811.79 query20 0.020.010.01 query21 15.43 0.940.55 query22 0.741.160.72 query23 14.92 1.400.64 query24 6.811.410.42 query25 0.410.160.08 query26 0.610.170.14 query27 0.050.060.04 query28 8.760.950.43 query29 12.72 3.963.28 query30 0.250.090.06 query31 2.830.590.38 query32 3.230.560.47 query33 3.023.003.06 query34 15.72 5.044.52 query35 4.504.484.52 query36 0.680.480.49 query37 0.080.060.06 query38 0.050.040.04 query39 0.030.020.03 query40 0.180.140.13 query41 0.080.020.02 query42 0.030.020.02 query43 0.030.030.03 Total cold run time: 102.19 s Total hot run time: 28.67 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] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
morningman commented on PR #51057: URL: https://github.com/apache/doris/pull/51057#issuecomment-2893652020 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
Re: [PR] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
doris-robot commented on PR #51057: URL: https://github.com/apache/doris/pull/51057#issuecomment-2893188550 TPC-DS: Total hot run time: 191935 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 e12e305eed96520048728fc58e490932db8b5526, data reload: false query1 1421109410461046 query2 6387180418051804 query3 11006 435643494349 query4 53847 25648 22932 22932 query5 5221480 459 459 query6 349 201 204 201 query7 4922504 298 298 query8 329 261 244 244 query9 5792259626062596 query10 428 333 257 257 query11 14882 15044 14773 14773 query12 162 108 98 98 query13 1052525 405 405 query14 10044 632762916291 query15 206 206 189 189 query16 7067667 504 504 query17 1104721 610 610 query18 1558396 315 315 query19 205 199 172 172 query20 132 128 126 126 query21 209 167 108 108 query22 4245447342434243 query23 34569 33607 33408 33408 query24 6567242124732421 query25 455 496 407 407 query26 691 285 152 152 query27 2239526 356 356 query28 2934215921362136 query29 565 579 432 432 query30 271 227 187 187 query31 852 840 782 782 query32 79 64 65 64 query33 492 368 331 331 query34 783 869 549 549 query35 803 874 756 756 query36 940 1004904 904 query37 109 97 78 78 query38 4207425843344258 query39 1533145714641457 query40 217 114 112 112 query41 64 52 53 52 query42 124 111 112 111 query43 496 508 481 481 query44 1344853 854 853 query45 187 174 164 164 query46 862 1040636 636 query47 1841188618161816 query48 396 430 329 329 query49 684 562 436 436 query50 681 707 406 406 query51 4245438242544254 query52 106 112 101 101 query53 224 251 192 192 query54 589 583 511 511 query55 84 83 83 83 query56 331 322 334 322 query57 1159119911091109 query58 270 262 262 262 query59 2650276327392739 query60 335 341 314 314 query61 145 133 147 133 query62 719 749 688 688 query63 231 206 195 195 query64 15911107729 729 query65 4333425042254225 query66 774 389 300 300 query67 15773 15564 15451 15451 query68 7605892 518 518 query69 600 311 275 275 query70 1272114110331033 query71 475 314 293 293 query72 5486470747244707 query73 1368606 361 361 query74 9199917589128912 query75 3737320227082708 query76 42691190752 752 query77 621 369 286 286 query78 998710170 93319331 query79 2810826 570 570 query80 670 507 438 438 query81 494 255 216 216 query82 474 124 96 96 query83 386 261 233 233 query84 286 94 88 88 query85 790 351 394 351 query86 376 314 303 303 query87 4317437742644264 query88 3131232822742274 query89 405 314 281 281 query90 1978206 200 200 query91 152 141 119 119 query92 75 63 54 54 query93 1163927 577 577 query94 699 408 305 305 query95 363 285 288 285 query96 492 557 278 278 query97 2738276626542654 query98 233 207 195 195 query99 1446139712761276 Total cold run time: 297209 ms Total hot run time: 191935 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] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
doris-robot commented on PR #51057: URL: https://github.com/apache/doris/pull/51057#issuecomment-2893201240 ClickBench: Total hot run time: 29.03 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit e12e305eed96520048728fc58e490932db8b5526, data reload: false query1 0.040.030.04 query2 0.130.100.11 query3 0.260.190.19 query4 1.590.190.20 query5 0.450.430.45 query6 1.460.660.66 query7 0.020.020.02 query8 0.040.030.03 query9 0.600.520.51 query10 0.570.580.56 query11 0.140.110.11 query12 0.150.120.12 query13 0.620.590.60 query14 0.800.790.81 query15 0.870.830.88 query16 0.370.390.38 query17 1.051.011.06 query18 0.210.210.21 query19 1.881.771.81 query20 0.010.010.01 query21 15.40 0.920.54 query22 0.741.200.69 query23 14.85 1.430.65 query24 7.170.960.94 query25 0.500.180.06 query26 0.510.170.15 query27 0.060.040.05 query28 9.670.830.44 query29 12.54 4.023.31 query30 0.260.090.06 query31 2.820.590.38 query32 3.260.540.46 query33 3.013.023.07 query34 15.74 5.104.47 query35 4.524.514.49 query36 0.670.490.48 query37 0.090.060.06 query38 0.050.040.04 query39 0.040.020.02 query40 0.170.130.12 query41 0.080.020.02 query42 0.030.020.02 query43 0.040.030.03 Total cold run time: 103.48 s Total hot run time: 29.03 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] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
doris-robot commented on PR #51057: URL: https://github.com/apache/doris/pull/51057#issuecomment-2893160302 TPC-H: Total hot run time: 33681 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit e12e305eed96520048728fc58e490932db8b5526, data reload: false -- Round 1 -- q1 25971 530249524952 q2 2064274 181 181 q3 10405 1234721 721 q4 10231 988 520 520 q5 7536232423202320 q6 179 163 131 131 q7 917 753 599 599 q8 93311267 q9 6824507151045071 q10 6862232018941894 q11 500 286 282 282 q12 352 357 220 220 q13 17795 364630353035 q14 236 226 210 210 q15 520 498 488 488 q16 410 430 367 367 q17 581 853 365 365 q18 7471714671477146 q19 1999958 553 553 q20 329 318 223 223 q21 3864317123212321 q22 10251007971 971 Total cold run time: 115402 ms Total hot run time: 33681 ms - Round 2, with runtime_filter_mode=off - q1 5115505450595054 q2 242 320 231 231 q3 2175267123862386 q4 1379181613881388 q5 436444244364 q6 215 168 136 136 q7 2051192917891789 q8 2593256025002500 q9 7218716370527052 q10 3062318927342734 q11 577 507 494 494 q12 695 775 631 631 q13 3483390732503250 q14 273 284 276 276 q15 528 487 475 475 q16 445 477 435 435 q17 1128162413671367 q18 7709750374047404 q19 809 819 903 819 q20 2034198918201820 q21 4763456144734473 q22 1092109710091009 Total cold run time: 52030 ms Total hot run time: 50087 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] [fix](schema-cache) make catalog level schema cache config work for "get_schema_from_table" mode [doris]
morningman commented on PR #51057: URL: https://github.com/apache/doris/pull/51057#issuecomment-2893076795 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
