Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
dataroaring merged PR #49023: URL: https://github.com/apache/doris/pull/49023 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
doris-robot commented on PR #49023: URL: https://github.com/apache/doris/pull/49023#issuecomment-2732097663 ClickBench: Total hot run time: 31.92 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 3d6b90a58dea0a3babd19c3de6badfbdefb07dd7, data reload: false query1 0.030.030.03 query2 0.060.030.03 query3 0.230.060.06 query4 1.630.100.10 query5 0.490.510.51 query6 1.140.720.72 query7 0.020.020.01 query8 0.040.030.03 query9 0.580.500.51 query10 0.550.560.55 query11 0.140.100.10 query12 0.130.120.11 query13 0.620.600.60 query14 2.862.892.77 query15 0.900.830.82 query16 0.390.380.37 query17 1.061.051.04 query18 0.240.210.20 query19 1.911.892.03 query20 0.010.010.02 query21 15.36 0.590.57 query22 2.532.781.46 query23 17.15 0.970.78 query24 3.271.121.04 query25 0.190.040.07 query26 0.600.150.14 query27 0.060.050.04 query28 10.06 0.540.44 query29 12.62 3.243.26 query30 0.250.060.06 query31 2.860.380.37 query32 3.260.460.46 query33 2.983.013.06 query34 16.91 4.514.49 query35 4.564.554.55 query36 0.680.480.50 query37 0.080.060.06 query38 0.040.030.03 query39 0.040.020.02 query40 0.160.130.12 query41 0.080.030.02 query42 0.040.020.02 query43 0.030.030.04 Total cold run time: 106.84 s Total hot run time: 31.92 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
doris-robot commented on PR #49023: URL: https://github.com/apache/doris/pull/49023#issuecomment-2732044083 TPC-H: Total hot run time: 40083 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 3d6b90a58dea0a3babd19c3de6badfbdefb07dd7, data reload: false -- Round 1 -- q1 17584 672166266626 q2 2062171 175 171 q3 10656 110011571100 q4 10560 762 787 762 q5 7744284528612845 q6 222 135 134 134 q7 947 630 616 616 q8 9397196320861963 q9 6812646664216421 q10 7054225122742251 q11 454 295 255 255 q12 410 216 205 205 q13 17758 298030342980 q14 243 212 205 205 q15 505 463 477 463 q16 677 606 571 571 q17 966 593 584 584 q18 7260665666606656 q19 1405109710041004 q20 484 215 201 201 q21 3956323330723072 q22 1002998 998 Total cold run time: 108267 ms Total hot run time: 40083 ms - Round 2, with runtime_filter_mode=off - q1 6650655865586558 q2 319 233 228 228 q3 2883277729332777 q4 2061180218021802 q5 5775572157225721 q6 214 132 130 130 q7 2240180617931793 q8 3366355634823482 q9 8838897788698869 q10 3582354334963496 q11 593 488 496 488 q12 804 577 665 577 q13 7814323031643164 q14 314 287 272 272 q15 507 475 470 470 q16 688 645 652 645 q17 1829161116011601 q18 8283787877127712 q19 1643159214851485 q20 2092188019021880 q21 5554541753195319 q22 1137105710371037 Total cold run time: 67186 ms Total hot run time: 59506 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
doris-robot commented on PR #49023: URL: https://github.com/apache/doris/pull/49023#issuecomment-2732086245 TPC-DS: Total hot run time: 197103 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 3d6b90a58dea0a3babd19c3de6badfbdefb07dd7, data reload: false query1 1262913 919 913 query2 6244213121042104 query3 10942 440944604409 query4 66170 28530 23302 23302 query5 4890456 463 456 query6 439 188 181 181 query7 5605315 319 315 query8 311 229 226 226 query9 8979261126002600 query10 461 265 259 259 query11 17755 15269 15773 15269 query12 149 105 101 101 query13 1493449 449 449 query14 10603 773968216821 query15 209 182 175 175 query16 7108481 494 481 query17 1092614 632 614 query18 1828322 312 312 query19 219 170 164 164 query20 115 116 110 110 query21 209 102 102 102 query22 4738459046114590 query23 34519 34118 34011 34011 query24 6236297228692869 query25 525 426 393 393 query26 656 163 167 163 query27 1743345 356 345 query28 4006245524262426 query29 691 470 435 435 query30 242 164 169 164 query31 998 844 834 834 query32 66 57 53 53 query33 425 291 286 286 query34 912 506 499 499 query35 842 720 746 720 query36 1059958 986 958 query37 117 63 66 63 query38 4192413040654065 query39 1507149214811481 query40 213 99 97 97 query41 49 46 53 46 query42 121 106 100 100 query43 543 486 500 486 query44 1178817 827 817 query45 185 167 168 167 query46 1146728 727 727 query47 2039191219771912 query48 500 378 399 378 query49 739 402 387 387 query50 856 442 424 424 query51 7428737170077007 query52 106 88 84 84 query53 252 180 176 176 query54 566 450 455 450 query55 75 76 79 76 query56 255 239 249 239 query57 1224109911011099 query58 215 202 204 202 query59 3204299430002994 query60 275 249 249 249 query61 109 149 148 148 query62 799 664 677 664 query63 213 194 183 183 query64 1381702 630 630 query65 3277322932383229 query66 692 305 296 296 query67 15925 15544 15712 15544 query68 3616597 579 579 query69 422 271 265 265 query70 1206109611481096 query71 341 264 261 261 query72 6213411641474116 query73 755 348 341 341 query74 10166 909189958995 query75 3367265126552651 query76 1935113510931093 query77 500 295 287 287 query78 10504 991295189518 query79 1953608 605 605 query80 1334495 414 414 query81 521 241 240 240 query82 100686 88 86 query83 265 147 140 140 query84 282 80 77 77 query85 1020306 290 290 query86 446 302 313 302 query87 4395421242514212 query88 3718238223452345 query89 414 289 290 289 query90 1901178 183 178 query91 178 148 167 148 query92 60 47 51 47 query93 2376552 554 552 query94 812 290 256 256 query95 358 254 256 254 query96 617 278 283 278 query97 3305319931703170 query98 210 201 193 193 query99 1574129612981296 Total cold run time: 318892 ms Total hot run time: 197103 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to
Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
morrySnow commented on PR #49023: URL: https://github.com/apache/doris/pull/49023#issuecomment-2731951523 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
doris-robot commented on PR #49023: URL: https://github.com/apache/doris/pull/49023#issuecomment-2720422901 ClickBench: Total hot run time: 32.04 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit cd85cf55ccf35045e1fdf8de808d1868f55dc042, data reload: false query1 0.030.030.02 query2 0.060.040.03 query3 0.230.070.07 query4 1.630.110.11 query5 0.540.520.52 query6 1.170.730.73 query7 0.020.020.02 query8 0.040.030.03 query9 0.550.500.49 query10 0.550.540.55 query11 0.140.100.10 query12 0.150.110.11 query13 0.610.600.60 query14 2.772.742.72 query15 0.880.820.82 query16 0.400.380.39 query17 1.061.081.05 query18 0.240.220.22 query19 1.821.902.01 query20 0.010.010.02 query21 15.35 0.580.59 query22 2.272.512.02 query23 17.17 0.920.83 query24 3.240.612.46 query25 0.310.230.09 query26 0.460.140.13 query27 0.040.050.04 query28 9.430.480.48 query29 12.66 3.213.20 query30 0.260.060.06 query31 2.870.390.38 query32 3.260.460.46 query33 3.013.043.02 query34 16.94 4.454.46 query35 4.534.544.46 query36 0.670.470.50 query37 0.090.070.06 query38 0.040.030.03 query39 0.030.020.02 query40 0.160.140.12 query41 0.080.030.02 query42 0.040.020.03 query43 0.040.030.02 Total cold run time: 105.85 s Total hot run time: 32.04 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
doris-robot commented on PR #49023: URL: https://github.com/apache/doris/pull/49023#issuecomment-2720400095 TPC-DS: Total hot run time: 197328 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 cd85cf55ccf35045e1fdf8de808d1868f55dc042, data reload: false query1 1327917 907 907 query2 6262220021262126 query3 10827 436041684168 query4 61112 33876 23648 23648 query5 5178447 446 446 query6 315 166 170 166 query7 4907324 317 317 query8 285 226 226 226 query9 6526266126462646 query10 418 264 255 255 query11 15761 15262 15475 15262 query12 160 109 104 104 query13 1074464 459 459 query14 11099 729872407240 query15 194 191 180 180 query16 7117516 497 497 query17 1188592 586 586 query18 1817316 337 316 query19 208 168 156 156 query20 122 110 115 110 query21 212 116 104 104 query22 4892448447924484 query23 34692 33761 33913 33761 query24 6278291429042904 query25 544 441 425 425 query26 659 174 173 173 query27 1860367 369 367 query28 4176255024552455 query29 711 487 453 453 query30 241 164 167 164 query31 983 825 835 825 query32 63 53 56 53 query33 437 279 289 279 query34 928 508 522 508 query35 857 728 723 723 query36 1074949 975 949 query37 116 62 66 62 query38 4101396040283960 query39 1516146114601460 query40 203 99 98 98 query41 49 49 48 48 query42 110 102 100 100 query43 551 507 506 506 query44 1158829 845 829 query45 188 174 179 174 query46 1183733 757 733 query47 2021191619241916 query48 482 389 402 389 query49 712 388 408 388 query50 827 423 414 414 query51 7389734972807280 query52 104 92 94 92 query53 258 191 191 191 query54 574 474 490 474 query55 80 77 80 77 query56 267 243 250 243 query57 1300115911661159 query58 228 216 220 216 query59 3284308328482848 query60 278 263 253 253 query61 110 108 109 108 query62 749 678 666 666 query63 213 184 185 184 query64 1361695 651 651 query65 3258318231763176 query66 714 297 312 297 query67 15992 15844 15498 15498 query68 3603603 585 585 query69 426 270 261 261 query70 1201110711641107 query71 352 262 255 255 query72 6304393339363933 query73 745 354 356 354 query74 10386 893091918930 query75 3321264226542642 query76 172510371037 query77 487 272 266 266 query78 10701 961796869617 query79 1304600 602 600 query80 824 443 418 418 query81 518 241 236 236 query82 126288 88 88 query83 158 138 142 138 query84 284 80 81 80 query85 860 307 288 288 query86 326 288 291 288 query87 4504425943574259 query88 3725239223622362 query89 406 299 286 286 query90 1985185 184 184 query91 187 149 149 149 query92 59 49 50 49 query93 1772560 559 559 query94 716 291 268 268 query95 354 253 249 249 query96 614 284 283 283 query97 3294320431633163 query98 210 202 199 199 query99 1579126312761263 Total cold run time: 308072 ms Total hot run time: 197328 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to
Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
doris-robot commented on PR #49023: URL: https://github.com/apache/doris/pull/49023#issuecomment-2720360781 TPC-H: Total hot run time: 40118 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit cd85cf55ccf35045e1fdf8de808d1868f55dc042, data reload: false -- Round 1 -- q1 17631 688466396639 q2 2063173 165 165 q3 10811 106811951068 q4 10347 823 727 727 q5 7711293028502850 q6 221 136 138 136 q7 983 624 614 614 q8 9385196620961966 q9 6661644663776377 q10 7158225923082259 q11 469 263 261 261 q12 409 211 210 210 q13 17786 298630292986 q14 229 209 205 205 q15 513 462 472 462 q16 667 614 592 592 q17 990 560 612 560 q18 7406676666696669 q19 1397104710201020 q20 485 206 194 194 q21 4020316633643166 q22 1113993 992 992 Total cold run time: 108455 ms Total hot run time: 40118 ms - Round 2, with runtime_filter_mode=off - q1 6702658466036584 q2 330 234 228 228 q3 2909279129512791 q4 2047185018051805 q5 5811575657455745 q6 211 129 128 128 q7 2268181818641818 q8 3388360235323532 q9 8830889789368897 q10 3588350335393503 q11 594 496 500 496 q12 838 599 601 599 q13 9436319331603160 q14 310 262 282 262 q15 532 462 469 462 q16 682 657 677 657 q17 1877163116201620 q18 8426781076837683 q19 1750159415981594 q20 2059184618811846 q21 5509551754645464 q22 1145102110391021 Total cold run time: 69242 ms Total hot run time: 59895 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
Thearas commented on PR #49023: URL: https://github.com/apache/doris/pull/49023#issuecomment-2720160669 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
Thearas commented on PR #49023: URL: https://github.com/apache/doris/pull/49023#issuecomment-2720160580 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 [doris]
dataroaring closed pull request #49023: branch-3.0: [opt](nereids) set column stats unkown by default when derive Not expressoin #48864 URL: https://github.com/apache/doris/pull/49023 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
