Re: [PR] [fix](sql_cache) fix sql cache result wrong of from_unixtime(col, 'yyyy-MM-dd HH:mm:ss') (#44631) [doris]
924060929 merged PR #44811: URL: https://github.com/apache/doris/pull/44811 -- 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] [fix](sql_cache) fix sql cache result wrong of from_unixtime(col, 'yyyy-MM-dd HH:mm:ss') (#44631) [doris]
924060929 merged PR #44810: URL: https://github.com/apache/doris/pull/44810 -- 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] [fix](sql_cache) fix sql cache result wrong of from_unixtime(col, 'yyyy-MM-dd HH:mm:ss') (#44631) [doris]
doris-robot commented on PR #44811: URL: https://github.com/apache/doris/pull/44811#issuecomment-2508819379 TPC-DS: Total hot run time: 194856 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 dc1eec758e0d1fe9fdb494b2af38c3d2c49701b2, data reload: false query1 1212915 899 899 query2 6232201419971997 query3 10789 365338743653 query4 68832 28463 23313 23313 query5 5579445 430 430 query6 472 170 162 162 query7 6199317 323 317 query8 322 224 229 224 query9 9361266126522652 query10 510 269 253 253 query11 18010 15336 15667 15336 query12 162 102 112 102 query13 1574444 421 421 query14 11388 732166716671 query15 211 180 182 180 query16 7231517 509 509 query17 1317587 576 576 query18 1855322 320 320 query19 213 167 159 159 query20 116 112 117 112 query21 216 106 106 106 query22 4765466745424542 query23 34888 34157 34087 34087 query24 5854295129562951 query25 498 376 380 376 query26 670 165 166 165 query27 2061307 305 305 query28 4423257225312531 query29 691 454 441 441 query30 237 161 160 160 query31 981 818 816 816 query32 64 52 53 52 query33 456 273 279 273 query34 910 502 523 502 query35 832 740 723 723 query36 1118980 958 958 query37 115 75 67 67 query38 4055399239573957 query39 1516145714701457 query40 204 96 96 96 query41 50 48 46 46 query42 108 94 94 94 query43 523 497 483 483 query44 1176805 821 805 query45 186 169 167 167 query46 1131780 743 743 query47 2021190819041904 query48 467 384 375 375 query49 735 383 391 383 query50 841 413 411 411 query51 7290724269966996 query52 102 84 90 84 query53 250 184 186 184 query54 550 442 435 435 query55 75 72 71 71 query56 255 242 226 226 query57 1185112210731073 query58 204 196 208 196 query59 3077283628752836 query60 282 254 240 240 query61 107 105 99 99 query62 758 658 671 658 query63 211 193 191 191 query64 1429650 614 614 query65 3244316831523152 query66 648 297 301 297 query67 15737 15232 15182 15182 query68 4551557 554 554 query69 417 272 256 256 query70 1191113811261126 query71 314 247 251 247 query72 6464401940184018 query73 743 346 343 343 query74 10117 880790018807 query75 3274279626432643 query76 2264109511411095 query77 480 268 260 260 query78 10713 978994049404 query79 9051592 574 574 query80 2374440 478 440 query81 567 240 249 240 query82 1277113 111 111 query83 303 137 135 135 query84 297 79 82 79 query85 1951297 283 283 query86 464 288 306 288 query87 417243074172 query88 5818238823952388 query89 561 284 288 284 query90 2173176 180 176 query91 173 139 141 139 query92 65 49 50 49 query93 6800537 536 536 query94 1035275 284 275 query95 336 255 253 253 query96 647 281 276 276 query97 3329312632123126 query98 219 204 201 201 query99 1710129712821282 Total cold run time: 342903 ms Total hot run time: 194856 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] [fix](sql_cache) fix sql cache result wrong of from_unixtime(col, 'yyyy-MM-dd HH:mm:ss') (#44631) [doris]
doris-robot commented on PR #44811: URL: https://github.com/apache/doris/pull/44811#issuecomment-2508816156 TPC-H: Total hot run time: 40302 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit dc1eec758e0d1fe9fdb494b2af38c3d2c49701b2, data reload: false -- Round 1 -- q1 17603 744672767276 q2 2040175 163 163 q3 10738 107311021073 q4 10546 797 663 663 q5 7755281228322812 q6 230 147 146 146 q7 970 610 606 606 q8 9564194919481948 q9 7323635364226353 q10 6963230823222308 q11 449 262 269 262 q12 412 220 212 212 q13 17764 298029692969 q14 238 210 214 210 q15 551 529 505 505 q16 647 614 595 595 q17 964 532 486 486 q18 7255653565006500 q19 284510311031 q20 470 202 195 195 q21 4102314330233023 q22 1090998 966 966 Total cold run time: 110519 ms Total hot run time: 40302 ms - Round 2, with runtime_filter_mode=off - q1 7330723372857233 q2 315 224 226 224 q3 2935285528482848 q4 2048179017621762 q5 5679572857255725 q6 231 148 143 143 q7 2139177317991773 q8 3363352333723372 q9 8941892888808880 q10 3538351235253512 q11 584 506 509 506 q12 822 654 594 594 q13 16388 315631363136 q14 303 283 279 279 q15 582 540 525 525 q16 708 666 680 666 q17 1891160216051602 q18 8160780173507350 q19 1693149814121412 q20 2044184818601848 q21 5305531052145214 q22 10961022985 985 Total cold run time: 76095 ms Total hot run time: 59589 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] [fix](sql_cache) fix sql cache result wrong of from_unixtime(col, 'yyyy-MM-dd HH:mm:ss') (#44631) [doris]
doris-robot commented on PR #44810: URL: https://github.com/apache/doris/pull/44810#issuecomment-2508805270 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] [fix](sql_cache) fix sql cache result wrong of from_unixtime(col, 'yyyy-MM-dd HH:mm:ss') (#44631) [doris]
924060929 commented on PR #44810: URL: https://github.com/apache/doris/pull/44810#issuecomment-2508805622 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] [fix](sql_cache) fix sql cache result wrong of from_unixtime(col, 'yyyy-MM-dd HH:mm:ss') (#44631) [doris]
924060929 commented on PR #44811: URL: https://github.com/apache/doris/pull/44811#issuecomment-2508805638 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] [fix](sql_cache) fix sql cache result wrong of from_unixtime(col, 'yyyy-MM-dd HH:mm:ss') (#44631) [doris]
doris-robot commented on PR #44811: URL: https://github.com/apache/doris/pull/44811#issuecomment-2508805582 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
