Re: [PR] branch-3.0: [fix](Nereids) we should also push down expr in join's mark conjuncts #50886 [doris]
dataroaring merged PR #50954: URL: https://github.com/apache/doris/pull/50954 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] branch-3.0: [fix](Nereids) we should also push down expr in join's mark conjuncts #50886 [doris]
doris-robot commented on PR #50954: URL: https://github.com/apache/doris/pull/50954#issuecomment-2939802110 ClickBench: Total hot run time: 30.08 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1c90c4d45ebc8df924513cfe9c14bc0de42ebbef, data reload: false query1 0.030.030.03 query2 0.060.030.03 query3 0.240.060.06 query4 1.630.100.10 query5 0.520.520.51 query6 1.140.730.74 query7 0.020.020.02 query8 0.040.030.04 query9 0.560.510.50 query10 0.560.560.55 query11 0.130.100.12 query12 0.150.110.10 query13 0.620.600.59 query14 0.770.790.78 query15 0.840.820.83 query16 0.380.390.38 query17 1.011.001.00 query18 0.230.220.22 query19 1.851.781.87 query20 0.020.010.01 query21 15.40 0.610.60 query22 2.621.872.78 query23 16.97 0.930.79 query24 2.741.290.87 query25 0.190.250.13 query26 0.330.140.14 query27 0.040.050.04 query28 10.59 0.560.45 query29 12.61 3.213.17 query30 0.250.060.07 query31 2.850.390.38 query32 3.220.470.46 query33 2.963.062.95 query34 16.82 4.524.53 query35 4.564.534.61 query36 0.690.480.48 query37 0.090.060.06 query38 0.040.030.04 query39 0.030.020.02 query40 0.160.130.12 query41 0.080.020.02 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 104.12 s Total hot run time: 30.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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] branch-3.0: [fix](Nereids) we should also push down expr in join's mark conjuncts #50886 [doris]
doris-robot commented on PR #50954: URL: https://github.com/apache/doris/pull/50954#issuecomment-2939785944 TPC-DS: Total hot run time: 196748 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 1c90c4d45ebc8df924513cfe9c14bc0de42ebbef, data reload: false query1 1292917 912 912 query2 6336196018591859 query3 10949 434443414341 query4 61039 28956 23595 23595 query5 5191458 451 451 query6 408 180 183 180 query7 5495318 312 312 query8 309 223 220 220 query9 8442260325802580 query10 468 259 275 259 query11 18146 15136 16052 15136 query12 158 103 105 103 query13 1442443 442 442 query14 10434 675771866757 query15 205 184 176 176 query16 7131510 499 499 query17 1139584 577 577 query18 1870339 307 307 query19 200 160 163 160 query20 121 120 114 114 query21 209 109 105 105 query22 4636461647154616 query23 34529 33966 34146 33966 query24 6240298130072981 query25 534 433 422 422 query26 655 171 166 166 query27 1856383 377 377 query28 3943218821802180 query29 719 488 444 444 query30 245 171 167 167 query31 1008822 838 822 query32 72 55 61 55 query33 481 301 299 299 query34 919 539 539 539 query35 836 718 722 718 query36 1109963 950 950 query37 109 68 64 64 query38 4007399339993993 query39 1524147014611461 query40 212 99 98 98 query41 47 46 51 46 query42 111 100 99 99 query43 548 482 474 474 query44 1168859 826 826 query45 187 165 170 165 query46 1152737 717 717 query47 2027194419641944 query48 493 388 394 388 query49 712 402 395 395 query50 827 415 432 415 query51 7357728672257225 query52 101 89 90 89 query53 257 189 189 189 query54 563 461 489 461 query55 82 80 77 77 query56 258 256 266 256 query57 1274115211641152 query58 219 201 220 201 query59 3198322730563056 query60 298 278 260 260 query61 114 166 103 103 query62 773 677 662 662 query63 214 186 183 183 query64 1364659 614 614 query65 3235321031553155 query66 702 293 301 293 query67 15964 15669 15562 15562 query68 3790617 586 586 query69 441 269 269 269 query70 1184108411441084 query71 354 257 252 252 query72 6289408141414081 query73 754 344 359 344 query74 10103 887090338870 query75 3352262826822628 query76 1994103311341033 query77 522 269 266 266 query78 10662 967296009600 query79 1667604 597 597 query80 1314435 413 413 query81 517 214 217 214 query82 940 92 85 85 query83 158 139 137 137 query84 283 83 76 76 query85 1001301 288 288 query86 362 301 302 301 query87 4375426941924192 query88 3954238623612361 query89 425 305 298 298 query90 1990182 184 182 query91 191 152 146 146 query92 60 50 50 50 query93 2158564 562 562 query94 769 292 294 292 query95 355 257 247 247 query96 616 279 278 278 query97 3238313231513132 query98 212 209 192 192 query99 1574133212821282 Total cold run time: 313467 ms Total hot run time: 196748 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: [fix](Nereids) we should also push down expr in join's mark conjuncts #50886 [doris]
doris-robot commented on PR #50954: URL: https://github.com/apache/doris/pull/50954#issuecomment-2939750714 TPC-H: Total hot run time: 39591 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1c90c4d45ebc8df924513cfe9c14bc0de42ebbef, data reload: false -- Round 1 -- q1 17623 670766006600 q2 2065167 182 167 q3 10675 106411511064 q4 10536 806 764 764 q5 7730283128112811 q6 215 134 133 133 q7 961 617 612 612 q8 9348194320061943 q9 6535639363986393 q10 7046226323462263 q11 453 260 251 251 q12 409 220 216 216 q13 17775 299030352990 q14 236 214 203 203 q15 509 472 473 472 q16 511 380 391 380 q17 977 542 513 513 q18 7319664465196519 q19 1405980 1109980 q20 463 204 204 204 q21 4030335331113111 q22 1114100710021002 Total cold run time: 107935 ms Total hot run time: 39591 ms - Round 2, with runtime_filter_mode=off - q1 6610657265496549 q2 329 242 229 229 q3 2880276828672768 q4 2044178017671767 q5 5831576157195719 q6 206 128 130 128 q7 2226180518221805 q8 3374356635223522 q9 8990876688838766 q10 3547350835293508 q11 592 500 504 500 q12 809 621 615 615 q13 8525316931903169 q14 313 264 261 261 q15 518 467 467 467 q16 510 445 440 440 q17 1849161916051605 q18 8251775876557655 q19 1678150615941506 q20 2174178618111786 q21 5440564353055305 q22 1104104610211021 Total cold run time: 67800 ms Total hot run time: 59091 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] branch-3.0: [fix](Nereids) we should also push down expr in join's mark conjuncts #50886 [doris]
morrySnow commented on PR #50954: URL: https://github.com/apache/doris/pull/50954#issuecomment-2939673246 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
