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

[PR] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   ## 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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.78 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 d5d4f782c688b987c6df42f9e95b9f0221b102d1, data reload: false
   
   query1	0.04	0.02	0.03
   query2	0.06	0.02	0.02
   query3	0.23	0.07	0.06
   query4	1.65	0.10	0.10
   query5	0.53	0.51	0.52
   query6	1.20	0.64	0.63
   query7	0.02	0.02	0.01
   query8	0.03	0.02	0.03
   query9	0.54	0.49	0.51
   query10	0.58	0.54	0.55
   query11	0.12	0.08	0.08
   query12	0.11	0.09	0.10
   query13	0.61	0.60	0.60
   query14	0.78	0.83	0.81
   query15	0.81	0.78	0.78
   query16	0.39	0.37	0.39
   query17	0.98	0.98	1.02
   query18	0.22	0.23	0.27
   query19	1.90	1.75	1.78
   query20	0.02	0.01	0.01
   query21	15.43	0.57	0.57
   query22	2.88	2.87	1.60
   query23	17.40	0.86	0.92
   query24	2.81	0.95	1.15
   query25	0.24	0.17	0.19
   query26	0.62	0.14	0.14
   query27	0.05	0.06	0.04
   query28	11.88	0.86	0.83
   query29	12.52	3.15	3.07
   query30	0.61	0.54	0.56
   query31	2.79	0.36	0.35
   query32	3.32	0.47	0.48
   query33	3.25	3.22	3.23
   query34	16.00	4.25	4.33
   query35	4.31	4.31	4.32
   query36	1.10	1.05	1.05
   query37	0.08	0.05	0.05
   query38	0.04	0.03	0.03
   query39	0.02	0.01	0.02
   query40	0.16	0.13	0.13
   query41	0.07	0.02	0.01
   query42	0.02	0.02	0.01
   query43	0.03	0.02	0.02
   Total cold run time: 106.45 s
   Total hot run time: 30.78 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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   run pipelinex_p0


-- 
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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 14667e1b8e14aafddd8e33bd057dd63d0c796252 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:      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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   run pipelinex_p0


