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

[PR] [chore](Nereids) turn off fallback [doris]

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

   ## 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38055 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 a11adb0ea1858ed96aff3f7645d45f2a3d51ef47, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17621	4151	4146	4146
   q2	2112	163	161	161
   q3	10576	1128	1226	1128
   q4	10223	731	837	731
   q5	7471	3021	2972	2972
   q6	205	125	120	120
   q7	1044	582	562	562
   q8	9333	2015	1988	1988
   q9	7169	6640	6552	6552
   q10	8371	3449	3599	3449
   q11	430	239	221	221
   q12	373	203	196	196
   q13	17815	2880	2882	2880
   q14	252	201	200	200
   q15	514	478	481	478
   q16	475	374	377	374
   q17	947	536	602	536
   q18	7119	6478	6529	6478
   q19	1527	1468	1493	1468
   q20	552	252	252	252
   q21	3597	2928	2864	2864
   q22	350	309	299	299
   Total cold run time: 108076 ms
   Total hot run time: 38055 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4075	4084	4123	4084
   q2	327	232	229	229
   q3	2999	2809	2873	2809
   q4	1858	1502	1518	1502
   q5	5296	5320	5290	5290
   q6	200	118	118	118
   q7	2268	1823	1868	1823
   q8	3157	3278	3287	3278
   q9	8681	8673	8718	8673
   q10	3815	3798	3808	3798
   q11	546	460	451	451
   q12	732	536	542	536
   q13	16916	2877	2858	2858
   q14	270	264	251	251
   q15	503	461	463	461
   q16	479	426	420	420
   q17	1734	1480	1446	1446
   q18	7323	7184	6973	6973
   q19	1610	1485	1507	1485
   q20	1905	1732	1713	1713
   q21	4707	4713	4826	4713
   q22	536	453	457	453
   Total cold run time: 69937 ms
   Total hot run time: 53364 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) disable fallback_to_original_planner by default [doris]

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


