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

[PR] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   ## Proposed changes
    Support to create partition materialized view using nodata table
   Such as the table def as following:
   >        CREATE TABLE `test_no_data` (
   >         `user_id` LARGEINT NOT NULL COMMENT '"用户id"',
   >         `date` DATE NOT NULL COMMENT '"数据灌入日期时间"',
   >         `num` SMALLINT NOT NULL COMMENT '"数量"'
   >        ) ENGINE=OLAP
   >        DUPLICATE KEY(`user_id`, `date`, `num`)
   >        COMMENT 'OLAP'
   >        PARTITION BY RANGE(`date`)
   >        (PARTITION p201701_1000 VALUES [('0000-01-01'), ('2017-02-01')),
   >        PARTITION p201702_2000 VALUES [('2017-02-01'), ('2017-03-01')),
   >        PARTITION p201703_all VALUES [('2017-03-01'), ('2017-04-01')))
   >        DISTRIBUTED BY HASH(`user_id`) BUCKETS 2
   >        PROPERTIES ('replication_num' = '1') ;
   
   when table test_no_data has no data, it also support to create partition materialized view as following:
   >        CREATE MATERIALIZED VIEW no_data_partition_mv
   >            BUILD IMMEDIATE REFRESH AUTO ON MANUAL
   >            partition by(`date`)
   >            DISTRIBUTED BY RANDOM BUCKETS 2
   >            PROPERTIES ('replication_num' = '1')
   >            AS
   >           SELECT * FROM test_no_data where date > '2017-05-01';
   >
   
   <!--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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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


##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/CreateMTMVInfo.java:
##########
@@ -224,6 +227,15 @@ public void analyzeQuery(ConnectContext ctx) {
         }
         getRelation(planner);
         getColumns(plan);
+        try {
+            // we want to set session variable, so need to new connectContext avoid influence other query
+            statementContext.setConnectContext(
+                    MTMVPlanUtil.createMTMVContext(this.envInfo.getCtlId(), this.envInfo.getDbId()));

Review Comment:
   Creating a new ctx here may not be a good method. How about setting environment variables on the ctx of crude oil and setting them back after the method ends? Or there may be other methods instead of using the environment variable setDisableNereidsRules



##########
fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVPlanUtil.java:
##########
@@ -60,6 +60,21 @@ public static ConnectContext createMTMVContext(MTMV mtmv) throws AnalysisExcepti
         return ctx;
     }
 