-- 
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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 175847 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 d5d4f782c688b987c6df42f9e95b9f0221b102d1, data reload: false
   
   query1	929	371	353	353
   query2	6522	2033	1956	1956
   query3	6698	200	201	200
   query4	31941	22206	22254	22206
   query5	4165	397	377	377
   query6	265	155	153	153
   query7	4615	272	263	263
   query8	243	174	178	174
   query9	9097	2268	2247	2247
   query10	410	204	204	204
   query11	18987	15596	15550	15550
   query12	127	69	69	69
   query13	1622	379	387	379
   query14	9380	6921	7019	6921
   query15	216	178	176	176
   query16	7807	262	250	250
   query17	1873	510	467	467
   query18	2029	273	259	259
   query19	176	139	129	129
   query20	72	66	72	66
   query21	202	139	140	139
   query22	4917	4739	4732	4732
   query23	31477	30402	30400	30400
   query24	11872	2729	2794	2729
   query25	570	314	317	314
   query26	1677	140	140	140
   query27	2718	295	287	287
   query28	7520	1843	1824	1824
   query29	2022	646	611	611
   query30	299	144	144	144
   query31	942	713	696	696
   query32	95	54	47	47
   query33	720	204	216	204
   query34	1099	480	468	468
   query35	872	764	767	764
   query36	1289	1211	1161	1161
   query37	179	58	59	58
   query38	3223	3162	3164	3162
   query39	1305	1272	1256	1256
   query40	336	85	88	85
   query41	37	35	35	35
   query42	91	87	85	85
   query43	520	479	487	479
   query44	1086	686	685	685
   query45	194	186	183	183
   query46	1065	629	644	629
   query47	1645	1506	1456	1456
   query48	423	310	337	310
   query49	1250	293	288	288
   query50	716	314	306	306
   query51	5327	5200	5169	5169
   query52	88	82	77	77
   query53	324	271	266	266
   query54	270	180	188	180
   query55	82	79	81	79
   query56	180	161	170	161
   query57	1011	901	897	897
   query58	194	164	177	164
   query59	2391	2361	2324	2324
   query60	208	183	175	175
   query61	83	86	83	83
   query62	674	376	348	348
   query63	279	266	266	266
   query64	6159	3752	3502	3502
   query65	3361	3292	3285	3285
   query66	1400	312	305	305
   query67	14581	14272	14154	14154
   query68	4276	504	515	504
   query69	446	314	299	299
   query70	1474	1513	1524	1513
   query71	308	217	214	214
   query72	5714	3137	2815	2815
   query73	695	319	321	319
   query74	6760	6264	6189	6189
   query75	3081	2391	2314	2314
   query76	2497	903	931	903
   query77	346	229	227	227
   query78	9566	9052	8782	8782
   query79	3055	513	515	513
   query80	2230	317	309	309
   query81	533	211	214	211
   query82	807	89	81	81
   query83	262	114	119	114
   query84	287	72	80	72
   query85	2435	339	317	317
   query86	512	389	410	389
   query87	3388	3197	3167	3167
   query88	4242	2170	2160	2160
   query89	438	357	363	357
   query90	1949	187	183	183
   query91	151	118	119	118
   query92	67	44	43	43
   query93	5018	434	422	422
   query94	1395	166	159	159
   query95	462	352	362	352
   query96	664	316	306	306
   query97	4297	4145	4158	4145
   query98	221	197	183	183
   query99	1156	705	656	656
   Total cold run time: 292879 ms
   Total hot run time: 175847 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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 175330 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 14667e1b8e14aafddd8e33bd057dd63d0c796252, data reload: false
   
   query1	921	335	327	327
   query2	6575	1963	1856	1856
   query3	6700	202	197	197
   query4	31872	22042	21969	21969
   query5	4095	320	323	320
   query6	254	162	154	154
   query7	4689	254	254	254
   query8	236	173	181	173
   query9	8941	2274	2257	2257
   query10	405	192	205	192
   query11	18249	15380	15470	15380
   query12	121	66	69	66
   query13	1628	383	374	374
   query14	8684	7005	7072	7005
   query15	241	171	179	171
   query16	7883	267	253	253
   query17	1865	498	479	479
   query18	2025	249	257	249
   query19	282	133	129	129
   query20	74	68	66	66
   query21	198	130	128	128
   query22	4893	4674	4676	4674
   query23	31149	30458	30394	30394
   query24	7139	2808	2761	2761
   query25	533	320	312	312
   query26	712	143	141	141
   query27	1985	289	281	281
   query28	3680	1860	1832	1832
   query29	912	615	615	615
   query30	283	132	135	132
   query31	915	713	712	712
   query32	94	53	46	46
   query33	530	213	206	206
   query34	1604	461	484	461
   query35	891	818	806	806
   query36	1400	1317	1279	1279
   query37	100	63	68	63
   query38	3463	3259	3245	3245
   query39	1336	1308	1322	1308
   query40	208	91	85	85
   query41	40	37	38	37
   query42	98	84	87	84
   query43	541	524	523	523
   query44	1058	719	719	719
   query45	205	196	192	192
   query46	1074	650	645	645
   query47	1780	1673	1496	1496
   query48	372	304	298	298
   query49	1112	279	280	279
   query50	702	314	319	314
   query51	5381	5235	5173	5173
   query52	98	78	76	76
   query53	326	255	261	255
   query54	216	176	188	176
   query55	82	77	90	77
   query56	178	177	154	154
   query57	960	895	914	895
   query58	188	159	158	158
   query59	2333	2317	2374	2317
   query60	583	202	170	170
   query61	89	81	81	81
   query62	723	361	353	353
   query63	284	260	260	260
   query64	4465	3717	3367	3367
   query65	3258	3244	3210	3210
   query66	930	318	312	312
   query67	14550	14256	14166	14166
   query68	5431	495	483	483
   query69	472	313	292	292
   query70	1614	1578	1585	1578
   query71	326	233	213	213
   query72	6209	3156	2855	2855
   query73	678	310	306	306
   query74	6678	6178	6234	6178
   query75	3053	2292	2352	2292
   query76	2999	932	904	904
   query77	378	227	228	227
   query78	9326	8690	8591	8591
   query79	2246	510	498	498
   query80	1041	319	312	312
   query81	535	194	192	192
   query82	962	85	81	81
   query83	226	109	121	109
   query84	233	81	69	69
   query85	2046	341	336	336
   query86	523	387	429	387
   query87	3356	3247	3232	3232
   query88	3925	2152	2157	2152
   query89	421	354	371	354
   query90	1900	188	186	186
   query91	152	115	118	115
   query92	54	43	43	43
   query93	2726	456	412	412
   query94	1365	161	156	156
   query95	479	354	345	345
   query96	627	321	320	320
   query97	4251	4096	4082	4082
   query98	203	201	181	181
   query99	995	710	710	710
   Total cold run time: 274821 ms
   Total hot run time: 175330 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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.47 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 14667e1b8e14aafddd8e33bd057dd63d0c796252, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.07	0.03	0.02
   query3	0.24	0.06	0.06
   query4	1.65	0.10	0.09
   query5	0.52	0.51	0.52
   query6	1.18	0.63	0.64
   query7	0.01	0.01	0.01
   query8	0.03	0.02	0.02
   query9	0.55	0.49	0.50
   query10	0.57	0.55	0.55
   query11	0.12	0.08	0.09
   query12	0.11	0.08	0.09
   query13	0.60	0.58	0.62
   query14	0.79	0.78	0.79
   query15	0.79	0.77	0.78
   query16	0.38	0.37	0.40
   query17	1.04	1.03	0.96
   query18	0.24	0.28	0.24
   query19	1.80	1.79	1.77
   query20	0.01	0.01	0.01
   query21	15.40	0.57	0.57
   query22	2.64	2.63	2.39
   query23	17.24	0.75	0.86
   query24	2.68	1.54	0.89
   query25	0.30	0.26	0.15
   query26	0.51	0.13	0.15
   query27	0.05	0.04	0.05
   query28	11.29	0.84	0.84
   query29	12.70	3.16	3.21
   query30	0.55	0.51	0.52
   query31	2.79	0.35	0.35
   query32	3.33	0.48	0.49
   query33	3.22	3.22	3.20
   query34	15.89	4.29	4.32
   query35	4.31	4.35	4.40
   query36	1.10	1.06	1.07
   query37	0.06	0.04	0.04
   query38	0.04	0.03	0.03
   query39	0.02	0.02	0.02
   query40	0.16	0.13	0.13
   query41	0.07	0.01	0.02
   query42	0.02	0.01	0.02
   query43	0.03	0.02	0.02
   Total cold run time: 105.14 s
   Total hot run time: 31.47 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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 36601 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 14667e1b8e14aafddd8e33bd057dd63d0c796252, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17662	4474	4424	4424
   q2	2036	138	128	128
   q3	10685	909	928	909
   q4	4640	659	701	659
   q5	7673	2740	2718	2718
   q6	184	120	120	120
   q7	1123	713	711	711
   q8	9273	1990	1996	1990
   q9	7229	6312	6265	6265
   q10	8118	2383	2405	2383
   q11	410	211	209	209
   q12	823	277	279	277
   q13	18003	3308	3310	3308
   q14	271	247	242	242
   q15	520	499	484	484
   q16	496	397	400	397
   q17	927	618	479	479
   q18	6721	5941	5896	5896
   q19	1544	1360	1420	1360
   q20	568	318	336	318
   q21	6706	3069	3037	3037
   q22	812	300	287	287
   Total cold run time: 106424 ms
   Total hot run time: 36601 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4486	4321	4417	4321
   q2	333	237	223	223
   q3	2964	2833	2805	2805
   q4	1873	1676	1581	1581
   q5	5090	5210	5207	5207
   q6	194	115	115	115
   q7	2180	1775	1768	1768
   q8	3103	3218	3250	3218
   q9	8236	8270	8300	8270
   q10	5910	3569	3558	3558
   q11	552	462	467	462
   q12	752	576	568	568
   q13	11628	3097	3044	3044
   q14	282	268	260	260
   q15	536	482	487	482
   q16	520	447	463	447
   q17	1838	1735	1700	1700
   q18	7788	7770	7510	7510
   q19	10231	1571	1545	1545
   q20	2131	1930	1906	1906
   q21	4808	4679	4602	4602
   q22	568	474	523	474
   Total cold run time: 76003 ms
   Total hot run time: 54066 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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   run pipelinx_p0


