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

[PR] [enhance](mtmv)show create materialized view [doris]

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

   - support show create materialized view
   - fix MTMV not have default duplicate key
   
   


-- 
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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39623 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 2101467e8533d350584a0c4c2ad4528dac9efcd4, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17619	4278	4292	4278
   q2	2016	188	192	188
   q3	10453	1151	1162	1151
   q4	10199	776	749	749
   q5	7480	2673	2642	2642
   q6	218	136	135	135
   q7	961	606	592	592
   q8	9228	2062	2044	2044
   q9	8931	6497	6458	6458
   q10	8970	3680	3724	3680
   q11	467	244	244	244
   q12	481	234	225	225
   q13	17817	2959	2986	2959
   q14	269	216	219	216
   q15	519	503	479	479
   q16	507	377	381	377
   q17	957	586	615	586
   q18	7921	7334	7273	7273
   q19	3574	1522	1502	1502
   q20	651	309	324	309
   q21	4882	3204	3214	3204
   q22	387	337	332	332
   Total cold run time: 114507 ms
   Total hot run time: 39623 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4296	4205	4166	4166
   q2	385	273	264	264
   q3	2919	2732	2733	2732
   q4	2039	1692	1730	1692
   q5	5490	5637	5482	5482
   q6	225	132	132	132
   q7	2188	1836	1791	1791
   q8	3318	3462	3395	3395
   q9	8663	8675	8717	8675
   q10	4113	3789	3932	3789
   q11	571	496	490	490
   q12	761	608	572	572
   q13	17044	3197	3178	3178
   q14	322	271	274	271
   q15	530	485	492	485
   q16	510	428	433	428
   q17	1809	1492	1560	1492
   q18	8080	7967	7810	7810
   q19	2124	1627	1707	1627
   q20	2110	1900	1894	1894
   q21	7020	4937	4914	4914
   q22	632	522	532	522
   Total cold run time: 75149 ms
   Total hot run time: 55801 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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39862 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 51398770f37e6becf4cf3cfdb66ab128c3f47402, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17624	4308	4281	4281
   q2	2023	190	199	190
   q3	10458	1113	1223	1113
   q4	10183	858	774	774
   q5	7461	2599	2605	2599
   q6	223	139	137	137
   q7	964	613	593	593
   q8	9231	2052	2078	2052
   q9	8893	6485	6500	6485
   q10	8837	3754	3711	3711
   q11	450	244	234	234
   q12	413	245	219	219
   q13	17762	2976	2973	2973
   q14	274	225	229	225
   q15	522	469	475	469
   q16	516	389	375	375
   q17	962	667	767	667
   q18	8064	7672	7342	7342
   q19	6368	1553	1564	1553
   q20	651	320	325	320
   q21	4933	3214	3220	3214
   q22	416	337	336	336
   Total cold run time: 117228 ms
   Total hot run time: 39862 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4345	4218	4229	4218
   q2	379	278	275	275
   q3	3011	2800	2723	2723
   q4	1882	1571	1608	1571
   q5	5239	5260	5259	5259
   q6	219	127	129	127
   q7	2105	1761	1771	1761
   q8	3183	3296	3315	3296
   q9	8363	8319	8357	8319
   q10	3905	3659	3679	3659
   q11	614	496	486	486
   q12	784	632	593	593
   q13	16392	2997	3065	2997
   q14	284	261	259	259
   q15	525	480	474	474
   q16	467	433	431	431
   q17	1798	1512	1470	1470
   q18	7721	7439	7322	7322
   q19	1710	1648	1690	1648
   q20	2009	1810	1783	1783
   q21	4914	4827	4793	4793
   q22	624	528	563	528
   Total cold run time: 70473 ms
   Total hot run time: 53992 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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 173591 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 51398770f37e6becf4cf3cfdb66ab128c3f47402, data reload: false
   
   query1	938	393	380	380
   query2	6446	2517	2268	2268
   query3	6653	211	214	211
   query4	19215	17373	17428	17373
   query5	4153	473	454	454
   query6	247	167	161	161
   query7	4597	311	298	298
   query8	313	304	307	304
   query9	8668	2373	2357	2357
   query10	625	313	294	294
   query11	10530	10114	10196	10114
   query12	143	87	85	85
   query13	1656	367	363	363
   query14	9954	7463	7862	7463
   query15	220	186	189	186
   query16	7502	272	271	271
   query17	1890	535	546	535
   query18	1226	276	280	276
   query19	197	157	153	153
   query20	90	88	85	85
   query21	216	135	122	122
   query22	4296	4085	4024	4024
   query23	33708	33169	33000	33000
   query24	11997	2792	2796	2792
   query25	674	351	363	351
   query26	1635	158	151	151
   query27	2687	330	321	321
   query28	6705	2033	2027	2027
   query29	1004	638	616	616
   query30	288	151	159	151
   query31	942	720	763	720
   query32	90	56	57	56
   query33	763	288	296	288
   query34	934	473	469	469
   query35	740	676	636	636
   query36	1084	893	904	893
   query37	187	71	76	71
   query38	2856	2765	2716	2716
   query39	840	805	814	805
   query40	279	127	123	123
   query41	50	47	54	47
   query42	118	99	104	99
   query43	608	532	544	532
   query44	1204	729	745	729
   query45	195	167	167	167
   query46	1082	731	742	731
   query47	1855	1750	1785	1750
   query48	376	298	303	298
   query49	1181	412	400	400
   query50	773	385	385	385
   query51	6736	6837	6719	6719
   query52	115	98	99	98
   query53	362	288	290	288
   query54	1069	453	442	442
   query55	78	77	79	77
   query56	277	299	273	273
   query57	1230	1060	1098	1060
   query58	264	250	277	250
   query59	3748	3426	3312	3312
   query60	289	280	280	280
   query61	90	93	90	90
   query62	640	433	447	433
   query63	315	287	291	287
   query64	9921	2325	1715	1715
   query65	3204	3111	3145	3111
   query66	1242	340	337	337
   query67	15372	14975	14868	14868
   query68	5809	567	559	559
   query69	555	451	391	391
   query70	1192	1139	1063	1063
   query71	431	272	278	272
   query72	7524	5265	5344	5265
   query73	775	328	331	328
   query74	5891	5479	5544	5479
   query75	3556	2669	2751	2669
   query76	3678	915	964	915
   query77	645	308	300	300
   query78	10400	9844	9886	9844
   query79	1833	526	528	526
   query80	1216	466	462	462
   query81	536	220	225	220
   query82	707	111	118	111
   query83	195	171	166	166
   query84	272	90	86	86
   query85	1438	290	326	290
   query86	470	324	319	319
   query87	3304	3079	3139	3079
   query88	3869	2487	2432	2432
   query89	475	400	377	377
   query90	1819	197	195	195
   query91	127	98	100	98
   query92	67	49	51	49
   query93	1750	518	507	507
   query94	1175	198	189	189
   query95	406	311	324	311
   query96	588	269	277	269
   query97	3249	3069	3053	3053
   query98	224	201	193	193
   query99	1196	873	833	833
   Total cold run time: 274954 ms
   Total hot run time: 173591 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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.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 19cd0df0255afd772a3a10ebb55ea6f01530560e, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.08	0.03	0.03
   query3	0.23	0.06	0.04
   query4	1.66	0.06	0.06
   query5	0.48	0.49	0.49
   query6	1.12	0.71	0.72
   query7	0.02	0.01	0.02
   query8	0.06	0.04	0.03
   query9	0.54	0.50	0.50
   query10	0.55	0.55	0.54
   query11	0.15	0.11	0.11
   query12	0.15	0.11	0.11
   query13	0.59	0.59	0.62
   query14	0.76	0.80	0.78
   query15	0.83	0.81	0.81
   query16	0.37	0.37	0.38
   query17	1.05	1.02	0.97
   query18	0.21	0.26	0.26
   query19	1.79	1.79	1.72
   query20	0.01	0.02	0.01
   query21	15.41	0.66	0.65
   query22	4.33	7.00	1.81
   query23	18.28	1.39	1.30
   query24	2.18	0.22	0.21
   query25	0.14	0.09	0.09
   query26	0.28	0.17	0.18
   query27	0.08	0.08	0.07
   query28	13.24	1.02	1.00
   query29	12.64	3.24	3.21
   query30	0.25	0.06	0.06
   query31	2.84	0.39	0.38
   query32	3.28	0.47	0.48
   query33	2.85	2.87	2.89
   query34	17.23	4.37	4.41
   query35	4.50	4.52	4.53
   query36	0.66	0.46	0.47
   query37	0.18	0.16	0.15
   query38	0.15	0.15	0.15
   query39	0.05	0.04	0.04
   query40	0.17	0.14	0.14
   query41	0.10	0.04	0.04
   query42	0.06	0.05	0.04
   query43	0.04	0.04	0.04
   Total cold run time: 109.63 s
   Total hot run time: 30.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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 173639 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 2101467e8533d350584a0c4c2ad4528dac9efcd4, data reload: false
   
   query1	915	390	376	376
   query2	6444	2402	2375	2375
   query3	6641	203	206	203
   query4	20192	17100	17077	17077
   query5	3585	482	480	480
   query6	237	154	157	154
   query7	4579	298	293	293
   query8	336	291	280	280
   query9	8549	2377	2360	2360
   query10	551	294	281	281
   query11	10371	10006	9958	9958
   query12	132	87	84	84
   query13	1633	362	370	362
   query14	9321	7143	7707	7143
   query15	237	193	181	181
   query16	7706	264	279	264
   query17	1382	558	511	511
   query18	1939	271	267	267
   query19	206	153	158	153
   query20	91	85	86	85
   query21	206	133	124	124
   query22	4184	3965	4000	3965
   query23	33605	33886	33775	33775
   query24	11248	2886	2936	2886
   query25	587	377	363	363
   query26	715	164	156	156
   query27	2322	319	325	319
   query28	5885	2125	2109	2109
   query29	889	637	648	637
   query30	259	154	156	154
   query31	959	777	745	745
   query32	98	55	52	52
   query33	684	291	288	288
   query34	901	478	485	478
   query35	745	666	649	649
   query36	1122	977	973	973
   query37	141	76	74	74
   query38	2971	2828	2823	2823
   query39	881	848	879	848
   query40	214	132	141	132
   query41	55	55	49	49
   query42	122	100	101	100
   query43	561	556	559	556
   query44	1105	719	727	719
   query45	201	166	163	163
   query46	1056	745	719	719
   query47	1859	1781	1767	1767
   query48	367	300	292	292
   query49	845	409	412	409
   query50	780	388	408	388
   query51	6745	6688	6799	6688
   query52	108	96	93	93
   query53	364	291	284	284
   query54	889	449	435	435
   query55	74	74	74	74
   query56	285	263	273	263
   query57	1128	1054	1060	1054
   query58	264	238	262	238
   query59	3331	3256	3201	3201
   query60	315	283	294	283
   query61	128	113	111	111
   query62	654	441	439	439
   query63	313	285	285	285
   query64	8500	2185	1744	1744
   query65	3203	3090	3075	3075
   query66	740	323	350	323
   query67	15391	14808	14733	14733
   query68	4528	542	541	541
   query69	506	453	350	350
   query70	1180	1149	1112	1112
   query71	402	337	285	285
   query72	7016	5953	5404	5404
   query73	750	322	326	322
   query74	5886	5460	5558	5460
   query75	3439	2697	2702	2697
   query76	2538	948	889	889
   query77	435	312	302	302
   query78	10327	9765	9811	9765
   query79	2013	520	526	520
   query80	2287	465	473	465
   query81	596	225	225	225
   query82	1116	102	102	102
   query83	311	169	168	168
   query84	266	90	84	84
   query85	1165	288	276	276
   query86	462	309	308	308
   query87	3262	3096	3042	3042
   query88	2982	2346	2346	2346
   query89	456	375	382	375
   query90	1672	194	192	192
   query91	132	105	101	101
   query92	58	50	49	49
   query93	1920	512	512	512
   query94	1081	194	189	189
   query95	406	334	402	334
   query96	580	272	262	262
   query97	3220	3026	3036	3026
   query98	216	206	194	194
   query99	1177	820	844	820
   Total cold run time: 265431 ms
   Total hot run time: 173639 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] [enhance](mtmv)show create materialized view [doris]

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

   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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39860 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 53b09dded645b522e0f95759b637a0ac8b6166d7, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17917	4517	4380	4380
   q2	2333	183	190	183
   q3	10481	1103	1112	1103
   q4	10202	736	785	736
   q5	7545	2693	2630	2630
   q6	222	138	135	135
   q7	948	602	586	586
   q8	9220	2060	2079	2060
   q9	8819	6478	6479	6478
   q10	9001	3719	3725	3719
   q11	442	232	231	231
   q12	443	229	227	227
   q13	17757	2948	2969	2948
   q14	265	221	222	221
   q15	516	472	465	465
   q16	482	373	373	373
   q17	968	616	729	616
   q18	8001	7484	7385	7385
   q19	5059	1511	1510	1510
   q20	642	303	313	303
   q21	4914	3242	3859	3242
   q22	384	329	334	329
   Total cold run time: 116561 ms
   Total hot run time: 39860 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4384	4200	4277	4200
   q2	371	270	272	270
   q3	2938	2760	2660	2660
   q4	1881	1564	1667	1564
   q5	5229	5233	5296	5233
   q6	211	127	126	126
   q7	2060	1738	1732	1732
   q8	3185	3326	3330	3326
   q9	8326	8283	8337	8283
   q10	3879	3702	3639	3639
   q11	577	475	512	475
   q12	754	585	624	585
   q13	16378	2945	2972	2945
   q14	308	257	257	257
   q15	512	474	483	474
   q16	453	407	407	407
   q17	1773	1484	1466	1466
   q18	7718	7497	7315	7315
   q19	1711	1634	1588	1588
   q20	1944	1794	1771	1771
   q21	4868	4767	4631	4631
   q22	611	544	536	536
   Total cold run time: 70071 ms
   Total hot run time: 53483 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] [enhance](mtmv)show create materialized view [doris]

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

   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] [enhance](mtmv)show create materialized view [doris]

Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on code in PR #36188:
URL: https://github.com/apache/doris/pull/36188#discussion_r1636203764


