You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zhangstar333 (via GitHub)" <gi...@apache.org> on 2024/01/05 06:29:25 UTC
[PR] [test](p0) [doris]
zhangstar333 opened a new pull request, #29584:
URL: https://github.com/apache/doris/pull/29584
## 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884315532
<details>
<summary>ClickBench: <b>Total hot run time: 29.98 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 5916e961b5a0dc35779cf0782369f20682cd706e, data reload: false
query1 0.06 0.06 0.06
query2 0.06 0.02 0.02
query3 0.25 0.11 0.10
query4 1.78 0.12 0.11
query5 0.52 0.51 0.52
query6 1.33 0.65 0.64
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.56 0.50 0.49
query10 0.54 0.54 0.54
query11 0.14 0.09 0.09
query12 0.11 0.09 0.10
query13 0.62 0.60 0.61
query14 0.78 0.81 0.77
query15 0.83 0.81 0.80
query16 0.34 0.35 0.35
query17 0.99 0.99 0.97
query18 0.25 0.26 0.25
query19 1.87 1.76 1.75
query20 0.01 0.01 0.01
query21 15.58 0.59 0.58
query22 3.15 2.32 1.60
query23 16.92 0.87 0.75
query24 2.57 5.65 0.33
query25 2.05 0.15 0.14
query26 0.14 0.13 0.14
query27 0.15 0.15 0.14
query28 9.56 0.82 0.85
query29 12.58 3.24 3.25
query30 0.60 0.47 0.50
query31 2.78 0.35 0.38
query32 3.38 0.50 0.48
query33 3.24 3.25 3.18
query34 16.10 4.17 4.14
query35 4.18 4.19 4.16
query36 1.12 1.03 1.04
query37 0.07 0.05 0.05
query38 0.03 0.03 0.03
query39 0.02 0.02 0.01
query40 0.18 0.13 0.13
query41 0.06 0.01 0.02
query42 0.02 0.01 0.02
query43 0.02 0.02 0.01
Total cold run time: 105.6 s
Total hot run time: 29.98 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882967724
<details>
<summary>TPC-DS: <b>Total hot run time: 188748 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 e4b85972806a68e156097f05788be0911c16c6cc, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 954 343 342 342
query2 6946 2066 2009 2009
query3 6721 229 234 229
query4 25144 22510 22620 22510
query5 5182 581 580 580
query6 340 222 216 216
query7 4581 324 321 321
query8 280 240 251 240
query9 9736 3337 3293 3293
query10 634 322 334 322
query11 15954 15432 15374 15374
query12 184 129 114 114
query13 1535 341 336 336
query14 12071 7886 8024 7886
query15 369 326 282 282
query16 6500 342 331 331
query17 1644 582 552 552
query18 1992 312 313 312
query19 230 183 185 183
query20 132 124 121 121
query21 197 107 100 100
query22 5009 4629 4456 4456
query23 32185 31350 31568 31350
query24 12957 3522 3531 3522
query25 637 393 403 393
query26 1582 205 204 204
query27 2725 332 337 332
query28 6628 2156 2148 2148
query29 1720 469 450 450
query30 312 151 169 151
query31 1187 886 866 866
query32 155 101 104 101
query33 807 387 372 372
query34 869 481 485 481
query35 1090 876 892 876
query36 1518 1289 1327 1289
query37 215 115 121 115
query38 3542 3452 3340 3340
query39 1394 1311 1319 1311
query40 320 102 95 95
query41 37 40 35 35
query42 118 117 119 117
query43 610 576 539 539
query44 1200 825 829 825
query45 279 259 259 259
query46 1191 906 864 864
query47 1778 1745 1725 1725
query48 391 310 314 310
query49 1220 328 334 328
query50 1043 817 932 817
query51 5512 5331 5326 5326
query52 115 119 101 101
query53 236 214 201 201
query54 1426 728 769 728
query55 108 104 102 102
query56 329 271 265 265
query57 1152 1067 1008 1008
query58 377 343 347 343
query59 3360 3064 3013 3013
query60 347 329 327 327
query61 150 149 146 146
query62 1381 543 535 535
query63 238 208 213 208
query64 6285 1811 1754 1754
query65 3469 3409 3443 3409
query66 1178 439 437 437
query67 15768 15756 15203 15203
query68 12570 548 559 548
query69 647 364 351 351
query70 1788 1784 1817 1784
query71 643 310 305 305
query72 6223 3995 4071 3995
query73 3097 330 338 330
query74 7220 6687 6612 6612
query75 5943 2307 2323 2307
query76 6658 1251 1176 1176
query77 1041 388 392 388
query78 9098 8661 8794 8661
query79 1160 544 557 544
query80 809 380 389 380
query81 512 228 236 228
query82 210 123 133 123
query83 234 145 147 145
query84 254 59 59 59
query85 941 293 284 284
query86 453 462 469 462
query87 3633 3485 3539 3485
query88 3396 2543 2458 2458
query89 436 372 341 341
query90 2035 283 279 279
query91 127 95 106 95
query92 104 99 89 89
query93 1451 434 494 434
query94 999 271 251 251
query95 624 527 517 517
query96 650 344 331 331
query97 4339 4278 4187 4187
query98 255 219 232 219
query99 1653 977 950 950
Total cold run time: 304679 ms
Total hot run time: 188748 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1914123189
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 84705b8715e129029ac6e0bba0957084bae48f79 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: 13.6 seconds inserted 10000000 Rows, about 735K 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-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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1914111302
<details>
<summary>TPC-DS: <b>Total hot run time: 172269 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 84705b8715e129029ac6e0bba0957084bae48f79, data reload: false
query1 962 335 326 326
query2 6557 1859 1866 1859
query3 6719 196 196 196
query4 32569 22036 21996 21996
query5 4455 415 345 345
query6 245 163 156 156
query7 4609 272 256 256
query8 265 173 176 173
query9 8621 2245 2240 2240
query10 542 210 203 203
query11 17992 15287 15297 15287
query12 118 65 67 65
query13 1677 370 365 365
query14 9185 6425 6352 6352
query15 203 178 185 178
query16 5710 253 249 249
query17 953 467 475 467
query18 1812 262 248 248
query19 168 134 132 132
query20 82 70 68 68
query21 204 136 136 136
query22 4946 4730 4673 4673
query23 31231 30249 30229 30229
query24 12448 2739 2813 2739
query25 584 310 294 294
query26 1974 137 139 137
query27 3185 286 289 286
query28 7422 1808 1789 1789
query29 2236 621 601 601
query30 284 137 131 131
query31 918 707 724 707
query32 84 48 49 48
query33 703 199 218 199
query34 1189 454 462 454
query35 867 819 730 730
query36 1319 1188 1211 1188
query37 91 58 56 56
query38 3257 3166 3148 3148
query39 1316 1266 1237 1237
query40 344 87 79 79
query41 37 37 33 33
query42 92 79 82 79
query43 480 481 488 481
query44 1088 692 692 692
query45 185 175 175 175
query46 1052 640 636 636
query47 1599 1501 1497 1497
query48 387 323 301 301
query49 1222 280 272 272
query50 681 310 305 305
query51 5299 5157 5176 5157
query52 106 87 77 77
query53 319 248 255 248
query54 247 180 173 173
query55 86 74 79 74
query56 174 160 155 155
query57 1011 878 894 878
query58 181 151 163 151
query59 2665 2540 2577 2540
query60 189 173 170 170
query61 85 80 80 80
query62 654 363 371 363
query63 281 272 264 264
query64 6051 1740 1721 1721
query65 3277 3219 3181 3181
query66 1506 312 308 308
query67 14459 14111 14115 14111
query68 3813 478 500 478
query69 421 301 297 297
query70 1548 1471 1454 1454
query71 294 209 208 208
query72 3798 2787 2804 2787
query73 670 317 306 306
query74 6665 6225 6223 6223
query75 2790 2298 2316 2298
query76 2589 1009 924 924
query77 446 238 224 224
query78 9062 8911 8593 8593
query79 2276 485 503 485
query80 1890 321 314 314
query81 525 205 199 199
query82 676 79 75 75
query83 227 115 116 115
query84 281 72 76 72
query85 2262 330 329 329
query86 513 404 383 383
query87 3389 3224 3256 3224
query88 3850 2157 2161 2157
query89 426 367 367 367
query90 2112 186 183 183
query91 150 117 114 114
query92 54 40 40 40
query93 2150 430 401 401
query94 1564 160 160 160
query95 498 463 450 450
query96 613 311 298 298
query97 4246 4114 4132 4114
query98 207 192 181 181
query99 1074 705 672 672
Total cold run time: 282538 ms
Total hot run time: 172269 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1878492642
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 a6ac93cc2cf432ea26d87909121a46b7382b509d, data reload: false
------ Round 1 ----------------------------------
q1 18337 5588 5110 5110
q2 2033 155 142 142
q3 10621 1084 1101 1084
q4 10237 753 786 753
q5 7821 2989 3029 2989
q6 229 136 146 136
q7 1004 514 522 514
q8 9284 2024 2024 2024
q9 6871 6384 6344 6344
q10 8248 2962 3032 2962
q11 416 212 203 203
q12 389 223 223 223
q13 18030 3609 3600 3600
q14 242 226 212 212
q15 563 528 511 511
q16 460 411 377 377
q17 966 497 464 464
q18 7511 6768 6680 6680
q19 1585 1431 1435 1431
q20 732 313 319 313
q21 2725 2352 2389 2352
q22 382 323 320 320
Total cold run time: 108686 ms
Total hot run time: 38744 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5126 5049 5070 5049
q2 339 246 236 236
q3 3305 3326 3280 3280
q4 2113 1993 2015 1993
q5 5815 5772 5795 5772
q6 216 124 124 124
q7 2313 1920 1900 1900
q8 3343 3470 3448 3448
q9 8831 8755 8698 8698
q10 3789 3827 3817 3817
q11 580 488 482 482
q12 797 615 624 615
q13 7210 3170 3187 3170
q14 296 260 260 260
q15 589 513 523 513
q16 553 488 508 488
q17 1934 1757 1748 1748
q18 8764 8375 8224 8224
q19 1624 1581 1595 1581
q20 2193 1981 1949 1949
q21 5608 5208 5260 5208
q22 564 468 480 468
Total cold run time: 65902 ms
Total hot run time: 59023 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882533575
<details>
<summary>TPC-DS: <b>Total hot run time: 184111 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 411de457ec300e95b4f7a42638fc29d4d914d8f9, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 946 351 350 350
query2 6557 1921 1917 1917
query3 6727 226 219 219
query4 25511 22651 22474 22474
query5 5603 632 601 601
query6 348 215 216 215
query7 4639 315 303 303
query8 257 234 237 234
query9 8714 2937 2949 2937
query10 602 356 323 323
query11 15830 15723 15840 15723
query12 169 98 97 97
query13 1685 334 337 334
query14 13428 7518 7626 7518
query15 265 243 217 217
query16 6479 337 335 335
query17 1696 519 519 519
query18 1958 308 302 302
query19 239 164 165 164
query20 107 106 100 100
query21 187 95 89 89
query22 5067 4881 4844 4844
query23 32416 31646 31075 31075
query24 11853 2958 2950 2950
query25 616 363 376 363
query26 1817 174 181 174
query27 2989 312 318 312
query28 7068 2141 2103 2103
query29 2083 435 429 429
query30 293 146 151 146
query31 1046 821 834 821
query32 124 89 75 75
query33 843 357 347 347
query34 863 478 473 473
query35 990 908 865 865
query36 1373 1311 1246 1246
query37 217 83 93 83
query38 3474 3367 3340 3340
query39 1358 1309 1312 1309
query40 307 92 87 87
query41 39 40 37 37
query42 108 104 106 104
query43 551 521 540 521
query44 1214 811 760 760
query45 223 212 199 199
query46 1045 721 735 721
query47 1723 1606 1621 1606
query48 361 286 271 271
query49 1214 326 313 313
query50 738 328 328 328
query51 5381 5285 5318 5285
query52 117 95 98 95
query53 229 174 166 166
query54 1449 653 675 653
query55 106 103 98 98
query56 258 249 267 249
query57 1057 951 982 951
query58 312 263 288 263
query59 3038 2789 2837 2789
query60 356 309 298 298
query61 160 155 153 153
query62 565 482 484 482
query63 186 185 174 174
query64 6018 1771 1714 1714
query65 3385 3346 3354 3346
query66 1388 386 390 386
query67 15728 15157 15063 15063
query68 10341 538 560 538
query69 588 304 304 304
query70 1834 1649 1589 1589
query71 584 283 290 283
query72 5118 3552 3517 3517
query73 2088 327 339 327
query74 7216 6580 6598 6580
query75 4675 2321 2326 2321
query76 6264 1262 1106 1106
query77 735 330 342 330
query78 9132 8791 8622 8622
query79 1029 516 525 516
query80 538 344 363 344
query81 460 212 211 211
query82 260 104 106 104
query83 168 147 142 142
query84 217 57 59 57
query85 924 292 274 274
query86 440 438 434 434
query87 3594 3484 3514 3484
query88 2946 2479 2480 2479
query89 352 279 279 279
query90 1890 262 231 231
query91 136 98 99 98
query92 95 81 70 70
query93 1013 428 476 428
query94 830 252 248 248
query95 574 512 510 510
query96 632 337 349 337
query97 4466 4246 4315 4246
query98 234 230 208 208
query99 1196 856 862 856
Total cold run time: 294262 ms
Total hot run time: 184111 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] [test](p0) [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884075208
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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882686582
<details>
<summary>TPC-DS: <b>Total hot run time: 186877 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 aef7b9def0cbe6698264c88b0f117c1c25e968b6, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 950 348 344 344
query2 6852 1994 1997 1994
query3 6747 241 231 231
query4 26102 22794 22655 22655
query5 6734 602 612 602
query6 386 222 218 218
query7 5396 293 299 293
query8 267 252 235 235
query9 9723 3300 3279 3279
query10 877 353 365 353
query11 16309 15667 15685 15667
query12 187 118 110 110
query13 1628 350 335 335
query14 12988 7639 7356 7356
query15 291 259 231 231
query16 6410 360 350 350
query17 1571 550 546 546
query18 1966 326 328 326
query19 313 175 172 172
query20 125 123 122 122
query21 188 106 95 95
query22 4934 4631 4591 4591
query23 32373 31404 31494 31404
query24 12362 3043 2996 2996
query25 617 404 395 395
query26 1772 199 174 174
query27 2815 319 308 308
query28 6995 2165 2122 2122
query29 2040 448 429 429
query30 293 144 147 144
query31 1067 839 862 839
query32 147 93 91 91
query33 839 366 366 366
query34 873 474 481 474
query35 1088 860 931 860
query36 1473 1393 1316 1316
query37 223 122 106 106
query38 3504 3363 3376 3363
query39 1498 1302 1296 1296
query40 313 97 95 95
query41 39 36 39 36
query42 116 118 122 118
query43 625 557 564 557
query44 1274 828 836 828
query45 218 218 208 208
query46 1052 710 703 703
query47 1768 1769 1683 1683
query48 360 304 281 281
query49 1235 324 325 324
query50 763 323 327 323
query51 5435 5345 5462 5345
query52 142 112 112 112
query53 243 182 174 174
query54 1418 707 691 691
query55 109 105 111 105
query56 297 263 299 263
query57 1145 1062 1057 1057
query58 358 342 340 340
query59 3363 3139 3158 3139
query60 376 330 321 321
query61 156 151 131 131
query62 604 544 496 496
query63 220 198 204 198
query64 6121 1706 1750 1706
query65 3500 3413 3401 3401
query66 1364 430 431 430
query67 15519 15774 15221 15221
query68 14306 565 553 553
query69 642 334 372 334
query70 2412 1837 1840 1837
query71 637 299 302 299
query72 5523 3536 3508 3508
query73 3667 346 348 346
query74 7388 6581 6658 6581
query75 5390 2324 2300 2300
query76 6467 1093 1262 1093
query77 864 369 372 369
query78 9070 8688 8724 8688
query79 2645 541 569 541
query80 586 378 372 372
query81 468 218 219 218
query82 245 131 121 121
query83 283 149 146 146
query84 256 60 59 59
query85 963 307 291 291
query86 459 464 459 459
query87 3612 3404 3479 3404
query88 3252 2554 2555 2554
query89 387 325 331 325
query90 2032 285 273 273
query91 128 102 103 102
query92 108 91 99 91
query93 1342 500 485 485
query94 945 272 266 266
query95 574 527 518 518
query96 645 340 347 340
query97 4382 4239 4301 4239
query98 248 220 225 220
query99 1177 871 903 871
Total cold run time: 310159 ms
Total hot run time: 186877 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882978305
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.1 seconds
stream load tsv: 578 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: 21.3 seconds inserted 10000000 Rows, about 469K ops/s
storage size: 17184130715 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884107425
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.83 seconds
stream load tsv: 569 seconds loaded 74807831229 Bytes, about 125 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: 21.7 seconds inserted 10000000 Rows, about 460K ops/s
storage size: 17184131778 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884310041
<details>
<summary>TPC-DS: <b>Total hot run time: 179133 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 5916e961b5a0dc35779cf0782369f20682cd706e, data reload: false
query1 946 337 331 331
query2 6725 1861 1881 1861
query3 6714 215 213 213
query4 28916 22147 22554 22147
query5 6075 500 490 490
query6 269 193 192 192
query7 4618 286 275 275
query8 234 214 208 208
query9 9169 2747 2746 2746
query10 675 247 247 247
query11 16297 15463 15391 15391
query12 134 82 79 79
query13 1639 355 352 352
query14 12742 7216 7352 7216
query15 282 187 203 187
query16 6483 278 272 272
query17 1909 493 480 480
query18 1939 271 276 271
query19 284 147 142 142
query20 91 83 78 78
query21 188 95 94 94
query22 5068 4904 4765 4765
query23 32155 31234 31158 31158
query24 12028 2803 2832 2803
query25 570 347 347 347
query26 1798 158 151 151
query27 2800 282 283 282
query28 6929 1928 1911 1911
query29 2071 389 384 384
query30 293 148 146 146
query31 975 763 779 763
query32 90 61 62 61
query33 759 269 281 269
query34 1004 451 451 451
query35 876 781 726 726
query36 1436 1257 1316 1257
query37 190 68 69 68
query38 3422 3282 3284 3282
query39 1329 1294 1289 1289
query40 293 103 95 95
query41 40 35 35 35
query42 100 93 94 93
query43 542 493 508 493
query44 1088 712 724 712
query45 210 195 183 183
query46 1053 672 669 669
query47 1671 1570 1483 1483
query48 406 314 327 314
query49 1277 318 335 318
query50 736 358 356 356
query51 5381 5349 5241 5241
query52 96 90 95 90
query53 220 157 154 154
query54 1405 578 576 576
query55 96 86 80 80
query56 217 194 205 194
query57 1039 974 928 928
query58 241 215 212 212
query59 2707 2562 2554 2554
query60 267 229 242 229
query61 85 83 81 81
query62 670 457 462 457
query63 171 153 160 153
query64 5750 1653 1659 1653
query65 3345 3274 3250 3250
query66 1261 357 346 346
query67 15585 15292 15270 15270
query68 10605 540 536 536
query69 560 293 288 288
query70 1761 1607 1677 1607
query71 505 235 222 222
query72 4704 2873 2839 2839
query73 2192 324 329 324
query74 7011 6482 6568 6482
query75 5067 2295 2262 2262
query76 6247 1083 1087 1083
query77 928 270 282 270
query78 9901 8866 8691 8691
query79 1042 517 503 503
query80 551 340 361 340
query81 447 216 211 211
query82 230 93 90 90
query83 163 140 142 140
query84 269 56 55 55
query85 993 321 294 294
query86 390 390 399 390
query87 3507 3360 3393 3360
query88 2796 2340 2320 2320
query89 333 275 287 275
query90 1982 201 207 201
query91 172 132 137 132
query92 60 56 53 53
query93 1107 433 480 433
query94 814 186 192 186
query95 483 427 423 423
query96 623 336 330 330
query97 4289 4178 4153 4153
query98 218 204 190 190
query99 1087 882 846 846
Total cold run time: 297111 ms
Total hot run time: 179133 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882522327
<details>
<summary>TPC-H: <b>Total hot run time: 38812 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 411de457ec300e95b4f7a42638fc29d4d914d8f9, data reload: false
------ Round 1 ----------------------------------
q1 17661 4963 4955 4955
q2 2027 161 166 161
q3 10630 1125 1186 1125
q4 10534 789 817 789
q5 7797 3021 3034 3021
q6 207 123 124 123
q7 902 539 503 503
q8 9508 1996 2015 1996
q9 8306 6449 6356 6356
q10 8323 3067 3003 3003
q11 459 238 219 219
q12 391 235 233 233
q13 18017 3391 3426 3391
q14 243 213 209 209
q15 548 509 511 509
q16 502 425 404 404
q17 971 743 605 605
q18 7272 6847 6673 6673
q19 1586 1534 1531 1531
q20 708 327 310 310
q21 2788 2423 2391 2391
q22 356 305 325 305
Total cold run time: 109736 ms
Total hot run time: 38812 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4968 4970 4897 4897
q2 336 236 257 236
q3 3289 3309 3266 3266
q4 2122 2056 2047 2047
q5 5808 5780 5805 5780
q6 213 116 119 116
q7 2330 1908 1882 1882
q8 3397 3452 3458 3452
q9 8820 8872 8911 8872
q10 3983 4044 4025 4025
q11 577 440 455 440
q12 807 661 661 661
q13 3941 3196 3195 3195
q14 313 262 254 254
q15 542 515 514 514
q16 566 503 508 503
q17 1871 1852 1870 1852
q18 8628 8433 8316 8316
q19 1587 1653 1635 1635
q20 2208 1965 1934 1934
q21 5576 5339 5314 5314
q22 530 463 478 463
Total cold run time: 62412 ms
Total hot run time: 59654 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882666525
<details>
<summary>TPC-H: <b>Total hot run time: 39817 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 aef7b9def0cbe6698264c88b0f117c1c25e968b6, data reload: false
------ Round 1 ----------------------------------
q1 18306 5634 5577 5577
q2 2056 164 147 147
q3 10670 1120 1131 1120
q4 10413 824 833 824
q5 7831 2980 2994 2980
q6 213 128 131 128
q7 926 523 503 503
q8 9305 2012 2038 2012
q9 6600 6428 6468 6428
q10 8284 3066 3034 3034
q11 439 219 224 219
q12 392 227 230 227
q13 18290 3480 3435 3435
q14 250 218 225 218
q15 556 518 515 515
q16 452 404 403 403
q17 951 789 706 706
q18 7389 6725 6730 6725
q19 1586 1536 1531 1531
q20 725 328 323 323
q21 2721 2450 2452 2450
q22 403 312 343 312
Total cold run time: 108758 ms
Total hot run time: 39817 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5605 5566 5529 5529
q2 355 271 266 266
q3 3354 3332 3339 3332
q4 2143 2039 2036 2036
q5 5861 5838 5860 5838
q6 205 125 131 125
q7 2302 1938 1905 1905
q8 3480 3592 3564 3564
q9 8988 8913 8935 8913
q10 3834 3826 3884 3826
q11 611 492 506 492
q12 802 670 645 645
q13 3987 3280 3262 3262
q14 300 276 266 266
q15 551 505 514 505
q16 549 500 507 500
q17 2434 2425 2433 2425
q18 8858 8685 8578 8578
q19 1595 1639 1631 1631
q20 2237 1993 2013 1993
q21 5733 5458 5436 5436
q22 591 545 549 545
Total cold run time: 64375 ms
Total hot run time: 61612 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882976052
<details>
<summary>ClickBench: <b>Total hot run time: 31.55 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 e4b85972806a68e156097f05788be0911c16c6cc, data reload: false
query1 0.07 0.06 0.06
query2 0.07 0.02 0.03
query3 0.33 0.22 0.22
query4 1.74 0.18 0.19
query5 0.52 0.53 0.52
query6 1.58 0.68 0.69
query7 0.02 0.01 0.01
query8 0.05 0.02 0.02
query9 0.61 0.56 0.57
query10 0.61 0.60 0.62
query11 0.16 0.12 0.12
query12 0.15 0.13 0.11
query13 0.59 0.60 0.60
query14 0.77 0.81 0.77
query15 0.82 0.80 0.81
query16 0.35 0.35 0.35
query17 1.00 0.99 0.94
query18 0.24 0.24 0.24
query19 1.90 1.77 1.70
query20 0.01 0.01 0.01
query21 15.40 0.55 0.52
query22 2.42 3.34 1.32
query23 17.54 1.03 1.06
query24 9.88 0.34 0.77
query25 1.84 0.16 0.17
query26 0.16 0.16 0.15
query27 0.17 0.17 0.16
query28 5.45 0.94 0.88
query29 13.12 3.62 3.59
query30 0.56 0.51 0.49
query31 2.92 0.37 0.37
query32 3.31 0.49 0.49
query33 3.21 3.21 3.19
query34 16.82 4.51 4.61
query35 4.67 4.63 4.51
query36 1.15 1.08 1.08
query37 0.06 0.04 0.04
query38 0.04 0.02 0.02
query39 0.02 0.02 0.02
query40 0.16 0.14 0.13
query41 0.07 0.02 0.01
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 110.61 s
Total hot run time: 31.55 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884100713
<details>
<summary>ClickBench: <b>Total hot run time: 30.97 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 e4b85972806a68e156097f05788be0911c16c6cc, data reload: false
query1 0.06 0.07 0.06
query2 0.06 0.03 0.03
query3 0.25 0.13 0.11
query4 1.76 0.12 0.12
query5 0.51 0.51 0.53
query6 1.38 0.65 0.64
query7 0.02 0.01 0.02
query8 0.04 0.02 0.02
query9 0.54 0.51 0.51
query10 0.55 0.55 0.54
query11 0.12 0.09 0.09
query12 0.11 0.10 0.08
query13 0.60 0.60 0.60
query14 0.79 0.77 0.81
query15 0.81 0.81 0.79
query16 0.36 0.37 0.36
query17 1.00 0.97 0.98
query18 0.26 0.24 0.26
query19 1.78 1.73 1.71
query20 0.01 0.01 0.02
query21 15.41 0.57 0.58
query22 3.14 2.65 1.58
query23 17.24 1.01 0.77
query24 5.48 1.18 1.82
query25 2.04 0.15 0.15
query26 0.14 0.14 0.13
query27 0.15 0.15 0.15
query28 9.81 0.82 0.82
query29 12.62 3.28 3.32
query30 0.51 0.50 0.49
query31 2.78 0.36 0.37
query32 3.37 0.48 0.48
query33 3.25 3.25 3.18
query34 15.84 4.19 4.21
query35 4.24 4.15 4.17
query36 1.11 1.06 1.05
query37 0.06 0.05 0.05
query38 0.04 0.02 0.03
query39 0.02 0.02 0.02
query40 0.16 0.13 0.13
query41 0.07 0.01 0.02
query42 0.02 0.02 0.02
query43 0.02 0.02 0.02
Total cold run time: 108.53 s
Total hot run time: 30.97 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884096415
<details>
<summary>TPC-DS: <b>Total hot run time: 180242 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 e4b85972806a68e156097f05788be0911c16c6cc, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 939 349 348 348
query2 6685 1828 1846 1828
query3 6723 224 216 216
query4 26177 22175 22200 22175
query5 4893 528 485 485
query6 273 194 192 192
query7 4632 285 272 272
query8 231 221 206 206
query9 9194 2750 2848 2750
query10 498 266 244 244
query11 16257 15459 15434 15434
query12 138 87 80 80
query13 1650 347 349 347
query14 12027 7259 7168 7168
query15 286 193 195 193
query16 6598 288 274 274
query17 1922 492 493 492
query18 1966 271 272 271
query19 295 140 144 140
query20 88 84 81 81
query21 186 95 95 95
query22 4842 4819 4858 4819
query23 32050 31447 31554 31447
query24 12174 2830 2802 2802
query25 581 361 359 359
query26 1767 159 152 152
query27 2825 284 286 284
query28 7059 1912 1887 1887
query29 2051 408 406 406
query30 276 143 149 143
query31 1012 775 769 769
query32 91 63 59 59
query33 754 285 273 273
query34 896 451 454 451
query35 935 764 775 764
query36 1326 1271 1283 1271
query37 105 72 73 72
query38 3394 3304 3271 3271
query39 1335 1302 1292 1292
query40 297 100 94 94
query41 39 35 35 35
query42 103 95 99 95
query43 554 494 463 463
query44 1089 703 716 703
query45 206 195 192 192
query46 1050 660 655 655
query47 1690 1681 1626 1626
query48 408 324 320 320
query49 1280 330 319 319
query50 800 328 357 328
query51 5430 5308 5256 5256
query52 106 90 94 90
query53 227 159 162 159
query54 1452 568 591 568
query55 100 90 85 85
query56 226 203 211 203
query57 1038 960 959 959
query58 243 215 220 215
query59 2721 2511 2461 2461
query60 248 220 246 220
query61 92 90 89 89
query62 640 463 463 463
query63 178 163 152 152
query64 5876 1749 1696 1696
query65 3344 3276 3280 3276
query66 1380 354 340 340
query67 15569 15800 15199 15199
query68 10544 529 517 517
query69 572 286 295 286
query70 1680 1579 1563 1563
query71 512 218 227 218
query72 5350 3516 3489 3489
query73 2127 324 319 319
query74 6915 6419 6487 6419
query75 4794 2281 2259 2259
query76 6324 1145 1142 1142
query77 692 279 281 279
query78 9633 8727 8655 8655
query79 1047 514 501 501
query80 554 360 373 360
query81 447 217 213 213
query82 230 86 92 86
query83 164 141 137 137
query84 268 59 57 57
query85 959 303 284 284
query86 419 396 393 393
query87 3543 3422 3369 3369
query88 3542 2326 2307 2307
query89 332 255 262 255
query90 1988 215 212 212
query91 177 136 131 131
query92 65 55 56 55
query93 1933 503 489 489
query94 773 188 187 187
query95 481 434 432 432
query96 627 331 323 323
query97 4290 4189 4167 4167
query98 208 192 196 192
query99 1109 873 883 873
Total cold run time: 293816 ms
Total hot run time: 180242 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] [test](p0) [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884277345
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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884298664
<details>
<summary>TPC-H: <b>Total hot run time: 39079 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 5916e961b5a0dc35779cf0782369f20682cd706e, data reload: false
------ Round 1 ----------------------------------
q1 17944 5037 5011 5011
q2 2139 147 140 140
q3 10909 1167 1136 1136
q4 10521 762 896 762
q5 8137 3235 3262 3235
q6 214 128 130 128
q7 899 535 499 499
q8 9567 2015 2031 2015
q9 6779 6650 6465 6465
q10 8249 3090 3068 3068
q11 436 219 215 215
q12 378 201 197 197
q13 18107 3446 3469 3446
q14 238 209 214 209
q15 550 516 509 509
q16 442 388 390 388
q17 936 521 563 521
q18 7357 6789 6688 6688
q19 1599 1407 1370 1370
q20 579 318 312 312
q21 2798 2433 2477 2433
q22 365 332 332 332
Total cold run time: 109143 ms
Total hot run time: 39079 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5000 5032 4961 4961
q2 321 196 208 196
q3 3328 3318 3307 3307
q4 2232 2260 2244 2244
q5 5786 5814 5793 5793
q6 193 118 122 118
q7 2306 1851 1843 1843
q8 3450 3577 3550 3550
q9 8863 8856 8862 8856
q10 3763 3835 3825 3825
q11 563 446 428 428
q12 787 601 609 601
q13 3892 3220 3215 3215
q14 294 256 267 256
q15 569 514 517 514
q16 527 488 483 483
q17 2040 2008 2037 2008
q18 8768 8380 8288 8288
q19 1626 1605 1618 1605
q20 2181 1939 1939 1939
q21 6046 5764 5765 5764
q22 580 496 501 496
Total cold run time: 63115 ms
Total hot run time: 60290 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1914097628
<details>
<summary>TPC-H: <b>Total hot run time: 37689 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 84705b8715e129029ac6e0bba0957084bae48f79, data reload: false
------ Round 1 ----------------------------------
q1 17705 5765 4926 4926
q2 2515 146 136 136
q3 11064 1014 942 942
q4 5183 751 750 750
q5 7985 2857 2852 2852
q6 194 125 124 124
q7 1190 736 707 707
q8 9271 2016 1998 1998
q9 7279 6334 6344 6334
q10 8112 2415 2435 2415
q11 409 206 191 191
q12 776 282 282 282
q13 18024 3289 3217 3217
q14 273 265 245 245
q15 538 492 479 479
q16 461 402 408 402
q17 940 531 519 519
q18 6944 6273 6124 6124
q19 1609 1370 1376 1370
q20 596 346 325 325
q21 7016 3058 3090 3058
q22 817 293 294 293
Total cold run time: 108901 ms
Total hot run time: 37689 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5088 5011 4832 4832
q2 340 242 237 237
q3 3057 2739 2682 2682
q4 1824 1546 1555 1546
q5 5360 5221 5197 5197
q6 207 121 116 116
q7 2175 1787 1771 1771
q8 3144 3179 3259 3179
q9 8693 8613 12283 8613
q10 5591 3443 3420 3420
q11 565 459 460 459
q12 726 601 614 601
q13 16938 3100 3063 3063
q14 286 253 247 247
q15 527 495 490 490
q16 552 479 473 473
q17 2081 1597 1693 1597
q18 8846 11892 8810 8810
q19 24486 1578 1524 1524
q20 4661 1921 1895 1895
q21 15816 4790 4776 4776
q22 1788 470 462 462
Total cold run time: 112751 ms
Total hot run time: 55990 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] [test](p0) [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1878470289
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] [test](p0) [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1878190797
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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882950458
<details>
<summary>TPC-H: <b>Total hot run time: 39340 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 e4b85972806a68e156097f05788be0911c16c6cc, data reload: false
------ Round 1 ----------------------------------
q1 18353 5577 5574 5574
q2 2036 159 148 148
q3 10691 1162 1159 1159
q4 10221 825 757 757
q5 7857 2918 2815 2815
q6 212 130 133 130
q7 926 519 494 494
q8 9291 2041 2017 2017
q9 6651 6388 6392 6388
q10 8245 2982 2996 2982
q11 443 238 212 212
q12 393 228 231 228
q13 18297 3444 3429 3429
q14 239 218 211 211
q15 559 508 504 504
q16 444 385 411 385
q17 946 738 685 685
q18 7456 6721 6749 6721
q19 1569 1526 1510 1510
q20 743 325 321 321
q21 2775 2350 2363 2350
q22 375 320 327 320
Total cold run time: 108722 ms
Total hot run time: 39340 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5543 5530 5491 5491
q2 360 249 252 249
q3 3374 3318 3349 3318
q4 2137 2047 2031 2031
q5 5856 5848 5849 5848
q6 209 123 123 123
q7 2352 1918 1947 1918
q8 3417 3487 3617 3487
q9 8886 8845 8815 8815
q10 3822 3872 3882 3872
q11 625 496 489 489
q12 823 620 635 620
q13 12824 3222 3185 3185
q14 299 263 275 263
q15 552 514 510 510
q16 544 497 490 490
q17 2398 2362 2351 2351
q18 8813 8660 8558 8558
q19 1585 1620 1633 1620
q20 2174 2002 1969 1969
q21 5713 5433 5400 5400
q22 568 532 510 510
Total cold run time: 72874 ms
Total hot run time: 61117 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] [test](p0) [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 closed pull request #29584: [test](p0)
URL: https://github.com/apache/doris/pull/29584
--
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] [test](p0) [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1914072948
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] [test](p0) [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882504113
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] [test](p0) [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882635777
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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882701220
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.51 seconds
stream load tsv: 566 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 27.3 seconds inserted 10000000 Rows, about 366K ops/s
storage size: 17183642495 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884103017
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit e4b85972806a68e156097f05788be0911c16c6cc with default session variables
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 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: 12.8 seconds inserted 10000000 Rows, about 781K 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-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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882701156
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit aef7b9def0cbe6698264c88b0f117c1c25e968b6 with default session variables
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 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: 18.3 seconds inserted 10000000 Rows, about 546K 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-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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884320675
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.76 seconds
stream load tsv: 564 seconds loaded 74807831229 Bytes, about 126 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: 21.3 seconds inserted 10000000 Rows, about 469K ops/s
storage size: 17183884595 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1878234827
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 48.01 seconds
stream load tsv: 566 seconds loaded 74807831229 Bytes, about 126 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.2 seconds inserted 10000000 Rows, about 367K ops/s
storage size: 17183684398 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1878506674
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 a6ac93cc2cf432ea26d87909121a46b7382b509d, data reload: false
run tpcds-sf100 query with default conf and session variables
query1 944 351 328 328
query2 4707 1917 1888 1888
query3 6648 199 200 199
query4 27789 22386 22444 22386
query5 3583 533 536 533
query6 266 185 190 185
query7 4606 262 264 262
query8 224 203 195 195
query9 8208 2689 2592 2592
query10 577 268 251 251
query11 16213 15488 15556 15488
query12 126 79 77 77
query13 1628 333 336 333
query14 10880 7068 7087 7068
query15 217 187 190 187
query16 6072 266 267 266
query17 1857 512 486 486
query18 1838 272 270 270
query19 175 137 127 127
query20 78 73 75 73
query21 172 94 94 94
query22 5053 4688 4781 4688
query23 32164 31033 31267 31033
query24 12137 2826 2783 2783
query25 578 340 325 325
query26 1565 139 138 138
query27 2888 272 274 272
query28 6893 1935 1918 1918
query29 1646 381 398 381
query30 271 141 149 141
query31 1070 755 778 755
query32 82 56 55 55
query33 751 251 267 251
query34 952 456 438 438
query35 883 797 786 786
query36 1365 1330 1265 1265
query37 154 62 70 62
query38 3456 3321 3311 3311
query39 1317 1292 1284 1284
query40 285 88 91 88
query41 38 35 41 35
query42 92 86 86 86
query43 547 497 501 497
query44 1129 711 709 709
query45 185 189 178 178
query46 1062 627 643 627
query47 1635 1580 1539 1539
query48 328 255 257 255
query49 1113 317 319 317
query50 730 329 336 329
query51 5358 5288 5317 5288
query52 91 88 80 80
query53 215 153 145 145
query54 1460 553 569 553
query55 98 91 90 90
query56 209 188 192 188
query57 1051 965 960 960
query58 221 195 198 195
query59 2749 2509 2577 2509
query60 236 239 224 224
query61 88 84 85 84
query62 664 458 478 458
query63 165 146 150 146
query64 5239 1726 1687 1687
query65 3312 3261 3256 3256
query66 1333 352 340 340
query67 15773 15649 14991 14991
query68 12517 539 521 521
query69 528 260 244 244
query70 1676 1512 1571 1512
query71 499 225 210 210
query72 5692 3528 3545 3528
query73 2929 323 313 313
query74 7022 6465 6404 6404
query75 5239 2254 2288 2254
query76 6027 1055 1119 1055
query77 661 250 244 244
query78 9184 8513 8527 8513
query79 1701 506 475 475
query80 678 357 333 333
query81 445 206 206 206
query82 193 87 86 86
query83 164 133 136 133
query84 242 53 53 53
query85 970 285 274 274
query86 395 389 391 389
query87 3565 3412 3379 3379
query88 3255 2228 2225 2225
query89 335 256 250 250
query90 2088 196 197 196
query91 122 89 100 89
query92 58 51 51 51
query93 2012 453 505 453
query94 895 181 174 174
query95 457 404 403 403
query96 614 315 314 314
query97 4318 4154 4143 4143
query98 211 193 188 188
query99 1107 848 817 817
Total cold run time: 291238 ms
Total hot run time: 178457 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1914119198
<details>
<summary>ClickBench: <b>Total hot run time: 30.89 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 84705b8715e129029ac6e0bba0957084bae48f79, data reload: false
query1 0.04 0.03 0.04
query2 0.07 0.03 0.03
query3 0.23 0.06 0.06
query4 1.65 0.10 0.09
query5 0.53 0.52 0.51
query6 1.21 0.63 0.64
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.55 0.48 0.50
query10 0.56 0.54 0.55
query11 0.12 0.09 0.09
query12 0.11 0.09 0.09
query13 0.60 0.60 0.61
query14 0.80 0.79 0.78
query15 0.79 0.78 0.78
query16 0.38 0.38 0.38
query17 1.00 1.00 1.01
query18 0.21 0.26 0.22
query19 1.84 1.77 1.78
query20 0.01 0.01 0.01
query21 15.55 0.59 0.60
query22 2.62 2.36 2.25
query23 17.28 0.82 0.70
query24 2.50 1.50 0.45
query25 0.29 0.29 0.12
query26 0.48 0.14 0.15
query27 0.06 0.05 0.06
query28 12.02 0.85 0.83
query29 12.63 3.24 3.12
query30 0.61 0.55 0.55
query31 2.79 0.35 0.35
query32 3.33 0.49 0.48
query33 3.22 3.24 3.23
query34 16.08 4.32 4.28
query35 4.32 4.29 4.36
query36 1.10 1.07 1.08
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.01 0.02
query40 0.17 0.15 0.13
query41 0.06 0.02 0.02
query42 0.02 0.01 0.02
query43 0.02 0.03 0.02
Total cold run time: 106.04 s
Total hot run time: 30.89 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884087711
<details>
<summary>TPC-H: <b>Total hot run time: 38787 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 e4b85972806a68e156097f05788be0911c16c6cc, data reload: false
------ Round 1 ----------------------------------
q1 17874 5007 4963 4963
q2 2041 154 140 140
q3 10809 1154 1158 1154
q4 10470 805 821 805
q5 7843 3142 3136 3136
q6 201 127 123 123
q7 881 505 492 492
q8 9261 2007 2026 2007
q9 6564 6488 6465 6465
q10 8235 3061 3135 3061
q11 422 203 217 203
q12 354 194 198 194
q13 18107 3451 3437 3437
q14 235 224 211 211
q15 565 518 509 509
q16 434 391 383 383
q17 944 507 574 507
q18 7364 6690 6711 6690
q19 1564 1418 1343 1343
q20 565 303 292 292
q21 2795 2352 2380 2352
q22 359 322 320 320
Total cold run time: 107887 ms
Total hot run time: 38787 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4978 4956 4984 4956
q2 317 198 205 198
q3 3310 3334 3312 3312
q4 2244 2233 2233 2233
q5 5797 5824 5793 5793
q6 197 118 118 118
q7 2317 1870 1867 1867
q8 3430 3526 3590 3526
q9 8897 8856 8871 8856
q10 3743 3815 3802 3802
q11 554 442 418 418
q12 792 606 622 606
q13 6907 3227 3229 3227
q14 292 263 269 263
q15 573 526 511 511
q16 512 471 481 471
q17 2039 2053 2033 2033
q18 8803 8488 8377 8377
q19 1602 1612 1614 1612
q20 2166 1944 1921 1921
q21 6075 5794 5732 5732
q22 568 508 500 500
Total cold run time: 66113 ms
Total hot run time: 60332 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1884318872
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 5916e961b5a0dc35779cf0782369f20682cd706e with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 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: 13.8 seconds inserted 10000000 Rows, about 724K 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-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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1878562062
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 a6ac93cc2cf432ea26d87909121a46b7382b509d, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5460 5157 5091 5091
q2 384 169 159 159
q3 1466 1168 1119 1119
q4 1089 867 827 827
q5 3151 3109 3147 3109
q6 230 134 134 134
q7 1011 537 532 532
q8 2150 2192 2213 2192
q9 6710 6648 6644 6644
q10 3186 3144 3161 3144
q11 353 221 224 221
q12 378 232 230 230
q13 4384 3656 3642 3642
q14 244 220 209 209
q15 586 547 532 532
q16 459 401 421 401
q17 1056 496 544 496
q18 7046 6705 6760 6705
q19 1651 1508 1478 1478
q20 600 340 336 336
q21 2910 2444 2509 2444
q22 399 320 339 320
Total cold run time: 44903 ms
Total hot run time: 39965 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5146 5053 5094 5053
q2 337 249 237 237
q3 3386 3330 3346 3330
q4 2167 2045 2034 2034
q5 5953 5907 5931 5907
q6 224 128 127 127
q7 2379 1918 1965 1918
q8 3545 3674 3655 3655
q9 9019 8956 8964 8956
q10 3892 3888 3927 3888
q11 588 499 484 484
q12 821 639 631 631
q13 3865 3183 3167 3167
q14 302 277 283 277
q15 601 532 536 532
q16 544 511 495 495
q17 2052 1828 1829 1828
q18 8743 8312 8252 8252
q19 1760 1733 1666 1666
q20 2269 1993 1975 1975
q21 5745 5381 5280 5280
q22 554 487 527 487
Total cold run time: 63892 ms
Total hot run time: 60179 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1878239682
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 6f6d7e2a20be72dca4b246e84d19e1e5992a02fb, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5428 5104 5149 5104
q2 387 168 158 158
q3 1449 1145 1119 1119
q4 1085 889 849 849
q5 3151 3098 3097 3097
q6 221 136 133 133
q7 969 558 520 520
q8 2154 2210 2241 2210
q9 6644 6706 6634 6634
q10 3171 3096 3073 3073
q11 341 226 215 215
q12 384 237 232 232
q13 4407 3676 3647 3647
q14 246 216 209 209
q15 580 529 545 529
q16 476 392 411 392
q17 1054 485 531 485
q18 7073 6713 6835 6713
q19 1643 1526 1499 1499
q20 601 324 315 315
q21 2890 2494 2456 2456
q22 397 314 327 314
Total cold run time: 44751 ms
Total hot run time: 39903 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5129 5060 5070 5060
q2 337 235 232 232
q3 3372 3341 3339 3339
q4 2174 2034 2051 2034
q5 5955 5905 5920 5905
q6 224 124 127 124
q7 2381 1898 1928 1898
q8 3573 3655 3659 3655
q9 9075 8982 9056 8982
q10 3929 3884 3921 3884
q11 584 480 471 471
q12 802 630 663 630
q13 3904 3215 3171 3171
q14 293 281 276 276
q15 589 543 523 523
q16 545 522 489 489
q17 2009 1776 1782 1776
q18 8762 8271 8403 8271
q19 1755 1695 1678 1678
q20 2271 1993 1975 1975
q21 5812 5307 5325 5307
q22 562 457 452 452
Total cold run time: 64037 ms
Total hot run time: 60132 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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1878508313
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.74 seconds
stream load tsv: 563 seconds loaded 74807831229 Bytes, about 126 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: 26.5 seconds inserted 10000000 Rows, about 377K ops/s
storage size: 17183974702 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] [test](p0) [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882914369
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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882696076
<details>
<summary>ClickBench: <b>Total hot run time: 31.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 aef7b9def0cbe6698264c88b0f117c1c25e968b6, data reload: false
query1 0.08 0.11 0.07
query2 0.07 0.03 0.03
query3 0.32 0.23 0.22
query4 1.73 0.19 0.19
query5 0.52 0.53 0.53
query6 1.57 0.69 0.69
query7 0.02 0.02 0.01
query8 0.04 0.02 0.03
query9 0.61 0.57 0.57
query10 0.61 0.62 0.62
query11 0.17 0.12 0.11
query12 0.16 0.12 0.11
query13 0.60 0.60 0.61
query14 0.79 0.78 0.78
query15 0.84 0.80 0.80
query16 0.36 0.36 0.35
query17 0.96 1.00 1.00
query18 0.26 0.25 0.24
query19 1.83 1.82 1.79
query20 0.01 0.00 0.01
query21 15.40 0.56 0.57
query22 2.76 3.37 1.36
query23 17.36 1.20 0.95
query24 10.07 0.86 0.35
query25 1.59 0.19 0.17
query26 0.16 0.17 0.16
query27 0.18 0.17 0.18
query28 5.50 0.94 0.88
query29 13.15 3.44 3.39
query30 0.54 0.53 0.52
query31 2.92 0.37 0.37
query32 3.34 0.49 0.47
query33 3.22 3.26 3.24
query34 16.49 4.64 4.52
query35 4.55 4.52 4.63
query36 1.14 1.11 1.10
query37 0.06 0.04 0.05
query38 0.03 0.02 0.02
query39 0.02 0.01 0.01
query40 0.16 0.13 0.13
query41 0.08 0.02 0.01
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 110.32 s
Total hot run time: 31.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] [test](p0) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29584:
URL: https://github.com/apache/doris/pull/29584#issuecomment-1882533737
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.82 seconds
stream load tsv: 568 seconds loaded 74807831229 Bytes, about 125 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.4 seconds inserted 10000000 Rows, about 364K ops/s
storage size: 17183792545 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