Re: [PR] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
morrySnow merged PR #44857: URL: https://github.com/apache/doris/pull/44857 -- 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](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
github-actions[bot] commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2519042271 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](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
doris-robot commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2516079520 ClickBench: Total hot run time: 32.74 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 4f6c7f5c6d0be032af47d0d389c7df502eda46d9, data reload: false query1 0.040.030.04 query2 0.060.030.03 query3 0.230.070.08 query4 1.630.110.11 query5 0.430.420.43 query6 1.190.660.64 query7 0.020.020.02 query8 0.040.030.03 query9 0.580.510.50 query10 0.560.550.57 query11 0.140.100.10 query12 0.130.110.10 query13 0.620.600.59 query14 2.812.742.83 query15 0.900.830.82 query16 0.390.390.38 query17 1.001.021.02 query18 0.220.210.21 query19 1.851.842.02 query20 0.020.010.01 query21 15.40 0.610.59 query22 2.732.552.14 query23 17.17 1.050.89 query24 2.851.720.71 query25 0.300.050.14 query26 0.480.140.14 query27 0.040.040.05 query28 10.51 1.111.08 query29 12.58 3.263.20 query30 0.260.070.06 query31 2.870.370.39 query32 3.270.460.46 query33 2.983.093.15 query34 17.33 4.424.54 query35 4.494.534.51 query36 0.680.470.50 query37 0.090.060.06 query38 0.050.040.04 query39 0.030.020.03 query40 0.170.120.13 query41 0.080.020.02 query42 0.030.020.02 query43 0.030.030.03 Total cold run time: 107.28 s Total hot run time: 32.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] [fix](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
doris-robot commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2516074337 TPC-DS: Total hot run time: 196035 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 4f6c7f5c6d0be032af47d0d389c7df502eda46d9, data reload: false query1 1269940 935 935 query2 6246206420812064 query3 10927 434344044343 query4 67175 28526 23435 23435 query5 4992457 428 428 query6 422 195 182 182 query7 5578299 296 296 query8 320 239 248 239 query9 8756274127382738 query10 450 249 253 249 query11 17222 15120 15826 15120 query12 158 100 101 100 query13 1495447 420 420 query14 9941768266466646 query15 216 190 208 190 query16 7119509 444 444 query17 1267577 562 562 query18 1805292 296 292 query19 199 143 146 143 query20 119 114 139 114 query21 205 101 98 98 query22 4726460945764576 query23 35018 34328 34562 34328 query24 5481241125242411 query25 480 400 392 392 query26 666 151 150 150 query27 1732278 291 278 query28 4712249124962491 query29 683 443 393 393 query30 208 148 150 148 query31 1018852 810 810 query32 67 56 55 55 query33 397 293 291 291 query34 932 526 531 526 query35 895 740 737 737 query36 1101977 958 958 query37 119 76 72 72 query38 4434440744134407 query39 1514147614761476 query40 209 96 95 95 query41 45 41 42 41 query42 106 99 96 96 query43 541 504 503 503 query44 1198816 817 816 query45 186 167 172 167 query46 1160739 702 702 query47 2080194619751946 query48 415 311 307 307 query49 713 382 398 382 query50 834 386 381 381 query51 7316721970287028 query52 96 86 88 86 query53 258 176 174 174 query54 504 375 402 375 query55 73 75 69 69 query56 271 218 221 218 query57 1252114211371137 query58 214 207 203 203 query59 3097289130312891 query60 270 238 252 238 query61 118 107 108 107 query62 770 679 656 656 query63 207 183 187 183 query64 1383662 634 634 query65 3241317832093178 query66 695 292 300 292 query67 16044 15554 15657 15554 query68 4240559 550 550 query69 410 259 246 246 query70 1160115311001100 query71 344 247 242 242 query72 6426409841154098 query73 756 349 355 349 query74 10296 907191749071 query75 3388263726612637 query76 1837116210611061 query77 485 255 256 255 query78 10303 947594119411 query79 1302590 591 590 query80 924 414 476 414 query81 523 237 234 234 query82 211 116 113 113 query83 173 139 143 139 query84 285 69 66 66 query85 984 295 296 295 query86 380 296 293 293 query87 4704464346004600 query88 4005218221742174 query89 402 292 280 280 query90 2139183 182 182 query91 135 102 102 102 query92 60 49 49 49 query93 2145541 513 513 query94 918 286 285 285 query95 342 246 255 246 query96 616 278 275 275 query97 2831264526522645 query98 214 195 194 194 query99 1592133513301330 Total cold run time: 317890 ms Total hot run time: 196035 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) Fix refresh materialized view fail when mv def contains cte [doris]
doris-robot commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2516062435 TPC-H: Total hot run time: 40068 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 4f6c7f5c6d0be032af47d0d389c7df502eda46d9, data reload: false -- Round 1 -- q1 17603 749172927292 q2 2040177 166 166 q3 10596 108411801084 q4 10542 728 721 721 q5 7596274426542654 q6 235 148 146 146 q7 998 610 596 596 q8 9251187018981870 q9 6720652065366520 q10 7047230523182305 q11 475 257 261 257 q12 413 228 223 223 q13 17769 300330113003 q14 243 205 217 205 q15 579 535 524 524 q16 657 572 574 572 q17 983 587 524 524 q18 7263677867086708 q19 13331043969 969 q20 466 178 187 178 q21 4105325932323232 q22 383 328 319 319 Total cold run time: 107297 ms Total hot run time: 40068 ms - Round 2, with runtime_filter_mode=off - q1 7334728272647264 q2 327 233 238 233 q3 2944287529572875 q4 2057180818411808 q5 5701581356425642 q6 238 144 147 144 q7 2238180118041801 q8 3426360235503550 q9 8997906390519051 q10 3614356336233563 q11 611 507 510 507 q12 822 617 633 617 q13 10163 320632573206 q14 309 275 274 274 q15 580 535 535 535 q16 701 664 642 642 q17 1868162615731573 q18 8186768876027602 q19 1721165915041504 q20 2088186218571857 q21 5750549154765476 q22 688 578 566 566 Total cold run time: 70363 ms Total hot run time: 60290 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](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
seawinde commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2515994877 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](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
github-actions[bot] commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2511235543 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](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
github-actions[bot] commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2511235455 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](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
doris-robot commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2510992594 ClickBench: Total hot run time: 33.44 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 33cca52f58895ae7c926c664005eaf65580d55c4, data reload: false query1 0.030.020.03 query2 0.070.030.03 query3 0.230.070.07 query4 1.630.100.11 query5 0.400.410.41 query6 1.170.660.66 query7 0.020.010.01 query8 0.050.030.03 query9 0.590.510.51 query10 0.540.550.57 query11 0.140.100.10 query12 0.130.110.11 query13 0.600.620.61 query14 2.842.742.87 query15 0.920.830.83 query16 0.390.370.38 query17 1.031.041.01 query18 0.210.210.20 query19 1.941.822.01 query20 0.010.010.01 query21 15.36 0.600.59 query22 2.612.092.09 query23 16.89 1.070.88 query24 2.591.462.12 query25 0.350.100.12 query26 0.610.150.15 query27 0.050.050.04 query28 9.871.111.09 query29 12.52 3.193.18 query30 0.250.060.07 query31 2.870.400.37 query32 3.270.460.48 query33 2.983.053.05 query34 17.09 4.464.46 query35 4.484.514.48 query36 0.670.490.50 query37 0.090.060.06 query38 0.050.040.03 query39 0.030.030.02 query40 0.160.120.13 query41 0.080.020.02 query42 0.040.020.02 query43 0.030.040.03 Total cold run time: 105.88 s Total hot run time: 33.44 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](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
doris-robot commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2510981058 TPC-DS: Total hot run time: 198052 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 33cca52f58895ae7c926c664005eaf65580d55c4, data reload: false query1 1237955 954 954 query2 6233208720642064 query3 10942 440944354409 query4 0 28865 23496 23496 query5 4905481 457 457 query6 410 196 178 178 query7 310 302 302 query8 330 263 246 246 query9 8755269526882688 query10 440 242 240 240 query11 17386 15400 16082 15400 query12 145 100 101 100 query13 1453424 409 409 query14 10925 763776097609 query15 218 180 187 180 query16 7066466 456 456 query17 1186621 599 599 query18 1882315 315 315 query19 212 167 168 167 query20 121 116 112 112 query21 221 105 104 104 query22 4817455245594552 query23 35109 34261 34365 34261 query24 6014264425942594 query25 484 393 382 382 query26 648 151 152 151 query27 1952289 287 287 query28 4256246524642464 query29 683 438 423 423 query30 218 157 150 150 query31 1020833 845 833 query32 65 55 55 55 query33 410 355 329 329 query34 949 518 547 518 query35 915 785 779 779 query36 1095971 950 950 query37 118 66 74 66 query38 4485455743834383 query39 1528152214801480 query40 200 104 101 101 query41 46 43 42 42 query42 113 100 101 100 query43 542 505 506 505 query44 1182818 821 818 query45 202 171 178 171 query46 1199730 777 730 query47 2060191219361912 query48 418 308 319 308 query49 726 407 420 407 query50 861 397 401 397 query51 7419721471337133 query52 98 88 92 88 query53 254 183 178 178 query54 522 397 392 392 query55 79 74 74 74 query56 241 236 242 236 query57 1273112111051105 query58 218 215 236 215 query59 3250301027952795 query60 263 234 239 234 query61 109 106 108 106 query62 816 691 678 678 query63 219 201 186 186 query64 1466707 660 660 query65 3308323732283228 query66 717 340 304 304 query67 16277 15662 15687 15662 query68 3832578 559 559 query69 444 249 254 249 query70 1142113511341134 query71 360 248 265 248 query72 6435405140974051 query73 751 367 365 365 query74 10376 908392229083 query75 3358270626552655 query76 1854102511231025 query77 511 291 276 276 query78 10490 948193969396 query79 1407621 605 605 query80 889 446 511 446 query81 486 229 234 229 query82 1295125 119 119 query83 253 148 139 139 query84 278 70 71 70 query85 889 289 292 289 query86 333 308 299 299 query87 4650459046284590 query88 3720221321742174 query89 421 311 305 305 query90 2021193 194 193 query91 136 100 105 100 query92 69 56 52 52 query93 1952535 544 535 query94 792 291 287 287 query95 348 249 248 248 query96 619 275 276 275 query97 2844264827152648 query98 222 191 204 191 query99 1647135413101310 Total cold run time: 319950 ms Total hot run time: 198052 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](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
doris-robot commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2510954043 TPC-H: Total hot run time: 40153 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 33cca52f58895ae7c926c664005eaf65580d55c4, data reload: false -- Round 1 -- q1 17602 745172747274 q2 2043188 170 170 q3 10802 108812221088 q4 10471 790 676 676 q5 7608278227422742 q6 238 144 146 144 q7 1029635 604 604 q8 9237184519521845 q9 6731658265086508 q10 7022231023442310 q11 482 267 257 257 q12 431 231 225 225 q13 18503 307530573057 q14 275 222 210 210 q15 589 534 524 524 q16 669 595 588 588 q17 981 544 561 544 q18 7321676666986698 q19 1332928 922 922 q20 458 183 184 183 q21 4073326533643265 q22 391 328 319 319 Total cold run time: 108288 ms Total hot run time: 40153 ms - Round 2, with runtime_filter_mode=off - q1 7387737372697269 q2 347 232 236 232 q3 3073314231733142 q4 2157191719451917 q5 5852581256915691 q6 231 144 142 142 q7 2350182517471747 q8 3438357235383538 q9 9024908491559084 q10 3585354635833546 q11 617 531 523 523 q12 850 624 617 617 q13 16107 324132113211 q14 308 276 260 260 q15 586 523 519 519 q16 696 627 644 627 q17 1844163616241624 q18 8365797475637563 q19 1702142216131422 q20 2110186519201865 q21 5587537755075377 q22 613 551 556 551 Total cold run time: 76829 ms Total hot run time: 60467 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](mtmv) Fix refresh materialized view fail when mv def contains cte [doris]
seawinde commented on PR #44857: URL: https://github.com/apache/doris/pull/44857#issuecomment-2510868834 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