Re: [PR] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
dataroaring merged PR #50768: URL: https://github.com/apache/doris/pull/50768 -- 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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
zddr commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2870512446 run 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: [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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
doris-robot commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2869850635 ClickBench: Total hot run time: 31.97 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 7eb0ca142e26fdf03a5432a916c0788898272717, data reload: false query1 0.030.030.03 query2 0.070.030.04 query3 0.230.070.07 query4 1.630.110.10 query5 0.540.500.52 query6 1.140.720.73 query7 0.020.020.02 query8 0.040.030.02 query9 0.550.500.50 query10 0.550.560.54 query11 0.150.100.10 query12 0.130.110.11 query13 0.610.590.58 query14 2.732.872.86 query15 0.900.830.82 query16 0.380.380.38 query17 1.051.041.02 query18 0.240.220.21 query19 1.831.832.02 query20 0.020.010.01 query21 15.36 0.590.58 query22 2.452.961.87 query23 17.02 1.100.73 query24 2.910.791.16 query25 0.360.140.14 query26 0.210.140.13 query27 0.040.040.05 query28 10.73 0.500.45 query29 12.56 3.223.19 query30 0.250.060.06 query31 2.860.390.39 query32 3.240.470.45 query33 3.013.023.02 query34 17.20 4.484.45 query35 4.504.504.48 query36 0.670.490.47 query37 0.090.050.06 query38 0.050.030.04 query39 0.030.020.02 query40 0.170.120.12 query41 0.080.020.02 query42 0.040.020.02 query43 0.030.020.02 Total cold run time: 106.7 s Total hot run time: 31.97 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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
doris-robot commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2869848319 TPC-DS: Total hot run time: 197342 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 7eb0ca142e26fdf03a5432a916c0788898272717, data reload: false query1 1290899 907 899 query2 6371199419511951 query3 10832 435043984350 query4 61054 29028 23670 23670 query5 5186459 443 443 query6 398 170 173 170 query7 5497306 306 306 query8 308 234 223 223 query9 8629259825882588 query10 472 268 259 259 query11 17913 15288 15716 15288 query12 165 109 114 109 query13 1459458 420 420 query14 9894756573357335 query15 197 184 182 182 query16 7122453 493 453 query17 1232577 597 577 query18 1929328 308 308 query19 225 160 165 160 query20 112 111 107 107 query21 218 110 110 110 query22 4560454845344534 query23 34555 33914 34012 33914 query24 6159294729632947 query25 558 457 418 418 query26 655 170 175 170 query27 1926384 363 363 query28 4539243824322432 query29 718 490 417 417 query30 240 175 160 160 query31 982 816 843 816 query32 69 57 56 56 query33 458 293 299 293 query34 902 513 544 513 query35 851 741 735 735 query36 1080924 936 924 query37 114 68 68 68 query38 4107402939613961 query39 1528150614891489 query40 209 95 99 95 query41 48 49 47 47 query42 114 101 101 101 query43 514 496 479 479 query44 1207823 809 809 query45 186 167 168 167 query46 1137726 734 726 query47 2018187518821875 query48 483 386 387 386 query49 741 394 389 389 query50 844 434 443 434 query51 7351716272777162 query52 102 93 88 88 query53 266 189 198 189 query54 571 464 470 464 query55 77 74 82 74 query56 264 256 252 252 query57 1300118711711171 query58 231 217 241 217 query59 3223299229832983 query60 275 247 255 247 query61 151 110 133 110 query62 744 669 687 669 query63 215 184 182 182 query64 1369660 646 646 query65 3307319732213197 query66 723 299 307 299 query67 15899 15328 15430 15328 query68 4302563 550 550 query69 435 266 271 266 query70 1196108910871087 query71 341 263 259 259 query72 6372402040304020 query73 743 343 347 343 query74 10190 902192589021 query75 3342261526362615 query76 1974107211721072 query77 521 265 280 265 query78 10627 956696279566 query79 1325603 604 603 query80 890 437 434 434 query81 502 256 245 245 query82 123990 88 88 query83 240 153 141 141 query84 286 81 76 76 query85 870 299 285 285 query86 320 294 286 286 query87 4391422242804222 query88 3564238223552355 query89 411 294 294 294 query90 1979192 183 183 query91 184 149 146 146 query92 67 49 51 49 query93 1877544 544 544 query94 755 307 291 291 query95 359 272 260 260 query96 611 280 280 280 query97 3273310031473100 query98 214 201 199 199 query99 1598129313001293 Total cold run time: 313071 ms Total hot run time: 197342 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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
doris-robot commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2869842824 TPC-H: Total hot run time: 39950 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 7eb0ca142e26fdf03a5432a916c0788898272717, data reload: false -- Round 1 -- q1 17613 677465816581 q2 2056165 165 165 q3 10635 108711981087 q4 10562 770 786 770 q5 7731281427382738 q6 223 136 134 134 q7 989 640 632 632 q8 9348193720381937 q9 6606640064346400 q10 6993222823162228 q11 451 254 260 254 q12 396 210 213 210 q13 17762 295729712957 q14 240 206 206 206 q15 504 454 456 454 q16 651 580 588 580 q17 952 630 505 505 q18 7152665166606651 q19 1403110710391039 q20 479 206 200 200 q21 4018321034303210 q22 1122105110121012 Total cold run time: 107886 ms Total hot run time: 39950 ms - Round 2, with runtime_filter_mode=off - q1 6752665867516658 q2 332 250 240 240 q3 3010283229682832 q4 2038178618051786 q5 5795575457745754 q6 214 128 129 128 q7 2244184218421842 q8 3415361635513551 q9 8897888488668866 q10 3650357735423542 q11 612 501 489 489 q12 823 663 635 635 q13 10522 334233063306 q14 303 293 296 293 q15 525 470 470 470 q16 730 685 669 669 q17 1869168516191619 q18 8255782178087808 q19 2190163016291629 q20 2154187518821875 q21 5403519354045193 q22 1089102910271027 Total cold run time: 70822 ms Total hot run time: 60212 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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
zddr commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2869824489 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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
zddr commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2868083825 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: [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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
zddr commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2866761217 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: [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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
doris-robot commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2866435827 TPC-DS: Total hot run time: 196365 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 7eb0ca142e26fdf03a5432a916c0788898272717, data reload: false query1 1292934 877 877 query2 6291199919221922 query3 10875 429443174294 query4 60741 29347 23453 23453 query5 5165459 449 449 query6 390 175 183 175 query7 5551332 311 311 query8 309 222 219 219 query9 8629257725942577 query10 473 271 257 257 query11 17691 15151 15677 15151 query12 162 110 103 103 query13 1501446 453 446 query14 10478 676467116711 query15 206 182 187 182 query16 7128472 455 455 query17 1132578 582 578 query18 1963340 319 319 query19 214 171 163 163 query20 121 115 109 109 query21 208 104 99 99 query22 4750442947724429 query23 34332 33821 33918 33821 query24 6141295329272927 query25 532 413 411 411 query26 662 167 169 167 query27 1961363 352 352 query28 4274245824292429 query29 696 472 432 432 query30 246 165 157 157 query31 1000824 819 819 query32 70 53 60 53 query33 483 288 272 272 query34 908 528 519 519 query35 857 736 747 736 query36 1062935 944 935 query37 119 66 79 66 query38 4076396339773963 query39 1512146914691469 query40 196 97 98 97 query41 48 47 48 47 query42 112 100 96 96 query43 515 479 492 479 query44 1207799 825 799 query45 184 170 173 170 query46 1139723 721 721 query47 2012192719161916 query48 471 387 395 387 query49 724 399 400 399 query50 857 438 442 438 query51 7251721574387215 query52 109 95 86 86 query53 269 185 184 184 query54 570 461 460 460 query55 80 82 83 82 query56 278 240 256 240 query57 1261118011331133 query58 222 211 225 211 query59 3280305929502950 query60 301 272 270 270 query61 119 140 111 111 query62 791 694 686 686 query63 224 199 185 185 query64 1374670 642 642 query65 3279319131993191 query66 708 289 300 289 query67 15980 15507 15475 15475 query68 4431585 562 562 query69 438 265 271 265 query70 1142111210901090 query71 342 253 259 253 query72 6286415140204020 query73 756 345 352 345 query74 10150 919893569198 query75 3374283726772677 query76 2114100311191003 query77 483 275 282 275 query78 10577 964995949594 query79 1661590 603 590 query80 1181427 430 427 query81 541 237 239 237 query82 416 90 89 89 query83 158 141 138 138 query84 279 79 76 76 query85 951 294 285 285 query86 347 297 301 297 query87 4455426842114211 query88 4079239523492349 query89 407 303 286 286 query90 1999188 194 188 query91 181 147 147 147 query92 66 50 50 50 query93 1876549 558 549 query94 784 301 284 284 query95 356 267 260 260 query96 610 283 278 278 query97 3340312631823126 query98 210 203 197 197 query99 1574127012531253 Total cold run time: 313326 ms Total hot run time: 196365 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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
doris-robot commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2866451338 ClickBench: Total hot run time: 31.51 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 7eb0ca142e26fdf03a5432a916c0788898272717, data reload: false query1 0.030.030.04 query2 0.070.030.03 query3 0.230.060.06 query4 1.630.100.10 query5 0.540.500.51 query6 1.150.730.74 query7 0.020.010.03 query8 0.040.030.03 query9 0.570.500.50 query10 0.550.550.56 query11 0.140.100.10 query12 0.140.110.11 query13 0.610.610.59 query14 2.902.762.78 query15 0.890.830.83 query16 0.380.390.39 query17 0.991.070.98 query18 0.230.210.21 query19 1.881.792.08 query20 0.010.020.01 query21 15.35 0.600.57 query22 2.552.351.86 query23 16.88 0.940.82 query24 2.871.640.48 query25 0.280.060.07 query26 0.410.140.14 query27 0.040.050.04 query28 10.59 0.510.45 query29 12.57 3.233.21 query30 0.250.060.06 query31 2.850.400.38 query32 3.260.470.46 query33 2.992.973.05 query34 17.14 4.444.46 query35 4.494.534.48 query36 0.690.490.48 query37 0.090.060.07 query38 0.040.040.03 query39 0.030.020.03 query40 0.160.130.12 query41 0.080.030.02 query42 0.030.030.02 query43 0.030.030.03 Total cold run time: 106.67 s Total hot run time: 31.51 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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
doris-robot commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2866398527 TPC-H: Total hot run time: 40137 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 7eb0ca142e26fdf03a5432a916c0788898272717, data reload: false -- Round 1 -- q1 17571 679166156615 q2 2044167 166 166 q3 10751 107011671070 q4 10543 728 648 648 q5 7754283128342831 q6 224 137 135 135 q7 977 641 634 634 q8 9376195520141955 q9 6624639464536394 q10 7043224822672248 q11 460 267 265 265 q12 404 222 217 217 q13 17804 294329832943 q14 238 207 209 207 q15 497 472 463 463 q16 668 585 585 585 q17 982 607 603 603 q18 7147669567326695 q19 1452111610331033 q20 473 203 201 201 q21 4366332432323232 q22 10511015997 997 Total cold run time: 108449 ms Total hot run time: 40137 ms - Round 2, with runtime_filter_mode=off - q1 6603674266346634 q2 330 239 236 236 q3 2950283130252831 q4 2061182617751775 q5 5834581558505815 q6 213 130 137 130 q7 2317189618791879 q8 3417360835813581 q9 8853886088268826 q10 3548351134793479 q11 591 500 509 500 q12 846 605 633 605 q13 8974318531423142 q14 303 270 294 270 q15 512 462 470 462 q16 692 657 642 642 q17 1832162816121612 q18 8179783475887588 q19 1659149215351492 q20 2080184719471847 q21 5452526052825260 q22 1135103810391038 Total cold run time: 68381 ms Total hot run time: 59644 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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
zddr commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2866281500 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] branch-3.0: [fix](mtmv)before mtmv refresh,check column type if change [doris]
hello-stephen commented on PR #50768: URL: https://github.com/apache/doris/pull/50768#issuecomment-2866281156 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]
