You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Yukang-Lian (via GitHub)" <gi...@apache.org> on 2024/10/23 09:28:19 UTC
[PR] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Yukang-Lian opened a new pull request, #42331:
URL: https://github.com/apache/doris/pull/42331
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
--
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2432169410
<details>
<summary>ClickBench: <b>Total hot run time: 32.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 1a567501972b8170ca31e4adfae96706b3ee3851, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.03 0.02
query3 0.23 0.07 0.07
query4 1.62 0.10 0.10
query5 0.51 0.50 0.51
query6 1.14 0.73 0.73
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.57 0.50 0.51
query10 0.55 0.55 0.55
query11 0.15 0.11 0.14
query12 0.13 0.11 0.11
query13 0.61 0.59 0.59
query14 2.85 2.82 2.68
query15 0.91 0.82 0.81
query16 0.39 0.38 0.40
query17 0.99 1.01 0.99
query18 0.21 0.20 0.20
query19 1.94 1.85 1.98
query20 0.01 0.01 0.00
query21 15.36 0.60 0.60
query22 2.33 1.77 1.69
query23 17.11 0.86 0.68
query24 3.01 0.86 2.20
query25 0.22 0.11 0.10
query26 0.44 0.16 0.13
query27 0.05 0.05 0.05
query28 10.27 1.10 1.07
query29 12.54 3.26 3.24
query30 0.25 0.07 0.08
query31 2.85 0.37 0.37
query32 3.29 0.46 0.44
query33 3.02 3.04 3.01
query34 17.11 4.53 4.46
query35 4.59 4.47 4.52
query36 0.66 0.48 0.49
query37 0.08 0.06 0.05
query38 0.04 0.03 0.04
query39 0.03 0.02 0.02
query40 0.16 0.12 0.12
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.03 0.02
Total cold run time: 106.53 s
Total hot run time: 32.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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2432898992
<details>
<summary>ClickBench: <b>Total hot run time: 32.59 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 0e355fe69801a23655a89abd8ba711c1e0d504a0, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.03 0.03
query3 0.24 0.07 0.06
query4 1.64 0.10 0.10
query5 0.51 0.52 0.49
query6 1.13 0.73 0.73
query7 0.02 0.02 0.01
query8 0.04 0.03 0.03
query9 0.56 0.50 0.51
query10 0.55 0.57 0.54
query11 0.15 0.12 0.11
query12 0.14 0.10 0.11
query13 0.61 0.60 0.59
query14 2.85 2.73 2.71
query15 0.89 0.83 0.83
query16 0.40 0.40 0.38
query17 0.99 1.00 1.05
query18 0.20 0.20 0.21
query19 1.92 1.85 2.02
query20 0.01 0.00 0.01
query21 15.36 0.62 0.59
query22 2.56 2.45 1.63
query23 16.92 1.18 0.83
query24 2.96 0.95 0.99
query25 0.22 0.07 0.07
query26 0.52 0.14 0.14
query27 0.04 0.04 0.03
query28 10.85 1.08 1.08
query29 12.58 3.27 3.27
query30 0.24 0.07 0.06
query31 2.88 0.39 0.38
query32 3.25 0.46 0.46
query33 3.03 3.01 3.05
query34 16.90 4.50 4.52
query35 4.55 4.54 4.52
query36 0.65 0.50 0.48
query37 0.09 0.06 0.06
query38 0.04 0.03 0.04
query39 0.03 0.02 0.03
query40 0.16 0.12 0.13
query41 0.07 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.03 0.03
Total cold run time: 106.9 s
Total hot run time: 32.59 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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2434250617
<details>
<summary>TPC-DS: <b>Total hot run time: 192494 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 30c85ece8177da2462a6a10f0e693f2192b68db7, data reload: false
query1 878 388 403 388
query2 6249 2118 2104 2104
query3 8678 197 204 197
query4 35329 23797 23536 23536
query5 4849 485 450 450
query6 276 185 171 171
query7 4195 298 293 293
query8 290 238 244 238
query9 9359 2660 2658 2658
query10 501 284 271 271
query11 18105 15364 15364 15364
query12 153 103 102 102
query13 1556 443 400 400
query14 9682 7036 7159 7036
query15 226 169 174 169
query16 7768 478 516 478
query17 1476 584 593 584
query18 2028 304 308 304
query19 241 165 162 162
query20 128 118 120 118
query21 217 107 110 107
query22 4921 4753 4485 4485
query23 34855 34145 34217 34145
query24 10672 2794 2766 2766
query25 597 412 407 407
query26 729 162 160 160
query27 2077 282 291 282
query28 6512 2432 2402 2402
query29 744 439 423 423
query30 266 160 165 160
query31 1067 805 817 805
query32 102 55 56 55
query33 666 303 312 303
query34 918 517 519 517
query35 1043 869 911 869
query36 1107 943 978 943
query37 153 91 91 91
query38 4497 4294 4240 4240
query39 1511 1439 1413 1413
query40 206 99 101 99
query41 50 46 48 46
query42 118 101 101 101
query43 569 499 506 499
query44 1166 818 796 796
query45 202 164 163 163
query46 1135 692 719 692
query47 1938 1862 1857 1857
query48 424 324 323 323
query49 922 431 432 431
query50 815 394 402 394
query51 7198 6961 6955 6955
query52 103 93 88 88
query53 254 181 183 181
query54 1017 426 427 426
query55 80 79 78 78
query56 275 288 253 253
query57 1313 1162 1181 1162
query58 218 224 230 224
query59 3193 3143 3038 3038
query60 311 268 267 267
query61 109 107 126 107
query62 862 666 675 666
query63 218 192 183 183
query64 3683 649 646 646
query65 3282 3203 3161 3161
query66 820 308 323 308
query67 15816 15581 15689 15581
query68 4535 565 533 533
query69 493 292 289 289
query70 1213 1176 1130 1130
query71 357 281 282 281
query72 7411 3960 3966 3960
query73 773 350 368 350
query74 10392 9059 9114 9059
query75 3674 2689 2701 2689
query76 2719 905 1011 905
query77 634 303 293 293
query78 10614 9629 9577 9577
query79 3068 605 614 605
query80 1192 436 480 436
query81 597 245 241 241
query82 700 140 137 137
query83 339 142 135 135
query84 289 72 68 68
query85 956 315 290 290
query86 335 293 303 293
query87 4977 4656 4586 4586
query88 3981 2196 2178 2178
query89 415 288 286 286
query90 1862 187 184 184
query91 139 102 101 101
query92 57 47 48 47
query93 1737 542 536 536
query94 771 302 301 301
query95 348 245 253 245
query96 609 279 281 279
query97 2831 2674 2731 2674
query98 213 208 193 193
query99 1584 1292 1306 1292
Total cold run time: 300733 ms
Total hot run time: 192494 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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2432776011
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #42331:
URL: https://github.com/apache/doris/pull/42331
--
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2432888373
<details>
<summary>TPC-DS: <b>Total hot run time: 192944 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 0e355fe69801a23655a89abd8ba711c1e0d504a0, data reload: false
query1 920 396 412 396
query2 6242 2167 2067 2067
query3 8687 208 214 208
query4 34414 23665 23665 23665
query5 3560 476 470 470
query6 279 173 163 163
query7 4208 301 289 289
query8 291 227 235 227
query9 9237 2751 2750 2750
query10 455 282 284 282
query11 17957 15430 15253 15253
query12 154 105 99 99
query13 1563 430 416 416
query14 9887 7507 7663 7507
query15 258 178 189 178
query16 8023 482 522 482
query17 1646 600 586 586
query18 2207 340 334 334
query19 370 159 166 159
query20 129 115 116 115
query21 221 109 112 109
query22 4844 4744 4626 4626
query23 35023 33981 34310 33981
query24 11051 2799 2829 2799
query25 633 420 405 405
query26 1124 166 164 164
query27 2582 284 289 284
query28 7751 2439 2459 2439
query29 842 429 425 425
query30 264 158 156 156
query31 1023 803 827 803
query32 101 56 58 56
query33 765 324 308 308
query34 941 530 521 521
query35 897 775 739 739
query36 1116 949 963 949
query37 152 92 93 92
query38 4011 3905 4055 3905
query39 1468 1439 1400 1400
query40 212 100 101 100
query41 50 47 47 47
query42 124 99 101 99
query43 545 497 513 497
query44 1276 820 813 813
query45 199 167 168 167
query46 1132 708 742 708
query47 1929 1801 1818 1801
query48 441 327 329 327
query49 933 432 429 429
query50 815 393 397 393
query51 6983 6984 7031 6984
query52 104 89 95 89
query53 264 187 186 186
query54 1133 426 429 426
query55 85 78 76 76
query56 291 278 287 278
query57 1298 1155 1165 1155
query58 235 223 236 223
query59 3266 3276 3186 3186
query60 283 267 263 263
query61 109 102 102 102
query62 863 681 677 677
query63 227 194 187 187
query64 3969 645 615 615
query65 3289 3172 3243 3172
query66 835 304 305 304
query67 16071 15797 15560 15560
query68 4459 590 564 564
query69 459 297 291 291
query70 1204 1103 1170 1103
query71 343 284 282 282
query72 7194 4016 3886 3886
query73 779 354 353 353
query74 10243 9048 9082 9048
query75 3397 2624 2694 2624
query76 2725 858 902 858
query77 599 315 303 303
query78 10527 9683 9589 9589
query79 2180 604 608 604
query80 1123 457 462 457
query81 568 247 238 238
query82 739 147 143 143
query83 291 136 134 134
query84 279 73 72 72
query85 1192 294 279 279
query86 319 288 302 288
query87 4489 4381 4456 4381
query88 3757 2195 2163 2163
query89 410 289 293 289
query90 2075 191 191 191
query91 146 101 102 101
query92 68 49 50 49
query93 1128 531 539 531
query94 918 308 291 291
query95 348 247 248 247
query96 603 283 280 280
query97 3271 3130 3142 3130
query98 228 202 194 194
query99 1578 1316 1310 1310
Total cold run time: 299896 ms
Total hot run time: 192944 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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2432937198
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2432114930
<details>
<summary>TPC-H: <b>Total hot run time: 41380 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 1a567501972b8170ca31e4adfae96706b3ee3851, data reload: false
------ Round 1 ----------------------------------
q1 17613 7490 7304 7304
q2 2044 151 154 151
q3 10579 1156 1116 1116
q4 10223 821 837 821
q5 7729 3145 3114 3114
q6 235 150 149 149
q7 1032 609 602 602
q8 9591 1994 2009 1994
q9 7799 6488 6444 6444
q10 7104 2408 2459 2408
q11 446 249 244 244
q12 515 222 215 215
q13 17766 2969 3005 2969
q14 247 212 211 211
q15 582 523 533 523
q16 651 585 595 585
q17 997 522 545 522
q18 7512 6717 6783 6717
q19 1350 1000 1062 1000
q20 501 186 185 185
q21 3991 3099 3127 3099
q22 1121 1007 1034 1007
Total cold run time: 109628 ms
Total hot run time: 41380 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7295 7274 7262 7262
q2 339 248 224 224
q3 2963 2826 2832 2826
q4 1962 1799 1770 1770
q5 5486 5501 5563 5501
q6 230 147 142 142
q7 2116 1688 1761 1688
q8 3258 3422 3423 3422
q9 8648 8622 8668 8622
q10 3511 3449 3433 3433
q11 582 488 481 481
q12 826 574 558 558
q13 10943 2993 3042 2993
q14 310 259 258 258
q15 555 517 524 517
q16 694 646 632 632
q17 1849 1593 1552 1552
q18 7864 7662 7511 7511
q19 1666 1411 1415 1411
q20 2046 1828 1815 1815
q21 5496 5213 5200 5200
q22 1144 1046 1006 1006
Total cold run time: 69783 ms
Total hot run time: 58824 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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2434121637
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2434392109
run p0
--
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2431468279
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2432037883
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2434326053
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2433057315
<details>
<summary>TPC-DS: <b>Total hot run time: 192558 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 07a3687c9592c779271d0e2e8d345f96bff72ba2, data reload: false
query1 894 401 401 401
query2 6259 2123 2075 2075
query3 8683 204 216 204
query4 34386 23729 23691 23691
query5 3552 473 475 473
query6 275 172 190 172
query7 4190 286 285 285
query8 286 232 239 232
query9 9418 2722 2716 2716
query10 442 289 271 271
query11 18197 15273 15192 15192
query12 145 105 97 97
query13 1557 449 402 402
query14 9594 7124 7067 7067
query15 231 180 185 180
query16 7767 451 475 451
query17 1653 629 596 596
query18 1990 319 323 319
query19 248 163 159 159
query20 126 109 115 109
query21 217 107 109 107
query22 4782 4741 4549 4549
query23 34973 34286 34211 34211
query24 10903 2774 2746 2746
query25 641 418 399 399
query26 1131 157 174 157
query27 2314 287 286 286
query28 7532 2440 2444 2440
query29 839 436 425 425
query30 269 161 156 156
query31 1074 807 812 807
query32 103 53 56 53
query33 767 297 298 297
query34 938 512 512 512
query35 905 768 769 768
query36 1094 937 983 937
query37 161 90 91 90
query38 4048 3962 3900 3900
query39 1482 1453 1433 1433
query40 212 99 98 98
query41 51 46 53 46
query42 130 100 101 100
query43 533 513 497 497
query44 1228 809 805 805
query45 199 169 169 169
query46 1127 710 702 702
query47 1920 1861 1846 1846
query48 435 329 332 329
query49 950 427 429 427
query50 807 411 403 403
query51 7084 7043 6919 6919
query52 102 90 93 90
query53 262 179 183 179
query54 1258 425 423 423
query55 90 83 77 77
query56 293 303 289 289
query57 1258 1181 1145 1145
query58 234 288 233 233
query59 3181 3187 2983 2983
query60 322 257 268 257
query61 109 104 105 104
query62 879 677 685 677
query63 224 193 182 182
query64 4062 628 624 624
query65 3345 3234 3201 3201
query66 779 305 302 302
query67 16040 15919 15861 15861
query68 4432 550 565 550
query69 493 293 282 282
query70 1215 1174 1130 1130
query71 353 273 280 273
query72 7278 4035 3957 3957
query73 784 353 359 353
query74 10236 9011 9002 9002
query75 3418 2630 2655 2630
query76 3049 960 973 960
query77 581 300 299 299
query78 10582 9643 9532 9532
query79 2064 592 611 592
query80 2610 441 461 441
query81 594 241 243 241
query82 709 140 143 140
query83 297 139 137 137
query84 287 71 71 71
query85 1697 312 289 289
query86 437 302 293 293
query87 4469 4280 4447 4280
query88 2859 2227 2187 2187
query89 403 288 282 282
query90 2106 189 181 181
query91 159 103 104 103
query92 64 51 49 49
query93 1973 539 537 537
query94 1208 309 284 284
query95 352 245 249 245
query96 617 280 278 278
query97 3253 3155 3129 3129
query98 214 202 202 202
query99 1584 1296 1324 1296
Total cold run time: 301557 ms
Total hot run time: 192558 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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2434257394
<details>
<summary>ClickBench: <b>Total hot run time: 33.49 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 30c85ece8177da2462a6a10f0e693f2192b68db7, data reload: false
query1 0.03 0.04 0.03
query2 0.07 0.03 0.03
query3 0.24 0.06 0.06
query4 1.64 0.10 0.10
query5 0.40 0.39 0.41
query6 1.15 0.65 0.65
query7 0.01 0.02 0.01
query8 0.04 0.03 0.03
query9 0.58 0.51 0.51
query10 0.56 0.55 0.56
query11 0.15 0.11 0.11
query12 0.14 0.12 0.11
query13 0.60 0.59 0.59
query14 2.73 2.82 2.76
query15 0.91 0.82 0.82
query16 0.38 0.39 0.39
query17 1.06 1.03 1.03
query18 0.21 0.20 0.19
query19 1.86 1.87 1.92
query20 0.01 0.01 0.01
query21 15.36 0.60 0.60
query22 2.35 2.30 1.91
query23 16.90 1.02 0.91
query24 3.19 1.53 1.77
query25 0.26 0.27 0.09
query26 0.62 0.13 0.14
query27 0.05 0.05 0.04
query28 9.96 1.09 1.08
query29 12.62 3.32 3.28
query30 0.25 0.06 0.06
query31 2.87 0.37 0.38
query32 3.29 0.46 0.46
query33 2.94 3.04 3.03
query34 16.92 4.50 4.52
query35 4.57 4.48 4.54
query36 0.64 0.48 0.48
query37 0.08 0.06 0.06
query38 0.05 0.04 0.03
query39 0.03 0.02 0.02
query40 0.16 0.12 0.12
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.04 0.03 0.03
Total cold run time: 106.03 s
Total hot run time: 33.49 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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2434236906
<details>
<summary>TPC-H: <b>Total hot run time: 41527 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 30c85ece8177da2462a6a10f0e693f2192b68db7, data reload: false
------ Round 1 ----------------------------------
q1 17791 7442 7274 7274
q2 2033 313 294 294
q3 12198 1072 1181 1072
q4 10560 828 840 828
q5 7766 3115 3060 3060
q6 244 149 146 146
q7 1028 624 610 610
q8 9370 1993 2004 1993
q9 6558 6483 6493 6483
q10 7044 2398 2417 2398
q11 445 245 247 245
q12 409 218 219 218
q13 17784 2987 3007 2987
q14 251 220 218 218
q15 573 526 516 516
q16 668 583 593 583
q17 990 495 566 495
q18 7313 6820 6828 6820
q19 1359 1046 1012 1012
q20 483 183 181 181
q21 4004 3093 3271 3093
q22 1099 1023 1001 1001
Total cold run time: 109970 ms
Total hot run time: 41527 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7328 7227 7225 7225
q2 333 242 232 232
q3 3066 3001 2906 2906
q4 2123 1854 1802 1802
q5 6022 5752 5758 5752
q6 232 149 154 149
q7 2290 1870 1819 1819
q8 3388 3605 3418 3418
q9 8963 8992 8874 8874
q10 3623 3551 3603 3551
q11 586 478 476 476
q12 844 667 622 622
q13 8888 3173 3273 3173
q14 319 282 302 282
q15 574 529 530 529
q16 678 654 641 641
q17 1855 1619 1641 1619
q18 8265 7783 7613 7613
q19 1728 1412 1528 1412
q20 2144 1851 1863 1851
q21 5664 5517 5297 5297
q22 1159 1078 1047 1047
Total cold run time: 70072 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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2434326014
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2433033224
<details>
<summary>TPC-H: <b>Total hot run time: 41277 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 07a3687c9592c779271d0e2e8d345f96bff72ba2, data reload: false
------ Round 1 ----------------------------------
q1 17578 7356 7322 7322
q2 2025 276 274 274
q3 12133 1028 1105 1028
q4 10579 858 840 840
q5 7769 3083 3088 3083
q6 236 155 151 151
q7 1039 630 612 612
q8 9349 1937 1958 1937
q9 6576 6457 6453 6453
q10 7036 2433 2449 2433
q11 448 249 251 249
q12 409 226 225 225
q13 17785 3023 3039 3023
q14 247 213 228 213
q15 560 512 512 512
q16 657 603 585 585
q17 973 545 541 541
q18 7264 6722 6619 6619
q19 1344 945 899 899
q20 492 184 179 179
q21 3983 3114 3266 3114
q22 1117 1019 985 985
Total cold run time: 109599 ms
Total hot run time: 41277 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7244 7277 7231 7231
q2 329 228 227 227
q3 3053 2961 2931 2931
q4 2082 1898 1807 1807
q5 5749 5835 5814 5814
q6 231 154 155 154
q7 2200 1877 1825 1825
q8 3389 3559 3414 3414
q9 8968 8999 8948 8948
q10 3568 3552 3567 3552
q11 592 502 492 492
q12 856 640 627 627
q13 9219 3240 3229 3229
q14 321 285 277 277
q15 583 533 533 533
q16 692 660 650 650
q17 1850 1621 1598 1598
q18 8405 7803 7655 7655
q19 1714 1572 1600 1572
q20 2126 1885 1862 1862
q21 5609 5485 5493 5485
q22 1210 1034 1077 1034
Total cold run time: 69990 ms
Total hot run time: 60917 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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2434392616
run cloud_p0
--
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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2432150408
<details>
<summary>TPC-DS: <b>Total hot run time: 191175 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 1a567501972b8170ca31e4adfae96706b3ee3851, data reload: false
query1 972 373 372 372
query2 5818 2136 2116 2116
query3 6178 216 229 216
query4 33455 23477 23530 23477
query5 3806 470 464 464
query6 234 163 170 163
query7 4218 295 297 295
query8 278 224 240 224
query9 7811 2735 2738 2735
query10 432 276 272 272
query11 18084 15167 15206 15167
query12 162 106 99 99
query13 1222 474 418 418
query14 9719 7016 6989 6989
query15 244 167 171 167
query16 7204 457 431 431
query17 1449 566 544 544
query18 1962 301 299 299
query19 294 152 146 146
query20 119 110 108 108
query21 145 107 105 105
query22 4618 4399 4393 4393
query23 35206 34065 34117 34065
query24 7340 2494 2450 2450
query25 625 412 413 412
query26 1043 164 157 157
query27 1975 287 294 287
query28 5168 2469 2436 2436
query29 802 422 422 422
query30 314 155 155 155
query31 1027 823 842 823
query32 95 59 59 59
query33 640 341 310 310
query34 932 526 508 508
query35 929 776 744 744
query36 1106 956 956 956
query37 158 87 91 87
query38 4054 3955 3925 3925
query39 1483 1427 1423 1423
query40 207 100 102 100
query41 51 46 47 46
query42 128 101 94 94
query43 550 498 489 489
query44 1255 836 821 821
query45 197 165 168 165
query46 1135 708 700 700
query47 1963 1816 1860 1816
query48 418 312 321 312
query49 923 440 429 429
query50 809 395 394 394
query51 7204 6960 6926 6926
query52 104 89 90 89
query53 254 182 180 180
query54 934 435 425 425
query55 86 79 77 77
query56 284 275 270 270
query57 1333 1154 1176 1154
query58 244 238 243 238
query59 3182 3201 3260 3201
query60 285 251 262 251
query61 108 100 101 100
query62 869 701 688 688
query63 221 188 180 180
query64 3741 655 591 591
query65 3279 3232 3212 3212
query66 782 309 325 309
query67 16065 15604 15587 15587
query68 3457 563 572 563
query69 631 322 317 317
query70 1218 1144 1157 1144
query71 355 293 273 273
query72 7221 3930 3917 3917
query73 781 356 366 356
query74 9983 9012 8945 8945
query75 3420 2644 2670 2644
query76 2668 816 891 816
query77 689 297 322 297
query78 11609 9764 9257 9257
query79 1160 609 597 597
query80 733 455 454 454
query81 567 236 243 236
query82 359 141 144 141
query83 345 136 133 133
query84 267 78 68 68
query85 748 295 280 280
query86 365 311 312 311
query87 4515 4360 4393 4360
query88 3145 2215 2171 2171
query89 390 287 292 287
query90 1868 188 188 188
query91 152 101 102 101
query92 60 50 48 48
query93 1070 543 534 534
query94 773 275 291 275
query95 341 247 239 239
query96 621 282 277 277
query97 3274 3164 3143 3143
query98 215 214 191 191
query99 1534 1349 1351 1349
Total cold run time: 282466 ms
Total hot run time: 191175 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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2432850593
<details>
<summary>TPC-H: <b>Total hot run time: 41322 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 0e355fe69801a23655a89abd8ba711c1e0d504a0, data reload: false
------ Round 1 ----------------------------------
q1 17584 7508 7336 7336
q2 2035 290 273 273
q3 11980 1034 1172 1034
q4 10580 852 827 827
q5 7744 3074 3086 3074
q6 241 162 162 162
q7 1030 618 601 601
q8 9352 1916 1971 1916
q9 6538 6412 6406 6406
q10 7027 2414 2433 2414
q11 446 252 249 249
q12 411 221 222 221
q13 17793 3056 3030 3030
q14 246 218 222 218
q15 571 509 532 509
q16 633 595 602 595
q17 966 499 556 499
q18 7324 6720 6722 6720
q19 1359 908 1105 908
q20 494 194 190 190
q21 4047 3137 3135 3135
q22 1097 1011 1005 1005
Total cold run time: 109498 ms
Total hot run time: 41322 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7303 7405 7251 7251
q2 327 235 233 233
q3 3102 2998 2979 2979
q4 2107 1844 1871 1844
q5 5822 5745 5778 5745
q6 232 153 151 151
q7 2206 1917 1853 1853
q8 3365 3547 3426 3426
q9 8975 8978 8949 8949
q10 3593 3617 3561 3561
q11 592 495 490 490
q12 849 675 617 617
q13 8978 3220 3185 3185
q14 321 290 273 273
q15 577 530 539 530
q16 689 647 666 647
q17 1860 1660 1607 1607
q18 8278 7903 7497 7497
q19 1766 1445 1427 1427
q20 2136 1892 1874 1874
q21 5671 5398 5443 5398
q22 1113 1068 1030 1030
Total cold run time: 69862 ms
Total hot run time: 60567 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] [Feature](schema change) Support add column bitmap with default value bitmap_empty [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #42331:
URL: https://github.com/apache/doris/pull/42331#issuecomment-2433079593
<details>
<summary>ClickBench: <b>Total hot run time: 33.08 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 07a3687c9592c779271d0e2e8d345f96bff72ba2, data reload: false
query1 0.03 0.03 0.04
query2 0.07 0.03 0.03
query3 0.24 0.07 0.07
query4 1.63 0.10 0.10
query5 0.51 0.50 0.51
query6 1.14 0.72 0.72
query7 0.02 0.01 0.01
query8 0.03 0.03 0.03
query9 0.56 0.50 0.49
query10 0.56 0.54 0.54
query11 0.14 0.11 0.10
query12 0.13 0.11 0.11
query13 0.60 0.60 0.59
query14 2.68 2.71 2.74
query15 0.89 0.82 0.82
query16 0.39 0.38 0.36
query17 1.06 0.98 1.06
query18 0.20 0.20 0.19
query19 1.88 1.88 2.00
query20 0.01 0.02 0.00
query21 15.37 0.61 0.56
query22 2.20 2.34 1.63
query23 17.26 0.86 0.74
query24 2.98 1.68 1.75
query25 0.27 0.27 0.11
query26 0.50 0.14 0.14
query27 0.03 0.03 0.03
query28 9.38 1.11 1.07
query29 12.53 3.27 3.25
query30 0.25 0.07 0.06
query31 2.90 0.38 0.36
query32 3.28 0.46 0.45
query33 3.00 3.03 3.04
query34 17.21 4.50 4.46
query35 4.53 4.48 4.51
query36 0.67 0.47 0.49
query37 0.09 0.06 0.06
query38 0.04 0.03 0.03
query39 0.03 0.03 0.02
query40 0.17 0.13 0.12
query41 0.08 0.02 0.03
query42 0.03 0.02 0.02
query43 0.03 0.03 0.03
Total cold run time: 105.6 s
Total hot run time: 33.08 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