Re: [PR] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
morrySnow merged PR #44673: URL: https://github.com/apache/doris/pull/44673 -- 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
github-actions[bot] commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503927277 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
doris-robot commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503821798 ClickBench: Total hot run time: 32.47 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 274ea59c44cdac4398aec3dd624041832f5a6346, data reload: false query1 0.040.030.02 query2 0.070.030.03 query3 0.230.080.07 query4 1.590.100.10 query5 0.420.420.42 query6 1.160.650.65 query7 0.020.010.02 query8 0.040.020.03 query9 0.590.520.51 query10 0.560.560.58 query11 0.150.100.10 query12 0.140.110.11 query13 0.620.610.61 query14 2.722.752.87 query15 0.910.840.82 query16 0.380.370.38 query17 1.071.051.00 query18 0.220.200.20 query19 1.851.881.97 query20 0.010.010.01 query21 15.35 0.580.58 query22 2.761.941.97 query23 17.07 0.930.75 query24 2.940.541.87 query25 0.210.240.16 query26 0.410.140.15 query27 0.040.040.05 query28 10.34 1.111.07 query29 12.55 3.313.29 query30 0.250.070.06 query31 2.860.390.38 query32 3.270.470.47 query33 3.012.983.04 query34 17.12 4.524.52 query35 4.544.534.54 query36 0.680.480.50 query37 0.100.060.07 query38 0.040.040.03 query39 0.030.030.02 query40 0.160.120.12 query41 0.070.020.02 query42 0.040.020.02 query43 0.030.030.03 Total cold run time: 106.66 s Total hot run time: 32.47 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
doris-robot commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503810216 TPC-DS: Total hot run time: 191171 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 274ea59c44cdac4398aec3dd624041832f5a6346, data reload: false query1 976 395 378 378 query2 6513215420572057 query3 6714216 210 210 query4 33997 23588 23650 23588 query5 4295455 448 448 query6 293 191 193 191 query7 4625291 300 291 query8 289 228 231 228 query9 9434271627072707 query10 474 251 268 251 query11 18033 15203 15116 15116 query12 152 102 102 102 query13 1650417 450 417 query14 9657764875407540 query15 295 189 180 180 query16 8064448 471 448 query17 1846583 564 564 query18 2107294 304 294 query19 370 191 142 142 query20 116 111 108 108 query21 210 100 107 100 query22 4616413541884135 query23 35134 34040 34044 34040 query24 11424 244724682447 query25 669 374 373 373 query26 1826147 146 146 query27 2783274 278 274 query28 7943242424252424 query29 1019406 404 404 query30 295 149 148 148 query31 1040801 821 801 query32 92 56 83 56 query33 786 280 278 278 query34 1041507 526 507 query35 889 728 720 720 query36 1128951 929 929 query37 265 73 75 73 query38 4398417641664166 query39 1482142414351424 query40 280 98 97 97 query41 48 43 42 42 query42 108 101 99 99 query43 542 494 501 494 query44 1261797 812 797 query45 189 167 165 165 query46 1124684 682 682 query47 1947185518611855 query48 408 310 328 310 query49 1289373 389 373 query50 800 389 379 379 query51 7367706871517068 query52 98 88 88 88 query53 254 175 179 175 query54 1223391 410 391 query55 88 79 78 78 query56 254 241 249 241 query57 1292111611421116 query58 236 207 221 207 query59 3299298829662966 query60 278 250 262 250 query61 141 113 109 109 query62 870 669 684 669 query63 206 192 189 189 query64 5130658 626 626 query65 3306318432143184 query66 1454319 358 319 query67 16118 15632 15630 15630 query68 4510565 553 553 query69 404 250 261 250 query70 1225112810981098 query71 335 243 252 243 query72 6379406241724062 query73 770 354 358 354 query74 9482899891248998 query75 3474265426432643 query76 267610641064 query77 499 269 283 269 query78 10280 941593159315 query79 2331593 605 593 query80 1211426 431 426 query81 549 229 224 224 query82 950 117 118 117 query83 245 153 175 153 query84 243 71 70 70 query85 1482299 295 295 query86 442 298 302 298 query87 4770454645944546 query88 3881220521742174 query89 409 290 298 290 query90 2108186 182 182 query91 131 107 104 104 query92 65 53 51 51 query93 1756542 532 532 query94 1129289 290 289 query95 357 248 251 248 query96 628 276 275 275 query97 2877265526942655 query98 212 199 190 190 query99 1679133913061306 Total cold run time: 304039 ms Total hot run time: 191171 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
Re: [PR] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
doris-robot commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503785024 TPC-H: Total hot run time: 39631 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 274ea59c44cdac4398aec3dd624041832f5a6346, data reload: false -- Round 1 -- q1 17588 745873077307 q2 2045178 162 162 q3 10554 114111941141 q4 10229 725 751 725 q5 7605265726702657 q6 240 153 154 153 q7 988 617 600 600 q8 9227182819121828 q9 6524635963836359 q10 6933227622742274 q11 461 259 263 259 q12 401 214 211 211 q13 17765 301130083008 q14 241 221 210 210 q15 567 526 521 521 q16 623 566 582 566 q17 969 671 616 616 q18 7331649866646498 q19 1351989 939 939 q20 481 181 185 181 q21 3920310532803105 q22 372 311 320 311 Total cold run time: 106415 ms Total hot run time: 39631 ms - Round 2, with runtime_filter_mode=off - q1 7305726972547254 q2 319 228 228 228 q3 2894274628862746 q4 2117183817661766 q5 5537568656165616 q6 223 138 139 138 q7 2221179717861786 q8 3355350634783478 q9 8821882987908790 q10 3613353635893536 q11 591 511 512 511 q12 817 608 621 608 q13 13818 319932123199 q14 297 267 262 262 q15 568 535 528 528 q16 667 634 616 616 q17 1820164915921592 q18 7796737673907376 q19 1655154415511544 q20 2054183017951795 q21 5315517152935171 q22 647 552 591 552 Total cold run time: 72450 ms Total hot run time: 59092 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
zddr commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503731351 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
github-actions[bot] commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503707265 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
github-actions[bot] commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503707339 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
morrySnow commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503691260 run cloud_p0 -- 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
zddr commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503336464 run cloud_p0 -- 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
doris-robot commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503248375 ClickBench: Total hot run time: 31.63 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit f49ea8361eb7a2c02c9a153f093aa1a6243bd0dd, data reload: false query1 0.030.030.03 query2 0.060.040.04 query3 0.230.070.07 query4 1.630.100.10 query5 0.450.410.41 query6 1.130.660.66 query7 0.020.020.02 query8 0.040.040.03 query9 0.560.520.49 query10 0.540.540.56 query11 0.140.110.10 query12 0.140.110.12 query13 0.620.600.60 query14 2.762.842.76 query15 0.900.820.82 query16 0.390.380.38 query17 1.061.031.05 query18 0.210.200.20 query19 1.991.852.05 query20 0.010.010.01 query21 15.36 0.600.60 query22 2.801.671.77 query23 16.93 0.940.77 query24 3.181.110.14 query25 0.140.060.04 query26 0.480.140.14 query27 0.050.040.05 query28 11.59 1.081.07 query29 12.56 3.263.28 query30 0.250.060.06 query31 2.860.390.39 query32 3.270.460.46 query33 3.013.023.02 query34 17.14 4.504.46 query35 4.454.484.47 query36 0.670.490.48 query37 0.090.060.07 query38 0.050.040.04 query39 0.030.020.02 query40 0.170.130.12 query41 0.080.030.02 query42 0.030.020.02 query43 0.040.030.04 Total cold run time: 108.14 s Total hot run time: 31.63 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
doris-robot commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503237353 TPC-DS: Total hot run time: 198108 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 f49ea8361eb7a2c02c9a153f093aa1a6243bd0dd, data reload: false query1 1267931 954 931 query2 6226210320462046 query3 10928 395340683953 query4 67456 29202 23745 23745 query5 5010473 476 473 query6 430 200 187 187 query7 5626305 297 297 query8 309 215 212 212 query9 9150274827472747 query10 443 255 253 253 query11 17349 15282 15875 15282 query12 156 104 101 101 query13 1532397 449 397 query14 9916791578277827 query15 214 186 197 186 query16 7249441 473 441 query17 1259573 592 573 query18 1884302 294 294 query19 200 157 192 157 query20 119 108 107 107 query21 210 102 99 99 query22 4710456345014501 query23 34975 34564 34473 34473 query24 5406245025072450 query25 488 406 427 406 query26 646 157 158 157 query27 1817290 302 290 query28 4497251225082508 query29 689 429 398 398 query30 225 149 150 149 query31 1020795 876 795 query32 69 56 59 56 query33 417 297 287 287 query34 973 510 544 510 query35 881 759 763 759 query36 1107955 976 955 query37 134 79 71 71 query38 4547455343174317 query39 1509149914641464 query40 214 103 103 103 query41 51 48 48 48 query42 113 105 101 101 query43 533 508 501 501 query44 1193849 853 849 query45 195 174 168 168 query46 1157733 702 702 query47 2053192519531925 query48 441 332 366 332 query49 743 407 417 407 query50 851 405 414 405 query51 7410723171997199 query52 91 89 89 89 query53 250 180 179 179 query54 513 388 390 388 query55 79 74 79 74 query56 249 257 233 233 query57 1322117911761176 query58 221 211 213 211 query59 3194306830243024 query60 275 254 247 247 query61 111 111 107 107 query62 803 659 672 659 query63 211 185 190 185 query64 1380665 633 633 query65 3315319632333196 query66 756 288 308 288 query67 16110 15913 15676 15676 query68 3859564 570 564 query69 420 249 260 249 query70 1214109511591095 query71 350 249 256 249 query72 6415404839713971 query73 779 419 375 375 query74 10243 910990519051 query75 3412274226402640 query76 1922113610901090 query77 474 271 271 271 query78 10489 944194179417 query79 1535596 602 596 query80 849 428 432 428 query81 515 241 233 233 query82 1337114 117 114 query83 268 145 154 145 query84 288 73 71 71 query85 912 328 300 300 query86 343 306 301 301 query87 4756464346284628 query88 3546222822022202 query89 415 306 290 290 query90 2001184 218 184 query91 129 104 99 99 query92 68 51 49 49 query93 1933535 539 535 query94 778 302 297 297 query95 352 256 248 248 query96 613 287 277 277 query97 2852266626472647 query98 216 193 192 192 query99 1606134113471341 Total cold run time: 319766 ms Total hot run time: 198108 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
Re: [PR] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
zddr commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503229796 run external -- 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
zddr commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503224007 run cloud_p0 -- 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
doris-robot commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503212008 TPC-H: Total hot run time: 40130 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit f49ea8361eb7a2c02c9a153f093aa1a6243bd0dd, data reload: false -- Round 1 -- q1 17619 743973287328 q2 2053179 169 169 q3 10595 110312071103 q4 10558 781 759 759 q5 7630272527362725 q6 238 147 147 147 q7 984 640 606 606 q8 9245191419781914 q9 6511635064216350 q10 6957228323192283 q11 460 262 262 262 q12 427 218 220 218 q13 17806 303830553038 q14 250 210 232 210 q15 560 526 523 523 q16 659 577 586 577 q17 969 644 532 532 q18 7271666167876661 q19 1334941 1044941 q20 485 181 184 181 q21 3964332132913291 q22 384 312 321 312 Total cold run time: 106959 ms Total hot run time: 40130 ms - Round 2, with runtime_filter_mode=off - q1 7260727872757275 q2 328 230 225 225 q3 2854285829762858 q4 2091186318591859 q5 5704568156875681 q6 227 145 144 144 q7 2245186218211821 q8 3441360235293529 q9 8901892188558855 q10 3601359535343534 q11 602 525 514 514 q12 811 627 612 612 q13 14155 318732413187 q14 304 275 269 269 q15 579 526 522 522 q16 712 668 644 644 q17 1873167616511651 q18 8228777175117511 q19 1691142015811420 q20 2117185119071851 q21 5498526753635267 q22 633 583 574 574 Total cold run time: 73855 ms Total hot run time: 59803 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
zddr commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503125080 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] [feat](mtmv)Unified external table interface supporting partition refresh and partition pruning [doris]
doris-robot commented on PR #44673: URL: https://github.com/apache/doris/pull/44673#issuecomment-2503116505 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
