You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morningman (via GitHub)" <gi...@apache.org> on 2024/01/04 14:28:25 UTC
[PR] [minor](jdbc) fix wrong log and add more info [doris]
morningman opened a new pull request, #29557:
URL: https://github.com/apache/doris/pull/29557
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [minor](jdbc) fix wrong log and add more info [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29557:
URL: https://github.com/apache/doris/pull/29557#issuecomment-1884264235
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [minor](jdbc) fix wrong log and add more info [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29557:
URL: https://github.com/apache/doris/pull/29557#issuecomment-1878394142
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 48.2 seconds
stream load tsv: 579 seconds loaded 74807831229 Bytes, about 123 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 27.7 seconds inserted 10000000 Rows, about 361K ops/s
storage size: 17183707719 Bytes
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [minor](jdbc) fix wrong log and add more info [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29557:
URL: https://github.com/apache/doris/pull/29557#issuecomment-1878416607
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit c6e72adb82e96b8ccf516c4fc5aedd00e2088810, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5505 5073 5177 5073
q2 382 200 159 159
q3 1444 1184 1225 1184
q4 1071 830 830 830
q5 3082 3141 3136 3136
q6 217 131 136 131
q7 978 547 519 519
q8 2144 2263 2219 2219
q9 6718 6622 6651 6622
q10 3152 3143 3098 3098
q11 345 216 208 208
q12 381 223 238 223
q13 4375 3638 3635 3635
q14 242 221 224 221
q15 578 550 524 524
q16 453 395 391 391
q17 1036 569 478 478
q18 7078 6722 6853 6722
q19 1643 1543 1593 1543
q20 587 319 321 319
q21 2926 2409 2490 2409
q22 402 311 319 311
Total cold run time: 44739 ms
Total hot run time: 39955 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5132 5120 5066 5066
q2 338 238 235 235
q3 3350 3306 3309 3306
q4 2129 2031 2012 2012
q5 5918 5893 5937 5893
q6 224 127 129 127
q7 2395 1926 1909 1909
q8 3526 3657 3699 3657
q9 8984 8958 8941 8941
q10 3859 3900 3914 3900
q11 570 481 495 481
q12 807 634 627 627
q13 3860 3168 3155 3155
q14 311 324 287 287
q15 580 522 529 522
q16 562 519 505 505
q17 2041 1809 1804 1804
q18 8693 8311 8415 8311
q19 1742 1682 1649 1649
q20 2272 1971 1967 1967
q21 5755 5327 5275 5275
q22 561 536 515 515
Total cold run time: 63609 ms
Total hot run time: 60144 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [minor](jdbc) fix wrong log and add more info [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29557:
URL: https://github.com/apache/doris/pull/29557#issuecomment-1878391949
TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
```
TPC-DS sf100 test result on commit c6e72adb82e96b8ccf516c4fc5aedd00e2088810, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 959 345 336 336
query2 6419 2011 2005 2005
query3 6662 219 205 205
query4 27449 22559 22584 22559
query5 3887 555 542 542
query6 268 193 189 189
query7 4581 285 275 275
query8 222 204 192 192
query9 8266 2759 2475 2475
query10 409 255 235 235
query11 16144 15657 15453 15453
query12 134 78 76 76
query13 1635 319 316 316
query14 11386 7181 7222 7181
query15 216 183 191 183
query16 6345 280 256 256
query17 1875 485 481 481
query18 1959 267 265 265
query19 187 133 130 130
query20 80 73 76 73
query21 183 98 96 96
query22 4868 4607 4647 4607
query23 32441 31269 31215 31215
query24 12130 2812 2840 2812
query25 605 345 336 336
query26 1814 140 140 140
query27 2897 274 275 274
query28 6910 1873 1887 1873
query29 2101 383 383 383
query30 287 143 154 143
query31 976 756 765 756
query32 90 54 57 54
query33 737 251 269 251
query34 906 445 440 440
query35 900 769 782 769
query36 1327 1255 1173 1173
query37 191 70 69 69
query38 3395 3297 3235 3235
query39 1344 1288 1272 1272
query40 300 93 86 86
query41 39 36 36 36
query42 93 84 84 84
query43 516 485 488 485
query44 1047 701 709 701
query45 195 189 180 180
query46 1061 647 636 636
query47 1680 1597 1604 1597
query48 324 261 259 259
query49 1224 320 319 319
query50 803 338 341 338
query51 5345 5251 5304 5251
query52 102 83 94 83
query53 217 144 146 144
query54 1375 554 577 554
query55 96 87 91 87
query56 195 193 192 192
query57 1019 947 973 947
query58 232 203 195 195
query59 2853 2604 2657 2604
query60 233 226 227 226
query61 88 83 84 83
query62 647 458 449 449
query63 167 153 144 144
query64 5811 1779 1685 1685
query65 3323 3266 3280 3266
query66 1393 347 347 347
query67 15729 15324 15214 15214
query68 12542 546 532 532
query69 503 257 254 254
query70 1749 1532 1479 1479
query71 498 220 200 200
query72 5615 3603 3542 3542
query73 2901 312 309 309
query74 7039 6420 6460 6420
query75 5254 2310 2291 2291
query76 6325 1200 1123 1123
query77 676 249 258 249
query78 9067 8723 8522 8522
query79 1058 517 502 502
query80 555 355 340 340
query81 470 216 209 209
query82 201 95 95 95
query83 171 138 136 136
query84 251 54 54 54
query85 947 279 280 279
query86 386 403 412 403
query87 3630 3400 3326 3326
query88 3187 2262 2268 2262
query89 340 260 268 260
query90 1903 200 195 195
query91 130 89 90 89
query92 63 55 55 55
query93 1707 507 433 433
query94 818 183 186 183
query95 467 411 415 411
query96 624 319 327 319
query97 4320 4158 4179 4158
query98 205 199 191 191
query99 1137 878 854 854
Total cold run time: 294031 ms
Total hot run time: 179192 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [minor](jdbc) fix wrong log and add more info [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29557:
URL: https://github.com/apache/doris/pull/29557#issuecomment-1884239924
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [minor](jdbc) fix wrong log and add more info [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk merged PR #29557:
URL: https://github.com/apache/doris/pull/29557
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [minor](jdbc) fix wrong log and add more info [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29557:
URL: https://github.com/apache/doris/pull/29557#issuecomment-1878377043
TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
```
Tpch sf100 test result on commit c6e72adb82e96b8ccf516c4fc5aedd00e2088810, data reload: false
------ Round 1 ----------------------------------
q1 18166 5394 5167 5167
q2 2036 157 148 148
q3 10629 1051 1136 1051
q4 10419 767 829 767
q5 7815 2938 2845 2845
q6 215 133 134 133
q7 910 515 526 515
q8 9259 2054 2045 2045
q9 6865 6419 6409 6409
q10 8232 3056 3084 3056
q11 433 218 212 212
q12 388 228 228 228
q13 18017 3629 3635 3629
q14 245 225 214 214
q15 565 524 524 524
q16 448 405 409 405
q17 957 437 536 437
q18 7489 6727 6734 6727
q19 1576 1327 1361 1327
q20 740 331 338 331
q21 2793 2380 2435 2380
q22 387 327 324 324
Total cold run time: 108584 ms
Total hot run time: 38874 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5202 5122 5112 5112
q2 343 244 237 237
q3 3332 3310 3268 3268
q4 2103 2005 2004 2004
q5 5834 5825 5816 5816
q6 219 125 127 125
q7 2344 1938 1933 1933
q8 3379 3464 3502 3464
q9 8854 8799 8779 8779
q10 3793 3857 3843 3843
q11 598 470 487 470
q12 797 627 641 627
q13 6956 3197 3190 3190
q14 308 270 275 270
q15 579 515 515 515
q16 545 471 499 471
q17 1947 1779 1736 1736
q18 8708 8433 8326 8326
q19 1620 1588 1575 1575
q20 2188 1980 1974 1974
q21 5563 5343 5293 5293
q22 529 510 482 482
Total cold run time: 65741 ms
Total hot run time: 59510 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [minor](jdbc) fix wrong log and add more info [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #29557:
URL: https://github.com/apache/doris/pull/29557#issuecomment-1878353806
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org