Re: [PR] [enhance](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
starocean999 merged PR #53415: URL: https://github.com/apache/doris/pull/53415 -- 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] [enhance](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
github-actions[bot] commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3084059267 PR approved by anyone and no changes requested. -- 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] [enhance](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
github-actions[bot] commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3084059116 PR approved by at least one committer and no changes requested. -- 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] [enhance](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
doris-robot commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3083310707 ClickBench: Total hot run time: 32.09 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 7ac467b68d48c4f0635a164bb20db30d016083e8, data reload: false query1 0.040.040.04 query2 0.080.040.04 query3 0.240.070.07 query4 1.630.100.10 query5 0.440.420.41 query6 1.160.660.67 query7 0.030.020.02 query8 0.040.030.04 query9 0.590.520.51 query10 0.580.570.58 query11 0.150.110.10 query12 0.150.120.11 query13 0.630.610.61 query14 0.790.800.81 query15 0.880.840.88 query16 0.390.390.39 query17 1.101.071.09 query18 0.220.220.22 query19 1.941.851.81 query20 0.010.010.02 query21 15.41 0.870.53 query22 0.751.020.74 query23 14.98 1.390.60 query24 6.552.810.41 query25 0.300.250.15 query26 0.680.170.16 query27 0.060.050.05 query28 9.200.910.43 query29 12.57 4.103.32 query30 3.042.932.92 query31 2.820.580.39 query32 3.240.560.48 query33 3.063.173.06 query34 16.23 5.414.79 query35 4.834.874.83 query36 0.700.490.51 query37 0.090.060.07 query38 0.050.050.04 query39 0.040.030.02 query40 0.180.140.14 query41 0.080.020.03 query42 0.040.020.03 query43 0.040.030.03 Total cold run time: 106.03 s Total hot run time: 32.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: [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] [enhance](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
doris-robot commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3083294393 TPC-DS: Total hot run time: 186517 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 7ac467b68d48c4f0635a164bb20db30d016083e8, data reload: false query1 1003385 408 385 query2 6530171216701670 query3 6745219 219 219 query4 26598 23340 23077 23077 query5 4465594 433 433 query6 302 216 191 191 query7 4639491 282 282 query8 266 219 209 209 query9 8587259726312597 query10 471 345 269 269 query11 15448 15146 14796 14796 query12 155 103 102 102 query13 1627500 408 408 query14 9464572457925724 query15 208 194 168 168 query16 7519638 468 468 query17 1170717 565 565 query18 1986392 292 292 query19 191 185 165 165 query20 120 116 114 114 query21 210 122 103 103 query22 4215438142434243 query23 34102 33015 33007 33007 query24 8397239223862386 query25 529 462 386 386 query26 1224266 141 141 query27 2775494 338 338 query28 4312216521302130 query29 736 544 427 427 query30 279 220 187 187 query31 923 805 747 747 query32 66 70 58 58 query33 544 366 314 314 query34 791 829 508 508 query35 778 823 792 792 query36 988 994 931 931 query37 104 96 73 73 query38 4188417340704070 query39 1496140614201406 query40 206 113 100 100 query41 60 58 53 53 query42 120 108 102 102 query43 504 514 491 491 query44 1334844 816 816 query45 175 167 170 167 query46 841 994 650 650 query47 1826183017621762 query48 384 413 310 310 query49 724 516 387 387 query50 649 682 410 410 query51 5566560854715471 query52 106 105 96 96 query53 218 254 179 179 query54 565 568 492 492 query55 83 82 81 81 query56 298 301 290 290 query57 1200120611301130 query58 265 259 249 249 query59 2466274025632563 query60 309 310 333 310 query61 158 151 147 147 query62 842 696 644 644 query63 223 193 181 181 query64 42731005654 654 query65 4242417442114174 query66 1106410 312 312 query67 15777 15697 15463 15463 query68 4339903 539 539 query69 471 310 291 291 query70 1215113411221122 query71 393 321 309 309 query72 5688495649694956 query73 683 655 349 349 query74 9007921186488648 query75 3171327026892689 query76 32211134716 716 query77 488 375 292 292 query78 10064 10185 93229322 query79 2777814 595 595 query80 1623520 474 474 query81 568 252 221 221 query82 711 136 96 96 query83 329 250 226 226 query84 252 105 86 86 query85 819 361 323 323 query86 463 331 305 305 query87 4376444744174417 query88 4072227822612261 query89 389 305 279 279 query90 1893201 204 201 query91 143 143 113 113 query92 78 60 62 60 query93 2536939 584 584 query94 775 427 306 306 query95 372 298 287 287 query96 498 560 285 285 query97 2734277926302630 query98 241 205 205 205 query99 1641139412651265 Total cold run time: 274701 ms Total hot run time: 186517 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](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
doris-robot commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3083257976 TPC-H: Total hot run time: 33723 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 7ac467b68d48c4f0635a164bb20db30d016083e8, data reload: false -- Round 1 -- q1 17555 528250485048 q2 1944282 178 178 q3 10315 1285696 696 q4 10227 1020527 527 q5 7470240722912291 q6 175 159 127 127 q7 894 753 605 605 q8 9307129910531053 q9 7407503551005035 q10 6878238019701970 q11 483 285 264 264 q12 340 354 217 217 q13 17783 369331013101 q14 225 225 227 225 q15 538 471 479 471 q16 419 438 378 378 q17 586 880 363 363 q18 7489709672367096 q19 1077949 579 579 q20 331 340 215 215 q21 3800308623202320 q22 10361012964 964 Total cold run time: 106279 ms Total hot run time: 33723 ms - Round 2, with runtime_filter_mode=off - q1 5156508154765081 q2 245 319 217 217 q3 2198266123142314 q4 1336179213391339 q5 4211454345754543 q6 207 165 123 123 q7 2108200018331833 q8 2738261925662566 q9 7640718573727185 q10 3102334128432843 q11 575 497 502 497 q12 730 767 636 636 q13 3576405633453345 q14 281 308 290 290 q15 530 483 458 458 q16 476 493 432 432 q17 1140148513531353 q18 7855766576967665 q19 806 883 1000883 q20 1989210818701870 q21 4638438644054386 q22 10521037977 977 Total cold run time: 52589 ms Total hot run time: 50836 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] [enhance](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
xiedeyantu commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3083195288 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]
Re: [PR] [enhance](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
doris-robot commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3082181612 TPC-DS: Total hot run time: 187562 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 1480a07fb3d65c286dccde1ede0ff4bb0650cb65, data reload: false query1 987 387 402 387 query2 6534169217111692 query3 6946214 207 207 query4 26456 23462 23446 23446 query5 4346561 418 418 query6 286 194 187 187 query7 4612503 282 282 query8 263 208 204 204 query9 8601262326392623 query10 493 315 275 275 query11 15768 15635 14786 14786 query12 155 105 103 103 query13 1631523 403 403 query14 9194590959465909 query15 210 198 168 168 query16 7400641 441 441 query17 1178696 566 566 query18 1988389 294 294 query19 186 177 171 171 query20 123 113 111 111 query21 211 121 107 107 query22 4236417540474047 query23 34036 33083 8 33083 query24 8542237423882374 query25 564 457 385 385 query26 1227264 145 145 query27 2758505 349 349 query28 4317211520942094 query29 734 549 434 434 query30 281 218 188 188 query31 926 836 755 755 query32 74 64 59 59 query33 581 373 311 311 query34 800 842 504 504 query35 767 828 763 763 query36 940 1007910 910 query37 113 101 79 79 query38 4189416441534153 query39 1490142314401423 query40 215 120 106 106 query41 56 58 51 51 query42 126 108 105 105 query43 519 507 491 491 query44 1313831 823 823 query45 189 171 168 168 query46 862 1008629 629 query47 1764183117311731 query48 379 416 297 297 query49 724 458 379 379 query50 630 686 427 427 query51 5394544054755440 query52 118 110 102 102 query53 218 257 187 187 query54 559 570 490 490 query55 85 88 82 82 query56 321 286 287 286 query57 1189121411311131 query58 264 252 254 252 query59 2673274827482748 query60 337 342 336 336 query61 127 119 126 119 query62 779 724 656 656 query63 223 187 188 187 query64 43281002662 662 query65 4271421941674167 query66 1124413 307 307 query67 15837 15481 15447 15447 query68 4375893 542 542 query69 489 304 271 271 query70 1221112110781078 query71 404 313 308 308 query72 5755502451765024 query73 669 651 357 357 query74 8851920289098909 query75 3167319127172717 query76 31981170728 728 query77 483 403 303 303 query78 10029 10084 93219321 query79 2944782 573 573 query80 769 517 557 517 query81 492 265 220 220 query82 723 128 98 98 query83 298 250 232 232 query84 300 107 84 84 query85 800 363 314 314 query86 413 317 303 303 query87 4533450444324432 query88 3955230922802280 query89 380 315 285 285 query90 1858208 213 208 query91 142 146 113 113 query92 74 62 59 59 query93 2566920 585 585 query94 777 408 305 305 query95 375 294 285 285 query96 493 581 284 284 query97 2790279426832683 query98 239 211 207 207 query99 1452140312951295 Total cold run time: 273781 ms Total hot run time: 187562 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](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
doris-robot commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3082192375 ClickBench: Total hot run time: 32.1 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1480a07fb3d65c286dccde1ede0ff4bb0650cb65, data reload: false query1 0.040.030.04 query2 0.090.050.04 query3 0.240.070.07 query4 1.630.110.11 query5 0.430.410.42 query6 1.180.660.67 query7 0.020.020.02 query8 0.050.040.03 query9 0.590.520.51 query10 0.570.560.56 query11 0.160.100.11 query12 0.160.110.11 query13 0.640.610.61 query14 0.800.830.85 query15 0.890.860.88 query16 0.390.400.40 query17 1.061.051.06 query18 0.230.230.22 query19 1.991.881.91 query20 0.010.010.01 query21 15.37 0.900.55 query22 0.751.160.73 query23 14.88 1.390.61 query24 7.541.780.38 query25 0.280.150.06 query26 0.720.160.14 query27 0.050.050.05 query28 8.960.910.45 query29 12.57 4.003.27 query30 3.022.992.91 query31 2.810.580.38 query32 3.230.570.50 query33 3.043.203.15 query34 16.00 5.364.77 query35 4.864.834.84 query36 0.690.520.47 query37 0.090.070.06 query38 0.050.040.04 query39 0.030.030.03 query40 0.170.150.14 query41 0.080.020.03 query42 0.030.020.03 query43 0.040.040.03 Total cold run time: 106.43 s Total hot run time: 32.1 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] [enhance](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
doris-robot commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3082114458 TPC-H: Total hot run time: 33839 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1480a07fb3d65c286dccde1ede0ff4bb0650cb65, data reload: false -- Round 1 -- q1 17567 524451225122 q2 1928279 179 179 q3 10327 1265715 715 q4 10231 1002546 546 q5 7527235922722272 q6 182 161 129 129 q7 895 728 591 591 q8 9299121410771077 q9 6780506450785064 q10 6870236019631963 q11 464 284 271 271 q12 337 348 218 218 q13 17749 371831413141 q14 244 234 225 225 q15 540 476 466 466 q16 416 444 377 377 q17 571 841 353 353 q18 7395715170387038 q19 1222941 562 562 q20 328 334 218 218 q21 4084310523782378 q22 1009979 934 934 Total cold run time: 105965 ms Total hot run time: 33839 ms - Round 2, with runtime_filter_mode=off - q1 5182513450915091 q2 240 334 225 225 q3 2204266222562256 q4 1359174713001300 q5 4201438844294388 q6 214 194 143 143 q7 2083197918091809 q8 2675265325852585 q9 7285736572347234 q10 3127322328892889 q11 582 554 510 510 q12 680 754 611 611 q13 3731403533383338 q14 287 299 279 279 q15 518 465 478 465 q16 469 525 472 472 q17 1346151913921392 q18 7873770073367336 q19 815 811 938 811 q20 1962194718421842 q21 4762439943834383 q22 10381024976 976 Total cold run time: 52633 ms Total hot run time: 50335 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] [enhance](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
xiedeyantu commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3082047531 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]
Re: [PR] [enhance](function) EXTRACT supports dayofyear/dayofweek aliases doy/dow [doris]
Thearas commented on PR #53415: URL: https://github.com/apache/doris/pull/53415#issuecomment-3082045901 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]
