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