Re: [PR] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2635553429 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2614929978 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2612389047 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2612175500 run 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: 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2611725262 run 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: 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2611636015 run 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: 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2611535807 ClickBench: Total hot run time: 31.07 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit b21bc183d3ed44f110aa0cf489b21cef2e603bbe, data reload: false query1 0.040.030.03 query2 0.070.030.03 query3 0.240.060.07 query4 1.630.100.10 query5 0.430.420.41 query6 1.140.650.66 query7 0.020.020.01 query8 0.040.040.03 query9 0.590.510.49 query10 0.560.560.56 query11 0.140.110.11 query12 0.130.110.11 query13 0.610.590.61 query14 2.732.742.83 query15 0.900.840.85 query16 0.370.420.39 query17 1.011.021.07 query18 0.240.210.21 query19 1.921.761.98 query20 0.020.020.01 query21 15.36 0.920.57 query22 0.750.810.73 query23 15.23 1.450.53 query24 3.032.001.45 query25 0.230.130.07 query26 0.280.150.14 query27 0.050.050.05 query28 14.00 1.010.43 query29 12.53 3.873.25 query30 0.260.090.07 query31 2.830.620.39 query32 3.220.540.46 query33 3.013.073.01 query34 16.65 5.144.48 query35 4.574.534.49 query36 0.650.490.47 query37 0.100.060.06 query38 0.040.040.03 query39 0.030.030.02 query40 0.170.130.13 query41 0.080.030.03 query42 0.030.030.03 query43 0.030.030.03 Total cold run time: 105.96 s Total hot run time: 31.07 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2611529259 TPC-DS: Total hot run time: 191863 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 b21bc183d3ed44f110aa0cf489b21cef2e603bbe, data reload: false query1 1305946 943 943 query2 6340203720732037 query3 10946 456245704562 query4 60954 31912 23144 23144 query5 5027615 483 483 query6 442 197 207 197 query7 5495520 303 303 query8 331 249 228 228 query9 7967257025782570 query10 438 312 250 250 query11 15734 15273 15631 15273 query12 165 111 113 111 query13 1383559 430 430 query14 10540 723972987239 query15 215 200 205 200 query16 7287668 498 498 query17 1133740 582 582 query18 1883417 354 354 query19 225 190 168 168 query20 127 121 114 114 query21 215 121 102 102 query22 4432443247674432 query23 34252 33232 33413 33232 query24 5537231722852285 query25 461 456 391 391 query26 645 279 155 155 query27 1607463 343 343 query28 4172248824322432 query29 556 556 438 438 query30 216 193 164 164 query31 947 877 823 823 query32 68 58 57 57 query33 441 352 291 291 query34 723 863 521 521 query35 827 824 759 759 query36 10281043976 976 query37 125 100 76 76 query38 4297436742624262 query39 1490142314501423 query40 224 115 102 102 query41 55 53 59 53 query42 117 107 105 105 query43 513 520 478 478 query44 1327843 851 843 query45 191 175 168 168 query46 860 1040647 647 query47 1878194618201820 query48 376 399 323 323 query49 714 513 385 385 query50 658 683 404 404 query51 4370436743064306 query52 108 103 95 95 query53 232 262 197 197 query54 497 498 419 419 query55 93 84 82 82 query56 266 258 260 258 query57 1202119811161116 query58 246 242 261 242 query59 3053327231083108 query60 280 286 266 266 query61 118 113 114 113 query62 757 747 684 684 query63 234 193 189 189 query64 12531001706 706 query65 3227314531373137 query66 679 397 301 301 query67 15861 15819 15453 15453 query68 5062825 530 530 query69 479 311 252 252 query70 1235112310991099 query71 462 292 260 260 query72 6043383439073834 query73 803 757 373 373 query74 9892893087618761 query75 3225315226792679 query76 37891178743 743 query77 511 358 266 266 query78 10084 10028 92859285 query79 2368796 596 596 query80 688 580 437 437 query81 505 290 244 244 query82 221 146 124 124 query83 186 168 155 155 query84 292 93 75 75 query85 755 411 298 298 query86 368 316 300 300 query87 4497450543694369 query88 3253222721842184 query89 410 327 298 298 query90 1680192 193 192 query91 129 134 109 109 query92 67 56 56 56 query93 1840841 528 528 query94 697 376 289 289 query95 341 274 253 253 query96 487 619 289 289 query97 2790287626882688 query98 219 213 196 196 query99 1280137312531253 Total cold run time: 304023 ms Total hot run time: 191863 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2611513426 TPC-H: Total hot run time: 32445 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit b21bc183d3ed44f110aa0cf489b21cef2e603bbe, data reload: false -- Round 1 -- q1 17570 552853945394 q2 2038307 168 168 q3 10432 1233717 717 q4 10290 958 527 527 q5 8831240721732173 q6 207 163 130 130 q7 925 748 593 593 q8 9232150413031303 q9 5200494749374937 q10 6860234218911891 q11 478 273 257 257 q12 343 355 214 214 q13 17761 372730873087 q14 241 252 207 207 q15 524 486 462 462 q16 637 589 586 586 q17 562 914 326 326 q18 6879649664846484 q19 1656964 537 537 q20 305 313 189 189 q21 2735214719561956 q22 368 337 307 307 Total cold run time: 104074 ms Total hot run time: 32445 ms - Round 2, with runtime_filter_mode=off - q1 5596562456265624 q2 248 327 237 237 q3 2257261123402340 q4 1368179713431343 q5 4298474146364636 q6 179 165 131 131 q7 2051192518111811 q8 2656281227812781 q9 7312719273867192 q10 3088329628302830 q11 578 503 484 484 q12 642 755 588 588 q13 3456392132683268 q14 299 304 270 270 q15 522 476 474 474 q16 643 687 635 635 q17 1274176412461246 q18 7717766272197219 q19 841 123611731173 q20 1969208119211921 q21 5678508648584858 q22 608 620 571 571 Total cold run time: 53280 ms Total hot run time: 51632 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2611391136 run 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: 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2609774075 ClickBench: Total hot run time: 30.39 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit f071567108543cc81fdd0aaed95c01e33b7a7232, data reload: false query1 0.030.030.03 query2 0.080.040.03 query3 0.230.070.07 query4 1.620.100.10 query5 0.420.430.43 query6 1.160.660.65 query7 0.020.020.01 query8 0.050.040.03 query9 0.590.510.50 query10 0.560.570.55 query11 0.140.110.10 query12 0.150.120.11 query13 0.620.600.60 query14 2.722.762.75 query15 0.890.820.82 query16 0.380.400.38 query17 1.001.041.05 query18 0.240.210.21 query19 2.001.971.89 query20 0.010.010.01 query21 15.37 0.980.56 query22 0.750.790.60 query23 15.36 1.430.59 query24 2.610.721.74 query25 0.120.190.11 query26 0.260.140.14 query27 0.070.050.06 query28 14.06 1.020.43 query29 12.58 3.933.25 query30 0.260.100.07 query31 2.800.620.39 query32 3.220.540.45 query33 2.983.023.00 query34 16.93 5.174.45 query35 4.614.474.54 query36 0.630.510.48 query37 0.100.060.06 query38 0.050.040.04 query39 0.030.020.02 query40 0.170.130.13 query41 0.080.030.02 query42 0.040.020.03 query43 0.030.030.03 Total cold run time: 106.02 s Total hot run time: 30.39 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2609762412 TPC-DS: Total hot run time: 184554 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 f071567108543cc81fdd0aaed95c01e33b7a7232, data reload: false query1 966 388 382 382 query2 6534208720292029 query3 6806213 207 207 query4 33474 23374 22865 22865 query5 4307598 434 434 query6 272 191 203 191 query7 4598491 302 302 query8 279 226 221 221 query9 9361254825562548 query10 477 322 252 252 query11 17862 15245 14922 14922 query12 154 114 107 107 query13 1674534 406 406 query14 9322692972716929 query15 222 194 208 194 query16 7980611 460 460 query17 1601754 539 539 query18 2066393 302 302 query19 221 172 144 144 query20 117 110 106 106 query21 214 152 100 100 query22 4189427139723972 query23 34243 33170 33075 33075 query24 6890225722062206 query25 485 458 405 405 query26 770 272 153 153 query27 2066479 337 337 query28 5230240724392407 query29 607 538 423 423 query30 230 189 157 157 query31 923 875 784 784 query32 71 63 60 60 query33 510 357 325 325 query34 727 836 513 513 query35 811 790 724 724 query36 995 1018951 951 query37 124 96 82 82 query38 4194428041454145 query39 1468142315581423 query40 208 112 102 102 query41 53 51 83 51 query42 119 99 104 99 query43 514 524 488 488 query44 1274796 811 796 query45 176 169 163 163 query46 865 1028650 650 query47 1812181317441744 query48 373 388 316 316 query49 746 484 392 392 query50 624 664 399 399 query51 4122422241694169 query52 111 110 90 90 query53 237 257 187 187 query54 496 490 406 406 query55 78 81 80 80 query56 262 263 261 261 query57 1162112411151115 query58 244 231 233 231 query59 2938313728322832 query60 280 275 266 266 query61 144 141 149 141 query62 790 711 674 674 query63 223 192 192 192 query64 35511090711 711 query65 3195315731663157 query66 894 406 333 333 query67 15781 15608 15318 15318 query68 3195837 541 541 query69 483 292 267 267 query70 1254114011261126 query71 367 285 298 285 query72 5848384338783843 query73 656 762 369 369 query74 10055 914290119011 query75 3151315126582658 query76 30371166760 760 query77 459 360 285 285 query78 10207 10009 92549254 query79 1931814 601 601 query80 1618531 439 439 query81 550 276 235 235 query82 356 146 126 126 query83 262 172 158 158 query84 232 103 76 76 query85 756 387 297 297 query86 400 315 276 276 query87 4439451843624362 query88 3866220521752175 query89 381 321 304 304 query90 1648217 193 193 query91 135 141 107 107 query92 57 56 56 56 query93 986 866 541 541 query94 674 401 289 289 query95 339 266 259 259 query96 486 604 276 276 query97 2775286427582758 query98 227 201 196 196 query99 1265138912861286 Total cold run time: 276407 ms Total hot run time: 184554 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2609738429 TPC-H: Total hot run time: 32364 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit f071567108543cc81fdd0aaed95c01e33b7a7232, data reload: false -- Round 1 -- q1 17608 549553405340 q2 2048303 167 167 q3 10422 1266751 751 q4 10234 967 546 546 q5 7577248021742174 q6 200 169 138 138 q7 906 758 616 616 q8 9227137411881188 q9 5267489049134890 q10 6819236219081908 q11 465 270 259 259 q12 349 349 220 220 q13 17773 370130713071 q14 230 219 206 206 q15 516 485 464 464 q16 649 612 608 608 q17 584 874 325 325 q18 7207653764646464 q19 1662969 533 533 q20 313 316 194 194 q21 2801218619891989 q22 370 328 313 313 Total cold run time: 103227 ms Total hot run time: 32364 ms - Round 2, with runtime_filter_mode=off - q1 5534549354875487 q2 242 327 230 230 q3 2269259223402340 q4 1411180114151415 q5 4362475846954695 q6 162 158 122 122 q7 2077201418211821 q8 2675282626802680 q9 7225721273157212 q10 2948325527552755 q11 575 514 501 501 q12 659 766 603 603 q13 3455386533183318 q14 278 312 284 284 q15 521 465 462 462 q16 637 693 658 658 q17 1220175712391239 q18 7673756172537253 q19 782 114211471142 q20 2013209419021902 q21 5551525749054905 q22 584 610 528 528 Total cold run time: 52853 ms Total hot run time: 51552 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2609596617 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2609188091 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2606988256 ClickBench: Total hot run time: 30.89 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 268b001f652541c42a1168415ec12b354cb0c269, data reload: false query1 0.030.030.04 query2 0.060.040.02 query3 0.230.070.06 query4 1.620.110.11 query5 0.420.420.40 query6 1.170.660.66 query7 0.020.010.01 query8 0.040.030.03 query9 0.590.510.50 query10 0.550.560.55 query11 0.150.100.10 query12 0.140.110.11 query13 0.610.600.60 query14 2.712.712.73 query15 0.890.830.84 query16 0.390.380.40 query17 1.031.071.04 query18 0.230.210.21 query19 1.991.861.95 query20 0.010.010.01 query21 15.35 0.930.60 query22 0.750.820.59 query23 15.35 1.430.59 query24 3.001.511.16 query25 0.250.060.08 query26 0.290.150.14 query27 0.070.060.04 query28 14.19 1.040.43 query29 12.58 4.003.30 query30 0.250.090.06 query31 2.820.590.39 query32 3.220.560.46 query33 2.993.033.01 query34 16.63 5.224.51 query35 4.594.554.53 query36 0.640.490.49 query37 0.090.060.06 query38 0.050.040.03 query39 0.040.020.02 query40 0.170.130.13 query41 0.080.020.02 query42 0.030.030.02 query43 0.040.040.03 Total cold run time: 106.35 s Total hot run time: 30.89 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2606977143 TPC-DS: Total hot run time: 194193 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 268b001f652541c42a1168415ec12b354cb0c269, data reload: false query1 1289955 926 926 query2 6348210220802080 query3 11101 444647134446 query4 61407 29026 22798 22798 query5 5575600 474 474 query6 437 213 190 190 query7 5521525 301 301 query8 341 241 244 241 query9 8369269826432643 query10 441 333 244 244 query11 17413 15027 15570 15027 query12 167 110 115 110 query13 1397516 430 430 query14 11521 693569076907 query15 211 210 198 198 query16 7198650 488 488 query17 1070723 563 563 query18 1894403 328 328 query19 202 180 161 161 query20 125 114 109 109 query21 218 123 116 116 query22 4555474246364636 query23 34288 33529 33146 33146 query24 5483231122812281 query25 462 447 390 390 query26 654 268 152 152 query27 1821477 349 349 query28 4235255324692469 query29 538 570 418 418 query30 208 194 157 157 query31 920 881 855 855 query32 68 56 55 55 query33 459 354 304 304 query34 740 889 536 536 query35 820 817 775 775 query36 10191037977 977 query37 132 104 84 84 query38 4263432443154315 query39 1476142314401423 query40 206 117 105 105 query41 51 49 50 49 query42 124 103 142 103 query43 541 544 497 497 query44 1266820 826 820 query45 182 174 166 166 query46 877 1070675 675 query47 1986194818921892 query48 392 407 332 332 query49 704 487 399 399 query50 654 674 409 409 query51 7061707569636963 query52 105 104 92 92 query53 236 262 183 183 query54 483 508 410 410 query55 81 82 82 82 query56 261 261 249 249 query57 1195123411331133 query58 265 235 242 235 query59 3122329931503150 query60 282 281 266 266 query61 147 142 138 138 query62 750 723 660 660 query63 219 186 183 183 query64 1258997 643 643 query65 3266314631783146 query66 716 385 301 301 query67 15987 15874 15483 15483 query68 5062770 581 581 query69 493 303 268 268 query70 1205116211281128 query71 396 289 253 253 query72 6068387138923871 query73 805 753 357 357 query74 10255 888489228884 query75 3210325326642664 query76 37461185751 751 query77 472 357 279 279 query78 10105 993892629262 query79 3132795 602 602 query80 689 520 459 459 query81 514 271 240 240 query82 568 222 123 123 query83 169 167 160 160 query84 291 99 70 70 query85 779 372 305 305 query86 382 312 290 290 query87 4430460344164416 query88 4758219021852185 query89 397 325 288 288 query90 1648190 191 190 query91 131 140 112 112 query92 68 56 59 56 query93 2869862 532 532 query94 717 401 292 292 query95 335 257 249 249 query96 492 604 296 296 query97 2861283127252725 query98 228 208 193 193 query99 1301135312461246 Total cold run time: 315379 ms Total hot run time: 194193 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2606949955 TPC-H: Total hot run time: 32376 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 268b001f652541c42a1168415ec12b354cb0c269, data reload: false -- Round 1 -- q1 17645 555853895389 q2 2060313 185 185 q3 10475 1256749 749 q4 10222 974 526 526 q5 7838239821632163 q6 194 176 132 132 q7 907 759 600 600 q8 9260136411611161 q9 5240493249464932 q10 6827232418871887 q11 464 277 252 252 q12 343 352 221 221 q13 17760 368330893089 q14 238 237 210 210 q15 526 479 468 468 q16 636 616 590 590 q17 573 880 328 328 q18 7137649664606460 q19 1861947 560 560 q20 326 319 185 185 q21 3060229019731973 q22 371 341 316 316 Total cold run time: 103963 ms Total hot run time: 32376 ms - Round 2, with runtime_filter_mode=off - q1 5589554555045504 q2 238 332 231 231 q3 2259268923452345 q4 1541183513751375 q5 4338476247034703 q6 178 162 129 129 q7 2134198018421842 q8 2641286827072707 q9 7379735673597356 q10 2999334127322732 q11 564 507 490 490 q12 656 755 637 637 q13 3524391932753275 q14 293 298 296 296 q15 518 472 459 459 q16 643 710 646 646 q17 1266171812721272 q18 7870750073367336 q19 810 108910931089 q20 2012207719361936 q21 5840527649334933 q22 628 631 572 572 Total cold run time: 53920 ms Total hot run time: 51865 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2606747544 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2606685277 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2606281536 TPC-DS: Total hot run time: 186738 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 bb5ff7c9afe5ca518fb4472ca590d2bc29cd9ab7, data reload: false query1 965 396 372 372 query2 6517196119501950 query3 6791224 223 223 query4 33904 23469 23083 23083 query5 4385623 495 495 query6 286 190 170 170 query7 4608482 301 301 query8 281 228 217 217 query9 9379257825722572 query10 485 303 233 233 query11 17854 15238 14876 14876 query12 156 107 101 101 query13 1636504 423 423 query14 9997638565016385 query15 211 203 187 187 query16 7798596 475 475 query17 1571716 541 541 query18 1972401 296 296 query19 200 183 151 151 query20 118 110 110 110 query21 218 124 103 103 query22 4350429143944291 query23 33924 33142 33849 33142 query24 6598221022142210 query25 463 433 380 380 query26 1056248 152 152 query27 2106475 329 329 query28 5371240224292402 query29 523 523 439 439 query30 233 188 150 150 query31 1092849 808 808 query32 81 62 59 59 query33 544 341 310 310 query34 739 856 492 492 query35 857 838 754 754 query36 997 1020935 935 query37 119 94 79 79 query38 4136419641024102 query39 1452137414041374 query40 210 114 102 102 query41 53 55 49 49 query42 121 103 101 101 query43 505 512 475 475 query44 1315805 798 798 query45 178 186 165 165 query46 851 1032637 637 query47 1874186118131813 query48 388 394 298 298 query49 776 510 435 435 query50 629 695 384 384 query51 6967689469576894 query52 103 126 92 92 query53 226 247 184 184 query54 481 488 412 412 query55 82 82 80 80 query56 255 269 242 242 query57 1135115610941094 query58 253 233 243 233 query59 2986300228852885 query60 303 284 254 254 query61 122 120 125 120 query62 811 714 674 674 query63 221 191 191 191 query64 43081004723 723 query65 3284316031603160 query66 1076440 318 318 query67 15781 15678 15440 15440 query68 4297823 542 542 query69 463 359 262 262 query70 1197115610801080 query71 381 276 254 254 query72 5778377838503778 query73 632 745 376 376 query74 9929903786238623 query75 3179315526932693 query76 32101169776 776 query77 472 379 288 288 query78 997310002 92689268 query79 3610801 573 573 query80 722 528 436 436 query81 518 292 240 240 query82 623 159 124 124 query83 172 168 155 155 query84 246 109 76 76 query85 782 364 300 300 query86 396 325 304 304 query87 4458436644454366 query88 4849220121342134 query89 396 338 299 299 query90 1807191 192 191 query91 130 139 106 106 query92 70 55 55 55 query93 2361868 521 521 query94 703 391 263 263 query95 354 262 261 261 query96 500 616 283 283 query97 2789286927312731 query98 231 201 191 191 query99 1330139012641264 Total cold run time: 285825 ms Total hot run time: 186738 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2606269291 TPC-H: Total hot run time: 32467 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit bb5ff7c9afe5ca518fb4472ca590d2bc29cd9ab7, data reload: false -- Round 1 -- q1 17605 545553665366 q2 2048296 168 168 q3 10432 1256700 700 q4 10217 962 548 548 q5 7546237421952195 q6 192 172 136 136 q7 902 769 606 606 q8 9228135911781178 q9 5362497249684968 q10 6844234619011901 q11 501 275 266 266 q12 353 361 221 221 q13 17784 368931293129 q14 250 232 214 214 q15 516 467 459 459 q16 619 615 584 584 q17 557 869 323 323 q18 7083649565146495 q19 1201951 523 523 q20 324 324 194 194 q21 3063219919761976 q22 378 340 317 317 Total cold run time: 103005 ms Total hot run time: 32467 ms - Round 2, with runtime_filter_mode=off - q1 5444544454675444 q2 239 328 247 247 q3 2258269122842284 q4 1444184214211421 q5 4393473346394639 q6 163 157 127 127 q7 2095205718551855 q8 2694280926452645 q9 7266724773607247 q10 2988350528332833 q11 592 536 494 494 q12 666 755 605 605 q13 3527387232123212 q14 295 298 287 287 q15 533 474 462 462 q16 671 676 669 669 q17 1211173912791279 q18 7668745273237323 q19 786 102011261020 q20 2006201618751875 q21 5712532850615061 q22 614 661 567 567 Total cold run time: 53265 ms Total hot run time: 51596 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2606246818 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2606247261 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2604623268 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2595006017 ClickBench: Total hot run time: 31.22 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 6ed5949adee5e86570b1993a54d78e623323bff7, data reload: false query1 0.030.050.03 query2 0.070.040.03 query3 0.230.080.07 query4 1.610.110.10 query5 0.430.420.39 query6 1.150.650.66 query7 0.020.010.02 query8 0.030.030.03 query9 0.590.510.50 query10 0.550.570.57 query11 0.140.100.10 query12 0.140.110.10 query13 0.620.600.60 query14 2.732.802.75 query15 0.900.830.84 query16 0.400.370.38 query17 0.991.061.08 query18 0.230.210.21 query19 1.941.871.93 query20 0.020.010.01 query21 15.36 0.940.59 query22 0.750.790.87 query23 15.09 1.500.62 query24 2.851.721.21 query25 0.170.180.05 query26 0.220.140.13 query27 0.060.050.04 query28 14.19 1.020.44 query29 12.56 3.943.27 query30 0.250.100.07 query31 2.820.590.38 query32 3.220.550.46 query33 2.993.113.04 query34 16.69 5.184.56 query35 4.564.604.50 query36 0.650.500.48 query37 0.100.060.06 query38 0.040.040.04 query39 0.030.020.02 query40 0.170.140.12 query41 0.080.030.02 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 105.75 s Total hot run time: 31.22 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594993867 TPC-DS: Total hot run time: 193999 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 6ed5949adee5e86570b1993a54d78e623323bff7, data reload: false query1 1329960 944 944 query2 6483199720151997 query3 11122 471844874487 query4 32830 23392 22936 22936 query5 3665600 476 476 query6 287 201 205 201 query7 3976489 298 298 query8 300 232 224 224 query9 9245262626342626 query10 452 303 241 241 query11 18186 15213 15090 15090 query12 163 111 112 111 query13 1553533 418 418 query14 10080 695969276927 query15 263 234 180 180 query16 7896654 516 516 query17 1583763 603 603 query18 2135434 311 311 query19 204 192 170 170 query20 131 136 120 120 query21 213 129 106 106 query22 4654455044204420 query23 34478 33814 33440 33440 query24 6829239023502350 query25 479 460 421 421 query26 862 278 154 154 query27 2199462 329 329 query28 5532247424812474 query29 648 553 419 419 query30 252 195 155 155 query31 948 881 809 809 query32 77 63 59 59 query33 478 352 310 310 query34 779 895 509 509 query35 806 828 740 740 query36 10451063929 929 query37 122 96 75 75 query38 4366434242704270 query39 1518145514531453 query40 214 116 105 105 query41 51 52 54 52 query42 115 103 115 103 query43 514 535 478 478 query44 1409828 819 819 query45 181 173 170 170 query46 855 1041641 641 query47 1894190118491849 query48 393 423 348 348 query49 739 494 416 416 query50 646 662 392 392 query51 7040709369776977 query52 103 106 94 94 query53 222 249 186 186 query54 504 499 437 437 query55 82 81 78 78 query56 265 267 250 250 query57 1222119511311131 query58 249 243 238 238 query59 3147315130963096 query60 281 272 290 272 query61 148 118 114 114 query62 768 730 696 696 query63 231 192 189 189 query64 3396987 625 625 query65 3277318931493149 query66 783 423 297 297 query67 16069 15602 15362 15362 query68 5858811 511 511 query69 495 286 314 286 query70 1175114111481141 query71 386 286 250 250 query72 5821385138413841 query73 636 761 357 357 query74 10103 921688938893 query75 3174315626352635 query76 31321167770 770 query77 471 352 279 279 query78 988210040 93039303 query79 3174812 581 581 query80 662 537 443 443 query81 508 278 237 237 query82 569 149 121 121 query83 185 167 150 150 query84 238 101 77 77 query85 770 372 292 292 query86 398 335 303 303 query87 4498450043254325 query88 4704216921472147 query89 412 330 296 296 query90 1791191 187 187 query91 133 147 114 114 query92 67 56 50 50 query93 2124871 522 522 query94 687 409 304 304 query95 331 268 257 257 query96 496 610 280 280 query97 2823288927362736 query98 217 210 194 194 query99 1304137912551255 Total cold run time: 290190 ms Total hot run time: 193999 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594966969 TPC-H: Total hot run time: 32247 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 6ed5949adee5e86570b1993a54d78e623323bff7, data reload: false -- Round 1 -- q1 17572 545054175417 q2 2052307 180 180 q3 10456 1229724 724 q4 10213 965 525 525 q5 7520239021512151 q6 211 168 132 132 q7 913 735 596 596 q8 9223131810881088 q9 5203491848584858 q10 6825230419131913 q11 481 277 262 262 q12 344 358 221 221 q13 17781 370831513151 q14 229 231 217 217 q15 508 470 477 470 q16 628 603 599 599 q17 571 853 328 328 q18 6907643866066438 q19 1681956 532 532 q20 308 320 193 193 q21 2954216919491949 q22 374 330 303 303 Total cold run time: 102954 ms Total hot run time: 32247 ms - Round 2, with runtime_filter_mode=off - q1 5518548255415482 q2 249 332 243 243 q3 2248265923452345 q4 1425186313781378 q5 4271469246484648 q6 169 158 125 125 q7 2031199818001800 q8 2628278226802680 q9 7447727774087277 q10 3062328928402840 q11 581 512 515 512 q12 634 738 574 574 q13 3521390432403240 q14 275 302 281 281 q15 528 475 460 460 q16 656 703 646 646 q17 1223173412811281 q18 7734735274727352 q19 812 121010881088 q20 2004203518661866 q21 5766524049964996 q22 631 643 577 577 Total cold run time: 53413 ms Total hot run time: 51691 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594819674 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594762410 ClickBench: Total hot run time: 31.09 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 270fdcdb5c947b9cdacc0fc7997f177454236a83, data reload: false query1 0.030.030.03 query2 0.070.040.03 query3 0.240.070.07 query4 1.620.110.11 query5 0.430.400.39 query6 1.140.640.65 query7 0.020.010.01 query8 0.040.040.02 query9 0.570.500.50 query10 0.550.560.54 query11 0.130.100.10 query12 0.140.110.12 query13 0.610.600.61 query14 2.842.722.71 query15 0.880.820.82 query16 0.380.380.37 query17 1.061.071.04 query18 0.220.210.21 query19 1.901.861.94 query20 0.020.010.01 query21 15.36 0.910.61 query22 0.750.820.61 query23 15.32 1.430.58 query24 2.941.561.30 query25 0.210.110.09 query26 0.260.140.14 query27 0.040.080.05 query28 13.90 1.040.43 query29 12.58 3.953.32 query30 0.240.090.07 query31 2.830.610.39 query32 3.220.550.46 query33 2.983.083.01 query34 16.67 5.174.53 query35 4.564.604.54 query36 0.640.510.50 query37 0.090.060.06 query38 0.040.040.03 query39 0.030.020.03 query40 0.170.140.12 query41 0.070.020.02 query42 0.040.030.02 query43 0.030.040.02 Total cold run time: 105.86 s Total hot run time: 31.09 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594754158 TPC-DS: Total hot run time: 193877 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 270fdcdb5c947b9cdacc0fc7997f177454236a83, data reload: false query1 1324951 951 951 query2 6413201720332017 query3 11051 459446514594 query4 33036 23269 23197 23197 query5 3508617 449 449 query6 272 183 196 183 query7 3979484 298 298 query8 286 233 212 212 query9 9424266826332633 query10 449 308 243 243 query11 17616 15161 14905 14905 query12 140 109 104 104 query13 1566543 390 390 query14 8639706164436443 query15 226 203 191 191 query16 7941662 517 517 query17 1626765 606 606 query18 2142433 344 344 query19 228 196 173 173 query20 133 129 126 126 query21 212 130 106 106 query22 4461445643094309 query23 34522 33502 33675 33502 query24 6354231622572257 query25 512 455 400 400 query26 813 278 159 159 query27 2111446 338 338 query28 5951248525082485 query29 639 552 430 430 query30 213 191 179 179 query31 919 881 826 826 query32 74 57 60 57 query33 498 371 285 285 query34 757 857 506 506 query35 792 843 769 769 query36 10391045985 985 query37 122 112 79 79 query38 4358427343504273 query39 1493143514071407 query40 211 118 98 98 query41 51 49 48 48 query42 117 102 111 102 query43 518 518 480 480 query44 1369837 825 825 query45 184 177 167 167 query46 877 1057641 641 query47 1927192918721872 query48 397 417 333 333 query49 727 532 406 406 query50 685 677 402 402 query51 7130700170137001 query52 103 114 91 91 query53 225 261 183 183 query54 501 495 417 417 query55 83 80 84 80 query56 256 273 250 250 query57 1240119511491149 query58 254 242 272 242 query59 3083323430153015 query60 286 274 255 255 query61 119 113 116 113 query62 779 731 701 701 query63 227 185 191 185 query64 33841069680 680 query65 3282314031503140 query66 795 399 291 291 query67 15823 15800 15487 15487 query68 3844834 519 519 query69 476 291 264 264 query70 1143115911551155 query71 394 280 257 257 query72 6195383537723772 query73 652 757 361 361 query74 10136 912891369128 query75 3205316826572657 query76 30291186761 761 query77 481 364 270 270 query78 10052 997392359235 query79 4096794 580 580 query80 720 525 424 424 query81 504 277 243 243 query82 691 158 125 125 query83 183 174 154 154 query84 247 137 72 72 query85 768 351 301 301 query86 398 330 307 307 query87 4514443143644364 query88 4956216621562156 query89 402 325 289 289 query90 1791188 181 181 query91 131 130 106 106 query92 64 56 51 51 query93 2719878 518 518 query94 689 392 305 305 query95 333 261 254 254 query96 493 618 288 288 query97 2794286027452745 query98 225 205 195 195 query99 1414136712581258 Total cold run time: 288211 ms Total hot run time: 193877 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594735604 TPC-H: Total hot run time: 32241 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 270fdcdb5c947b9cdacc0fc7997f177454236a83, data reload: false -- Round 1 -- q1 17587 554154055405 q2 2058292 174 174 q3 10452 1215743 743 q4 10388 967 516 516 q5 9302234921422142 q6 199 168 135 135 q7 904 751 603 603 q8 9251138411801180 q9 5203497148684868 q10 6866232618881888 q11 473 272 257 257 q12 344 356 216 216 q13 17780 372130923092 q14 225 233 213 213 q15 515 474 474 474 q16 627 630 588 588 q17 565 839 325 325 q18 6839642365656423 q19 3289951 524 524 q20 291 313 197 197 q21 2778214219711971 q22 369 338 307 307 Total cold run time: 106305 ms Total hot run time: 32241 ms - Round 2, with runtime_filter_mode=off - q1 5621548854865486 q2 241 325 236 236 q3 2233266423522352 q4 1459181613901390 q5 4300475247864752 q6 170 166 129 129 q7 2051199218171817 q8 2635284026892689 q9 7348725173037251 q10 3047328827032703 q11 568 520 484 484 q12 753 772 638 638 q13 3489392133623362 q14 300 289 267 267 q15 519 477 471 471 q16 656 680 651 651 q17 1250173712961296 q18 7733745872997299 q19 814 931 1158931 q20 1984204618941894 q21 5693520851045104 q22 608 625 568 568 Total cold run time: 53472 ms Total hot run time: 51770 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594702597 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594537394 ClickBench: Total hot run time: 30.49 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit a0a2765f5455eda1751e12fd6f901ee1893dff5a, data reload: false query1 0.040.040.06 query2 0.070.030.03 query3 0.240.070.07 query4 1.600.100.10 query5 0.440.390.40 query6 1.140.660.65 query7 0.020.010.02 query8 0.040.040.04 query9 0.570.520.52 query10 0.590.580.57 query11 0.150.110.11 query12 0.140.110.12 query13 0.620.600.59 query14 2.842.782.73 query15 0.900.840.83 query16 0.380.360.37 query17 0.961.051.04 query18 0.230.210.22 query19 1.881.891.98 query20 0.010.020.01 query21 15.35 0.920.58 query22 0.760.800.69 query23 15.31 1.400.54 query24 2.860.472.25 query25 0.280.130.26 query26 0.250.140.14 query27 0.050.070.04 query28 13.83 0.980.44 query29 12.62 4.023.29 query30 0.250.100.06 query31 2.820.600.39 query32 3.220.550.46 query33 3.003.053.13 query34 16.76 5.154.58 query35 4.604.564.59 query36 0.660.500.48 query37 0.090.060.07 query38 0.050.040.03 query39 0.030.020.03 query40 0.160.130.12 query41 0.080.020.02 query42 0.030.030.02 query43 0.030.020.02 Total cold run time: 105.95 s Total hot run time: 30.49 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594532280 TPC-DS: Total hot run time: 187486 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 a0a2765f5455eda1751e12fd6f901ee1893dff5a, data reload: false query1 977 382 380 380 query2 6541203220082008 query3 6787215 229 215 query4 33898 23312 22880 22880 query5 4421619 479 479 query6 293 205 186 186 query7 4601496 308 308 query8 303 249 238 238 query9 9630268426812681 query10 453 323 251 251 query11 17835 15236 14891 14891 query12 159 110 108 108 query13 1706518 416 416 query14 9462646777426467 query15 263 196 193 193 query16 8537646 458 458 query17 1666727 555 555 query18 2090392 292 292 query19 226 177 180 177 query20 116 108 107 107 query21 208 123 103 103 query22 4219441143194319 query23 34104 32861 33181 32861 query24 6694232523382325 query25 506 460 379 379 query26 1180276 151 151 query27 2051463 332 332 query28 5320248324262426 query29 721 544 420 420 query30 228 190 158 158 query31 962 908 805 805 query32 93 63 58 58 query33 544 346 307 307 query34 759 836 499 499 query35 811 814 756 756 query36 10231010950 950 query37 152 105 75 75 query38 4146412240804080 query39 1461142214141414 query40 204 117 102 102 query41 55 55 52 52 query42 125 107 103 103 query43 508 530 483 483 query44 1338822 817 817 query45 183 181 164 164 query46 870 1041641 641 query47 1867185117751775 query48 387 401 327 327 query49 790 487 398 398 query50 650 658 404 404 query51 6899689568766876 query52 104 106 93 93 query53 225 252 195 195 query54 490 500 398 398 query55 84 88 81 81 query56 261 288 263 263 query57 1170114610611061 query58 248 225 237 225 query59 3022310728282828 query60 277 312 257 257 query61 121 121 126 121 query62 804 751 662 662 query63 230 191 186 186 query64 42091008655 655 query65 3254316931893169 query66 1082431 312 312 query67 16016 15900 15435 15435 query68 4319824 537 537 query69 486 293 256 256 query70 1230118111601160 query71 394 284 259 259 query72 5860391139703911 query73 666 762 360 360 query74 10262 896789938967 query75 3156319826882688 query76 31581147768 768 query77 506 387 275 275 query78 10063 993094509450 query79 3037807 602 602 query80 1696527 446 446 query81 576 272 244 244 query82 369 155 122 122 query83 272 172 150 150 query84 239 95 78 78 query85 783 343 300 300 query86 480 317 307 307 query87 4566467544614461 query88 4539220721552155 query89 396 358 295 295 query90 1835187 189 187 query91 143 147 108 108 query92 73 59 57 57 query93 2795890 532 532 query94 751 407 305 305 query95 386 269 254 254 query96 506 616 284 284 query97 2767291527212721 query98 237 196 193 193 query99 1297138612631263 Total cold run time: 288462 ms Total hot run time: 187486 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594473635 TPC-H: Total hot run time: 32622 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit a0a2765f5455eda1751e12fd6f901ee1893dff5a, data reload: false -- Round 1 -- q1 17659 566053545354 q2 2046304 183 183 q3 10529 1301741 741 q4 10267 979 535 535 q5 8558240322162216 q6 201 166 135 135 q7 912 751 628 628 q8 9255139811771177 q9 6039504749794979 q10 6871236519021902 q11 482 290 274 274 q12 354 372 230 230 q13 1 375331283128 q14 244 236 210 210 q15 516 473 482 473 q16 625 620 588 588 q17 597 881 331 331 q18 7143653763726372 q19 1499960 564 564 q20 330 344 201 201 q21 3002233320742074 q22 377 339 327 327 Total cold run time: 105283 ms Total hot run time: 32622 ms - Round 2, with runtime_filter_mode=off - q1 5552552655685526 q2 243 343 236 236 q3 2279269423232323 q4 1458189614061406 q5 4338477948854779 q6 171 164 130 130 q7 2095203218631863 q8 2657286627352735 q9 7280731772377237 q10 3042325727772777 q11 580 528 507 507 q12 687 784 592 592 q13 35613901 q14 273 296 282 282 q15 514 490 467 467 q16 650 697 636 636 q17 1266174512921292 q18 7732749772757275 q19 864 117610801080 q20 1956204919031903 q21 5778545350105010 q22 587 605 561 561 Total cold run time: 53563 ms Total hot run time: 51950 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594445176 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2594438825 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2566454038 ClickBench: Total hot run time: 31.76 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit bfad26cc257f8f516650de417d4c4713ed750d2f, data reload: false query1 0.030.030.04 query2 0.070.030.04 query3 0.240.080.07 query4 1.620.100.10 query5 0.430.420.40 query6 1.150.660.65 query7 0.020.010.01 query8 0.040.030.03 query9 0.580.500.50 query10 0.550.560.55 query11 0.140.100.10 query12 0.140.110.12 query13 0.610.610.60 query14 2.742.782.88 query15 0.910.830.83 query16 0.370.390.38 query17 1.081.051.08 query18 0.220.200.20 query19 1.941.801.95 query20 0.010.010.01 query21 15.39 0.950.60 query22 0.750.780.63 query23 15.36 1.470.56 query24 2.931.201.74 query25 0.160.140.21 query26 0.290.140.14 query27 0.050.040.05 query28 14.42 1.511.06 query29 12.60 3.923.25 query30 0.250.090.07 query31 2.820.600.38 query32 3.230.530.46 query33 3.073.183.18 query34 16.75 5.204.56 query35 4.494.454.60 query36 0.650.490.49 query37 0.090.070.06 query38 0.050.040.04 query39 0.030.020.03 query40 0.170.140.13 query41 0.090.020.02 query42 0.040.030.02 query43 0.040.030.03 Total cold run time: 106.61 s Total hot run time: 31.76 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2566450522 TPC-DS: Total hot run time: 197216 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 bfad26cc257f8f516650de417d4c4713ed750d2f, data reload: false query1 1321975 913 913 query2 6358242923772377 query3 11122 453548944535 query4 32987 23767 23598 23598 query5 3756581 425 425 query6 271 198 201 198 query7 3994511 319 319 query8 308 261 240 240 query9 9358273827342734 query10 442 324 243 243 query11 18029 15304 15753 15304 query12 165 108 103 103 query13 1668522 405 405 query14 11518 690476786904 query15 247 217 192 192 query16 7947639 512 512 query17 1541763 600 600 query18 2072400 308 308 query19 192 187 159 159 query20 132 115 111 111 query21 206 122 109 109 query22 4752460245164516 query23 34784 33479 34068 33479 query24 6486230423762304 query25 482 454 393 393 query26 740 275 168 168 query27 2225459 341 341 query28 5494250325102503 query29 649 552 416 416 query30 217 190 154 154 query31 1020924 833 833 query32 96 62 57 57 query33 535 358 292 292 query34 794 853 534 534 query35 793 850 761 761 query36 10541061960 960 query37 118 106 78 78 query38 4331412942754129 query39 1496147114721471 query40 212 125 107 107 query41 47 46 42 42 query42 118 108 105 105 query43 531 547 509 509 query44 1318845 817 817 query45 180 176 181 176 query46 881 1067658 658 query47 2019200819641964 query48 395 417 320 320 query49 717 488 388 388 query50 647 684 399 399 query51 7279723371997199 query52 103 105 97 97 query53 229 250 185 185 query54 493 521 413 413 query55 82 91 78 78 query56 261 263 253 253 query57 1277124811661166 query58 269 219 234 219 query59 3395353132713271 query60 283 278 265 265 query61 130 153 112 112 query62 837 810 761 761 query63 228 204 194 194 query64 35891031649 649 query65 3328327532663266 query66 711 421 312 312 query67 16479 15678 15531 15531 query68 8579760 527 527 query69 483 295 249 249 query70 1192114011671140 query71 443 284 256 256 query72 6222393838493849 query73 667 773 364 364 query74 10121 941993559355 query75 4032313926432643 query76 36241203830 830 query77 744 376 279 279 query78 10029 10203 93539353 query79 3462921 588 588 query80 748 618 442 442 query81 500 283 234 234 query82 643 159 116 116 query83 191 163 148 148 query84 272 87 77 77 query85 761 358 303 303 query86 359 322 308 308 query87 4586442645834426 query88 4243223122232223 query89 425 340 288 288 query90 1835195 189 189 query91 183 141 105 105 query92 62 59 52 52 query93 1310897 527 527 query94 638 416 309 309 query95 332 274 256 256 query96 491 626 293 293 query97 2741283326892689 query98 220 199 202 199 query99 1706159414651465 Total cold run time: 297582 ms Total hot run time: 197216 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] [enhance](nereids) add eliminate order by key by uniform [doris]
doris-robot commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2566442076 TPC-H: Total hot run time: 32281 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit bfad26cc257f8f516650de417d4c4713ed750d2f, data reload: false -- Round 1 -- q1 17573 684260476047 q2 2049308 178 178 q3 10427 1212728 728 q4 10208 870 439 439 q5 7521217619751975 q6 208 178 145 145 q7 892 763 606 606 q8 9243136211511151 q9 5262487449534874 q10 6738230718351835 q11 470 278 262 262 q12 345 357 221 221 q13 17778 357729242924 q14 230 228 209 209 q15 551 505 510 505 q16 631 617 598 598 q17 560 840 323 323 q18 6968640563116311 q19 2133952 550 550 q20 309 308 182 182 q21 2842216519091909 q22 366 335 309 309 Total cold run time: 103304 ms Total hot run time: 32281 ms - Round 2, with runtime_filter_mode=off - q1 6292624862236223 q2 238 326 233 233 q3 2248265022592259 q4 1435184613921392 q5 4361474747644747 q6 186 175 142 142 q7 2078195118401840 q8 2639283826682668 q9 7354727273447272 q10 3088339828702870 q11 571 515 518 515 q12 657 757 621 621 q13 3367374731393139 q14 307 299 286 286 q15 567 509 508 508 q16 671 663 656 656 q17 1212173512511251 q18 7676748373507350 q19 823 118010681068 q20 2032202918341834 q21 5660531448904890 q22 597 623 566 566 Total cold run time: 54059 ms Total hot run time: 52330 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] [enhance](nereids) add eliminate order by key by uniform [doris]
feiniaofeiafei commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2566411641 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] [enhance](nereids) add eliminate order by key by uniform [doris]
hello-stephen commented on PR #46225: URL: https://github.com/apache/doris/pull/46225#issuecomment-2566410334 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
