You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "cambyzju (via GitHub)" <gi...@apache.org> on 2026/01/18 14:26:43 UTC
[PR] [opt](fe) opt the performance for setColumnPositionMapping [doris]
cambyzju opened a new pull request, #60003:
URL: https://github.com/apache/doris/pull/60003
### What problem does this PR solve?
When there are large of columns(such as 3W columns) in table, setColumnPositionMapping function will be the main performance bottleneck.
this pr opt it from $O(N \times M)$ to $O(N + M)$
<img width="1527" height="858" alt="Clipboard_Screenshot_1768746220" src="https://github.com/user-attachments/assets/46ed6544-1dac-4157-b8fd-4ccb5cca60e9" />
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766173771
run external
--
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #60003:
URL: https://github.com/apache/doris/pull/60003
--
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3767403172
# FE Regression Coverage Report
Increment line coverage ` 83.33% (5/6)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60003_7f4c976b92545a9ee0dd8ac7eebbc6ba6c76241e_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60003_7f4c976b92545a9ee0dd8ac7eebbc6ba6c76241e_merge_fe/report/index.html)
--
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3765382361
<details>
<summary>TPC-DS: <b>Total hot run time: 174521 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 1966db5712fb95c0ef33e078b40188d279ff6ea2, data reload: false
query5 5014 610 489 489
query6 331 221 215 215
query7 4221 452 269 269
query8 328 242 233 233
query9 8751 2890 2907 2890
query10 556 376 314 314
query11 15358 15298 14915 14915
query12 188 111 114 111
query13 1239 502 381 381
query14 6481 3036 2832 2832
query14_1 2691 2636 2705 2636
query15 221 194 174 174
query16 1009 488 484 484
query17 1059 658 566 566
query18 2703 430 343 343
query19 227 217 201 201
query20 126 116 115 115
query21 221 140 119 119
query22 4235 4056 4230 4056
query23 16075 15671 15337 15337
query23_1 15562 15596 15421 15421
query24 7124 1578 1169 1169
query24_1 1178 1194 1191 1191
query25 544 452 430 430
query26 1245 264 151 151
query27 2744 443 278 278
query28 4566 2190 2191 2190
query29 748 516 409 409
query30 309 237 205 205
query31 819 628 577 577
query32 79 74 69 69
query33 533 346 310 310
query34 911 879 529 529
query35 727 748 678 678
query36 878 914 835 835
query37 133 100 84 84
query38 2700 2721 2666 2666
query39 770 745 736 736
query39_1 744 717 703 703
query40 208 134 118 118
query41 67 62 65 62
query42 111 105 103 103
query43 440 428 414 414
query44 1320 750 746 746
query45 182 184 180 180
query46 818 934 566 566
query47 1430 1483 1333 1333
query48 323 318 247 247
query49 607 453 351 351
query50 627 283 208 208
query51 3892 3790 3867 3790
query52 101 105 94 94
query53 285 324 279 279
query54 287 265 259 259
query55 80 78 78 78
query56 305 291 311 291
query57 1051 962 888 888
query58 268 257 269 257
query59 1992 2117 1968 1968
query60 337 338 317 317
query61 150 146 146 146
query62 380 363 311 311
query63 300 263 267 263
query64 4824 1237 954 954
query65 3843 3837 3775 3775
query66 1388 424 307 307
query67 15639 15557 15396 15396
query68 2430 1095 783 783
query69 424 367 323 323
query70 989 871 917 871
query71 330 312 302 302
query72 5292 3313 3364 3313
query73 617 720 316 316
query74 8821 8825 8658 8658
query75 2763 2835 2471 2471
query76 2304 1058 648 648
query77 367 391 315 315
query78 9772 9993 9159 9159
query79 1077 924 600 600
query80 1465 591 537 537
query81 520 270 232 232
query82 1352 146 112 112
query83 362 250 244 244
query84 250 122 94 94
query85 1020 484 430 430
query86 389 302 289 289
query87 2922 2842 2778 2778
query88 3467 2584 2561 2561
query89 405 344 322 322
query90 1928 173 164 164
query91 166 168 133 133
query92 76 76 73 73
query93 941 891 553 553
query94 617 313 303 303
query95 599 398 320 320
query96 633 504 232 232
query97 2349 2432 2328 2328
query98 212 206 202 202
query99 597 588 545 545
Total cold run time: 249173 ms
Total hot run time: 174521 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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3765387543
<details>
<summary>ClickBench: <b>Total hot run time: 26.89 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 1966db5712fb95c0ef33e078b40188d279ff6ea2, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.04
query3 0.26 0.09 0.09
query4 1.60 0.12 0.11
query5 0.28 0.26 0.26
query6 1.15 0.67 0.66
query7 0.03 0.02 0.02
query8 0.05 0.04 0.04
query9 0.57 0.50 0.50
query10 0.54 0.56 0.56
query11 0.14 0.10 0.10
query12 0.15 0.11 0.12
query13 0.61 0.59 0.59
query14 0.95 0.95 0.93
query15 0.80 0.78 0.78
query16 0.38 0.43 0.39
query17 1.02 1.02 1.04
query18 0.22 0.21 0.21
query19 1.94 1.90 1.84
query20 0.02 0.03 0.01
query21 15.47 0.29 0.15
query22 4.98 0.06 0.05
query23 15.75 0.28 0.10
query24 1.58 0.23 0.25
query25 0.10 0.05 0.05
query26 0.14 0.14 0.14
query27 0.08 0.09 0.08
query28 3.60 1.09 0.88
query29 12.54 3.93 3.18
query30 0.28 0.14 0.12
query31 2.81 0.63 0.40
query32 3.25 0.56 0.47
query33 3.02 3.05 3.03
query34 16.55 5.09 4.46
query35 4.53 4.43 4.47
query36 0.65 0.50 0.48
query37 0.10 0.07 0.06
query38 0.07 0.04 0.03
query39 0.04 0.03 0.02
query40 0.16 0.14 0.13
query41 0.09 0.04 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 96.73 s
Total hot run time: 26.89 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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766106812
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766878875
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766355479
# FE Regression Coverage Report
Increment line coverage ` 83.33% (5/6)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60003_1966db5712fb95c0ef33e078b40188d279ff6ea2_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60003_1966db5712fb95c0ef33e078b40188d279ff6ea2_merge_fe/report/index.html)
--
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766911420
<details>
<summary>ClickBench: <b>Total hot run time: 26.76 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 7f4c976b92545a9ee0dd8ac7eebbc6ba6c76241e, data reload: false
query1 0.05 0.04 0.04
query2 0.10 0.04 0.04
query3 0.26 0.08 0.09
query4 1.63 0.11 0.11
query5 0.27 0.26 0.26
query6 1.14 0.67 0.65
query7 0.03 0.03 0.02
query8 0.06 0.04 0.04
query9 0.58 0.51 0.50
query10 0.55 0.57 0.54
query11 0.15 0.10 0.10
query12 0.15 0.10 0.11
query13 0.60 0.60 0.59
query14 0.95 0.94 0.95
query15 0.79 0.78 0.78
query16 0.40 0.39 0.43
query17 1.01 1.07 1.00
query18 0.22 0.21 0.21
query19 1.97 1.88 1.87
query20 0.02 0.01 0.02
query21 15.64 0.29 0.14
query22 5.99 0.05 0.05
query23 15.99 0.31 0.10
query24 1.54 0.73 0.18
query25 0.10 0.10 0.05
query26 0.14 0.14 0.13
query27 0.05 0.08 0.05
query28 4.58 1.06 0.89
query29 12.60 4.00 3.13
query30 0.28 0.14 0.11
query31 2.81 0.65 0.39
query32 3.25 0.56 0.46
query33 2.99 3.07 3.06
query34 16.08 5.09 4.51
query35 4.47 4.44 4.42
query36 0.65 0.49 0.48
query37 0.10 0.07 0.06
query38 0.07 0.04 0.03
query39 0.05 0.03 0.03
query40 0.17 0.14 0.13
query41 0.09 0.03 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 98.65 s
Total hot run time: 26.76 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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3765352304
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766301959
# FE Regression Coverage Report
Increment line coverage ` 83.33% (5/6)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60003_1966db5712fb95c0ef33e078b40188d279ff6ea2_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60003_1966db5712fb95c0ef33e078b40188d279ff6ea2_merge_fe/report/index.html)
--
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3765372464
<details>
<summary>TPC-H: <b>Total hot run time: 32032 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 1966db5712fb95c0ef33e078b40188d279ff6ea2, data reload: false
------ Round 1 ----------------------------------
q1 17631 4278 4042 4042
q2 2041 364 255 255
q3 10133 1280 710 710
q4 10206 811 305 305
q5 7543 2061 1820 1820
q6 188 170 137 137
q7 897 775 667 667
q8 9292 1393 1228 1228
q9 4893 4559 4667 4559
q10 6718 1782 1403 1403
q11 533 298 266 266
q12 696 740 566 566
q13 17791 3807 3112 3112
q14 295 298 272 272
q15 586 503 507 503
q16 680 700 629 629
q17 650 792 487 487
q18 6617 6496 6715 6496
q19 1362 1099 678 678
q20 443 393 252 252
q21 3214 2595 2623 2595
q22 1165 1110 1050 1050
Total cold run time: 103574 ms
Total hot run time: 32032 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4440 4264 4358 4264
q2 339 430 340 340
q3 2296 2856 2465 2465
q4 1506 1899 1493 1493
q5 4532 4325 4270 4270
q6 211 169 130 130
q7 2027 2028 1705 1705
q8 2769 2378 2370 2370
q9 7324 7419 7138 7138
q10 2478 2681 2271 2271
q11 534 475 454 454
q12 681 741 611 611
q13 3609 4010 3100 3100
q14 276 281 254 254
q15 519 489 481 481
q16 614 648 610 610
q17 1091 1228 1306 1228
q18 7532 7331 7209 7209
q19 840 787 795 787
q20 1880 2017 1792 1792
q21 4537 4238 4108 4108
q22 1063 1031 1000 1000
Total cold run time: 51098 ms
Total hot run time: 48080 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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766861391
<details>
<summary>TPC-H: <b>Total hot run time: 31305 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 7f4c976b92545a9ee0dd8ac7eebbc6ba6c76241e, data reload: false
------ Round 1 ----------------------------------
q1 17648 4187 4061 4061
q2 2035 346 237 237
q3 10154 1259 718 718
q4 10192 789 303 303
q5 7538 2029 1861 1861
q6 191 171 135 135
q7 944 760 650 650
q8 9295 1361 1154 1154
q9 4925 4663 4529 4529
q10 6743 1810 1378 1378
q11 547 311 293 293
q12 701 745 594 594
q13 17772 3862 3087 3087
q14 306 303 278 278
q15 574 498 505 498
q16 685 674 646 646
q17 647 799 496 496
q18 6583 6510 6373 6373
q19 1098 969 636 636
q20 398 362 248 248
q21 3004 2416 2180 2180
q22 1031 986 950 950
Total cold run time: 103011 ms
Total hot run time: 31305 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4077 4008 4061 4008
q2 347 395 312 312
q3 2114 2598 2239 2239
q4 1325 1745 1329 1329
q5 4105 3942 4080 3942
q6 206 169 126 126
q7 1861 1827 1669 1669
q8 2802 2538 2452 2452
q9 7189 7228 7284 7228
q10 2507 2938 2351 2351
q11 562 487 458 458
q12 707 764 665 665
q13 3821 4116 3346 3346
q14 299 316 292 292
q15 639 561 515 515
q16 628 681 652 652
q17 1141 1342 1393 1342
q18 8075 7528 7882 7528
q19 861 812 849 812
q20 2077 2117 1956 1956
q21 4829 4461 4268 4268
q22 1168 1098 1038 1038
Total cold run time: 51340 ms
Total hot run time: 48528 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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766878750
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766173581
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766739260
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3765351946
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).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3765418305
# FE UT Coverage Report
Increment line coverage ` 0.00% (0/6)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60003_1966db5712fb95c0ef33e078b40188d279ff6ea2/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60003_1966db5712fb95c0ef33e078b40188d279ff6ea2/fe_report/index.html)
--
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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766895052
<details>
<summary>TPC-DS: <b>Total hot run time: 174991 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 7f4c976b92545a9ee0dd8ac7eebbc6ba6c76241e, data reload: false
query5 4398 636 514 514
query6 335 235 211 211
query7 4216 447 271 271
query8 331 248 242 242
query9 8743 2927 2885 2885
query10 520 378 327 327
query11 15343 15331 15941 15331
query12 184 132 120 120
query13 1293 553 442 442
query14 6043 3141 2950 2950
query14_1 2799 2848 2714 2714
query15 210 204 183 183
query16 1079 511 515 511
query17 1106 750 614 614
query18 2490 443 342 342
query19 227 222 204 204
query20 120 113 117 113
query21 204 132 111 111
query22 3810 4270 3934 3934
query23 16168 15496 15213 15213
query23_1 15496 15358 15545 15358
query24 7119 1539 1178 1178
query24_1 1168 1173 1163 1163
query25 554 458 403 403
query26 1244 260 154 154
query27 2755 441 281 281
query28 4522 2193 2225 2193
query29 753 505 411 411
query30 298 234 207 207
query31 808 646 549 549
query32 79 72 71 71
query33 515 338 308 308
query34 917 859 528 528
query35 715 751 676 676
query36 892 887 796 796
query37 123 96 79 79
query38 2730 2841 2719 2719
query39 775 752 746 746
query39_1 705 713 711 711
query40 218 131 118 118
query41 63 60 60 60
query42 101 100 104 100
query43 485 440 407 407
query44 1324 734 731 731
query45 187 176 178 176
query46 823 954 561 561
query47 1437 1484 1307 1307
query48 318 321 263 263
query49 596 442 341 341
query50 615 272 215 215
query51 3766 3820 3772 3772
query52 104 107 95 95
query53 304 320 273 273
query54 298 276 271 271
query55 86 82 78 78
query56 305 305 316 305
query57 1017 1013 945 945
query58 269 259 258 258
query59 2101 2128 2168 2128
query60 372 334 322 322
query61 154 143 149 143
query62 380 356 301 301
query63 298 260 263 260
query64 4922 1252 987 987
query65 3828 3696 3727 3696
query66 1451 434 305 305
query67 15517 15525 15544 15525
query68 2384 1102 773 773
query69 448 379 344 344
query70 1023 967 961 961
query71 349 323 300 300
query72 5308 3242 3224 3224
query73 598 726 319 319
query74 8753 8671 8661 8661
query75 2741 2782 2484 2484
query76 2260 1052 678 678
query77 369 390 304 304
query78 9702 9981 9101 9101
query79 1407 902 593 593
query80 1291 572 485 485
query81 543 265 233 233
query82 965 160 110 110
query83 329 255 241 241
query84 254 121 90 90
query85 909 486 443 443
query86 414 293 301 293
query87 2833 2831 2748 2748
query88 3527 2619 2568 2568
query89 400 350 323 323
query90 2017 170 163 163
query91 165 162 136 136
query92 76 75 75 75
query93 1095 892 551 551
query94 637 347 285 285
query95 585 332 320 320
query96 647 515 230 230
query97 2353 2390 2301 2301
query98 229 199 195 195
query99 590 575 498 498
Total cold run time: 247471 ms
Total hot run time: 174991 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] [opt](fe) opt the performance for setColumnPositionMapping [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60003:
URL: https://github.com/apache/doris/pull/60003#issuecomment-3766976842
# FE UT Coverage Report
Increment line coverage ` 0.00% (0/6)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60003_7f4c976b92545a9ee0dd8ac7eebbc6ba6c76241e/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60003_7f4c976b92545a9ee0dd8ac7eebbc6ba6c76241e/fe_report/index.html)
--
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