Re: [PR] [fix](cloud) fix routine load can not consume in cloud mode [doris]
dataroaring merged PR #33248: URL: https://github.com/apache/doris/pull/33248 -- 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](cloud) fix routine load can not consume in cloud mode [doris]
doris-robot commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036618671 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 31b5e14246915d9e95748ad934868e8665d2d35c with default session variables Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 16.2 seconds inserted 1000 Rows, about 617K ops/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: 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](cloud) fix routine load can not consume in cloud mode [doris]
doris-robot commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036612173 ClickBench: Total hot run time: 29.94 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 31b5e14246915d9e95748ad934868e8665d2d35c, data reload: false query1 0.040.040.03 query2 0.080.040.04 query3 0.250.040.05 query4 1.660.070.08 query5 0.500.480.50 query6 1.160.660.66 query7 0.020.010.02 query8 0.040.040.04 query9 0.560.500.50 query10 0.550.560.56 query11 0.160.120.12 query12 0.150.120.12 query13 0.600.590.59 query14 0.770.780.79 query15 0.860.850.85 query16 0.340.350.36 query17 0.980.990.99 query18 0.260.240.26 query19 1.801.741.80 query20 0.020.010.01 query21 15.41 0.650.66 query22 3.817.631.57 query23 18.03 1.331.26 query24 1.630.200.20 query25 0.160.080.08 query26 0.270.170.16 query27 0.070.080.08 query28 13.75 0.980.94 query29 12.63 3.273.30 query30 0.260.070.05 query31 2.830.400.38 query32 3.280.470.47 query33 2.862.842.90 query34 15.51 4.354.31 query35 4.354.374.39 query36 0.680.480.47 query37 0.180.160.16 query38 0.150.140.14 query39 0.040.040.04 query40 0.170.150.15 query41 0.100.050.06 query42 0.060.050.05 query43 0.040.040.03 Total cold run time: 107.07 s Total hot run time: 29.94 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: 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](cloud) fix routine load can not consume in cloud mode [doris]
doris-robot commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036599620 TPC-DS: Total hot run time: 182050 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 31b5e14246915d9e95748ad934868e8665d2d35c, data reload: false query1 1237110511171105 query2 6331191617631763 query3 6669235 218 218 query4 25726 21632 21417 21417 query5 4195399 409 399 query6 277 193 180 180 query7 4611295 295 295 query8 235 185 187 185 query9 8477227622392239 query10 445 243 253 243 query11 14961 14847 14639 14639 query12 144 90 88 88 query13 1649385 373 373 query14 8543686869186868 query15 207 168 176 168 query16 6832260 257 257 query17 1019564 558 558 query18 1828274 262 262 query19 196 151 149 149 query20 90 89 93 89 query21 196 127 126 126 query22 4985484448544844 query23 33635 32892 32666 32666 query24 10611 314331903143 query25 678 400 430 400 query26 1865172 160 160 query27 3199377 387 377 query28 7460191718971897 query29 1260622 641 622 query30 307 174 176 174 query31 972 735 750 735 query32 93 57 56 56 query33 649 243 238 238 query34 1116508 507 507 query35 852 713 707 707 query36 996 866 878 866 query37 273 84 78 78 query38 3510358536133585 query39 1651160716001600 query40 237 143 127 127 query41 48 46 46 46 query42 109 103 104 103 query43 463 409 429 409 query44 1163761 744 744 query45 317 262 278 262 query46 1134852 786 786 query47 1944186118961861 query48 377 306 316 306 query49 918 366 380 366 query50 836 404 419 404 query51 6867669867366698 query52 107 93 102 93 query53 353 295 297 295 query54 276 231 233 231 query55 85 77 75 75 query56 250 224 243 224 query57 1312113111901131 query58 245 239 228 228 query59 2707266824992499 query60 253 250 232 232 query61 91 86 88 86 query62 653 442 451 442 query63 303 282 279 279 query64 5836317731493149 query65 3041301930063006 query66 1300315 315 315 query67 15433 15030 14747 14747 query68 9240576 580 576 query69 547 309 290 290 query70 1374111210821082 query71 524 272 266 266 query72 6263257124292429 query73 1399316 321 316 query74 6577641563086308 query75 3994226522822265 query76 6222120112341201 query77 635 244 244 244 query78 10928 10192 10209 10192 query79 8732537 536 536 query80 1337434 424 424 query81 492 237 229 229 query82 492 96 98 96 query83 220 170 168 168 query84 267 91 88 88 query85 978 282 274 274 query86 368 288 293 288 query87 3698351534913491 query88 3836232323402323 query89 568 369 377 369 query90 2172181 178 178 query91 130 107 103 103 query92 58 48 48 48 query93 6334539 542 539 query94 1190186 184 184 query95 422 321 315 315 query96 619 273 272 272 query97 2671250324782478 query98 221 219 216 216 query99 1300842 851 842 Total cold run time: 298446 ms Total hot run time: 182050 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](cloud) fix routine load can not consume in cloud mode [doris]
doris-robot commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036575297 TPC-H: Total hot run time: 38282 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 31b5e14246915d9e95748ad934868e8665d2d35c, data reload: false -- Round 1 -- q1 17701 404440384038 q2 2013186 180 180 q3 10491 117412851174 q4 10213 809 951 809 q5 7482291829142914 q6 219 132 133 132 q7 1097647 613 613 q8 9407189420141894 q9 6700613861596138 q10 8462350234803480 q11 423 242 242 242 q12 397 220 214 214 q13 17780 291229152912 q14 271 241 239 239 q15 524 491 481 481 q16 511 391 368 368 q17 945 913 907 907 q18 7291642163436343 q19 2177154315131513 q20 549 306 303 303 q21 3511308831123088 q22 345 306 300 300 Total cold run time: 108509 ms Total hot run time: 38282 ms - Round 2, with runtime_filter_mode=off - q1 4080402340204020 q2 318 220 214 214 q3 2946294829252925 q4 1833185818301830 q5 5194519151995191 q6 208 124 125 124 q7 2245177218241772 q8 3191324732373237 q9 8434846284638462 q10 3729390540143905 q11 554 455 467 455 q12 751 607 599 599 q13 16801 309831373098 q14 302 271 276 271 q15 543 483 519 483 q16 493 441 452 441 q17 1776173617351735 q18 8188772675697569 q19 1716167816771677 q20 2015182318191819 q21 5257480749774807 q22 507 441 456 441 Total cold run time: 71081 ms Total hot run time: 55075 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](cloud) fix routine load can not consume in cloud mode [doris]
HHoflittlefish777 commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036546294 run p0 -- 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](cloud) fix routine load can not consume in cloud mode [doris]
github-actions[bot] commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036535480 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: 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](cloud) fix routine load can not consume in cloud mode [doris]
HHoflittlefish777 commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036473527 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](cloud) fix routine load can not consume in cloud mode [doris]
doris-robot commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036301180 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 31b5e14246915d9e95748ad934868e8665d2d35c with default session variables Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s Insert into select: 15.2 seconds inserted 1000 Rows, about 657K ops/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: 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](cloud) fix routine load can not consume in cloud mode [doris]
doris-robot commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036296961 ClickBench: Total hot run time: 29.94 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 31b5e14246915d9e95748ad934868e8665d2d35c, data reload: false query1 0.040.040.02 query2 0.080.040.04 query3 0.240.050.05 query4 1.660.070.07 query5 0.480.480.48 query6 1.120.650.65 query7 0.020.010.01 query8 0.050.040.05 query9 0.610.520.51 query10 0.580.570.55 query11 0.160.110.11 query12 0.140.120.12 query13 0.610.590.59 query14 0.770.780.79 query15 0.860.840.84 query16 0.360.350.36 query17 0.971.010.99 query18 0.240.240.25 query19 1.821.731.77 query20 0.020.010.01 query21 15.41 0.640.66 query22 4.217.261.61 query23 18.17 1.211.21 query24 1.450.220.19 query25 0.160.090.07 query26 0.270.160.16 query27 0.070.080.08 query28 13.89 0.970.95 query29 12.51 3.333.30 query30 0.270.060.05 query31 3.240.390.40 query32 3.260.480.47 query33 2.872.882.96 query34 15.48 4.334.31 query35 4.384.384.34 query36 0.700.470.49 query37 0.180.160.16 query38 0.180.150.16 query39 0.040.040.04 query40 0.190.150.17 query41 0.100.050.05 query42 0.060.060.05 query43 0.040.040.04 Total cold run time: 107.96 s Total hot run time: 29.94 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: 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](cloud) fix routine load can not consume in cloud mode [doris]
doris-robot commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036288716 TPC-DS: Total hot run time: 180965 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 31b5e14246915d9e95748ad934868e8665d2d35c, data reload: false query1 887 372 1115372 query2 6295193718841884 query3 6647205 206 205 query4 24093 21427 21255 21255 query5 4186394 403 394 query6 280 202 186 186 query7 4607297 294 294 query8 235 173 168 168 query9 8474225322562253 query10 449 241 259 241 query11 15005 14517 14388 14388 query12 140 89 86 86 query13 1649382 381 381 query14 8498682868396828 query15 211 170 171 170 query16 6833267 272 267 query17 989 569 565 565 query18 1866289 271 271 query19 194 155 154 154 query20 93 89 86 86 query21 201 126 131 126 query22 5053488849504888 query23 33692 32905 32791 32791 query24 12018 318132073181 query25 694 374 383 374 query26 1800159 164 159 query27 3190368 372 368 query28 7327189318991893 query29 1295594 577 577 query30 326 167 163 163 query31 992 752 753 752 query32 94 58 52 52 query33 664 244 233 233 query34 1348519 494 494 query35 837 715 721 715 query36 1025877 881 877 query37 268 73 73 73 query38 3560365435233523 query39 1652157715941577 query40 258 139 130 130 query41 50 46 47 46 query42 115 103 99 99 query43 456 425 415 415 query44 1211757 735 735 query45 297 296 286 286 query46 848 811 811 query47 2002190718741874 query48 394 307 310 307 query49 928 375 375 375 query50 842 401 412 401 query51 6863666467236664 query52 109 92 101 92 query53 367 288 292 288 query54 297 240 256 240 query55 85 79 79 79 query56 263 235 249 235 query57 1302119911801180 query58 248 220 219 219 query59 2673235723732357 query60 266 242 263 242 query61 108 106 105 105 query62 668 468 449 449 query63 308 284 289 284 query64 5844312831373128 query65 3052301629992999 query66 1297311 312 311 query67 15655 15178 14803 14803 query68 7153553 565 553 query69 534 293 311 293 query70 1271113611211121 query71 525 268 266 266 query72 6279258924242424 query73 816 313 312 312 query74 6973635263876352 query75 3581228122882281 query76 5088120912201209 query77 600 238 239 238 query78 10927 10117 10100 10100 query79 9923532 528 528 query80 1726421 428 421 query81 523 233 231 231 query82 673 98 94 94 query83 203 166 178 166 query84 264 90 83 83 query85 1379288 281 281 query86 463 290 311 290 query87 3655351735133513 query88 4193227822872278 query89 574 370 374 370 query90 2021184 175 175 query91 129 99 108 99 query92 65 49 50 49 query93 7273543 543 543 query94 1066181 176 176 query95 414 320 313 313 query96 630 274 267 267 query97 2669246624932466 query98 226 218 217 217 query99 1291854 838 838 Total cold run time: 297843 ms Total hot run time: 180965 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](cloud) fix routine load can not consume in cloud mode [doris]
github-actions[bot] commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036275365 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: 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](cloud) fix routine load can not consume in cloud mode [doris]
doris-robot commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036272745 TPC-H: Total hot run time: 38415 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 31b5e14246915d9e95748ad934868e8665d2d35c, data reload: false -- Round 1 -- q1 17631 405540894055 q2 2012182 177 177 q3 10490 115513251155 q4 10208 849 960 849 q5 7462297929292929 q6 219 133 131 131 q7 1095623 598 598 q8 9392205620262026 q9 6682620361586158 q10 8459351834763476 q11 418 236 236 236 q12 381 211 200 200 q13 17769 288729022887 q14 272 240 236 236 q15 515 496 479 479 q16 506 384 370 370 q17 949 888 902 888 q18 7193639064016390 q19 1609153015381530 q20 559 320 293 293 q21 3489311430633063 q22 352 289 309 289 Total cold run time: 107662 ms Total hot run time: 38415 ms - Round 2, with runtime_filter_mode=off - q1 4063402340664023 q2 327 216 219 216 q3 2956293529242924 q4 1855185318591853 q5 5276520351915191 q6 209 122 126 122 q7 2202181018341810 q8 3202329832673267 q9 8459843684318431 q10 3765392839863928 q11 580 457 460 457 q12 735 585 574 574 q13 16977 308030493049 q14 310 264 279 264 q15 528 518 499 499 q16 482 428 456 428 q17 1786172116871687 q18 8252770976777677 q19 1695168116521652 q20 2036181618531816 q21 5174496849724968 q22 505 463 437 437 Total cold run time: 71374 ms Total hot run time: 55273 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](cloud) fix routine load can not consume in cloud mode [doris]
HHoflittlefish777 commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036228247 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
[PR] [fix](cloud) fix routine load can not consume in cloud mode [doris]
HHoflittlefish777 opened a new pull request, #33248: URL: https://github.com/apache/doris/pull/33248 ## Proposed changes Issue Number: close #xxx ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- 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](cloud) fix routine load can not consume in cloud mode [doris]
doris-robot commented on PR #33248: URL: https://github.com/apache/doris/pull/33248#issuecomment-2036226911 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: 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