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 2023/12/12 16:37:21 UTC
[PR] [fix](statistics)Fix column stats trigger info bug. [doris]
Jibing-Li opened a new pull request, #28303:
URL: https://github.com/apache/doris/pull/28303
## 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] [fix](statistics)Fix column stats trigger info bug. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28303:
URL: https://github.com/apache/doris/pull/28303#issuecomment-1853741810
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 7f1c22d766ea58b39a81e404240061c2e7593391, data reload: false
run tpch-sf100 query with default conf and session variables
q1 50190 31979 31843 31843
q2 365 137 136 136
q3 1508 1216 1188 1188
q4 1122 932 880 880
q5 3278 3216 3194 3194
q6 268 155 146 146
q7 992 488 475 475
q8 2149 2236 2206 2206
q9 6943 6943 6862 6862
q10 3242 3270 3302 3270
q11 351 222 218 218
q12 351 207 205 205
q13 4550 3925 3832 3832
q14 429 336 334 334
q15 768 1282 1335 1282
q16 441 396 383 383
q17 1030 619 563 563
q18 7535 8065 7036 7036
q19 1528 1374 1460 1374
q20 588 732 314 314
q21 3046 2652 2697 2652
q22 351 281 288 281
Total cold run time: 91025 ms
Total hot run time: 68674 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 30813 31845 31809 31809
q2 278 172 180 172
q3 3664 3672 3578 3578
q4 2383 2390 2367 2367
q5 5824 5821 5824 5821
q6 242 133 136 133
q7 3040 3407 3368 3368
q8 3544 3549 3543 3543
q9 9231 9186 9182 9182
q10 3967 4056 4060 4056
q11 881 863 1340 863
q12 765 605 606 605
q13 4300 3606 3570 3570
q14 534 449 464 449
q15 1049 1334 1321 1321
q16 499 492 471 471
q17 1897 1884 1845 1845
q18 8866 8625 8620 8620
q19 1777 1767 1760 1760
q20 2914 2612 2644 2612
q21 6567 6210 6202 6202
q22 504 428 420 420
Total cold run time: 93539 ms
Total hot run time: 92767 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](statistics)Fix column stats trigger info bug. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28303:
URL: https://github.com/apache/doris/pull/28303#issuecomment-1852465398
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.77 seconds
stream load tsv: 579 seconds loaded 74807831229 Bytes, about 123 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 66 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
insert into select: 28.9 seconds inserted 10000000 Rows, about 346K ops/s
storage size: 17219791441 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] [fix](statistics)Fix column stats trigger info bug. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28303:
URL: https://github.com/apache/doris/pull/28303#issuecomment-1853621297
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](statistics)Fix column stats trigger info bug. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #28303:
URL: https://github.com/apache/doris/pull/28303#issuecomment-1852402806
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](statistics)Fix column stats trigger info bug. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28303:
URL: https://github.com/apache/doris/pull/28303#issuecomment-1852442170
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit e93572c255d1aab6d7df4292728023ba6dff2693, data reload: false
run tpch-sf100 query with default conf and session variables
q1 51380 31852 31830 31830
q2 382 143 139 139
q3 1563 1244 1224 1224
q4 1112 920 919 919
q5 3292 3215 3245 3215
q6 264 143 139 139
q7 982 486 505 486
q8 2141 2229 2180 2180
q9 6908 6870 6865 6865
q10 3256 3302 3307 3302
q11 342 211 209 209
q12 347 206 208 206
q13 4592 3802 3808 3802
q14 425 327 321 321
q15 765 1300 1342 1300
q16 440 396 389 389
q17 1017 569 549 549
q18 7351 7207 6859 6859
q19 1535 1336 1476 1336
q20 595 304 331 304
q21 3073 2632 2681 2632
q22 355 291 293 291
Total cold run time: 92117 ms
Total hot run time: 68497 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 30794 31856 31807 31807
q2 277 167 173 167
q3 3672 3601 3596 3596
q4 2404 2386 2376 2376
q5 5816 5854 5815 5815
q6 239 134 131 131
q7 3079 3396 3368 3368
q8 3535 3549 3524 3524
q9 9217 9137 9112 9112
q10 3967 4073 4063 4063
q11 793 921 1363 921
q12 774 607 594 594
q13 4274 3525 3584 3525
q14 509 426 425 425
q15 1120 1344 1318 1318
q16 495 460 489 460
q17 1865 1846 1830 1830
q18 8891 8201 8197 8197
q19 1751 1772 1750 1750
q20 2897 2591 2581 2581
q21 6539 6186 6128 6128
q22 488 422 411 411
Total cold run time: 93396 ms
Total hot run time: 92099 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](statistics)Fix column stats trigger info bug. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #28303:
URL: https://github.com/apache/doris/pull/28303#issuecomment-1853613121
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](statistics)Fix column stats trigger info bug. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #28303:
URL: https://github.com/apache/doris/pull/28303#issuecomment-1853621380
PR approved by anyone and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](statistics)Fix column stats trigger info bug. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #28303:
URL: https://github.com/apache/doris/pull/28303#issuecomment-1853702825
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.44 seconds
stream load tsv: 593 seconds loaded 74807831229 Bytes, about 120 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 67 seconds loaded 1101869774 Bytes, about 15 MB/s
stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
insert into select: 28.4 seconds inserted 10000000 Rows, about 352K ops/s
storage size: 17224294282 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] [fix](statistics)Fix column stats trigger info bug. [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #28303:
URL: https://github.com/apache/doris/pull/28303
--
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