You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zddr (via GitHub)" <gi...@apache.org> on 2024/09/03 07:48:43 UTC

[PR] [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]

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

   The replaced partition version should inherit from the original partition
   
   


-- 
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] [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 192366 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 705345f4aeadb74f056c1e12229854ed1f2ec184, data reload: false
   
   query1	1263	893	869	869
   query2	6335	2070	2024	2024
   query3	10625	4064	3896	3896
   query4	59506	23836	23214	23214
   query5	5387	512	494	494
   query6	407	166	169	166
   query7	5757	300	302	300
   query8	294	202	228	202
   query9	8989	2453	2465	2453
   query10	478	275	258	258
   query11	18085	15102	15228	15102
   query12	161	105	102	102
   query13	1600	392	391	391
   query14	10395	6891	7713	6891
   query15	227	176	190	176
   query16	7667	470	470	470
   query17	1179	583	617	583
   query18	2083	304	300	300
   query19	306	180	144	144
   query20	117	115	108	108
   query21	216	102	106	102
   query22	4477	4679	4618	4618
   query23	34177	33593	33301	33301
   query24	5946	2835	2812	2812
   query25	529	387	380	380
   query26	683	151	148	148
   query27	1825	268	269	268
   query28	3681	2034	2014	2014
   query29	695	401	409	401
   query30	228	151	160	151
   query31	960	761	784	761
   query32	113	56	52	52
   query33	474	277	279	277
   query34	846	497	493	493
   query35	829	765	700	700
   query36	1047	933	931	931
   query37	147	89	85	85
   query38	4004	4016	3928	3928
   query39	1430	1400	1418	1400
   query40	194	111	116	111
   query41	48	44	45	44
   query42	112	96	92	92
   query43	520	476	479	476
   query44	1065	737	725	725
   query45	200	169	167	167
   query46	1096	733	703	703
   query47	1908	1824	1801	1801
   query48	372	292	297	292
   query49	761	424	457	424
   query50	822	415	402	402
   query51	6980	6925	6880	6880
   query52	101	88	90	88
   query53	249	173	177	173
   query54	584	454	498	454
   query55	75	75	73	73
   query56	284	251	254	251
   query57	1159	1063	1077	1063
   query58	223	252	248	248
   query59	3069	2782	2730	2730
   query60	288	256	265	256
   query61	102	97	101	97
   query62	731	654	651	651
   query63	216	181	183	181
   query64	2836	671	701	671
   query65	3202	3129	3172	3129
   query66	695	333	334	333
   query67	15346	15167	15373	15167
   query68	2957	582	573	573
   query69	401	284	283	283
   query70	1202	1091	1146	1091
   query71	351	290	276	276
   query72	5122	4106	3974	3974
   query73	743	326	337	326
   query74	9119	8969	8902	8902
   query75	3330	2683	2663	2663
   query76	1335	1060	975	975
   query77	524	320	316	316
   query78	10445	9639	9065	9065
   query79	1030	539	522	522
   query80	688	488	573	488
   query81	472	235	237	235
   query82	255	142	149	142
   query83	173	148	148	148
   query84	261	74	79	74
   query85	683	276	277	276
   query86	295	300	288	288
   query87	4433	4353	4372	4353
   query88	3006	2342	2330	2330
   query89	379	281	287	281
   query90	1952	194	195	194
   query91	125	100	102	100
   query92	62	48	49	48
   query93	1035	519	517	517
   query94	725	294	282	282
   query95	329	255	250	250
   query96	590	274	263	263
   query97	3213	3054	3078	3054
   query98	211	222	196	196
   query99	1527	1336	1234	1234
   Total cold run time: 303379 ms
   Total hot run time: 192366 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] [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37852 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 705345f4aeadb74f056c1e12229854ed1f2ec184, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17622	4394	4297	4297
   q2	2026	186	181	181
   q3	11758	989	1064	989
   q4	10514	754	763	754
   q5	7751	2791	2760	2760
   q6	231	144	142	142
   q7	970	619	587	587
   q8	9333	2083	2040	2040
   q9	7067	6541	6577	6541
   q10	7000	2426	2178	2178
   q11	444	235	238	235
   q12	396	221	219	219
   q13	17774	3056	3106	3056
   q14	277	239	240	239
   q15	515	495	497	495
   q16	584	503	508	503
   q17	984	632	816	632
   q18	7312	6713	6875	6713
   q19	1399	1009	1082	1009
   q20	670	344	329	329
   q21	3899	3036	2962	2962
   q22	1124	991	1033	991
   Total cold run time: 109650 ms
   Total hot run time: 37852 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4355	4345	4317	4317
   q2	393	285	277	277
   q3	2867	2695	2654	2654
   q4	1942	1657	1652	1652
   q5	5638	5659	5711	5659
   q6	232	141	148	141
   q7	2248	1802	1885	1802
   q8	3297	3409	3411	3409
   q9	8847	8890	8846	8846
   q10	3592	3369	3417	3369
   q11	599	504	522	504
   q12	818	646	671	646
   q13	14999	3227	3325	3227
   q14	336	301	292	292
   q15	529	485	494	485
   q16	610	599	589	589
   q17	1824	1533	1536	1533
   q18	8066	7846	7884	7846
   q19	1729	1578	1626	1578
   q20	2157	1906	1945	1906
   q21	5711	5491	5424	5424
   q22	1114	1043	1030	1030
   Total cold run time: 71903 ms
   Total hot run time: 57186 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] [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]

Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr closed pull request #40318: [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2
URL: https://github.com/apache/doris/pull/40318


-- 
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] [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 32.27 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 705345f4aeadb74f056c1e12229854ed1f2ec184, data reload: false
   
   query1	0.04	0.04	0.04
   query2	0.08	0.04	0.04
   query3	0.22	0.06	0.06
   query4	1.65	0.10	0.10
   query5	0.50	0.49	0.50
   query6	1.12	0.73	0.73
   query7	0.02	0.01	0.02
   query8	0.05	0.04	0.04
   query9	0.54	0.48	0.49
   query10	0.54	0.53	0.55
   query11	0.16	0.11	0.11
   query12	0.15	0.12	0.13
   query13	0.62	0.59	0.58
   query14	2.03	2.06	2.06
   query15	0.91	0.83	0.81
   query16	0.39	0.36	0.38
   query17	1.04	1.08	1.04
   query18	0.20	0.21	0.20
   query19	1.94	1.72	1.78
   query20	0.01	0.01	0.01
   query21	15.40	0.66	0.67
   query22	4.15	7.27	2.05
   query23	18.28	1.47	1.38
   query24	2.12	0.24	0.22
   query25	0.15	0.09	0.08
   query26	0.26	0.19	0.18
   query27	0.08	0.08	0.08
   query28	13.30	1.03	0.98
   query29	12.64	3.34	3.31
   query30	0.24	0.06	0.05
   query31	2.85	0.39	0.40
   query32	3.27	0.48	0.48
   query33	2.96	3.00	3.02
   query34	17.10	4.38	4.36
   query35	4.52	4.44	4.44
   query36	0.65	0.50	0.49
   query37	0.19	0.16	0.15
   query38	0.15	0.15	0.14
   query39	0.05	0.04	0.04
   query40	0.16	0.13	0.14
   query41	0.10	0.05	0.05
   query42	0.06	0.04	0.05
   query43	0.05	0.04	0.04
   Total cold run time: 110.94 s
   Total hot run time: 32.27 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] [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]

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

   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)
   
   Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
   See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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] [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]

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

   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