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/07/18 06:02:40 UTC
[PR] [improvement](statistics) Update table/index row count in one operation. [doris]
Jibing-Li opened a new pull request, #38059:
URL: https://github.com/apache/doris/pull/38059
Atomic update table/index row count. Avoid the row count in partial updated status.
--
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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236355810
<details>
<summary>ClickBench: <b>Total hot run time: 30.48 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 cc51afe349677c6a356dce62465bbf076267edf8, data reload: false
query1 0.05 0.03 0.03
query2 0.08 0.04 0.04
query3 0.22 0.05 0.04
query4 1.67 0.07 0.06
query5 0.49 0.48 0.48
query6 1.13 0.73 0.72
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.55 0.49 0.50
query10 0.55 0.54 0.54
query11 0.15 0.11 0.11
query12 0.14 0.12 0.12
query13 0.59 0.59 0.57
query14 0.75 0.78 0.77
query15 0.86 0.83 0.81
query16 0.37 0.37 0.38
query17 1.01 1.00 1.01
query18 0.24 0.22 0.22
query19 1.81 1.79 1.73
query20 0.01 0.01 0.02
query21 15.40 0.75 0.66
query22 4.19 7.28 1.94
query23 18.25 1.43 1.22
query24 2.07 0.24 0.21
query25 0.17 0.09 0.07
query26 0.29 0.21 0.21
query27 0.47 0.23 0.23
query28 13.27 1.02 1.00
query29 12.60 3.33 3.31
query30 0.25 0.05 0.06
query31 2.86 0.38 0.39
query32 3.28 0.47 0.47
query33 2.89 2.88 2.91
query34 17.07 4.29 4.36
query35 4.41 4.35 4.42
query36 0.65 0.50 0.47
query37 0.18 0.16 0.16
query38 0.16 0.15 0.15
query39 0.04 0.03 0.04
query40 0.15 0.13 0.12
query41 0.09 0.05 0.05
query42 0.05 0.05 0.04
query43 0.04 0.04 0.03
Total cold run time: 109.57 s
Total hot run time: 30.48 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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2235770415
<details>
<summary>ClickBench: <b>Total hot run time: 30.3 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 8eb63b433e8111ca89b054a326c07b165144b020, data reload: false
query1 0.03 0.03 0.03
query2 0.08 0.03 0.04
query3 0.23 0.06 0.06
query4 1.65 0.07 0.09
query5 0.50 0.48 0.49
query6 1.13 0.73 0.73
query7 0.02 0.01 0.01
query8 0.04 0.05 0.04
query9 0.55 0.50 0.49
query10 0.54 0.54 0.54
query11 0.15 0.11 0.12
query12 0.15 0.12 0.12
query13 0.58 0.59 0.58
query14 0.76 0.80 0.77
query15 0.86 0.84 0.83
query16 0.37 0.36 0.35
query17 0.98 0.95 0.96
query18 0.22 0.22 0.22
query19 1.78 1.69 1.75
query20 0.02 0.01 0.01
query21 15.39 0.74 0.65
query22 4.62 7.77 1.56
query23 18.27 1.38 1.28
query24 2.14 0.23 0.23
query25 0.16 0.09 0.08
query26 0.31 0.21 0.21
query27 0.45 0.23 0.23
query28 13.24 1.01 1.00
query29 12.60 3.32 3.28
query30 0.25 0.06 0.06
query31 2.84 0.39 0.38
query32 3.28 0.49 0.48
query33 2.88 2.93 2.96
query34 16.88 4.36 4.36
query35 4.47 4.42 4.42
query36 0.66 0.47 0.46
query37 0.19 0.16 0.15
query38 0.16 0.15 0.16
query39 0.04 0.04 0.03
query40 0.16 0.13 0.12
query41 0.10 0.04 0.05
query42 0.05 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 109.82 s
Total hot run time: 30.3 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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236036853
<details>
<summary>TPC-DS: <b>Total hot run time: 174256 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 ace45753a79e189e9b770622587393624e796911, data reload: false
query1 919 373 367 367
query2 6445 1864 1915 1864
query3 6655 206 219 206
query4 28577 17553 17323 17323
query5 3745 478 479 478
query6 264 168 166 166
query7 4577 300 291 291
query8 234 214 188 188
query9 8709 2521 2509 2509
query10 444 306 276 276
query11 11647 10267 9998 9998
query12 116 88 84 84
query13 1659 375 377 375
query14 10127 7076 7743 7076
query15 230 170 171 170
query16 7677 348 313 313
query17 1785 589 550 550
query18 1954 295 286 286
query19 201 156 153 153
query20 90 80 80 80
query21 211 131 129 129
query22 4413 4043 4128 4043
query23 34238 33988 33757 33757
query24 12106 2934 2972 2934
query25 672 381 390 381
query26 1786 159 157 157
query27 2991 302 289 289
query28 8099 2136 2092 2092
query29 1115 666 646 646
query30 263 155 153 153
query31 953 766 769 766
query32 96 52 54 52
query33 756 305 330 305
query34 929 495 511 495
query35 724 599 617 599
query36 1120 988 967 967
query37 273 91 88 88
query38 2941 2795 2738 2738
query39 866 807 812 807
query40 242 124 121 121
query41 46 45 43 43
query42 122 104 101 101
query43 517 473 469 469
query44 1220 741 736 736
query45 199 164 157 157
query46 1108 752 732 732
query47 1868 1776 1797 1776
query48 386 290 296 290
query49 940 405 445 405
query50 772 400 401 400
query51 6975 6875 6834 6834
query52 102 95 93 93
query53 364 294 294 294
query54 898 451 456 451
query55 77 75 79 75
query56 290 269 265 265
query57 1134 1081 1083 1081
query58 250 249 275 249
query59 2858 2584 2624 2584
query60 318 300 299 299
query61 98 94 95 94
query62 791 656 645 645
query63 315 285 290 285
query64 10246 2235 7416 2235
query65 3136 3290 3119 3119
query66 1245 336 324 324
query67 15502 15057 15006 15006
query68 4547 556 564 556
query69 611 404 347 347
query70 1203 1173 1097 1097
query71 463 286 287 286
query72 8007 5669 5530 5530
query73 748 329 333 329
query74 6168 5721 5643 5643
query75 3691 2685 2760 2685
query76 3133 1091 925 925
query77 566 308 310 308
query78 9648 9036 8970 8970
query79 2499 524 525 524
query80 2800 470 485 470
query81 607 218 228 218
query82 958 133 138 133
query83 325 171 165 165
query84 279 95 84 84
query85 2069 311 296 296
query86 475 313 317 313
query87 3284 3161 3118 3118
query88 4379 2471 2510 2471
query89 473 382 376 376
query90 1927 192 187 187
query91 128 100 98 98
query92 60 50 47 47
query93 2597 519 518 518
query94 1283 213 222 213
query95 412 316 333 316
query96 594 282 280 280
query97 3187 3011 3056 3011
query98 217 199 191 191
query99 1544 1288 1237 1237
Total cold run time: 291508 ms
Total hot run time: 174256 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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li merged PR #38059:
URL: https://github.com/apache/doris/pull/38059
--
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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236014648
<details>
<summary>TPC-H: <b>Total hot run time: 39996 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 ace45753a79e189e9b770622587393624e796911, data reload: false
------ Round 1 ----------------------------------
q1 17864 6799 4324 4324
q2 2017 192 191 191
q3 10549 1149 1050 1050
q4 10340 783 885 783
q5 7579 2743 2694 2694
q6 217 137 137 137
q7 972 602 598 598
q8 9215 2111 2128 2111
q9 8669 6576 6594 6576
q10 8758 3823 3781 3781
q11 465 245 249 245
q12 401 225 226 225
q13 17794 2944 2985 2944
q14 288 225 237 225
q15 531 485 490 485
q16 476 378 378 378
q17 998 656 668 656
q18 8229 7463 7440 7440
q19 5948 1365 1307 1307
q20 683 330 353 330
q21 5037 3219 3999 3219
q22 372 305 297 297
Total cold run time: 117402 ms
Total hot run time: 39996 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4394 4234 4245 4234
q2 382 269 273 269
q3 3130 3007 2929 2929
q4 2014 1741 1731 1731
q5 5583 5470 5550 5470
q6 236 136 141 136
q7 2239 1885 1811 1811
q8 3318 3421 3458 3421
q9 8837 8966 8784 8784
q10 4097 3834 3884 3834
q11 607 521 497 497
q12 800 643 625 625
q13 16374 3128 3171 3128
q14 310 305 295 295
q15 536 510 507 507
q16 493 434 430 430
q17 1824 1521 1512 1512
q18 8356 8271 7888 7888
q19 3620 1697 1587 1587
q20 2080 1864 1879 1864
q21 5001 4811 4958 4811
q22 584 532 523 523
Total cold run time: 74815 ms
Total hot run time: 56286 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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236345943
<details>
<summary>TPC-DS: <b>Total hot run time: 173620 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 cc51afe349677c6a356dce62465bbf076267edf8, data reload: false
query1 920 376 368 368
query2 6436 1843 1838 1838
query3 6637 211 220 211
query4 26829 17588 17467 17467
query5 3586 469 478 469
query6 308 171 190 171
query7 4589 291 302 291
query8 237 200 195 195
query9 8438 2497 2514 2497
query10 429 285 257 257
query11 11722 10151 10275 10151
query12 115 85 83 83
query13 1661 373 361 361
query14 10242 7323 7553 7323
query15 232 166 166 166
query16 7749 330 312 312
query17 1793 548 526 526
query18 1940 281 269 269
query19 202 156 181 156
query20 86 80 86 80
query21 202 135 125 125
query22 4295 3982 4132 3982
query23 34095 33762 33378 33378
query24 10582 2930 2998 2930
query25 614 411 423 411
query26 696 157 152 152
query27 2227 283 281 281
query28 6244 2131 2101 2101
query29 896 636 651 636
query30 251 151 162 151
query31 966 744 771 744
query32 105 56 57 56
query33 661 328 314 314
query34 906 567 499 499
query35 678 592 580 580
query36 1151 978 961 961
query37 140 79 82 79
query38 2966 2828 2821 2821
query39 895 831 816 816
query40 201 119 116 116
query41 48 46 45 45
query42 113 96 96 96
query43 493 484 478 478
query44 1089 729 746 729
query45 192 163 160 160
query46 1093 725 716 716
query47 1867 1767 1781 1767
query48 377 295 285 285
query49 822 411 412 411
query50 774 426 394 394
query51 6878 6692 6830 6692
query52 111 92 97 92
query53 367 295 285 285
query54 862 460 447 447
query55 75 71 73 71
query56 295 272 273 272
query57 1151 1054 1074 1054
query58 243 241 250 241
query59 2826 2689 2652 2652
query60 303 275 306 275
query61 95 99 98 98
query62 796 647 631 631
query63 318 302 289 289
query64 9148 2229 1688 1688
query65 3128 3098 3136 3098
query66 741 334 326 326
query67 15476 14952 14916 14916
query68 4492 549 550 549
query69 472 329 334 329
query70 1204 1060 1136 1060
query71 368 280 271 271
query72 7124 5555 5567 5555
query73 744 337 326 326
query74 6144 5621 5611 5611
query75 3376 2684 2682 2682
query76 2224 1009 937 937
query77 434 316 297 297
query78 9530 9000 10071 9000
query79 2539 535 529 529
query80 1633 501 497 497
query81 599 235 225 225
query82 860 147 138 138
query83 273 182 175 175
query84 251 100 91 91
query85 1800 378 357 357
query86 330 303 310 303
query87 3266 3143 3135 3135
query88 3886 2463 2574 2463
query89 478 376 385 376
query90 1730 197 192 192
query91 142 113 113 113
query92 61 50 52 50
query93 2862 524 513 513
query94 774 229 232 229
query95 421 333 339 333
query96 602 294 291 291
query97 3184 3051 3035 3035
query98 216 208 198 198
query99 1698 1277 1228 1228
Total cold run time: 276320 ms
Total hot run time: 173620 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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2235694488
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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236597474
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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2235746315
<details>
<summary>TPC-H: <b>Total hot run time: 39718 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 8eb63b433e8111ca89b054a326c07b165144b020, data reload: false
------ Round 1 ----------------------------------
q1 17597 4339 4266 4266
q2 2011 188 191 188
q3 10464 1119 1107 1107
q4 10195 817 803 803
q5 7544 2659 2680 2659
q6 218 137 136 136
q7 951 604 599 599
q8 9214 2087 2063 2063
q9 8727 6520 6524 6520
q10 8832 3781 3783 3781
q11 461 239 244 239
q12 443 231 224 224
q13 17795 2945 2978 2945
q14 283 239 245 239
q15 527 474 470 470
q16 491 374 374 374
q17 973 684 747 684
q18 8001 7422 7389 7389
q19 8602 1384 1334 1334
q20 658 312 325 312
q21 4951 3105 3849 3105
q22 339 281 295 281
Total cold run time: 119277 ms
Total hot run time: 39718 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4382 4282 4235 4235
q2 386 270 255 255
q3 3063 2919 2965 2919
q4 1944 1695 1740 1695
q5 5541 5555 5441 5441
q6 221 133 135 133
q7 2246 1868 1872 1868
q8 3288 3453 3432 3432
q9 8750 8886 8792 8792
q10 4143 3753 3855 3753
q11 593 517 510 510
q12 820 654 630 630
q13 17301 3157 3162 3157
q14 313 283 296 283
q15 533 497 490 490
q16 483 441 449 441
q17 1797 1522 1510 1510
q18 8222 7935 7833 7833
q19 1777 1490 1624 1490
q20 2893 1865 1876 1865
q21 7399 4860 4898 4860
q22 618 545 513 513
Total cold run time: 76713 ms
Total hot run time: 56105 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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236325889
<details>
<summary>TPC-H: <b>Total hot run time: 40245 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 cc51afe349677c6a356dce62465bbf076267edf8, data reload: false
------ Round 1 ----------------------------------
q1 17621 4352 4329 4329
q2 2017 198 194 194
q3 10522 1226 1149 1149
q4 10188 845 857 845
q5 7586 2706 2714 2706
q6 218 139 137 137
q7 968 598 594 594
q8 9238 2095 2151 2095
q9 8987 6582 6597 6582
q10 8890 3836 3807 3807
q11 446 250 242 242
q12 443 226 232 226
q13 17779 2995 2991 2991
q14 279 233 240 233
q15 537 480 493 480
q16 508 381 370 370
q17 980 718 720 718
q18 8259 7572 7347 7347
q19 7454 1344 1387 1344
q20 693 330 335 330
q21 4927 3236 3268 3236
q22 361 295 290 290
Total cold run time: 118901 ms
Total hot run time: 40245 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4430 4310 4265 4265
q2 365 276 268 268
q3 3072 2978 2946 2946
q4 1969 1779 1780 1779
q5 5623 5563 5498 5498
q6 227 135 137 135
q7 2328 1847 1838 1838
q8 3272 3462 3425 3425
q9 8783 8916 8750 8750
q10 4170 3780 3903 3780
q11 602 502 495 495
q12 800 661 624 624
q13 16078 3158 3209 3158
q14 313 306 288 288
q15 554 489 500 489
q16 519 437 450 437
q17 1832 1526 1533 1526
q18 8353 8017 7894 7894
q19 1739 1574 1662 1574
q20 2054 1877 1869 1869
q21 9647 4763 4693 4693
q22 649 510 502 502
Total cold run time: 77379 ms
Total hot run time: 56233 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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236597564
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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236585233
run cloud_p1
--
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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2235688695
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236047740
<details>
<summary>ClickBench: <b>Total hot run time: 30.56 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 ace45753a79e189e9b770622587393624e796911, data reload: false
query1 0.04 0.03 0.04
query2 0.09 0.04 0.04
query3 0.24 0.04 0.04
query4 1.66 0.08 0.08
query5 0.48 0.49 0.49
query6 1.14 0.72 0.72
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.55 0.50 0.49
query10 0.54 0.54 0.53
query11 0.16 0.11 0.10
query12 0.14 0.12 0.12
query13 0.58 0.58 0.58
query14 0.76 0.76 0.78
query15 0.84 0.83 0.83
query16 0.38 0.37 0.38
query17 1.07 1.06 1.00
query18 0.23 0.21 0.20
query19 1.81 1.82 1.83
query20 0.01 0.00 0.01
query21 15.40 0.76 0.65
query22 4.95 7.04 1.89
query23 18.28 1.41 1.23
query24 2.20 0.21 0.21
query25 0.16 0.08 0.10
query26 0.30 0.20 0.21
query27 0.45 0.23 0.22
query28 13.25 1.01 0.99
query29 12.62 3.36 3.34
query30 0.25 0.06 0.06
query31 2.88 0.38 0.38
query32 3.26 0.49 0.46
query33 2.89 2.89 2.93
query34 17.07 4.34 4.30
query35 4.37 4.38 4.42
query36 0.67 0.45 0.49
query37 0.18 0.16 0.16
query38 0.15 0.15 0.14
query39 0.04 0.03 0.04
query40 0.15 0.12 0.13
query41 0.10 0.05 0.04
query42 0.06 0.05 0.05
query43 0.04 0.05 0.04
Total cold run time: 110.51 s
Total hot run time: 30.56 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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2235904956
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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2235761938
<details>
<summary>TPC-DS: <b>Total hot run time: 173877 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 8eb63b433e8111ca89b054a326c07b165144b020, data reload: false
query1 905 369 365 365
query2 6451 1885 1837 1837
query3 6641 207 231 207
query4 28382 17489 17741 17489
query5 3708 466 470 466
query6 266 187 162 162
query7 4573 281 278 278
query8 237 192 194 192
query9 8583 2445 2414 2414
query10 444 277 261 261
query11 11569 9956 9925 9925
query12 110 84 87 84
query13 1636 365 360 360
query14 10071 7772 7536 7536
query15 224 163 168 163
query16 7120 315 309 309
query17 1376 540 524 524
query18 1553 296 302 296
query19 199 178 147 147
query20 90 83 82 82
query21 202 122 123 122
query22 4314 4074 3924 3924
query23 33985 33778 33491 33491
query24 11363 2916 2956 2916
query25 618 388 396 388
query26 709 154 149 149
query27 2291 277 279 277
query28 6700 2096 2072 2072
query29 885 615 649 615
query30 260 150 147 147
query31 986 756 759 756
query32 100 57 53 53
query33 758 315 305 305
query34 1051 482 510 482
query35 685 583 592 583
query36 1143 970 986 970
query37 151 81 86 81
query38 2953 2862 2803 2803
query39 903 860 828 828
query40 212 124 121 121
query41 46 44 43 43
query42 107 99 95 95
query43 519 473 477 473
query44 1213 715 711 711
query45 199 166 165 165
query46 1089 727 720 720
query47 1851 1748 1789 1748
query48 372 287 292 287
query49 832 403 410 403
query50 779 395 396 395
query51 6891 6780 6757 6757
query52 104 93 93 93
query53 358 295 292 292
query54 922 442 441 441
query55 74 71 71 71
query56 284 259 257 257
query57 1092 1054 1044 1044
query58 255 246 248 246
query59 2849 2602 2500 2500
query60 297 271 274 271
query61 94 94 92 92
query62 786 629 658 629
query63 331 287 283 283
query64 9195 2719 2287 2287
query65 3159 3081 3120 3081
query66 829 338 343 338
query67 15560 14838 14800 14800
query68 4489 535 544 535
query69 548 429 344 344
query70 1141 1109 1159 1109
query71 399 282 284 282
query72 6914 5802 5801 5801
query73 748 328 334 328
query74 6152 5654 5699 5654
query75 3361 2716 2642 2642
query76 2422 914 947 914
query77 430 315 310 310
query78 9757 9052 8988 8988
query79 4395 533 526 526
query80 2615 493 499 493
query81 586 224 225 224
query82 1195 143 138 138
query83 328 179 174 174
query84 285 95 94 94
query85 1858 469 287 287
query86 494 309 353 309
query87 3238 3126 3125 3125
query88 4683 2477 2434 2434
query89 492 384 381 381
query90 1821 195 197 195
query91 130 99 104 99
query92 60 48 50 48
query93 5275 498 503 498
query94 1228 212 214 212
query95 406 307 316 307
query96 599 273 274 273
query97 3212 3030 3036 3030
query98 225 194 187 187
query99 1580 1260 1234 1234
Total cold run time: 285560 ms
Total hot run time: 173877 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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236267756
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] [improvement](statistics) Update table/index row count in one operation. [doris]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
Jibing-Li commented on PR #38059:
URL: https://github.com/apache/doris/pull/38059#issuecomment-2236602422
run cloud_p1
--
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