You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "starocean999 (via GitHub)" <gi...@apache.org> on 2026/01/28 06:50:38 UTC
[PR] [opt](unnest)report user friendly error message when use unnest in subquery [doris]
starocean999 opened a new pull request, #60297:
URL: https://github.com/apache/doris/pull/60297
…
### 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] [opt](unnest)report user friendly error message when use unnest in subquery [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60297:
URL: https://github.com/apache/doris/pull/60297#issuecomment-3810298417
# FE Regression Coverage Report
Increment line coverage ` 83.33% (5/6)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60297_c5b4e564ce0c815e6ffe51d1d30a7e2ad7b7e91a_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60297_c5b4e564ce0c815e6ffe51d1d30a7e2ad7b7e91a_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](unnest)report user friendly error message when use unnest in subquery [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60297:
URL: https://github.com/apache/doris/pull/60297#issuecomment-3809713761
# FE UT Coverage Report
Increment line coverage ` 0.00% (0/6)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60297_c5b4e564ce0c815e6ffe51d1d30a7e2ad7b7e91a/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60297_c5b4e564ce0c815e6ffe51d1d30a7e2ad7b7e91a/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](unnest)report user friendly error message when use unnest in subquery [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60297:
URL: https://github.com/apache/doris/pull/60297#issuecomment-3809562678
<details>
<summary>ClickBench: <b>Total hot run time: 28.54 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 c5b4e564ce0c815e6ffe51d1d30a7e2ad7b7e91a, data reload: false
query1 0.06 0.05 0.05
query2 0.10 0.04 0.05
query3 0.26 0.10 0.09
query4 1.62 0.12 0.11
query5 0.30 0.24 0.25
query6 1.17 0.69 0.67
query7 0.04 0.03 0.03
query8 0.06 0.05 0.05
query9 0.58 0.50 0.49
query10 0.55 0.55 0.54
query11 0.16 0.10 0.10
query12 0.15 0.11 0.11
query13 0.64 0.62 0.62
query14 1.07 1.07 1.07
query15 0.86 0.87 0.88
query16 0.40 0.39 0.40
query17 1.07 1.12 1.14
query18 0.24 0.22 0.22
query19 2.13 2.01 2.00
query20 0.02 0.02 0.02
query21 15.41 0.26 0.15
query22 5.08 0.06 0.05
query23 15.87 0.29 0.11
query24 0.99 0.65 0.33
query25 0.07 0.08 0.09
query26 0.14 0.14 0.13
query27 0.07 0.08 0.05
query28 3.77 1.18 0.97
query29 12.56 3.94 3.19
query30 0.30 0.16 0.14
query31 2.83 0.64 0.39
query32 3.24 0.60 0.51
query33 3.26 3.16 3.38
query34 16.36 5.40 4.78
query35 4.86 4.78 4.79
query36 0.65 0.50 0.49
query37 0.11 0.08 0.07
query38 0.07 0.05 0.04
query39 0.05 0.04 0.03
query40 0.19 0.18 0.16
query41 0.08 0.04 0.03
query42 0.05 0.03 0.03
query43 0.05 0.04 0.04
Total cold run time: 97.54 s
Total hot run time: 28.54 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](unnest)report user friendly error message when use unnest in subquery [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60297:
URL: https://github.com/apache/doris/pull/60297#issuecomment-3809501222
<details>
<summary>TPC-H: <b>Total hot run time: 32065 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 c5b4e564ce0c815e6ffe51d1d30a7e2ad7b7e91a, data reload: false
------ Round 1 ----------------------------------
q1 17627 5232 5050 5050
q2 2021 308 219 219
q3 10217 1265 740 740
q4 10230 895 317 317
q5 7521 2159 1903 1903
q6 194 189 150 150
q7 873 741 596 596
q8 9255 1367 1216 1216
q9 5297 4807 4751 4751
q10 6824 1934 1577 1577
q11 531 275 274 274
q12 327 380 229 229
q13 17799 4067 3254 3254
q14 234 246 218 218
q15 893 832 813 813
q16 683 676 614 614
q17 624 789 499 499
q18 7182 6572 6580 6572
q19 1283 999 620 620
q20 380 349 235 235
q21 2544 2040 1937 1937
q22 349 320 281 281
Total cold run time: 102888 ms
Total hot run time: 32065 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5317 5264 6221 5264
q2 257 331 240 240
q3 2176 2690 2219 2219
q4 1353 1740 1298 1298
q5 4254 4110 4266 4110
q6 217 187 140 140
q7 2344 2056 1863 1863
q8 2613 2425 2384 2384
q9 7646 7562 7582 7562
q10 2803 3000 2741 2741
q11 553 478 468 468
q12 644 714 613 613
q13 3907 4461 3547 3547
q14 324 335 303 303
q15 888 837 807 807
q16 813 742 685 685
q17 1143 1266 1326 1266
q18 8318 7776 8008 7776
q19 833 825 798 798
q20 2292 2130 1996 1996
q21 4860 4242 4047 4047
q22 598 545 520 520
Total cold run time: 54153 ms
Total hot run time: 50647 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](unnest)report user friendly error message when use unnest in subquery [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on PR #60297:
URL: https://github.com/apache/doris/pull/60297#issuecomment-3809325340
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](unnest)report user friendly error message when use unnest in subquery [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60297:
URL: https://github.com/apache/doris/pull/60297#issuecomment-3833651026
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](unnest)report user friendly error message when use unnest in subquery [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60297:
URL: https://github.com/apache/doris/pull/60297#issuecomment-3809396427
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](unnest)report user friendly error message when use unnest in subquery [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60297:
URL: https://github.com/apache/doris/pull/60297#issuecomment-3833650866
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](unnest)report user friendly error message when use unnest in subquery [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 merged PR #60297:
URL: https://github.com/apache/doris/pull/60297
--
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