You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "csun5285 (via GitHub)" <gi...@apache.org> on 2026/01/23 06:32:19 UTC
[PR] [fix](array)array sorting function supports multidimensional arrays. [doris]
csun5285 opened a new pull request, #60173:
URL: https://github.com/apache/doris/pull/60173
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### 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] [fix](array)array sorting function supports multidimensional arrays [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60173:
URL: https://github.com/apache/doris/pull/60173#issuecomment-3789302104
# FE Regression Coverage Report
Increment line coverage ` 52.38% (11/21)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60173_3f197f4473200e789cb18cfb0791ce700e1b10bd_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60173_3f197f4473200e789cb18cfb0791ce700e1b10bd_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] [fix](array)array sorting function supports multidimensional arrays [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60173:
URL: https://github.com/apache/doris/pull/60173#issuecomment-3788971755
# FE UT Coverage Report
Increment line coverage ` 0.00% (0/21)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60173_3f197f4473200e789cb18cfb0791ce700e1b10bd/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60173_3f197f4473200e789cb18cfb0791ce700e1b10bd/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] [fix](array)array sorting function supports multidimensional arrays [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60173:
URL: https://github.com/apache/doris/pull/60173#issuecomment-3789822846
# FE Regression Coverage Report
Increment line coverage ` 52.38% (11/21)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60173_3f197f4473200e789cb18cfb0791ce700e1b10bd_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60173_3f197f4473200e789cb18cfb0791ce700e1b10bd_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] [fix](array)array sorting function supports multidimensional arrays. [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60173:
URL: https://github.com/apache/doris/pull/60173#issuecomment-3788541990
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] [fix](array)array sorting function supports multidimensional arrays [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60173:
URL: https://github.com/apache/doris/pull/60173#issuecomment-3788804494
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](array)array sorting function supports multidimensional arrays. [doris]
Posted by "csun5285 (via GitHub)" <gi...@apache.org>.
csun5285 commented on PR #60173:
URL: https://github.com/apache/doris/pull/60173#issuecomment-3788542352
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](array)array sorting function supports multidimensional arrays [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60173:
URL: https://github.com/apache/doris/pull/60173#issuecomment-3788804606
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](array)array sorting function supports multidimensional arrays [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60173:
URL: https://github.com/apache/doris/pull/60173#issuecomment-3788711783
<details>
<summary>TPC-H: <b>Total hot run time: 30452 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 3f197f4473200e789cb18cfb0791ce700e1b10bd, data reload: false
------ Round 1 ----------------------------------
q1 17596 4737 4537 4537
q2 1989 310 202 202
q3 10263 1254 714 714
q4 10201 813 305 305
q5 7527 2110 1775 1775
q6 203 173 145 145
q7 852 715 600 600
q8 9282 1361 1063 1063
q9 4891 4556 4440 4440
q10 6763 1638 1286 1286
q11 540 285 281 281
q12 342 378 230 230
q13 17771 3807 3120 3120
q14 240 225 213 213
q15 603 519 527 519
q16 672 638 577 577
q17 646 829 485 485
q18 6563 6488 6319 6319
q19 1115 1006 590 590
q20 385 339 225 225
q21 2614 1948 1910 1910
q22 1063 997 916 916
Total cold run time: 102121 ms
Total hot run time: 30452 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4758 4693 4683 4683
q2 320 396 329 329
q3 2150 2676 2286 2286
q4 1365 1731 1303 1303
q5 4047 4018 4002 4002
q6 213 176 137 137
q7 1945 1826 1744 1744
q8 2740 2607 2422 2422
q9 7479 7325 7164 7164
q10 2657 2855 2392 2392
q11 561 503 484 484
q12 677 788 590 590
q13 3606 4106 3524 3524
q14 301 323 305 305
q15 566 525 521 521
q16 653 691 649 649
q17 1146 1388 1360 1360
q18 7997 7545 7999 7545
q19 964 857 839 839
q20 1971 2085 2088 2085
q21 4924 4480 4188 4188
q22 1065 996 957 957
Total cold run time: 52105 ms
Total hot run time: 49509 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](array)array sorting function supports multidimensional arrays [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60173:
URL: https://github.com/apache/doris/pull/60173#issuecomment-3788743298
<details>
<summary>TPC-DS: <b>Total hot run time: 172304 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 3f197f4473200e789cb18cfb0791ce700e1b10bd, data reload: false
query5 4426 640 480 480
query6 313 222 192 192
query7 4212 448 254 254
query8 343 264 246 246
query9 8751 2873 2868 2868
query10 457 336 282 282
query11 15361 15250 15036 15036
query12 184 120 120 120
query13 1247 458 359 359
query14 6034 3069 2796 2796
query14_1 2752 2738 2715 2715
query15 208 193 176 176
query16 985 479 453 453
query17 1088 668 596 596
query18 2427 433 337 337
query19 189 180 156 156
query20 124 117 116 116
query21 211 134 119 119
query22 3973 4014 3791 3791
query23 15974 15674 15389 15389
query23_1 15362 15415 15385 15385
query24 7140 1554 1166 1166
query24_1 1154 1184 1184 1184
query25 535 463 413 413
query26 1243 271 151 151
query27 2763 437 285 285
query28 4563 2163 2144 2144
query29 795 551 458 458
query30 308 241 206 206
query31 812 633 571 571
query32 102 80 72 72
query33 529 373 316 316
query34 917 893 541 541
query35 720 762 694 694
query36 871 911 820 820
query37 138 113 93 93
query38 2750 2770 2684 2684
query39 780 753 726 726
query39_1 727 693 713 693
query40 216 136 121 121
query41 74 71 69 69
query42 100 96 96 96
query43 483 493 414 414
query44 1318 753 768 753
query45 189 194 181 181
query46 833 946 586 586
query47 1379 1371 1407 1371
query48 313 319 252 252
query49 617 441 347 347
query50 675 261 206 206
query51 3762 3751 3734 3734
query52 93 92 81 81
query53 213 226 169 169
query54 293 261 247 247
query55 85 81 78 78
query56 303 285 296 285
query57 1013 993 943 943
query58 275 259 255 255
query59 2095 2220 2217 2217
query60 331 326 313 313
query61 142 150 140 140
query62 396 339 300 300
query63 191 162 155 155
query64 4882 1137 820 820
query65 3871 3764 3764 3764
query66 1457 408 309 309
query67 15662 15696 15468 15468
query68 2410 1074 704 704
query69 405 316 284 284
query70 967 967 904 904
query71 300 291 271 271
query72 5288 3179 2344 2344
query73 613 726 309 309
query74 8749 8747 8480 8480
query75 2279 2333 1912 1912
query76 2264 1059 644 644
query77 360 366 299 299
query78 9773 9799 9170 9170
query79 3032 852 580 580
query80 1756 547 447 447
query81 585 274 234 234
query82 1019 145 115 115
query83 321 261 238 238
query84 262 114 99 99
query85 919 467 418 418
query86 486 298 284 284
query87 2942 2883 2803 2803
query88 3450 2571 2556 2556
query89 302 266 255 255
query90 1883 174 164 164
query91 174 155 157 155
query92 74 72 67 67
query93 1375 1003 646 646
query94 652 321 298 298
query95 589 345 319 319
query96 638 493 227 227
query97 2361 2377 2335 2335
query98 235 206 200 200
query99 578 581 509 509
Total cold run time: 249136 ms
Total hot run time: 172304 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](array)array sorting function supports multidimensional arrays [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60173:
URL: https://github.com/apache/doris/pull/60173#issuecomment-3788758380
<details>
<summary>ClickBench: <b>Total hot run time: 26.8 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 3f197f4473200e789cb18cfb0791ce700e1b10bd, data reload: false
query1 0.05 0.04 0.04
query2 0.09 0.04 0.04
query3 0.25 0.08 0.08
query4 1.61 0.11 0.11
query5 0.29 0.25 0.26
query6 1.14 0.66 0.65
query7 0.03 0.03 0.03
query8 0.06 0.04 0.04
query9 0.57 0.50 0.49
query10 0.55 0.55 0.55
query11 0.14 0.10 0.09
query12 0.14 0.11 0.11
query13 0.62 0.59 0.59
query14 0.95 0.94 0.94
query15 0.79 0.77 0.79
query16 0.43 0.42 0.39
query17 1.03 1.05 1.07
query18 0.22 0.21 0.21
query19 2.01 1.88 1.85
query20 0.02 0.02 0.01
query21 15.43 0.27 0.14
query22 5.09 0.05 0.04
query23 15.91 0.28 0.10
query24 1.29 0.29 0.55
query25 0.06 0.08 0.10
query26 0.15 0.13 0.14
query27 0.12 0.05 0.05
query28 4.63 1.08 0.88
query29 12.61 3.86 3.13
query30 0.27 0.14 0.12
query31 2.82 0.61 0.40
query32 3.24 0.56 0.45
query33 2.94 3.08 3.00
query34 16.05 5.23 4.43
query35 4.44 4.43 4.43
query36 0.65 0.50 0.50
query37 0.10 0.07 0.07
query38 0.08 0.04 0.04
query39 0.04 0.03 0.04
query40 0.17 0.15 0.12
query41 0.08 0.03 0.03
query42 0.04 0.02 0.02
query43 0.05 0.04 0.03
Total cold run time: 97.25 s
Total hot run time: 26.8 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](array)array sorting function supports multidimensional arrays [doris]
Posted by "eldenmoon (via GitHub)" <gi...@apache.org>.
eldenmoon merged PR #60173:
URL: https://github.com/apache/doris/pull/60173
--
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