Re: [PR] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
github-actions[bot] closed pull request #40916: [opt](datatype) avoid unnecessary copying in the push number for the date type, URL: https://github.com/apache/doris/pull/40916 -- 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
github-actions[bot] commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2734994502 We're closing this PR because it hasn't been updated in a while. This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable. If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag! -- 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2360083243 ClickBench: Total hot run time: 33.06 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit cbb7b18afcdecedfadaa414a8984f02863b41972, data reload: false query1 0.050.040.04 query2 0.050.030.03 query3 0.230.060.06 query4 1.650.100.10 query5 0.520.490.51 query6 1.150.730.72 query7 0.010.010.01 query8 0.040.030.03 query9 0.560.490.49 query10 0.550.560.56 query11 0.140.100.10 query12 0.140.110.11 query13 0.600.590.58 query14 3.122.953.06 query15 0.900.820.82 query16 0.380.380.39 query17 1.061.021.06 query18 0.220.200.20 query19 1.951.832.00 query20 0.020.010.01 query21 15.37 0.610.60 query22 2.692.672.06 query23 17.48 0.940.91 query24 2.971.350.93 query25 0.330.080.06 query26 0.350.140.15 query27 0.040.030.04 query28 10.46 1.081.06 query29 12.55 3.273.27 query30 0.250.060.06 query31 2.880.390.38 query32 3.260.460.46 query33 2.963.033.00 query34 16.99 4.384.37 query35 4.454.444.43 query36 0.680.480.49 query37 0.080.060.06 query38 0.040.030.03 query39 0.040.020.02 query40 0.160.120.13 query41 0.080.020.03 query42 0.030.030.02 query43 0.030.020.02 Total cold run time: 107.51 s Total hot run time: 33.06 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2360086466 TeamCity be ut coverage result: Function Coverage: 37.33% (9585/25676) Line Coverage: 28.73% (79255/275891) Region Coverage: 28.19% (41021/145521) Branch Coverage: 24.82% (20903/84220) Coverage Report: http://coverage.selectdb-in.cc/coverage/cbb7b18afcdecedfadaa414a8984f02863b41972_cbb7b18afcdecedfadaa414a8984f02863b41972/report/index.html -- 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2360067102 TPC-DS: Total hot run time: 193571 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 cbb7b18afcdecedfadaa414a8984f02863b41972, data reload: false query1 956 376 384 376 query2 6546208120132013 query3 6702210 221 210 query4 34506 23338 23427 23338 query5 4335477 467 467 query6 262 168 164 164 query7 4615290 296 290 query8 281 215 228 215 query9 9889269626962696 query10 450 271 279 271 query11 18174 15176 15123 15123 query12 146 106 98 98 query13 1652422 408 408 query14 10368 730373547303 query15 290 180 169 169 query16 8125468 483 468 query17 1676589 557 557 query18 2161301 325 301 query19 374 150 163 150 query20 115 106 106 106 query21 215 100 103 100 query22 4386409042344090 query23 34710 34083 33805 33805 query24 11168 295728562856 query25 643 401 414 401 query26 1182161 157 157 query27 2363299 300 299 query28 8120247524392439 query29 852 424 420 420 query30 338 158 155 155 query31 1019779 809 779 query32 97 57 57 57 query33 773 295 296 295 query34 966 491 484 484 query35 857 745 725 725 query36 1080959 944 944 query37 168 92 85 85 query38 4076402238453845 query39 1468143014151415 query40 203 99 96 96 query41 52 48 51 48 query42 118 97 95 95 query43 530 472 472 472 query44 1242835 805 805 query45 193 165 163 163 query46 1156747 766 747 query47 1917183318241824 query48 461 357 362 357 query49 1156423 398 398 query50 818 421 393 393 query51 7176709169186918 query52 102 92 88 88 query53 255 183 181 181 query54 1314474 479 474 query55 76 76 76 76 query56 269 262 259 259 query57 1231108910951089 query58 267 233 239 233 query59 3147293527662766 query60 299 264 261 261 query61 103 101 103 101 query62 859 679 667 667 query63 219 181 181 181 query64 5185638 623 623 query65 3251322031863186 query66 1436297 312 297 query67 16063 15544 15295 15295 query68 3110580 589 580 query69 427 279 292 279 query70 1215109711251097 query71 321 273 264 264 query72 5958402339673967 query73 758 330 326 326 query74 9448895089608950 query75 3339262926152615 query76 2060875 862 862 query77 448 287 289 287 query78 10072 10118 93019301 query79 1388861 851 851 query80 927 578 551 551 query81 526 254 254 254 query82 784 227 233 227 query83 212 159 167 159 query84 247 112 108 108 query85 764 364 360 360 query86 367 319 304 304 query87 4456446544274427 query88 4713401740094009 query89 372 363 363 363 query90 1990308 301 301 query91 160 160 165 160 query92 75 70 71 70 query93 918 902 888 888 query94 960 370 363 363 query95 460 404 402 402 query96 484 476 484 476 query97 3140310131553101 query98 225 231 225 225 query99 1453130412771277 Total cold run time: 296979 ms Total hot run time: 193571 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 t
Re: [PR] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2360043837 TPC-H: Total hot run time: 41970 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit cbb7b18afcdecedfadaa414a8984f02863b41972, data reload: false -- Round 1 -- q1 17922 751073537353 q2 2435182 161 161 q3 1 116611881166 q4 10213 809 775 775 q5 7725320030873087 q6 233 151 151 151 q7 1015615 603 603 q8 9447209320652065 q9 6893643064176417 q10 7002233322852285 q11 429 248 256 248 q12 406 219 227 219 q13 17786 297429682968 q14 237 231 245 231 q15 573 519 512 512 q16 668 629 614 614 q17 997 847 815 815 q18 7260677067826770 q19 13971010990 990 q20 593 293 290 290 q21 4006336032473247 q22 1071102610031003 Total cold run time: 109419 ms Total hot run time: 41970 ms - Round 2, with runtime_filter_mode=off - q1 7306722773117227 q2 335 235 226 226 q3 2939281428352814 q4 1946167117471671 q5 5377541054315410 q6 233 143 142 142 q7 2086172017301720 q8 3187333633053305 q9 8406839484618394 q10 3392335033863350 q11 577 480 460 460 q12 776 563 571 563 q13 6599297929972979 q14 293 265 257 257 q15 564 511 500 500 q16 698 660 663 660 q17 1772155315321532 q18 7756746475187464 q19 1701157514081408 q20 2053183418371834 q21 5352516950885088 q22 11251017990 990 Total cold run time: 64473 ms Total hot run time: 57994 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
Mryange commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2359963660 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2359908933 ClickBench: Total hot run time: 32.49 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit ba5f54706029bac48e9f8be506f869eac6d0e55d, data reload: false query1 0.050.040.04 query2 0.060.020.03 query3 0.240.060.06 query4 1.650.100.10 query5 0.500.490.52 query6 1.160.710.72 query7 0.020.020.01 query8 0.030.030.03 query9 0.550.500.48 query10 0.540.550.55 query11 0.150.100.11 query12 0.140.110.11 query13 0.600.590.59 query14 3.012.963.13 query15 0.900.830.80 query16 0.380.360.38 query17 1.031.061.01 query18 0.190.200.19 query19 1.941.802.05 query20 0.020.010.01 query21 15.35 0.620.62 query22 2.612.611.61 query23 17.24 0.990.85 query24 2.921.191.00 query25 0.160.170.09 query26 0.460.140.12 query27 0.040.030.04 query28 10.70 1.091.08 query29 12.51 3.313.24 query30 0.240.060.05 query31 2.870.390.38 query32 3.280.450.44 query33 2.983.013.00 query34 17.00 4.384.48 query35 4.404.444.41 query36 0.670.470.48 query37 0.090.060.06 query38 0.050.030.04 query39 0.030.030.02 query40 0.160.130.12 query41 0.080.020.02 query42 0.020.020.02 query43 0.030.030.04 Total cold run time: 107.05 s Total hot run time: 32.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: [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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2359904644 TPC-DS: Total hot run time: 198555 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 ba5f54706029bac48e9f8be506f869eac6d0e55d, data reload: false query1 1304866 909 866 query2 6397213920762076 query3 10783 388439113884 query4 64518 28366 23502 23502 query5 4917476 460 460 query6 408 153 159 153 query7 5464297 290 290 query8 310 221 218 218 query9 8319261326212613 query10 448 286 270 270 query11 17053 15158 15585 15158 query12 156 102 101 101 query13 1430415 414 414 query14 10489 711874987118 query15 205 177 172 172 query16 476 476 476 query17 1190598 579 579 query18 1301308 304 304 query19 215 153 154 153 query20 128 117 115 115 query21 219 107 105 105 query22 4935450446404504 query23 35214 34084 33781 33781 query24 6024292329002900 query25 508 395 398 395 query26 621 163 161 161 query27 1584276 279 276 query28 4452243824122412 query29 667 445 426 426 query30 230 159 152 152 query31 939 781 788 781 query32 71 56 56 56 query33 443 277 295 277 query34 892 480 484 480 query35 835 720 731 720 query36 1071924 900 900 query37 149 85 90 85 query38 3987389439883894 query39 1450143814031403 query40 206 96 95 95 query41 49 48 46 46 query42 112 96 95 95 query43 530 487 483 483 query44 1120815 786 786 query45 191 163 165 163 query46 1112744 720 720 query47 1909180318141803 query48 462 359 365 359 query49 695 403 415 403 query50 825 408 447 408 query51 7090692569286925 query52 98 84 85 84 query53 248 179 176 176 query54 566 451 446 446 query55 78 73 74 73 query56 254 249 265 249 query57 1229109410941094 query58 218 220 234 220 query59 3197290430442904 query60 307 255 266 255 query61 105 106 105 105 query62 741 665 660 660 query63 228 187 182 182 query64 1271639 665 639 query65 3271315831673158 query66 668 292 300 292 query67 15977 15632 15815 15632 query68 1355846 821 821 query69 443 349 344 344 query70 1197118011601160 query71 329 335 339 335 query72 5848335633803356 query73 579 574 567 567 query74 9412891990028919 query75 3035294028452845 query76 1055870 873 870 query77 382 354 352 352 query78 9631919992919199 query79 910 877 854 854 query80 591 563 567 563 query81 463 252 251 251 query82 231 229 233 229 query83 160 160 155 155 query84 237 107 107 107 query85 672 362 364 362 query86 302 308 298 298 query87 4399429044274290 query88 4390403739873987 query89 365 348 354 348 query90 1431311 301 301 query91 165 164 180 164 query92 76 70 75 70 query93 879 872 869 869 query94 548 365 376 365 query95 420 402 409 402 query96 478 475 477 475 query97 3126310931393109 query98 230 220 220 220 query99 1477130912831283 Total cold run time: 303565 ms Total hot run time: 198555 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2359896191 TeamCity be ut coverage result: Function Coverage: 37.33% (9584/25675) Line Coverage: 28.70% (79209/275965) Region Coverage: 28.18% (41013/145536) Branch Coverage: 24.80% (20897/84262) Coverage Report: http://coverage.selectdb-in.cc/coverage/ba5f54706029bac48e9f8be506f869eac6d0e55d_ba5f54706029bac48e9f8be506f869eac6d0e55d/report/index.html -- 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2359894527 TPC-H: Total hot run time: 41325 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit ba5f54706029bac48e9f8be506f869eac6d0e55d, data reload: false -- Round 1 -- q1 17705 747872797279 q2 2046163 161 161 q3 10865 107211481072 q4 10350 774 710 710 q5 7759313530883088 q6 234 148 146 146 q7 1011606 599 599 q8 9447205420762054 q9 6812642664456426 q10 6998224822982248 q11 442 247 239 239 q12 408 211 211 211 q13 17791 300229662966 q14 236 214 218 214 q15 570 520 521 520 q16 689 627 603 603 q17 983 832 792 792 q18 7521677566626662 q19 1403105410491049 q20 577 279 278 278 q21 4236330230223022 q22 11171040986 986 Total cold run time: 109200 ms Total hot run time: 41325 ms - Round 2, with runtime_filter_mode=off - q1 7255719271917191 q2 326 225 223 223 q3 2977291429472914 q4 2034191118081808 q5 5603570656025602 q6 237 151 140 140 q7 2277177017761770 q8 3340343334533433 q9 8763888587648764 q10 3578343335233433 q11 560 477 478 477 q12 812 592 608 592 q13 10385 311231363112 q14 310 290 277 277 q15 586 524 521 521 q16 703 665 676 665 q17 1860159216181592 q18 8312772278857722 q19 1732157915611561 q20 2137189318931893 q21 5683526854075268 q22 1156108810501050 Total cold run time: 70626 ms Total hot run time: 60008 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
Mryange commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2359736685 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
HappenLee commented on code in PR #40916:
URL: https://github.com/apache/doris/pull/40916#discussion_r1764900727
##
be/src/vec/data_types/data_type_date.cpp:
##
@@ -42,14 +42,16 @@ bool DataTypeDate::equals(const IDataType& rhs) const {
}
size_t DataTypeDate::number_length() const {
-return 10;
+return sizeof("2024-01-01"); //11
}
void DataTypeDate::push_number(ColumnString::Chars& chars, const Int64& num)
const {
doris::VecDateTimeValue value = binary_cast(num);
-char buf[64];
-char* pos = value.to_string(buf);
-// DateTime to_string the end is /0
-chars.insert(buf, pos - 1);
+
+const auto old_size = chars.size();
+const auto len = value.to_buffer((char*)chars.data() + old_size);
Review Comment:
how you sure the memory length is enough or segment fault？
--
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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2358151624 ClickBench: Total hot run time: 32.72 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 7c32f377a97e86ac393b08d326b8af8e6fbe3d0c, data reload: false query1 0.050.040.04 query2 0.060.030.03 query3 0.230.060.06 query4 1.690.100.10 query5 0.520.510.50 query6 1.140.720.72 query7 0.010.010.01 query8 0.040.030.03 query9 0.570.510.50 query10 0.560.550.55 query11 0.140.110.10 query12 0.130.100.10 query13 0.600.590.59 query14 3.102.932.97 query15 0.900.820.81 query16 0.390.390.40 query17 1.081.101.06 query18 0.200.190.20 query19 1.971.912.01 query20 0.010.010.01 query21 15.38 0.590.57 query22 2.683.551.75 query23 17.31 0.810.85 query24 3.350.861.19 query25 0.280.070.12 query26 0.510.140.14 query27 0.030.030.05 query28 10.46 1.081.08 query29 12.56 3.273.26 query30 0.240.050.06 query31 2.880.380.38 query32 3.270.470.46 query33 3.023.023.04 query34 16.98 4.374.36 query35 4.414.504.47 query36 0.680.480.49 query37 0.090.060.06 query38 0.050.040.03 query39 0.030.020.02 query40 0.160.120.12 query41 0.080.020.02 query42 0.030.030.03 query43 0.040.020.02 Total cold run time: 107.91 s Total hot run time: 32.72 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2358141577 TPC-DS: Total hot run time: 198744 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 7c32f377a97e86ac393b08d326b8af8e6fbe3d0c, data reload: false query1 1296883 889 883 query2 6378203520252025 query3 10752 383539233835 query4 63182 28788 23760 23760 query5 5056460 461 460 query6 395 170 160 160 query7 5451310 303 303 query8 307 226 225 225 query9 8484265026252625 query10 421 309 278 278 query11 17197 15018 15668 15018 query12 160 103 104 103 query13 1436413 434 413 query14 10718 775178097751 query15 204 181 172 172 query16 6499505 498 498 query17 1161617 581 581 query18 1464318 320 318 query19 220 150 151 150 query20 122 118 111 111 query21 208 102 104 102 query22 4639451746844517 query23 34653 34054 33809 33809 query24 5981289628922892 query25 512 401 391 391 query26 640 163 164 163 query27 1637286 286 286 query28 4300244924172417 query29 663 437 425 425 query30 239 156 156 156 query31 961 778 793 778 query32 78 56 57 56 query33 400 292 294 292 query34 891 496 499 496 query35 851 720 720 720 query36 1052929 924 924 query37 150 81 86 81 query38 4011396439133913 query39 1592154814191419 query40 204 96 97 96 query41 50 50 47 47 query42 125 99 98 98 query43 536 482 490 482 query44 1142816 797 797 query45 194 165 173 165 query46 1110755 725 725 query47 1940178218171782 query48 479 368 399 368 query49 697 410 402 402 query50 820 409 404 404 query51 7034679968496799 query52 95 85 89 85 query53 256 173 184 173 query54 547 447 451 447 query55 81 77 75 75 query56 268 258 261 258 query57 1231107111031071 query58 214 226 229 226 query59 3237294328742874 query60 289 261 267 261 query61 106 114 98 98 query62 760 647 642 642 query63 221 191 186 186 query64 1359646 650 646 query65 3251314632173146 query66 649 303 294 294 query67 16129 15578 15440 15440 query68 1583559 551 551 query69 428 294 297 294 query70 1230113910351035 query71 314 267 271 267 query72 6126409340524052 query73 743 324 327 324 query74 9691894089968940 query75 3344271526692669 query76 1383875 862 862 query77 408 290 297 290 query78 10176 963192269226 query79 1007884 848 848 query80 774 575 604 575 query81 507 250 261 250 query82 230 229 233 229 query83 164 159 150 150 query84 280 99 95 95 query85 750 368 350 350 query86 316 302 325 302 query87 4453423443744234 query88 4636402140324021 query89 384 367 355 355 query90 1589309 301 301 query91 162 162 161 161 query92 77 70 73 70 query93 909 866 873 866 query94 665 340 386 340 query95 434 404 401 401 query96 492 524 477 477 query97 3171310431713104 query98 225 216 223 216 query99 1474130012961296 Total cold run time: 305510 ms Total hot run time: 198744 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 t
Re: [PR] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2358119623 TeamCity be ut coverage result: Function Coverage: 37.32% (9582/25672) Line Coverage: 28.73% (79244/275871) Region Coverage: 28.19% (41015/145509) Branch Coverage: 24.81% (20903/84246) Coverage Report: http://coverage.selectdb-in.cc/coverage/7c32f377a97e86ac393b08d326b8af8e6fbe3d0c_7c32f377a97e86ac393b08d326b8af8e6fbe3d0c/report/index.html -- 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2358118101 TPC-H: Total hot run time: 41644 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 7c32f377a97e86ac393b08d326b8af8e6fbe3d0c, data reload: false -- Round 1 -- q1 18014 742472977297 q2 2038178 160 160 q3 12877 105711451057 q4 10215 766 691 691 q5 7761312330623062 q6 234 149 143 143 q7 1015614 596 596 q8 9653205820142014 q9 6903644064846440 q10 6997227023272270 q11 446 253 251 251 q12 416 220 214 214 q13 18001 319232563192 q14 259 223 244 223 q15 584 560 529 529 q16 1068604 641 604 q17 1078864 803 803 q18 7809679566856685 q19 1444975 1076975 q20 602 300 286 286 q21 4215366031733173 q22 10991045979 979 Total cold run time: 112728 ms Total hot run time: 41644 ms - Round 2, with runtime_filter_mode=off - q1 7240724373377243 q2 326 231 236 231 q3 3060293429242924 q4 2109182917571757 q5 5587554257255542 q6 234 139 140 139 q7 2196178618181786 q8 3270340633943394 q9 8765874987598749 q10 3427347334543454 q11 595 486 478 478 q12 817 653 605 605 q13 14847 312331463123 q14 327 276 286 276 q15 575 541 535 535 q16 692 675 680 675 q17 1813161015581558 q18 8183761678047616 q19 1702156414931493 q20 2100187218841872 q21 5455547654345434 q22 1154104110021002 Total cold run time: 74474 ms Total hot run time: 59886 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
Mryange commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2358041178 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2357752146 ClickBench: Total hot run time: 32.14 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit c804027af9838170026fdc138f2b0a646ecedbe5, data reload: false query1 0.050.040.04 query2 0.060.030.03 query3 0.220.060.06 query4 1.650.100.10 query5 0.510.520.51 query6 1.150.730.73 query7 0.020.010.01 query8 0.040.030.03 query9 0.570.480.48 query10 0.540.580.56 query11 0.140.100.11 query12 0.130.110.10 query13 0.600.610.58 query14 3.073.123.07 query15 0.890.820.82 query16 0.360.380.39 query17 1.061.051.07 query18 0.200.190.20 query19 1.951.851.97 query20 0.010.010.01 query21 15.36 0.610.61 query22 2.772.451.54 query23 17.45 0.780.66 query24 2.830.980.74 query25 0.260.120.04 query26 0.340.150.14 query27 0.050.040.04 query28 11.12 1.101.06 query29 12.54 3.243.23 query30 0.240.060.05 query31 2.870.380.37 query32 3.300.470.46 query33 2.993.013.08 query34 16.55 4.374.35 query35 4.414.374.43 query36 0.680.490.48 query37 0.080.050.06 query38 0.040.040.03 query39 0.030.020.02 query40 0.150.130.12 query41 0.070.020.02 query42 0.040.030.02 query43 0.040.030.03 Total cold run time: 107.43 s Total hot run time: 32.14 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2357741416 TPC-DS: Total hot run time: 198669 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 c804027af9838170026fdc138f2b0a646ecedbe5, data reload: false query1 1309852 917 852 query2 6410204020542040 query3 10827 394039433940 query4 64855 28732 23700 23700 query5 4913457 453 453 query6 402 160 163 160 query7 5468298 298 298 query8 311 223 217 217 query9 8723266226492649 query10 443 286 270 270 query11 17162 15407 15932 15407 query12 153 115 101 101 query13 1501409 422 409 query14 10737 757276257572 query15 203 178 173 173 query16 6664466 495 466 query17 1203615 567 567 query18 1444313 339 313 query19 205 153 147 147 query20 126 110 108 108 query21 220 106 108 106 query22 4618434348404343 query23 34628 33533 33743 33533 query24 6019292428832883 query25 507 412 400 400 query26 618 163 153 153 query27 1587279 278 278 query28 3900246924192419 query29 670 428 425 425 query30 233 156 153 153 query31 970 772 763 763 query32 69 56 60 56 query33 439 291 286 286 query34 888 499 473 473 query35 842 719 702 702 query36 1062917 933 917 query37 144 86 80 80 query38 3964391439133913 query39 1453143613951395 query40 210 96 96 96 query41 49 48 47 47 query42 120 96 96 96 query43 520 480 492 480 query44 1125801 808 801 query45 193 165 163 163 query46 1128739 763 739 query47 1895178418071784 query48 453 353 358 353 query49 692 403 416 403 query50 824 397 499 397 query51 7058699970576999 query52 93 84 85 84 query53 247 173 178 173 query54 545 443 458 443 query55 74 77 74 74 query56 269 260 275 260 query57 1236108710971087 query58 229 229 220 220 query59 3112302428402840 query60 292 258 266 258 query61 97 113 101 101 query62 762 655 661 655 query63 215 182 177 177 query64 1274647 649 647 query65 3283317631883176 query66 674 305 298 298 query67 16054 15490 15271 15271 query68 1307550 543 543 query69 474 281 277 277 query70 1204112311591123 query71 346 270 264 264 query72 6420397539543954 query73 758 329 328 328 query74 9317892289958922 query75 3347265526872655 query76 1431879 940 879 query77 465 292 300 292 query78 10132 962993539353 query79 1182877 864 864 query80 857 574 558 558 query81 508 249 293 249 query82 1296227 226 226 query83 151 155 154 154 query84 291 99 100 99 query85 756 383 364 364 query86 329 321 325 321 query87 4415434743694347 query88 4277401540414015 query89 380 356 354 354 query90 1921304 301 301 query91 160 163 156 156 query92 76 70 71 70 query93 950 876 869 869 query94 752 356 359 356 query95 446 400 401 400 query96 477 484 484 484 query97 3169313331403133 query98 223 232 235 232 query99 1459130312851285 Total cold run time: 307889 ms Total hot run time: 198669 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2357717240 TPC-H: Total hot run time: 41343 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit c804027af9838170026fdc138f2b0a646ecedbe5, data reload: false -- Round 1 -- q1 17584 742072597259 q2 2052162 164 162 q3 10606 106012151060 q4 10559 714 748 714 q5 7761303730423037 q6 235 150 146 146 q7 1003610 620 610 q8 9438201120502011 q9 6705637763676367 q10 7002225322682253 q11 443 246 243 243 q12 398 207 209 207 q13 17789 297629482948 q14 236 214 217 214 q15 574 538 515 515 q16 667 618 625 618 q17 985 784 776 776 q18 7368668268196682 q19 1406104910101010 q20 591 285 280 280 q21 3950324932703249 q22 10881034982 982 Total cold run time: 108440 ms Total hot run time: 41343 ms - Round 2, with runtime_filter_mode=off - q1 7203720871817181 q2 339 228 227 227 q3 2958294129822941 q4 1995184517611761 q5 5685560255165516 q6 225 147 143 143 q7 2261179317471747 q8 3313343034193419 q9 8777898387818781 q10 3546337134533371 q11 589 490 481 481 q12 784 582 618 582 q13 10389 318031623162 q14 325 291 264 264 q15 587 526 526 526 q16 713 677 680 677 q17 1799154115821541 q18 8220786078607860 q19 1719155715621557 q20 2131189518671867 q21 5541527354605273 q22 1161105310311031 Total cold run time: 70260 ms Total hot run time: 59908 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2357707278 TeamCity be ut coverage result: Function Coverage: 37.33% (9583/25670) Line Coverage: 28.73% (79249/275880) Region Coverage: 28.19% (41019/145502) Branch Coverage: 24.81% (20903/84248) Coverage Report: http://coverage.selectdb-in.cc/coverage/c804027af9838170026fdc138f2b0a646ecedbe5_c804027af9838170026fdc138f2b0a646ecedbe5/report/index.html -- 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
Mryange commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2357650283 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
Mryange commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2357646626 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] [opt](datatype) avoid unnecessary copying in the push number for the date type, [doris]
doris-robot commented on PR #40916: URL: https://github.com/apache/doris/pull/40916#issuecomment-2357646478 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) Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website). See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document). -- 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]
