Re: [PR] [fix](mtmv) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
morrySnow merged PR #58643: URL: https://github.com/apache/doris/pull/58643 -- 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) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
github-actions[bot] commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3605863651 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) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
github-actions[bot] commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3605863470 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) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
doris-robot commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3604949523 ClickBench: Total hot run time: 27.3 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 99f0df716682d530913e1e036dc906c3309b56e1, data reload: false query1 0.050.040.04 query2 0.100.050.04 query3 0.240.090.08 query4 1.610.110.11 query5 0.280.250.27 query6 1.140.630.64 query7 0.030.030.03 query8 0.060.040.04 query9 0.550.500.50 query10 0.550.560.56 query11 0.140.100.10 query12 0.150.110.11 query13 0.640.610.59 query14 0.991.000.98 query15 0.810.810.79 query16 0.420.420.40 query17 1.051.081.08 query18 0.230.220.21 query19 1.941.841.85 query20 0.020.010.01 query21 15.44 0.290.14 query22 4.790.050.05 query23 16.16 0.300.10 query24 1.050.240.18 query25 0.060.070.08 query26 0.140.140.13 query27 0.080.080.05 query28 3.321.231.02 query29 12.61 3.973.23 query30 0.280.130.12 query31 2.820.620.38 query32 3.300.550.45 query33 2.993.053.06 query34 16.98 5.214.54 query35 4.584.534.56 query36 0.660.500.49 query37 0.110.070.07 query38 0.070.040.04 query39 0.040.030.03 query40 0.160.140.14 query41 0.090.040.04 query42 0.040.030.03 query43 0.040.040.03 Total cold run time: 96.81 s Total hot run time: 27.3 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) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
doris-robot commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3604927854 TPC-DS: Total hot run time: 181466 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 99f0df716682d530913e1e036dc906c3309b56e1, data reload: false query1 1116403 400 400 query2 6650117211721172 query3 6826226 230 226 query4 25195 23400 22997 22997 query5 5249649 497 497 query6 341 241 232 232 query7 4687520 309 309 query8 302 255 234 234 query9 8757262026182618 query10 574 373 322 322 query11 15390 14770 14892 14770 query12 190 123 114 114 query13 1697582 452 452 query14 9925597559795975 query15 214 201 183 183 query16 7680699 536 536 query17 1251791 648 648 query18 2077442 345 345 query19 218 218 186 186 query20 130 124 119 119 query21 407 139 122 122 query22 3838388539423885 query23 32833 31816 31838 31816 query24 8398241024192410 query25 650 549 487 487 query26 1298279 176 176 query27 2668501 351 351 query28 4329216821532153 query29 834 654 519 519 query30 354 243 213 213 query31 826 709 618 618 query32 90 80 76 76 query33 635 389 347 347 query34 840 880 538 538 query35 811 876 754 754 query36 890 916 844 844 query37 166 111 89 89 query38 3816386437733773 query39 1459141614311416 query40 227 135 118 118 query41 67 62 61 61 query42 121 118 113 113 query43 426 458 418 418 query44 1361742 737 737 query45 200 192 187 187 query46 908 1021642 642 query47 1673174416361636 query48 425 432 329 329 query49 760 486 403 403 query50 698 705 411 411 query51 3940392438483848 query52 113 113 103 103 query53 249 263 196 196 query54 317 323 280 280 query55 98 94 92 92 query56 345 333 339 333 query57 1108116111101110 query58 297 277 272 272 query59 2333236922972297 query60 349 350 325 325 query61 188 163 164 163 query62 791 727 642 642 query63 233 198 189 189 query64 44591230894 894 query65 4031395139683951 query66 1085439 328 328 query67 15071 15114 14791 14791 query68 8304998 619 619 query69 532 337 310 310 query70 1100100510191005 query71 498 337 345 337 query72 5895485748074807 query73 684 589 345 345 query74 8878889786318631 query75 3666300025352535 query76 38181134753 753 query77 818 393 325 325 query78 9603949388308830 query79 2318845 590 590 query80 645 577 489 489 query81 509 267 240 240 query82 516 141 108 108 query83 276 269 253 253 query84 267 120 105 105 query85 906 501 450 450 query86 390 310 301 301 query87 4128409939303930 query88 4143231622862286 query89 397 330 299 299 query90 1993227 231 227 query91 174 173 137 137 query92 89 67 66 66 query93 19641047664 664 query94 720 441 339 339 query95 509 418 406 406 query96 543 576 287 287 query97 2622263525252525 query98 250 210 204 204 query99 1360137912721272 Total cold run time: 273999 ms Total hot run time: 181466 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 hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
doris-robot commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3604890960 TPC-H: Total hot run time: 34254 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 99f0df716682d530913e1e036dc906c3309b56e1, data reload: false -- Round 1 -- q1 17724 506649294929 q2 2203359 201 201 q3 10208 1297747 747 q4 10270 871 318 318 q5 7513234921762176 q6 189 177 145 145 q7 946 781 658 658 q8 9355139711251125 q9 7077529053205290 q10 7000218217991799 q11 543 324 286 286 q12 389 374 231 231 q13 17783 361930153015 q14 226 241 215 215 q15 570 518 506 506 q16 857 848 813 813 q17 731 782 542 542 q18 7488710970047004 q19 1094955 608 608 q20 362 360 229 229 q21 4030345724882488 q22 1023987 929 929 Total cold run time: 107581 ms Total hot run time: 34254 ms - Round 2, with runtime_filter_mode=off - q1 5004496649514951 q2 324 424 314 314 q3 2148265222902290 q4 1292174512961296 q5 4221440844484408 q6 211 171 131 131 q7 2040202419181918 q8 2733264025332533 q9 7457756275817562 q10 3077320729022902 q11 574 512 507 507 q12 695 722 569 569 q13 3400387133363336 q14 283 300 301 300 q15 547 498 496 496 q16 914 942 896 896 q17 1221152714591459 q18 7871756775907567 q19 919 898 914 898 q20 1976196318041804 q21 4597423640554055 q22 10931045969 969 Total cold run time: 52597 ms Total hot run time: 51161 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) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
hello-stephen commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3602673012 # FE Regression Coverage Report Increment line coverage ` 76.92% (10/13)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58643_548a5a3ca3a8b4967a10ddfd539f5cc9afea66bf_merge_fe/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58643_548a5a3ca3a8b4967a10ddfd539f5cc9afea66bf_merge_fe/report/index.html) -- 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) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
hello-stephen commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3602225739 # FE UT Coverage Report Increment line coverage ` 84.62% (11/13)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58643_548a5a3ca3a8b4967a10ddfd539f5cc9afea66bf/fe_increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58643_548a5a3ca3a8b4967a10ddfd539f5cc9afea66bf/fe_report/index.html) -- 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) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
doris-robot commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3602116155 ClickBench: Total hot run time: 27.77 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 548a5a3ca3a8b4967a10ddfd539f5cc9afea66bf, data reload: false query1 0.070.050.04 query2 0.100.050.05 query3 0.250.100.08 query4 1.610.110.10 query5 0.280.270.28 query6 1.200.640.63 query7 0.030.030.03 query8 0.060.050.04 query9 0.580.520.50 query10 0.560.560.56 query11 0.160.100.11 query12 0.150.120.12 query13 0.640.610.61 query14 0.990.980.97 query15 0.820.800.80 query16 0.400.380.41 query17 1.021.041.02 query18 0.240.260.21 query19 1.881.871.86 query20 0.020.010.01 query21 15.44 0.290.14 query22 4.990.050.05 query23 16.11 0.280.11 query24 1.270.700.88 query25 0.090.080.05 query26 0.150.130.13 query27 0.060.040.05 query28 4.821.231.03 query29 12.62 3.883.13 query30 0.300.130.12 query31 2.820.640.41 query32 3.230.560.47 query33 3.103.243.06 query34 16.99 5.174.56 query35 4.574.534.60 query36 0.670.500.49 query37 0.120.070.07 query38 0.070.040.04 query39 0.050.030.04 query40 0.180.140.14 query41 0.090.040.03 query42 0.050.030.03 query43 0.040.040.03 Total cold run time: 98.89 s Total hot run time: 27.77 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) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
doris-robot commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3602085041 TPC-DS: Total hot run time: 182427 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 548a5a3ca3a8b4967a10ddfd539f5cc9afea66bf, data reload: false query1 1094413 402 402 query2 6606122411801180 query3 6743229 226 226 query4 25707 23253 22938 22938 query5 4812681 516 516 query6 341 262 227 227 query7 4661535 311 311 query8 324 259 244 244 query9 8723264326522643 query10 535 352 347 347 query11 15484 15173 14525 14525 query12 188 120 112 112 query13 1676579 445 445 query14 9283618163166181 query15 225 202 185 185 query16 7274702 492 492 query17 1217771 629 629 query18 2008436 345 345 query19 220 216 194 194 query20 134 130 130 130 query21 227 173 117 117 query22 3877385938873859 query23 32904 31965 31753 31753 query24 8620245724842457 query25 635 513 459 459 query26 1246284 172 172 query27 2740522 339 339 query28 4386216621312131 query29 856 643 496 496 query30 322 243 208 208 query31 859 754 627 627 query32 87 77 74 74 query33 605 390 344 344 query34 865 913 554 554 query35 813 858 767 767 query36 912 938 853 853 query37 128 123 93 93 query38 3947386538633863 query39 1543144714391439 query40 234 148 130 130 query41 66 65 69 65 query42 136 119 120 119 query43 439 456 430 430 query44 1377775 752 752 query45 203 193 185 185 query46 960 1057666 666 query47 1684169616241624 query48 412 437 324 324 query49 779 496 422 422 query50 722 776 416 416 query51 3948385038453845 query52 114 114 106 106 query53 249 273 197 197 query54 319 309 291 291 query55 99 99 92 92 query56 357 350 348 348 query57 1115115911151115 query58 302 283 275 275 query59 2275236023772360 query60 373 378 373 373 query61 192 189 185 185 query62 797 715 697 697 query63 248 207 201 201 query64 4792134310121012 query65 4083396839723968 query66 1210471 355 355 query67 15400 14941 14770 14770 query68 62861023634 634 query69 543 367 324 324 query70 1108105110171017 query71 445 364 329 329 query72 6069494848094809 query73 674 602 349 349 query74 8749885088338833 query75 3072305325692569 query76 32911217786 786 query77 509 428 320 320 query78 9501992988468846 query79 1413876 571 571 query80 1693587 496 496 query81 568 277 244 244 query82 424 148 117 117 query83 364 271 263 263 query84 255 122 97 97 query85 916 499 450 450 query86 389 297 294 294 query87 4119419540404040 query88 3097233923112311 query89 405 335 295 295 query90 1765230 227 227 query91 183 178 146 146 query92 79 72 83 72 query93 12571028663 663 query94 720 477 369 369 query95 518 435 421 421 query96 539 558 286 286 query97 2634267426002600 query98 242 224 209 209 query99 1285139212401240 Total cold run time: 268824 ms Total hot run time: 182427 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 hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
doris-robot commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3602027176 TPC-H: Total hot run time: 34710 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 548a5a3ca3a8b4967a10ddfd539f5cc9afea66bf, data reload: false -- Round 1 -- q1 17612 513649684968 q2 2044326 209 209 q3 10229 1321756 756 q4 10207 853 333 333 q5 7724250121792179 q6 193 175 149 149 q7 991 854 681 681 q8 9366148912221222 q9 6994532754025327 q10 6892223717891789 q11 537 304 305 304 q12 341 387 240 240 q13 17810 367930563056 q14 250 248 214 214 q15 595 506 514 506 q16 885 869 815 815 q17 668 877 529 529 q18 7929698670006986 q19 1116950 638 638 q20 384 358 230 230 q21 4051386926272627 q22 10481007952 952 Total cold run time: 107866 ms Total hot run time: 34710 ms - Round 2, with runtime_filter_mode=off - q1 5065501250025002 q2 330 400 326 326 q3 2145271223202320 q4 1330175213071307 q5 4328450145164501 q6 226 173 136 136 q7 2066197617761776 q8 2789257525532553 q9 7682737675537376 q10 3116325529062906 q11 611 521 500 500 q12 693 763 666 666 q13 3574405235253525 q14 321 295 282 282 q15 553 525 510 510 q16 875 939 877 877 q17 1192147114471447 q18 8000763774247424 q19 944 867 912 867 q20 2113205417981798 q21 4719426741574157 q22 10701033991 991 Total cold run time: 53742 ms Total hot run time: 51247 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) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
seawinde commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3601832994 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) Fix hudi materialized view union all rewritten plan execute fail because of invalid slot [doris]
Thearas commented on PR #58643: URL: https://github.com/apache/doris/pull/58643#issuecomment-3601832665 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]
