Re: [PR] branch-3.1: [fix](nereids) fix insert overwrite statement plan twice (#53398) [doris]
morrySnow merged PR #53474: URL: https://github.com/apache/doris/pull/53474 -- 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.1: [fix](nereids) fix insert overwrite statement plan twice (#53398) [doris]
doris-robot commented on PR #53474: URL: https://github.com/apache/doris/pull/53474#issuecomment-3083941531 ClickBench: Total hot run time: 29.78 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit a0a819fc2cc5e6e58c7411bdfca75faefcb7a8ee, data reload: false query1 0.040.040.03 query2 0.070.020.03 query3 0.230.070.07 query4 1.610.110.11 query5 0.500.510.51 query6 1.130.730.74 query7 0.030.020.02 query8 0.040.030.03 query9 0.570.500.51 query10 0.540.540.56 query11 0.140.100.09 query12 0.130.110.11 query13 0.600.600.59 query14 0.780.800.81 query15 0.850.850.83 query16 0.380.390.40 query17 1.061.051.09 query18 0.240.230.21 query19 1.961.751.77 query20 0.010.010.01 query21 15.42 0.600.57 query22 2.492.311.50 query23 17.02 0.970.83 query24 3.360.981.87 query25 0.260.170.05 query26 0.540.140.14 query27 0.040.060.04 query28 9.400.500.52 query29 12.59 3.163.19 query30 0.250.060.06 query31 2.860.400.38 query32 3.230.460.45 query33 2.982.982.98 query34 16.96 4.484.51 query35 4.534.484.52 query36 0.660.490.50 query37 0.090.060.05 query38 0.040.040.03 query39 0.030.030.02 query40 0.170.130.13 query41 0.070.020.02 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 103.98 s Total hot run time: 29.78 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.1: [fix](nereids) fix insert overwrite statement plan twice (#53398) [doris]
doris-robot commented on PR #53474: URL: https://github.com/apache/doris/pull/53474#issuecomment-3083924626 TPC-DS: Total hot run time: 197475 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 a0a819fc2cc5e6e58c7411bdfca75faefcb7a8ee, data reload: false query1 1275941 903 903 query2 6319188018741874 query3 10804 435142734273 query4 33157 23833 24082 23833 query5 4537498 463 463 query6 290 183 192 183 query7 3989315 328 315 query8 289 234 232 232 query9 9595260526072605 query10 493 263 259 259 query11 18510 15211 15214 15211 query12 163 106 106 106 query13 1552434 432 432 query14 8757726367156715 query15 239 179 183 179 query16 8054503 476 476 query17 1585602 574 574 query18 2122314 315 314 query19 232 167 174 167 query20 122 125 118 118 query21 204 113 109 109 query22 4657442945564429 query23 34548 34504 34090 34090 query24 11245 289628742874 query25 631 420 405 405 query26 1261169 168 168 query27 2535351 351 351 query28 7539217621482148 query29 883 466 475 466 query30 268 162 170 162 query31 1042846 840 840 query32 97 60 59 59 query33 802 312 320 312 query34 944 529 537 529 query35 859 775 747 747 query36 1074958 934 934 query37 129 65 69 65 query38 4037392140263921 query39 1509146415901464 query40 210 104 103 103 query41 48 50 49 49 query42 116 101 106 101 query43 508 481 478 478 query44 1281834 829 829 query45 186 168 169 168 query46 1146774 759 759 query47 2009191219181912 query48 456 357 339 339 query49 996 402 403 402 query50 846 421 433 421 query51 7479731673077307 query52 107 93 98 93 query53 264 187 202 187 query54 1140476 483 476 query55 91 78 81 78 query56 263 275 257 257 query57 1310121312351213 query58 235 227 222 222 query59 3238306230623062 query60 299 270 265 265 query61 113 107 107 107 query62 873 712 708 708 query63 222 199 190 190 query64 4048704 685 685 query65 3358328833313288 query66 801 313 309 309 query67 16217 15690 15600 15600 query68 4387593 592 592 query69 425 274 276 274 query70 1164110711331107 query71 348 274 262 262 query72 6313416341784163 query73 744 353 349 349 query74 10762 877689288776 query75 3408269927232699 query76 2568105511301055 query77 415 294 289 289 query78 10539 959095249524 query79 1777630 598 598 query80 1157462 453 453 query81 557 227 225 225 query82 914 92 90 90 query83 237 149 153 149 query84 244 89 87 87 query85 1372413 359 359 query86 375 289 312 289 query87 4313428142134213 query88 3768241923922392 query89 420 290 298 290 query90 1946193 188 188 query91 142 111 109 109 query92 60 49 51 49 query93 1991563 562 562 query94 911 289 297 289 query95 360 251 261 251 query96 603 281 282 281 query97 3288310831693108 query98 227 202 198 198 query99 1531130612921292 Total cold run time: 301474 ms Total hot run time: 197475 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] branch-3.1: [fix](nereids) fix insert overwrite statement plan twice (#53398) [doris]
doris-robot commented on PR #53474: URL: https://github.com/apache/doris/pull/53474#issuecomment-3083883498 TPC-H: Total hot run time: 39770 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit a0a819fc2cc5e6e58c7411bdfca75faefcb7a8ee, data reload: false -- Round 1 -- q1 17572 684866006600 q2 2070211 165 165 q3 10625 116111791161 q4 10478 774 711 711 q5 7687284128342834 q6 218 132 134 132 q7 985 638 600 600 q8 9379190919911909 q9 6575639463696369 q10 7031228622812281 q11 464 257 260 257 q12 399 210 205 205 q13 17774 299830372998 q14 231 201 203 201 q15 502 478 472 472 q16 488 383 368 368 q17 962 525 580 525 q18 742466386638 q19 1315103310241024 q20 475 205 199 199 q21 3932313132083131 q22 1073990 1001990 Total cold run time: 107659 ms Total hot run time: 39770 ms - Round 2, with runtime_filter_mode=off - q1 6615657166006571 q2 325 231 236 231 q3 2906295129202920 q4 2000190118301830 q5 5808583858735838 q6 215 132 132 132 q7 2237184718681847 q8 3408357635843576 q9 8764888788238823 q10 3564355635103510 q11 592 501 484 484 q12 824 592 595 592 q13 7597318131263126 q14 308 281 278 278 q15 511 475 473 473 q16 495 442 435 435 q17 1805161215761576 q18 8193772977767729 q19 1690156015481548 q20 2030181018091809 q21 5133512549764976 q22 1106103910421039 Total cold run time: 66126 ms Total hot run time: 59343 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.1: [fix](nereids) fix insert overwrite statement plan twice (#53398) [doris]
Thearas commented on PR #53474: URL: https://github.com/apache/doris/pull/53474#issuecomment-3083763577 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR). Please clearly describe your PR: 1. What problem was fixed (it's best to include specific error reporting information). How it was fixed. 2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be. 3. What features were added. Why was this function added? 4. Which code was refactored and why was this part of the code refactored? 5. Which functions were optimized and what is the difference before and after the optimization? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] branch-3.1: [fix](nereids) fix insert overwrite statement plan twice (#53398) [doris]
924060929 commented on PR #53474: URL: https://github.com/apache/doris/pull/53474#issuecomment-3083763671 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]
