You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "BiteTheDDDDt (via GitHub)" <gi...@apache.org> on 2023/11/21 10:38:09 UTC

[PR] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

BiteTheDDDDt opened a new pull request, #27360:
URL: https://github.com/apache/doris/pull/27360

   ## Proposed changes
   mysql> SELECT  pk AS C1   FROM table_1000_undef_undef2 AS T1 WHERE `col_bigint_undef_signed` NOT IN (SELECT  `col_bigint_undef_signed2` AS C2   FROM  table_1000_undef_undef2 AS T2  ) OR `col_bigint_undef_signed2` <> 9 ;ERROR 1105 (HY000): errCode = 2, detailMessage = (127.0.0.1)[CANCELLED][INTERNAL_ERROR]input block not contain slot column , column_id=3, block=pk Nullable(Int32) Nullable(size = 95, Int32(size = 95), UInt8(size = 95)),col_bigint_undef_signed2 Nullable(Int64) Nullable(size = 95, Int64(size = 95), UInt8(size = 95)),[Anonymous Column] Nullable(UInt8) Nullable(size = 95, UInt8(size = 95), UInt8(size = 95))
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
   
   


-- 
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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1821998234

   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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1820697119

   TeamCity be ut coverage result:
    Function Coverage: 36.52% (8446/23125) 
    Line Coverage: 28.86% (68662/237940)
    Region Coverage: 27.82% (35512/127643)
    Branch Coverage: 24.58% (18113/73688)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/162b5e34c0ca5bb6bbe1934a50a3eec97dd66df3_162b5e34c0ca5bb6bbe1934a50a3eec97dd66df3/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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1820855052

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 45.06 seconds
    stream load tsv:          579 seconds loaded 74807831229 Bytes, about 123 MB/s
    stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
    stream load orc:          65 seconds loaded 1101869774 Bytes, about 16 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.4 seconds inserted 10000000 Rows, about 352K ops/s
    storage size: 17099448698 Bytes


-- 
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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1820658499

   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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1821989103

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1823770047

   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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1822100219

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit 2fd59c3ac565b2569939871a6ab73875df2ffb1b, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4912	4664	4636	4636
   q2	367	149	158	149
   q3	2026	1926	1895	1895
   q4	1388	1254	1225	1225
   q5	3993	3977	4009	3977
   q6	246	130	128	128
   q7	1415	893	886	886
   q8	2739	2774	2757	2757
   q9	9750	9586	9535	9535
   q10	10229	3545	3540	3540
   q11	376	249	237	237
   q12	440	285	287	285
   q13	4553	3815	3797	3797
   q14	320	292	286	286
   q15	595	526	527	526
   q16	669	582	589	582
   q17	1140	959	928	928
   q18	7783	7391	7468	7391
   q19	1675	1680	1683	1680
   q20	568	311	313	311
   q21	4371	3922	3949	3922
   q22	481	374	375	374
   Total cold run time: 60036 ms
   Total hot run time: 49047 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4595	4571	4576	4571
   q2	336	217	269	217
   q3	4023	4005	3988	3988
   q4	2708	2683	2682	2682
   q5	9665	9614	9538	9538
   q6	237	123	120	120
   q7	3007	2515	2502	2502
   q8	4445	4451	4482	4451
   q9	13184	13100	13125	13100
   q10	4117	4194	4205	4194
   q11	852	659	671	659
   q12	994	814	808	808
   q13	4289	3572	3554	3554
   q14	382	354	344	344
   q15	588	527	514	514
   q16	738	659	676	659
   q17	3919	3932	3934	3932
   q18	9631	9158	8896	8896
   q19	1819	1780	1760	1760
   q20	2375	2089	2062	2062
   q21	8769	8460	8637	8460
   q22	898	810	810	810
   Total cold run time: 81571 ms
   Total hot run time: 77821 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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1822107214

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 44.64 seconds
    stream load tsv:          580 seconds loaded 74807831229 Bytes, about 123 MB/s
    stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
    stream load orc:          65 seconds loaded 1101869774 Bytes, about 16 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.6 seconds inserted 10000000 Rows, about 349K ops/s
    storage size: 17103231373 Bytes


-- 
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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1822052225

   TeamCity be ut coverage result:
    Function Coverage: 36.53% (8447/23125) 
    Line Coverage: 28.86% (68676/237996)
    Region Coverage: 27.81% (35511/127670)
    Branch Coverage: 24.57% (18112/73708)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/2fd59c3ac565b2569939871a6ab73875df2ffb1b_2fd59c3ac565b2569939871a6ab73875df2ffb1b/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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1820838094

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit 162b5e34c0ca5bb6bbe1934a50a3eec97dd66df3, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4935	4698	4639	4639
   q2	360	156	161	156
   q3	2064	1899	1866	1866
   q4	1379	1240	1235	1235
   q5	3968	3967	4025	3967
   q6	247	126	128	126
   q7	1440	888	893	888
   q8	2734	2772	2768	2768
   q9	9664	9612	9488	9488
   q10	3490	3558	3557	3557
   q11	376	254	250	250
   q12	442	294	301	294
   q13	4576	3832	3775	3775
   q14	327	281	290	281
   q15	588	523	527	523
   q16	670	595	584	584
   q17	1133	941	885	885
   q18	7786	7341	7259	7259
   q19	1658	1675	1675	1675
   q20	570	297	301	297
   q21	4363	3967	3948	3948
   q22	477	368	378	368
   Total cold run time: 53247 ms
   Total hot run time: 48829 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4579	4584	4584	4584
   q2	337	234	253	234
   q3	4003	3989	3983	3983
   q4	2710	2693	2689	2689
   q5	9640	9578	9605	9578
   q6	237	120	122	120
   q7	3018	2497	2455	2455
   q8	4415	4446	4456	4446
   q9	13214	13125	13132	13125
   q10	4104	4204	4185	4185
   q11	792	660	675	660
   q12	967	823	825	823
   q13	4275	3554	3618	3554
   q14	382	340	336	336
   q15	593	515	525	515
   q16	734	682	693	682
   q17	3925	3851	3866	3851
   q18	9490	9132	9118	9118
   q19	1795	1757	1763	1757
   q20	2399	2069	2051	2051
   q21	8781	8644	8839	8644
   q22	864	829	862	829
   Total cold run time: 81254 ms
   Total hot run time: 78219 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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1821984971

   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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1823770065

   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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt merged PR #27360:
URL: https://github.com/apache/doris/pull/27360


-- 
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] [Bug](mark-join)fix mark join report error when probe block have column do not output [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27360:
URL: https://github.com/apache/doris/pull/27360#issuecomment-1820667282

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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