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