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

[PR] [Improve)(Variant) do not allow fall back to legacy planner [doris]

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

   ## Proposed changes
   
   Issue Number: close #xxx
   
   <!--Describe your changes.-->
   
   ## 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] [Improve)(Variant) do not allow fall back to legacy planner [doris]

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

   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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.55 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 f0ea7dbd0b7f97d2e27e2bbfe600cc46dafc0b08, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.06	0.03	0.02
   query3	0.22	0.05	0.05
   query4	1.71	0.06	0.10
   query5	0.53	0.52	0.52
   query6	1.40	0.64	0.64
   query7	0.02	0.01	0.01
   query8	0.04	0.02	0.02
   query9	0.54	0.51	0.49
   query10	0.56	0.57	0.55
   query11	0.11	0.09	0.09
   query12	0.11	0.09	0.10
   query13	0.60	0.62	0.60
   query14	0.80	0.79	0.80
   query15	0.80	0.78	0.78
   query16	0.39	0.39	0.37
   query17	1.03	1.03	1.02
   query18	0.24	0.26	0.24
   query19	1.85	1.81	1.78
   query20	0.01	0.01	0.01
   query21	15.40	0.56	0.58
   query22	2.88	2.54	1.55
   query23	17.62	0.80	0.76
   query24	2.24	1.18	0.65
   query25	0.44	0.17	0.19
   query26	0.40	0.14	0.16
   query27	0.06	0.06	0.06
   query28	12.08	0.77	0.77
   query29	12.53	3.18	3.20
   query30	0.54	0.52	0.50
   query31	2.77	0.35	0.35
   query32	3.38	0.47	0.48
   query33	3.22	3.24	3.25
   query34	15.76	4.35	4.27
   query35	4.33	4.39	4.37
   query36	1.12	1.09	1.11
   query37	0.07	0.05	0.05
   query38	0.04	0.03	0.03
   query39	0.02	0.01	0.02
   query40	0.16	0.14	0.13
   query41	0.07	0.02	0.02
   query42	0.02	0.02	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 106.22 s
   Total hot run time: 30.55 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 174205 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 d10ab47846a329460d75648653cac944f7a36be9, data reload: false
   
   query1	941	333	322	322
   query2	6565	2042	1928	1928
   query3	6695	202	198	198
   query4	32943	22163	22111	22111
   query5	4461	431	344	344
   query6	258	151	147	147
   query7	4624	269	259	259
   query8	250	196	177	177
   query9	8536	2289	2269	2269
   query10	428	203	210	203
   query11	17819	15344	15476	15344
   query12	116	68	63	63
   query13	1680	372	381	372
   query14	9275	6384	6471	6384
   query15	209	180	177	177
   query16	5710	266	256	256
   query17	932	466	464	464
   query18	1822	250	261	250
   query19	179	134	131	131
   query20	73	71	66	66
   query21	199	121	129	121
   query22	5114	4877	4941	4877
   query23	31065	30297	30452	30297
   query24	7637	2801	2772	2772
   query25	525	316	313	313
   query26	887	139	139	139
   query27	2807	278	281	278
   query28	3960	1871	1843	1843
   query29	949	610	620	610
   query30	249	134	131	131
   query31	892	709	728	709
   query32	76	50	52	50
   query33	420	219	199	199
   query34	823	454	471	454
   query35	822	764	774	764
   query36	1348	1231	1194	1194
   query37	89	61	57	57
   query38	3297	3189	3171	3171
   query39	1313	1262	1258	1258
   query40	196	89	82	82
   query41	40	34	35	34
   query42	92	78	79	78
   query43	511	487	484	484
   query44	1072	686	684	684
   query45	191	182	174	174
   query46	1046	646	654	646
   query47	1559	1516	1529	1516
   query48	391	302	306	302
   query49	918	284	277	277
   query50	678	304	316	304
   query51	5368	5197	5182	5182
   query52	86	86	80	80
   query53	324	255	272	255
   query54	225	177	189	177
   query55	81	72	73	72
   query56	172	155	163	155
   query57	996	919	896	896
   query58	172	156	161	156
   query59	2681	2600	2446	2446
   query60	210	182	173	173
   query61	87	83	79	79
   query62	499	355	353	353
   query63	288	260	257	257
   query64	3662	1762	1729	1729
   query65	3308	3241	3216	3216
   query66	1169	324	319	319
   query67	15827	15511	14956	14956
   query68	12569	515	503	503
   query69	607	310	306	306
   query70	1806	1615	1534	1534
   query71	532	213	209	209
   query72	4932	2845	2822	2822
   query73	2976	311	311	311
   query74	6834	6343	6320	6320
   query75	5282	2286	2260	2260
   query76	6430	1064	940	940
   query77	663	237	224	224
   query78	9069	8870	8601	8601
   query79	1313	490	494	490
   query80	744	312	304	304
   query81	487	197	202	197
   query82	208	81	72	72
   query83	138	115	114	114
   query84	281	77	71	71
   query85	1089	326	310	310
   query86	419	396	416	396
   query87	3533	3305	3265	3265
   query88	3053	2171	2155	2155
   query89	424	354	357	354
   query90	2176	184	183	183
   query91	147	116	118	116
   query92	50	53	42	42
   query93	2453	462	419	419
   query94	1395	164	160	160
   query95	492	454	451	451
   query96	638	303	312	303
   query97	4211	4094	4134	4094
   query98	203	193	187	187
   query99	986	708	805	708
   Total cold run time: 283977 ms
   Total hot run time: 174205 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 173118 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 4f4b86f5d30cbc93e16c8b0fd13cb339e42f14cd, data reload: false
   
   query1	940	334	325	325
   query2	6548	1945	1952	1945
   query3	6760	201	196	196
   query4	32963	22024	22042	22024
   query5	4448	351	361	351
   query6	244	168	162	162
   query7	4601	260	255	255
   query8	227	173	172	172
   query9	8670	2256	2243	2243
   query10	408	200	206	200
   query11	17506	15409	15379	15379
   query12	130	69	67	67
   query13	1676	380	379	379
   query14	9143	6466	6479	6466
   query15	206	182	176	176
   query16	5698	256	245	245
   query17	952	486	449	449
   query18	1802	257	256	256
   query19	167	134	129	129
   query20	72	71	72	71
   query21	195	129	143	129
   query22	5035	4785	4721	4721
   query23	31471	30542	30290	30290
   query24	12454	2748	2777	2748
   query25	600	310	318	310
   query26	1996	136	141	136
   query27	3190	282	275	275
   query28	7655	1829	1804	1804
   query29	2253	612	605	605
   query30	286	137	139	137
   query31	906	710	709	709
   query32	77	50	47	47
   query33	706	214	208	208
   query34	1180	482	473	473
   query35	857	760	753	753
   query36	1325	1203	1154	1154
   query37	93	59	57	57
   query38	3273	3124	3166	3124
   query39	1307	1245	1237	1237
   query40	340	88	90	88
   query41	38	34	34	34
   query42	93	81	85	81
   query43	552	489	542	489
   query44	1090	687	682	682
   query45	195	181	174	174
   query46	1067	650	639	639
   query47	1599	1522	1544	1522
   query48	376	299	306	299
   query49	1232	282	279	279
   query50	678	308	316	308
   query51	5358	5160	5169	5160
   query52	86	83	84	83
   query53	322	251	263	251
   query54	246	191	183	183
   query55	81	80	71	71
   query56	175	163	170	163
   query57	1030	898	908	898
   query58	198	160	154	154
   query59	2817	2719	2522	2522
   query60	210	177	179	177
   query61	85	80	81	80
   query62	601	349	341	341
   query63	283	260	265	260
   query64	6039	1772	1740	1740
   query65	3289	3250	3219	3219
   query66	1494	324	307	307
   query67	14211	14227	14324	14227
   query68	4027	480	481	480
   query69	439	294	291	291
   query70	1531	1443	1536	1443
   query71	291	215	210	210
   query72	3757	2835	2864	2835
   query73	691	313	301	301
   query74	6660	6220	6313	6220
   query75	2815	2283	2252	2252
   query76	2616	1012	1002	1002
   query77	349	233	235	233
   query78	9140	8913	8631	8631
   query79	1945	503	479	479
   query80	1283	328	320	320
   query81	503	196	203	196
   query82	690	86	82	82
   query83	223	110	115	110
   query84	273	69	71	69
   query85	2138	340	344	340
   query86	510	386	414	386
   query87	3407	3244	3249	3244
   query88	3842	2162	2149	2149
   query89	433	362	374	362
   query90	1931	184	181	181
   query91	148	122	119	119
   query92	57	49	47	47
   query93	2142	449	436	436
   query94	1313	158	161	158
   query95	504	465	456	456
   query96	610	309	320	309
   query97	4272	4103	4102	4102
   query98	212	194	189	189
   query99	1023	656	648	648
   Total cold run time: 281580 ms
   Total hot run time: 173118 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 4f4b86f5d30cbc93e16c8b0fd13cb339e42f14cd with default session variables
   Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 MB/s
   Stream load parquet:      32 seconds loaded 861443392 Bytes, about 25 MB/s
   Insert into select:       13.2 seconds inserted 10000000 Rows, about 757K ops/s
   ```
   


-- 
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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit f0ea7dbd0b7f97d2e27e2bbfe600cc46dafc0b08 with default session variables
   Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      32 seconds loaded 861443392 Bytes, about 25 MB/s
   Insert into select:       13.8 seconds inserted 10000000 Rows, about 724K ops/s
   ```
   


