You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Jibing-Li (via GitHub)" <gi...@apache.org> on 2024/01/12 03:49:49 UTC
[PR] [unit test](statistics)Add unit test case for auto analyze. [doris]
Jibing-Li opened a new pull request, #29904:
URL: https://github.com/apache/doris/pull/29904
Add unit test case for auto analyze.
<!--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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888404042
<details>
<summary>TPC-H: <b>Total hot run time: 38950 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 1b8f3d3b8bd429115ac901cddcc287f76dc736de, data reload: false
------ Round 1 ----------------------------------
q1 17971 4954 4921 4921
q2 2053 140 133 133
q3 10696 1153 1199 1153
q4 10301 785 850 785
q5 7841 3176 3214 3176
q6 205 125 124 124
q7 897 513 492 492
q8 9259 1974 2019 1974
q9 7379 6531 6491 6491
q10 8273 3118 3075 3075
q11 406 201 215 201
q12 370 198 204 198
q13 18093 3455 3472 3455
q14 245 216 222 216
q15 564 524 513 513
q16 427 377 384 377
q17 956 528 498 498
q18 7459 6801 6717 6717
q19 1587 1410 1350 1350
q20 551 322 330 322
q21 2783 2501 2481 2481
q22 350 319 298 298
Total cold run time: 108666 ms
Total hot run time: 38950 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4948 5017 4939 4939
q2 319 206 202 202
q3 3350 3322 3327 3322
q4 2260 2273 2270 2270
q5 5872 5845 5849 5845
q6 196 120 117 117
q7 2331 1864 1874 1864
q8 3469 3575 3607 3575
q9 8926 8878 8899 8878
q10 3774 3836 3864 3836
q11 549 421 433 421
q12 800 603 623 603
q13 8624 3254 3219 3219
q14 288 258 267 258
q15 566 522 508 508
q16 511 451 453 451
q17 2072 2041 2005 2005
q18 8843 8347 8401 8347
q19 1620 1643 1599 1599
q20 2185 1942 1921 1921
q21 6092 5767 5695 5695
q22 546 461 492 461
Total cold run time: 68141 ms
Total hot run time: 60336 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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888480968
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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888416218
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 1b8f3d3b8bd429115ac901cddcc287f76dc736de with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 12.7 seconds inserted 10000000 Rows, about 787K 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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888552548
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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #29904:
URL: https://github.com/apache/doris/pull/29904
--
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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888390674
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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888504450
<details>
<summary>TPC-H: <b>Total hot run time: 38633 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 5375fb9b046f853883b509591c7d79946800d12a, data reload: false
------ Round 1 ----------------------------------
q1 17955 4978 4935 4935
q2 2038 140 126 126
q3 10706 1180 1189 1180
q4 10513 799 893 799
q5 7794 3198 3182 3182
q6 202 124 125 124
q7 894 506 504 504
q8 9281 1951 1996 1951
q9 7323 6444 6435 6435
q10 8236 3096 3095 3095
q11 422 219 209 209
q12 358 191 193 191
q13 18101 3452 3387 3387
q14 236 207 213 207
q15 564 513 514 513
q16 422 382 379 379
q17 933 535 524 524
q18 7285 6648 6665 6648
q19 1559 1408 1321 1321
q20 531 317 289 289
q21 2838 2334 2381 2334
q22 342 306 300 300
Total cold run time: 108533 ms
Total hot run time: 38633 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4947 4971 4962 4962
q2 304 195 198 195
q3 3325 3313 3296 3296
q4 2225 2242 2238 2238
q5 5797 5788 5785 5785
q6 189 117 116 116
q7 2311 1883 1874 1874
q8 3441 3514 3539 3514
q9 8848 8810 8792 8792
q10 3739 3855 3829 3829
q11 548 440 412 412
q12 783 610 601 601
q13 6095 3229 3230 3229
q14 288 255 271 255
q15 559 515 513 513
q16 509 463 466 463
q17 2023 1966 2028 1966
q18 8722 8379 8295 8295
q19 1609 1587 1593 1587
q20 2133 1941 1911 1911
q21 5912 5722 5703 5703
q22 547 451 469 451
Total cold run time: 64854 ms
Total hot run time: 59987 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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888414441
<details>
<summary>ClickBench: <b>Total hot run time: 30.53 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 1b8f3d3b8bd429115ac901cddcc287f76dc736de, data reload: false
query1 0.06 0.06 0.06
query2 0.06 0.03 0.02
query3 0.24 0.11 0.11
query4 1.76 0.13 0.11
query5 0.52 0.52 0.52
query6 1.36 0.64 0.64
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.56 0.50 0.48
query10 0.55 0.57 0.55
query11 0.12 0.09 0.09
query12 0.11 0.10 0.09
query13 0.61 0.60 0.59
query14 0.76 0.79 0.77
query15 0.82 0.81 0.80
query16 0.35 0.35 0.36
query17 0.97 0.99 0.96
query18 0.26 0.25 0.25
query19 1.87 1.69 1.72
query20 0.01 0.01 0.01
query21 15.40 0.56 0.56
query22 2.92 2.75 2.00
query23 17.35 0.71 0.80
query24 16.16 0.58 0.58
query25 2.16 0.14 0.15
query26 0.13 0.13 0.13
query27 0.15 0.14 0.14
query28 7.01 0.86 0.82
query29 12.59 3.28 3.15
query30 0.58 0.48 0.49
query31 2.78 0.34 0.36
query32 3.37 0.49 0.48
query33 3.16 3.25 3.26
query34 15.95 4.16 4.17
query35 4.18 4.17 4.18
query36 1.11 1.06 1.05
query37 0.06 0.04 0.04
query38 0.04 0.03 0.03
query39 0.03 0.01 0.01
query40 0.16 0.13 0.13
query41 0.07 0.02 0.01
query42 0.03 0.01 0.01
query43 0.03 0.02 0.02
Total cold run time: 116.47 s
Total hot run time: 30.53 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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888418711
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.3 seconds
stream load tsv: 558 seconds loaded 74807831229 Bytes, about 127 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.4 seconds inserted 10000000 Rows, about 467K ops/s
storage size: 17183831073 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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888410948
<details>
<summary>TPC-DS: <b>Total hot run time: 179384 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 1b8f3d3b8bd429115ac901cddcc287f76dc736de, data reload: false
query1 887 341 329 329
query2 3218 1898 1863 1863
query3 5599 209 207 207
query4 26469 22146 22083 22083
query5 4504 527 477 477
query6 283 181 180 180
query7 4348 282 276 276
query8 241 204 197 197
query9 8498 2789 2749 2749
query10 584 245 249 245
query11 16190 15322 15339 15322
query12 133 78 75 75
query13 1621 382 399 382
query14 10597 7301 7223 7223
query15 251 195 191 191
query16 4788 258 255 255
query17 1738 489 484 484
query18 1743 280 268 268
query19 282 157 154 154
query20 81 86 71 71
query21 178 135 130 130
query22 5006 4862 4730 4730
query23 31888 30946 31035 30946
query24 11734 2856 2832 2832
query25 515 330 334 330
query26 1503 153 156 153
query27 2913 274 277 274
query28 6769 1886 1864 1864
query29 1381 663 681 663
query30 275 139 146 139
query31 1018 785 760 760
query32 93 62 60 60
query33 687 261 256 256
query34 1023 460 467 460
query35 851 757 697 697
query36 1336 1217 1243 1217
query37 166 71 69 69
query38 3409 3283 3244 3244
query39 1354 1286 1271 1271
query40 329 99 92 92
query41 41 36 35 35
query42 108 91 104 91
query43 548 497 486 486
query44 1086 704 712 704
query45 218 191 190 190
query46 1054 666 677 666
query47 1650 1598 1597 1597
query48 409 335 328 328
query49 1055 313 324 313
query50 705 334 329 329
query51 5286 5202 5252 5202
query52 100 89 102 89
query53 364 310 289 289
query54 2060 1605 1612 1605
query55 91 89 81 81
query56 218 212 199 199
query57 1013 956 953 953
query58 230 209 192 192
query59 2815 2579 2538 2538
query60 226 220 235 220
query61 85 91 82 82
query62 581 395 405 395
query63 323 282 286 282
query64 4779 1725 1712 1712
query65 3376 3277 3280 3277
query66 1358 344 318 318
query67 15649 15182 14908 14908
query68 10878 511 526 511
query69 635 392 383 383
query70 1657 1552 1530 1530
query71 485 255 245 245
query72 5048 2826 2922 2826
query73 1975 310 320 310
query74 6916 6388 6426 6388
query75 5640 2309 2321 2309
query76 6267 897 1141 897
query77 721 263 261 261
query78 9907 8627 8774 8627
query79 1022 514 499 499
query80 538 339 346 339
query81 456 207 214 207
query82 202 89 91 89
query83 149 121 120 120
query84 283 78 76 76
query85 1014 331 342 331
query86 419 368 389 368
query87 3608 3407 3416 3407
query88 3201 2211 2188 2188
query89 466 384 401 384
query90 1862 204 192 192
query91 155 129 124 124
query92 61 60 54 54
query93 938 422 432 422
query94 1126 186 179 179
query95 528 479 489 479
query96 619 310 324 310
query97 4311 4148 4186 4148
query98 206 193 188 188
query99 981 730 694 694
Total cold run time: 282185 ms
Total hot run time: 179384 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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888519209
<details>
<summary>ClickBench: <b>Total hot run time: 30.86 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 5375fb9b046f853883b509591c7d79946800d12a, data reload: false
query1 0.06 0.06 0.04
query2 0.06 0.02 0.02
query3 0.25 0.11 0.10
query4 1.80 0.12 0.11
query5 0.52 0.52 0.52
query6 1.37 0.63 0.61
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.55 0.51 0.49
query10 0.55 0.55 0.53
query11 0.12 0.10 0.09
query12 0.12 0.10 0.09
query13 0.61 0.60 0.60
query14 0.79 0.78 0.80
query15 0.82 0.80 0.79
query16 0.34 0.35 0.36
query17 0.98 0.94 0.96
query18 0.25 0.25 0.26
query19 1.88 1.80 1.74
query20 0.02 0.01 0.01
query21 15.40 0.57 0.56
query22 2.68 2.50 2.35
query23 17.45 0.76 0.78
query24 16.03 0.57 0.56
query25 2.16 0.14 0.14
query26 0.14 0.13 0.13
query27 0.15 0.15 0.14
query28 6.15 0.84 0.83
query29 12.57 3.18 3.16
query30 0.58 0.49 0.46
query31 2.79 0.34 0.36
query32 3.37 0.49 0.49
query33 3.19 3.19 3.28
query34 15.76 4.18 4.16
query35 4.18 4.19 4.19
query36 1.08 1.04 1.03
query37 0.06 0.05 0.05
query38 0.03 0.03 0.03
query39 0.03 0.01 0.02
query40 0.16 0.15 0.13
query41 0.07 0.02 0.02
query42 0.02 0.02 0.01
query43 0.02 0.02 0.02
Total cold run time: 115.22 s
Total hot run time: 30.86 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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888521969
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 5375fb9b046f853883b509591c7d79946800d12a with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888552497
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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888513780
<details>
<summary>TPC-DS: <b>Total hot run time: 179570 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 5375fb9b046f853883b509591c7d79946800d12a, data reload: false
query1 926 328 325 325
query2 6721 2033 1882 1882
query3 6693 215 201 201
query4 26001 22001 22223 22001
query5 5784 476 498 476
query6 263 205 192 192
query7 4622 271 277 271
query8 229 191 197 191
query9 9235 2709 2889 2709
query10 522 244 247 244
query11 16206 15319 15483 15319
query12 134 75 67 67
query13 1724 391 381 381
query14 12124 7084 7089 7084
query15 225 192 196 192
query16 6523 252 243 243
query17 1948 493 478 478
query18 1944 273 257 257
query19 280 162 146 146
query20 79 79 69 69
query21 193 119 121 119
query22 5340 5109 5139 5109
query23 31723 30865 30901 30865
query24 12240 2818 2761 2761
query25 549 322 323 322
query26 1741 152 151 151
query27 2907 274 279 274
query28 7035 1867 1850 1850
query29 2065 686 656 656
query30 282 143 137 137
query31 965 758 783 758
query32 90 64 59 59
query33 720 245 254 245
query34 1076 454 449 449
query35 896 753 718 718
query36 1312 1207 1232 1207
query37 186 74 66 66
query38 3407 3303 3302 3302
query39 1320 1272 1280 1272
query40 314 98 95 95
query41 38 35 35 35
query42 97 92 100 92
query43 561 513 501 501
query44 1044 689 703 689
query45 208 188 178 178
query46 1041 641 663 641
query47 1676 1487 1585 1487
query48 415 314 314 314
query49 1257 312 310 310
query50 713 312 302 302
query51 5344 5226 5194 5194
query52 91 95 87 87
query53 372 293 286 286
query54 2048 1588 1605 1588
query55 95 89 88 88
query56 211 188 197 188
query57 1032 988 961 961
query58 219 197 196 196
query59 2750 2532 2523 2523
query60 226 220 205 205
query61 87 83 81 81
query62 566 365 404 365
query63 302 278 275 275
query64 5772 1702 1631 1631
query65 3316 3253 3279 3253
query66 1324 342 329 329
query67 15747 15315 15423 15315
query68 10703 520 517 517
query69 649 384 393 384
query70 1711 1525 1516 1516
query71 496 244 237 237
query72 4678 2820 2792 2792
query73 2155 314 308 308
query74 7025 6480 6471 6471
query75 4789 2366 2336 2336
query76 6374 1081 1096 1081
query77 775 282 262 262
query78 9821 8715 8570 8570
query79 1022 503 503 503
query80 529 344 340 340
query81 453 209 208 208
query82 220 93 84 84
query83 139 126 121 121
query84 283 75 76 75
query85 1003 337 326 326
query86 368 375 396 375
query87 3575 3446 3490 3446
query88 3515 2194 2180 2180
query89 437 380 392 380
query90 1897 213 211 211
query91 175 122 130 122
query92 63 50 51 50
query93 1915 446 430 430
query94 1200 177 176 176
query95 521 493 474 474
query96 632 315 311 311
query97 4260 4153 4164 4153
query98 228 185 186 185
query99 1007 689 714 689
Total cold run time: 295714 ms
Total hot run time: 179570 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] [unit test](statistics)Add unit test case for auto analyze. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29904:
URL: https://github.com/apache/doris/pull/29904#issuecomment-1888518119
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.21 seconds
stream load tsv: 559 seconds loaded 74807831229 Bytes, about 127 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: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 21.5 seconds inserted 10000000 Rows, about 465K ops/s
storage size: 17183935170 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