Re: [PR] [fix](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2876856912 TPC-DS: Total hot run time: 193903 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 56769a91009196d533bf73b3be9e28c09ce4ec64, data reload: false query1 1402111211031103 query2 6341188418981884 query3 11014 453245314531 query4 53503 25696 23114 23114 query5 5053588 457 457 query6 370 218 202 202 query7 4891512 302 302 query8 325 279 252 252 query9 5232266026642660 query10 459 342 279 279 query11 15107 14948 14901 14901 query12 165 113 106 106 query13 1031542 420 420 query14 10172 652063766376 query15 204 202 191 191 query16 7065657 504 504 query17 1140745 616 616 query18 1587433 367 367 query19 204 200 171 171 query20 133 124 135 124 query21 200 134 106 106 query22 4263449642614261 query23 34344 33601 33578 33578 query24 6597251125032503 query25 478 475 426 426 query26 734 272 157 157 query27 2361520 350 350 query28 3143215321312131 query29 596 602 445 445 query30 276 225 196 196 query31 890 893 832 832 query32 74 70 59 59 query33 449 370 323 323 query34 788 867 563 563 query35 806 854 770 770 query36 955 1028905 905 query37 120 99 79 79 query38 4292429242644264 query39 1515145414481448 query40 230 118 114 114 query41 57 60 54 54 query42 146 114 110 110 query43 502 522 477 477 query44 1340847 840 840 query45 185 179 172 172 query46 864 1050679 679 query47 1890187117981798 query48 409 440 321 321 query49 695 520 483 483 query50 667 705 401 401 query51 4206417441874174 query52 114 111 101 101 query53 239 269 208 208 query54 626 579 531 531 query55 89 86 85 85 query56 332 317 307 307 query57 1160124911451145 query58 276 276 264 264 query59 2758287327702770 query60 337 347 321 321 query61 134 129 129 129 query62 771 741 667 667 query63 237 196 199 196 query64 19141058729 729 query65 4303424942364236 query66 714 407 314 314 query67 15909 15511 15396 15396 query68 7430897 530 530 query69 546 312 265 265 query70 1200114911141114 query71 509 316 297 297 query72 5618476751184767 query73 1582664 356 356 query74 8936909787008700 query75 4061332727192719 query76 41621184765 765 query77 692 372 291 291 query78 10103 10174 93619361 query79 2152794 594 594 query80 643 524 455 455 query81 485 260 225 225 query82 443 126 104 104 query83 352 249 232 232 query84 297 103 85 85 query85 770 356 321 321 query86 362 300 280 280 query87 4456441744484417 query88 3796231822902290 query89 407 318 287 287 query90 1874214 220 214 query91 167 146 114 114 query92 73 58 62 58 query93 1541963 584 584 query94 684 405 309 309 query95 371 296 288 288 query96 501 569 283 283 query97 3175323731553155 query98 233 212 199 199 query99 1458138912661266 Total cold run time: 298462 ms Total hot run time: 193903 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2876875089 ClickBench: Total hot run time: 28.84 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 56769a91009196d533bf73b3be9e28c09ce4ec64, data reload: false query1 0.040.030.04 query2 0.120.110.12 query3 0.250.190.20 query4 1.600.190.19 query5 0.590.610.58 query6 1.200.720.71 query7 0.020.010.02 query8 0.050.030.04 query9 0.560.530.51 query10 0.560.570.56 query11 0.160.110.10 query12 0.140.120.11 query13 0.620.600.61 query14 0.780.820.81 query15 0.870.860.85 query16 0.400.370.38 query17 1.051.031.03 query18 0.220.220.21 query19 1.881.771.80 query20 0.010.010.01 query21 15.40 0.930.55 query22 0.761.210.64 query23 14.93 1.400.67 query24 7.171.620.36 query25 0.480.090.26 query26 0.560.150.13 query27 0.060.050.06 query28 9.470.890.45 query29 12.60 3.903.29 query30 0.260.090.06 query31 2.820.590.38 query32 3.230.560.48 query33 3.023.103.08 query34 15.89 5.094.55 query35 4.564.524.48 query36 0.660.490.48 query37 0.080.070.07 query38 0.050.040.04 query39 0.030.020.02 query40 0.160.150.13 query41 0.080.030.02 query42 0.040.020.02 query43 0.040.040.02 Total cold run time: 103.47 s Total hot run time: 28.84 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2876804814 TPC-H: Total hot run time: 34163 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 56769a91009196d533bf73b3be9e28c09ce4ec64, data reload: false -- Round 1 -- q1 26061 503849924992 q2 2067298 203 203 q3 10354 1246706 706 q4 10214 1020525 525 q5 7547238824082388 q6 187 169 139 139 q7 941 745 602 602 q8 9312128911971197 q9 6826513050865086 q10 6891233419121912 q11 518 299 276 276 q12 361 364 213 213 q13 17764 375331453145 q14 222 222 212 212 q15 538 483 485 483 q16 433 440 380 380 q17 602 860 350 350 q18 7517707672107076 q19 1492931 565 565 q20 339 335 229 229 q21 4332344225432543 q22 1072987 941 941 Total cold run time: 115590 ms Total hot run time: 34163 ms - Round 2, with runtime_filter_mode=off - q1 5147511351525113 q2 238 329 240 240 q3 2195268122982298 q4 1376175314631463 q5 4434441444184414 q6 223 174 133 133 q7 2010194017841784 q8 2584258826052588 q9 7208719169766976 q10 3011323127752775 q11 586 515 485 485 q12 687 775 623 623 q13 3600387233233323 q14 303 329 292 292 q15 551 496 485 485 q16 452 481 433 433 q17 1167154514071407 q18 7766765374697469 q19 862 851 874 851 q20 2034200218351835 q21 5243490050604900 q22 1067108510111011 Total cold run time: 52744 ms Total hot run time: 50898 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2876634691 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
github-actions[bot] commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2870742575 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
github-actions[bot] commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2870742480 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2870569642 ClickBench: Total hot run time: 28.79 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 54f136878f9ef7e2b9e8e69ce3853ff1b3131335, data reload: false query1 0.030.030.03 query2 0.120.110.11 query3 0.250.200.19 query4 1.590.200.12 query5 0.580.560.56 query6 1.170.710.73 query7 0.020.020.02 query8 0.040.030.03 query9 0.580.520.50 query10 0.580.580.57 query11 0.150.100.11 query12 0.150.110.13 query13 0.620.600.60 query14 0.780.810.80 query15 0.870.860.85 query16 0.380.390.37 query17 1.061.021.02 query18 0.240.220.21 query19 2.001.881.86 query20 0.010.010.01 query21 15.40 0.920.55 query22 0.751.200.74 query23 14.91 1.370.60 query24 7.801.300.41 query25 0.480.270.07 query26 0.570.170.14 query27 0.050.040.05 query28 9.040.910.45 query29 12.55 3.913.28 query30 0.260.100.07 query31 2.840.600.37 query32 3.230.560.47 query33 3.053.023.06 query34 15.77 5.184.48 query35 4.554.544.56 query36 0.650.500.48 query37 0.080.060.07 query38 0.050.040.03 query39 0.040.030.03 query40 0.180.140.12 query41 0.080.020.02 query42 0.030.020.03 query43 0.040.040.03 Total cold run time: 103.62 s Total hot run time: 28.79 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2870564286 TPC-DS: Total hot run time: 193830 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 54f136878f9ef7e2b9e8e69ce3853ff1b3131335, data reload: false query1 1427110110681068 query2 6419183618311831 query3 11094 464647834646 query4 25320 23947 23191 23191 query5 4386628 482 482 query6 324 216 202 202 query7 3991512 297 297 query8 305 270 257 257 query9 8448265726612657 query10 476 320 287 287 query11 15245 15097 14842 14842 query12 167 119 107 107 query13 1569554 409 409 query14 9072613563136135 query15 198 190 164 164 query16 7407620 473 473 query17 1181757 602 602 query18 1999423 297 297 query19 218 207 177 177 query20 127 127 116 116 query21 210 128 110 110 query22 4407457043244324 query23 34702 34036 33794 33794 query24 8592249224572457 query25 518 479 398 398 query26 1164273 152 152 query27 2978522 349 349 query28 4738215221582152 query29 710 583 450 450 query30 280 222 199 199 query31 941 869 793 793 query32 73 66 67 66 query33 573 424 337 337 query34 825 865 551 551 query35 806 859 738 738 query36 982 1005883 883 query37 116 101 70 70 query38 4387437142234223 query39 1506144514611445 query40 217 117 110 110 query41 59 58 52 52 query42 123 116 114 114 query43 508 523 487 487 query44 1360848 864 848 query45 185 178 168 168 query46 877 1035662 662 query47 1883190717811781 query48 398 448 339 339 query49 780 531 455 455 query50 668 707 419 419 query51 4201427442114211 query52 115 114 105 105 query53 233 262 191 191 query54 631 609 535 535 query55 87 92 86 86 query56 344 338 299 299 query57 1176119511631163 query58 306 290 271 271 query59 2704281626092609 query60 370 333 339 333 query61 161 163 153 153 query62 818 731 673 673 query63 261 200 187 187 query64 43361053713 713 query65 4519432843214321 query66 1036401 312 312 query67 15976 15722 15427 15427 query68 9145896 526 526 query69 494 310 273 273 query70 1242117611131113 query71 459 333 314 314 query72 5631471849484718 query73 755 650 360 360 query74 9252905188368836 query75 4305325527212721 query76 37461187770 770 query77 794 371 278 278 query78 991210230 94679467 query79 1456827 566 566 query80 590 514 537 514 query81 488 261 223 223 query82 437 127 96 96 query83 285 252 234 234 query84 295 102 85 85 query85 775 352 320 320 query86 342 300 285 285 query87 4453451543454345 query88 2852227622672267 query89 389 316 288 288 query90 1918214 209 209 query91 143 142 111 111 query92 80 58 57 57 query93 1138914 572 572 query94 666 409 315 315 query95 372 301 283 283 query96 498 565 280 280 query97 3191328231313131 query98 226 214 207 207 query99 1435138813111311 Total cold run time: 279977 ms Total hot run time: 193830 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2870547894 TPC-H: Total hot run time: 34727 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 54f136878f9ef7e2b9e8e69ce3853ff1b3131335, data reload: false -- Round 1 -- q1 26358 526650425042 q2 2090276 182 182 q3 10410 1232704 704 q4 10220 1012547 547 q5 7523237823362336 q6 179 159 131 131 q7 931 746 598 598 q8 9300129210661066 q9 6815512451105110 q10 6855231419171917 q11 503 304 300 300 q12 340 355 224 224 q13 17784 367330843084 q14 229 227 225 225 q15 526 479 484 479 q16 427 436 388 388 q17 606 852 381 381 q18 7611703872037038 q19 21711025555 555 q20 340 349 229 229 q21 4012352831613161 q22 1099109010301030 Total cold run time: 116329 ms Total hot run time: 34727 ms - Round 2, with runtime_filter_mode=off - q1 5396504550465045 q2 241 337 230 230 q3 2232274023732373 q4 1382186914151415 q5 4554452444654465 q6 220 173 137 137 q7 2027193717961796 q8 2627266726112611 q9 7404700072217000 q10 3003317827732773 q11 584 535 492 492 q12 693 781 626 626 q13 3555385233873387 q14 295 301 290 290 q15 521 476 481 476 q16 464 484 458 458 q17 1172159513591359 q18 7774747973437343 q19 820 810 925 810 q20 2008197118421842 q21 5155468847414688 q22 1088107410131013 Total cold run time: 53215 ms Total hot run time: 50629 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2870490490 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2837478923 ClickBench: Total hot run time: 29.47 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit cd4252ece048a478dd85690a977a6f3ab9c81989, data reload: false query1 0.030.040.03 query2 0.110.110.11 query3 0.250.190.19 query4 1.600.180.19 query5 0.610.560.59 query6 1.180.720.72 query7 0.020.020.01 query8 0.040.030.04 query9 0.570.510.51 query10 0.570.560.56 query11 0.150.100.11 query12 0.150.110.11 query13 0.620.600.60 query14 0.780.810.80 query15 0.840.840.85 query16 0.380.390.39 query17 1.031.061.01 query18 0.220.190.20 query19 1.841.811.81 query20 0.010.010.02 query21 15.47 0.870.54 query22 0.751.180.93 query23 14.72 1.350.62 query24 6.951.580.96 query25 0.510.110.17 query26 0.670.160.14 query27 0.060.060.04 query28 10.64 0.840.43 query29 12.53 3.913.25 query30 0.260.100.06 query31 2.810.600.39 query32 3.220.550.48 query33 3.073.043.13 query34 15.74 5.084.45 query35 4.524.494.51 query36 0.660.530.48 query37 0.090.070.06 query38 0.050.030.03 query39 0.030.030.02 query40 0.170.140.12 query41 0.090.030.02 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 104.09 s Total hot run time: 29.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: [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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2837465303 TPC-DS: Total hot run time: 185197 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 cd4252ece048a478dd85690a977a6f3ab9c81989, data reload: false query1 1013468 504 468 query2 6582184817891789 query3 6745212 217 212 query4 26805 23800 23526 23526 query5 4800620 435 435 query6 308 200 202 200 query7 4615487 276 276 query8 281 237 230 230 query9 8630257625932576 query10 492 313 261 261 query11 15236 15012 14844 14844 query12 159 109 107 107 query13 1657519 382 382 query14 10241 606962426069 query15 201 188 174 174 query16 7699664 487 487 query17 1151723 586 586 query18 2032407 307 307 query19 197 196 164 164 query20 121 118 117 117 query21 215 126 105 105 query22 4175424441174117 query23 33781 32971 33035 32971 query24 7732242424062406 query25 544 459 384 384 query26 1241266 155 155 query27 2581458 333 333 query28 4360208820722072 query29 716 530 419 419 query30 290 210 187 187 query31 962 847 750 750 query32 74 69 61 61 query33 551 364 299 299 query34 793 838 514 514 query35 776 814 711 711 query36 968 991 874 874 query37 107 100 79 79 query38 4108418440224022 query39 1463148413991399 query40 211 116 115 115 query41 62 59 55 55 query42 115 103 106 103 query43 497 506 462 462 query44 1295818 794 794 query45 181 172 167 167 query46 831 1034618 618 query47 1770183817431743 query48 362 411 298 298 query49 776 505 419 419 query50 657 677 388 388 query51 4079410539833983 query52 107 102 97 97 query53 224 259 183 183 query54 584 569 495 495 query55 82 77 76 76 query56 304 295 272 272 query57 1115113810731073 query58 257 254 246 246 query59 2602261125052505 query60 322 323 296 296 query61 128 124 123 123 query62 778 747 652 652 query63 226 185 180 180 query64 42551011665 665 query65 4311424542244224 query66 1054412 320 320 query67 15840 15419 15244 15244 query68 8227884 521 521 query69 470 316 259 259 query70 1234105210801052 query71 491 323 287 287 query72 5582463045794579 query73 703 560 336 336 query74 9203920189228922 query75 3842323226572657 query76 37411221773 773 query77 788 372 278 278 query78 10023 10163 92789278 query79 2609805 564 564 query80 642 521 440 440 query81 499 256 221 221 query82 679 122 97 97 query83 253 256 248 248 query84 250 115 85 85 query85 789 355 314 314 query86 383 310 280 280 query87 4473447942394239 query88 3545218522092185 query89 392 310 279 279 query90 1854206 206 206 query91 142 143 112 112 query92 83 60 56 56 query93 1638955 583 583 query94 672 408 305 305 query95 368 292 279 279 query96 489 564 274 274 query97 3125325331263126 query98 243 199 215 199 query99 1433137512991299 Total cold run time: 276292 ms Total hot run time: 185197 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2837452723 TPC-H: Total hot run time: 34022 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit cd4252ece048a478dd85690a977a6f3ab9c81989, data reload: false -- Round 1 -- q1 25996 511950815081 q2 2075279 187 187 q3 10391 1261683 683 q4 10228 993 536 536 q5 7569236523932365 q6 178 161 132 132 q7 908 771 609 609 q8 9321130010891089 q9 6766516850675067 q10 6818232118881888 q11 477 286 265 265 q12 341 359 212 212 q13 17780 367830943094 q14 224 233 208 208 q15 541 493 490 490 q16 413 428 368 368 q17 606 851 377 377 q18 7622727971497149 q19 1210935 569 569 q20 343 339 242 242 q21 4325337324702470 q22 10421032941 941 Total cold run time: 115174 ms Total hot run time: 34022 ms - Round 2, with runtime_filter_mode=off - q1 5112506650525052 q2 235 329 231 231 q3 2196282323322332 q4 1342177313381338 q5 4593454444284428 q6 212 167 125 125 q7 1943185617301730 q8 2602256325052505 q9 7116708670517051 q10 3045316827782778 q11 553 495 468 468 q12 711 762 580 580 q13 3518400033383338 q14 283 297 258 258 q15 519 484 466 466 q16 447 507 455 455 q17 1165157113521352 q18 7623768172997299 q19 804 813 852 813 q20 1954205518641864 q21 5117460544574457 q22 10751038987 987 Total cold run time: 52165 ms Total hot run time: 49907 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2837429547 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2826142212 ClickBench: Total hot run time: 29.61 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1ecf4355f2230cd8bfdaba03d2318dd257bec211, data reload: false query1 0.040.040.03 query2 0.120.110.12 query3 0.250.190.19 query4 1.600.190.19 query5 0.580.590.59 query6 1.160.710.72 query7 0.020.020.02 query8 0.050.040.03 query9 0.580.530.51 query10 0.570.590.56 query11 0.150.110.10 query12 0.150.120.11 query13 0.610.600.59 query14 1.151.191.20 query15 0.860.860.84 query16 0.390.380.40 query17 1.021.011.06 query18 0.210.190.20 query19 1.901.821.82 query20 0.010.010.02 query21 15.42 0.870.55 query22 0.761.140.71 query23 14.93 1.370.61 query24 7.041.420.67 query25 0.500.260.06 query26 0.610.170.14 query27 0.050.050.05 query28 9.040.860.41 query29 12.58 3.923.32 query30 0.250.100.07 query31 2.800.580.38 query32 3.220.560.48 query33 2.973.083.07 query34 15.60 5.124.60 query35 4.574.514.54 query36 0.660.490.48 query37 0.090.060.06 query38 0.050.040.04 query39 0.030.020.02 query40 0.170.140.13 query41 0.080.020.02 query42 0.040.020.02 query43 0.030.030.03 Total cold run time: 102.91 s Total hot run time: 29.61 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2826136485 TPC-DS: Total hot run time: 193198 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 1ecf4355f2230cd8bfdaba03d2318dd257bec211, data reload: false query1 1415110210721072 query2 6225182117961796 query3 11140 457545924575 query4 52549 24640 22996 22996 query5 5208587 456 456 query6 363 210 196 196 query7 4898509 283 283 query8 323 250 250 250 query9 5525259025792579 query10 438 352 270 270 query11 15051 15114 14937 14937 query12 162 117 107 107 query13 1035512 408 408 query14 10243 660766436607 query15 209 190 178 178 query16 7016649 527 527 query17 1072763 605 605 query18 1546396 308 308 query19 193 207 166 166 query20 132 128 124 124 query21 206 122 109 109 query22 4465443342234223 query23 34191 33647 33569 33569 query24 6613243024132413 query25 461 460 398 398 query26 677 272 165 165 query27 2214518 341 341 query28 3094216221502150 query29 596 574 437 437 query30 274 213 194 194 query31 865 894 765 765 query32 71 64 67 64 query33 470 356 312 312 query34 775 855 534 534 query35 794 825 737 737 query36 950 990 898 898 query37 125 101 87 87 query38 4220426742974267 query39 1514147814191419 query40 212 118 107 107 query41 56 57 57 57 query42 126 109 113 109 query43 507 511 478 478 query44 1339818 844 818 query45 191 174 179 174 query46 861 1019638 638 query47 1849185518291829 query48 385 418 299 299 query49 680 485 438 438 query50 662 698 425 425 query51 4199427242744272 query52 112 110 100 100 query53 226 261 189 189 query54 578 574 558 558 query55 82 81 82 81 query56 308 305 307 305 query57 1177119611491149 query58 267 260 265 260 query59 2677280827592759 query60 332 324 308 308 query61 130 127 125 125 query62 737 735 687 687 query63 234 189 192 189 query64 17181068815 815 query65 4450425442684254 query66 745 421 319 319 query67 15728 15435 15095 15095 query68 6775877 525 525 query69 567 313 264 264 query70 1201112010891089 query71 459 322 306 306 query72 5915482949924829 query73 1303705 345 345 query74 8997885190618851 query75 3630318927262726 query76 40371193783 783 query77 651 383 286 286 query78 10189 10060 92619261 query79 2438796 572 572 query80 767 507 443 443 query81 492 255 224 224 query82 454 125 98 98 query83 261 250 234 234 query84 293 103 82 82 query85 777 350 314 314 query86 367 313 281 281 query87 4420437144114371 query88 3373221122342211 query89 399 302 276 276 query90 1751214 227 214 query91 138 139 110 110 query92 75 61 55 55 query93 1949909 578 578 query94 711 417 296 296 query95 367 296 283 283 query96 493 579 283 283 query97 3138324331523152 query98 229 208 214 208 query99 1412140512891289 Total cold run time: 295914 ms Total hot run time: 193198 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2826121721 TPC-H: Total hot run time: 33938 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1ecf4355f2230cd8bfdaba03d2318dd257bec211, data reload: false -- Round 1 -- q1 25833 529950305030 q2 2082270 176 176 q3 10425 1231674 674 q4 10244 984 556 556 q5 7528242823322332 q6 180 164 133 133 q7 918 742 613 613 q8 9411125710531053 q9 6863515551825155 q10 6849231219131913 q11 474 281 261 261 q12 351 354 236 236 q13 18065 369130933093 q14 238 221 206 206 q15 536 498 502 498 q16 453 449 407 407 q17 568 852 348 348 q18 7527719371457145 q19 1459964 540 540 q20 327 328 224 224 q21 3846339523712371 q22 10841059974 974 Total cold run time: 115261 ms Total hot run time: 33938 ms - Round 2, with runtime_filter_mode=off - q1 5136508651705086 q2 259 333 240 240 q3 2279281924432443 q4 1614187515181518 q5 4624475646704670 q6 225 169 138 138 q7 2146205118241824 q8 2680254225862542 q9 7390718872127188 q10 2895320227412741 q11 574 491 499 491 q12 694 742 620 620 q13 3525392033683368 q14 270 282 272 272 q15 533 484 466 466 q16 460 513 461 461 q17 1125156813791379 q18 7740745974107410 q19 788 775 776 775 q20 1963201318771877 q21 5317467148974671 q22 1063106210411041 Total cold run time: 53300 ms Total hot run time: 51221 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2825966717 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2824442178 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2823310597 ClickBench: Total hot run time: 30.22 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 58311fff7a5dd95daecbfe146289c31738ca2489, data reload: false query1 0.040.030.03 query2 0.130.100.12 query3 0.250.190.19 query4 1.590.190.19 query5 0.590.590.59 query6 1.180.720.72 query7 0.020.020.02 query8 0.040.030.03 query9 0.570.520.51 query10 0.570.580.57 query11 0.160.100.11 query12 0.150.110.11 query13 0.600.600.61 query14 1.181.191.17 query15 0.870.850.85 query16 0.400.400.38 query17 1.021.051.05 query18 0.210.190.19 query19 1.881.811.80 query20 0.010.010.01 query21 15.43 0.900.55 query22 0.781.160.87 query23 14.69 1.390.62 query24 6.941.011.01 query25 0.500.220.23 query26 0.590.160.13 query27 0.050.050.05 query28 9.340.840.45 query29 12.53 4.033.36 query30 0.260.100.07 query31 2.820.600.39 query32 3.220.540.46 query33 3.013.053.09 query34 15.87 5.084.49 query35 4.474.484.54 query36 0.670.490.49 query37 0.080.060.06 query38 0.050.050.03 query39 0.020.020.02 query40 0.170.140.13 query41 0.080.030.03 query42 0.030.020.02 query43 0.040.030.03 Total cold run time: 103.1 s Total hot run time: 30.22 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2823299806 TPC-DS: Total hot run time: 192239 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 58311fff7a5dd95daecbfe146289c31738ca2489, data reload: false query1 1449109310601060 query2 6174186618711866 query3 11007 450944804480 query4 54415 25992 23079 23079 query5 5012586 460 460 query6 338 215 194 194 query7 4875497 271 271 query8 307 239 227 227 query9 5375258125842581 query10 424 310 256 256 query11 15134 15092 15207 15092 query12 158 115 109 109 query13 1034530 398 398 query14 10274 664764096409 query15 206 205 178 178 query16 7138683 512 512 query17 1090749 604 604 query18 1612426 331 331 query19 201 201 164 164 query20 128 132 124 124 query21 207 127 108 108 query22 4325447143574357 query23 34093 33428 33268 33268 query24 6580245024082408 query25 456 476 445 445 query26 788 274 145 145 query27 2389514 335 335 query28 2989216321342134 query29 574 578 424 424 query30 263 220 183 183 query31 868 873 783 783 query32 77 64 64 64 query33 471 367 341 341 query34 785 877 514 514 query35 807 834 747 747 query36 949 1000924 924 query37 109 96 73 73 query38 4160432941934193 query39 1475144014621440 query40 222 121 128 121 query41 53 50 54 50 query42 119 107 113 107 query43 499 537 489 489 query44 1355829 828 828 query45 180 175 175 175 query46 841 1031647 647 query47 1823185517751775 query48 377 429 304 304 query49 699 519 401 401 query50 651 698 401 401 query51 4184422641044104 query52 105 110 98 98 query53 225 250 195 195 query54 603 578 537 537 query55 78 83 81 81 query56 319 303 279 279 query57 1145123711321132 query58 265 254 253 253 query59 2680288927102710 query60 332 323 294 294 query61 129 134 126 126 query62 783 748 656 656 query63 226 193 189 189 query64 20631079702 702 query65 4406418441874184 query66 725 406 308 308 query67 15836 15483 15351 15351 query68 6858879 503 503 query69 534 366 263 263 query70 1261112410971097 query71 511 316 274 274 query72 5576466448044664 query73 1429553 334 334 query74 9104924289128912 query75 3971323826582658 query76 42671222759 759 query77 679 392 277 277 query78 9882998691919191 query79 2367840 575 575 query80 606 581 443 443 query81 489 250 220 220 query82 413 127 103 103 query83 333 262 232 232 query84 297 108 83 83 query85 806 351 319 319 query86 340 285 270 270 query87 4423438243454345 query88 306122182218 query89 390 310 286 286 query90 1990215 216 215 query91 139 140 113 113 query92 76 58 55 55 query93 1156905 567 567 query94 680 424 307 307 query95 368 303 283 283 query96 490 567 276 276 query97 3146323531493149 query98 224 203 200 200 query99 1445141212701270 Total cold run time: 296950 ms Total hot run time: 192239 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2823279093 TPC-H: Total hot run time: 34541 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 58311fff7a5dd95daecbfe146289c31738ca2489, data reload: false -- Round 1 -- q1 26187 546951035103 q2 2100299 192 192 q3 10360 1229708 708 q4 10366 1018577 577 q5 8668239623382338 q6 187 161 132 132 q7 919 751 620 620 q8 9325127410891089 q9 7418510151625101 q10 6816231919691969 q11 500 290 299 290 q12 361 357 239 239 q13 18958 400434243424 q14 232 232 217 217 q15 654 497 502 497 q16 483 459 415 415 q17 806 850 371 371 q18 9138720671347134 q19 2192950 538 538 q20 325 322 216 216 q21 4030339524192419 q22 1045987 952 952 Total cold run time: 121070 ms Total hot run time: 34541 ms - Round 2, with runtime_filter_mode=off - q1 5126508350865083 q2 233 327 235 235 q3 2137263824812481 q4 1607192514741474 q5 4601450044294429 q6 218 167 126 126 q7 2024193217881788 q8 2640260125502550 q9 7175727371197119 q10 2946321727242724 q11 570 500 479 479 q12 681 763 590 590 q13 3535394633453345 q14 287 302 273 273 q15 513 479 471 471 q16 465 510 465 465 q17 1134146613901390 q18 7711748672937293 q19 845 765 853 765 q20 1941203019351935 q21 5201512647684768 q22 11151017985 985 Total cold run time: 52705 ms Total hot run time: 50768 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2823206300 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2820694308 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
morrySnow commented on code in PR #49297:
URL: https://github.com/apache/doris/pull/49297#discussion_r2053682940
##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/CreateMaterializedViewCommand.java:
##
@@ -199,22 +198,10 @@ private Pair
analyzeAndRewriteLogicalPlan(LogicalP
ConnectContext ctx) {
StatementContext statementContext = ctx.getStatementContext();
NereidsPlanner planner = new NereidsPlanner(statementContext);
Review Comment:
this function name should be changed to `analyzeLogicalPlan`
--
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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
morrySnow commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2820657758 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2804032250 ClickBench: Total hot run time: 31.6 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 42a3c844ce65c20ec82519ddbd76c193b9bbf1f2, data reload: false query1 0.040.040.03 query2 0.130.100.11 query3 0.240.200.20 query4 1.600.190.19 query5 0.610.590.60 query6 1.190.720.71 query7 0.020.010.02 query8 0.030.030.03 query9 0.570.540.51 query10 0.560.570.56 query11 0.160.100.11 query12 0.140.110.11 query13 0.610.590.60 query14 2.662.802.74 query15 0.920.840.84 query16 0.380.380.40 query17 1.041.061.05 query18 0.220.210.20 query19 1.862.051.80 query20 0.010.010.01 query21 15.36 0.930.53 query22 0.751.190.59 query23 15.04 1.420.63 query24 7.351.471.30 query25 0.610.330.16 query26 0.590.160.15 query27 0.050.060.05 query28 10.64 0.880.43 query29 12.62 3.933.23 query30 0.250.100.07 query31 2.820.610.40 query32 3.230.540.46 query33 3.043.023.04 query34 15.79 5.154.52 query35 4.534.514.54 query36 0.660.490.48 query37 0.090.060.07 query38 0.050.040.04 query39 0.030.020.03 query40 0.170.150.13 query41 0.080.020.02 query42 0.040.030.02 query43 0.040.030.03 Total cold run time: 106.82 s Total hot run time: 31.6 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2804019627 TPC-DS: Total hot run time: 193441 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 42a3c844ce65c20ec82519ddbd76c193b9bbf1f2, data reload: false query1 1408109210631063 query2 6232190819031903 query3 11124 468146174617 query4 25204 23531 23532 23531 query5 4852645 480 480 query6 305 199 202 199 query7 4008497 275 275 query8 294 259 238 238 query9 8559260625982598 query10 484 328 270 270 query11 15594 15249 14809 14809 query12 174 110 112 110 query13 1589539 410 410 query14 9649634862606260 query15 203 193 175 175 query16 7617640 498 498 query17 1181789 661 661 query18 2033426 344 344 query19 205 195 170 170 query20 131 134 120 120 query21 220 131 116 116 query22 4426437942494249 query23 34586 33704 33519 33519 query24 8565246423922392 query25 516 469 398 398 query26 1168278 157 157 query27 2758501 338 338 query28 4731246824272427 query29 732 568 450 450 query30 271 214 192 192 query31 890 868 796 796 query32 76 65 65 65 query33 556 384 306 306 query34 799 902 544 544 query35 832 868 776 776 query36 980 1026924 924 query37 131 103 78 78 query38 4263428641054105 query39 1496146514231423 query40 235 121 108 108 query41 53 52 52 52 query42 121 104 115 104 query43 515 514 493 493 query44 1352846 836 836 query45 191 177 171 171 query46 866 1029635 635 query47 1830186317651765 query48 377 422 317 317 query49 779 511 457 457 query50 656 701 413 413 query51 4302434641734173 query52 114 109 99 99 query53 234 281 188 188 query54 590 590 527 527 query55 81 87 86 86 query56 313 299 301 299 query57 1172121611261126 query58 271 263 282 263 query59 2684278427302730 query60 338 340 302 302 query61 131 127 134 127 query62 767 730 653 653 query63 239 194 187 187 query64 39811076719 719 query65 4431434244094342 query66 984 408 314 314 query67 16295 15521 15415 15415 query68 8499926 516 516 query69 484 306 260 260 query70 1210110611431106 query71 486 317 292 292 query72 5364473546454645 query73 713 554 349 349 query74 9346891687588758 query75 3969321326692669 query76 37851199755 755 query77 797 401 283 283 query78 10046 10413 93199319 query79 2051878 582 582 query80 756 530 466 466 query81 464 278 224 224 query82 433 135 102 102 query83 275 253 234 234 query84 293 107 80 80 query85 789 371 325 325 query86 330 315 283 283 query87 4561442643914391 query88 3435220322152203 query89 391 323 280 280 query90 1971213 212 212 query91 146 154 112 112 query92 84 59 57 57 query93 1404967 578 578 query94 660 414 294 294 query95 374 297 295 295 query96 514 573 275 275 query97 3188326130973097 query98 230 211 205 205 query99 1434143113071307 Total cold run time: 281226 ms Total hot run time: 193441 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2803992061 TPC-H: Total hot run time: 34149 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 42a3c844ce65c20ec82519ddbd76c193b9bbf1f2, data reload: false -- Round 1 -- q1 25771 502150815021 q2 2066283 194 194 q3 10376 1220677 677 q4 10228 1086534 534 q5 7537232523272325 q6 192 165 135 135 q7 905 777 625 625 q8 9324123811291129 q9 6918513050775077 q10 6873230618941894 q11 482 289 280 280 q12 359 361 218 218 q13 17780 371331353135 q14 219 221 217 217 q15 538 508 493 493 q16 618 612 592 592 q17 604 836 367 367 q18 7391707070037003 q19 1309948 558 558 q20 333 340 221 221 q21 4227269024692469 q22 11401058985 985 Total cold run time: 115190 ms Total hot run time: 34149 ms - Round 2, with runtime_filter_mode=off - q1 5211513851705138 q2 250 324 232 232 q3 2268290524402440 q4 1488184614441444 q5 4515453544434443 q6 218 167 126 126 q7 2070196417981798 q8 2586268525972597 q9 7198716071257125 q10 3057321228062806 q11 578 511 504 504 q12 702 777 648 648 q13 3652392633773377 q14 305 298 277 277 q15 523 497 461 461 q16 655 706 653 653 q17 1168152913931393 q18 7707756874237423 q19 839 845 887 845 q20 1934201518301830 q21 5314482849684828 q22 1066105210321032 Total cold run time: 53304 ms Total hot run time: 51420 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2803916614 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
morrySnow commented on code in PR #49297:
URL: https://github.com/apache/doris/pull/49297#discussion_r2043494676
##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/CreateMaterializedViewCommand.java:
##
@@ -199,22 +198,12 @@ private Pair
analyzeAndRewriteLogicalPlan(LogicalP
ConnectContext ctx) {
StatementContext statementContext = ctx.getStatementContext();
NereidsPlanner planner = new NereidsPlanner(statementContext);
-Set tempDisableRules =
ctx.getSessionVariable().getDisableNereidsRuleNames();
-
ctx.getSessionVariable().setDisableNereidsRules(SYNC_MV_PLANER_DISABLE_RULES);
-
ctx.getStatementContext().invalidCache(SessionVariable.DISABLE_NEREIDS_RULES);
-LogicalPlan plan;
-try {
-// disable rbo sync mv rewrite
-
ctx.getSessionVariable().setVarOnce(SessionVariable.ENABLE_SYNC_MV_COST_BASED_REWRITE,
"true");
-// disable constant fold
-
ctx.getSessionVariable().setVarOnce(SessionVariable.DEBUG_SKIP_FOLD_CONSTANT,
"true");
-plan = (LogicalPlan) planner.planWithLock(unboundPlan,
PhysicalProperties.ANY,
-ExplainCommand.ExplainLevel.REWRITTEN_PLAN);
-} finally {
-// after operate, roll back the disable rules
-ctx.getSessionVariable().setDisableNereidsRules(String.join(",",
tempDisableRules));
-
ctx.getStatementContext().invalidCache(SessionVariable.DISABLE_NEREIDS_RULES);
-}
+// disable rbo sync mv rewrite
+
ctx.getSessionVariable().setVarOnce(SessionVariable.ENABLE_SYNC_MV_COST_BASED_REWRITE,
"true");
Review Comment:
comment is disable, but variable is true?
--
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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2796526345 ClickBench: Total hot run time: 31.49 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit bea6b5d1ce18ebb246b56849b33512b741ed7299, data reload: false query1 0.040.030.03 query2 0.130.100.11 query3 0.250.190.19 query4 1.590.190.19 query5 0.590.580.58 query6 1.190.710.73 query7 0.020.020.01 query8 0.040.040.03 query9 0.570.550.52 query10 0.590.580.57 query11 0.160.110.11 query12 0.140.110.12 query13 0.620.610.60 query14 2.682.732.69 query15 0.920.860.86 query16 0.390.380.43 query17 1.101.071.04 query18 0.210.200.20 query19 1.881.931.85 query20 0.010.020.01 query21 15.38 0.920.56 query22 0.761.220.67 query23 14.91 1.390.61 query24 7.461.581.07 query25 0.490.250.10 query26 0.660.170.14 query27 0.050.050.05 query28 9.260.810.43 query29 12.56 4.023.33 query30 0.260.090.06 query31 2.820.610.39 query32 3.220.550.47 query33 3.013.123.02 query34 15.72 5.094.51 query35 4.514.514.48 query36 0.670.500.50 query37 0.090.060.06 query38 0.050.040.04 query39 0.030.030.02 query40 0.170.140.13 query41 0.080.020.02 query42 0.040.030.02 query43 0.030.040.03 Total cold run time: 105.35 s Total hot run time: 31.49 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2796515477 TPC-DS: Total hot run time: 192931 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 bea6b5d1ce18ebb246b56849b33512b741ed7299, data reload: false query1 1447106210331033 query2 6206184819041848 query3 10991 460346364603 query4 53229 24497 23664 23664 query5 5206491 436 436 query6 318 193 208 193 query7 4901502 292 292 query8 343 253 246 246 query9 5904260425932593 query10 421 324 286 286 query11 15040 14963 14816 14816 query12 165 113 105 105 query13 1052528 396 396 query14 10032 626163656261 query15 213 194 184 184 query16 7028661 535 535 query17 1088747 590 590 query18 1563414 326 326 query19 198 201 165 165 query20 127 123 125 123 query21 215 128 114 114 query22 4429456642214221 query23 34201 33377 33580 33377 query24 6674245224362436 query25 469 499 418 418 query26 799 280 157 157 query27 2448493 332 332 query28 3513246424302430 query29 582 565 452 452 query30 269 220 191 191 query31 872 874 760 760 query32 69 59 67 59 query33 450 361 310 310 query34 789 858 537 537 query35 827 837 777 777 query36 932 997 912 912 query37 128 103 74 74 query38 4265429843244298 query39 1506142514341425 query40 220 120 105 105 query41 53 55 49 49 query42 124 110 106 106 query43 493 506 484 484 query44 1309836 838 836 query45 185 170 169 169 query46 880 1022647 647 query47 1848186917981798 query48 380 416 308 308 query49 693 516 441 441 query50 660 698 401 401 query51 4252428241844184 query52 115 116 94 94 query53 234 258 177 177 query54 577 560 520 520 query55 81 86 88 86 query56 308 300 289 289 query57 1239119910931093 query58 262 259 251 251 query59 2745265726852657 query60 343 339 297 297 query61 132 128 143 128 query62 739 752 683 683 query63 231 192 198 192 query64 21501023678 678 query65 4325422742014201 query66 762 409 299 299 query67 16201 15412 15340 15340 query68 7212877 515 515 query69 559 303 266 266 query70 1183102910951029 query71 511 327 306 306 query72 5734486548454845 query73 1182658 340 340 query74 8982903386588658 query75 3851320226962696 query76 41551186760 760 query77 636 359 282 282 query78 10070 10044 92419241 query79 2015826 562 562 query80 587 506 432 432 query81 499 269 228 228 query82 486 127 93 93 query83 248 252 236 236 query84 297 114 89 89 query85 793 363 324 324 query86 397 302 284 284 query87 4493443743554355 query88 3783224622382238 query89 407 312 274 274 query90 1837211 212 211 query91 148 156 111 111 query92 70 65 55 55 query93 1709945 569 569 query94 660 405 291 291 query95 367 287 292 287 query96 480 560 271 271 query97 3178321431083108 query98 223 211 207 207 query99 1441142712801280 Total cold run time: 298643 ms Total hot run time: 192931 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 t
Re: [PR] [fix](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2796483204 TPC-H: Total hot run time: 34070 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit bea6b5d1ce18ebb246b56849b33512b741ed7299, data reload: false -- Round 1 -- q1 26011 521151265126 q2 2074272 182 182 q3 10409 1238727 727 q4 10226 992 519 519 q5 7533234522782278 q6 183 158 129 129 q7 918 746 620 620 q8 9307127311141114 q9 6860509750515051 q10 6809229418661866 q11 469 279 258 258 q12 348 353 220 220 q13 17746 364930473047 q14 231 229 218 218 q15 537 499 489 489 q16 624 609 595 595 q17 573 843 359 359 q18 7589713772517137 q19 1233930 548 548 q20 330 323 228 228 q21 3904336424172417 q22 1034994 942 942 Total cold run time: 114948 ms Total hot run time: 34070 ms - Round 2, with runtime_filter_mode=off - q1 5137511050845084 q2 239 326 239 239 q3 2142264523082308 q4 1437180514531453 q5 4455436544084365 q6 218 164 126 126 q7 1988189817491749 q8 2612252624912491 q9 7183722271057105 q10 2954313427262726 q11 575 504 481 481 q12 670 759 640 640 q13 3481385733953395 q14 293 307 270 270 q15 517 484 477 477 q16 652 681 641 641 q17 1138157213811381 q18 7703767974397439 q19 789 787 841 787 q20 1984193718101810 q21 5259479548204795 q22 11211112988 988 Total cold run time: 52547 ms Total hot run time: 50750 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2796362198 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on code in PR #49297:
URL: https://github.com/apache/doris/pull/49297#discussion_r2038929182
##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/CreateMaterializedViewCommand.java:
##
@@ -331,6 +328,9 @@ public Plan visitLogicalAggregate(LogicalAggregate aggregate, Va
int groupByExprCount = aggregate.getGroupByExpressions().size();
context.groupByExprs = Maps.newHashMap();
for (int i = 0; i < groupByExprCount; ++i) {
+if (outputs.get(i).getDataType().isOnlyMetricType()) {
+throw new AnalysisException(Type.OnlyMetricTypeErrorMsg);
+}
Review Comment:
these isOnlyMetricType are borrowed from CheckAfterRewrite rule. There are
regression cases for group by and order by
--
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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
morrySnow commented on code in PR #49297:
URL: https://github.com/apache/doris/pull/49297#discussion_r2038895408
##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/CreateMaterializedViewCommand.java:
##
@@ -331,6 +328,9 @@ public Plan visitLogicalAggregate(LogicalAggregate aggregate, Va
int groupByExprCount = aggregate.getGroupByExpressions().size();
context.groupByExprs = Maps.newHashMap();
for (int i = 0; i < groupByExprCount; ++i) {
+if (outputs.get(i).getDataType().isOnlyMetricType()) {
+throw new AnalysisException(Type.OnlyMetricTypeErrorMsg);
+}
Review Comment:
do we need more case about this and below check?
--
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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2785560092 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2785652900 ClickBench: Total hot run time: 30.97 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit e4bce475298cb9716782c17e5e65b8576a813c50, data reload: false query1 0.050.050.04 query2 0.120.100.10 query3 0.260.200.18 query4 1.590.200.20 query5 0.580.560.57 query6 1.170.720.71 query7 0.030.020.02 query8 0.050.040.04 query9 0.580.520.53 query10 0.590.580.58 query11 0.160.110.10 query12 0.140.120.11 query13 0.620.600.59 query14 2.782.822.86 query15 0.930.850.84 query16 0.390.380.38 query17 1.031.001.01 query18 0.220.200.20 query19 1.901.941.82 query20 0.010.010.01 query21 15.36 0.900.53 query22 0.741.110.71 query23 14.97 1.420.58 query24 6.631.700.72 query25 0.480.190.06 query26 0.620.160.13 query27 0.050.050.04 query28 9.450.870.43 query29 12.63 3.913.28 query30 0.250.090.05 query31 2.830.590.39 query32 3.230.540.46 query33 2.982.993.05 query34 15.85 5.144.50 query35 4.494.494.47 query36 0.660.500.49 query37 0.090.070.06 query38 0.050.030.03 query39 0.040.020.03 query40 0.170.140.13 query41 0.070.030.03 query42 0.030.030.02 query43 0.040.030.03 Total cold run time: 104.91 s Total hot run time: 30.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] [fix](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2786621674 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2786801738 ClickBench: Total hot run time: 31.54 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit f51a494224b24bc35daf5c8d9942e1bdd7a0dc6d, data reload: false query1 0.040.040.03 query2 0.120.100.11 query3 0.250.190.19 query4 1.590.190.19 query5 0.560.540.55 query6 1.210.730.73 query7 0.030.020.02 query8 0.030.040.04 query9 0.590.520.51 query10 0.580.580.56 query11 0.170.110.11 query12 0.150.110.11 query13 0.620.610.60 query14 2.622.802.75 query15 0.970.850.84 query16 0.390.390.37 query17 1.061.041.04 query18 0.210.200.20 query19 2.091.851.79 query20 0.010.010.01 query21 15.35 0.920.54 query22 0.751.270.78 query23 14.74 1.410.63 query24 7.341.171.39 query25 0.520.180.07 query26 0.560.170.15 query27 0.060.050.05 query28 9.810.880.42 query29 12.56 4.003.26 query30 0.250.090.06 query31 2.810.590.39 query32 3.250.550.46 query33 3.073.113.10 query34 15.84 5.054.50 query35 4.494.484.44 query36 0.670.500.49 query37 0.090.060.06 query38 0.060.040.04 query39 0.030.020.02 query40 0.170.120.12 query41 0.080.030.02 query42 0.030.020.02 query43 0.030.030.02 Total cold run time: 105.85 s Total hot run time: 31.54 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2786781879 TPC-DS: Total hot run time: 193295 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 f51a494224b24bc35daf5c8d9942e1bdd7a0dc6d, data reload: false query1 1380109010781078 query2 6415195119581951 query3 10987 442846174428 query4 54515 25131 23423 23423 query5 5065524 472 472 query6 362 210 197 197 query7 4988502 285 285 query8 324 246 244 244 query9 6148259126112591 query10 431 342 281 281 query11 15103 15040 14864 14864 query12 167 112 110 110 query13 1119525 405 405 query14 10290 630065376300 query15 207 189 173 173 query16 7026660 461 461 query17 1081759 595 595 query18 1583407 312 312 query19 200 196 158 158 query20 129 119 119 119 query21 215 125 107 107 query22 4342453342174217 query23 34141 33559 33220 33220 query24 6703245323942394 query25 471 485 409 409 query26 691 270 164 164 query27 2421495 348 348 query28 3349244324472443 query29 592 586 451 451 query30 284 227 227 227 query31 882 900 791 791 query32 72 66 64 64 query33 455 376 319 319 query34 780 847 513 513 query35 820 843 770 770 query36 985 1007908 908 query37 124 99 75 75 query38 4230422443474224 query39 1486147514531453 query40 231 125 124 124 query41 54 53 55 53 query42 127 108 114 108 query43 499 529 493 493 query44 1388809 840 809 query45 184 173 174 173 query46 857 1038652 652 query47 1859188218131813 query48 393 452 322 322 query49 717 561 483 483 query50 697 724 426 426 query51 4222433842614261 query52 106 111 110 110 query53 237 267 194 194 query54 590 582 540 540 query55 91 85 92 85 query56 345 326 320 320 query57 1183119311301130 query58 279 280 280 280 query59 2787294627882788 query60 341 329 325 325 query61 129 131 142 131 query62 732 734 719 719 query63 279 197 193 193 query64 14911077734 734 query65 4442436143444344 query66 792 401 300 300 query67 15834 15301 15267 15267 query68 7813877 502 502 query69 539 307 267 267 query70 1198116811331133 query71 504 307 289 289 query72 5583477948644779 query73 1362647 346 346 query74 8884893587058705 query75 4155322427032703 query76 44421318776 776 query77 648 381 295 295 query78 991610157 92369236 query79 2246805 573 573 query80 629 517 448 448 query81 493 258 225 225 query82 446 127 95 95 query83 360 256 235 235 query84 292 106 87 87 query85 889 359 322 322 query86 366 325 289 289 query87 4347456843144314 query88 3162222122332221 query89 407 313 282 282 query90 1950215 218 215 query91 145 147 112 112 query92 77 65 57 57 query93 1232939 580 580 query94 678 414 303 303 query95 373 303 295 295 query96 488 562 276 276 query97 3228332431223122 query98 229 208 210 208 query99 1451140312841284 Total cold run time: 299981 ms Total hot run time: 193295 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2786743839 TPC-H: Total hot run time: 34124 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit f51a494224b24bc35daf5c8d9942e1bdd7a0dc6d, data reload: false -- Round 1 -- q1 25921 509950255025 q2 2074281 183 183 q3 10402 1235666 666 q4 10221 1013535 535 q5 7537236023022302 q6 191 165 134 134 q7 909 750 617 617 q8 9330127810861086 q9 6866510750505050 q10 6853230718731873 q11 484 283 279 279 q12 343 352 224 224 q13 17774 364130783078 q14 216 229 201 201 q15 520 468 486 468 q16 624 605 586 586 q17 616 852 381 381 q18 7507718271967182 q19 1234959 568 568 q20 355 338 238 238 q21 4323333224702470 q22 10661030978 978 Total cold run time: 115366 ms Total hot run time: 34124 ms - Round 2, with runtime_filter_mode=off - q1 5204510551305105 q2 242 326 233 233 q3 2187264822982298 q4 1408180614121412 q5 4472439343984393 q6 212 169 129 129 q7 2014192417681768 q8 2593268525972597 q9 7234719270897089 q10 2995323327282728 q11 584 518 491 491 q12 658 783 623 623 q13 3495389032823282 q14 308 312 272 272 q15 516 488 476 476 q16 644 706 638 638 q17 1158156113751375 q18 7727752273817381 q19 807 835 940 835 q20 1953198918291829 q21 5252487447054705 q22 1105105410301030 Total cold run time: 52768 ms Total hot run time: 50689 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2785638436 TPC-DS: Total hot run time: 186243 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 e4bce475298cb9716782c17e5e65b8576a813c50, data reload: false query1 996 457 487 457 query2 6560197119401940 query3 6739219 221 219 query4 26833 23200 23423 23200 query5 4344620 478 478 query6 315 227 194 194 query7 4620486 292 292 query8 302 265 251 251 query9 8632249625142496 query10 500 308 256 256 query11 15188 15017 14887 14887 query12 162 114 110 110 query13 1641504 385 385 query14 8755609860516051 query15 238 177 168 168 query16 7111606 484 484 query17 939 742 591 591 query18 1982391 301 301 query19 186 179 149 149 query20 117 112 116 112 query21 211 123 101 101 query22 4430425640024002 query23 33729 32839 32992 32839 query24 8404238923762376 query25 543 454 393 393 query26 1232271 147 147 query27 2757493 327 327 query28 4383237123822371 query29 736 547 416 416 query30 292 214 199 199 query31 931 862 748 748 query32 75 66 64 64 query33 580 373 299 299 query34 794 845 509 509 query35 788 806 753 753 query36 935 938 886 886 query37 116 100 125 100 query38 4073405940654059 query39 1438155413941394 query40 216 119 104 104 query41 56 60 51 51 query42 127 106 100 100 query43 508 485 474 474 query44 1280768 764 764 query45 182 171 168 168 query46 836 1012614 614 query47 1762180717221722 query48 369 393 287 287 query49 789 503 408 408 query50 645 673 398 398 query51 4128412541874125 query52 112 110 108 108 query53 216 257 187 187 query54 584 570 507 507 query55 85 78 80 78 query56 311 310 295 295 query57 11361157 query58 258 248 255 248 query59 2841275927742759 query60 328 314 291 291 query61 132 131 124 124 query62 771 759 642 642 query63 214 178 195 178 query64 43201055809 809 query65 4355427043354270 query66 1150442 326 326 query67 15697 15442 15412 15412 query68 7557866 507 507 query69 478 302 270 270 query70 1180106510791065 query71 414 323 293 293 query72 5586475748104757 query73 651 635 347 347 query74 8936925190219021 query75 3371324227072707 query76 32881182738 738 query77 692 382 280 280 query78 993510176 92389238 query79 2055868 562 562 query80 616 509 445 445 query81 486 251 215 215 query82 347 129 95 95 query83 255 248 234 234 query84 295 104 83 83 query85 840 351 318 318 query86 359 310 295 295 query87 4409455143054305 query88 3739223822522238 query89 382 315 277 277 query90 1911209 223 209 query91 151 145 110 110 query92 76 66 53 53 query93 1708954 577 577 query94 667 388 301 301 query95 383 297 284 284 query96 487 562 279 279 query97 3166324331023102 query98 234 204 203 203 query99 1341140612711271 Total cold run time: 272010 ms Total hot run time: 186243 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 t
Re: [PR] [fix](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2785608134 TPC-H: Total hot run time: 34229 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit e4bce475298cb9716782c17e5e65b8576a813c50, data reload: false -- Round 1 -- q1 26103 499750954997 q2 2069295 190 190 q3 10365 1226702 702 q4 10224 983 532 532 q5 7549231223932312 q6 190 165 131 131 q7 903 739 617 617 q8 9304130010591059 q9 6981511851315118 q10 6820230818721872 q11 486 297 268 268 q12 351 358 221 221 q13 17749 372431123112 q14 226 221 212 212 q15 541 483 474 474 q16 636 630 575 575 q17 595 874 369 369 q18 7568739372177217 q19 1229936 581 581 q20 340 353 241 241 q21 3990273524482448 q22 10391009981 981 Total cold run time: 115258 ms Total hot run time: 34229 ms - Round 2, with runtime_filter_mode=off - q1 5107505250365036 q2 228 326 229 229 q3 2179267122812281 q4 1405182213801380 q5 4576447743694369 q6 208 167 127 127 q7 1997189017571757 q8 2583263225712571 q9 7188709371067093 q10 2996320227172717 q11 589 506 484 484 q12 691 758 599 599 q13 3512393133023302 q14 284 304 261 261 q15 511 474 460 460 q16 633 707 656 656 q17 1149156813961396 q18 7694754874717471 q19 813 823 868 823 q20 2000200117991799 q21 5123478645874587 q22 10601029971 971 Total cold run time: 52526 ms Total hot run time: 50369 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2739136121 TPC-DS: Total hot run time: 192015 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 c92f0b5105d0257de1b11f07a7af966011a3b1ca, data reload: false query1 1450108410901084 query2 6167196119111911 query3 11140 476046404640 query4 27622 2 23008 23008 query5 4845655 471 471 query6 287 191 168 168 query7 3981505 292 292 query8 281 232 228 228 query9 8524258625842584 query10 486 313 261 261 query11 16173 15149 14763 14763 query12 157 111 108 108 query13 1718529 397 397 query14 10057 629467606294 query15 212 186 183 183 query16 7617650 453 453 query17 1492757 597 597 query18 2039405 312 312 query19 192 191 175 175 query20 122 141 131 131 query21 201 118 106 106 query22 4597453645644536 query23 34218 33619 33364 33364 query24 7112244924342434 query25 510 480 384 384 query26 1204271 159 159 query27 2518464 372 372 query28 4680244124242424 query29 705 554 449 449 query30 280 233 201 201 query31 906 861 769 769 query32 70 64 61 61 query33 510 350 301 301 query34 817 874 516 516 query35 824 847 759 759 query36 996 1012903 903 query37 117 95 72 72 query38 4394425743464257 query39 1470144414531444 query40 210 112 103 103 query41 55 51 50 50 query42 124 102 104 102 query43 519 526 477 477 query44 1402822 819 819 query45 188 175 172 172 query46 849 1042646 646 query47 1825190218121812 query48 417 453 302 302 query49 793 510 445 445 query50 714 744 422 422 query51 4256432543074307 query52 114 107 93 93 query53 226 252 191 191 query54 490 502 408 408 query55 84 83 81 81 query56 271 251 257 251 query57 11291211 query58 243 241 237 237 query59 2725283728172817 query60 278 292 271 271 query61 118 124 143 124 query62 772 750 668 668 query63 231 197 198 197 query64 40891103779 779 query65 46034625 query66 972 396 302 302 query67 16165 15433 15601 15433 query68 8529887 502 502 query69 475 288 255 255 query70 1218110611081106 query71 491 292 256 256 query72 5760355437693554 query73 788 732 338 338 query74 9061922887608760 query75 3825315626972697 query76 37311181729 729 query77 791 365 273 273 query78 10087 10050 93739373 query79 3269832 587 587 query80 734 518 448 448 query81 512 253 214 214 query82 772 125 99 99 query83 167 165 151 151 query84 246 98 86 86 query85 765 347 296 296 query86 372 308 276 276 query87 4461450442984298 query88 3586227022742270 query89 414 315 280 280 query90 1834217 232 217 query91 140 135 110 110 query92 77 59 54 54 query93 22421055578 578 query94 665 399 295 295 query95 359 290 256 256 query96 485 572 278 278 query97 3339336632823282 query98 221 205 228 205 query99 1421140212571257 Total cold run time: 285390 ms Total hot run time: 192015 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 t
Re: [PR] [fix](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2739142664 ClickBench: Total hot run time: 31.07 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit c92f0b5105d0257de1b11f07a7af966011a3b1ca, data reload: false query1 0.040.040.02 query2 0.120.100.11 query3 0.250.200.19 query4 1.590.180.20 query5 0.580.580.59 query6 1.210.720.71 query7 0.030.020.02 query8 0.050.040.04 query9 0.580.510.52 query10 0.590.580.57 query11 0.150.100.11 query12 0.140.110.12 query13 0.600.610.61 query14 2.702.662.73 query15 0.920.850.85 query16 0.380.370.37 query17 1.001.061.02 query18 0.220.200.20 query19 1.961.901.82 query20 0.010.010.02 query21 15.36 0.880.53 query22 0.751.050.65 query23 15.08 1.390.62 query24 7.981.440.88 query25 0.590.210.12 query26 0.630.160.14 query27 0.050.040.04 query28 9.150.850.42 query29 12.61 3.913.30 query30 0.260.080.07 query31 2.830.610.39 query32 3.230.550.47 query33 3.043.033.05 query34 15.77 5.074.46 query35 4.524.524.50 query36 0.660.490.47 query37 0.090.060.07 query38 0.040.040.04 query39 0.030.020.02 query40 0.180.130.13 query41 0.080.020.02 query42 0.030.020.02 query43 0.030.020.02 Total cold run time: 106.11 s Total hot run time: 31.07 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
doris-robot commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2739119064 TPC-H: Total hot run time: 32061 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit c92f0b5105d0257de1b11f07a7af966011a3b1ca, data reload: false -- Round 1 -- q1 24069 508649724972 q2 2040294 170 170 q3 10396 1232680 680 q4 10222 1019536 536 q5 7523246623262326 q6 191 163 131 131 q7 908 748 607 607 q8 93021264974 974 q9 4940465546724655 q10 6805229118671867 q11 492 274 249 249 q12 349 363 221 221 q13 17779 365730733073 q14 226 226 204 204 q15 544 477 486 477 q16 631 629 603 603 q17 571 848 336 336 q18 7045634363866343 q19 1591954 560 560 q20 326 319 192 192 q21 2843213919081908 q22 10531025977 977 Total cold run time: 109846 ms Total hot run time: 32061 ms - Round 2, with runtime_filter_mode=off - q1 5151511250975097 q2 230 318 225 225 q3 2126260923082308 q4 1425180613741374 q5 4241412043234120 q6 218 176 128 128 q7 1975193917701770 q8 2620250825302508 q9 7197720672147206 q10 3042324627372737 q11 584 502 509 502 q12 701 778 633 633 q13 3577390633103310 q14 293 290 265 265 q15 541 474 469 469 q16 652 700 667 667 q17 1140157413961396 q18 7747769875147514 q19 826 831 877 831 q20 1999208218841884 q21 5466484749374847 q22 1113109410601060 Total cold run time: 52864 ms Total hot run time: 50851 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]
[PR] [fix](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 opened a new pull request, #49297: URL: https://github.com/apache/doris/pull/49297 … ### What problem does this PR solve? Issue Number: close #xxx Related PR: #xxx Problem Summary: ### Release note None ### Check List (For Author) - Test - [ ] Regression test - [ ] Unit Test - [ ] Manual test (add detailed scripts or steps below) - [ ] No need to test or manual test. Explain why: - [ ] This is a refactor/code format and no logic has been changed. - [ ] Previous test can cover this change. - [ ] No code files have been changed. - [ ] Other reason - Behavior changed: - [ ] No. - [ ] Yes. - Does this need documentation? - [ ] No. - [ ] Yes. ### Check List (For Reviewer who merge this PR) - [ ] Confirm the release note - [ ] Confirm test cases - [ ] Confirm document - [ ] Add branch pick label -- 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
starocean999 commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2739062615 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](nereids)use analyzed plan instead of rewritten plan in CreateMaterializedViewCommand [doris]
Thearas commented on PR #49297: URL: https://github.com/apache/doris/pull/49297#issuecomment-2739062530 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]
