Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
morningman merged PR #50979: URL: https://github.com/apache/doris/pull/50979 -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
doris-robot commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2893364293 TPC-H: Total hot run time: 33970 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 7aec445c1e52a074ca7b5b8d63ef709cc3112a1a, data reload: false -- Round 1 -- q1 26239 505550325032 q2 2069287 185 185 q3 10486 1268709 709 q4 10233 1036505 505 q5 7830237823142314 q6 184 166 133 133 q7 901 728 628 628 q8 9325125811261126 q9 6860516550695069 q10 6809232219191919 q11 472 293 279 279 q12 342 352 215 215 q13 17779 362830903090 q14 236 232 217 217 q15 536 496 479 479 q16 421 441 368 368 q17 622 857 370 370 q18 7620722472357224 q19 1876964 577 577 q20 338 329 219 219 q21 3781316523572357 q22 10251015955 955 Total cold run time: 115984 ms Total hot run time: 33970 ms - Round 2, with runtime_filter_mode=off - q1 5212508650575057 q2 234 322 226 226 q3 2172276622882288 q4 1322176213901390 q5 4489441643394339 q6 216 172 133 133 q7 1977197217641764 q8 2572251124522452 q9 7182704971777049 q10 3036314827922792 q11 563 508 485 485 q12 661 790 620 620 q13 3477386733613361 q14 289 305 265 265 q15 516 486 473 473 q16 444 489 432 432 q17 1142156913451345 q18 7714743373467346 q19 793 795 857 795 q20 1993201219381938 q21 4856434244284342 q22 10621022956 956 Total cold run time: 51922 ms Total hot run time: 49848 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
morningman commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2893312619 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
doris-robot commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2893416357 ClickBench: Total hot run time: 29.1 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 7aec445c1e52a074ca7b5b8d63ef709cc3112a1a, data reload: false query1 0.040.040.03 query2 0.130.100.11 query3 0.260.200.20 query4 1.610.200.19 query5 0.490.450.45 query6 1.160.670.66 query7 0.020.020.02 query8 0.040.040.04 query9 0.600.510.52 query10 0.580.570.57 query11 0.150.110.11 query12 0.150.110.12 query13 0.620.600.59 query14 0.790.780.80 query15 0.870.850.84 query16 0.380.400.38 query17 1.041.041.05 query18 0.220.210.22 query19 1.931.761.80 query20 0.010.020.01 query21 15.41 0.880.55 query22 0.771.370.66 query23 14.79 1.370.66 query24 6.872.430.88 query25 0.500.360.09 query26 0.540.150.13 query27 0.060.050.05 query28 9.720.850.44 query29 12.70 4.043.34 query30 0.250.090.07 query31 2.820.590.39 query32 3.220.550.46 query33 3.033.023.13 query34 15.78 5.134.47 query35 4.514.504.51 query36 0.670.490.47 query37 0.080.060.06 query38 0.050.040.04 query39 0.030.020.03 query40 0.170.130.12 query41 0.080.030.03 query42 0.040.030.02 query43 0.030.040.03 Total cold run time: 103.21 s Total hot run time: 29.1 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
doris-robot commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2893396739 TPC-DS: Total hot run time: 185528 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 7aec445c1e52a074ca7b5b8d63ef709cc3112a1a, data reload: false query1 1034493 542 493 query2 6564192818641864 query3 6763233 218 218 query4 26107 23805 22873 22873 query5 4383630 461 461 query6 308 211 210 210 query7 4628492 290 290 query8 308 267 249 249 query9 8580260026102600 query10 493 335 286 286 query11 15913 15009 14778 14778 query12 170 110 114 110 query13 1667522 429 429 query14 9587620561256125 query15 221 213 163 163 query16 7250605 491 491 query17 1180710 570 570 query18 1968394 291 291 query19 194 207 151 151 query20 131 116 113 113 query21 210 129 104 104 query22 3989408540024002 query23 33882 33049 33099 33049 query24 8425240323962396 query25 534 468 390 390 query26 1229270 156 156 query27 2754498 340 340 query28 4300210720962096 query29 762 560 438 438 query30 277 218 186 186 query31 988 815 784 784 query32 71 65 62 62 query33 549 381 303 303 query34 802 846 527 527 query35 774 805 731 731 query36 951 971 889 889 query37 117 101 75 75 query38 4095404440314031 query39 1489143614251425 query40 214 125 114 114 query41 57 53 54 53 query42 133 118 108 108 query43 500 499 487 487 query44 1310818 818 818 query45 183 180 170 170 query46 847 1039649 649 query47 1772177517191719 query48 401 423 326 326 query49 816 535 459 459 query50 665 679 413 413 query51 4194414940424042 query52 147 115 100 100 query53 222 252 178 178 query54 595 568 498 498 query55 83 85 84 84 query56 305 293 291 291 query57 1124114810791079 query58 282 268 256 256 query59 2719279125902590 query60 322 319 318 318 query61 127 123 123 123 query62 860 737 658 658 query63 222 180 185 180 query64 43481027714 714 query65 4322422342524223 query66 1144403 314 314 query67 15733 15505 15533 15505 query68 8729887 531 531 query69 478 305 269 269 query70 1233106011251060 query71 482 318 297 297 query72 5573480147614761 query73 712 607 361 361 query74 9021880886448644 query75 4062318727002700 query76 37671192752 752 query77 803 381 289 289 query78 10133 10036 92969296 query79 2924832 580 580 query80 628 506 450 450 query81 502 254 226 226 query82 512 122 99 99 query83 296 262 243 243 query84 309 109 86 86 query85 807 365 320 320 query86 396 295 300 295 query87 4488443343964396 query88 3603232923192319 query89 412 317 288 288 query90 1874215 212 212 query91 143 194 130 130 query92 74 62 58 58 query93 2176977 579 579 query94 677 407 306 306 query95 379 300 290 290 query96 500 573 287 287 query97 2783273926672667 query98 239 208 200 200 query99 1481142413191319 Total cold run time: 277490 ms Total hot run time: 185528 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] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
github-actions[bot] commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2893312377 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
github-actions[bot] commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2893312260 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
doris-robot commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2890071517 ClickBench: Total hot run time: 28.93 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1f1d5e464975ebfbffdbec90c7ecd168e5db3fc3, data reload: false query1 0.040.040.03 query2 0.120.110.11 query3 0.260.200.18 query4 1.590.200.19 query5 0.450.450.46 query6 1.150.670.67 query7 0.020.010.02 query8 0.040.040.04 query9 0.600.510.51 query10 0.580.580.57 query11 0.150.110.11 query12 0.150.120.12 query13 0.620.590.59 query14 0.790.810.82 query15 0.880.850.86 query16 0.380.400.39 query17 1.041.041.02 query18 0.220.220.21 query19 1.911.841.89 query20 0.010.010.01 query21 15.41 0.890.53 query22 0.751.400.72 query23 14.73 1.400.65 query24 7.321.220.46 query25 0.520.170.08 query26 0.630.180.15 query27 0.050.050.06 query28 9.020.910.43 query29 12.59 4.073.41 query30 0.240.090.06 query31 2.820.610.39 query32 3.250.540.48 query33 3.043.053.05 query34 15.77 5.104.48 query35 4.454.504.49 query36 0.660.500.48 query37 0.080.060.06 query38 0.050.040.03 query39 0.040.020.03 query40 0.190.140.13 query41 0.080.020.02 query42 0.030.020.02 query43 0.040.030.03 Total cold run time: 102.76 s Total hot run time: 28.93 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
doris-robot commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2890056838 TPC-DS: Total hot run time: 186056 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 1f1d5e464975ebfbffdbec90c7ecd168e5db3fc3, data reload: false query1 1006475 499 475 query2 6777190619151906 query3 6750230 217 217 query4 26860 23897 23314 23314 query5 4743634 472 472 query6 305 196 190 190 query7 4627489 296 296 query8 301 249 235 235 query9 8639263826382638 query10 497 344 287 287 query11 15876 15065 14805 14805 query12 160 120 108 108 query13 1662531 407 407 query14 9242616560756075 query15 208 202 173 173 query16 7213612 476 476 query17 1169735 628 628 query18 1980402 293 293 query19 198 210 162 162 query20 122 118 117 117 query21 208 128 108 108 query22 4081409639443944 query23 33918 33096 32970 32970 query24 8427241824382418 query25 533 473 388 388 query26 1087269 151 151 query27 2732511 351 351 query28 4288212421142114 query29 756 583 432 432 query30 285 219 192 192 query31 960 881 734 734 query32 69 66 65 65 query33 536 365 301 301 query34 821 856 536 536 query35 785 813 725 725 query36 965 1005896 896 query37 118 104 75 75 query38 4113404639833983 query39 1484141814301418 query40 206 116 106 106 query41 58 54 53 53 query42 122 121 112 112 query43 525 510 486 486 query44 1321830 846 830 query45 178 174 168 168 query46 837 1019645 645 query47 1775176717171717 query48 392 421 309 309 query49 783 503 434 434 query50 641 678 420 420 query51 4250414340994099 query52 111 109 97 97 query53 220 248 185 185 query54 587 575 501 501 query55 87 82 84 82 query56 320 321 307 307 query57 1144115910751075 query58 271 258 282 258 query59 2797271726982698 query60 335 340 317 317 query61 128 121 130 121 query62 776 725 635 635 query63 225 189 195 189 query64 4010989 644 644 query65 4309423442364234 query66 1091421 347 347 query67 15916 15431 15507 15431 query68 7957885 522 522 query69 479 317 286 286 query70 1221109311091093 query71 465 333 360 333 query72 5509471047974710 query73 724 636 363 363 query74 9358913988058805 query75 3808313926742674 query76 36071191773 773 query77 790 378 289 289 query78 993910352 94349434 query79 1976789 596 596 query80 607 524 469 469 query81 468 255 216 216 query82 425 130 97 97 query83 259 253 290 253 query84 250 105 85 85 query85 789 350 306 306 query86 340 313 278 278 query87 4371439944944399 query88 3091235323552353 query89 396 320 291 291 query90 1916221 212 212 query91 196 146 109 109 query92 73 61 56 56 query93 1072955 577 577 query94 664 384 290 290 query95 381 298 285 285 query96 512 573 288 288 query97 2712273825922592 query98 245 209 197 197 query99 1475143612501250 Total cold run time: 273991 ms Total hot run time: 186056 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] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
doris-robot commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2890010756 TPC-H: Total hot run time: 33753 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1f1d5e464975ebfbffdbec90c7ecd168e5db3fc3, data reload: false -- Round 1 -- q1 26204 506349744974 q2 2082292 180 180 q3 10480 1275717 717 q4 10240 1032537 537 q5 7635235423482348 q6 178 164 134 134 q7 925 790 642 642 q8 9323134911081108 q9 6803512250045004 q10 6830232319091909 q11 508 284 268 268 q12 352 355 208 208 q13 17775 368630753075 q14 236 222 217 217 q15 521 479 487 479 q16 447 427 393 393 q17 594 877 363 363 q18 7678720671127112 q19 1394949 568 568 q20 332 347 223 223 q21 3775322523462346 q22 1049977 948 948 Total cold run time: 115361 ms Total hot run time: 33753 ms - Round 2, with runtime_filter_mode=off - q1 5074524050635063 q2 246 327 233 233 q3 2175266723252325 q4 1313174313571357 q5 4619446944574457 q6 222 172 123 123 q7 1947194717481748 q8 2622259624982498 q9 7172709571847095 q10 3006320927082708 q11 574 513 494 494 q12 678 736 614 614 q13 3581405732113211 q14 283 290 266 266 q15 507 481 478 478 q16 452 491 430 430 q17 1172154914171417 q18 7683755775137513 q19 807 871 976 871 q20 2051206618971897 q21 4765434042174217 q22 1072966 981 966 Total cold run time: 52021 ms Total hot run time: 49981 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
BePPPower commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2889807691 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
BePPPower commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2886127360 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [Fix](MTMV) mtmv not refresh cache of external table before run task [doris]
Thearas commented on PR #50979: URL: https://github.com/apache/doris/pull/50979#issuecomment-2886123684 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
