Re: [PR] [opt](nereids) flatten compound predicates [doris]
englefly closed pull request #44803: [opt](nereids) flatten compound predicates URL: https://github.com/apache/doris/pull/44803 -- 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] [opt](nereids) flatten compound predicates [doris]
doris-robot commented on PR #44803: URL: https://github.com/apache/doris/pull/44803#issuecomment-2508153671 ClickBench: Total hot run time: 32.08 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit dfa39da617d9e799d71165e288c0394c1f81eac0, data reload: false query1 0.030.030.03 query2 0.060.030.03 query3 0.230.070.07 query4 1.630.100.11 query5 0.440.420.41 query6 1.150.650.65 query7 0.020.020.01 query8 0.050.030.03 query9 0.570.520.50 query10 0.540.550.57 query11 0.140.100.10 query12 0.140.120.10 query13 0.610.600.61 query14 2.842.782.90 query15 0.900.830.82 query16 0.380.390.39 query17 1.050.991.08 query18 0.210.200.21 query19 1.991.871.98 query20 0.010.010.01 query21 15.37 0.600.57 query22 3.011.702.38 query23 16.98 0.880.90 query24 3.220.770.50 query25 0.260.200.15 query26 0.250.130.13 query27 0.040.040.04 query28 11.27 1.091.07 query29 12.61 3.253.21 query30 0.240.060.06 query31 2.880.380.38 query32 3.280.460.48 query33 2.983.013.01 query34 17.02 4.434.46 query35 4.474.474.49 query36 0.650.480.49 query37 0.080.060.06 query38 0.040.030.04 query39 0.040.020.02 query40 0.170.120.12 query41 0.080.020.02 query42 0.040.020.02 query43 0.030.040.03 Total cold run time: 108 s Total hot run time: 32.08 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] [opt](nereids) flatten compound predicates [doris]
doris-robot commented on PR #44803: URL: https://github.com/apache/doris/pull/44803#issuecomment-2508144762 TPC-DS: Total hot run time: 197551 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 dfa39da617d9e799d71165e288c0394c1f81eac0, data reload: false query1 1248954 987 954 query2 6248208420962084 query3 10971 455544524452 query4 67328 28598 23492 23492 query5 4914464 463 463 query6 401 197 169 169 query7 5462309 300 300 query8 332 240 242 240 query9 8511275627362736 query10 436 243 248 243 query11 16977 15273 16098 15273 query12 160 104 103 103 query13 1450423 399 399 query14 10777 698877156988 query15 217 203 198 198 query16 6967467 495 467 query17 1285578 561 561 query18 1790302 299 299 query19 200 161 156 156 query20 112 112 109 109 query21 198 107 107 107 query22 4521458345024502 query23 34936 34434 34576 34434 query24 5678256724602460 query25 509 384 387 384 query26 634 157 149 149 query27 1682294 294 294 query28 4496245924882459 query29 711 417 423 417 query30 209 151 154 151 query31 985 847 864 847 query32 64 57 52 52 query33 455 283 282 282 query34 951 517 546 517 query35 869 769 758 758 query36 1089945 984 945 query37 123 79 68 68 query38 4608453844474447 query39 1517148914731473 query40 204 109 108 108 query41 47 52 50 50 query42 110 102 104 102 query43 544 505 501 501 query44 1199840 838 838 query45 200 176 176 176 query46 1190760 738 738 query47 2032191719381917 query48 441 340 325 325 query49 783 420 417 417 query50 827 418 407 407 query51 7287717372077173 query52 99 85 95 85 query53 258 177 182 177 query54 504 402 395 395 query55 79 71 74 71 query56 265 234 238 234 query57 1226110811251108 query58 215 224 215 215 query59 3189299130012991 query60 274 235 241 235 query61 106 104 102 102 query62 787 684 672 672 query63 209 188 198 188 query64 1346675 686 675 query65 3280321531953195 query66 718 296 307 296 query67 15906 15686 15646 15646 query68 4032579 559 559 query69 433 253 256 253 query70 1098114011221122 query71 361 250 249 249 query72 6383404939883988 query73 757 368 360 360 query74 9475918890549054 query75 3410270026372637 query76 1944110210971097 query77 473 278 283 278 query78 10494 946494039403 query79 1694598 600 598 query80 1145454 493 454 query81 506 239 240 239 query82 1255118 122 118 query83 248 139 198 139 query84 274 69 65 65 query85 896 306 313 306 query86 375 301 303 301 query87 4629454145814541 query88 3712221921822182 query89 425 299 292 292 query90 1972190 195 190 query91 137 103 104 103 query92 67 51 49 49 query93 2005530 548 530 query94 835 296 301 296 query95 356 253 257 253 query96 607 279 274 274 query97 2854265926552655 query98 223 193 203 193 query99 1636131313041304 Total cold run time: 318057 ms Total hot run time: 197551 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] [opt](nereids) flatten compound predicates [doris]
doris-robot commented on PR #44803: URL: https://github.com/apache/doris/pull/44803#issuecomment-2508129091 TPC-H: Total hot run time: 40530 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit dfa39da617d9e799d71165e288c0394c1f81eac0, data reload: false -- Round 1 -- q1 17591 753473847384 q2 2061182 172 172 q3 10837 115112011151 q4 10537 705 795 705 q5 7615274427372737 q6 236 154 146 146 q7 996 641 618 618 q8 9245191818761876 q9 6776653464476447 q10 7027241423642364 q11 474 270 256 256 q12 434 234 226 226 q13 17768 303130473031 q14 236 216 206 206 q15 570 522 517 517 q16 663 603 581 581 q17 982 571 565 565 q18 7269681667866786 q19 1443104010071007 q20 461 184 186 184 q21 4208342532543254 q22 378 335 317 317 Total cold run time: 107807 ms Total hot run time: 40530 ms - Round 2, with runtime_filter_mode=off - q1 7282723072467230 q2 324 232 230 230 q3 2986294329782943 q4 2134195019201920 q5 5663567357065673 q6 224 142 140 140 q7 2263180517861786 q8 3370353835613538 q9 8912904890759048 q10 3617358935663566 q11 639 506 496 496 q12 814 646 618 618 q13 11535 328032253225 q14 296 270 279 270 q15 585 533 516 516 q16 704 661 644 644 q17 1878165416271627 q18 8283780176047604 q19 1710166015071507 q20 2117188318841883 q21 5557560354595459 q22 661 603 570 570 Total cold run time: 71554 ms Total hot run time: 60493 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] [opt](nereids) flatten compound predicates [doris]
doris-robot commented on PR #44803: URL: https://github.com/apache/doris/pull/44803#issuecomment-2508037227 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] [opt](nereids) flatten compound predicates [doris]
englefly commented on PR #44803: URL: https://github.com/apache/doris/pull/44803#issuecomment-2508038059 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