-- 
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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.58 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 212446a13e2fd811ce265e4b8963b645801bee1d, data reload: false
   
   query1	0.04	0.03	0.04
   query2	0.07	0.04	0.04
   query3	0.24	0.06	0.05
   query4	1.66	0.08	0.09
   query5	0.48	0.50	0.49
   query6	1.13	0.65	0.65
   query7	0.02	0.01	0.01
   query8	0.06	0.04	0.05
   query9	0.57	0.49	0.50
   query10	0.56	0.58	0.56
   query11	0.16	0.10	0.11
   query12	0.14	0.11	0.12
   query13	0.61	0.60	0.59
   query14	0.77	0.78	0.80
   query15	0.86	0.83	0.84
   query16	0.35	0.36	0.35
   query17	0.97	0.98	0.99
   query18	0.24	0.25	0.27
   query19	1.87	1.79	1.71
   query20	0.02	0.01	0.01
   query21	15.43	0.75	0.72
   query22	3.00	5.80	2.05
   query23	17.45	1.28	1.10
   query24	1.54	0.32	0.22
   query25	0.15	0.10	0.08
   query26	0.29	0.17	0.18
   query27	0.09	0.08	0.08
   query28	13.55	0.98	1.00
   query29	12.60	3.44	3.54
   query30	0.26	0.06	0.06
   query31	2.86	0.39	0.39
   query32	3.31	0.46	0.46
   query33	2.83	2.88	2.87
   query34	15.49	4.36	4.38
   query35	4.37	4.34	4.42
   query36	0.68	0.48	0.48
   query37	0.21	0.16	0.19
   query38	0.16	0.17	0.15
   query39	0.04	0.03	0.05
   query40	0.20	0.15	0.15
   query41	0.10	0.06	0.05
   query42	0.06	0.05	0.05
   query43	0.04	0.04	0.04
   Total cold run time: 105.53 s
   Total hot run time: 30.58 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.62 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 0ebcf1b8e601b332a79f9567826dd30835c9f56c, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.07	0.04	0.04
   query3	0.23	0.05	0.05
   query4	1.67	0.07	0.06
   query5	0.47	0.48	0.48
   query6	1.13	0.65	0.66
   query7	0.02	0.01	0.01
   query8	0.05	0.04	0.05
   query9	0.57	0.51	0.51
   query10	0.56	0.57	0.56
   query11	0.15	0.11	0.11
   query12	0.14	0.11	0.12
   query13	0.60	0.60	0.59
   query14	0.77	0.77	0.80
   query15	0.87	0.82	0.84
   query16	0.35	0.35	0.36
   query17	0.96	1.02	0.98
   query18	0.25	0.24	0.26
   query19	1.87	1.74	1.73
   query20	0.02	0.01	0.01
   query21	15.40	0.76	0.65
   query22	3.34	4.54	2.37
   query23	17.52	1.32	1.00
   query24	1.89	0.22	0.23
   query25	0.13	0.09	0.09
   query26	0.28	0.17	0.20
   query27	0.09	0.09	0.08
   query28	13.46	0.95	0.96
   query29	12.59	3.37	3.47
   query30	0.26	0.06	0.06
   query31	2.86	0.38	0.37
   query32	3.30	0.47	0.46
   query33	2.86	2.90	2.91
   query34	15.51	4.33	4.33
   query35	4.36	4.38	4.35
   query36	0.66	0.49	0.48
   query37	0.20	0.18	0.17
   query38	0.15	0.17	0.15
   query39	0.05	0.04	0.04
   query40	0.17	0.14	0.14
   query41	0.09	0.05	0.05
   query42	0.06	0.05	0.04
   query43	0.04	0.05	0.04
   Total cold run time: 106.06 s
   Total hot run time: 30.62 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 181856 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 bbfab684d920774cc00a855cd2ce4b3ac457e48d, data reload: false
   
   query1	934	364	352	352
   query2	7615	1989	1804	1804
   query3	6700	217	220	217
   query4	31694	21348	21361	21348
   query5	4314	414	390	390
   query6	276	176	169	169
   query7	4630	300	289	289
   query8	236	170	175	170
   query9	9167	2297	2260	2260
   query10	574	245	267	245
   query11	14746	14350	14280	14280
   query12	139	86	86	86
   query13	1630	429	427	427
   query14	11250	7751	7899	7751
   query15	244	209	193	193
   query16	8171	257	262	257
   query17	1943	575	545	545
   query18	2101	290	319	290
   query19	317	161	156	156
   query20	101	87	86	86
   query21	203	127	125	125
   query22	5035	4876	4826	4826
   query23	33850	32862	32912	32862
   query24	10953	2818	2859	2818
   query25	627	389	391	389
   query26	1365	160	165	160
   query27	2924	362	361	361
   query28	7327	1918	1900	1900
   query29	903	639	625	625
   query30	304	150	149	149
   query31	974	720	733	720
   query32	97	59	55	55
   query33	771	255	249	249
   query34	1042	491	488	488
   query35	809	605	603	603
   query36	1029	907	898	898
   query37	119	67	65	65
   query38	3588	3473	3428	3428
   query39	1461	1447	1448	1447
   query40	223	130	112	112
   query41	50	47	47	47
   query42	102	97	101	97
   query43	457	436	438	436
   query44	1182	761	735	735
   query45	273	260	255	255
   query46	1117	710	704	704
   query47	1922	1941	1842	1842
   query48	456	356	365	356
   query49	1131	348	341	341
   query50	772	377	379	377
   query51	6660	6617	6674	6617
   query52	103	94	89	89
   query53	348	277	279	277
   query54	304	248	244	244
   query55	90	80	81	80
   query56	252	231	226	226
   query57	1236	1139	1133	1133
   query58	231	218	214	214
   query59	2677	2485	2458	2458
   query60	289	254	246	246
   query61	114	112	115	112
   query62	646	439	438	438
   query63	298	272	276	272
   query64	5758	3958	3943	3943
   query65	3112	3025	3051	3025
   query66	1484	378	360	360
   query67	15118	14895	14829	14829
   query68	6393	533	531	531
   query69	599	378	398	378
   query70	1261	1201	1148	1148
   query71	448	264	259	259
   query72	6380	2733	2533	2533
   query73	719	319	318	318
   query74	6623	6334	6404	6334
   query75	3250	2226	2231	2226
   query76	4344	936	915	915
   query77	623	272	256	256
   query78	10999	10084	10218	10084
   query79	8724	539	538	538
   query80	1964	379	388	379
   query81	565	215	216	215
   query82	1573	83	86	83
   query83	289	144	148	144
   query84	285	76	82	76
   query85	1636	319	312	312
   query86	512	291	313	291
   query87	3741	3525	3518	3518
   query88	5227	2380	2377	2377
   query89	540	372	369	369
   query90	1903	176	177	176
   query91	168	135	140	135
   query92	66	48	48	48
   query93	7267	510	501	501
   query94	1229	182	184	182
   query95	446	342	335	335
   query96	627	272	270	270
   query97	2695	2486	2465	2465
   query98	234	220	209	209
   query99	1281	903	947	903
   Total cold run time: 309179 ms
   Total hot run time: 181856 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.07 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 09ef7fc5ac5a0fc7658b6a432504e4296cf2f944, data reload: false
   
   query1	0.03	0.03	0.03
   query2	0.08	0.04	0.04
   query3	0.22	0.05	0.05
   query4	1.67	0.08	0.07
   query5	0.50	0.50	0.50
   query6	1.12	0.64	0.66
   query7	0.02	0.01	0.01
   query8	0.05	0.05	0.04
   query9	0.55	0.49	0.50
   query10	0.54	0.55	0.56
   query11	0.16	0.11	0.12
   query12	0.15	0.11	0.12
   query13	0.60	0.59	0.60
   query14	0.74	0.78	0.79
   query15	0.83	0.81	0.80
   query16	0.34	0.36	0.36
   query17	1.02	1.00	1.02
   query18	0.20	0.24	0.24
   query19	1.90	1.65	1.68
   query20	0.01	0.02	0.01
   query21	15.41	0.65	0.64
   query22	4.29	6.53	2.86
   query23	18.24	1.28	1.20
   query24	1.69	0.28	0.21
   query25	0.13	0.07	0.09
   query26	0.27	0.16	0.15
   query27	0.08	0.08	0.08
   query28	13.39	0.98	0.97
   query29	12.57	3.33	3.29
   query30	0.26	0.06	0.06
   query31	2.84	0.37	0.38
   query32	3.31	0.46	0.46
   query33	2.79	2.83	2.84
   query34	17.46	4.37	4.48
   query35	4.47	4.41	4.48
   query36	0.65	0.47	0.46
   query37	0.20	0.15	0.15
   query38	0.14	0.14	0.14
   query39	0.05	0.04	0.04
   query40	0.18	0.13	0.15
   query41	0.10	0.05	0.04
   query42	0.06	0.04	0.04
   query43	0.04	0.03	0.03
   Total cold run time: 109.35 s
   Total hot run time: 31.07 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] [chore](Nereids) turn off fallback [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 09ef7fc5ac5a0fc7658b6a432504e4296cf2f944 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.7 seconds inserted 10000000 Rows, about 729K 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37924 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 d3b81431733de44810c113235a5fa91dd5b9a2ee, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17639	4335	4116	4116
   q2	2112	162	152	152
   q3	11065	1244	1246	1244
   q4	10485	807	765	765
   q5	7770	2990	2976	2976
   q6	207	127	130	127
   q7	1042	594	582	582
   q8	9392	2040	2012	2012
   q9	7092	6515	6456	6456
   q10	8886	3477	3572	3477
   q11	436	231	217	217
   q12	433	198	194	194
   q13	17792	2858	2836	2836
   q14	236	199	205	199
   q15	515	479	471	471
   q16	502	368	373	368
   q17	950	540	547	540
   q18	7169	6472	6490	6472
   q19	1564	1407	1486	1407
   q20	538	252	272	252
   q21	3563	2880	2780	2780
   q22	334	290	281	281
   Total cold run time: 109722 ms
   Total hot run time: 37924 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4087	4112	4092	4092
   q2	327	227	224	224
   q3	2919	2832	2902	2832
   q4	1859	1632	1542	1542
   q5	5235	5223	5176	5176
   q6	192	113	115	113
   q7	2224	1816	1807	1807
   q8	3182	3310	3321	3310
   q9	8407	8357	8413	8357
   q10	3779	3770	3767	3767
   q11	553	478	434	434
   q12	728	558	519	519
   q13	8238	2902	2877	2877
   q14	302	249	275	249
   q15	500	461	453	453
   q16	486	420	418	418
   q17	1721	1516	1463	1463
   q18	7339	7094	7100	7094
   q19	1612	1514	1564	1514
   q20	1896	1742	1717	1717
   q21	4860	4712	4688	4688
   q22	530	442	426	426
   Total cold run time: 60976 ms
   Total hot run time: 53072 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 11ffe2e88ffefcce8e05cb0a24ebf3d0e7003875 with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 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.5 seconds inserted 10000000 Rows, about 740K 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38417 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 0974ded429b7d84fd90ef93e482f47ab69473cdd, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17703	4073	4050	4050
   q2	2012	197	188	188
   q3	10469	1173	1378	1173
   q4	10216	944	1054	944
   q5	7527	2946	2883	2883
   q6	213	130	133	130
   q7	1070	616	593	593
   q8	9396	2018	2010	2010
   q9	6650	6134	6125	6125
   q10	8441	3501	3495	3495
   q11	427	257	233	233
   q12	377	218	211	211
   q13	17772	2890	2896	2890
   q14	276	238	239	238
   q15	525	485	486	485
   q16	520	398	386	386
   q17	941	904	853	853
   q18	7168	6353	6508	6353
   q19	1581	1538	1522	1522
   q20	603	329	305	305
   q21	3504	3056	3057	3056
   q22	364	300	294	294
   Total cold run time: 107755 ms
   Total hot run time: 38417 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4031	4021	4035	4021
   q2	326	220	220	220
   q3	2957	2935	2913	2913
   q4	1841	1844	1787	1787
   q5	5186	5199	5177	5177
   q6	206	123	121	121
   q7	2211	1779	1778	1778
   q8	3171	3281	3245	3245
   q9	8423	8481	8430	8430
   q10	3715	3854	3988	3854
   q11	553	459	475	459
   q12	741	589	556	556
   q13	16820	3113	3105	3105
   q14	312	276	276	276
   q15	535	500	478	478
   q16	506	442	463	442
   q17	1757	1731	1731	1731
   q18	8393	7597	7626	7597
   q19	1715	1653	1675	1653
   q20	2040	1810	1824	1810
   q21	5328	4796	4930	4796
   q22	522	438	426	426
   Total cold run time: 71289 ms
   Total hot run time: 54875 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] [chore](Nereids) turn off fallback [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit c03b62965cb35b9d153af110989e0c1e140de0bf with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 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:       15.4 seconds inserted 10000000 Rows, about 649K 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] [chore](Nereids) turn off fallback [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit d3b81431733de44810c113235a5fa91dd5b9a2ee with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 212446a13e2fd811ce265e4b8963b645801bee1d with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 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:       16.4 seconds inserted 10000000 Rows, about 609K 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.41 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 c03b62965cb35b9d153af110989e0c1e140de0bf, data reload: false
   
   query1	0.04	0.04	0.04
   query2	0.07	0.04	0.04
   query3	0.23	0.04	0.05
   query4	1.68	0.07	0.07
   query5	0.51	0.48	0.49
   query6	1.14	0.65	0.64
   query7	0.02	0.01	0.01
   query8	0.05	0.04	0.04
   query9	0.55	0.51	0.50
   query10	0.56	0.57	0.56
   query11	0.15	0.12	0.11
   query12	0.14	0.11	0.12
   query13	0.60	0.59	0.59
   query14	0.77	0.77	0.80
   query15	0.86	0.84	0.85
   query16	0.34	0.35	0.35
   query17	0.97	0.93	0.96
   query18	0.24	0.25	0.25
   query19	1.88	1.73	1.68
   query20	0.01	0.01	0.02
   query21	15.42	0.65	0.64
   query22	4.00	8.11	1.26
   query23	18.10	1.28	1.21
   query24	1.49	0.21	0.19
   query25	0.14	0.08	0.08
   query26	0.27	0.16	0.17
   query27	0.09	0.07	0.07
   query28	13.84	0.96	0.95
   query29	12.66	3.29	3.28
   query30	0.26	0.05	0.06
   query31	2.86	0.39	0.39
   query32	3.30	0.47	0.48
   query33	2.88	2.86	2.84
   query34	15.49	4.41	4.34
   query35	4.38	4.38	4.38
   query36	0.66	0.46	0.47
   query37	0.18	0.15	0.16
   query38	0.15	0.14	0.14
   query39	0.04	0.04	0.04
   query40	0.18	0.14	0.15
   query41	0.10	0.04	0.05
   query42	0.05	0.04	0.05
   query43	0.04	0.04	0.03
   Total cold run time: 107.39 s
   Total hot run time: 29.41 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 181063 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 0974ded429b7d84fd90ef93e482f47ab69473cdd, data reload: false
   
   query1	1215	1124	350	350
   query2	6348	2005	1810	1810
   query3	6654	214	208	208
   query4	24723	21421	21363	21363
   query5	4210	409	405	405
   query6	271	214	188	188
   query7	4609	306	300	300
   query8	233	181	186	181
   query9	8477	2223	2224	2223
   query10	453	253	267	253
   query11	14958	14460	14482	14460
   query12	145	97	93	93
   query13	1623	393	392	392
   query14	8555	6910	6938	6910
   query15	223	184	196	184
   query16	6876	280	273	273
   query17	987	594	596	594
   query18	1875	300	283	283
   query19	212	168	170	168
   query20	96	93	92	92
   query21	198	133	130	130
   query22	4936	4738	4790	4738
   query23	33377	32807	32706	32706
   query24	12452	3318	3360	3318
   query25	701	432	425	425
   query26	1677	173	180	173
   query27	3243	374	385	374
   query28	6995	1866	1861	1861
   query29	1136	602	609	602
   query30	312	168	168	168
   query31	1015	782	720	720
   query32	99	62	57	57
   query33	700	245	248	245
   query34	1229	511	514	511
   query35	838	748	736	736
   query36	983	884	877	877
   query37	161	85	90	85
   query38	3707	3620	3611	3611
   query39	1088	1059	1055	1055
   query40	228	149	147	147
   query41	51	46	45	45
   query42	123	117	104	104
   query43	460	418	417	417
   query44	1127	751	733	733
   query45	277	283	269	269
   query46	1098	819	796	796
   query47	1975	1874	1870	1870
   query48	386	326	324	324
   query49	868	361	392	361
   query50	820	424	437	424
   query51	6835	6808	6765	6765
   query52	107	103	102	102
   query53	371	303	300	300
   query54	331	244	241	241
   query55	92	85	83	83
   query56	261	251	245	245
   query57	1269	1194	1182	1182
   query58	259	240	249	240
   query59	2620	2502	2427	2427
   query60	257	243	251	243
   query61	108	107	102	102
   query62	642	475	467	467
   query63	314	281	289	281
   query64	5057	3051	3000	3000
   query65	3022	3042	3002	3002
   query66	1331	316	313	313
   query67	15676	15308	14954	14954
   query68	8751	589	598	589
   query69	566	324	332	324
   query70	1225	1114	1101	1101
   query71	502	270	268	268
   query72	6372	2580	2425	2425
   query73	790	321	323	321
   query74	6650	6359	6349	6349
   query75	3531	2307	2305	2305
   query76	4985	1102	1208	1102
   query77	562	249	253	249
   query78	10749	10085	10091	10085
   query79	9797	525	526	525
   query80	1458	427	411	411
   query81	508	245	240	240
   query82	619	104	106	104
   query83	212	163	161	161
   query84	269	89	90	89
   query85	1257	291	279	279
   query86	364	302	275	275
   query87	3720	3477	3462	3462
   query88	3687	2273	2275	2273
   query89	560	375	371	371
   query90	1941	178	180	178
   query91	130	107	106	106
   query92	60	51	55	51
   query93	6672	529	538	529
   query94	1174	190	194	190
   query95	431	323	322	322
   query96	605	279	270	270
   query97	2689	2514	2504	2504
   query98	224	218	216	216
   query99	1290	830	844	830
   Total cold run time: 295905 ms
   Total hot run time: 181063 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 180086 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 c03b62965cb35b9d153af110989e0c1e140de0bf, data reload: false
   
   query1	1220	1118	1114	1114
   query2	6489	1912	1701	1701
   query3	6665	220	236	220
   query4	24091	21571	21393	21393
   query5	4201	408	415	408
   query6	275	175	186	175
   query7	4600	300	299	299
   query8	226	170	177	170
   query9	8463	2210	2219	2210
   query10	580	253	256	253
   query11	14839	14512	14394	14394
   query12	134	91	86	86
   query13	1630	380	374	374
   query14	8652	6747	6884	6747
   query15	205	182	180	180
   query16	6781	274	271	271
   query17	992	583	575	575
   query18	1798	288	276	276
   query19	199	154	159	154
   query20	95	90	87	87
   query21	201	126	123	123
   query22	5026	4898	4791	4791
   query23	33363	32522	32639	32522
   query24	10843	3017	3066	3017
   query25	652	369	365	365
   query26	1903	156	153	153
   query27	3061	312	318	312
   query28	6750	1818	1803	1803
   query29	1076	578	570	570
   query30	314	161	162	161
   query31	949	707	733	707
   query32	94	57	54	54
   query33	640	243	244	243
   query34	943	477	486	477
   query35	823	665	672	665
   query36	965	853	850	850
   query37	235	67	71	67
   query38	3474	3381	3345	3345
   query39	1564	1537	1517	1517
   query40	293	123	123	123
   query41	50	44	44	44
   query42	106	102	102	102
   query43	456	428	418	418
   query44	1144	714	708	708
   query45	276	250	248	248
   query46	1062	781	763	763
   query47	1874	1793	1789	1789
   query48	365	311	311	311
   query49	1156	365	385	365
   query50	801	399	397	397
   query51	6621	6569	6574	6569
   query52	104	102	96	96
   query53	363	287	289	287
   query54	286	230	242	230
   query55	87	80	75	75
   query56	243	225	231	225
   query57	1226	1129	1133	1129
   query58	256	210	209	209
   query59	2451	2312	2567	2312
   query60	262	232	255	232
   query61	110	102	90	90
   query62	694	433	443	433
   query63	311	277	283	277
   query64	6396	3055	3110	3055
   query65	3037	2962	3007	2962
   query66	1446	326	321	321
   query67	15294	14810	14867	14810
   query68	4546	573	575	573
   query69	467	315	297	297
   query70	1160	1147	1105	1105
   query71	420	272	271	271
   query72	6153	2580	2457	2457
   query73	717	328	329	328
   query74	6659	6324	6284	6284
   query75	2949	2272	2289	2272
   query76	3055	1130	1198	1130
   query77	411	256	259	256
   query78	10937	10118	10209	10118
   query79	3952	530	538	530
   query80	1894	448	435	435
   query81	524	230	231	230
   query82	957	104	99	99
   query83	271	183	183	183
   query84	262	94	97	94
   query85	2076	344	329	329
   query86	481	313	279	279
   query87	3708	3491	3503	3491
   query88	3722	2391	2358	2358
   query89	478	371	372	371
   query90	2024	187	187	187
   query91	143	120	114	114
   query92	67	49	51	49
   query93	5228	540	521	521
   query94	1214	190	189	189
   query95	427	328	323	323
   query96	607	271	270	270
   query97	2666	2487	2473	2473
   query98	232	228	211	211
   query99	1283	850	872	850
   Total cold run time: 281471 ms
   Total hot run time: 180086 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] [chore](Nereids) disable fallback_to_original_planner by default [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38831 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 7737b83741534046d4ec750e04fa25b205d3e4ff, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17639	4437	4280	4280
   q2	2024	192	184	184
   q3	10479	1222	1235	1222
   q4	10645	782	800	782
   q5	7673	2763	2697	2697
   q6	222	133	135	133
   q7	1047	614	612	612
   q8	9393	2093	2068	2068
   q9	7572	6796	6714	6714
   q10	8683	3480	3538	3480
   q11	450	228	222	222
   q12	549	221	213	213
   q13	18545	2939	2982	2939
   q14	266	224	227	224
   q15	526	485	473	473
   q16	529	403	388	388
   q17	968	734	675	675
   q18	7599	6736	6816	6736
   q19	1812	1492	1513	1492
   q20	660	322	305	305
   q21	3710	2678	2899	2678
   q22	352	314	315	314
   Total cold run time: 111343 ms
   Total hot run time: 38831 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4329	4204	4212	4204
   q2	380	269	261	261
   q3	2984	2714	2726	2714
   q4	1859	1587	1596	1587
   q5	5369	5375	5349	5349
   q6	209	122	127	122
   q7	2239	1878	1880	1878
   q8	3218	3319	3325	3319
   q9	8593	8595	8574	8574
   q10	3886	3698	3724	3698
   q11	595	472	492	472
   q12	764	581	590	581
   q13	16322	2923	2941	2923
   q14	299	286	266	266
   q15	515	474	463	463
   q16	473	411	434	411
   q17	1759	1462	1441	1441
   q18	7629	7530	7420	7420
   q19	1633	1562	1543	1543
   q20	1932	1739	1766	1739
   q21	4848	4699	4778	4699
   q22	538	476	457	457
   Total cold run time: 70373 ms
   Total hot run time: 54121 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38608 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 0ebcf1b8e601b332a79f9567826dd30835c9f56c, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17688	4078	4103	4078
   q2	2017	187	183	183
   q3	10495	1177	1377	1177
   q4	10195	897	1057	897
   q5	7471	2937	2896	2896
   q6	219	133	130	130
   q7	1097	625	593	593
   q8	9389	2021	1999	1999
   q9	6710	6197	6128	6128
   q10	8451	3562	3514	3514
   q11	423	246	245	245
   q12	393	217	208	208
   q13	17786	2883	2886	2883
   q14	269	245	244	244
   q15	533	496	485	485
   q16	498	385	372	372
   q17	938	899	897	897
   q18	7175	6518	6581	6518
   q19	1599	1522	1511	1511
   q20	624	331	313	313
   q21	3491	3025	3046	3025
   q22	367	312	316	312
   Total cold run time: 107828 ms
   Total hot run time: 38608 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4086	4028	4038	4028
   q2	328	219	218	218
   q3	2932	2950	2917	2917
   q4	1833	1783	1821	1783
   q5	5196	5214	5192	5192
   q6	206	122	121	121
   q7	2215	1772	1808	1772
   q8	3176	3251	3250	3250
   q9	8388	8419	8413	8413
   q10	3746	3893	3976	3893
   q11	567	463	451	451
   q12	746	591	567	567
   q13	15018	3077	3102	3077
   q14	297	272	265	265
   q15	536	481	494	481
   q16	515	453	439	439
   q17	1790	1712	1726	1712
   q18	8149	7681	7636	7636
   q19	1800	1676	1664	1664
   q20	2038	1811	1821	1811
   q21	5242	4865	4963	4865
   q22	506	460	435	435
   Total cold run time: 69310 ms
   Total hot run time: 54990 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 182061 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 0ebcf1b8e601b332a79f9567826dd30835c9f56c, data reload: false
   
   query1	1216	1113	1125	1113
   query2	6362	1890	1917	1890
   query3	6664	214	210	210
   query4	24181	21432	21521	21432
   query5	4224	388	406	388
   query6	279	200	188	188
   query7	4592	305	304	304
   query8	238	182	182	182
   query9	8474	2252	2269	2252
   query10	452	245	262	245
   query11	14941	14534	14497	14497
   query12	136	96	94	94
   query13	1632	373	365	365
   query14	8512	6849	6829	6829
   query15	206	178	188	178
   query16	6841	267	274	267
   query17	997	593	581	581
   query18	1857	285	280	280
   query19	207	163	162	162
   query20	94	93	93	93
   query21	197	129	127	127
   query22	5005	4868	4846	4846
   query23	33582	33060	32673	32673
   query24	12751	3215	3253	3215
   query25	723	431	430	430
   query26	1900	175	171	171
   query27	3243	381	383	381
   query28	7240	1918	1900	1900
   query29	1373	630	611	611
   query30	329	184	175	175
   query31	1041	770	747	747
   query32	100	64	65	64
   query33	735	265	251	251
   query34	1229	507	540	507
   query35	844	732	738	732
   query36	1010	841	864	841
   query37	278	90	94	90
   query38	3681	3523	3563	3523
   query39	1664	1736	1636	1636
   query40	252	142	147	142
   query41	48	46	50	46
   query42	115	112	113	112
   query43	450	414	414	414
   query44	1114	729	716	716
   query45	271	287	255	255
   query46	1116	880	827	827
   query47	2019	1926	1939	1926
   query48	406	319	325	319
   query49	956	372	374	372
   query50	803	419	404	404
   query51	7024	6847	6917	6847
   query52	106	105	97	97
   query53	375	295	308	295
   query54	330	247	243	243
   query55	92	79	83	79
   query56	264	237	243	237
   query57	1266	1213	1185	1185
   query58	269	246	232	232
   query59	2813	2720	2239	2239
   query60	255	227	237	227
   query61	89	84	87	84
   query62	655	436	468	436
   query63	304	284	273	273
   query64	5901	2943	3063	2943
   query65	3007	2985	3003	2985
   query66	1296	316	308	308
   query67	15419	14759	15013	14759
   query68	9414	574	586	574
   query69	594	325	327	325
   query70	1423	1085	1103	1085
   query71	488	275	268	268
   query72	6610	2550	2419	2419
   query73	1607	328	324	324
   query74	6734	6436	6404	6404
   query75	3691	2279	2248	2248
   query76	5611	1075	1187	1075
   query77	558	244	244	244
   query78	10784	10128	10140	10128
   query79	10088	525	539	525
   query80	1802	449	417	417
   query81	524	243	236	236
   query82	364	102	108	102
   query83	216	170	163	163
   query84	262	91	91	91
   query85	944	301	283	283
   query86	379	284	281	281
   query87	3731	3536	3482	3482
   query88	3721	2356	2361	2356
   query89	555	364	375	364
   query90	1919	177	190	177
   query91	135	108	106	106
   query92	62	54	58	54
   query93	6651	534	547	534
   query94	1183	194	198	194
   query95	456	339	341	339
   query96	611	284	272	272
   query97	2689	2482	2472	2472
   query98	231	218	219	218
   query99	1162	829	865	829
   Total cold run time: 301244 ms
   Total hot run time: 182061 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 29.86 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 0974ded429b7d84fd90ef93e482f47ab69473cdd, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.07	0.04	0.04
   query3	0.24	0.04	0.05
   query4	1.67	0.07	0.07
   query5	0.48	0.47	0.48
   query6	1.15	0.65	0.66
   query7	0.02	0.01	0.01
   query8	0.05	0.05	0.05
   query9	0.57	0.52	0.50
   query10	0.56	0.56	0.56
   query11	0.14	0.11	0.12
   query12	0.14	0.11	0.12
   query13	0.63	0.61	0.59
   query14	0.77	0.77	0.79
   query15	0.86	0.83	0.83
   query16	0.36	0.35	0.35
   query17	0.97	1.00	1.03
   query18	0.26	0.24	0.26
   query19	1.82	1.69	1.74
   query20	0.01	0.00	0.00
   query21	15.42	0.74	0.68
   query22	2.85	6.15	1.57
   query23	17.20	1.36	1.15
   query24	1.36	0.25	0.30
   query25	0.14	0.10	0.08
   query26	0.30	0.18	0.19
   query27	0.09	0.09	0.08
   query28	13.65	0.95	0.95
   query29	12.60	3.54	3.30
   query30	0.26	0.06	0.06
   query31	2.85	0.39	0.39
   query32	3.30	0.47	0.46
   query33	2.86	2.84	2.88
   query34	15.52	4.34	4.32
   query35	4.40	4.36	4.37
   query36	0.66	0.46	0.47
   query37	0.20	0.16	0.18
   query38	0.17	0.17	0.15
   query39	0.05	0.03	0.04
   query40	0.17	0.14	0.15
   query41	0.10	0.05	0.05
   query42	0.06	0.05	0.06
   query43	0.05	0.04	0.04
   Total cold run time: 105.07 s
   Total hot run time: 29.86 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] [chore](Nereids) turn off fallback [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 0974ded429b7d84fd90ef93e482f47ab69473cdd 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:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       16.7 seconds inserted 10000000 Rows, about 598K 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39162 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 520f2da0eb1d968acd4f7fb147c72ea9d7505f99, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17704	4363	4236	4236
   q2	2012	188	190	188
   q3	10503	1192	1157	1157
   q4	10200	760	797	760
   q5	7524	2670	2612	2612
   q6	220	131	128	128
   q7	1008	626	614	614
   q8	9196	2056	2044	2044
   q9	8599	7164	7120	7120
   q10	8536	3497	3515	3497
   q11	464	242	239	239
   q12	461	220	219	219
   q13	18901	2937	2912	2912
   q14	272	229	237	229
   q15	521	478	471	471
   q16	526	387	384	384
   q17	954	752	717	717
   q18	7263	6798	6807	6798
   q19	2048	1533	1520	1520
   q20	689	320	299	299
   q21	3452	2716	2748	2716
   q22	365	309	302	302
   Total cold run time: 111418 ms
   Total hot run time: 39162 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4362	4257	4240	4240
   q2	366	261	271	261
   q3	2995	2763	2820	2763
   q4	1904	1621	1569	1569
   q5	5365	5354	5255	5255
   q6	209	126	121	121
   q7	2243	1870	1836	1836
   q8	3191	3336	3333	3333
   q9	9257	9317	9358	9317
   q10	4064	3922	3901	3901
   q11	592	488	491	488
   q12	753	654	601	601
   q13	17132	3117	3150	3117
   q14	320	277	289	277
   q15	509	468	472	468
   q16	483	461	484	461
   q17	1855	1519	1505	1505
   q18	8034	8069	7725	7725
   q19	2024	1644	1583	1583
   q20	2057	1854	1842	1842
   q21	5246	4756	5089	4756
   q22	575	505	486	486
   Total cold run time: 73536 ms
   Total hot run time: 55905 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 181601 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 11ffe2e88ffefcce8e05cb0a24ebf3d0e7003875, data reload: false
   
   query1	953	368	358	358
   query2	6528	2031	1923	1923
   query3	6707	208	211	208
   query4	31980	21420	21547	21420
   query5	4290	397	402	397
   query6	272	173	191	173
   query7	4631	288	293	288
   query8	229	182	177	177
   query9	9170	2367	2334	2334
   query10	569	250	259	250
   query11	17190	14129	14140	14129
   query12	146	94	92	92
   query13	1628	416	431	416
   query14	9879	7604	7571	7571
   query15	250	201	196	196
   query16	8143	257	253	253
   query17	1972	548	523	523
   query18	2076	272	275	272
   query19	245	155	153	153
   query20	93	88	85	85
   query21	198	130	132	130
   query22	4952	4791	4804	4791
   query23	33595	32821	32641	32641
   query24	11905	2890	2852	2852
   query25	646	363	386	363
   query26	1830	157	164	157
   query27	3141	347	356	347
   query28	7920	1901	1875	1875
   query29	1048	645	624	624
   query30	307	149	151	149
   query31	992	755	743	743
   query32	94	60	55	55
   query33	780	257	259	257
   query34	1110	491	505	491
   query35	852	626	615	615
   query36	1007	885	854	854
   query37	283	68	78	68
   query38	3545	3444	3425	3425
   query39	1501	1464	1436	1436
   query40	294	114	113	113
   query41	50	47	47	47
   query42	109	100	97	97
   query43	507	472	429	429
   query44	1229	760	737	737
   query45	275	258	266	258
   query46	1113	698	692	692
   query47	1905	1849	1826	1826
   query48	467	354	356	354
   query49	1242	352	353	352
   query50	758	377	381	377
   query51	6750	6540	6666	6540
   query52	113	94	93	93
   query53	369	276	291	276
   query54	335	250	248	248
   query55	81	80	79	79
   query56	260	233	231	231
   query57	1206	1148	1156	1148
   query58	250	212	213	212
   query59	2837	2646	2588	2588
   query60	277	259	262	259
   query61	119	114	112	112
   query62	681	440	458	440
   query63	311	282	281	281
   query64	6605	4155	4068	4068
   query65	3136	3047	3045	3045
   query66	1410	395	387	387
   query67	15379	15049	14893	14893
   query68	7956	516	532	516
   query69	627	400	395	395
   query70	1287	1171	1116	1116
   query71	514	275	272	272
   query72	6486	2692	2554	2554
   query73	742	329	314	314
   query74	7792	6452	6327	6327
   query75	3571	2180	2252	2180
   query76	4981	869	860	860
   query77	644	255	257	255
   query78	11001	10134	10165	10134
   query79	11720	534	519	519
   query80	1944	368	370	368
   query81	522	217	217	217
   query82	755	84	88	84
   query83	216	142	150	142
   query84	284	78	73	73
   query85	1494	320	314	314
   query86	475	287	306	287
   query87	3724	3538	3509	3509
   query88	5389	2295	2295	2295
   query89	500	378	375	375
   query90	1975	177	174	174
   query91	177	134	138	134
   query92	64	48	47	47
   query93	7660	500	483	483
   query94	1229	180	174	174
   query95	436	321	327	321
   query96	625	275	267	267
   query97	2669	2492	2494	2492
   query98	231	215	213	213
   query99	1252	917	937	917
   Total cold run time: 319667 ms
   Total hot run time: 181601 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 182281 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 a668412b14c8a498f03c49200892d73ebebb2a20, data reload: false
   
   query1	925	359	343	343
   query2	6544	2116	2018	2018
   query3	6703	213	217	213
   query4	31738	21325	21297	21297
   query5	4305	409	392	392
   query6	277	186	183	183
   query7	4630	295	290	290
   query8	233	168	169	168
   query9	9193	2350	2356	2350
   query10	575	257	267	257
   query11	17245	14389	14313	14313
   query12	140	94	91	91
   query13	1629	421	463	421
   query14	9994	7592	7976	7592
   query15	252	183	201	183
   query16	8232	257	261	257
   query17	2025	539	543	539
   query18	2094	286	276	276
   query19	338	161	152	152
   query20	91	90	90	90
   query21	208	136	151	136
   query22	5019	4841	4792	4792
   query23	33257	32830	32767	32767
   query24	11840	2834	2890	2834
   query25	665	382	389	382
   query26	1811	157	153	153
   query27	3097	359	360	359
   query28	7675	1894	1855	1855
   query29	1050	640	627	627
   query30	311	146	152	146
   query31	979	725	746	725
   query32	103	63	57	57
   query33	790	266	253	253
   query34	1111	486	496	486
   query35	835	624	605	605
   query36	988	925	900	900
   query37	270	64	70	64
   query38	3561	3472	3466	3466
   query39	1476	1450	1427	1427
   query40	287	117	115	115
   query41	50	47	44	44
   query42	118	102	95	95
   query43	496	446	447	446
   query44	1179	743	762	743
   query45	276	258	270	258
   query46	1110	725	715	715
   query47	1927	1855	1848	1848
   query48	426	371	364	364
   query49	1243	347	344	344
   query50	760	371	363	363
   query51	6706	6693	6625	6625
   query52	115	93	94	93
   query53	354	278	280	278
   query54	331	237	241	237
   query55	92	80	80	80
   query56	250	224	227	224
   query57	1229	1142	1144	1142
   query58	239	215	213	213
   query59	2836	2648	2696	2648
   query60	276	255	259	255
   query61	116	118	124	118
   query62	683	468	450	450
   query63	306	279	282	279
   query64	6884	4060	4016	4016
   query65	3097	3076	3039	3039
   query66	1453	396	373	373
   query67	15794	14935	14848	14848
   query68	9088	523	523	523
   query69	696	399	378	378
   query70	1408	1091	1147	1091
   query71	527	270	273	270
   query72	6636	2709	2578	2578
   query73	1582	326	328	326
   query74	6936	6513	6436	6436
   query75	4170	2274	2227	2227
   query76	5838	889	903	889
   query77	650	264	276	264
   query78	10881	10208	10128	10128
   query79	8350	526	538	526
   query80	1070	381	367	367
   query81	493	213	217	213
   query82	254	91	87	87
   query83	227	149	143	143
   query84	286	81	77	77
   query85	1073	332	321	321
   query86	354	316	297	297
   query87	3771	3536	3524	3524
   query88	4337	2307	2299	2299
   query89	480	373	364	364
   query90	2010	176	180	176
   query91	179	140	140	140
   query92	65	48	47	47
   query93	4914	495	489	489
   query94	1328	178	180	178
   query95	430	340	329	329
   query96	597	278	270	270
   query97	2632	2491	2482	2482
   query98	225	218	225	218
   query99	1091	912	921	912
   Total cold run time: 313420 ms
   Total hot run time: 182281 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] [chore](Nereids) turn off fallback [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit a668412b14c8a498f03c49200892d73ebebb2a20 with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       13.7 seconds inserted 10000000 Rows, about 729K 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] [chore](Nereids) disable fallback_to_original_planner by default [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37722 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 bbfab684d920774cc00a855cd2ce4b3ac457e48d, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17613	4236	4091	4091
   q2	2101	161	149	149
   q3	10584	1175	1179	1175
   q4	10224	751	745	745
   q5	7435	2949	2960	2949
   q6	204	124	122	122
   q7	1026	584	577	577
   q8	9318	1958	1948	1948
   q9	7183	6567	6546	6546
   q10	8448	3434	3563	3434
   q11	434	229	226	226
   q12	364	208	201	201
   q13	17799	2837	2839	2837
   q14	235	201	213	201
   q15	513	462	458	458
   q16	482	374	375	374
   q17	941	623	578	578
   q18	7152	6391	6386	6386
   q19	3772	1358	1400	1358
   q20	539	246	247	246
   q21	3542	2829	2982	2829
   q22	342	310	292	292
   Total cold run time: 110251 ms
   Total hot run time: 37722 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4118	4049	4083	4049
   q2	325	231	231	231
   q3	2975	2839	2829	2829
   q4	1826	1552	1565	1552
   q5	5258	5349	5305	5305
   q6	197	119	118	118
   q7	2251	1857	1866	1857
   q8	3154	3264	3290	3264
   q9	8681	8680	8678	8678
   q10	3823	3776	3797	3776
   q11	540	445	437	437
   q12	732	542	575	542
   q13	16919	2846	2863	2846
   q14	270	253	266	253
   q15	493	468	454	454
   q16	490	429	439	429
   q17	1715	1498	1455	1455
   q18	7306	7191	7042	7042
   q19	1611	1498	1461	1461
   q20	1958	1743	1718	1718
   q21	4711	4716	4731	4716
   q22	517	476	447	447
   Total cold run time: 69870 ms
   Total hot run time: 53459 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] [chore](Nereids) turn off fallback [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit a11adb0ea1858ed96aff3f7645d45f2a3d51ef47 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:       14.1 seconds inserted 10000000 Rows, about 709K 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 181765 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 d3b81431733de44810c113235a5fa91dd5b9a2ee, data reload: false
   
   query1	953	365	353	353
   query2	6544	2040	1884	1884
   query3	6706	218	213	213
   query4	31631	21333	21263	21263
   query5	4280	392	393	392
   query6	269	179	183	179
   query7	4632	291	293	291
   query8	240	179	189	179
   query9	9279	2334	2316	2316
   query10	563	257	252	252
   query11	15534	14216	14359	14216
   query12	141	100	93	93
   query13	1626	414	418	414
   query14	9957	8040	7903	7903
   query15	308	192	181	181
   query16	8157	259	261	259
   query17	2139	582	553	553
   query18	1925	309	300	300
   query19	352	155	154	154
   query20	97	87	91	87
   query21	206	129	126	126
   query22	5036	4828	4857	4828
   query23	33353	32683	33029	32683
   query24	11798	2871	2879	2871
   query25	658	385	389	385
   query26	1789	154	155	154
   query27	3030	353	352	352
   query28	7669	1910	1872	1872
   query29	1006	644	612	612
   query30	309	153	149	149
   query31	1004	729	752	729
   query32	90	60	56	56
   query33	757	257	249	249
   query34	1112	478	483	478
   query35	867	605	612	605
   query36	1026	880	899	880
   query37	272	65	67	65
   query38	3595	3459	3391	3391
   query39	1494	1469	1443	1443
   query40	297	113	112	112
   query41	55	48	49	48
   query42	103	97	95	95
   query43	489	457	425	425
   query44	1209	727	725	725
   query45	282	269	260	260
   query46	1102	692	687	687
   query47	1917	1831	1839	1831
   query48	441	368	352	352
   query49	1235	343	359	343
   query50	763	369	373	369
   query51	6845	6763	6861	6763
   query52	115	93	90	90
   query53	346	279	271	271
   query54	322	246	241	241
   query55	93	79	78	78
   query56	249	234	223	223
   query57	1249	1134	1140	1134
   query58	249	211	206	206
   query59	2844	2691	2728	2691
   query60	268	240	254	240
   query61	114	114	115	114
   query62	634	425	423	423
   query63	309	277	275	275
   query64	6242	4077	4022	4022
   query65	3069	3053	3037	3037
   query66	1388	378	348	348
   query67	15579	14924	14791	14791
   query68	8979	518	531	518
   query69	663	375	369	369
   query70	1361	1163	1164	1163
   query71	524	273	257	257
   query72	6608	2545	2357	2357
   query73	1637	313	314	313
   query74	8270	6420	6336	6336
   query75	3801	2240	2253	2240
   query76	5714	908	909	908
   query77	642	292	252	252
   query78	11022	10319	10082	10082
   query79	10632	514	523	514
   query80	1752	380	369	369
   query81	511	222	224	222
   query82	235	87	83	83
   query83	209	146	143	143
   query84	289	73	84	73
   query85	1122	317	313	313
   query86	358	295	292	292
   query87	3765	3553	3514	3514
   query88	5082	2309	2301	2301
   query89	483	360	370	360
   query90	2060	180	178	178
   query91	166	137	136	136
   query92	63	49	47	47
   query93	6154	493	486	486
   query94	1321	176	180	176
   query95	440	324	328	324
   query96	626	270	275	270
   query97	2642	2542	2517	2517
   query98	229	223	208	208
   query99	1133	840	848	840
   Total cold run time: 316705 ms
   Total hot run time: 181765 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39464 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 09ef7fc5ac5a0fc7658b6a432504e4296cf2f944, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17967	4746	4433	4433
   q2	2455	200	197	197
   q3	10734	1261	1311	1261
   q4	10533	792	853	792
   q5	7737	2776	2683	2683
   q6	220	137	136	136
   q7	1024	601	586	586
   q8	9220	2051	2028	2028
   q9	8532	7165	7162	7162
   q10	8622	3604	3523	3523
   q11	452	241	230	230
   q12	442	215	213	213
   q13	17967	2974	2991	2974
   q14	279	226	236	226
   q15	535	483	477	477
   q16	506	396	379	379
   q17	973	561	693	561
   q18	7216	6695	6712	6695
   q19	1607	1518	1490	1490
   q20	703	327	320	320
   q21	3493	2796	2928	2796
   q22	374	302	309	302
   Total cold run time: 111591 ms
   Total hot run time: 39464 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4251	4219	4209	4209
   q2	392	275	274	274
   q3	2998	2791	2780	2780
   q4	1868	1585	1614	1585
   q5	5325	5308	5288	5288
   q6	213	127	128	127
   q7	2248	1862	1894	1862
   q8	3205	3379	3317	3317
   q9	9304	9280	9160	9160
   q10	3829	3685	3746	3685
   q11	571	512	487	487
   q12	738	595	599	595
   q13	14057	2966	2897	2897
   q14	310	266	277	266
   q15	506	464	464	464
   q16	457	418	422	418
   q17	1750	1469	1463	1463
   q18	7484	7604	7371	7371
   q19	1628	1481	1483	1481
   q20	1957	1726	1737	1726
   q21	4918	4864	4752	4752
   q22	544	469	449	449
   Total cold run time: 68553 ms
   Total hot run time: 54656 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) disable fallback_to_original_planner by default [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 7737b83741534046d4ec750e04fa25b205d3e4ff 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.5 seconds inserted 10000000 Rows, about 740K 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) disable fallback_to_original_planner by default [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 184770 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 7737b83741534046d4ec750e04fa25b205d3e4ff, data reload: false
   
   query1	903	365	359	359
   query2	7640	2641	2406	2406
   query3	6648	207	208	207
   query4	24188	21309	21375	21309
   query5	4167	413	414	413
   query6	278	175	197	175
   query7	4591	292	283	283
   query8	228	179	177	177
   query9	8636	2340	2342	2340
   query10	602	256	248	248
   query11	14880	14200	14154	14154
   query12	148	90	87	87
   query13	1649	364	356	356
   query14	10534	8079	7959	7959
   query15	279	187	180	180
   query16	8240	266	270	266
   query17	1972	598	567	567
   query18	2107	292	295	292
   query19	336	156	159	156
   query20	97	85	87	85
   query21	199	127	124	124
   query22	4980	4772	4819	4772
   query23	33803	33422	33183	33183
   query24	11678	2951	2960	2951
   query25	645	360	368	360
   query26	1743	154	149	149
   query27	2894	311	308	308
   query28	7680	1995	1984	1984
   query29	1009	626	596	596
   query30	278	173	178	173
   query31	958	734	717	717
   query32	85	51	55	51
   query33	739	251	247	247
   query34	1026	477	479	477
   query35	825	707	694	694
   query36	1059	914	902	902
   query37	190	69	72	69
   query38	3384	3173	3225	3173
   query39	1583	1518	1527	1518
   query40	270	123	127	123
   query41	46	43	44	43
   query42	102	93	99	93
   query43	562	553	553	553
   query44	1223	717	741	717
   query45	275	258	253	253
   query46	1068	728	755	728
   query47	1917	1864	1848	1848
   query48	355	308	284	284
   query49	1130	377	360	360
   query50	760	377	385	377
   query51	6727	6513	6556	6513
   query52	103	87	92	87
   query53	345	273	278	273
   query54	305	237	232	232
   query55	81	73	77	73
   query56	243	227	228	227
   query57	1203	1139	1182	1139
   query58	222	199	198	198
   query59	3423	3111	3236	3111
   query60	259	230	235	230
   query61	91	90	91	90
   query62	646	429	448	429
   query63	305	281	277	277
   query64	6234	3894	3745	3745
   query65	3229	3034	3042	3034
   query66	1389	343	322	322
   query67	15400	15137	14876	14876
   query68	6372	545	534	534
   query69	519	317	308	308
   query70	1229	1189	1149	1149
   query71	1445	1267	1264	1264
   query72	6493	2630	2423	2423
   query73	736	315	317	315
   query74	6886	6458	6377	6377
   query75	3841	2628	2653	2628
   query76	4255	952	1042	952
   query77	624	268	267	267
   query78	11064	10181	10434	10181
   query79	7137	512	524	512
   query80	1799	429	422	422
   query81	532	254	248	248
   query82	1496	96	95	95
   query83	336	172	167	167
   query84	259	85	82	82
   query85	1562	267	264	264
   query86	499	302	313	302
   query87	3465	3313	3319	3313
   query88	4893	2318	2318	2318
   query89	483	368	373	368
   query90	1996	187	183	183
   query91	129	95	102	95
   query92	58	50	47	47
   query93	5424	519	503	503
   query94	1215	177	176	176
   query95	393	352	297	297
   query96	610	262	264	262
   query97	3202	2930	2960	2930
   query98	240	224	213	213
   query99	1256	880	873	873
   Total cold run time: 301242 ms
   Total hot run time: 184770 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38809 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 c03b62965cb35b9d153af110989e0c1e140de0bf, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17624	4107	4075	4075
   q2	2014	187	176	176
   q3	10494	1171	1349	1171
   q4	10511	882	1018	882
   q5	7866	3017	2996	2996
   q6	221	138	135	135
   q7	1124	672	611	611
   q8	9916	2093	2063	2063
   q9	6859	6317	6172	6172
   q10	8459	3486	3504	3486
   q11	427	232	232	232
   q12	370	207	206	206
   q13	17777	2913	2913	2913
   q14	269	229	238	229
   q15	522	486	484	484
   q16	511	376	367	367
   q17	963	912	900	900
   q18	7276	6489	6457	6457
   q19	1595	1543	1537	1537
   q20	562	323	297	297
   q21	3540	3149	3120	3120
   q22	371	300	303	300
   Total cold run time: 109271 ms
   Total hot run time: 38809 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4030	4131	4026	4026
   q2	329	220	222	220
   q3	2970	2946	2942	2942
   q4	1858	1839	1853	1839
   q5	5266	5224	5218	5218
   q6	210	130	126	126
   q7	2220	1781	1812	1781
   q8	3210	3268	3309	3268
   q9	8513	8444	8471	8444
   q10	3748	3829	3828	3828
   q11	550	470	442	442
   q12	686	511	537	511
   q13	7875	2909	2901	2901
   q14	299	250	259	250
   q15	518	462	461	461
   q16	445	390	391	390
   q17	1687	1690	1669	1669
   q18	7564	7181	7150	7150
   q19	1649	1647	1643	1643
   q20	1929	1735	1720	1720
   q21	4998	4751	4721	4721
   q22	488	438	406	406
   Total cold run time: 61042 ms
   Total hot run time: 53956 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) disable fallback_to_original_planner by default [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 182523 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 a11adb0ea1858ed96aff3f7645d45f2a3d51ef47, data reload: false
   
   query1	932	375	366	366
   query2	6556	2112	1926	1926
   query3	6702	210	209	209
   query4	31733	21335	21434	21335
   query5	4325	406	393	393
   query6	274	179	174	174
   query7	4645	298	287	287
   query8	249	167	168	167
   query9	9407	2311	2291	2291
   query10	554	249	241	241
   query11	15392	14223	14293	14223
   query12	144	95	88	88
   query13	1637	412	411	411
   query14	10058	8016	7884	7884
   query15	277	211	201	201
   query16	8249	267	265	265
   query17	2041	593	554	554
   query18	2104	292	287	287
   query19	345	157	158	157
   query20	97	89	90	89
   query21	201	131	124	124
   query22	5070	4832	4860	4832
   query23	33546	33028	32882	32882
   query24	11109	2907	2825	2825
   query25	621	391	387	387
   query26	1639	159	153	153
   query27	2949	352	353	352
   query28	7522	1897	1862	1862
   query29	970	619	613	613
   query30	305	159	150	150
   query31	970	736	752	736
   query32	87	58	55	55
   query33	767	248	251	248
   query34	1056	492	491	491
   query35	829	621	613	613
   query36	1027	894	899	894
   query37	118	69	63	63
   query38	3579	3398	3433	3398
   query39	1494	1453	1425	1425
   query40	290	115	111	111
   query41	51	49	51	49
   query42	107	98	96	96
   query43	506	466	457	457
   query44	1206	730	742	730
   query45	277	266	268	266
   query46	1127	698	720	698
   query47	1920	1847	1841	1841
   query48	454	355	366	355
   query49	1199	332	349	332
   query50	764	379	370	370
   query51	6716	6740	6583	6583
   query52	104	89	97	89
   query53	340	276	274	274
   query54	339	238	225	225
   query55	79	76	78	76
   query56	242	216	215	215
   query57	1266	1131	1142	1131
   query58	231	202	203	202
   query59	2808	2762	2787	2762
   query60	275	239	247	239
   query61	98	93	95	93
   query62	663	432	437	432
   query63	306	270	280	270
   query64	6248	3932	3984	3932
   query65	3174	3118	3078	3078
   query66	1410	369	356	356
   query67	15738	15075	15006	15006
   query68	8443	517	521	517
   query69	614	380	374	374
   query70	1289	1187	1171	1171
   query71	517	260	249	249
   query72	6474	2703	2564	2564
   query73	729	316	318	316
   query74	6923	6442	6360	6360
   query75	3674	2191	2233	2191
   query76	5121	916	890	890
   query77	638	272	260	260
   query78	10893	10380	10167	10167
   query79	7930	533	537	533
   query80	1394	403	395	395
   query81	518	217	219	217
   query82	520	90	88	88
   query83	222	153	147	147
   query84	287	83	82	82
   query85	1270	390	369	369
   query86	392	295	320	295
   query87	3775	3563	3562	3562
   query88	4505	2301	2289	2289
   query89	488	361	379	361
   query90	2059	171	173	171
   query91	169	159	138	138
   query92	60	46	46	46
   query93	6384	496	490	490
   query94	1206	190	188	188
   query95	436	326	337	326
   query96	601	277	269	269
   query97	2637	2500	2476	2476
   query98	223	217	209	209
   query99	1204	894	923	894
   Total cold run time: 309113 ms
   Total hot run time: 182523 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38179 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 11ffe2e88ffefcce8e05cb0a24ebf3d0e7003875, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17888	4407	4201	4201
   q2	2432	161	172	161
   q3	11509	1113	1175	1113
   q4	10387	742	760	742
   q5	7724	3084	3051	3051
   q6	205	127	125	125
   q7	1064	628	604	604
   q8	9335	2047	1985	1985
   q9	7275	6629	6590	6590
   q10	8448	3465	3594	3465
   q11	435	239	216	216
   q12	370	194	194	194
   q13	17796	2846	2860	2846
   q14	226	205	197	197
   q15	515	475	460	460
   q16	511	366	371	366
   q17	954	535	573	535
   q18	7133	6626	6447	6447
   q19	1562	1437	1495	1437
   q20	552	258	274	258
   q21	3591	2895	2902	2895
   q22	346	294	291	291
   Total cold run time: 110258 ms
   Total hot run time: 38179 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4103	4077	4074	4074
   q2	320	224	227	224
   q3	2932	2820	2817	2817
   q4	1832	1556	1579	1556
   q5	5327	5361	5316	5316
   q6	195	116	116	116
   q7	2194	1839	1857	1839
   q8	3176	3277	3269	3269
   q9	8725	8724	8700	8700
   q10	3840	3731	3809	3731
   q11	552	446	438	438
   q12	740	541	537	537
   q13	16893	2860	2840	2840
   q14	289	258	257	257
   q15	504	455	464	455
   q16	488	415	421	415
   q17	1709	1494	1477	1477
   q18	7347	7176	7162	7162
   q19	1593	1526	1562	1526
   q20	1893	1716	1742	1716
   q21	4806	4675	4551	4551
   q22	533	465	451	451
   Total cold run time: 69991 ms
   Total hot run time: 53467 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] [chore](Nereids) disable fallback_to_original_planner by default [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.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 7737b83741534046d4ec750e04fa25b205d3e4ff, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.08	0.04	0.04
   query3	0.23	0.04	0.04
   query4	1.68	0.07	0.07
   query5	0.51	0.50	0.52
   query6	1.47	0.71	0.73
   query7	0.02	0.01	0.01
   query8	0.04	0.04	0.04
   query9	0.56	0.50	0.49
   query10	0.55	0.56	0.55
   query11	0.16	0.11	0.12
   query12	0.15	0.13	0.13
   query13	0.61	0.60	0.57
   query14	0.75	0.79	0.77
   query15	0.81	0.78	0.79
   query16	0.37	0.34	0.37
   query17	0.93	0.93	0.93
   query18	0.23	0.22	0.25
   query19	1.75	1.70	1.66
   query20	0.02	0.01	0.01
   query21	15.43	0.64	0.64
   query22	4.31	7.31	2.14
   query23	18.26	1.35	1.20
   query24	1.68	0.33	0.21
   query25	0.14	0.10	0.07
   query26	0.25	0.16	0.16
   query27	0.08	0.08	0.08
   query28	13.33	1.00	0.96
   query29	12.61	3.24	3.20
   query30	0.26	0.07	0.06
   query31	2.85	0.37	0.39
   query32	3.30	0.46	0.46
   query33	2.84	2.78	2.82
   query34	17.23	4.39	4.39
   query35	4.48	4.50	4.52
   query36	0.65	0.46	0.46
   query37	0.18	0.16	0.15
   query38	0.16	0.15	0.14
   query39	0.04	0.04	0.03
   query40	0.16	0.14	0.14
   query41	0.10	0.04	0.04
   query42	0.05	0.05	0.05
   query43	0.04	0.04	0.04
   Total cold run time: 109.39 s
   Total hot run time: 30.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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38219 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 a668412b14c8a498f03c49200892d73ebebb2a20, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17915	4350	4207	4207
   q2	2424	164	157	157
   q3	11204	1152	1237	1152
   q4	10552	812	722	722
   q5	7848	3040	3033	3033
   q6	208	130	127	127
   q7	1046	634	603	603
   q8	9705	2039	2025	2025
   q9	7212	6644	6631	6631
   q10	8450	3465	3581	3465
   q11	434	236	220	220
   q12	367	199	195	195
   q13	17799	2869	2909	2869
   q14	229	225	203	203
   q15	499	483	464	464
   q16	496	369	376	369
   q17	962	510	610	510
   q18	7224	6461	6375	6375
   q19	1546	1466	1405	1405
   q20	561	263	281	263
   q21	3692	2975	2923	2923
   q22	349	301	304	301
   Total cold run time: 110722 ms
   Total hot run time: 38219 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4101	4074	4097	4074
   q2	328	235	237	235
   q3	3021	2824	2818	2818
   q4	1855	1534	1569	1534
   q5	5303	5366	5324	5324
   q6	196	121	119	119
   q7	2280	1902	1848	1848
   q8	3206	3288	3306	3288
   q9	8712	8720	8706	8706
   q10	3774	3810	3788	3788
   q11	550	452	430	430
   q12	727	544	547	544
   q13	16862	2842	2851	2842
   q14	288	261	251	251
   q15	503	459	465	459
   q16	469	408	424	408
   q17	1745	1479	1460	1460
   q18	7353	7047	7125	7047
   q19	1615	1528	1475	1475
   q20	1918	1747	1720	1720
   q21	4832	4766	4576	4576
   q22	531	451	451	451
   Total cold run time: 70169 ms
   Total hot run time: 53397 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit bbfab684d920774cc00a855cd2ce4b3ac457e48d with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 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.9 seconds inserted 10000000 Rows, about 719K 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39042 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 212446a13e2fd811ce265e4b8963b645801bee1d, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17755	4104	4113	4104
   q2	2017	194	184	184
   q3	10471	1253	1393	1253
   q4	10365	872	993	872
   q5	7806	2995	2977	2977
   q6	228	137	136	136
   q7	1139	674	634	634
   q8	9842	2101	2090	2090
   q9	6784	6339	6151	6151
   q10	8479	3512	3502	3502
   q11	422	242	234	234
   q12	386	220	219	219
   q13	17787	2911	2917	2911
   q14	270	245	251	245
   q15	536	494	475	475
   q16	511	400	387	387
   q17	959	927	911	911
   q18	7240	6539	6520	6520
   q19	1596	1537	1545	1537
   q20	597	326	310	310
   q21	3499	3104	3095	3095
   q22	360	298	295	295
   Total cold run time: 109049 ms
   Total hot run time: 39042 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4091	4059	4102	4059
   q2	323	214	219	214
   q3	2978	2935	2959	2935
   q4	1895	1844	1853	1844
   q5	5246	5215	5195	5195
   q6	207	125	123	123
   q7	2249	1818	1821	1818
   q8	3204	3268	3283	3268
   q9	8476	8422	8496	8422
   q10	3763	3841	3845	3841
   q11	546	450	454	450
   q12	716	557	559	557
   q13	8362	2908	2873	2873
   q14	307	259	264	259
   q15	517	483	482	482
   q16	473	414	411	411
   q17	1701	1681	1684	1681
   q18	7566	7306	7210	7210
   q19	1638	1647	1640	1640
   q20	1926	1724	1740	1724
   q21	5038	4739	4703	4703
   q22	482	420	420	420
   Total cold run time: 61704 ms
   Total hot run time: 54129 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] [chore](Nereids) turn off fallback [doris]

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

   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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 180701 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 212446a13e2fd811ce265e4b8963b645801bee1d, data reload: false
   
   query1	910	377	361	361
   query2	6468	1884	1798	1798
   query3	6662	213	214	213
   query4	24781	21595	21612	21595
   query5	4200	425	411	411
   query6	270	200	183	183
   query7	4600	319	297	297
   query8	228	176	188	176
   query9	8477	2243	2239	2239
   query10	574	264	276	264
   query11	14954	14378	14474	14378
   query12	159	99	95	95
   query13	1642	381	396	381
   query14	8665	6714	6834	6714
   query15	214	188	186	186
   query16	7160	280	277	277
   query17	1001	616	582	582
   query18	1929	290	288	288
   query19	200	171	168	168
   query20	104	95	96	95
   query21	210	125	132	125
   query22	5018	4858	4856	4856
   query23	33715	32834	32786	32786
   query24	12566	3147	3116	3116
   query25	695	415	414	414
   query26	1909	166	163	163
   query27	3006	330	336	330
   query28	6679	1830	1831	1830
   query29	1383	582	577	577
   query30	305	146	152	146
   query31	971	726	706	706
   query32	95	59	62	59
   query33	719	268	248	248
   query34	1056	495	507	495
   query35	837	702	707	702
   query36	972	847	851	847
   query37	288	74	73	73
   query38	3571	3375	3376	3375
   query39	1581	1536	1507	1507
   query40	286	135	137	135
   query41	47	44	45	44
   query42	114	104	106	104
   query43	434	414	414	414
   query44	1069	708	703	703
   query45	264	259	265	259
   query46	1060	790	785	785
   query47	1891	1778	1773	1773
   query48	377	308	306	306
   query49	1159	373	361	361
   query50	800	394	392	392
   query51	6834	6759	6683	6683
   query52	112	103	97	97
   query53	357	297	284	284
   query54	310	246	238	238
   query55	90	86	81	81
   query56	249	220	222	220
   query57	1217	1105	1127	1105
   query58	252	223	231	223
   query59	2530	2291	2249	2249
   query60	271	242	248	242
   query61	98	96	96	96
   query62	695	457	452	452
   query63	317	285	287	285
   query64	6439	3231	3303	3231
   query65	3085	3010	3031	3010
   query66	1462	338	323	323
   query67	15393	14963	14915	14915
   query68	5079	556	567	556
   query69	498	328	325	325
   query70	1134	1130	1103	1103
   query71	400	293	279	279
   query72	6318	2733	2595	2595
   query73	711	328	332	328
   query74	6614	6322	6240	6240
   query75	2953	2308	2303	2303
   query76	2775	1054	1203	1054
   query77	408	269	253	253
   query78	10693	10145	10090	10090
   query79	7507	526	532	526
   query80	1586	462	461	461
   query81	536	227	227	227
   query82	1380	113	112	112
   query83	308	165	167	165
   query84	276	88	90	88
   query85	1913	289	290	289
   query86	489	315	299	299
   query87	3695	3525	3521	3521
   query88	4320	2282	2267	2267
   query89	500	370	376	370
   query90	1966	183	186	183
   query91	136	109	107	107
   query92	63	51	55	51
   query93	5802	534	540	534
   query94	1220	202	198	198
   query95	448	340	332	332
   query96	608	270	270	270
   query97	2648	2471	2511	2471
   query98	243	220	211	211
   query99	1324	853	827	827
   Total cold run time: 290537 ms
   Total hot run time: 180701 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] [chore](Nereids) turn off fallback [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 0ebcf1b8e601b332a79f9567826dd30835c9f56c 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:       17.8 seconds inserted 10000000 Rows, about 561K 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] [chore](Nereids) turn off fallback [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 181769 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 09ef7fc5ac5a0fc7658b6a432504e4296cf2f944, data reload: false
   
   query1	1243	1132	1109	1109
   query2	6480	2010	1950	1950
   query3	6645	205	209	205
   query4	37710	21516	21355	21355
   query5	4143	409	400	400
   query6	236	181	175	175
   query7	4049	304	283	283
   query8	223	174	188	174
   query9	5725	2308	2293	2293
   query10	528	246	246	246
   query11	14749	14207	14177	14177
   query12	146	88	88	88
   query13	1003	366	355	355
   query14	10202	6967	6747	6747
   query15	200	184	180	180
   query16	6734	274	263	263
   query17	1557	577	560	560
   query18	1375	283	275	275
   query19	196	153	153	153
   query20	97	86	87	86
   query21	201	127	125	125
   query22	4949	4792	4784	4784
   query23	33683	33030	32952	32952
   query24	12378	2982	2875	2875
   query25	579	378	385	378
   query26	1677	159	156	156
   query27	3098	306	316	306
   query28	7400	1892	1892	1892
   query29	868	622	604	604
   query30	302	161	164	161
   query31	948	721	714	714
   query32	63	58	54	54
   query33	590	252	246	246
   query34	876	465	493	465
   query35	838	686	675	675
   query36	1008	874	899	874
   query37	232	73	71	71
   query38	3555	3456	3391	3391
   query39	1579	1531	1523	1523
   query40	277	130	137	130
   query41	52	52	45	45
   query42	106	95	93	93
   query43	485	459	485	459
   query44	1417	710	706	706
   query45	263	284	264	264
   query46	1062	718	714	714
   query47	1896	1841	1867	1841
   query48	364	296	275	275
   query49	1133	364	356	356
   query50	748	373	366	366
   query51	6709	6683	6536	6536
   query52	102	90	93	90
   query53	359	278	285	278
   query54	262	236	236	236
   query55	77	70	71	70
   query56	240	225	211	211
   query57	1182	1160	1105	1105
   query58	222	199	200	199
   query59	2926	2703	2808	2703
   query60	252	234	244	234
   query61	93	93	90	90
   query62	633	434	456	434
   query63	309	274	276	274
   query64	4889	3942	3929	3929
   query65	3111	3070	3037	3037
   query66	1371	330	315	315
   query67	15233	14763	14804	14763
   query68	7218	536	546	536
   query69	527	312	312	312
   query70	1275	1153	1112	1112
   query71	487	279	268	268
   query72	6463	2678	2550	2550
   query73	826	316	318	316
   query74	6895	6367	6401	6367
   query75	3217	2389	2368	2368
   query76	4217	1084	1101	1084
   query77	674	253	251	251
   query78	10975	10137	10213	10137
   query79	7397	538	518	518
   query80	2015	429	426	426
   query81	538	238	242	238
   query82	1437	101	95	95
   query83	326	164	172	164
   query84	276	86	90	86
   query85	1622	309	306	306
   query86	472	305	318	305
   query87	3789	3567	3533	3533
   query88	6045	2293	2297	2293
   query89	492	364	377	364
   query90	1939	180	180	180
   query91	121	95	98	95
   query92	64	48	47	47
   query93	6121	500	488	488
   query94	1264	176	176	176
   query95	391	321	309	309
   query96	593	265	259	259
   query97	2667	2467	2466	2466
   query98	235	223	211	211
   query99	1211	836	844	836
   Total cold run time: 305627 ms
   Total hot run time: 181769 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