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