-- 
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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   run pipelinx_p0


-- 
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] [runtimefilter](nereids)push down RF into cte producer [doris]

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


-- 
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] [runtimefilter](nereids)push down RF into cte producer [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37024 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 d5d4f782c688b987c6df42f9e95b9f0221b102d1, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17728	4571	4471	4471
   q2	2602	139	131	131
   q3	11866	932	938	932
   q4	4961	749	734	734
   q5	8027	2829	2740	2740
   q6	183	120	121	120
   q7	1149	714	705	705
   q8	9240	1990	1996	1990
   q9	7246	6362	6308	6308
   q10	8132	2453	2416	2416
   q11	420	198	195	195
   q12	778	275	273	273
   q13	18008	3313	3289	3289
   q14	285	252	263	252
   q15	531	492	482	482
   q16	463	404	408	404
   q17	937	479	513	479
   q18	6859	6087	6037	6037
   q19	1599	1447	1380	1380
   q20	625	360	321	321
   q21	7019	3064	3057	3057
   q22	823	321	308	308
   Total cold run time: 109481 ms
   Total hot run time: 37024 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4433	4305	4396	4305
   q2	320	238	228	228
   q3	2978	2889	2822	2822
   q4	1834	1626	1572	1572
   q5	5187	5252	5257	5252
   q6	189	114	115	114
   q7	2138	1822	1784	1784
   q8	3074	3209	3262	3209
   q9	8327	8327	8262	8262
   q10	5928	3565	3554	3554
   q11	538	467	453	453
   q12	745	577	580	577
   q13	15493	3069	3085	3069
   q14	286	251	261	251
   q15	530	492	485	485
   q16	527	469	468	468
   q17	1815	1681	1749	1681
   q18	7837	7793	7746	7746
   q19	6940	1502	1547	1502
   q20	2122	1930	1903	1903
   q21	4785	4502	4539	4502
   q22	558	474	458	458
   Total cold run time: 76584 ms
   Total hot run time: 54197 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