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

[PR] [cherry-pick](branch-30) should check the expr of auto range partition (#41626) [doris]

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

   ## Proposed changes
   
   cherry-pick from master (#41626)
   
   <!--Describe your changes.-->
   
   


-- 
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] [cherry-pick](branch-30) should check the expr of auto range partition (#41626) [doris]

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

   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] [cherry-pick](branch-30) should check the expr of auto range partition (#41626) [doris]

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


-- 
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] [cherry-pick](branch-30) should check the expr of auto range partition (#41626) [doris]

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

   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] [cherry-pick](branch-30) should check the expr of auto range partition (#41626) [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 40389 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 719936c7138b1c91f7f43e0b86026f9170ce29c4, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17578	7403	7283	7283
   q2	2040	151	177	151
   q3	10558	1105	1134	1105
   q4	10200	708	739	708
   q5	7772	2859	2795	2795
   q6	229	150	149	149
   q7	1033	653	611	611
   q8	9576	1937	1949	1937
   q9	8133	6450	6425	6425
   q10	7085	2285	2344	2285
   q11	436	252	259	252
   q12	543	214	213	213
   q13	17800	2982	2967	2967
   q14	247	210	213	210
   q15	561	502	517	502
   q16	497	409	406	406
   q17	987	562	573	562
   q18	7237	6593	6502	6502
   q19	1340	906	966	906
   q20	564	272	271	271
   q21	4015	3172	3293	3172
   q22	1076	1017	977	977
   Total cold run time: 109507 ms
   Total hot run time: 40389 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	7292	7288	7249	7249
   q2	327	228	228	228
   q3	2901	2733	2742	2733
   q4	1905	1667	1636	1636
   q5	5402	5452	5422	5422
   q6	221	139	142	139
   q7	2155	1656	1673	1656
   q8	3232	3376	3407	3376
   q9	8570	8508	8540	8508
   q10	3452	3422	3381	3381
   q11	575	479	488	479
   q12	747	559	594	559
   q13	15079	2989	2968	2968
   q14	279	255	258	255
   q15	547	508	511	508
   q16	486	443	443	443
   q17	1787	1598	1584	1584
   q18	7548	7322	7331	7322
   q19	1660	1523	1481	1481
   q20	2001	1750	1802	1750
   q21	5165	5118	4946	4946
   q22	1082	980	999	980
   Total cold run time: 72413 ms
   Total hot run time: 57603 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] [cherry-pick](branch-30) should check the expr of auto range partition (#41626) [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 188837 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 719936c7138b1c91f7f43e0b86026f9170ce29c4, data reload: false
   
   query1	975	396	358	358
   query2	6496	2030	1977	1977
   query3	6547	213	221	213
   query4	34072	23335	23382	23335
   query5	4379	453	462	453
   query6	257	163	158	158
   query7	4544	304	300	300
   query8	262	200	193	193
   query9	9588	2673	2645	2645
   query10	483	288	285	285
   query11	18061	15109	15135	15109
   query12	151	99	94	94
   query13	1683	441	430	430
   query14	10502	7270	7059	7059
   query15	222	183	170	170
   query16	7690	473	420	420
   query17	1562	566	554	554
   query18	1713	311	305	305
   query19	203	162	157	157
   query20	116	105	106	105
   query21	209	101	101	101
   query22	4580	4079	4164	4079
   query23	34538	33817	33930	33817
   query24	10944	2884	2878	2878
   query25	663	393	403	393
   query26	1466	160	168	160
   query27	2672	297	296	296
   query28	7402	2158	2108	2108
   query29	917	454	423	423
   query30	318	158	148	148
   query31	1026	795	809	795
   query32	94	55	57	55
   query33	755	308	295	295
   query34	925	510	513	510
   query35	908	765	728	728
   query36	1108	946	935	935
   query37	140	77	77	77
   query38	3993	3847	3936	3847
   query39	1489	1424	1424	1424
   query40	280	97	97	97
   query41	46	43	44	43
   query42	118	99	94	94
   query43	500	469	471	469
   query44	1258	780	767	767
   query45	195	163	164	163
   query46	1152	699	700	699
   query47	1904	1809	1823	1809
   query48	435	346	337	337
   query49	1170	399	385	385
   query50	816	413	409	409
   query51	7058	6951	6904	6904
   query52	100	90	90	90
   query53	269	187	188	187
   query54	932	471	459	459
   query55	82	79	76	76
   query56	272	252	251	251
   query57	1283	1144	1126	1126
   query58	249	234	236	234
   query59	3091	2922	2777	2777
   query60	294	284	273	273
   query61	132	96	98	96
   query62	855	685	658	658
   query63	213	187	184	184
   query64	4610	622	610	610
   query65	3209	3195	3146	3146
   query66	1236	312	304	304
   query67	15735	15333	15226	15226
   query68	4569	552	566	552
   query69	582	278	291	278
   query70	1176	1123	1153	1123
   query71	388	270	274	270
   query72	7734	3824	3856	3824
   query73	772	346	336	336
   query74	10332	8872	8978	8872
   query75	3839	2630	2615	2615
   query76	3670	922	860	860
   query77	634	293	292	292
   query78	10130	9590	9192	9192
   query79	3203	575	590	575
   query80	1760	438	435	435
   query81	565	221	224	221
   query82	974	134	127	127
   query83	336	142	138	138
   query84	299	78	81	78
   query85	1979	282	279	279
   query86	475	291	288	288
   query87	4609	4273	4386	4273
   query88	4707	2392	2398	2392
   query89	421	289	288	288
   query90	2084	182	183	182
   query91	135	102	114	102
   query92	67	47	45	45
   query93	4981	536	530	530
   query94	1056	291	294	291
   query95	353	254	249	249
   query96	637	277	279	277
   query97	3294	3150	3121	3121
   query98	218	194	194	194
   query99	1828	1297	1276	1276
   Total cold run time: 308954 ms
   Total hot run time: 188837 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