Re: [PR] [refine](expr) Expr execution does not depend on the block's rows. [doris]
zclllyybb merged PR #58578: URL: https://github.com/apache/doris/pull/58578 -- 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
github-actions[bot] commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3609913834 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
github-actions[bot] commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3609913682 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
hello-stephen commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3606696472 # BE Regression && UT Coverage Report Increment line coverage `96.15% (100/104)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 72.11% (24695/34246) | | Line Coverage | 58.71% (258695/440651) | | Region Coverage | 53.33% (213905/401104) | | Branch Coverage | 54.99% (91659/166689) | -- 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
hello-stephen commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3606655885 # BE Regression && UT Coverage Report Increment line coverage `96.15% (100/104)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 72.11% (24695/34246) | | Line Coverage | 58.70% (258667/440651) | | Region Coverage | 53.32% (213868/401104) | | Branch Coverage | 54.98% (91651/166689) | -- 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
hello-stephen commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3606622680 # BE Regression && UT Coverage Report Increment line coverage `96.15% (100/104)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 72.11% (24694/34246) | | Line Coverage | 58.70% (258645/440651) | | Region Coverage | 53.31% (213820/401104) | | Branch Coverage | 54.97% (91632/166689) | -- 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
hello-stephen commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3606479175 # BE Regression && UT Coverage Report Increment line coverage `97.12% (101/104)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 73.58% (25197/34246) | | Line Coverage | 60.80% (267898/440651) | | Region Coverage | 55.62% (223091/401104) | | Branch Coverage | 57.44% (95743/166689) | -- 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3606451581 # BE UT Coverage Report Increment line coverage `25.00% (26/104)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/16b4038c94f9ac58ba86db780a2f242c2789cacb_16b4038c94f9ac58ba86db780a2f242c2789cacb/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/16b4038c94f9ac58ba86db780a2f242c2789cacb_16b4038c94f9ac58ba86db780a2f242c2789cacb/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.36% (18639/34930) | | Line Coverage | 39.02% (172087/441046) | | Region Coverage | 33.64% (133301/396294) | | Branch Coverage | 34.58% (57339/165792) | -- 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3606033042 ClickBench: Total hot run time: 27.51 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false query1 0.060.050.05 query2 0.100.050.05 query3 0.250.080.09 query4 1.600.100.11 query5 0.280.250.25 query6 1.160.650.64 query7 0.030.020.02 query8 0.060.040.04 query9 0.580.520.49 query10 0.570.560.55 query11 0.170.110.12 query12 0.150.110.12 query13 0.640.610.60 query14 1.000.970.99 query15 0.810.810.80 query16 0.400.400.39 query17 1.041.071.05 query18 0.240.220.22 query19 1.871.801.76 query20 0.020.010.01 query21 15.49 0.310.14 query22 4.860.050.05 query23 15.99 0.290.11 query24 2.150.370.63 query25 0.070.050.05 query26 0.140.150.14 query27 0.120.050.04 query28 4.061.221.03 query29 12.55 3.963.21 query30 0.290.140.11 query31 2.820.630.42 query32 3.240.570.46 query33 3.023.073.09 query34 16.74 5.204.62 query35 4.624.584.54 query36 0.680.490.49 query37 0.110.070.06 query38 0.070.040.04 query39 0.050.030.03 query40 0.160.140.14 query41 0.080.040.03 query42 0.040.030.03 query43 0.040.040.04 Total cold run time: 98.42 s Total hot run time: 27.51 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3606009930 TPC-DS: Total hot run time: 182500 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 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false query1 1060411 395 395 query2 6584118611341134 query3 6744227 229 227 query4 25522 23376 22828 22828 query5 4483644 495 495 query6 356 259 241 241 query7 4667533 320 320 query8 318 259 251 251 query9 8726265826582658 query10 517 392 333 333 query11 15365 15220 15064 15064 query12 184 124 118 118 query13 1686605 469 469 query14 9115594859295929 query15 210 209 183 183 query16 7443692 533 533 query17 1249787 651 651 query18 2028438 351 351 query19 223 212 179 179 query20 144 130 120 120 query21 218 143 115 115 query22 3982401739813981 query23 33146 31868 32168 31868 query24 8492248924362436 query25 680 560 504 504 query26 1252297 179 179 query27 2709506 361 361 query28 4366221921852185 query29 883 676 524 524 query30 320 252 219 219 query31 851 703 619 619 query32 94 76 82 76 query33 623 399 344 344 query34 868 888 589 589 query35 805 830 738 738 query36 914 931 823 823 query37 124 113 90 90 query38 3895388837633763 query39 1459140814151408 query40 228 127 122 122 query41 67 62 61 61 query42 124 120 114 114 query43 447 456 434 434 query44 1333764 770 764 query45 200 195 189 189 query46 926 1027647 647 query47 1694176216241624 query48 420 425 329 329 query49 761 496 404 404 query50 697 726 421 421 query51 3890386441513864 query52 117 112 103 103 query53 246 262 189 189 query54 319 310 287 287 query55 99 93 96 93 query56 349 349 360 349 query57 1118116511001100 query58 294 287 289 287 query59 2346238923332333 query60 344 358 341 341 query61 162 164 156 156 query62 830 713 672 672 query63 233 196 190 190 query64 46161255876 876 query65 4056398140003981 query66 1174447 335 335 query67 15398 14924 14815 14815 query68 83991008640 640 query69 530 341 317 317 query70 1083103610011001 query71 489 346 309 309 query72 5848488348674867 query73 719 572 342 342 query74 8746881886748674 query75 3598301625682568 query76 37301136748 748 query77 827 401 321 321 query78 9434968088898889 query79 1481876 601 601 query80 661 609 506 506 query81 484 275 246 246 query82 432 142 113 113 query83 277 278 267 267 query84 255 121 108 108 query85 918 490 434 434 query86 338 305 283 283 query87 4074408439763976 query88 2971234723362336 query89 415 338 301 301 query90 1941234 223 223 query91 178 174 138 138 query92 88 68 67 67 query93 11981060685 685 query94 726 433 349 349 query95 505 416 409 409 query96 549 550 290 290 query97 2634269626302630 query98 234 212 205 205 query99 1588140212761276 Total cold run time: 270143 ms Total hot run time: 182500 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3605963778 TPC-H: Total hot run time: 34852 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false -- Round 1 -- q1 17616 509649784978 q2 2077318 210 210 q3 10206 1319769 769 q4 10210 856 316 316 q5 7536250521412141 q6 188 174 139 139 q7 984 795 651 651 q8 9360145912571257 q9 7181544754395439 q10 6859220917751775 q11 525 310 286 286 q12 358 376 227 227 q13 17784 374831003100 q14 236 240 211 211 q15 600 517 508 508 q16 900 867 813 813 q17 713 743 575 575 q18 7704719770237023 q19 1102970 603 603 q20 379 372 248 248 q21 4171363426122612 q22 1043987 971 971 Total cold run time: 107732 ms Total hot run time: 34852 ms - Round 2, with runtime_filter_mode=off - q1 4992495349584953 q2 336 404 310 310 q3 2151270323032303 q4 1393178912741274 q5 4347458045404540 q6 229 183 131 131 q7 2065198518291829 q8 2701261125722572 q9 7641759376357593 q10 3072327628782878 q11 616 525 512 512 q12 713 792 607 607 q13 3562389933373337 q14 284 303 302 302 q15 581 522 510 510 q16 934 909 909 909 q17 1235160113731373 q18 8004762676777626 q19 905 888 880 880 q20 1955208519141914 q21 4828429142064206 q22 10871053970 970 Total cold run time: 53631 ms Total hot run time: 51529 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
hello-stephen commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3605048454 # BE Regression && UT Coverage Report Increment line coverage `97.12% (101/104)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 73.75% (25314/34326) | | Line Coverage | 60.98% (269099/441315) | | Region Coverage | 55.84% (224276/401641) | | Branch Coverage | 57.65% (96286/167010) | -- 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
hello-stephen commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3605039243 # BE Regression && UT Coverage Report Increment line coverage `97.12% (101/104)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 73.74% (25311/34326) | | Line Coverage | 60.97% (269071/441315) | | Region Coverage | 55.82% (224206/401641) | | Branch Coverage | 57.65% (96273/167010) | -- 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3604830878 ClickBench: Total hot run time: 27.35 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false query1 0.060.050.05 query2 0.140.060.05 query3 0.280.090.08 query4 1.610.110.11 query5 0.280.260.26 query6 1.160.650.64 query7 0.040.030.03 query8 0.050.040.04 query9 0.580.520.50 query10 0.560.570.56 query11 0.210.120.11 query12 0.160.110.12 query13 0.640.600.61 query14 0.980.970.98 query15 0.830.810.82 query16 0.420.380.40 query17 1.101.041.04 query18 0.240.210.22 query19 1.991.911.82 query20 0.010.010.01 query21 15.51 0.290.14 query22 4.960.050.04 query23 16.13 0.280.10 query24 2.290.360.18 query25 0.090.090.06 query26 0.140.140.13 query27 0.070.040.06 query28 3.751.241.03 query29 12.55 4.133.27 query30 0.270.140.11 query31 2.830.670.40 query32 3.230.560.47 query33 2.992.993.08 query34 16.87 5.284.54 query35 4.544.624.61 query36 0.650.510.50 query37 0.140.070.06 query38 0.070.040.04 query39 0.240.040.03 query40 0.230.130.13 query41 0.290.030.03 query42 0.070.030.03 query43 0.060.040.04 Total cold run time: 99.31 s Total hot run time: 27.35 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3604822291 TPC-DS: Total hot run time: 182478 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 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false query1 1192417 398 398 query2 7042117811451145 query3 6853230 225 225 query4 25866 23283 22981 22981 query5 5160657 502 502 query6 325 237 227 227 query7 4680532 302 302 query8 302 251 250 250 query9 8716265526332633 query10 524 364 331 331 query11 15291 15487 14967 14967 query12 197 122 115 115 query13 1690585 437 437 query14 9758608759695969 query15 213 204 186 186 query16 7695675 533 533 query17 1221810 638 638 query18 2053442 343 343 query19 223 218 182 182 query20 137 133 122 122 query21 461 136 117 117 query22 3958407639113911 query23 32969 31930 31857 31857 query24 8497244324532443 query25 680 541 491 491 query26 857 284 181 181 query27 2554510 350 350 query28 4260216721612161 query29 774 661 520 520 query30 350 245 213 213 query31 818 725 627 627 query32 86 76 76 76 query33 680 402 349 349 query34 848 897 534 534 query35 809 897 734 734 query36 903 925 838 838 query37 139 124 94 94 query38 3902390738173817 query39 1502141414231414 query40 223 133 120 120 query41 63 63 64 63 query42 128 129 119 119 query43 448 444 434 434 query44 1337741 738 738 query45 200 196 189 189 query46 909 1036651 651 query47 1716171116571657 query48 411 426 331 331 query49 753 489 425 425 query50 678 717 424 424 query51 3876390138653865 query52 114 115 105 105 query53 236 264 187 187 query54 319 301 278 278 query55 98 96 89 89 query56 338 324 350 324 query57 1136116511051105 query58 294 279 277 277 query59 2321238223962382 query60 355 348 345 345 query61 155 153 147 147 query62 784 750 673 673 query63 239 191 196 191 query64 33071228874 874 query65 4092395040023950 query66 897 445 343 343 query67 15168 15153 14841 14841 query68 84751005623 623 query69 526 342 308 308 query70 1142103110261026 query71 477 340 332 332 query72 5842490748394839 query73 723 600 344 344 query74 8592888287198719 query75 3680300525382538 query76 37631192770 770 query77 818 420 305 305 query78 9639981489588958 query79 2023862 613 613 query80 659 612 497 497 query81 497 272 239 239 query82 282 148 113 113 query83 271 268 255 255 query84 261 116 101 101 query85 886 501 441 441 query86 341 293 274 274 query87 4069412740734073 query88 3723231323162313 query89 394 336 292 292 query90 2027227 224 224 query91 167 166 144 144 query92 86 71 66 66 query93 12311030672 672 query94 697 466 346 346 query95 530 411 417 411 query96 538 564 283 283 query97 2575270525592559 query98 251 224 216 216 query99 1299141412441244 Total cold run time: 271264 ms Total hot run time: 182478 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3604800858 TPC-H: Total hot run time: 35550 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 16b4038c94f9ac58ba86db780a2f242c2789cacb, data reload: false -- Round 1 -- q1 17724 503549644964 q2 2443321 215 215 q3 10567 1376763 763 q4 10867 933 347 347 q5 7982248722132213 q6 195 173 139 139 q7 989 845 673 673 q8 9354145811421142 q9 6962537353405340 q10 7015219217941794 q11 607 309 307 307 q12 359 373 232 232 q13 17843 366330343034 q14 240 239 212 212 q15 589 522 513 513 q16 882 876 797 797 q17 731 824 568 568 q18 7427756175387538 q19 11501045691 691 q20 415 372 252 252 q21 4403400527912791 q22 1109106910251025 Total cold run time: 109853 ms Total hot run time: 35550 ms - Round 2, with runtime_filter_mode=off - q1 5277523552515235 q2 342 419 320 320 q3 2289278924132413 q4 1470203614231423 q5 44794449 q6 211 166 125 125 q7 1994196117721772 q8 2678253225232523 q9 7596745176137451 q10 3064318528322832 q11 612 510 498 498 q12 631 720 558 558 q13 3227364230933093 q14 278 305 260 260 q15 537 503 509 503 q16 886 892 849 849 q17 1124131613441316 q18 7140709670367036 q19 857 803 824 803 q20 1892197118481848 q21 4659427941334133 q22 10671010956 956 Total cold run time: 52310 ms Total hot run time: 50391 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
hello-stephen commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3603489760 # BE Regression && UT Coverage Report Increment line coverage `96.15% (100/104)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58578_16b4038c94f9ac58ba86db780a2f242c2789cacb_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 72.27% (24807/34326) | | Line Coverage | 58.87% (259783/441315) | | Region Coverage | 53.50% (214893/401641) | | Branch Coverage | 55.17% (92138/167010) | -- 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3603062424 # BE UT Coverage Report Increment line coverage `25.00% (26/104)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/16b4038c94f9ac58ba86db780a2f242c2789cacb_16b4038c94f9ac58ba86db780a2f242c2789cacb/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/16b4038c94f9ac58ba86db780a2f242c2789cacb_16b4038c94f9ac58ba86db780a2f242c2789cacb/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.51% (18734/35010) | | Line Coverage | 39.10% (172703/441710) | | Region Coverage | 33.69% (133692/396831) | | Branch Coverage | 34.65% (57552/166113) | -- 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Mryange commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3602702849 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Mryange commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3602308609 run cloud_p0 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3602047851 ClickBench: Total hot run time: 27.11 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 183b17b533daa97cb3992374c3ca8b1421afd0c7, data reload: false query1 0.050.050.05 query2 0.100.050.04 query3 0.250.100.09 query4 1.610.110.11 query5 0.300.250.25 query6 1.160.640.63 query7 0.030.030.03 query8 0.050.040.04 query9 0.560.510.51 query10 0.560.540.56 query11 0.150.110.11 query12 0.150.110.12 query13 0.630.590.61 query14 0.990.970.98 query15 0.810.790.82 query16 0.410.410.40 query17 1.061.070.98 query18 0.230.220.21 query19 1.931.851.74 query20 0.020.010.01 query21 15.45 0.290.14 query22 5.040.050.04 query23 15.90 0.260.10 query24 1.631.110.17 query25 0.100.060.05 query26 0.140.130.13 query27 0.080.060.04 query28 5.521.231.03 query29 12.56 4.073.32 query30 0.270.160.11 query31 2.830.630.40 query32 3.230.550.46 query33 3.033.033.04 query34 17.03 5.254.56 query35 4.624.514.50 query36 0.650.520.49 query37 0.100.060.06 query38 0.070.040.04 query39 0.040.030.03 query40 0.180.140.13 query41 0.080.040.03 query42 0.050.030.02 query43 0.040.030.03 Total cold run time: 99.69 s Total hot run time: 27.11 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3602023601 TPC-DS: Total hot run time: 181012 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 183b17b533daa97cb3992374c3ca8b1421afd0c7, data reload: false query1 1028411 399 399 query2 6619121011561156 query3 6740233 223 223 query4 24219 23176 22895 22895 query5 5096647 482 482 query6 331 229 220 220 query7 4658497 305 305 query8 321 260 232 232 query9 8749264126422641 query10 536 346 304 304 query11 15243 14945 14579 14579 query12 180 122 116 116 query13 1669572 460 460 query14 9593598060165980 query15 211 203 189 189 query16 7690683 555 555 query17 1219775 631 631 query18 2048429 344 344 query19 221 209 177 177 query20 128 125 122 122 query21 222 137 116 116 query22 3914409037823782 query23 32992 32203 31911 31911 query24 8537246824052405 query25 641 554 499 499 query26 1248281 172 172 query27 2669512 346 346 query28 4349214121532141 query29 801 642 518 518 query30 315 242 214 214 query31 811 702 634 634 query32 83 77 80 77 query33 644 395 345 345 query34 834 893 533 533 query35 828 849 748 748 query36 873 943 837 837 query37 126 115 88 88 query38 3835386038023802 query39 1459141314281413 query40 222 127 120 120 query41 66 60 62 60 query42 127 116 112 112 query43 431 445 418 418 query44 1316745 731 731 query45 197 191 183 183 query46 897 1013660 660 query47 1647170816461646 query48 408 419 330 330 query49 790 506 406 406 query50 684 714 417 417 query51 3879389137983798 query52 112 120 101 101 query53 241 255 195 195 query54 313 292 276 276 query55 92 92 90 90 query56 322 326 320 320 query57 1149116110991099 query58 293 275 275 275 query59 2390245522622262 query60 364 346 338 338 query61 164 155 155 155 query62 788 740 660 660 query63 242 188 196 188 query64 44491186891 891 query65 4058391740233917 query66 1090423 332 332 query67 14927 14970 14875 14875 query68 81611002620 620 query69 517 359 306 306 query70 1099102210141014 query71 516 357 314 314 query72 5792484947404740 query73 695 572 348 348 query74 8819874885808580 query75 3697301925242524 query76 38661150744 744 query77 818 409 306 306 query78 9481965188648864 query79 2656847 590 590 query80 671 587 490 490 query81 530 271 236 236 query82 493 139 111 111 query83 274 266 256 256 query84 259 115 99 99 query85 906 486 438 438 query86 395 286 288 286 query87 4095405539193919 query88 4231232922902290 query89 411 333 302 302 query90 1955231 221 221 query91 165 171 136 136 query92 87 72 67 67 query93 24051015653 653 query94 694 450 337 337 query95 504 415 413 413 query96 536 563 286 286 query97 2650270826102610 query98 244 211 209 209 query99 1334142112571257 Total cold run time: 272294 ms Total hot run time: 181012 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3601961484 TPC-H: Total hot run time: 34142 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 183b17b533daa97cb3992374c3ca8b1421afd0c7, data reload: false -- Round 1 -- q1 18060 500549364936 q2 2053312 198 198 q3 10285 1323758 758 q4 10218 857 318 318 q5 7537240921692169 q6 182 171 139 139 q7 946 765 647 647 q8 9355139311041104 q9 6921534253525342 q10 6842219218031803 q11 551 304 288 288 q12 339 371 230 230 q13 17786 369730263026 q14 234 250 216 216 q15 601 503 504 503 q16 869 871 792 792 q17 666 803 503 503 q18 7667694969736949 q19 1105939 585 585 q20 375 347 226 226 q21 3966322224652465 q22 10221017945 945 Total cold run time: 107580 ms Total hot run time: 34142 ms - Round 2, with runtime_filter_mode=off - q1 4949492049044904 q2 323 384 318 318 q3 2179264122442244 q4 1313177012891289 q5 4241440745904407 q6 216 173 126 126 q7 2109200418501850 q8 2813252424782478 q9 7610753476657534 q10 3065325428192819 q11 612 517 492 492 q12 719 774 588 588 q13 3514398035213521 q14 313 303 286 286 q15 557 520 512 512 q16 901 953 887 887 q17 1162143614771436 q18 7944765975857585 q19 901 1006868 868 q20 1957206019331933 q21 4710430541834183 q22 10551002958 958 Total cold run time: 53163 ms Total hot run time: 51218 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Mryange commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3601789655 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3601391675 ClickBench: Total hot run time: 27.54 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 92eb709a93362eb94acaee7c6bc96ca13a5d6dee, data reload: false query1 0.060.050.04 query2 0.100.050.04 query3 0.260.100.08 query4 1.600.110.11 query5 0.270.260.27 query6 1.180.650.65 query7 0.040.020.02 query8 0.070.040.04 query9 0.580.490.50 query10 0.560.570.56 query11 0.160.110.10 query12 0.160.110.12 query13 0.610.600.60 query14 0.980.980.99 query15 0.820.800.81 query16 0.430.400.41 query17 1.051.061.08 query18 0.240.210.21 query19 1.971.871.92 query20 0.020.010.01 query21 15.44 0.290.15 query22 4.980.050.05 query23 16.15 0.290.10 query24 1.170.290.34 query25 0.060.080.08 query26 0.140.130.13 query27 0.080.060.05 query28 3.541.221.03 query29 12.56 4.153.29 query30 0.280.140.12 query31 2.830.640.40 query32 3.230.590.46 query33 3.023.033.07 query34 16.83 5.204.53 query35 4.604.564.54 query36 0.670.520.50 query37 0.120.070.07 query38 0.070.040.04 query39 0.040.030.04 query40 0.170.150.14 query41 0.090.030.03 query42 0.040.020.02 query43 0.040.040.03 Total cold run time: 97.31 s Total hot run time: 27.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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3601373592 TPC-DS: Total hot run time: 182831 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 92eb709a93362eb94acaee7c6bc96ca13a5d6dee, data reload: false query1 1071433 399 399 query2 6567119311701170 query3 6748233 231 231 query4 25951 23483 22915 22915 query5 4941686 503 503 query6 340 244 233 233 query7 4657509 320 320 query8 305 255 249 249 query9 8734264926422642 query10 543 364 319 319 query11 15081 14944 14970 14944 query12 193 121 117 117 query13 1687585 437 437 query14 9677613961216121 query15 220 207 191 191 query16 7663703 538 538 query17 1219787 647 647 query18 2049439 354 354 query19 233 215 190 190 query20 141 164 123 123 query21 222 137 117 117 query22 3912393938023802 query23 32997 31956 31820 31820 query24 8515239524222395 query25 600 534 467 467 query26 741 279 173 173 query27 2645500 349 349 query28 4254217721602160 query29 716 639 509 509 query30 316 245 214 214 query31 822 701 637 637 query32 86 75 78 75 query33 606 399 366 366 query34 840 869 550 550 query35 785 832 754 754 query36 908 936 850 850 query37 131 110 92 92 query38 3914392538433843 query39 1490140514121405 query40 244 134 121 121 query41 67 67 64 64 query42 129 120 116 116 query43 442 453 436 436 query44 1370755 749 749 query45 201 195 184 184 query46 902 1012661 661 query47 1672172716711671 query48 400 445 336 336 query49 742 497 412 412 query50 711 734 430 430 query51 3999388038863880 query52 117 115 109 109 query53 252 269 204 204 query54 316 301 293 293 query55 100 94 95 94 query56 361 340 330 330 query57 1112115810971097 query58 293 283 283 283 query59 2371243622792279 query60 355 367 346 346 query61 166 167 166 166 query62 787 715 664 664 query63 240 204 202 202 query64 33981234919 919 query65 4029398839743974 query66 920 458 358 358 query67 15127 14851 14992 14851 query68 56381004640 640 query69 513 347 309 309 query70 1139103110201020 query71 429 358 320 320 query72 5934499751414997 query73 683 613 354 354 query74 8838882086128612 query75 3107306325682568 query76 32101165793 793 query77 516 418 338 338 query78 9387967589618961 query79 1927848 578 578 query80 790 630 551 551 query81 536 274 239 239 query82 439 148 117 117 query83 283 279 271 271 query84 285 123 105 105 query85 983 489 449 449 query86 393 291 281 281 query87 3983403339643964 query88 3025229623232296 query89 392 337 298 298 query90 1886233 227 227 query91 177 184 177 177 query92 80 72 67 67 query93 15531008670 670 query94 715 457 346 346 query95 508 425 424 424 query96 552 548 284 284 query97 2626270925842584 query98 242 220 214 214 query99 1295142113271327 Total cold run time: 265407 ms Total hot run time: 182831 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3601329844 TPC-H: Total hot run time: 34804 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 92eb709a93362eb94acaee7c6bc96ca13a5d6dee, data reload: false -- Round 1 -- q1 17604 502649524952 q2 2035318 213 213 q3 10254 1328727 727 q4 10232 897 325 325 q5 7546228323272283 q6 184 167 136 136 q7 956 784 648 648 q8 9361149510881088 q9 7131534253915342 q10 6855218617891789 q11 525 308 290 290 q12 378 378 233 233 q13 17785 372930263026 q14 235 238 217 217 q15 610 519 502 502 q16 912 872 828 828 q17 685 793 569 569 q18 7534731071637163 q19 1100979 592 592 q20 370 349 233 233 q21 4001386226892689 q22 1063997 959 959 Total cold run time: 107356 ms Total hot run time: 34804 ms - Round 2, with runtime_filter_mode=off - q1 5016496949704969 q2 342 413 317 317 q3 2150266022712271 q4 1319176113101310 q5 4300461646464616 q6 227 177 134 134 q7 2054191318711871 q8 2680252625572526 q9 7568753975517539 q10 3077328028562856 q11 598 515 496 496 q12 736 766 580 580 q13 3527398432863286 q14 281 306 299 299 q15 556 524 508 508 q16 916 936 884 884 q17 1240141914191419 q18 8095782374557455 q19 915 927 912 912 q20 2005196418651865 q21 4684422741554155 q22 10681050961 961 Total cold run time: 53354 ms Total hot run time: 51229 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Mryange commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3601004399 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Mryange commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3600348939 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3600058580 ClickBench: Total hot run time: 27.27 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 85ed7ea1ae5e0a8b18c4478943bd45988b181cbd, data reload: false query1 0.050.050.05 query2 0.100.050.05 query3 0.260.080.08 query4 1.610.120.11 query5 0.290.270.25 query6 1.180.650.63 query7 0.030.020.03 query8 0.060.040.05 query9 0.560.500.49 query10 0.560.570.55 query11 0.170.120.11 query12 0.150.110.12 query13 0.640.600.61 query14 1.010.980.98 query15 0.820.800.80 query16 0.380.410.40 query17 1.031.051.02 query18 0.230.210.21 query19 1.841.731.89 query20 0.020.010.02 query21 15.45 0.280.14 query22 4.750.050.05 query23 16.08 0.270.10 query24 1.000.670.30 query25 0.100.060.05 query26 0.140.140.14 query27 0.100.040.05 query28 3.141.231.02 query29 12.59 3.913.23 query30 0.290.140.12 query31 2.810.600.40 query32 3.230.540.46 query33 2.993.023.13 query34 16.77 5.164.59 query35 4.554.554.54 query36 0.670.490.48 query37 0.100.060.07 query38 0.070.050.04 query39 0.040.020.02 query40 0.180.140.14 query41 0.080.030.03 query42 0.040.030.03 query43 0.040.040.03 Total cold run time: 96.2 s Total hot run time: 27.27 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3600049271 TPC-DS: Total hot run time: 182475 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 85ed7ea1ae5e0a8b18c4478943bd45988b181cbd, data reload: false query1 1042411 397 397 query2 6625115311621153 query3 6746236 232 232 query4 25094 23475 23030 23030 query5 5106659 536 536 query6 365 244 230 230 query7 4643522 314 314 query8 330 256 251 251 query9 8744270526602660 query10 552 338 311 311 query11 15415 14825 15356 14825 query12 186 122 115 115 query13 1686563 435 435 query14 9565593260365932 query15 211 200 183 183 query16 7670691 536 536 query17 1216792 633 633 query18 2046438 350 350 query19 217 211 185 185 query20 141 131 124 124 query21 254 142 116 116 query22 3902401539133913 query23 32856 32186 32138 32138 query24 8493240924442409 query25 598 512 470 470 query26 1236277 167 167 query27 2732491 348 348 query28 4269217021442144 query29 801 617 488 488 query30 316 229 209 209 query31 818 731 620 620 query32 83 71 77 71 query33 595 405 344 344 query34 817 882 539 539 query35 782 827 745 745 query36 873 926 838 838 query37 140 114 87 87 query38 3883391337813781 query39 1483141414141414 query40 224 132 125 125 query41 67 61 62 61 query42 126 125 118 118 query43 442 452 415 415 query44 1345762 752 752 query45 200 197 186 186 query46 897 1011654 654 query47 1708177216691669 query48 384 423 335 335 query49 762 491 437 437 query50 662 686 414 414 query51 3922396639313931 query52 112 113 108 108 query53 244 267 195 195 query54 322 306 288 288 query55 100 104 93 93 query56 345 340 357 340 query57 1173118510781078 query58 296 276 283 276 query59 2305245122912291 query60 354 360 364 360 query61 160 159 163 159 query62 780 721 660 660 query63 226 202 200 200 query64 45341190906 906 query65 4045396739693967 query66 1103457 358 358 query67 15159 14898 14896 14896 query68 5800975 634 634 query69 519 352 315 315 query70 1090105010071007 query71 429 361 329 329 query72 5798485748984857 query73 673 569 347 347 query74 8586875386328632 query75 3062305125592559 query76 33281148745 745 query77 496 429 320 320 query78 9433952388868886 query79 2391848 599 599 query80 642 589 500 500 query81 527 274 235 235 query82 306 141 115 115 query83 277 263 250 250 query84 259 127 102 102 query85 906 488 437 437 query86 382 297 286 286 query87 4022408839753975 query88 4161234223092309 query89 412 331 296 296 query90 1993226 229 226 query91 161 173 144 144 query92 82 72 69 69 query93 20111010666 666 query94 741 473 349 349 query95 512 417 408 408 query96 522 557 291 291 query97 2642270625762576 query98 251 222 213 213 query99 1375136512531253 Total cold run time: 268317 ms Total hot run time: 182475 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3600020119 TPC-H: Total hot run time: 34248 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 85ed7ea1ae5e0a8b18c4478943bd45988b181cbd, data reload: false -- Round 1 -- q1 17060 511749544954 q2 2100304 213 213 q3 10011 1324733 733 q4 10192 785 323 323 q5 7524204622882046 q6 195 176 142 142 q7 912 844 641 641 q8 93721353 q9 7084535053805350 q10 6844220718011801 q11 537 305 298 298 q12 333 373 222 222 q13 17781 367830613061 q14 243 256 218 218 q15 599 520 518 518 q16 876 880 815 815 q17 595 730 568 568 q18 7987718871617161 q19 1089970 576 576 q20 353 355 232 232 q21 3629319823172317 q22 10391023948 948 Total cold run time: 106355 ms Total hot run time: 34248 ms - Round 2, with runtime_filter_mode=off - q1 5000523449604960 q2 325 389 314 314 q3 2134270523162316 q4 1373177712961296 q5 4224441244724412 q6 227 180 133 133 q7 2045195719261926 q8 2678253325282528 q9 7497747775147477 q10 3063332028322832 q11 630 525 488 488 q12 698 752 835 752 q13 3488387333503350 q14 279 287 273 273 q15 553 506 536 506 q16 935 958 889 889 q17 1160141214181412 q18 7808774575707570 q19 864 852 829 829 q20 2085198318221822 q21 4633431042084208 q22 10621059994 994 Total cold run time: 52761 ms Total hot run time: 51287 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Mryange commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3599885628 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3596682727 ClickBench: Total hot run time: 27.41 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit a179bb8ed88354dbbe084a7282c1361d5294d996, data reload: false query1 0.050.060.05 query2 0.110.050.05 query3 0.250.090.09 query4 1.610.120.11 query5 0.280.270.26 query6 1.150.650.63 query7 0.030.030.03 query8 0.060.040.04 query9 0.570.520.51 query10 0.570.550.56 query11 0.160.110.12 query12 0.150.120.11 query13 0.620.600.62 query14 0.980.970.99 query15 0.820.810.81 query16 0.390.410.45 query17 0.991.051.07 query18 0.230.210.21 query19 1.971.871.87 query20 0.020.010.02 query21 15.48 0.270.14 query22 4.670.060.04 query23 15.85 0.250.11 query24 1.331.000.24 query25 0.120.070.06 query26 0.140.130.12 query27 0.080.040.04 query28 4.921.221.01 query29 12.58 3.853.24 query30 0.290.140.13 query31 2.840.620.39 query32 3.230.540.46 query33 3.013.113.05 query34 16.90 5.194.50 query35 4.534.604.56 query36 0.670.500.50 query37 0.110.070.06 query38 0.070.040.04 query39 0.050.030.03 query40 0.170.140.15 query41 0.080.030.03 query42 0.040.020.02 query43 0.040.040.03 Total cold run time: 98.21 s Total hot run time: 27.41 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3596655304 TPC-DS: Total hot run time: 182288 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 a179bb8ed88354dbbe084a7282c1361d5294d996, data reload: false query1 1108426 405 405 query2 6596121011511151 query3 6741231 226 226 query4 25660 23265 22922 22922 query5 4853684 502 502 query6 370 239 241 239 query7 4661528 314 314 query8 323 255 246 246 query9 8770265026602650 query10 540 357 339 339 query11 15323 15401 14905 14905 query12 192 122 117 117 query13 1695570 451 451 query14 9594611360706070 query15 225 201 189 189 query16 7556714 543 543 query17 1227793 644 644 query18 2037442 345 345 query19 218 222 184 184 query20 135 125 124 124 query21 225 145 128 128 query22 3991388338683868 query23 32801 32208 32017 32017 query24 8531244624762446 query25 626 549 498 498 query26 1258287 173 173 query27 2719518 363 363 query28 4342216521552155 query29 857 675 533 533 query30 316 247 216 216 query31 838 718 637 637 query32 90 77 79 77 query33 652 396 328 328 query34 841 900 557 557 query35 818 842 748 748 query36 916 924 839 839 query37 126 117 87 87 query38 3857378538693785 query39 1480141114171411 query40 237 135 119 119 query41 66 63 66 63 query42 125 113 114 113 query43 440 458 430 430 query44 1328748 753 748 query45 208 192 184 184 query46 896 1009664 664 query47 1689174616391639 query48 396 436 336 336 query49 771 509 437 437 query50 687 725 417 417 query51 3852398039153915 query52 111 115 105 105 query53 238 268 193 193 query54 318 297 285 285 query55 100 96 94 94 query56 328 350 325 325 query57 1145114610911091 query58 301 290 281 281 query59 2359239622642264 query60 365 346 341 341 query61 167 164 200 164 query62 805 727 659 659 query63 235 201 206 201 query64 45611207902 902 query65 4097398940453989 query66 1132441 353 353 query67 15182 15136 14685 14685 query68 8354980 629 629 query69 518 354 315 315 query70 1120100110051001 query71 489 338 318 318 query72 5829485447974797 query73 717 576 343 343 query74 8753875785528552 query75 3750306425332533 query76 38141162754 754 query77 815 428 329 329 query78 9519961288628862 query79 1988858 577 577 query80 656 589 514 514 query81 499 269 246 246 query82 842 149 112 112 query83 272 270 258 258 query84 259 117 93 93 query85 942 492 461 461 query86 340 307 291 291 query87 4029409739803980 query88 3847232723142314 query89 400 343 306 306 query90 2020229 234 229 query91 174 172 148 148 query92 87 71 71 71 query93 1400988 676 676 query94 744 472 349 349 query95 506 414 404 404 query96 513 552 288 288 query97 2636270325862586 query98 248 221 222 221 query99 1361140013021302 Total cold run time: 272688 ms Total hot run time: 182288 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3596596425 TPC-H: Total hot run time: 34035 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit a179bb8ed88354dbbe084a7282c1361d5294d996, data reload: false -- Round 1 -- q1 17637 511248764876 q2 2056312 210 210 q3 10284 1298746 746 q4 10228 873 324 324 q5 7499237321962196 q6 184 178 143 143 q7 953 786 642 642 q8 9355135810761076 q9 7011534553095309 q10 6843221417951795 q11 529 315 299 299 q12 349 364 226 226 q13 17813 371930483048 q14 229 238 224 224 q15 596 532 509 509 q16 882 853 831 831 q17 580 792 458 458 q18 7570702970347029 q19 1085961 568 568 q20 338 339 232 232 q21 3615317123482348 q22 10161018946 946 Total cold run time: 106652 ms Total hot run time: 34035 ms - Round 2, with runtime_filter_mode=off - q1 4970491249234912 q2 353 412 325 325 q3 2111271222972297 q4 1304178113021302 q5 4208434746184347 q6 222 178 127 127 q7 2078201818231823 q8 2728242925492429 q9 7574778474127412 q10 3063330029732973 q11 589 512 493 493 q12 681 763 577 577 q13 3442392633043304 q14 276 316 283 283 q15 554 498 518 498 q16 914 957 1020957 q17 1166145914531453 q18 7740769675817581 q19 849 800 826 800 q20 1994212918901890 q21 4862456444524452 q22 11091047978 978 Total cold run time: 52787 ms Total hot run time: 51213 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Mryange commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3596333490 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3596126287 ClickBench: Total hot run time: 27.29 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 2e40358b1b4fd8a85a0d6194f3e8b5b5ea1acaa1, data reload: false query1 0.060.040.05 query2 0.090.050.06 query3 0.260.100.09 query4 1.610.110.12 query5 0.280.250.25 query6 1.170.660.65 query7 0.030.020.02 query8 0.050.040.04 query9 0.590.520.49 query10 0.560.560.54 query11 0.170.110.12 query12 0.150.120.11 query13 0.640.610.60 query14 0.990.980.99 query15 0.820.790.80 query16 0.390.420.39 query17 0.971.041.04 query18 0.230.220.24 query19 1.971.861.76 query20 0.020.020.01 query21 15.46 0.290.14 query22 4.700.060.05 query23 15.90 0.260.11 query24 2.290.590.19 query25 0.070.070.06 query26 0.140.150.13 query27 0.060.040.05 query28 3.941.221.02 query29 12.56 3.873.30 query30 0.270.140.11 query31 2.840.610.39 query32 3.240.550.47 query33 2.983.093.08 query34 16.73 5.224.51 query35 4.594.574.57 query36 0.670.510.49 query37 0.110.060.06 query38 0.070.040.04 query39 0.040.030.02 query40 0.170.140.14 query41 0.080.020.03 query42 0.040.040.03 query43 0.040.030.03 Total cold run time: 98.04 s Total hot run time: 27.29 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3596108061 TPC-DS: Total hot run time: 181794 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 2e40358b1b4fd8a85a0d6194f3e8b5b5ea1acaa1, data reload: false query1 1057407 430 407 query2 6575117111571157 query3 6757223 227 223 query4 25517 23416 22947 22947 query5 5280643 505 505 query6 346 256 237 237 query7 4651500 305 305 query8 302 260 254 254 query9 8740266626872666 query10 532 355 307 307 query11 15468 14928 15012 14928 query12 188 121 116 116 query13 1689587 437 437 query14 9842599560045995 query15 217 198 192 192 query16 7693715 531 531 query17 1305771 654 654 query18 2045437 350 350 query19 217 207 182 182 query20 134 132 122 122 query21 222 142 115 115 query22 3845403539193919 query23 33077 32010 31881 31881 query24 8445244724152415 query25 647 564 481 481 query26 1260292 174 174 query27 2714507 359 359 query28 4340217221572157 query29 824 638 516 516 query30 312 240 220 220 query31 821 716 646 646 query32 93 80 72 72 query33 601 391 340 340 query34 823 912 536 536 query35 796 837 738 738 query36 894 927 827 827 query37 119 115 93 93 query38 3845386438133813 query39 1528141114341411 query40 226 130 120 120 query41 66 64 63 63 query42 125 114 117 114 query43 434 454 414 414 query44 1262756 751 751 query45 202 194 188 188 query46 892 994 638 638 query47 1684172316321632 query48 390 417 337 337 query49 764 478 431 431 query50 666 688 415 415 query51 3973389840613898 query52 115 112 102 102 query53 244 263 195 195 query54 315 292 281 281 query55 100 97 92 92 query56 328 315 326 315 query57 1128117210911091 query58 286 275 272 272 query59 2249249822652265 query60 357 364 334 334 query61 162 157 159 157 query62 782 723 686 686 query63 228 193 190 190 query64 45091208878 878 query65 4061397440113974 query66 1084440 344 344 query67 15187 15143 14712 14712 query68 8464949 618 618 query69 499 354 312 312 query70 10941048995 995 query71 475 357 317 317 query72 6043492147844784 query73 646 559 344 344 query74 8874875186118611 query75 3719300725452545 query76 36251125735 735 query77 806 402 325 325 query78 9467962788218821 query79 2221856 576 576 query80 635 568 504 504 query81 527 265 253 253 query82 462 134 111 111 query83 268 259 249 249 query84 266 115 101 101 query85 915 510 444 444 query86 380 308 289 289 query87 3991405439803980 query88 4189230222962296 query89 419 340 298 298 query90 1956246 225 225 query91 176 170 143 143 query92 85 71 70 70 query93 1905993 660 660 query94 731 462 352 352 query95 513 416 418 416 query96 520 550 281 281 query97 2610268425672567 query98 245 222 219 219 query99 1641137112361236 Total cold run time: 273947 ms Total hot run time: 181794 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
doris-robot commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3596055886 TPC-H: Total hot run time: 34436 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 2e40358b1b4fd8a85a0d6194f3e8b5b5ea1acaa1, data reload: false -- Round 1 -- q1 17637 514549274927 q2 2116314 215 215 q3 10179 1293748 748 q4 10240 911 322 322 q5 7576237522632263 q6 184 171 135 135 q7 961 775 637 637 q8 9367140711331133 q9 7212535853255325 q10 6820217718001800 q11 521 314 292 292 q12 334 370 242 242 q13 17780 376630693069 q14 246 251 208 208 q15 602 532 519 519 q16 910 864 817 817 q17 606 816 500 500 q18 7467723570987098 q19 1097958 603 603 q20 336 347 231 231 q21 3101324724322432 q22 1041988 920 920 Total cold run time: 106333 ms Total hot run time: 34436 ms - Round 2, with runtime_filter_mode=off - q1 4966498949364936 q2 334 389 327 327 q3 2154272923572357 q4 1318176212791279 q5 4238439346564393 q6 219 174 129 129 q7 2131207918431843 q8 2714249024912490 q9 7537745274837452 q10 3058332428432843 q11 600 521 500 500 q12 703 783 621 621 q13 3529397433993399 q14 330 345 283 283 q15 550 532 511 511 q16 889 963 899 899 q17 1159150114011401 q18 7844766875927592 q19 837 815 804 804 q20 2004204519311931 q21 5048433641974197 q22 11141014969 969 Total cold run time: 53276 ms Total hot run time: 51156 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Mryange commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3595816967 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] [refine](expr) Expr execution does not depend on the block's rows. [doris]
Thearas commented on PR #58578: URL: https://github.com/apache/doris/pull/58578#issuecomment-3595814085 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]