-- 
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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit ac72040a326e93656b49765e4ea76f29542b182c with default session variables
   Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       13.6 seconds inserted 10000000 Rows, about 735K ops/s
   ```
   


-- 
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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39355 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 f0ea7dbd0b7f97d2e27e2bbfe600cc46dafc0b08, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17613	5295	5238	5238
   q2	2051	154	133	133
   q3	10702	932	981	932
   q4	4691	817	826	817
   q5	7677	2940	2993	2940
   q6	183	120	122	120
   q7	1082	747	725	725
   q8	9305	2030	2010	2010
   q9	7285	6388	6399	6388
   q10	8091	2443	2450	2443
   q11	416	210	200	200
   q12	775	284	284	284
   q13	17989	3352	3346	3346
   q14	299	259	277	259
   q15	567	509	509	509
   q16	463	414	424	414
   q17	927	571	508	508
   q18	7760	6955	6810	6810
   q19	1550	1432	1425	1425
   q20	580	342	326	326
   q21	6975	3228	3255	3228
   q22	818	307	300	300
   Total cold run time: 107799 ms
   Total hot run time: 39355 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5431	5263	5298	5263
   q2	318	221	212	212
   q3	3313	3254	3232	3232
   q4	2144	2059	2078	2059
   q5	6063	5816	5966	5816
   q6	199	116	115	115
   q7	2344	1906	1833	1833
   q8	3217	3329	3384	3329
   q9	8960	8875	8811	8811
   q10	6181	3860	3829	3829
   q11	542	470	471	470
   q12	774	625	612	612
   q13	16943	3173	3150	3150
   q14	279	249	278	249
   q15	561	500	508	500
   q16	498	475	479	475
   q17	3166	1765	1852	1765
   q18	9485	17823	9726	9726
   q19	22193	1574	1488	1488
   q20	4575	1947	1921	1921
   q21	14698	5704	5586	5586
   q22	961	542	534	534
   Total cold run time: 112845 ms
   Total hot run time: 60975 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39345 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 ac72040a326e93656b49765e4ea76f29542b182c, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17696	5379	5475	5379
   q2	2061	139	131	131
   q3	10608	963	926	926
   q4	4645	766	818	766
   q5	7668	2920	2935	2920
   q6	189	120	121	120
   q7	1083	723	721	721
   q8	9317	2040	2025	2025
   q9	7267	6459	6418	6418
   q10	8150	2444	2461	2444
   q11	408	198	201	198
   q12	711	287	266	266
   q13	17989	3373	3379	3373
   q14	290	256	253	253
   q15	543	517	512	512
   q16	464	414	423	414
   q17	941	558	485	485
   q18	7644	6893	6890	6890
   q19	1556	1323	1371	1323
   q20	570	346	322	322
   q21	7203	3160	3259	3160
   q22	807	299	299	299
   Total cold run time: 107810 ms
   Total hot run time: 39345 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5441	5559	5422	5422
   q2	321	220	207	207
   q3	3306	3259	3236	3236
   q4	2106	2065	2021	2021
   q5	6054	5924	5944	5924
   q6	200	116	116	116
   q7	2305	1833	1907	1833
   q8	3263	3369	3374	3369
   q9	8938	8996	8796	8796
   q10	5410	3819	3861	3819
   q11	563	443	461	443
   q12	826	620	629	620
   q13	16900	3152	3127	3127
   q14	275	256	270	256
   q15	561	513	520	513
   q16	501	441	467	441
   q17	1883	1804	1847	1804
   q18	9729	19170	9581	9581
   q19	24169	1585	1541	1541
   q20	4637	1958	1915	1915
   q21	14409	5239	5487	5239
   q22	957	550	538	538
   Total cold run time: 112754 ms
   Total hot run time: 60761 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.91 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 4f4b86f5d30cbc93e16c8b0fd13cb339e42f14cd, data reload: false
   
   query1	0.04	0.03	0.02
   query2	0.06	0.02	0.02
   query3	0.23	0.06	0.06
   query4	1.68	0.09	0.09
   query5	0.53	0.51	0.52
   query6	1.19	0.64	0.63
   query7	0.02	0.01	0.02
   query8	0.03	0.02	0.02
   query9	0.54	0.50	0.50
   query10	0.55	0.57	0.56
   query11	0.12	0.08	0.08
   query12	0.11	0.09	0.09
   query13	0.61	0.60	0.60
   query14	0.79	0.79	0.79
   query15	0.78	0.76	0.77
   query16	0.40	0.40	0.38
   query17	1.00	1.02	1.02
   query18	0.22	0.28	0.24
   query19	1.92	1.75	1.78
   query20	0.02	0.01	0.01
   query21	15.40	0.59	0.58
   query22	2.32	2.41	1.82
   query23	17.51	0.85	0.90
   query24	2.76	1.18	0.90
   query25	0.30	0.33	0.10
   query26	0.47	0.14	0.14
   query27	0.05	0.04	0.05
   query28	11.15	0.88	0.85
   query29	12.61	3.07	3.09
   query30	0.59	0.54	0.52
   query31	2.78	0.36	0.34
   query32	3.36	0.49	0.48
   query33	3.21	3.28	3.20
   query34	15.81	4.22	4.32
   query35	4.42	4.35	4.38
   query36	1.10	1.07	1.06
   query37	0.07	0.05	0.05
   query38	0.04	0.03	0.02
   query39	0.02	0.02	0.02
   query40	0.17	0.13	0.13
   query41	0.07	0.02	0.01
   query42	0.02	0.01	0.02
   query43	0.02	0.02	0.01
   Total cold run time: 105.09 s
   Total hot run time: 30.91 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   run p0 10


-- 
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] [Improve](Variant) do not allow fall back to legacy planner [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30430:
URL: https://github.com/apache/doris/pull/30430#issuecomment-1913435984

   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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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


-- 
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] [Improve](Variant) do not allow fall back to legacy planner [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30430:
URL: https://github.com/apache/doris/pull/30430#issuecomment-1913435981

   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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 176108 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 ac72040a326e93656b49765e4ea76f29542b182c, data reload: false
   
   query1	941	332	329	329
   query2	6563	1950	1838	1838
   query3	6704	201	200	200
   query4	30784	22213	22252	22213
   query5	4455	380	382	380
   query6	247	152	159	152
   query7	4605	258	259	258
   query8	231	190	171	171
   query9	8435	2537	2535	2535
   query10	413	206	215	206
   query11	16864	15442	15587	15442
   query12	130	71	68	68
   query13	1677	368	384	368
   query14	9768	6777	6746	6746
   query15	207	178	188	178
   query16	5704	254	260	254
   query17	944	475	458	458
   query18	1804	259	251	251
   query19	180	129	130	129
   query20	69	69	69	69
   query21	197	139	133	133
   query22	4966	4736	4809	4736
   query23	31671	30899	31111	30899
   query24	12450	2829	2779	2779
   query25	595	321	306	306
   query26	1896	142	146	142
   query27	3194	292	280	280
   query28	7675	1828	1811	1811
   query29	1972	612	595	595
   query30	283	133	134	133
   query31	960	727	761	727
   query32	75	51	53	51
   query33	692	215	217	215
   query34	1152	457	487	457
   query35	870	714	786	714
   query36	1317	1175	1177	1175
   query37	94	57	61	57
   query38	3353	3290	3275	3275
   query39	1294	1284	1264	1264
   query40	343	86	82	82
   query41	38	35	46	35
   query42	87	84	84	84
   query43	512	459	470	459
   query44	1109	683	693	683
   query45	189	176	172	172
   query46	1058	665	649	649
   query47	1655	1559	1610	1559
   query48	380	309	304	304
   query49	1189	284	274	274
   query50	675	308	308	308
   query51	5294	5181	5232	5181
   query52	94	76	90	76
   query53	315	252	272	252
   query54	240	179	187	179
   query55	86	81	78	78
   query56	171	160	157	157
   query57	1023	929	918	918
   query58	184	170	153	153
   query59	2847	2667	2437	2437
   query60	203	186	183	183
   query61	79	80	84	80
   query62	614	361	367	361
   query63	275	262	253	253
   query64	5974	1764	1726	1726
   query65	3316	3269	3257	3257
   query66	1319	313	311	311
   query67	15622	15265	15051	15051
   query68	10843	539	535	535
   query69	589	317	299	299
   query70	1693	1473	1472	1472
   query71	515	217	206	206
   query72	4888	2802	2836	2802
   query73	2112	316	310	310
   query74	7027	6395	6376	6376
   query75	4760	2283	2270	2270
   query76	6611	1079	1079	1079
   query77	658	226	237	226
   query78	9086	8972	8763	8763
   query79	1007	492	481	481
   query80	559	323	317	317
   query81	443	207	195	195
   query82	186	80	76	76
   query83	134	115	114	114
   query84	265	70	67	67
   query85	1086	324	315	315
   query86	368	380	368	368
   query87	3580	3369	3318	3318
   query88	2711	2223	2209	2209
   query89	417	340	357	340
   query90	1999	195	182	182
   query91	146	114	123	114
   query92	56	48	45	45
   query93	1776	431	437	431
   query94	1248	160	158	158
   query95	511	455	459	455
   query96	610	315	318	315
   query97	4269	4126	4146	4126
   query98	194	202	186	186
   query99	1011	734	702	702
   Total cold run time: 291680 ms
   Total hot run time: 176108 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.18 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 d10ab47846a329460d75648653cac944f7a36be9, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.07	0.02	0.03
   query3	0.23	0.06	0.06
   query4	1.65	0.09	0.10
   query5	0.52	0.51	0.53
   query6	1.21	0.62	0.61
   query7	0.02	0.01	0.01
   query8	0.04	0.02	0.02
   query9	0.53	0.49	0.50
   query10	0.54	0.55	0.56
   query11	0.11	0.08	0.08
   query12	0.11	0.09	0.10
   query13	0.60	0.61	0.61
   query14	0.80	0.79	0.79
   query15	0.79	0.79	0.78
   query16	0.38	0.38	0.40
   query17	1.01	1.02	1.00
   query18	0.21	0.27	0.24
   query19	1.84	1.82	1.72
   query20	0.01	0.01	0.02
   query21	15.41	0.58	0.56
   query22	2.60	2.35	2.06
   query23	17.21	0.98	0.86
   query24	2.66	1.11	0.97
   query25	0.35	0.10	0.16
   query26	0.47	0.15	0.14
   query27	0.06	0.06	0.04
   query28	11.50	0.84	0.85
   query29	12.52	3.23	3.22
   query30	0.67	0.55	0.46
   query31	2.79	0.34	0.34
   query32	3.35	0.49	0.50
   query33	3.23	3.20	3.21
   query34	15.72	4.24	4.38
   query35	4.36	4.28	4.24
   query36	1.11	1.07	1.06
   query37	0.06	0.05	0.05
   query38	0.04	0.03	0.03
   query39	0.03	0.02	0.02
   query40	0.16	0.14	0.13
   query41	0.07	0.02	0.01
   query42	0.02	0.01	0.02
   query43	0.02	0.02	0.02
   Total cold run time: 105.12 s
   Total hot run time: 31.18 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38077 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 d10ab47846a329460d75648653cac944f7a36be9, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17682	5266	5115	5115
   q2	2053	142	131	131
   q3	10706	925	955	925
   q4	4715	723	722	722
   q5	7675	2820	2822	2820
   q6	187	121	118	118
   q7	1157	720	709	709
   q8	9339	2022	2029	2022
   q9	7267	6312	6322	6312
   q10	8091	2446	2436	2436
   q11	418	198	207	198
   q12	758	293	275	275
   q13	18023	3309	3269	3269
   q14	281	251	238	238
   q15	531	521	487	487
   q16	471	409	414	409
   q17	936	546	476	476
   q18	6992	6311	6255	6255
   q19	1565	1412	1410	1410
   q20	583	351	352	351
   q21	6643	3118	3095	3095
   q22	806	314	304	304
   Total cold run time: 106879 ms
   Total hot run time: 38077 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5312	5159	4963	4963
   q2	330	244	236	236
   q3	2987	2687	2688	2687
   q4	1836	1576	1603	1576
   q5	5346	5366	5240	5240
   q6	200	116	117	116
   q7	2200	1791	1772	1772
   q8	3158	3233	3171	3171
   q9	8531	8691	17715	8691
   q10	5647	3564	3417	3417
   q11	553	465	483	465
   q12	749	599	586	586
   q13	16937	3096	3061	3061
   q14	278	252	253	252
   q15	537	491	486	486
   q16	525	473	455	455
   q17	2040	1713	1684	1684
   q18	8798	8730	10427	8730
   q19	23887	1601	1530	1530
   q20	4558	1905	1903	1903
   q21	14450	4707	4833	4707
   q22	1042	446	507	446
   Total cold run time: 109901 ms
   Total hot run time: 56174 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 178001 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 f0ea7dbd0b7f97d2e27e2bbfe600cc46dafc0b08, data reload: false
   
   query1	948	340	333	333
   query2	6557	2026	1956	1956
   query3	6730	201	200	200
   query4	31906	22388	22366	22366
   query5	4448	378	441	378
   query6	241	160	158	158
   query7	4603	278	260	260
   query8	233	181	186	181
   query9	8317	2543	2537	2537
   query10	408	227	218	218
   query11	17025	15623	15533	15533
   query12	123	69	68	68
   query13	1676	376	381	376
   query14	9986	7050	6993	6993
   query15	209	178	183	178
   query16	5706	264	251	251
   query17	950	498	479	479
   query18	1798	271	258	258
   query19	184	131	139	131
   query20	73	70	71	70
   query21	200	139	119	119
   query22	4903	4703	4709	4703
   query23	32108	31240	31057	31057
   query24	9975	2918	2920	2918
   query25	556	320	324	320
   query26	900	147	146	146
   query27	2983	288	291	288
   query28	5764	1833	1835	1833
   query29	995	635	627	627
   query30	277	144	150	144
   query31	933	757	780	757
   query32	85	52	51	51
   query33	541	220	213	213
   query34	867	461	469	461
   query35	882	795	769	769
   query36	1306	1235	1117	1117
   query37	97	57	58	57
   query38	3364	3329	3240	3240
   query39	1316	1273	1270	1270
   query40	197	92	86	86
   query41	40	36	35	35
   query42	91	86	84	84
   query43	529	464	509	464
   query44	1042	691	681	681
   query45	196	185	175	175
   query46	1117	717	684	684
   query47	1677	1558	1570	1558
   query48	411	324	315	315
   query49	1101	311	310	310
   query50	746	314	310	310
   query51	5289	5229	5165	5165
   query52	86	82	75	75
   query53	354	259	256	256
   query54	217	185	194	185
   query55	79	74	86	74
   query56	181	170	164	164
   query57	1021	943	953	943
   query58	190	154	160	154
   query59	2929	2724	2619	2619
   query60	209	178	187	178
   query61	93	98	86	86
   query62	542	364	350	350
   query63	299	264	260	260
   query64	4056	1855	1837	1837
   query65	3380	3304	3299	3299
   query66	1199	327	311	311
   query67	15647	15475	15333	15333
   query68	10237	526	511	511
   query69	586	321	308	308
   query70	1676	1469	1472	1469
   query71	465	215	214	214
   query72	4743	2886	2896	2886
   query73	1924	316	317	316
   query74	7086	6384	6442	6384
   query75	4313	2320	2355	2320
   query76	6206	1160	1107	1107
   query77	663	235	233	233
   query78	9036	8912	8616	8616
   query79	1122	519	506	506
   query80	737	331	336	331
   query81	467	202	209	202
   query82	215	89	81	81
   query83	168	120	116	116
   query84	277	70	70	70
   query85	965	335	350	335
   query86	392	399	383	383
   query87	3579	3411	3367	3367
   query88	3221	2208	2218	2208
   query89	437	364	354	354
   query90	1982	189	191	189
   query91	164	124	133	124
   query92	55	43	43	43
   query93	2507	434	418	418
   query94	1288	163	162	162
   query95	507	481	473	473
   query96	678	312	315	312
   query97	4260	4135	4164	4135
   query98	218	195	187	187
   query99	988	636	711	636
   Total cold run time: 284253 ms
   Total hot run time: 178001 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit d10ab47846a329460d75648653cac944f7a36be9 with default session variables
   Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 MB/s
   Stream load parquet:      33 seconds loaded 861443392 Bytes, about 24 MB/s
   Insert into select:       14.2 seconds inserted 10000000 Rows, about 704K ops/s
   ```
   