##########
fe/fe-core/src/main/cup/sql_parser.cup:
##########
@@ -4278,6 +4278,10 @@ show_param ::=
     {:
         RESULT = new ShowCreateTableStmt(table, true, false);
     :}
+    | KW_CREATE KW_MATERIALIZED KW_VIEW table_name:table
+    {:
+        RESULT = new ShowCreateMTMVStmt(table);
+    :}

Review Comment:
   impl it in Nereids?



-- 
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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 171651 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 19cd0df0255afd772a3a10ebb55ea6f01530560e, data reload: false
   
   query1	806	385	381	381
   query2	6389	2341	2391	2341
   query3	6411	209	221	209
   query4	18960	17488	17358	17358
   query5	3722	464	470	464
   query6	251	160	159	159
   query7	4453	296	293	293
   query8	300	291	297	291
   query9	8284	2359	2340	2340
   query10	552	289	270	270
   query11	10549	9995	9920	9920
   query12	134	87	85	85
   query13	1570	364	373	364
   query14	10012	6166	7113	6166
   query15	228	194	186	186
   query16	7272	266	272	266
   query17	1389	575	556	556
   query18	1920	268	272	268
   query19	190	156	154	154
   query20	90	79	78	78
   query21	208	126	126	126
   query22	4302	4102	3933	3933
   query23	33445	33382	33580	33382
   query24	8055	2806	2888	2806
   query25	605	357	345	345
   query26	705	147	146	146
   query27	2222	316	323	316
   query28	5670	2028	2031	2028
   query29	874	640	609	609
   query30	240	147	150	147
   query31	955	738	724	724
   query32	93	53	57	53
   query33	659	276	268	268
   query34	872	477	465	465
   query35	704	622	601	601
   query36	1084	934	929	929
   query37	135	65	70	65
   query38	2867	2679	2695	2679
   query39	865	789	816	789
   query40	201	124	128	124
   query41	55	51	55	51
   query42	119	99	94	94
   query43	593	545	543	543
   query44	1077	739	736	736
   query45	191	164	166	164
   query46	1071	714	699	699
   query47	1836	1740	1780	1740
   query48	365	300	291	291
   query49	877	433	392	392
   query50	761	382	374	374
   query51	6642	6704	6609	6609
   query52	99	91	91	91
   query53	348	284	279	279
   query54	724	477	447	447
   query55	73	73	82	73
   query56	276	263	259	259
   query57	1118	1036	1016	1016
   query58	254	233	255	233
   query59	3449	3214	3269	3214
   query60	294	266	268	266
   query61	93	95	89	89
   query62	604	452	448	448
   query63	317	282	288	282
   query64	8589	2245	1795	1795
   query65	3158	3101	3108	3101
   query66	904	322	335	322
   query67	15213	14934	14894	14894
   query68	4469	553	540	540
   query69	455	288	290	288
   query70	1158	1150	1123	1123
   query71	372	275	272	272
   query72	7121	5395	5284	5284
   query73	742	329	324	324
   query74	5923	5489	5493	5489
   query75	3402	2700	2656	2656
   query76	2252	966	918	918
   query77	450	294	288	288
   query78	10330	9917	9682	9682
   query79	2671	502	497	497
   query80	1233	476	448	448
   query81	590	221	226	221
   query82	787	100	102	100
   query83	222	165	167	165
   query84	240	85	83	83
   query85	1644	279	271	271
   query86	517	311	308	308
   query87	3264	3079	3053	3053
   query88	4302	2440	2464	2440
   query89	463	389	373	373
   query90	1909	188	186	186
   query91	122	100	106	100
   query92	61	54	46	46
   query93	2125	502	503	502
   query94	1259	182	257	182
   query95	402	315	305	305
   query96	599	275	274	274
   query97	3163	3029	3052	3029
   query98	214	208	196	196
   query99	1172	836	822	822
   Total cold run time: 260976 ms
   Total hot run time: 171651 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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.34 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 51398770f37e6becf4cf3cfdb66ab128c3f47402, data reload: false
   
   query1	0.04	0.04	0.04
   query2	0.08	0.04	0.04
   query3	0.24	0.06	0.06
   query4	1.64	0.09	0.10
   query5	0.52	0.50	0.51
   query6	1.13	0.73	0.72
   query7	0.02	0.01	0.01
   query8	0.05	0.05	0.05
   query9	0.54	0.49	0.48
   query10	0.54	0.54	0.53
   query11	0.16	0.12	0.12
   query12	0.16	0.12	0.13
   query13	0.60	0.58	0.61
   query14	0.78	0.80	0.77
   query15	0.83	0.83	0.82
   query16	0.39	0.37	0.37
   query17	1.06	0.99	0.98
   query18	0.23	0.24	0.25
   query19	1.81	1.77	1.72
   query20	0.02	0.01	0.01
   query21	15.43	0.66	0.65
   query22	4.54	6.05	2.52
   query23	18.33	1.38	1.30
   query24	2.19	0.22	0.23
   query25	0.15	0.09	0.09
   query26	0.27	0.17	0.17
   query27	0.07	0.07	0.09
   query28	13.16	1.02	1.01
   query29	12.62	3.36	3.38
   query30	0.26	0.06	0.07
   query31	2.90	0.39	0.39
   query32	3.24	0.47	0.47
   query33	2.92	2.93	2.89
   query34	17.18	4.37	4.42
   query35	4.49	4.53	4.46
   query36	0.65	0.47	0.46
   query37	0.18	0.16	0.16
   query38	0.15	0.14	0.15
   query39	0.05	0.04	0.04
   query40	0.18	0.14	0.14
   query41	0.09	0.04	0.04
   query42	0.06	0.04	0.05
   query43	0.04	0.04	0.04
   Total cold run time: 109.99 s
   Total hot run time: 31.34 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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.89 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 53b09dded645b522e0f95759b637a0ac8b6166d7, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.09	0.04	0.04
   query3	0.24	0.06	0.06
   query4	1.66	0.08	0.08
   query5	0.50	0.47	0.48
   query6	1.13	0.72	0.74
   query7	0.03	0.02	0.01
   query8	0.06	0.04	0.04
   query9	0.54	0.48	0.48
   query10	0.55	0.54	0.53
   query11	0.15	0.11	0.11
   query12	0.15	0.12	0.12
   query13	0.59	0.59	0.60
   query14	0.78	0.81	0.78
   query15	0.84	0.81	0.81
   query16	0.37	0.37	0.37
   query17	1.04	1.03	1.03
   query18	0.24	0.23	0.24
   query19	1.76	1.69	1.67
   query20	0.01	0.00	0.01
   query21	15.43	0.66	0.65
   query22	4.38	6.80	2.18
   query23	18.23	1.47	1.31
   query24	2.16	0.22	0.21
   query25	0.15	0.08	0.08
   query26	0.26	0.18	0.17
   query27	0.09	0.08	0.09
   query28	13.25	1.01	0.99
   query29	12.65	3.29	3.29
   query30	0.26	0.07	0.05
   query31	2.88	0.39	0.38
   query32	3.29	0.48	0.47
   query33	2.90	2.95	2.92
   query34	16.99	4.43	4.44
   query35	4.56	4.46	4.58
   query36	0.65	0.46	0.48
   query37	0.18	0.15	0.15
   query38	0.15	0.13	0.14
   query39	0.05	0.03	0.03
   query40	0.17	0.15	0.14
   query41	0.09	0.05	0.05
   query42	0.05	0.05	0.05
   query43	0.05	0.04	0.04
   Total cold run time: 109.64 s
   Total hot run time: 30.89 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] [enhance](mtmv)show create materialized view [doris]

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

   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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 40203 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 19cd0df0255afd772a3a10ebb55ea6f01530560e, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17614	4311	4251	4251
   q2	2014	186	192	186
   q3	10458	1123	1176	1123
   q4	10189	792	753	753
   q5	7436	2663	2590	2590
   q6	219	136	135	135
   q7	959	614	585	585
   q8	9224	2052	2068	2052
   q9	8905	6534	6486	6486
   q10	9087	3717	3695	3695
   q11	453	237	235	235
   q12	497	227	222	222
   q13	18999	3013	3015	3013
   q14	259	214	229	214
   q15	523	475	482	475
   q16	527	402	390	390
   q17	967	660	676	660
   q18	8327	8034	7875	7875
   q19	7981	1380	1541	1380
   q20	696	333	326	326
   q21	5324	4389	3207	3207
   q22	423	365	350	350
   Total cold run time: 121081 ms
   Total hot run time: 40203 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4869	4596	4651	4596
   q2	384	268	260	260
   q3	3179	2993	3087	2993
   q4	2023	1729	1739	1729
   q5	5676	5586	5611	5586
   q6	242	132	131	131
   q7	2241	1846	1832	1832
   q8	3367	3389	3445	3389
   q9	8679	8650	8678	8650
   q10	4092	3871	3884	3871
   q11	597	514	491	491
   q12	814	644	643	643
   q13	17154	3010	3123	3010
   q14	298	274	259	259
   q15	523	498	491	491
   q16	509	429	444	429
   q17	1830	1555	1524	1524
   q18	8046	7880	7840	7840
   q19	1747	1545	1697	1545
   q20	3351	1896	1847	1847
   q21	10160	4642	4876	4642
   q22	701	540	553	540
   Total cold run time: 80482 ms
   Total hot run time: 56298 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] [enhance](mtmv)show create materialized view [doris]

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

   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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.31 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 2101467e8533d350584a0c4c2ad4528dac9efcd4, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.08	0.04	0.04
   query3	0.24	0.05	0.04
   query4	1.68	0.08	0.09
   query5	0.50	0.49	0.49
   query6	1.13	0.73	0.72
   query7	0.02	0.02	0.02
   query8	0.06	0.04	0.04
   query9	0.54	0.49	0.48
   query10	0.56	0.56	0.54
   query11	0.15	0.12	0.11
   query12	0.15	0.12	0.12
   query13	0.59	0.59	0.60
   query14	0.79	0.79	0.77
   query15	0.83	0.82	0.83
   query16	0.34	0.36	0.36
   query17	0.95	0.97	0.97
   query18	0.23	0.22	0.26
   query19	1.89	1.74	1.73
   query20	0.01	0.01	0.01
   query21	15.41	0.64	0.64
   query22	4.44	7.55	1.71
   query23	18.30	1.50	1.27
   query24	2.15	0.23	0.23
   query25	0.16	0.09	0.08
   query26	0.27	0.17	0.17
   query27	0.07	0.08	0.08
   query28	13.17	1.04	1.00
   query29	12.60	3.26	3.27
   query30	0.26	0.07	0.06
   query31	2.86	0.39	0.39
   query32	3.27	0.47	0.49
   query33	2.96	2.88	2.88
   query34	16.96	4.40	4.39
   query35	4.47	4.47	4.50
   query36	0.66	0.48	0.46
   query37	0.19	0.15	0.15
   query38	0.15	0.15	0.14
   query39	0.05	0.03	0.03
   query40	0.17	0.13	0.14
   query41	0.09	0.05	0.04
   query42	0.05	0.04	0.04
   query43	0.04	0.04	0.04
   Total cold run time: 109.53 s
   Total hot run time: 30.31 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] [enhance](mtmv)show create materialized view [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 173065 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 53b09dded645b522e0f95759b637a0ac8b6166d7, data reload: false
   
   query1	918	380	377	377
   query2	6458	2333	2420	2333
   query3	6648	203	204	203
   query4	19221	17432	17370	17370
   query5	4153	471	480	471
   query6	241	157	159	157
   query7	4590	303	301	301
   query8	315	273	281	273
   query9	8678	2472	2434	2434
   query10	612	291	273	273
   query11	10491	9929	9986	9929
   query12	138	86	84	84
   query13	1645	367	368	367
   query14	9559	7515	7437	7437
   query15	236	192	191	191
   query16	7769	276	264	264
   query17	1798	538	522	522
   query18	1763	274	266	266
   query19	190	154	149	149
   query20	89	81	84	81
   query21	214	137	127	127
   query22	4359	4139	4017	4017
   query23	33723	32891	32894	32891
   query24	12122	2804	2788	2788
   query25	654	347	371	347
   query26	1765	152	155	152
   query27	3007	325	332	325
   query28	7614	2070	2090	2070
   query29	1100	622	618	618
   query30	293	152	147	147
   query31	953	732	756	732
   query32	96	53	54	53
   query33	760	286	270	270
   query34	1019	480	467	467
   query35	731	605	608	605
   query36	1120	913	966	913
   query37	295	76	73	73
   query38	2847	2722	2731	2722
   query39	910	809	807	807
   query40	284	124	125	124
   query41	54	52	50	50
   query42	115	97	101	97
   query43	560	534	552	534
   query44	1223	725	738	725
   query45	199	168	170	168
   query46	1072	745	707	707
   query47	1829	1770	1754	1754
   query48	386	317	299	299
   query49	1199	410	399	399
   query50	763	396	382	382
   query51	6754	6724	6666	6666
   query52	110	93	91	91
   query53	360	292	289	289
   query54	988	442	449	442
   query55	75	72	76	72
   query56	287	255	260	255
   query57	1161	1049	1080	1049
   query58	254	228	249	228
   query59	3453	3364	3348	3348
   query60	290	265	265	265
   query61	93	87	87	87
   query62	667	444	454	444
   query63	324	292	296	292
   query64	9830	2254	1724	1724
   query65	3212	3140	3110	3110
   query66	1336	328	338	328
   query67	15451	14930	15056	14930
   query68	4501	547	543	543
   query69	448	305	314	305
   query70	1124	1160	1154	1154
   query71	400	271	272	271
   query72	7237	5697	5309	5309
   query73	742	330	339	330
   query74	6023	5514	5392	5392
   query75	3516	2651	2675	2651
   query76	2817	966	913	913
   query77	454	310	298	298
   query78	10124	9859	9669	9669
   query79	2149	577	514	514
   query80	1073	467	462	462
   query81	585	221	225	221
   query82	785	108	109	108
   query83	235	169	171	169
   query84	238	84	85	84
   query85	2044	287	272	272
   query86	490	319	318	318
   query87	3266	3079	3180	3079
   query88	4094	2466	2456	2456
   query89	491	394	388	388
   query90	1827	196	193	193
   query91	127	95	96	95
   query92	65	48	47	47
   query93	2500	516	504	504
   query94	1289	187	191	187
   query95	407	316	322	316
   query96	599	278	279	278
   query97	3204	3055	3049	3049
   query98	211	198	192	192
   query99	1274	833	841	833
   Total cold run time: 275762 ms
   Total hot run time: 173065 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] [enhance](mtmv)show create materialized view [doris]

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

   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] [enhance](mtmv)show create materialized view [doris]

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

   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