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/12/04 13:05:35 UTC
[PR] [Bug](materialized-view) fix create mv failed on unique table [doris]
BiteTheDDDDt opened a new pull request, #27971:
URL: https://github.com/apache/doris/pull/27971
## Proposed changes
fix create mv failed on unique table
## 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](materialized-view) fix create mv failed on unique table [doris]
Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt merged PR #27971:
URL: https://github.com/apache/doris/pull/27971
--
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](materialized-view) fix create mv failed on unique table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27971:
URL: https://github.com/apache/doris/pull/27971#issuecomment-1840054144
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 44.03 seconds
stream load tsv: 564 seconds loaded 74807831229 Bytes, about 126 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.5 seconds inserted 10000000 Rows, about 350K ops/s
storage size: 17163624322 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](materialized-view) fix create mv failed on unique table [doris]
Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt commented on PR #27971:
URL: https://github.com/apache/doris/pull/27971#issuecomment-1838603130
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](materialized-view) fix create mv failed on unique table [doris]
Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt commented on PR #27971:
URL: https://github.com/apache/doris/pull/27971#issuecomment-1839945901
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](materialized-view) fix create mv failed on unique table [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27971:
URL: https://github.com/apache/doris/pull/27971#issuecomment-1840085864
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](materialized-view) fix create mv failed on unique table [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27971:
URL: https://github.com/apache/doris/pull/27971#issuecomment-1840085791
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](materialized-view) fix create mv failed on unique table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27971:
URL: https://github.com/apache/doris/pull/27971#issuecomment-1840097130
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 72cdbe4e188742185418c3c95038707eb6a1e969, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4885 4679 4734 4679
q2 361 153 158 153
q3 1502 1305 1320 1305
q4 1152 940 952 940
q5 3221 3236 3227 3227
q6 253 131 131 131
q7 1004 517 561 517
q8 2247 2245 2227 2227
q9 6863 6880 6859 6859
q10 3278 3338 3332 3332
q11 327 207 216 207
q12 364 211 213 211
q13 4650 3863 3847 3847
q14 247 220 220 220
q15 595 539 532 532
q16 458 394 386 386
q17 1028 645 620 620
q18 8045 7433 7333 7333
q19 1545 1561 1566 1561
q20 592 336 290 290
q21 3413 2981 2983 2981
q22 378 303 312 303
Total cold run time: 46408 ms
Total hot run time: 41861 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4643 4642 4629 4629
q2 309 183 212 183
q3 3734 3705 3720 3705
q4 2548 2545 2532 2532
q5 6120 6108 6137 6108
q6 240 124 126 124
q7 2621 1958 1955 1955
q8 3737 3754 3727 3727
q9 9415 9388 9367 9367
q10 4036 4119 4104 4104
q11 625 482 522 482
q12 828 663 631 631
q13 4385 3651 3618 3618
q14 279 242 241 241
q15 592 538 537 537
q16 538 488 463 463
q17 2036 2023 1984 1984
q18 9289 9017 8794 8794
q19 1723 1763 1757 1757
q20 2308 1993 1953 1953
q21 7181 6755 6779 6755
q22 696 590 555 555
Total cold run time: 67883 ms
Total hot run time: 64204 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