You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "w41ter (via GitHub)" <gi...@apache.org> on 2024/06/12 11:09:51 UTC
[PR] [fix](alter) Remove rebuildAlterJob [doris]
w41ter opened a new pull request, #36196:
URL: https://github.com/apache/doris/pull/36196
The compatible subtype was introduced in #35989, after that the RollupJobV2 and SchemaChangeJobV2 will be instanced to CloudRollupJobV2 and SchemaChangeJobV2. So there is no need to use rebuildAlterJob anymore.
--
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](alter) Remove rebuildAlterJob [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36196:
URL: https://github.com/apache/doris/pull/36196#issuecomment-2162825061
<details>
<summary>TPC-H: <b>Total hot run time: 39578 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 aa5bf07cced568d9dcfcfcb7da07c856b4d6f8f6, data reload: false
------ Round 1 ----------------------------------
q1 17629 4323 4249 4249
q2 2025 190 190 190
q3 10451 1131 1088 1088
q4 10186 748 858 748
q5 7456 2658 2707 2658
q6 225 141 135 135
q7 953 596 599 596
q8 9220 2046 2057 2046
q9 8913 6493 6460 6460
q10 9002 3724 3685 3685
q11 463 234 236 234
q12 441 228 221 221
q13 18734 2936 2993 2936
q14 272 221 219 219
q15 514 477 472 472
q16 520 382 368 368
q17 955 719 690 690
q18 7894 7399 7346 7346
q19 4451 1466 1505 1466
q20 646 316 318 316
q21 4802 3131 3125 3125
q22 381 337 330 330
Total cold run time: 116133 ms
Total hot run time: 39578 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4526 4244 4217 4217
q2 369 272 264 264
q3 2921 2711 2900 2711
q4 1997 1662 1666 1662
q5 5597 5516 5507 5507
q6 217 134 127 127
q7 2140 1791 1894 1791
q8 3281 3388 3374 3374
q9 8701 8648 8774 8648
q10 4017 3880 3821 3821
q11 578 484 484 484
q12 770 610 615 610
q13 16091 3148 3167 3148
q14 313 273 278 273
q15 546 500 484 484
q16 502 435 429 429
q17 1803 1528 1478 1478
q18 7997 7808 7721 7721
q19 1804 1635 1699 1635
q20 2812 1870 1875 1870
q21 5146 4896 4966 4896
q22 625 555 546 546
Total cold run time: 72753 ms
Total hot run time: 55696 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](alter) Remove rebuildAlterJob [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36196:
URL: https://github.com/apache/doris/pull/36196#issuecomment-2162847784
<details>
<summary>TPC-DS: <b>Total hot run time: 170454 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 aa5bf07cced568d9dcfcfcb7da07c856b4d6f8f6, data reload: false
query1 947 389 380 380
query2 6451 2424 2395 2395
query3 6640 210 212 210
query4 19033 17342 17324 17324
query5 3579 478 446 446
query6 244 171 159 159
query7 4645 299 295 295
query8 313 298 297 297
query9 8481 2450 2420 2420
query10 593 311 282 282
query11 10877 10254 10146 10146
query12 124 95 87 87
query13 1645 377 378 377
query14 10029 6046 7573 6046
query15 234 195 185 185
query16 7727 261 262 261
query17 1922 535 513 513
query18 1911 293 271 271
query19 189 151 148 148
query20 90 81 82 81
query21 207 127 130 127
query22 4509 4005 4065 4005
query23 33814 33847 33796 33796
query24 11058 3056 3044 3044
query25 627 378 380 378
query26 1198 156 157 156
query27 2977 328 337 328
query28 7489 2079 2054 2054
query29 924 648 636 636
query30 256 155 163 155
query31 992 767 819 767
query32 99 56 56 56
query33 747 279 299 279
query34 1044 499 473 473
query35 752 668 639 639
query36 1133 1002 979 979
query37 174 80 74 74
query38 2970 2872 2817 2817
query39 925 843 822 822
query40 217 126 124 124
query41 56 51 57 51
query42 111 115 111 111
query43 606 583 549 549
query44 1259 729 755 729
query45 205 155 164 155
query46 1083 758 728 728
query47 1868 1764 1762 1762
query48 374 307 298 298
query49 870 412 421 412
query50 757 390 384 384
query51 6781 6617 6628 6617
query52 105 92 99 92
query53 355 289 292 289
query54 863 449 449 449
query55 76 74 75 74
query56 323 257 250 250
query57 1107 1028 1023 1023
query58 241 242 236 236
query59 3480 3118 3162 3118
query60 295 267 260 260
query61 87 87 92 87
query62 606 461 451 451
query63 316 293 292 292
query64 8745 2212 1735 1735
query65 3260 3088 3089 3088
query66 822 309 323 309
query67 15263 14878 14817 14817
query68 6083 541 528 528
query69 625 475 426 426
query70 1146 1148 1144 1144
query71 502 269 266 266
query72 7353 5653 2752 2752
query73 788 331 321 321
query74 5888 5589 5466 5466
query75 4051 2728 2680 2680
query76 4135 961 914 914
query77 715 307 306 306
query78 10373 9842 9654 9654
query79 2166 510 502 502
query80 2100 469 518 469
query81 568 221 220 220
query82 760 104 100 100
query83 280 166 167 166
query84 268 86 85 85
query85 1353 286 265 265
query86 448 310 334 310
query87 3239 3121 3057 3057
query88 4222 2449 2431 2431
query89 465 376 368 368
query90 1759 192 187 187
query91 129 101 99 99
query92 57 47 51 47
query93 2591 494 498 494
query94 1023 194 187 187
query95 408 311 312 311
query96 605 281 267 267
query97 3227 3072 3010 3010
query98 220 203 190 190
query99 1167 834 835 834
Total cold run time: 276414 ms
Total hot run time: 170454 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](alter) Remove rebuildAlterJob [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36196:
URL: https://github.com/apache/doris/pull/36196#issuecomment-2162751541
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](alter) Remove rebuildAlterJob [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36196:
URL: https://github.com/apache/doris/pull/36196#issuecomment-2162738606
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](alter) Remove rebuildAlterJob [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36196:
URL: https://github.com/apache/doris/pull/36196#issuecomment-2162858792
<details>
<summary>ClickBench: <b>Total hot run time: 31.26 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 aa5bf07cced568d9dcfcfcb7da07c856b4d6f8f6, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.04 0.04
query3 0.23 0.05 0.05
query4 1.65 0.10 0.08
query5 0.50 0.50 0.49
query6 1.12 0.74 0.73
query7 0.02 0.01 0.01
query8 0.06 0.04 0.04
query9 0.54 0.50 0.49
query10 0.53 0.55 0.54
query11 0.16 0.12 0.11
query12 0.15 0.12 0.12
query13 0.59 0.58 0.60
query14 0.80 0.78 0.78
query15 0.82 0.82 0.81
query16 0.35 0.34 0.34
query17 0.96 0.97 0.95
query18 0.21 0.27 0.23
query19 1.84 1.73 1.72
query20 0.01 0.01 0.01
query21 15.41 0.65 0.65
query22 4.65 6.21 2.47
query23 18.29 1.47 1.37
query24 2.11 0.22 0.23
query25 0.15 0.08 0.09
query26 0.27 0.18 0.17
query27 0.09 0.07 0.08
query28 13.24 1.01 0.99
query29 12.63 3.24 3.20
query30 0.26 0.07 0.06
query31 2.85 0.40 0.37
query32 3.27 0.46 0.47
query33 2.85 2.86 2.95
query34 17.09 4.62 4.70
query35 4.75 4.60 4.48
query36 0.66 0.47 0.46
query37 0.18 0.15 0.15
query38 0.15 0.14 0.15
query39 0.04 0.03 0.03
query40 0.16 0.14 0.14
query41 0.09 0.05 0.05
query42 0.06 0.05 0.04
query43 0.04 0.04 0.03
Total cold run time: 109.94 s
Total hot run time: 31.26 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](alter) Remove rebuildAlterJob [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36196:
URL: https://github.com/apache/doris/pull/36196#issuecomment-2162751470
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](alter) Remove rebuildAlterJob [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter commented on PR #36196:
URL: https://github.com/apache/doris/pull/36196#issuecomment-2162741838
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](alter) Remove rebuildAlterJob [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #36196:
URL: https://github.com/apache/doris/pull/36196
--
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