You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "bobhan1 (via GitHub)" <gi...@apache.org> on 2024/06/17 15:13:54 UTC
[PR] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
bobhan1 opened a new pull request, #36421:
URL: https://github.com/apache/doris/pull/36421
(no comment)
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "bobhan1 (via GitHub)" <gi...@apache.org>.
bobhan1 commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2186304307
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
Re: [PR] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173814922
<details>
<summary>TPC-DS: <b>Total hot run time: 173836 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 38154b40c2b397028c705e032ffea76eb60271d5, data reload: false
query1 931 383 373 373
query2 6445 2479 2322 2322
query3 6638 210 213 210
query4 18793 17545 17273 17273
query5 3617 490 458 458
query6 255 163 163 163
query7 4579 295 289 289
query8 317 299 281 281
query9 8543 2401 2392 2392
query10 580 303 294 294
query11 10644 10019 10015 10015
query12 122 92 89 89
query13 1639 365 363 363
query14 10161 7638 7876 7638
query15 238 192 197 192
query16 7823 275 302 275
query17 1814 558 528 528
query18 2020 289 281 281
query19 203 161 158 158
query20 96 87 84 84
query21 213 135 130 130
query22 4713 4503 4347 4347
query23 34061 33616 33735 33616
query24 10590 2757 2730 2730
query25 573 357 359 357
query26 728 156 147 147
query27 2202 308 311 308
query28 5956 2013 2028 2013
query29 842 615 602 602
query30 224 149 150 149
query31 934 722 746 722
query32 93 54 53 53
query33 648 287 277 277
query34 912 461 457 457
query35 722 614 611 611
query36 1069 920 907 907
query37 143 71 75 71
query38 2839 2764 2729 2729
query39 870 794 809 794
query40 200 125 122 122
query41 56 51 49 49
query42 113 95 97 95
query43 570 565 539 539
query44 1102 724 736 724
query45 206 171 162 162
query46 1065 731 746 731
query47 1883 1760 1766 1760
query48 375 302 303 302
query49 857 415 457 415
query50 759 388 387 387
query51 6777 6670 6693 6670
query52 112 89 97 89
query53 359 283 293 283
query54 874 443 437 437
query55 76 71 74 71
query56 284 253 260 253
query57 1092 1027 1060 1027
query58 266 236 251 236
query59 3581 3081 3044 3044
query60 296 267 267 267
query61 93 92 92 92
query62 620 453 469 453
query63 322 294 289 289
query64 8561 2233 1721 1721
query65 3161 3096 3106 3096
query66 748 319 329 319
query67 15349 14805 14800 14800
query68 4509 530 546 530
query69 523 378 350 350
query70 1207 1103 1189 1103
query71 433 270 269 269
query72 7341 5548 5437 5437
query73 734 325 322 322
query74 5890 5525 5800 5525
query75 3405 2694 2702 2694
query76 2760 940 877 877
query77 478 302 292 292
query78 10298 9798 9677 9677
query79 2554 530 511 511
query80 1146 505 457 457
query81 590 214 220 214
query82 789 104 106 104
query83 227 169 168 168
query84 234 84 86 84
query85 1543 299 294 294
query86 477 312 319 312
query87 3287 3068 3102 3068
query88 4072 2362 2355 2355
query89 475 387 385 385
query90 1670 200 194 194
query91 130 104 103 103
query92 65 51 53 51
query93 2043 489 495 489
query94 1054 194 197 194
query95 433 390 325 325
query96 584 267 273 267
query97 3186 3024 3070 3024
query98 224 204 203 203
query99 1160 837 827 827
Total cold run time: 267068 ms
Total hot run time: 173836 ms
```
</details>
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "bobhan1 (via GitHub)" <gi...@apache.org>.
bobhan1 commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173682937
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
Re: [PR] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2186200275
<details>
<summary>TPC-DS: <b>Total hot run time: 175165 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 6cdebf692f971fbf261ce116689e2ca5276cdd50, data reload: false
query1 940 388 369 369
query2 6446 2352 2226 2226
query3 6625 210 214 210
query4 23009 17492 17430 17430
query5 3626 476 465 465
query6 245 161 163 161
query7 4581 305 290 290
query8 312 298 306 298
query9 8451 2473 2454 2454
query10 582 283 297 283
query11 10624 10309 10235 10235
query12 114 83 82 82
query13 1641 364 357 357
query14 10121 6928 7809 6928
query15 244 191 194 191
query16 7853 283 284 283
query17 1867 572 540 540
query18 1990 287 284 284
query19 207 158 157 157
query20 93 92 87 87
query21 212 130 127 127
query22 4453 4290 4309 4290
query23 34097 33642 33702 33642
query24 10806 2884 3017 2884
query25 606 415 404 404
query26 727 160 158 158
query27 2309 334 337 334
query28 5519 2177 2162 2162
query29 899 653 649 649
query30 250 158 159 158
query31 977 777 850 777
query32 95 56 54 54
query33 650 302 303 302
query34 866 488 477 477
query35 760 671 657 657
query36 1131 986 995 986
query37 143 75 71 71
query38 3005 2900 2869 2869
query39 891 825 818 818
query40 215 135 125 125
query41 54 51 56 51
query42 109 102 99 99
query43 590 539 532 532
query44 1091 727 744 727
query45 193 162 158 158
query46 1070 722 706 706
query47 1910 1798 1792 1792
query48 361 321 297 297
query49 845 402 417 402
query50 781 389 394 389
query51 6920 6761 6703 6703
query52 101 95 89 89
query53 360 289 279 279
query54 876 448 447 447
query55 76 74 73 73
query56 279 256 259 256
query57 1154 1046 1090 1046
query58 258 266 249 249
query59 3391 3266 3320 3266
query60 298 263 282 263
query61 92 90 93 90
query62 601 447 447 447
query63 311 301 288 288
query64 8512 2249 1736 1736
query65 3131 3098 3096 3096
query66 738 333 316 316
query67 15648 15027 15079 15027
query68 4600 539 539 539
query69 490 305 323 305
query70 1139 1092 1175 1092
query71 376 279 283 279
query72 7975 5687 5452 5452
query73 741 332 327 327
query74 6009 5589 5570 5570
query75 3384 2668 2675 2668
query76 2379 944 885 885
query77 665 309 286 286
query78 10393 9864 9898 9864
query79 4162 519 518 518
query80 1058 468 473 468
query81 559 221 228 221
query82 772 104 102 102
query83 329 178 175 175
query84 275 101 90 90
query85 1323 289 279 279
query86 459 322 309 309
query87 3279 3158 3093 3093
query88 4849 2454 2457 2454
query89 559 377 380 377
query90 1824 186 191 186
query91 129 102 103 102
query92 59 50 48 48
query93 5165 548 529 529
query94 1162 194 190 190
query95 405 317 317 317
query96 606 270 266 266
query97 3209 3044 3091 3044
query98 224 203 190 190
query99 1145 842 859 842
Total cold run time: 277635 ms
Total hot run time: 175165 ms
```
</details>
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "bobhan1 (via GitHub)" <gi...@apache.org>.
bobhan1 commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2191624090
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
Re: [PR] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2186002335
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
Re: [PR] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2186367775
<details>
<summary>TPC-DS: <b>Total hot run time: 173641 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit c73fd0c0490ec02cc6c0fe961e6952dc9fb3da21, data reload: false
query1 921 378 390 378
query2 6448 2451 2488 2451
query3 6644 210 201 201
query4 19311 17341 17211 17211
query5 4150 499 479 479
query6 256 171 166 166
query7 4587 315 301 301
query8 357 318 323 318
query9 8665 2469 2463 2463
query10 603 287 291 287
query11 10536 10064 9884 9884
query12 130 88 88 88
query13 1644 376 379 376
query14 9622 7678 7804 7678
query15 266 199 191 191
query16 8084 269 280 269
query17 1891 531 524 524
query18 1690 295 276 276
query19 194 156 155 155
query20 91 91 83 83
query21 211 130 126 126
query22 4178 4115 4017 4017
query23 33742 32998 33032 32998
query24 10981 2834 2863 2834
query25 619 372 367 367
query26 1461 156 165 156
query27 2885 326 323 323
query28 7395 2114 2111 2111
query29 907 622 631 622
query30 290 158 160 158
query31 950 754 745 745
query32 99 59 56 56
query33 770 296 287 287
query34 952 504 482 482
query35 710 646 620 620
query36 1091 937 893 893
query37 167 75 72 72
query38 2899 2724 2768 2724
query39 887 815 785 785
query40 276 137 129 129
query41 54 50 52 50
query42 120 101 99 99
query43 601 582 565 565
query44 1204 738 740 738
query45 199 165 156 156
query46 1081 741 756 741
query47 1836 1806 1730 1730
query48 379 296 297 296
query49 1183 418 423 418
query50 774 398 400 398
query51 6925 6763 6619 6619
query52 102 95 91 91
query53 366 303 297 297
query54 919 462 454 454
query55 78 75 76 75
query56 295 279 270 270
query57 1149 1073 1052 1052
query58 253 250 272 250
query59 3593 3309 3078 3078
query60 306 292 286 286
query61 94 94 94 94
query62 647 448 464 448
query63 336 298 295 295
query64 9777 2288 1820 1820
query65 3206 3130 3102 3102
query66 1317 356 330 330
query67 15345 14726 15048 14726
query68 4560 546 549 546
query69 467 313 330 313
query70 1177 1206 1157 1157
query71 405 274 281 274
query72 7067 5808 5341 5341
query73 749 332 335 332
query74 5929 5590 5525 5525
query75 3387 2673 2680 2673
query76 2490 902 951 902
query77 446 312 299 299
query78 10491 9824 9684 9684
query79 2625 528 536 528
query80 1173 498 498 498
query81 590 222 229 222
query82 871 114 104 104
query83 249 174 181 174
query84 241 99 92 92
query85 1364 344 278 278
query86 463 339 308 308
query87 3270 3105 3094 3094
query88 4090 2443 2482 2443
query89 487 416 403 403
query90 1760 211 196 196
query91 136 100 105 100
query92 68 49 52 49
query93 1809 520 520 520
query94 1266 198 196 196
query95 416 331 334 331
query96 593 280 272 272
query97 3246 3001 3105 3001
query98 217 200 198 198
query99 1116 864 826 826
Total cold run time: 272917 ms
Total hot run time: 173641 ms
```
</details>
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "bobhan1 (via GitHub)" <gi...@apache.org>.
bobhan1 commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173736455
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
Re: [PR] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173761404
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173696712
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2180548885
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2186377072
<details>
<summary>ClickBench: <b>Total hot run time: 30.7 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit c73fd0c0490ec02cc6c0fe961e6952dc9fb3da21, data reload: false
query1 0.03 0.04 0.03
query2 0.08 0.04 0.04
query3 0.21 0.05 0.05
query4 1.68 0.07 0.08
query5 0.51 0.49 0.48
query6 1.13 0.73 0.74
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.53 0.49 0.49
query10 0.56 0.53 0.55
query11 0.15 0.11 0.11
query12 0.15 0.12 0.12
query13 0.59 0.59 0.58
query14 0.75 0.80 0.80
query15 0.83 0.81 0.84
query16 0.37 0.36 0.34
query17 1.02 0.97 0.95
query18 0.20 0.24 0.24
query19 1.79 1.76 1.72
query20 0.01 0.01 0.01
query21 15.42 0.66 0.65
query22 4.19 6.61 2.02
query23 18.32 1.39 1.23
query24 2.11 0.23 0.21
query25 0.16 0.08 0.08
query26 0.27 0.18 0.17
query27 0.08 0.08 0.08
query28 13.26 1.02 1.01
query29 12.61 3.36 3.35
query30 0.26 0.06 0.06
query31 2.85 0.39 0.37
query32 3.29 0.47 0.48
query33 2.90 2.95 2.89
query34 16.89 4.43 4.48
query35 4.50 4.51 4.48
query36 0.65 0.48 0.47
query37 0.18 0.16 0.15
query38 0.16 0.15 0.14
query39 0.04 0.04 0.03
query40 0.17 0.15 0.14
query41 0.09 0.05 0.04
query42 0.06 0.04 0.05
query43 0.04 0.04 0.05
Total cold run time: 109.16 s
Total hot run time: 30.7 s
```
</details>
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173682575
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-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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173825491
<details>
<summary>ClickBench: <b>Total hot run time: 30.79 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 38154b40c2b397028c705e032ffea76eb60271d5, data reload: false
query1 0.04 0.04 0.04
query2 0.08 0.03 0.04
query3 0.23 0.06 0.06
query4 1.66 0.10 0.08
query5 0.51 0.50 0.51
query6 1.12 0.73 0.72
query7 0.02 0.02 0.02
query8 0.04 0.04 0.04
query9 0.54 0.49 0.49
query10 0.55 0.55 0.54
query11 0.16 0.12 0.11
query12 0.15 0.12 0.12
query13 0.59 0.59 0.60
query14 0.79 0.76 0.79
query15 0.83 0.82 0.82
query16 0.37 0.37 0.37
query17 0.98 0.98 0.99
query18 0.20 0.27 0.24
query19 1.79 1.73 1.77
query20 0.01 0.01 0.02
query21 15.42 0.68 0.66
query22 4.41 6.69 2.13
query23 18.23 1.51 1.28
query24 2.17 0.24 0.21
query25 0.15 0.09 0.10
query26 0.26 0.18 0.18
query27 0.08 0.09 0.08
query28 13.21 1.02 0.99
query29 12.63 3.22 3.26
query30 0.26 0.07 0.06
query31 2.88 0.38 0.37
query32 3.29 0.48 0.46
query33 2.89 2.90 2.95
query34 16.83 4.40 4.42
query35 4.56 4.52 4.49
query36 0.65 0.45 0.48
query37 0.18 0.15 0.15
query38 0.15 0.15 0.14
query39 0.04 0.03 0.04
query40 0.17 0.13 0.15
query41 0.09 0.04 0.04
query42 0.06 0.05 0.04
query43 0.05 0.04 0.04
Total cold run time: 109.32 s
Total hot run time: 30.79 s
```
</details>
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2186210526
<details>
<summary>ClickBench: <b>Total hot run time: 30.6 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 6cdebf692f971fbf261ce116689e2ca5276cdd50, data reload: false
query1 0.04 0.03 0.03
query2 0.09 0.04 0.04
query3 0.23 0.05 0.05
query4 1.69 0.07 0.07
query5 0.51 0.49 0.47
query6 1.16 0.72 0.72
query7 0.02 0.02 0.01
query8 0.05 0.04 0.05
query9 0.53 0.50 0.49
query10 0.53 0.54 0.53
query11 0.16 0.12 0.12
query12 0.15 0.12 0.12
query13 0.59 0.59 0.59
query14 0.75 0.79 0.82
query15 0.82 0.80 0.81
query16 0.36 0.36 0.35
query17 0.95 0.99 1.00
query18 0.20 0.30 0.20
query19 1.85 1.72 1.69
query20 0.01 0.01 0.01
query21 15.42 0.67 0.66
query22 3.70 8.13 1.91
query23 18.28 1.44 1.28
query24 2.13 0.22 0.23
query25 0.15 0.08 0.09
query26 0.27 0.18 0.17
query27 0.08 0.08 0.08
query28 13.23 1.04 1.00
query29 12.62 3.34 3.31
query30 0.26 0.06 0.05
query31 2.85 0.38 0.39
query32 3.28 0.48 0.49
query33 2.87 2.88 2.92
query34 17.02 4.43 4.49
query35 4.59 4.51 4.53
query36 0.65 0.45 0.47
query37 0.18 0.16 0.15
query38 0.15 0.15 0.14
query39 0.04 0.03 0.03
query40 0.18 0.14 0.14
query41 0.09 0.05 0.05
query42 0.05 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 108.83 s
Total hot run time: 30.6 s
```
</details>
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2180574425
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173818086
TeamCity be ut coverage result:
Function Coverage: 36.48% (9004/24679)
Line Coverage: 28.02% (73752/263203)
Region Coverage: 27.49% (38305/139335)
Branch Coverage: 24.19% (19527/80732)
Coverage Report: http://coverage.selectdb-in.cc/coverage/38154b40c2b397028c705e032ffea76eb60271d5_38154b40c2b397028c705e032ffea76eb60271d5/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: 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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173790090
<details>
<summary>TPC-H: <b>Total hot run time: 39815 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 38154b40c2b397028c705e032ffea76eb60271d5, data reload: false
------ Round 1 ----------------------------------
q1 17621 4313 4285 4285
q2 2035 190 189 189
q3 10473 1148 1160 1148
q4 10203 906 726 726
q5 7465 2674 2695 2674
q6 226 137 135 135
q7 966 601 592 592
q8 9225 2045 2056 2045
q9 8946 6491 6471 6471
q10 8949 3692 3724 3692
q11 461 233 234 233
q12 398 237 221 221
q13 17755 2999 2987 2987
q14 263 222 214 214
q15 518 479 487 479
q16 521 382 383 382
q17 950 656 679 656
q18 7882 7412 7445 7412
q19 4244 1484 1573 1484
q20 652 332 315 315
q21 4925 3265 3141 3141
q22 395 334 337 334
Total cold run time: 115073 ms
Total hot run time: 39815 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4362 4272 4264 4264
q2 356 268 271 268
q3 2987 2731 3052 2731
q4 2008 1786 1710 1710
q5 5612 5469 5524 5469
q6 224 127 130 127
q7 2169 1857 1823 1823
q8 3252 3419 3390 3390
q9 8697 8666 8817 8666
q10 4095 3859 3734 3734
q11 583 478 466 466
q12 806 643 651 643
q13 16560 3301 3180 3180
q14 287 275 281 275
q15 527 485 494 485
q16 491 423 428 423
q17 1800 1490 1461 1461
q18 8151 7871 7676 7676
q19 2078 1529 1495 1495
q20 3060 1927 1866 1866
q21 5033 4932 4899 4899
q22 616 532 535 532
Total cold run time: 73754 ms
Total hot run time: 55583 ms
```
</details>
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173761491
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2191636248
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2173748485
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2186319250
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2186345549
<details>
<summary>TPC-H: <b>Total hot run time: 40013 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit c73fd0c0490ec02cc6c0fe961e6952dc9fb3da21, data reload: false
------ Round 1 ----------------------------------
q1 17924 4681 4409 4409
q2 2357 205 184 184
q3 10517 1246 1146 1146
q4 10204 765 824 765
q5 7451 2676 2553 2553
q6 219 132 133 132
q7 946 592 608 592
q8 9214 2053 2068 2053
q9 8745 6445 6472 6445
q10 8955 3717 3744 3717
q11 460 244 244 244
q12 406 244 228 228
q13 17784 2973 2987 2973
q14 271 233 214 214
q15 527 501 488 488
q16 527 385 381 381
q17 953 748 620 620
q18 8079 7500 7454 7454
q19 7956 1484 1464 1464
q20 651 331 327 327
q21 4889 3368 3275 3275
q22 413 350 349 349
Total cold run time: 119448 ms
Total hot run time: 40013 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4456 4263 4372 4263
q2 359 273 266 266
q3 2947 2744 2726 2726
q4 1876 1578 1619 1578
q5 5289 5329 5346 5329
q6 222 125 126 125
q7 2133 1713 1720 1713
q8 3182 3319 3320 3319
q9 8361 8391 8367 8367
q10 3867 3708 3662 3662
q11 571 499 485 485
q12 792 597 589 589
q13 16401 3025 3010 3010
q14 294 271 280 271
q15 526 472 486 472
q16 461 424 410 410
q17 1777 1477 1486 1477
q18 7659 7464 7451 7451
q19 1660 1595 1452 1452
q20 1973 1808 1836 1808
q21 7725 4728 4775 4728
q22 606 576 603 576
Total cold run time: 73137 ms
Total hot run time: 54077 ms
```
</details>
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2180554741
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Fix](autoinc) try fix concurrent load problem with auto inc column [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36421:
URL: https://github.com/apache/doris/pull/36421#issuecomment-2186176818
<details>
<summary>TPC-H: <b>Total hot run time: 39823 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 6cdebf692f971fbf261ce116689e2ca5276cdd50, data reload: false
------ Round 1 ----------------------------------
q1 17939 4731 4271 4271
q2 2006 195 190 190
q3 10564 1115 1164 1115
q4 10241 841 765 765
q5 7468 2653 2582 2582
q6 222 133 129 129
q7 946 591 601 591
q8 9222 2072 2051 2051
q9 9058 6528 6482 6482
q10 8917 3697 3705 3697
q11 478 248 258 248
q12 490 224 220 220
q13 17818 2961 3001 2961
q14 272 232 226 226
q15 516 474 491 474
q16 497 370 370 370
q17 975 661 740 661
q18 8166 7484 7579 7484
q19 4978 1457 1449 1449
q20 643 323 345 323
q21 4946 3792 3195 3195
q22 394 339 356 339
Total cold run time: 116756 ms
Total hot run time: 39823 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4331 4283 4202 4202
q2 390 257 258 257
q3 3022 2917 2876 2876
q4 2045 1700 1727 1700
q5 5566 5491 5477 5477
q6 220 129 128 128
q7 2195 1852 1858 1852
q8 3283 3401 3463 3401
q9 8751 8666 8813 8666
q10 4048 3896 3724 3724
q11 591 481 512 481
q12 810 639 619 619
q13 17038 3115 3148 3115
q14 318 273 286 273
q15 516 490 476 476
q16 473 423 444 423
q17 1856 1511 1498 1498
q18 8007 7844 7746 7746
q19 1839 1529 1560 1529
q20 3051 1933 1879 1879
q21 6237 4922 4934 4922
q22 642 558 560 558
Total cold run time: 75229 ms
Total hot run time: 55802 ms
```
</details>
--
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