+    public static ConnectContext createMTMVContext(long ctlId, long dbId) throws AnalysisException {

Review Comment:
   There is some overlap with the logic of createMTMVContext (MTMV mtmv), abstract it a bit



-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 07e346f6ec008a08684b5887496754e8c7a1c988, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	5425	5086	5161	5086
   q2	398	154	158	154
   q3	1460	1188	1203	1188
   q4	1093	843	815	815
   q5	3125	3056	3134	3056
   q6	220	146	131	131
   q7	980	573	519	519
   q8	2140	2263	2271	2263
   q9	6712	6662	6681	6662
   q10	3176	3152	3102	3102
   q11	340	218	215	215
   q12	384	242	234	234
   q13	4399	3627	3687	3627
   q14	249	221	212	212
   q15	610	553	549	549
   q16	450	423	389	389
   q17	1035	587	522	522
   q18	7117	6743	7371	6743
   q19	1641	1490	1407	1407
   q20	552	340	345	340
   q21	2854	2436	2474	2436
   q22	391	317	328	317
   Total cold run time: 44751 ms
   Total hot run time: 39967 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	5154	5130	5064	5064
   q2	342	253	254	253
   q3	3366	3328	3279	3279
   q4	2141	2042	2017	2017
   q5	5938	5933	5898	5898
   q6	227	125	125	125
   q7	2408	1915	1951	1915
   q8	3568	3642	3672	3642
   q9	9017	9012	8971	8971
   q10	3872	3915	3915	3915
   q11	591	471	499	471
   q12	814	648	649	648
   q13	3885	3217	3178	3178
   q14	306	281	278	278
   q15	607	544	534	534
   q16	574	536	541	536
   q17	2049	1821	1826	1821
   q18	8761	8396	8304	8304
   q19	1724	1685	1649	1649
   q20	2293	2006	1979	1979
   q21	5720	5297	5320	5297
   q22	607	497	457	457
   Total cold run time: 63964 ms
   Total hot run time: 60231 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 07e346f6ec008a08684b5887496754e8c7a1c988, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17820	5187	5118	5118
   q2	2045	160	147	147
   q3	10596	1071	1155	1071
   q4	10194	773	856	773
   q5	7795	2918	2807	2807
   q6	221	137	136	136
   q7	907	501	557	501
   q8	9299	2029	2026	2026
   q9	7004	6427	6402	6402
   q10	8271	3044	3037	3037
   q11	453	228	231	228
   q12	395	229	232	229
   q13	18019	3662	3675	3662
   q14	239	214	207	207
   q15	586	549	538	538
   q16	492	399	420	399
   q17	979	523	513	513
   q18	7425	6806	6702	6702
   q19	1622	1434	1347	1347
   q20	726	325	321	321
   q21	2798	2361	2428	2361
   q22	379	320	332	320
   Total cold run time: 108265 ms
   Total hot run time: 38845 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5181	5107	5055	5055
   q2	335	251	260	251
   q3	3319	3293	3252	3252
   q4	2103	2022	2009	2009
   q5	5793	5808	5928	5808
   q6	224	129	132	129
   q7	2378	2038	1999	1999
   q8	3413	3467	3493	3467
   q9	8953	8897	8785	8785
   q10	3846	3837	3829	3829
   q11	582	461	483	461
   q12	786	633	642	633
   q13	13553	3170	3204	3170
   q14	293	277	269	269
   q15	588	551	527	527
   q16	564	490	521	490
   q17	1938	1754	1798	1754
   q18	8690	8342	8200	8200
   q19	1621	1567	1597	1567
   q20	2203	1964	1996	1964
   q21	5607	5260	5225	5225
   q22	550	510	453	453
   Total cold run time: 72520 ms
   Total hot run time: 59297 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 47.48 seconds
    stream load tsv:          561 seconds loaded 74807831229 Bytes, about 127 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          27.6 seconds inserted 10000000 Rows, about 362K ops/s
    storage size: 17183722198 Bytes


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 46.67 seconds
    stream load tsv:          584 seconds loaded 74807831229 Bytes, about 122 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          33 seconds loaded 861443392 Bytes, about 24 MB/s
    insert into select:          28.0 seconds inserted 10000000 Rows, about 357K ops/s
    storage size: 17183949665 Bytes


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit e738c419d4902982a79c0660590b9b9d7d16580f, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	18418	5204	5182	5182
   q2	2026	159	146	146
   q3	10605	1093	1123	1093
   q4	10205	762	857	762
   q5	7803	2978	2868	2868
   q6	214	139	137	137
   q7	939	519	561	519
   q8	9305	2023	2044	2023
   q9	6932	6379	6397	6379
   q10	8238	3058	3068	3058
   q11	419	213	221	213
   q12	390	235	241	235
   q13	18014	3646	3654	3646
   q14	239	221	214	214
   q15	586	544	536	536
   q16	446	415	403	403
   q17	977	598	502	502
   q18	7472	6779	6808	6779
   q19	1600	1399	1345	1345
   q20	671	348	351	348
   q21	2814	2369	2443	2369
   q22	382	306	322	306
   Total cold run time: 108695 ms
   Total hot run time: 39063 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5103	5141	5106	5106
   q2	333	234	247	234
   q3	3312	3305	3248	3248
   q4	2136	2040	2029	2029
   q5	5832	5802	5806	5802
   q6	216	129	126	126
   q7	2359	1902	1870	1870
   q8	3383	3468	3462	3462
   q9	8878	8839	8856	8839
   q10	3815	3816	3867	3816
   q11	570	479	477	477
   q12	827	628	642	628
   q13	11946	3189	3194	3189
   q14	295	261	272	261
   q15	599	542	545	542
   q16	532	486	493	486
   q17	1934	1775	1726	1726
   q18	8712	8405	8418	8405
   q19	1629	1572	1603	1572
   q20	2236	2019	1984	1984
   q21	5533	5258	5261	5258
   q22	524	461	511	461
   Total cold run time: 70704 ms
   Total hot run time: 59521 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
   ```
   TPC-DS sf100 test result on commit 4d313910ff5ebfa184f1d2c6736205bae28495c3, data reload: false
   
   run tpcds-sf100 query with default conf and session variables
   query1	953	348	338	338
   query2	4928	2078	1924	1924
   query3	6643	208	208	208
   query4	27564	22353	22355	22353
   query5	3897	513	560	513
   query6	261	180	186	180
   query7	4583	270	268	268
   query8	220	235	200	200
   query9	8188	2558	2549	2549
   query10	434	261	230	230
   query11	16197	15522	15487	15487
   query12	132	78	73	73
   query13	1642	326	323	323
   query14	10739	7212	7122	7122
   query15	236	186	188	186
   query16	6148	276	268	268
   query17	1844	508	492	492
   query18	1810	264	272	264
   query19	184	139	139	139
   query20	79	76	73	73
   query21	184	98	98	98
   query22	4935	4774	4691	4691
   query23	32115	31226	31276	31226
   query24	12073	2833	2827	2827
   query25	567	348	338	338
   query26	1619	137	140	137
   query27	2887	279	279	279
   query28	6862	1889	1886	1886
   query29	1411	399	400	399
   query30	292	140	144	140
   query31	995	771	793	771
   query32	86	58	54	54
   query33	743	251	269	251
   query34	881	440	442	440
   query35	903	750	799	750
   query36	1339	1229	1207	1207
   query37	181	65	68	65
   query38	3424	3309	3280	3280
   query39	1331	1296	1284	1284
   query40	308	90	87	87
   query41	36	37	41	37
   query42	88	86	83	83
   query43	519	478	482	478
   query44	1083	704	718	704
   query45	201	191	182	182
   query46	1066	655	620	620
   query47	1661	1532	1573	1532
   query48	342	252	263	252
   query49	1149	316	308	308
   query50	822	330	339	330
   query51	5382	5220	5299	5220
   query52	93	82	88	82
   query53	221	150	161	150
   query54	1382	576	567	567
   query55	100	84	82	82
   query56	213	195	200	195
   query57	1036	928	922	922
   query58	219	189	203	189
   query59	2896	2705	2662	2662
   query60	231	229	223	223
   query61	93	91	90	90
   query62	640	433	465	433
   query63	177	152	147	147
   query64	5121	1782	1742	1742
   query65	3323	3280	3275	3275
   query66	1285	343	341	341
   query67	15657	15592	15649	15592
   query68	11235	543	538	538
   query69	532	260	252	252
   query70	1725	1533	1450	1450
   query71	511	222	206	206
   query72	5897	3647	3636	3636
   query73	2279	311	324	311
   query74	7136	6479	6578	6479
   query75	5395	2260	2287	2260
   query76	6305	1176	1107	1107
   query77	664	241	272	241
   query78	9114	8731	8559	8559
   query79	1018	498	504	498
   query80	532	347	355	347
   query81	451	203	212	203
   query82	206	92	85	85
   query83	163	142	137	137
   query84	252	56	56	56
   query85	955	286	287	286
   query86	379	379	370	370
   query87	3580	3413	3430	3413
   query88	2878	2278	2249	2249
   query89	315	254	257	254
   query90	1886	197	195	195
   query91	126	93	97	93
   query92	65	51	55	51
   query93	1178	444	500	444
   query94	822	183	185	183
   query95	457	407	410	407
   query96	627	322	321	321
   query97	4269	4189	4172	4172
   query98	206	190	187	187
   query99	1065	788	832	788
   Total cold run time: 287077 ms
   Total hot run time: 179616 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
   ```
   TPC-DS sf100 test result on commit 42c3c22d09402b0fc103c1bc9eb0bc7f614343fb, data reload: false
   
   run tpcds-sf100 query with default conf and session variables
   query1	913	349	335	335
   query2	6412	1866	1824	1824
   query3	6639	212	205	205
   query4	27527	22474	22498	22474
   query5	3887	510	544	510
   query6	261	182	179	179
   query7	4579	269	267	267
   query8	226	200	200	200
   query9	8233	2537	2587	2537
   query10	420	245	244	244
   query11	16214	15602	15411	15411
   query12	136	75	75	75
   query13	1624	315	308	308
   query14	11443	7090	7202	7090
   query15	216	195	188	188
   query16	6158	273	260	260
   query17	1818	501	496	496
   query18	1841	273	258	258
   query19	188	133	132	132
   query20	76	75	79	75
   query21	182	99	92	92
   query22	4779	4693	4637	4637
   query23	32165	31192	31167	31167
   query24	12291	2843	2846	2843
   query25	609	344	333	333
   query26	1808	143	139	139
   query27	2941	273	280	273
   query28	6947	1860	1846	1846
   query29	2215	384	386	384
   query30	284	145	151	145
   query31	969	752	787	752
   query32	89	58	54	54
   query33	725	275	261	261
   query34	931	435	440	435
   query35	895	773	772	772
   query36	1277	1237	1193	1193
   query37	181	69	70	69
   query38	3369	3287	3267	3267
   query39	1339	1321	1287	1287
   query40	309	88	93	88
   query41	41	35	34	34
   query42	88	84	82	82
   query43	526	463	487	463
   query44	1060	684	688	684
   query45	195	186	185	185
   query46	1061	635	648	635
   query47	1586	1588	1541	1541
   query48	335	263	254	254
   query49	1207	313	315	313
   query50	752	323	320	320
   query51	5331	5255	5241	5241
   query52	98	90	90	90
   query53	209	142	145	142
   query54	1364	551	579	551
   query55	92	85	80	80
   query56	204	190	187	187
   query57	1058	925	939	925
   query58	235	199	197	197
   query59	2802	2573	2641	2573
   query60	234	205	224	205
   query61	86	85	85	85
   query62	675	461	473	461
   query63	156	149	147	147
   query64	5901	1787	1718	1718
   query65	3330	3263	3261	3261
   query66	1399	359	337	337
   query67	15584	15662	15212	15212
   query68	13607	509	503	503
   query69	502	254	238	238
   query70	2305	1465	1522	1465
   query71	484	217	216	216
   query72	5658	3569	3558	3558
   query73	3498	324	318	318
   query74	7002	6390	6556	6390
   query75	5379	2284	2281	2281
   query76	6303	1125	1063	1063
   query77	700	268	283	268
   query78	9146	8707	8456	8456
   query79	1866	497	485	485
   query80	578	360	346	346
   query81	455	208	209	208
   query82	200	95	93	93
   query83	187	132	134	132
   query84	247	53	51	51
   query85	946	289	276	276
   query86	389	397	385	385
   query87	3541	3354	3344	3344
   query88	3105	2255	2255	2255
   query89	337	261	247	247
   query90	2244	200	190	190
   query91	119	94	89	89
   query92	62	53	55	53
   query93	1471	437	486	437
   query94	905	181	181	181
   query95	446	414	394	394
   query96	639	319	322	319
   query97	4299	4159	4151	4151
   query98	212	202	189	189
   query99	1107	840	871	840
   Total cold run time: 296664 ms
   Total hot run time: 178449 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
   ```
   TPC-DS sf100 test result on commit 07e346f6ec008a08684b5887496754e8c7a1c988, data reload: false
   
   run tpcds-sf100 query with default conf and session variables
   query1	881	366	348	348
   query2	3676	1883	1963	1883
   query3	4972	207	200	200
   query4	26603	22492	22414	22414
   query5	4135	589	614	589
   query6	269	193	186	186
   query7	4061	283	274	274
   query8	222	214	207	207
   query9	6981	2587	2707	2587
   query10	401	261	266	261
   query11	16360	15561	15489	15489
   query12	139	79	77	77
   query13	1342	334	335	334
   query14	10433	7325	7254	7254
   query15	230	195	204	195
   query16	5021	273	271	271
   query17	1464	505	518	505
   query18	1637	287	268	268
   query19	208	144	140	140
   query20	84	81	79	79
   query21	179	103	98	98
   query22	4863	4616	4868	4616
   query23	32462	31513	31562	31513
   query24	12720	2900	2838	2838
   query25	638	359	363	359
   query26	1722	150	154	150
   query27	2856	280	296	280
   query28	6804	1978	1981	1978
   query29	2553	408	389	389
   query30	287	151	152	151
   query31	1038	775	796	775
   query32	90	60	58	58
   query33	718	269	279	269
   query34	966	459	451	451
   query35	873	803	743	743
   query36	1330	1173	1232	1173
   query37	174	74	74	74
   query38	3388	3271	3269	3269
   query39	1357	1294	1297	1294
   query40	287	94	95	94
   query41	39	36	35	35
   query42	95	92	93	92
   query43	557	511	494	494
   query44	1093	704	741	704
   query45	200	193	187	187
   query46	1071	672	660	660
   query47	1640	1522	1506	1506
   query48	348	271	266	266
   query49	1180	341	324	324
   query50	739	386	373	373
   query51	5462	5379	5277	5277
   query52	104	91	91	91
   query53	224	160	154	154
   query54	2023	608	598	598
   query55	97	88	87	87
   query56	207	203	196	196
   query57	985	948	901	901
   query58	221	211	212	211
   query59	2849	2582	2631	2582
   query60	265	245	237	237
   query61	85	84	82	82
   query62	639	468	454	454
   query63	174	151	149	149
   query64	5667	1775	1758	1758
   query65	3361	3281	3286	3281
   query66	1332	337	322	322
   query67	15675	15507	15520	15507
   query68	11242	546	536	536
   query69	468	256	260	256
   query70	1643	1465	1544	1465
   query71	419	232	222	222
   query72	5434	3516	3495	3495
   query73	2512	314	313	313
   query74	7056	6389	6378	6378
   query75	4909	2296	2280	2280
   query76	5531	1069	1136	1069
   query77	656	291	292	291
   query78	9233	8772	8654	8654
   query79	3130	534	523	523
   query80	557	359	370	359
   query81	473	209	213	209
   query82	217	101	105	101
   query83	169	140	137	137
   query84	238	54	54	54
   query85	888	286	267	267
   query86	430	358	398	358
   query87	3582	3382	3388	3382
   query88	3085	2286	2283	2283
   query89	342	253	258	253
   query90	1853	213	212	212
   query91	119	86	90	86
   query92	65	54	53	53
   query93	1552	504	439	439
   query94	748	188	191	188
   query95	464	413	419	413
   query96	627	315	321	315
   query97	4304	4174	4163	4163
   query98	200	206	189	189
   query99	1088	841	805	805
   Total cold run time: 283990 ms
   Total hot run time: 180409 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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


##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/CreateMTMVInfo.java:
##########
@@ -224,7 +228,18 @@ public void analyzeQuery(ConnectContext ctx) {
         }
         getRelation(planner);
         getColumns(plan);
-        analyzePartition(planner);
+        SessionVariable sessionVariable = statementContext.getConnectContext().getSessionVariable();
+        Set<String> tempDisableRules = sessionVariable.getDisableNereidsRuleNames();
+        // Should not make table without data to empty relation, so add disable rules
+        sessionVariable.setDisableNereidsRules(MTMV_PLANER_DISABLE_RULES);
+        try {
+            analyzePartition(planner);
+        } finally {
+            if (!tempDisableRules.isEmpty()) {

Review Comment:
   OK, I will fix it



-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 47.53 seconds
    stream load tsv:          581 seconds loaded 74807831229 Bytes, about 122 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          33 seconds loaded 861443392 Bytes, about 24 MB/s
    insert into select:          27.5 seconds inserted 10000000 Rows, about 363K ops/s
    storage size: 17187942904 Bytes


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 87c7369671a0a6464f498a4b0752902023d7c7a9, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	5509	5150	5148	5148
   q2	392	181	168	168
   q3	1473	1145	1169	1145
   q4	1079	887	781	781
   q5	3123	3087	3117	3087
   q6	223	134	134	134
   q7	955	548	531	531
   q8	2149	2240	2299	2240
   q9	6759	6694	6687	6687
   q10	3228	3127	3135	3127
   q11	344	224	215	215
   q12	383	228	234	228
   q13	4375	3626	3606	3606
   q14	251	210	219	210
   q15	576	525	537	525
   q16	456	403	400	400
   q17	1039	568	511	511
   q18	7098	6795	6765	6765
   q19	1648	1620	1454	1454
   q20	589	323	316	316
   q21	2855	2445	2453	2445
   q22	396	333	320	320
   Total cold run time: 44900 ms
   Total hot run time: 40043 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	5126	5079	5100	5079
   q2	335	231	228	228
   q3	3351	3327	3327	3327
   q4	2159	2065	2039	2039
   q5	5956	5927	5904	5904
   q6	223	125	125	125
   q7	2400	1897	1915	1897
   q8	3564	3664	3667	3664
   q9	9013	8972	8923	8923
   q10	3856	3957	3932	3932
   q11	609	490	471	471
   q12	799	626	639	626
   q13	3859	3194	3201	3194
   q14	304	270	265	265
   q15	606	529	525	525
   q16	534	507	523	507
   q17	2030	1820	1811	1811
   q18	8755	8407	8331	8331
   q19	1756	1708	1713	1708
   q20	2284	1988	1974	1974
   q21	5710	5322	5248	5248
   q22	549	463	490	463
   Total cold run time: 63778 ms
   Total hot run time: 60241 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 47.37 seconds
    stream load tsv:          568 seconds loaded 74807831229 Bytes, about 125 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.2 seconds inserted 10000000 Rows, about 354K ops/s
    storage size: 17184199990 Bytes


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
   ```
   TPC-DS sf100 test result on commit b6f1d1ac388fc503595752d297aaf4c67866b73e, data reload: false
   
   run tpcds-sf100 query with default conf and session variables
   query1	928	345	326	326
   query2	6415	2057	1951	1951
   query3	6655	208	205	205
   query4	26213	22542	22404	22404
   query5	3892	516	541	516
   query6	265	184	172	172
   query7	4582	265	268	265
   query8	238	206	193	193
   query9	8299	2558	2535	2535
   query10	453	231	224	224
   query11	16186	15487	15534	15487
   query12	136	80	74	74
   query13	1625	323	319	319
   query14	11313	7232	6990	6990
   query15	222	185	188	185
   query16	6353	265	262	262
   query17	1890	500	489	489
   query18	1964	268	252	252
   query19	178	134	133	133
   query20	81	75	75	75
   query21	186	98	102	98
   query22	5064	4774	4752	4752
   query23	32005	31130	31256	31130
   query24	12082	2776	2790	2776
   query25	605	351	332	332
   query26	1757	135	143	135
   query27	2922	271	281	271
   query28	7106	1866	1858	1858
   query29	2093	395	377	377
   query30	293	142	145	142
   query31	993	754	765	754
   query32	98	56	53	53
   query33	743	247	263	247
   query34	940	446	446	446
   query35	867	803	799	799
   query36	1289	1184	1246	1184
   query37	190	71	69	69
   query38	3383	3250	3248	3248
   query39	1332	1290	1281	1281
   query40	306	95	92	92
   query41	37	36	34	34
   query42	89	85	79	79
   query43	533	500	482	482
   query44	1140	703	702	702
   query45	200	187	181	181
   query46	1067	641	628	628
   query47	1656	1560	1554	1554
   query48	329	256	260	256
   query49	1237	328	304	304
   query50	779	359	329	329
   query51	5440	5308	5299	5299
   query52	98	88	82	82
   query53	219	147	141	141
   query54	1418	566	571	566
   query55	100	79	89	79
   query56	196	186	195	186
   query57	1045	921	926	921
   query58	222	194	201	194
   query59	2891	2757	2622	2622
   query60	235	214	227	214
   query61	87	84	86	84
   query62	626	471	464	464
   query63	165	146	144	144
   query64	5937	1635	1662	1635
   query65	3324	3247	3259	3247
   query66	1399	353	344	344
   query67	15536	15333	15186	15186
   query68	11206	513	522	513
   query69	515	250	258	250
   query70	1736	1458	1494	1458
   query71	498	210	221	210
   query72	5640	3550	3549	3549
   query73	2239	313	314	313
   query74	6980	6416	6460	6416
   query75	4792	2286	2290	2286
   query76	6229	1119	1083	1083
   query77	663	251	286	251
   query78	9084	8726	8507	8507
   query79	1042	509	500	500
   query80	535	358	345	345
   query81	457	211	215	211
   query82	203	98	91	91
   query83	159	137	139	137
   query84	243	53	54	53
   query85	949	283	269	269
   query86	376	387	375	375
   query87	3603	3348	3386	3348
   query88	2845	2258	2267	2258
   query89	333	261	261	261
   query90	1884	194	198	194
   query91	120	93	91	91
   query92	63	54	52	52
   query93	1386	423	421	421
   query94	888	185	185	185
   query95	472	415	425	415
   query96	619	320	319	319
   query97	4295	4128	4223	4128
   query98	195	199	192	192
   query99	1100	810	840	810
   Total cold run time: 289496 ms
   Total hot run time: 178549 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 47.95 seconds
    stream load tsv:          575 seconds loaded 74807831229 Bytes, about 124 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.2 seconds inserted 10000000 Rows, about 354K ops/s
    storage size: 17183873705 Bytes


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 46.74 seconds
    stream load tsv:          563 seconds loaded 74807831229 Bytes, about 126 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.1 seconds inserted 10000000 Rows, about 355K ops/s
    storage size: 17188203594 Bytes


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38625 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 d8119a0983f5134a0f97bcedfce508872991f6fe, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17658	4969	4957	4957
   q2	2024	162	144	144
   q3	10619	1152	1179	1152
   q4	10454	821	793	793
   q5	7842	2968	2951	2951
   q6	211	123	123	123
   q7	898	504	498	498
   q8	9268	1989	1997	1989
   q9	6452	6375	6353	6353
   q10	8248	3094	3078	3078
   q11	441	220	221	220
   q12	388	227	230	227
   q13	18003	3388	3398	3388
   q14	239	215	211	211
   q15	546	512	507	507
   q16	449	392	402	392
   q17	954	651	533	533
   q18	7279	6702	6604	6604
   q19	1590	1527	1524	1524
   q20	719	314	297	297
   q21	2756	2379	2381	2379
   q22	345	305	316	305
   Total cold run time: 107383 ms
   Total hot run time: 38625 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4995	5040	4932	4932
   q2	341	233	237	233
   q3	3293	3294	3308	3294
   q4	2124	2008	2032	2008
   q5	5791	5804	5768	5768
   q6	203	118	120	118
   q7	2313	1894	1905	1894
   q8	3384	3425	3481	3425
   q9	8739	8750	8691	8691
   q10	3767	3845	3842	3842
   q11	544	436	436	436
   q12	801	628	620	620
   q13	7699	3182	3191	3182
   q14	295	267	261	261
   q15	544	505	508	505
   q16	546	507	521	507
   q17	1866	1882	1867	1867
   q18	8653	8301	8204	8204
   q19	1668	1636	1629	1629
   q20	2217	1946	1958	1946
   q21	5636	5278	5308	5278
   q22	496	477	469	469
   Total cold run time: 65915 ms
   Total hot run time: 59109 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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 182979 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 d8119a0983f5134a0f97bcedfce508872991f6fe, data reload: false
   
   run tpcds-sf100 query with default conf and session variables
   query1	937	336	336	336
   query2	6559	2053	1963	1963
   query3	6719	228	224	224
   query4	27194	22385	22499	22385
   query5	6038	586	611	586
   query6	343	208	226	208
   query7	4640	311	305	305
   query8	261	220	225	220
   query9	8713	2962	2964	2962
   query10	557	335	311	311
   query11	16166	15615	15856	15615
   query12	162	98	107	98
   query13	1710	365	349	349
   query14	13433	7559	7559	7559
   query15	260	249	212	212
   query16	6250	346	328	328
   query17	1706	512	489	489
   query18	1950	307	301	301
   query19	215	165	149	149
   query20	110	102	101	101
   query21	185	93	98	93
   query22	5001	4903	4760	4760
   query23	32089	31020	31511	31020
   query24	12204	2913	2943	2913
   query25	608	363	367	363
   query26	1790	168	181	168
   query27	2960	316	308	308
   query28	7044	2180	2171	2171
   query29	2160	422	408	408
   query30	290	144	147	144
   query31	1021	821	848	821
   query32	130	88	80	80
   query33	826	342	308	308
   query34	867	466	468	466
   query35	997	861	830	830
   query36	1352	1263	1342	1263
   query37	197	90	87	87
   query38	3536	3391	3368	3368
   query39	1350	1293	1295	1293
   query40	301	87	88	87
   query41	41	41	37	37
   query42	115	104	105	104
   query43	562	555	525	525
   query44	1256	796	799	796
   query45	209	198	208	198
   query46	1052	704	703	703
   query47	1785	1596	1579	1579
   query48	385	291	294	291
   query49	1206	306	308	306
   query50	731	334	337	334
   query51	5511	5259	5234	5234
   query52	105	104	91	91
   query53	231	167	167	167
   query54	1409	658	645	645
   query55	104	102	95	95
   query56	303	249	240	240
   query57	1072	984	1011	984
   query58	314	280	273	273
   query59	3124	2880	2987	2880
   query60	369	308	292	292
   query61	145	147	146	146
   query62	591	471	485	471
   query63	194	161	171	161
   query64	5941	1714	1745	1714
   query65	3422	3371	3346	3346
   query66	1356	385	375	375
   query67	15638	14966	15589	14966
   query68	16188	545	569	545
   query69	607	318	315	315
   query70	2325	1509	1624	1509
   query71	608	288	292	288
   query72	5328	3448	3461	3448
   query73	4077	347	330	330
   query74	7181	6476	6544	6476
   query75	6207	2302	2279	2279
   query76	6557	1031	1279	1031
   query77	1227	319	338	319
   query78	9112	8522	8504	8504
   query79	2712	512	528	512
   query80	704	349	339	339
   query81	514	230	211	211
   query82	232	114	113	113
   query83	358	147	142	142
   query84	257	54	57	54
   query85	741	278	272	272
   query86	425	433	392	392
   query87	3662	3477	3427	3427
   query88	3205	2474	2432	2432
   query89	398	284	287	284
   query90	2307	252	250	250
   query91	126	94	95	94
   query92	89	66	67	66
   query93	1515	499	431	431
   query94	1078	252	221	221
   query95	608	527	495	495
   query96	637	341	334	334
   query97	4425	4189	4257	4189
   query98	233	230	215	215
   query99	1159	857	863	857
   Total cold run time: 310804 ms
   Total hot run time: 182979 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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 183619 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 6f2ec5a87ed964d4ec35360ebe4114fae543af3a, data reload: false
   
   run tpcds-sf100 query with default conf and session variables
   query1	958	343	330	330
   query2	6559	2017	1921	1921
   query3	6718	224	228	224
   query4	25255	22563	22428	22428
   query5	6053	607	647	607
   query6	352	203	208	203
   query7	4641	305	307	305
   query8	247	219	227	219
   query9	8753	2971	2981	2971
   query10	564	303	314	303
   query11	16268	15321	15563	15321
   query12	160	94	100	94
   query13	1695	345	351	345
   query14	12463	7580	7558	7558
   query15	267	227	213	213
   query16	6383	334	325	325
   query17	1709	529	521	521
   query18	1968	300	301	300
   query19	244	160	158	158
   query20	107	95	105	95
   query21	190	91	98	91
   query22	5089	4704	4906	4704
   query23	32521	31132	31040	31040
   query24	10977	2949	2892	2892
   query25	606	348	361	348
   query26	1570	171	175	171
   query27	2751	320	308	308
   query28	6779	2184	2191	2184
   query29	1414	418	396	396
   query30	283	148	146	146
   query31	1024	811	823	811
   query32	137	82	89	82
   query33	830	360	337	337
   query34	860	458	488	458
   query35	994	898	878	878
   query36	1340	1263	1261	1261
   query37	122	82	88	82
   query38	3568	3392	3391	3391
   query39	1348	1316	1302	1302
   query40	188	90	89	89
   query41	42	36	38	36
   query42	111	102	101	101
   query43	555	500	518	500
   query44	1193	808	825	808
   query45	213	212	203	203
   query46	1055	736	732	732
   query47	1767	1608	1687	1608
   query48	383	302	290	290
   query49	1081	312	317	312
   query50	793	362	332	332
   query51	5412	5336	5263	5263
   query52	112	97	94	94
   query53	229	170	166	166
   query54	1383	671	673	671
   query55	107	97	95	95
   query56	329	243	256	243
   query57	1070	1029	989	989
   query58	298	275	286	275
   query59	2996	2794	2818	2794
   query60	327	296	303	296
   query61	153	151	142	142
   query62	567	512	483	483
   query63	192	174	166	166
   query64	5102	1760	1728	1728
   query65	3421	3334	3316	3316
   query66	1094	383	393	383
   query67	15538	15183	15582	15183
   query68	13119	571	572	571
   query69	627	299	303	299
   query70	1685	1533	1539	1533
   query71	622	298	270	270
   query72	5391	3476	3438	3438
   query73	3208	335	344	335
   query74	7084	6548	6523	6523
   query75	5954	2316	2271	2271
   query76	6596	1226	1230	1226
   query77	1026	315	337	315
   query78	9235	8815	8758	8758
   query79	1098	528	553	528
   query80	666	338	357	338
   query81	496	213	213	213
   query82	235	101	108	101
   query83	231	142	143	142
   query84	248	58	60	58
   query85	875	290	269	269
   query86	433	441	448	441
   query87	3654	3507	3413	3413
   query88	2986	2500	2496	2496
   query89	368	287	287	287
   query90	2054	237	250	237
   query91	125	94	94	94
   query92	97	71	80	71
   query93	1278	436	500	436
   query94	1062	248	246	246
   query95	594	510	507	507
   query96	640	332	331	331
   query97	4353	4278	4207	4207
   query98	237	221	212	212
   query99	1179	886	832	832
   Total cold run time: 296934 ms
   Total hot run time: 183619 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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 46.59 seconds
    stream load tsv:          563 seconds loaded 74807831229 Bytes, about 126 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.2 seconds inserted 10000000 Rows, about 354K ops/s
    storage size: 17183310394 Bytes


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit e738c419d4902982a79c0660590b9b9d7d16580f, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	5544	5229	5146	5146
   q2	390	165	159	159
   q3	1466	1239	1135	1135
   q4	1114	941	812	812
   q5	3169	3147	3158	3147
   q6	232	131	131	131
   q7	1026	531	500	500
   q8	2178	2306	2284	2284
   q9	6769	6704	6672	6672
   q10	3206	3136	3114	3114
   q11	350	222	211	211
   q12	388	242	233	233
   q13	4389	3644	3662	3644
   q14	254	224	209	209
   q15	605	541	538	538
   q16	458	412	425	412
   q17	1055	607	558	558
   q18	7090	6778	6941	6778
   q19	1650	1540	1473	1473
   q20	580	337	322	322
   q21	2920	2487	2526	2487
   q22	390	314	312	312
   Total cold run time: 45223 ms
   Total hot run time: 40277 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	5092	5070	5133	5070
   q2	333	247	279	247
   q3	3359	3353	3280	3280
   q4	2136	2024	2002	2002
   q5	5930	5895	5927	5895
   q6	227	125	128	125
   q7	2412	1911	1876	1876
   q8	3569	3664	3667	3664
   q9	9042	8974	8997	8974
   q10	3890	3912	3918	3912
   q11	595	469	496	469
   q12	786	634	646	634
   q13	3874	3200	3186	3186
   q14	303	282	259	259
   q15	613	546	543	543
   q16	551	524	539	524
   q17	2024	1799	1795	1795
   q18	8720	8433	8434	8433
   q19	1751	1710	1690	1690
   q20	2350	1972	1987	1972
   q21	5732	5311	5358	5311
   q22	564	510	492	492
   Total cold run time: 63853 ms
   Total hot run time: 60353 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 42c3c22d09402b0fc103c1bc9eb0bc7f614343fb, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17661	5060	5112	5060
   q2	2030	155	138	138
   q3	10555	1052	1143	1052
   q4	10185	742	762	742
   q5	7770	2966	2924	2924
   q6	215	131	131	131
   q7	898	501	540	501
   q8	9234	1983	2020	1983
   q9	6810	6330	6382	6330
   q10	8199	3049	3036	3036
   q11	424	216	222	216
   q12	379	229	226	226
   q13	18004	3615	3644	3615
   q14	237	217	201	201
   q15	565	517	511	511
   q16	466	415	379	379
   q17	953	472	522	472
   q18	7199	6686	6641	6641
   q19	1561	1379	1439	1379
   q20	686	332	346	332
   q21	2782	2311	2324	2311
   q22	382	315	325	315
   Total cold run time: 107195 ms
   Total hot run time: 38495 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5135	5048	5103	5048
   q2	332	228	247	228
   q3	3317	3286	3268	3268
   q4	2123	1990	1987	1987
   q5	5777	5754	5772	5754
   q6	216	124	124	124
   q7	2336	1951	1895	1895
   q8	3341	3422	3421	3421
   q9	8788	8706	8718	8706
   q10	3811	3821	3867	3821
   q11	577	485	469	469
   q12	798	610	648	610
   q13	6858	3239	3181	3181
   q14	297	266	275	266
   q15	575	520	524	520
   q16	555	482	483	482
   q17	1895	1773	1770	1770
   q18	8703	8290	8211	8211
   q19	1599	1550	1570	1550
   q20	2193	1979	1941	1941
   q21	5560	5254	5178	5178
   q22	520	486	496	486
   Total cold run time: 65306 ms
   Total hot run time: 58916 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 47.57 seconds
    stream load tsv:          570 seconds loaded 74807831229 Bytes, about 125 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.5 seconds inserted 10000000 Rows, about 350K ops/s
    storage size: 17183908316 Bytes


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 4d313910ff5ebfa184f1d2c6736205bae28495c3, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	5507	5091	5102	5091
   q2	385	161	159	159
   q3	1463	1154	1236	1154
   q4	1078	793	785	785
   q5	3140	3055	3075	3055
   q6	230	140	136	136
   q7	1000	554	507	507
   q8	2153	2230	2275	2230
   q9	6711	6647	6674	6647
   q10	3202	3154	3146	3146
   q11	332	226	207	207
   q12	383	230	230	230
   q13	4413	3649	3637	3637
   q14	262	221	218	218
   q15	582	528	535	528
   q16	456	410	395	395
   q17	1046	569	531	531
   q18	7080	6731	6748	6731
   q19	1643	1550	1422	1422
   q20	540	317	334	317
   q21	2904	2429	2486	2429
   q22	396	309	338	309
   Total cold run time: 44906 ms
   Total hot run time: 39864 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	5129	5119	5081	5081
   q2	341	228	236	228
   q3	3375	3352	3304	3304
   q4	2150	2048	2026	2026
   q5	5967	5959	5949	5949
   q6	228	127	132	127
   q7	2395	1930	1909	1909
   q8	3561	3669	3674	3669
   q9	9086	9034	9023	9023
   q10	3858	3891	3895	3891
   q11	580	484	480	480
   q12	804	639	637	637
   q13	3859	3211	3182	3182
   q14	292	271	275	271
   q15	588	536	528	528
   q16	568	504	501	501
   q17	2006	1828	1843	1828
   q18	8733	8370	8609	8370
   q19	1746	1701	1666	1666
   q20	2259	1997	1961	1961
   q21	5894	5382	5265	5265
   q22	560	524	478	478
   Total cold run time: 63979 ms
   Total hot run time: 60374 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   run buidall


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
   ```
   TPC-DS sf100 test result on commit e738c419d4902982a79c0660590b9b9d7d16580f, data reload: false
   
   run tpcds-sf100 query with default conf and session variables
   query1	876	359	339	339
   query2	4753	1973	1913	1913
   query3	5028	210	198	198
   query4	26594	22466	22370	22370
   query5	3927	540	507	507
   query6	251	190	183	183
   query7	4084	270	274	270
   query8	242	215	200	200
   query9	7652	2594	2550	2550
   query10	391	242	244	242
   query11	16184	15636	15509	15509
   query12	130	83	83	83
   query13	1542	343	340	340
   query14	11005	7208	7169	7169
   query15	244	187	188	187
   query16	6143	280	270	270
   query17	1615	491	492	491
   query18	1814	272	256	256
   query19	200	144	137	137
   query20	84	74	80	74
   query21	180	99	95	95
   query22	4899	4555	4717	4555
   query23	32071	31136	31160	31136
   query24	11133	2831	2783	2783
   query25	589	346	339	339
   query26	1579	148	148	148
   query27	2777	280	278	278
   query28	6777	1974	1972	1972
   query29	1856	387	396	387
   query30	275	144	145	144
   query31	991	766	769	766
   query32	89	59	57	57
   query33	693	271	272	271
   query34	850	450	440	440
   query35	891	780	775	775
   query36	1364	1178	1202	1178
   query37	166	72	73	72
   query38	3374	3304	3282	3282
   query39	1321	1281	1263	1263
   query40	287	93	92	92
   query41	38	36	37	36
   query42	97	90	92	90
   query43	530	499	481	481
   query44	1048	704	718	704
   query45	196	190	181	181
   query46	1049	654	645	645
   query47	1688	1517	1481	1481
   query48	341	270	261	261
   query49	1045	327	323	323
   query50	742	324	323	323
   query51	5336	5233	5289	5233
   query52	100	88	88	88
   query53	217	152	156	152
   query54	1330	580	590	580
   query55	101	86	87	86
   query56	216	202	201	201
   query57	1026	976	979	976
   query58	225	199	198	198
   query59	2759	2569	2564	2564
   query60	258	237	251	237
   query61	87	83	83	83
   query62	634	488	456	456
   query63	164	151	149	149
   query64	5433	1688	1707	1688
   query65	3359	3272	3274	3272
   query66	1392	337	326	326
   query67	15706	15199	15256	15199
   query68	11472	532	521	521
   query69	511	252	252	252
   query70	1754	1527	1542	1527
   query71	475	224	225	224
   query72	5671	3578	3543	3543
   query73	2283	314	315	314
   query74	6942	6520	6433	6433
   query75	4839	2299	2289	2289
   query76	6152	1137	1152	1137
   query77	681	268	275	268
   query78	9103	8799	8619	8619
   query79	1071	514	496	496
   query80	544	369	362	362
   query81	457	211	215	211
   query82	216	105	102	102
   query83	155	139	133	133
   query84	235	53	62	53
   query85	898	275	272	272
   query86	376	368	383	368
   query87	3527	3449	3365	3365
   query88	3077	2256	2280	2256
   query89	339	254	268	254
   query90	1897	213	206	206
   query91	115	86	96	86
   query92	60	52	51	51
   query93	1805	487	495	487
   query94	795	191	186	186
   query95	465	414	421	414
   query96	620	318	319	318
   query97	4269	4168	4170	4168
   query98	200	191	190	190
   query99	1094	835	807	807
   Total cold run time: 282136 ms
   Total hot run time: 179246 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 4d313910ff5ebfa184f1d2c6736205bae28495c3, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17637	5435	5172	5172
   q2	2025	161	146	146
   q3	10612	1108	1175	1108
   q4	10288	746	877	746
   q5	7809	2947	2849	2849
   q6	219	138	137	137
   q7	937	519	546	519
   q8	9323	2037	2062	2037
   q9	6859	6425	6419	6419
   q10	8287	3069	3026	3026
   q11	431	216	211	211
   q12	388	232	236	232
   q13	18008	3670	3641	3641
   q14	247	219	213	213
   q15	566	528	525	525
   q16	454	433	401	401
   q17	965	523	479	479
   q18	7479	6764	6712	6712
   q19	1603	1361	1378	1361
   q20	718	328	338	328
   q21	2820	2403	2443	2403
   q22	382	327	332	327
   Total cold run time: 108057 ms
   Total hot run time: 38992 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5156	5187	5131	5131
   q2	347	233	239	233
   q3	3314	3304	3284	3284
   q4	2114	2012	2051	2012
   q5	5848	5800	5809	5800
   q6	217	124	129	124
   q7	2338	1964	1946	1946
   q8	3396	3470	3488	3470
   q9	8832	8803	8796	8796
   q10	3821	3870	3883	3870
   q11	580	492	476	476
   q12	796	657	639	639
   q13	8118	3213	3191	3191
   q14	294	258	280	258
   q15	591	521	517	517
   q16	567	503	514	503
   q17	1940	1779	1784	1779
   q18	8681	8441	8252	8252
   q19	1632	1596	1584	1584
   q20	2194	1956	1948	1948
   q21	5711	5249	5269	5249
   q22	537	458	525	458
   Total cold run time: 67024 ms
   Total hot run time: 59520 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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


##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/CreateMTMVInfo.java:
##########
@@ -224,7 +228,18 @@ public void analyzeQuery(ConnectContext ctx) {
         }
         getRelation(planner);
         getColumns(plan);
-        analyzePartition(planner);
+        SessionVariable sessionVariable = statementContext.getConnectContext().getSessionVariable();
+        Set<String> tempDisableRules = sessionVariable.getDisableNereidsRuleNames();
+        // Should not make table without data to empty relation, so add disable rules
+        sessionVariable.setDisableNereidsRules(MTMV_PLANER_DISABLE_RULES);
+        try {
+            analyzePartition(planner);
+        } finally {
+            if (!tempDisableRules.isEmpty()) {

Review Comment:
   should not add this `if`, always set back



-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit b6f1d1ac388fc503595752d297aaf4c67866b73e, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	5516	5084	5098	5084
   q2	389	156	168	156
   q3	1467	1126	1134	1126
   q4	1087	813	823	813
   q5	3157	3149	3189	3149
   q6	219	135	133	133
   q7	944	567	515	515
   q8	2156	2308	2392	2308
   q9	6713	6694	6682	6682
   q10	3166	3120	3173	3120
   q11	348	228	211	211
   q12	378	233	229	229
   q13	4386	3641	3658	3641
   q14	254	218	214	214
   q15	580	533	535	533
   q16	465	408	393	393
   q17	1055	536	520	520
   q18	7057	6711	6977	6711
   q19	1645	1503	1559	1503
   q20	564	346	347	346
   q21	2858	2472	2507	2472
   q22	404	322	329	322
   Total cold run time: 44808 ms
   Total hot run time: 40181 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	5093	5105	5083	5083
   q2	352	230	230	230
   q3	3361	3344	3324	3324
   q4	2172	2062	2054	2054
   q5	5946	5927	5944	5927
   q6	224	127	129	127
   q7	2405	1920	1945	1920
   q8	3552	3672	3698	3672
   q9	9074	9050	9034	9034
   q10	3903	3918	3947	3918
   q11	578	489	479	479
   q12	807	625	647	625
   q13	3846	3175	3166	3166
   q14	290	269	281	269
   q15	595	532	529	529
   q16	569	495	492	492
   q17	2020	1838	1826	1826
   q18	8735	8381	8390	8381
   q19	1747	1667	1705	1667
   q20	2259	1983	1967	1967
   q21	5813	5347	5326	5326
   q22	541	472	467	467
   Total cold run time: 63882 ms
   Total hot run time: 60483 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit b6f1d1ac388fc503595752d297aaf4c67866b73e, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17656	5127	5047	5047
   q2	2029	151	139	139
   q3	10565	1018	1061	1018
   q4	10176	782	782	782
   q5	7793	2881	2860	2860
   q6	210	131	131	131
   q7	906	565	499	499
   q8	9285	1974	1977	1974
   q9	6800	6400	6329	6329
   q10	8222	3027	3028	3027
   q11	417	210	206	206
   q12	384	226	226	226
   q13	17993	3625	3631	3625
   q14	250	209	200	200
   q15	558	526	511	511
   q16	444	385	393	385
   q17	949	487	505	487
   q18	7254	6737	6630	6630
   q19	1587	1297	1352	1297
   q20	704	348	312	312
   q21	2804	2333	2399	2333
   q22	381	324	338	324
   Total cold run time: 107367 ms
   Total hot run time: 38342 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5134	4955	5061	4955
   q2	338	227	231	227
   q3	3274	3287	3263	3263
   q4	2128	1986	2011	1986
   q5	5801	5768	5762	5762
   q6	213	124	125	124
   q7	2320	1880	1895	1880
   q8	3365	3411	3455	3411
   q9	8798	8742	8716	8716
   q10	3766	3831	3840	3831
   q11	580	468	491	468
   q12	788	630	637	630
   q13	7533	3239	3159	3159
   q14	293	274	262	262
   q15	578	521	540	521
   q16	524	504	511	504
   q17	1936	1754	1746	1746
   q18	8568	8369	8213	8213
   q19	1624	1569	1550	1550
   q20	2182	1967	1919	1919
   q21	5552	5265	5199	5199
   q22	545	479	462	462
   Total cold run time: 65840 ms
   Total hot run time: 58788 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 87c7369671a0a6464f498a4b0752902023d7c7a9, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17621	5280	5145	5145
   q2	2022	154	148	148
   q3	10628	1087	1142	1087
   q4	10554	777	830	777
   q5	7827	2890	2941	2890
   q6	213	130	132	130
   q7	917	519	547	519
   q8	9296	2011	2006	2006
   q9	6861	6391	6397	6391
   q10	8241	3049	2981	2981
   q11	415	209	217	209
   q12	380	233	227	227
   q13	18010	3676	3623	3623
   q14	241	217	211	211
   q15	566	539	507	507
   q16	461	410	410	410
   q17	973	471	524	471
   q18	7449	6760	6725	6725
   q19	1596	1339	1317	1317
   q20	722	357	340	340
   q21	2796	2330	2391	2330
   q22	382	315	330	315
   Total cold run time: 108171 ms
   Total hot run time: 38759 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5131	5095	5130	5095
   q2	337	237	237	237
   q3	3335	3299	3283	3283
   q4	2119	2033	1995	1995
   q5	5840	5804	5839	5804
   q6	217	125	126	125
   q7	2338	1935	1954	1935
   q8	3389	3469	3451	3451
   q9	8886	8800	8760	8760
   q10	3825	3833	3867	3833
   q11	575	487	484	484
   q12	801	632	650	632
   q13	8301	3210	3181	3181
   q14	306	268	280	268
   q15	582	510	521	510
   q16	552	508	504	504
   q17	1955	1776	1777	1776
   q18	8655	8355	8234	8234
   q19	1622	1590	1619	1590
   q20	2189	1954	1927	1927
   q21	5644	5224	5274	5224
   q22	547	485	458	458
   Total cold run time: 67146 ms
   Total hot run time: 59306 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38549 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 6f2ec5a87ed964d4ec35360ebe4114fae543af3a, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	12747	4941	4944	4941
   q2	406	151	148	148
   q3	1398	1192	1161	1161
   q4	1037	819	755	755
   q5	2930	3054	2984	2984
   q6	231	126	134	126
   q7	917	508	481	481
   q8	1919	2008	1995	1995
   q9	6395	6399	6352	6352
   q10	3079	3011	2969	2969
   q11	329	213	211	211
   q12	373	226	228	226
   q13	4117	3383	3369	3369
   q14	241	221	215	215
   q15	546	512	500	500
   q16	439	404	385	385
   q17	917	709	611	611
   q18	7140	6765	6635	6635
   q19	1496	1520	1513	1513
   q20	570	300	301	300
   q21	2643	2425	2368	2368
   q22	373	304	321	304
   Total cold run time: 50243 ms
   Total hot run time: 38549 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4891	4921	4908	4908
   q2	342	231	233	231
   q3	3286	3309	3263	3263
   q4	2118	2012	1997	1997
   q5	5796	5781	5767	5767
   q6	206	115	116	115
   q7	2333	1904	1928	1904
   q8	3369	3412	3464	3412
   q9	8737	8698	8700	8698
   q10	3819	3860	3821	3821
   q11	545	429	433	429
   q12	789	635	623	623
   q13	3836	3170	3196	3170
   q14	291	255	248	248
   q15	543	512	496	496
   q16	538	500	489	489
   q17	1842	1833	1841	1833
   q18	8554	8225	8177	8177
   q19	1598	1618	1620	1618
   q20	2184	1953	1936	1936
   q21	5619	5285	5260	5260
   q22	544	442	451	442
   Total cold run time: 61780 ms
   Total hot run time: 58837 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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 42c3c22d09402b0fc103c1bc9eb0bc7f614343fb, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	5480	5135	5123	5123
   q2	393	162	159	159
   q3	1463	1232	1195	1195
   q4	1087	752	775	752
   q5	3126	3111	3107	3107
   q6	221	131	132	131
   q7	968	555	514	514
   q8	2176	2305	2256	2256
   q9	6715	6715	6654	6654
   q10	3191	3175	3129	3129
   q11	336	230	217	217
   q12	385	234	234	234
   q13	4401	3644	3617	3617
   q14	243	213	207	207
   q15	570	539	533	533
   q16	463	387	411	387
   q17	1050	514	648	514
   q18	7141	6804	6749	6749
   q19	1661	1490	1423	1423
   q20	603	347	319	319
   q21	2855	2490	2430	2430
   q22	383	336	334	334
   Total cold run time: 44911 ms
   Total hot run time: 39984 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	5089	5132	5072	5072
   q2	337	229	229	229
   q3	3346	3323	3315	3315
   q4	2159	2060	2047	2047
   q5	5934	5922	5921	5921
   q6	223	125	127	125
   q7	2392	1938	1930	1930
   q8	3564	3660	3686	3660
   q9	9046	9048	8996	8996
   q10	3854	3905	3930	3905
   q11	583	496	490	490
   q12	795	618	628	618
   q13	3882	3202	3203	3202
   q14	292	266	270	266
   q15	589	535	521	521
   q16	561	499	492	492
   q17	2034	1798	1824	1798
   q18	8715	8446	8310	8310
   q19	1767	1725	1699	1699
   q20	2275	2012	1957	1957
   q21	5834	5424	5369	5369
   q22	549	458	533	458
   Total cold run time: 63820 ms
   Total hot run time: 60380 ms
   ```
   


-- 
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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   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] [Fix](nereids) Fix get ralated partition table when nodata [doris]

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

   
   TPC-DS test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with scripts in https://github.com/apache/doris/tree/master/tools/tpcds-tools
   ```
   TPC-DS sf100 test result on commit 87c7369671a0a6464f498a4b0752902023d7c7a9, data reload: false
   
   run tpcds-sf100 query with default conf and session variables
   query1	923	353	338	338
   query2	6409	2072	1871	1871
   query3	6646	219	204	204
   query4	26114	22531	22371	22371
   query5	4441	522	505	505
   query6	287	182	192	182
   query7	4584	272	265	265
   query8	231	214	189	189
   query9	8234	2507	2488	2488
   query10	385	245	250	245
   query11	16227	15492	15519	15492
   query12	131	73	77	73
   query13	1633	318	316	316
   query14	11317	7163	7152	7152
   query15	224	189	196	189
   query16	6378	267	253	253
   query17	1870	489	486	486
   query18	1944	273	260	260
   query19	203	136	133	133
   query20	81	75	75	75
   query21	189	107	95	95
   query22	5098	4866	4817	4817
   query23	32018	31291	31375	31291
   query24	12063	2822	2785	2785
   query25	601	342	333	333
   query26	1741	137	135	135
   query27	2920	278	270	270
   query28	6878	1863	1851	1851
   query29	1992	394	391	391
   query30	285	139	149	139
   query31	989	763	781	763
   query32	88	59	54	54
   query33	721	246	261	246
   query34	920	447	441	441
   query35	856	782	767	767
   query36	1343	1182	1259	1182
   query37	186	63	64	63
   query38	3422	3300	3260	3260
   query39	1339	1279	1281	1279
   query40	303	86	88	86
   query41	37	35	35	35
   query42	97	90	83	83
   query43	537	506	483	483
   query44	1121	680	695	680
   query45	193	184	186	184
   query46	1054	649	636	636
   query47	1631	1547	1522	1522
   query48	323	253	247	247
   query49	1222	310	312	310
   query50	736	309	324	309
   query51	5469	5410	5262	5262
   query52	101	79	88	79
   query53	203	153	145	145
   query54	1354	554	549	549
   query55	89	85	84	84
   query56	194	174	193	174
   query57	1061	926	954	926
   query58	216	192	199	192
   query59	2772	2634	2586	2586
   query60	230	204	215	204
   query61	84	88	81	81
   query62	633	465	460	460
   query63	172	146	143	143
   query64	5735	1701	1708	1701
   query65	3332	3222	3275	3222
   query66	1396	346	333	333
   query67	15916	15488	15013	15013
   query68	12290	522	532	522
   query69	497	249	236	236
   query70	1654	1449	1481	1449
   query71	495	219	217	217
   query72	5608	3523	3507	3507
   query73	2826	312	306	306
   query74	7055	6547	6468	6468
   query75	5203	2329	2300	2300
   query76	6294	1122	1079	1079
   query77	674	288	262	262
   query78	9114	8821	8524	8524
   query79	1044	506	503	503
   query80	569	336	334	334
   query81	456	208	207	207
   query82	214	97	86	86
   query83	157	139	134	134
   query84	242	53	51	51
   query85	963	260	263	260
   query86	398	390	417	390
   query87	3553	3429	3365	3365
   query88	3142	2231	2244	2231
   query89	319	254	246	246
   query90	1947	192	195	192
   query91	116	90	91	90
   query92	59	49	51	49
   query93	1892	485	424	424
   query94	836	178	176	176
   query95	445	422	405	405
   query96	633	321	315	315
   query97	4264	4160	4157	4157
   query98	221	192	190	190
   query99	1136	816	881	816
   Total cold run time: 292438 ms
   Total hot run time: 178469 ms
   ```
   


-- 
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