-- 
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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.92 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 ac72040a326e93656b49765e4ea76f29542b182c, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.06	0.02	0.02
   query3	0.23	0.05	0.05
   query4	1.70	0.06	0.06
   query5	0.54	0.52	0.52
   query6	1.32	0.62	0.64
   query7	0.02	0.01	0.02
   query8	0.04	0.02	0.02
   query9	0.53	0.51	0.50
   query10	0.56	0.55	0.55
   query11	0.12	0.08	0.08
   query12	0.11	0.10	0.09
   query13	0.61	0.61	0.62
   query14	0.77	0.81	0.80
   query15	0.80	0.79	0.76
   query16	0.37	0.38	0.37
   query17	1.02	1.02	1.00
   query18	0.24	0.28	0.24
   query19	1.85	1.77	1.79
   query20	0.01	0.01	0.01
   query21	15.40	0.58	0.56
   query22	2.68	2.43	1.30
   query23	17.38	0.80	0.66
   query24	2.52	1.25	0.86
   query25	0.41	0.31	0.07
   query26	0.56	0.15	0.14
   query27	0.06	0.05	0.06
   query28	11.49	0.77	0.78
   query29	12.75	3.12	3.15
   query30	0.56	0.54	0.49
   query31	2.78	0.35	0.36
   query32	3.37	0.47	0.49
   query33	3.23	3.16	3.26
   query34	15.84	4.24	4.30
   query35	4.42	4.26	4.35
   query36	1.11	1.07	1.08
   query37	0.07	0.05	0.05
   query38	0.03	0.02	0.02
   query39	0.02	0.02	0.01
   query40	0.16	0.13	0.13
   query41	0.06	0.01	0.02
   query42	0.02	0.02	0.01
   query43	0.03	0.02	0.02
   Total cold run time: 105.88 s
   Total hot run time: 29.92 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] [Improve](Variant) do not allow fall back to legacy planner [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37769 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 4f4b86f5d30cbc93e16c8b0fd13cb339e42f14cd, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17613	4941	5122	4941
   q2	2050	138	135	135
   q3	10602	957	932	932
   q4	4978	738	749	738
   q5	7741	2865	2867	2865
   q6	186	125	120	120
   q7	1156	750	744	744
   q8	9379	2275	2057	2057
   q9	7424	6502	6389	6389
   q10	8112	2404	2420	2404
   q11	411	218	224	218
   q12	805	281	293	281
   q13	18010	3332	3272	3272
   q14	274	252	250	250
   q15	530	494	488	488
   q16	469	395	396	395
   q17	938	552	485	485
   q18	6916	5930	6043	5930
   q19	1567	1360	1386	1360
   q20	624	358	333	333
   q21	7226	3134	3173	3134
   q22	817	301	298	298
   Total cold run time: 107828 ms
   Total hot run time: 37769 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5190	5028	4944	4944
   q2	341	236	238	236
   q3	3030	2778	2777	2777
   q4	1844	1607	1607	1607
   q5	5408	5173	5253	5173
   q6	203	116	126	116
   q7	2139	1769	1802	1769
   q8	3130	3196	3274	3196
   q9	8708	8613	8666	8613
   q10	5366	3512	3442	3442
   q11	567	475	448	448
   q12	831	610	599	599
   q13	16949	3138	3071	3071
   q14	283	250	263	250
   q15	528	490	495	490
   q16	518	471	484	471
   q17	2035	1671	1663	1663
   q18	8951	15146	8946	8946
   q19	27460	1524	1571	1524
   q20	4603	1940	1889	1889
   q21	15354	4783	4691	4691
   q22	1491	471	483	471
   Total cold run time: 114929 ms
   Total hot run time: 56386 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