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

[PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]

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

   ## Proposed changes
   
   Issue Number: close #xxx
   
   before:
   ```
   mysql> create table illegal(
       -> k0 datetime(6) NOT null,
       -> k1 datetime(6) NOT null
       -> )
       -> auto partition by range date_trunc(k0, k1, 'hour')
       -> (
       -> )
       -> DISTRIBUTED BY HASH(`k0`) BUCKETS 2
       -> properties("replication_num" = "1");
   Query OK, 0 rows affected (0.15 sec)
   ```
   
   now:
   ```
   mysql> create table illegal( k0 datetime(6) NOT null, k1 datetime(6) NOT null ) auto partition by range date_trunc(k0, k1, 'hour') ( ) DISTRIBUTED BY HASH(`k0`) BUCKETS 2 properties("replication_num" = "1");
   ERROR 1105 (HY000): errCode = 2, detailMessage = errCode = 2, detailMessage = partition expr date_trunc is illegal!
   ```
   
   ## 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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 169277 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 35417fe1a3bf518d7139a6c94d6471484db82a09, data reload: false
   
   query1	926	331	327	327
   query2	6559	1696	1704	1696
   query3	6698	216	210	210
   query4	23519	20586	20526	20526
   query5	4297	365	354	354
   query6	256	177	172	172
   query7	4603	298	294	294
   query8	254	187	192	187
   query9	8406	2234	2219	2219
   query10	415	208	217	208
   query11	14565	14163	14067	14067
   query12	141	83	81	81
   query13	1648	426	418	418
   query14	8477	6729	6608	6608
   query15	207	178	174	174
   query16	7082	253	252	252
   query17	1053	518	498	498
   query18	1895	279	259	259
   query19	191	143	148	143
   query20	88	81	83	81
   query21	199	130	113	113
   query22	4768	4505	4553	4505
   query23	30533	29864	29920	29864
   query24	11981	3114	3060	3060
   query25	645	349	355	349
   query26	1855	152	155	152
   query27	3031	313	321	313
   query28	7036	1797	1768	1768
   query29	1226	558	550	550
   query30	285	133	137	133
   query31	868	683	683	683
   query32	97	60	59	59
   query33	712	220	227	220
   query34	1031	491	490	490
   query35	866	736	749	736
   query36	934	837	822	822
   query37	266	61	62	61
   query38	3074	2978	2975	2975
   query39	1314	1260	1248	1248
   query40	278	100	98	98
   query41	37	36	35	35
   query42	110	100	101	100
   query43	464	424	465	424
   query44	1078	688	703	688
   query45	188	184	170	170
   query46	1036	794	767	767
   query47	1545	1481	1504	1481
   query48	417	338	345	338
   query49	1165	320	295	295
   query50	768	370	379	370
   query51	4371	4375	4305	4305
   query52	99	90	96	90
   query53	335	262	266	262
   query54	295	222	221	221
   query55	93	84	81	81
   query56	224	202	196	196
   query57	991	913	886	886
   query58	210	196	199	196
   query59	2159	2144	2041	2041
   query60	238	225	210	210
   query61	86	84	81	81
   query62	592	360	323	323
   query63	280	254	274	254
   query64	6549	3036	3095	3036
   query65	3216	3192	3196	3192
   query66	1443	319	325	319
   query67	14386	14179	14184	14179
   query68	3864	546	567	546
   query69	497	373	373	373
   query70	1221	1158	1212	1158
   query71	322	246	253	246
   query72	5908	2816	2660	2660
   query73	703	329	327	327
   query74	6323	6043	6028	6028
   query75	3032	2429	2417	2417
   query76	2348	1031	1165	1031
   query77	329	237	225	225
   query78	8921	8440	8449	8440
   query79	1582	517	515	515
   query80	1109	360	366	360
   query81	475	192	196	192
   query82	954	86	84	84
   query83	216	122	120	120
   query84	274	80	80	80
   query85	1312	353	340	340
   query86	374	266	302	266
   query87	3301	3087	3145	3087
   query88	2746	2361	2320	2320
   query89	385	343	328	328
   query90	1914	172	169	169
   query91	171	125	122	122
   query92	57	46	50	46
   query93	1270	496	490	490
   query94	1287	181	178	178
   query95	438	341	342	341
   query96	579	266	267	266
   query97	4227	4157	4165	4157
   query98	214	194	190	190
   query99	1067	697	662	662
   Total cold run time: 262074 ms
   Total hot run time: 169277 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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 169202 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 2379a640801bfcf80a749527d66547afd5a6c097, data reload: false
   
   query1	925	354	336	336
   query2	6518	1753	1710	1710
   query3	6718	209	203	203
   query4	23367	20783	20521	20521
   query5	4313	362	368	362
   query6	260	171	165	165
   query7	4617	290	291	290
   query8	247	191	199	191
   query9	8517	2240	2231	2231
   query10	423	221	213	213
   query11	14729	14183	14118	14118
   query12	137	83	85	83
   query13	1645	424	433	424
   query14	8345	6618	6257	6257
   query15	208	172	185	172
   query16	7104	259	259	259
   query17	1031	519	508	508
   query18	1897	290	269	269
   query19	199	149	150	149
   query20	88	81	80	80
   query21	197	131	115	115
   query22	4855	4658	4645	4645
   query23	30514	29988	29935	29935
   query24	11961	3081	3120	3081
   query25	639	354	345	345
   query26	1845	155	165	155
   query27	3053	320	307	307
   query28	7058	1833	1816	1816
   query29	1224	561	554	554
   query30	284	130	141	130
   query31	852	672	689	672
   query32	101	59	57	57
   query33	716	213	221	213
   query34	1058	486	487	486
   query35	867	754	746	746
   query36	920	908	890	890
   query37	225	65	62	62
   query38	3126	3019	3026	3019
   query39	1306	1267	1247	1247
   query40	278	105	96	96
   query41	38	37	35	35
   query42	101	97	97	97
   query43	446	470	417	417
   query44	1076	708	716	708
   query45	192	173	167	167
   query46	1026	778	767	767
   query47	1473	1448	1456	1448
   query48	421	346	339	339
   query49	1179	299	293	293
   query50	776	374	372	372
   query51	4382	4250	4293	4250
   query52	102	90	89	89
   query53	330	270	267	267
   query54	293	221	226	221
   query55	87	84	79	79
   query56	220	197	199	197
   query57	955	918	883	883
   query58	210	192	196	192
   query59	2101	1967	2117	1967
   query60	239	221	209	209
   query61	86	87	86	86
   query62	591	367	357	357
   query63	297	265	264	264
   query64	6586	2971	3117	2971
   query65	3238	3235	3206	3206
   query66	1442	330	327	327
   query67	14238	14160	14076	14076
   query68	5046	546	577	546
   query69	531	392	370	370
   query70	1246	1165	1136	1136
   query71	394	248	246	246
   query72	6224	2823	2667	2667
   query73	706	316	316	316
   query74	6244	5987	5950	5950
   query75	3060	2465	2399	2399
   query76	2853	1026	1150	1026
   query77	339	238	227	227
   query78	9085	8632	8579	8579
   query79	980	533	534	533
   query80	528	358	356	356
   query81	454	196	196	196
   query82	163	93	84	84
   query83	140	123	119	119
   query84	258	76	76	76
   query85	1032	353	359	353
   query86	294	288	298	288
   query87	3269	3116	3083	3083
   query88	2690	2284	2261	2261
   query89	376	321	344	321
   query90	1818	169	167	167
   query91	153	126	125	125
   query92	57	47	54	47
   query93	1006	523	532	523
   query94	1068	186	182	182
   query95	448	348	346	346
   query96	572	262	260	260
   query97	4228	4152	4158	4152
   query98	217	197	194	194
   query99	1020	691	678	678
   Total cold run time: 260991 ms
   Total hot run time: 169202 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) forbid create table with illegal auto partition expr [doris]

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

   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) forbid create table with illegal auto partition expr [doris]

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

   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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.57 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 868a461d21c92481867ab5ccd8644f728d5c01e3, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.06	0.02	0.03
   query3	0.23	0.06	0.06
   query4	1.67	0.10	0.10
   query5	0.52	0.52	0.52
   query6	1.29	0.68	0.68
   query7	0.02	0.01	0.01
   query8	0.03	0.02	0.02
   query9	0.58	0.49	0.52
   query10	0.56	0.56	0.56
   query11	0.12	0.10	0.09
   query12	0.13	0.10	0.10
   query13	0.62	0.62	0.61
   query14	0.79	0.79	0.81
   query15	0.83	0.82	0.81
   query16	0.37	0.38	0.37
   query17	0.97	0.96	1.00
   query18	0.25	0.25	0.26
   query19	1.79	1.67	1.78
   query20	0.01	0.02	0.02
   query21	15.41	0.65	0.67
   query22	3.22	4.58	2.01
   query23	17.46	1.05	0.99
   query24	2.15	0.74	0.12
   query25	0.18	0.05	0.04
   query26	0.15	0.14	0.14
   query27	0.03	0.04	0.03
   query28	12.38	0.83	0.81
   query29	12.59	3.45	3.33
   query30	0.60	0.52	0.53
   query31	2.77	0.35	0.36
   query32	3.36	0.47	0.48
   query33	3.17	3.17	3.23
   query34	15.37	4.73	4.75
   query35	4.79	4.72	4.76
   query36	1.14	1.06	1.07
   query37	0.07	0.05	0.05
   query38	0.04	0.02	0.02
   query39	0.02	0.02	0.02
   query40	0.17	0.15	0.13
   query41	0.07	0.02	0.01
   query42	0.03	0.02	0.02
   query43	0.02	0.02	0.02
   Total cold run time: 106.07 s
   Total hot run time: 31.57 s
   ```
   </details>
   


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

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

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


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


Re: [PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]

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

   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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 38430 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 2379a640801bfcf80a749527d66547afd5a6c097, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	18352	4186	4167	4167
   q2	2104	147	146	146
   q3	11535	975	963	963
   q4	4826	972	970	970
   q5	8405	3029	3114	3029
   q6	184	127	124	124
   q7	1288	786	788	786
   q8	9642	2053	2048	2048
   q9	7238	6350	6304	6304
   q10	8177	2505	2503	2503
   q11	420	218	220	218
   q12	781	324	317	317
   q13	17938	3254	3221	3221
   q14	280	244	254	244
   q15	537	507	483	483
   q16	466	402	426	402
   q17	941	899	897	897
   q18	6694	5947	6089	5947
   q19	1576	1535	1514	1514
   q20	553	281	270	270
   q21	6621	3587	3617	3587
   q22	791	290	291	290
   Total cold run time: 109349 ms
   Total hot run time: 38430 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4017	4005	4015	4005
   q2	313	213	220	213
   q3	2996	2920	2987	2920
   q4	1854	1850	1868	1850
   q5	5190	5078	5156	5078
   q6	201	115	116	115
   q7	2137	1786	1731	1731
   q8	3157	3201	3224	3201
   q9	8307	8299	8257	8257
   q10	6202	3691	3680	3680
   q11	510	434	425	425
   q12	701	566	520	520
   q13	3802	3100	3083	3083
   q14	283	255	256	255
   q15	536	493	489	489
   q16	519	457	465	457
   q17	1708	1696	1686	1686
   q18	7764	7647	7399	7399
   q19	1688	1648	1646	1646
   q20	2092	1896	1886	1886
   q21	4762	4614	4667	4614
   q22	497	434	432	432
   Total cold run time: 59236 ms
   Total hot run time: 53942 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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 32.78 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 8425ba6d368d1ff3c35b76519bfa725c436b14ef, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.07	0.03	0.02
   query3	0.23	0.05	0.06
   query4	1.66	0.10	0.10
   query5	0.53	0.51	0.52
   query6	1.26	0.67	0.68
   query7	0.02	0.01	0.01
   query8	0.03	0.03	0.03
   query9	0.55	0.50	0.52
   query10	0.57	0.58	0.56
   query11	0.13	0.09	0.09
   query12	0.11	0.10	0.10
   query13	0.62	0.61	0.60
   query14	0.79	0.80	0.80
   query15	0.83	0.82	0.82
   query16	0.38	0.38	0.37
   query17	1.01	0.97	0.95
   query18	0.26	0.25	0.26
   query19	1.80	1.69	1.72
   query20	0.01	0.01	0.02
   query21	15.42	0.62	0.65
   query22	3.09	3.61	3.07
   query23	17.74	1.06	0.98
   query24	2.27	0.44	0.39
   query25	0.22	0.06	0.06
   query26	0.17	0.14	0.14
   query27	0.03	0.03	0.04
   query28	12.12	0.84	0.83
   query29	12.59	3.41	3.18
   query30	0.55	0.56	0.53
   query31	2.80	0.34	0.36
   query32	3.35	0.48	0.47
   query33	3.21	3.21	3.25
   query34	15.34	4.75	4.74
   query35	4.76	4.73	4.75
   query36	1.15	1.06	1.06
   query37	0.07	0.05	0.04
   query38	0.04	0.03	0.02
   query39	0.03	0.01	0.01
   query40	0.17	0.13	0.14
   query41	0.08	0.01	0.01
   query42	0.02	0.01	0.02
   query43	0.03	0.02	0.02
   Total cold run time: 106.15 s
   Total hot run time: 32.78 s
   ```
   </details>
   


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

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

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


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


Re: [PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 868a461d21c92481867ab5ccd8644f728d5c01e3 with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       18.0 seconds inserted 10000000 Rows, about 555K ops/s
   ```
   


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

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

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


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


Re: [PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37470 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 578da166d70da4fe17ef709a34b71b341f21b75b, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17748	3996	4014	3996
   q2	2043	139	133	133
   q3	10597	927	934	927
   q4	4661	923	936	923
   q5	7627	2855	2952	2855
   q6	178	121	122	121
   q7	1234	753	736	736
   q8	9257	1971	2016	1971
   q9	7201	6242	6260	6242
   q10	8153	2475	2488	2475
   q11	421	214	214	214
   q12	765	306	314	306
   q13	17922	3198	3217	3198
   q14	273	253	252	252
   q15	528	496	499	496
   q16	488	408	405	405
   q17	930	865	852	852
   q18	6608	5949	5911	5911
   q19	1566	1499	1499	1499
   q20	541	266	266	266
   q21	6312	3408	3546	3408
   q22	803	284	286	284
   Total cold run time: 105856 ms
   Total hot run time: 37470 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	3985	3955	3968	3955
   q2	305	225	214	214
   q3	2955	2943	2953	2943
   q4	1875	1800	1791	1791
   q5	5126	5075	5085	5075
   q6	197	115	116	115
   q7	2135	1682	1737	1682
   q8	3103	3173	3207	3173
   q9	8210	8199	8209	8199
   q10	6087	3632	3643	3632
   q11	508	427	426	426
   q12	682	528	520	520
   q13	8970	3053	3039	3039
   q14	268	250	254	250
   q15	531	494	495	494
   q16	499	448	469	448
   q17	1696	1693	1668	1668
   q18	7749	7527	7369	7369
   q19	1636	1619	1625	1619
   q20	2076	1887	1899	1887
   q21	4802	4675	4581	4581
   q22	496	425	432	425
   Total cold run time: 63891 ms
   Total hot run time: 53505 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) forbid create table with illegal auto partition expr [doris]

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

   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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 32.29 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 578da166d70da4fe17ef709a34b71b341f21b75b, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.07	0.03	0.03
   query3	0.23	0.06	0.06
   query4	1.68	0.10	0.10
   query5	0.52	0.51	0.51
   query6	1.29	0.68	0.68
   query7	0.02	0.02	0.01
   query8	0.03	0.03	0.03
   query9	0.56	0.53	0.52
   query10	0.57	0.59	0.57
   query11	0.12	0.10	0.10
   query12	0.13	0.10	0.10
   query13	0.62	0.61	0.61
   query14	0.78	0.81	0.82
   query15	0.83	0.82	0.82
   query16	0.38	0.36	0.36
   query17	0.98	0.99	0.96
   query18	0.27	0.25	0.26
   query19	1.88	1.67	1.74
   query20	0.01	0.00	0.01
   query21	15.40	0.66	0.66
   query22	3.55	3.82	2.50
   query23	17.57	1.07	0.94
   query24	2.18	0.35	0.58
   query25	0.34	0.06	0.04
   query26	0.17	0.14	0.13
   query27	0.03	0.04	0.03
   query28	12.09	0.83	0.83
   query29	12.55	3.43	3.23
   query30	0.60	0.53	0.53
   query31	2.79	0.34	0.36
   query32	3.35	0.47	0.48
   query33	3.22	3.18	3.20
   query34	15.35	4.77	4.78
   query35	4.74	4.78	4.74
   query36	1.14	1.07	1.07
   query37	0.07	0.05	0.05
   query38	0.04	0.02	0.03
   query39	0.02	0.02	0.02
   query40	0.17	0.13	0.15
   query41	0.07	0.01	0.01
   query42	0.02	0.02	0.01
   query43	0.02	0.02	0.03
   Total cold run time: 106.49 s
   Total hot run time: 32.29 s
   ```
   </details>
   


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

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

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


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


Re: [PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37876 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 868a461d21c92481867ab5ccd8644f728d5c01e3, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17636	4264	4036	4036
   q2	2062	142	134	134
   q3	10682	960	933	933
   q4	4691	943	953	943
   q5	7622	2859	3012	2859
   q6	180	122	120	120
   q7	1241	761	755	755
   q8	9347	1995	2057	1995
   q9	7143	6269	6298	6269
   q10	8187	2500	2522	2500
   q11	420	213	214	213
   q12	754	316	306	306
   q13	17954	3220	3198	3198
   q14	282	249	256	249
   q15	528	487	489	487
   q16	464	393	420	393
   q17	936	842	856	842
   q18	6739	6022	6033	6022
   q19	1574	1507	1510	1507
   q20	537	278	263	263
   q21	6692	3575	3575	3575
   q22	795	277	288	277
   Total cold run time: 106466 ms
   Total hot run time: 37876 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	3996	4011	3998	3998
   q2	306	228	210	210
   q3	2982	2909	2960	2909
   q4	1833	1798	1771	1771
   q5	5134	5183	5126	5126
   q6	198	114	114	114
   q7	2137	1790	1725	1725
   q8	3133	3197	3201	3197
   q9	8313	8286	8238	8238
   q10	6144	3670	3648	3648
   q11	509	414	449	414
   q12	674	538	527	527
   q13	5037	3064	3042	3042
   q14	285	260	250	250
   q15	545	493	483	483
   q16	503	465	460	460
   q17	1705	1675	1688	1675
   q18	7906	7585	7513	7513
   q19	1638	1633	1628	1628
   q20	2069	1908	1887	1887
   q21	4766	4603	4640	4603
   q22	510	443	461	443
   Total cold run time: 60323 ms
   Total hot run time: 53861 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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.01 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 35417fe1a3bf518d7139a6c94d6471484db82a09, data reload: false
   
   query1	0.04	0.03	0.04
   query2	0.06	0.02	0.03
   query3	0.25	0.06	0.06
   query4	1.65	0.10	0.09
   query5	0.52	0.52	0.51
   query6	1.31	0.67	0.68
   query7	0.01	0.01	0.02
   query8	0.03	0.02	0.02
   query9	0.55	0.50	0.51
   query10	0.57	0.57	0.57
   query11	0.12	0.09	0.10
   query12	0.12	0.11	0.10
   query13	0.62	0.61	0.62
   query14	0.80	0.81	0.82
   query15	0.83	0.82	0.81
   query16	0.37	0.37	0.37
   query17	0.96	0.95	0.98
   query18	0.25	0.24	0.25
   query19	1.79	1.71	1.74
   query20	0.01	0.01	0.01
   query21	15.41	0.62	0.55
   query22	3.07	3.16	1.35
   query23	17.92	1.06	1.08
   query24	2.00	0.76	0.12
   query25	0.32	0.12	0.10
   query26	0.16	0.15	0.16
   query27	0.05	0.05	0.04
   query28	12.25	0.84	0.86
   query29	12.73	3.55	3.31
   query30	0.58	0.58	0.54
   query31	2.81	0.34	0.36
   query32	3.34	0.48	0.48
   query33	3.18	3.21	3.17
   query34	15.33	4.73	4.75
   query35	4.78	4.77	4.74
   query36	1.13	1.07	1.07
   query37	0.07	0.05	0.05
   query38	0.04	0.03	0.02
   query39	0.02	0.02	0.01
   query40	0.16	0.12	0.13
   query41	0.07	0.01	0.02
   query42	0.02	0.02	0.01
   query43	0.03	0.02	0.02
   Total cold run time: 106.33 s
   Total hot run time: 31.01 s
   ```
   </details>
   


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

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

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


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


Re: [PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]

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

   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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 169013 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 578da166d70da4fe17ef709a34b71b341f21b75b, data reload: false
   
   query1	937	338	329	329
   query2	6548	1635	1812	1635
   query3	6696	209	206	206
   query4	23586	20939	20675	20675
   query5	4266	358	349	349
   query6	272	184	173	173
   query7	5722	314	308	308
   query8	1012	197	203	197
   query9	9030	2287	2256	2256
   query10	415	222	217	217
   query11	14675	14244	14158	14158
   query12	128	82	82	82
   query13	1644	427	447	427
   query14	9002	6665	6356	6356
   query15	224	183	188	183
   query16	7635	273	285	273
   query17	1409	583	559	559
   query18	3794	311	299	299
   query19	653	163	178	163
   query20	301	103	109	103
   query21	595	145	139	139
   query22	5217	4556	4580	4556
   query23	30408	29892	29875	29875
   query24	11933	3139	3093	3093
   query25	640	355	349	349
   query26	1795	154	159	154
   query27	2992	316	303	303
   query28	6977	1839	1845	1839
   query29	1120	559	567	559
   query30	284	132	139	132
   query31	875	678	699	678
   query32	101	60	59	59
   query33	700	225	218	218
   query34	1051	488	483	483
   query35	849	733	741	733
   query36	964	891	844	844
   query37	255	60	66	60
   query38	3069	2996	3007	2996
   query39	1285	1260	1243	1243
   query40	282	101	99	99
   query41	38	36	34	34
   query42	106	96	96	96
   query43	501	461	418	418
   query44	1065	683	701	683
   query45	192	176	172	172
   query46	1033	769	784	769
   query47	1520	1399	1466	1399
   query48	409	334	338	334
   query49	1221	284	295	284
   query50	762	360	358	358
   query51	4428	4271	4282	4271
   query52	101	89	91	89
   query53	332	270	262	262
   query54	287	215	219	215
   query55	79	84	77	77
   query56	222	199	197	197
   query57	980	920	859	859
   query58	213	197	193	193
   query59	2162	2024	2138	2024
   query60	234	215	215	215
   query61	87	95	90	90
   query62	592	356	330	330
   query63	276	256	259	256
   query64	6409	2948	3115	2948
   query65	3212	3210	3216	3210
   query66	1381	317	313	313
   query67	14549	14350	13887	13887
   query68	4907	556	558	556
   query69	518	370	351	351
   query70	1190	1253	1251	1251
   query71	418	246	246	246
   query72	6235	2809	2668	2668
   query73	701	317	324	317
   query74	6334	5977	5961	5961
   query75	3103	2447	2433	2433
   query76	3229	1038	1140	1038
   query77	343	228	232	228
   query78	8943	8493	8494	8493
   query79	959	515	515	515
   query80	510	356	347	347
   query81	445	199	195	195
   query82	238	82	80	80
   query83	136	122	124	122
   query84	231	74	78	74
   query85	1045	359	346	346
   query86	291	299	300	299
   query87	3260	3129	3030	3030
   query88	2641	2246	2239	2239
   query89	383	361	321	321
   query90	1966	160	160	160
   query91	155	124	125	124
   query92	53	48	48	48
   query93	1025	520	498	498
   query94	1097	185	178	178
   query95	427	322	336	322
   query96	565	259	258	258
   query97	4232	4125	4135	4125
   query98	202	202	199	199
   query99	1063	648	684	648
   Total cold run time: 268577 ms
   Total hot run time: 169013 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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37546 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 35417fe1a3bf518d7139a6c94d6471484db82a09, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17740	3995	3973	3973
   q2	2044	142	134	134
   q3	10579	943	920	920
   q4	4664	931	934	931
   q5	7610	2871	2971	2871
   q6	182	122	120	120
   q7	1229	746	725	725
   q8	9237	1950	1992	1950
   q9	7155	6241	6242	6241
   q10	8185	2490	2494	2490
   q11	421	217	211	211
   q12	794	307	307	307
   q13	17949	3201	3202	3201
   q14	272	246	256	246
   q15	526	506	493	493
   q16	472	397	399	397
   q17	921	864	869	864
   q18	6633	5966	5951	5951
   q19	1572	1491	1498	1491
   q20	549	285	275	275
   q21	6229	3464	3533	3464
   q22	808	291	291	291
   Total cold run time: 105771 ms
   Total hot run time: 37546 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	3999	3996	3981	3981
   q2	300	219	223	219
   q3	2976	2931	2922	2922
   q4	1806	1819	1802	1802
   q5	5093	5081	5091	5081
   q6	197	115	115	115
   q7	2140	1751	1691	1691
   q8	3103	3181	3183	3181
   q9	8255	8241	8268	8241
   q10	6129	3632	3623	3623
   q11	498	428	428	428
   q12	683	518	530	518
   q13	11956	3055	3027	3027
   q14	275	259	262	259
   q15	530	497	491	491
   q16	515	459	467	459
   q17	1681	1661	1662	1661
   q18	7790	7376	7426	7376
   q19	1648	1625	1624	1624
   q20	2097	1903	1906	1903
   q21	4738	4735	4660	4660
   q22	505	430	443	430
   Total cold run time: 66914 ms
   Total hot run time: 53692 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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 169450 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 8425ba6d368d1ff3c35b76519bfa725c436b14ef, data reload: false
   
   query1	921	333	333	333
   query2	6563	1681	1743	1681
   query3	6695	213	213	213
   query4	23086	20632	20746	20632
   query5	4336	370	361	361
   query6	263	165	165	165
   query7	4612	304	299	299
   query8	263	195	206	195
   query9	8455	2270	2277	2270
   query10	424	207	205	205
   query11	14838	14360	14386	14360
   query12	133	85	82	82
   query13	1647	457	442	442
   query14	8417	6767	6357	6357
   query15	225	185	196	185
   query16	7373	295	271	271
   query17	1411	577	553	553
   query18	2704	313	305	305
   query19	507	180	199	180
   query20	140	96	99	96
   query21	823	149	160	149
   query22	5388	4506	4594	4506
   query23	30808	29960	29925	29925
   query24	12043	3087	3112	3087
   query25	635	343	351	343
   query26	1867	157	164	157
   query27	3059	305	311	305
   query28	6993	1835	1831	1831
   query29	1209	557	555	555
   query30	288	132	143	132
   query31	895	671	686	671
   query32	100	66	57	57
   query33	716	229	226	226
   query34	1060	479	494	479
   query35	858	745	742	742
   query36	933	853	879	853
   query37	179	61	62	61
   query38	3076	2928	2983	2928
   query39	1320	1252	1240	1240
   query40	280	104	103	103
   query41	39	37	36	36
   query42	105	104	96	96
   query43	458	421	431	421
   query44	1073	691	706	691
   query45	191	180	175	175
   query46	1029	792	783	783
   query47	1573	1416	1438	1416
   query48	428	343	337	337
   query49	1237	311	303	303
   query50	767	369	373	369
   query51	4331	4286	4265	4265
   query52	107	97	96	96
   query53	337	260	268	260
   query54	295	220	223	220
   query55	89	77	81	77
   query56	218	199	200	199
   query57	964	901	864	864
   query58	218	194	198	194
   query59	2191	2045	2017	2017
   query60	235	211	215	211
   query61	90	81	81	81
   query62	617	362	359	359
   query63	279	257	267	257
   query64	6406	2991	3422	2991
   query65	3232	3333	3213	3213
   query66	1364	321	312	312
   query67	14184	14093	14081	14081
   query68	5024	566	585	566
   query69	529	382	380	380
   query70	1240	1227	1209	1209
   query71	409	250	255	250
   query72	6234	2771	2653	2653
   query73	697	326	323	323
   query74	6308	5972	5967	5967
   query75	3105	2431	2408	2408
   query76	3216	1043	1138	1043
   query77	346	238	225	225
   query78	9178	8660	8424	8424
   query79	1131	531	542	531
   query80	903	359	347	347
   query81	477	198	194	194
   query82	1248	89	90	89
   query83	223	123	117	117
   query84	233	77	75	75
   query85	1314	349	337	337
   query86	371	295	310	295
   query87	3258	3079	3071	3071
   query88	2712	2235	2225	2225
   query89	402	328	320	320
   query90	1900	171	164	164
   query91	149	121	121	121
   query92	54	49	51	49
   query93	1067	534	506	506
   query94	1321	179	178	178
   query95	448	335	339	335
   query96	582	257	262	257
   query97	4281	4111	4161	4111
   query98	212	201	190	190
   query99	1023	646	631	631
   Total cold run time: 267195 ms
   Total hot run time: 169450 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) forbid create table with illegal auto partition expr [doris]

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

   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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 169245 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 868a461d21c92481867ab5ccd8644f728d5c01e3, data reload: false
   
   query1	934	343	336	336
   query2	6528	1766	1696	1696
   query3	6713	202	203	202
   query4	23523	20522	20606	20522
   query5	4283	362	362	362
   query6	266	164	171	164
   query7	4599	287	294	287
   query8	252	197	193	193
   query9	8372	2222	2218	2218
   query10	417	220	225	220
   query11	14656	14239	14103	14103
   query12	141	83	81	81
   query13	1629	462	427	427
   query14	8462	6643	6471	6471
   query15	217	181	182	181
   query16	7086	258	257	257
   query17	1036	527	501	501
   query18	1911	280	263	263
   query19	194	146	148	146
   query20	85	79	88	79
   query21	197	123	114	114
   query22	4975	4759	4770	4759
   query23	30505	29866	29765	29765
   query24	11963	3043	3113	3043
   query25	649	346	341	341
   query26	1831	154	163	154
   query27	3049	312	318	312
   query28	6996	1817	1824	1817
   query29	1124	552	551	551
   query30	287	132	140	132
   query31	873	685	680	680
   query32	85	54	56	54
   query33	724	219	232	219
   query34	1060	472	484	472
   query35	854	735	746	735
   query36	950	882	835	835
   query37	230	59	60	59
   query38	3084	3022	2990	2990
   query39	1288	1242	1237	1237
   query40	280	100	102	100
   query41	40	37	35	35
   query42	102	95	98	95
   query43	462	437	418	418
   query44	1058	694	720	694
   query45	188	180	171	171
   query46	1031	795	793	793
   query47	1553	1507	1461	1461
   query48	410	340	334	334
   query49	1153	299	289	289
   query50	766	365	366	365
   query51	4456	4286	4290	4286
   query52	101	89	90	89
   query53	339	261	264	261
   query54	297	216	224	216
   query55	82	78	71	71
   query56	231	195	206	195
   query57	976	874	882	874
   query58	217	194	193	193
   query59	2158	1957	2124	1957
   query60	229	217	209	209
   query61	89	89	85	85
   query62	609	338	363	338
   query63	288	257	250	250
   query64	6297	3018	3057	3018
   query65	3247	3203	3207	3203
   query66	1350	322	318	318
   query67	14377	14242	14276	14242
   query68	4983	543	560	543
   query69	538	386	373	373
   query70	1213	1217	1203	1203
   query71	366	248	246	246
   query72	6237	2814	2631	2631
   query73	714	327	321	321
   query74	6480	6031	5943	5943
   query75	3050	2455	2422	2422
   query76	2793	1021	1160	1021
   query77	344	224	228	224
   query78	10166	8571	8505	8505
   query79	998	544	520	520
   query80	602	365	355	355
   query81	450	196	194	194
   query82	482	87	83	83
   query83	241	122	125	122
   query84	281	76	74	74
   query85	1144	351	344	344
   query86	300	295	263	263
   query87	3234	3120	3114	3114
   query88	2698	2284	2255	2255
   query89	384	339	326	326
   query90	1984	164	170	164
   query91	152	123	124	123
   query92	55	50	47	47
   query93	1014	527	516	516
   query94	1075	189	187	187
   query95	445	337	344	337
   query96	577	259	261	259
   query97	4241	4138	4184	4138
   query98	216	198	188	188
   query99	1022	666	694	666
   Total cold run time: 262893 ms
   Total hot run time: 169245 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) forbid create table with illegal auto partition expr [doris]

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

   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) forbid create table with illegal auto partition expr [doris]

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

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


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

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

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


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


Re: [PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]

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

   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) forbid create table with illegal auto partition expr [doris]

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


-- 
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) forbid create table with illegal auto partition expr [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37640 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 8425ba6d368d1ff3c35b76519bfa725c436b14ef, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17660	4049	4009	4009
   q2	2035	140	138	138
   q3	10574	936	936	936
   q4	4656	935	927	927
   q5	7610	2815	3015	2815
   q6	179	122	121	121
   q7	1222	750	740	740
   q8	9245	1984	2000	1984
   q9	7167	6277	6249	6249
   q10	8182	2485	2509	2485
   q11	406	216	206	206
   q12	769	309	306	306
   q13	17936	3201	3195	3195
   q14	279	257	267	257
   q15	531	491	492	491
   q16	465	410	400	400
   q17	925	869	890	869
   q18	6721	5911	5976	5911
   q19	1567	1490	1502	1490
   q20	541	279	269	269
   q21	6680	3561	3622	3561
   q22	811	281	287	281
   Total cold run time: 106161 ms
   Total hot run time: 37640 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	3978	3964	3989	3964
   q2	307	213	218	213
   q3	2936	2991	2981	2981
   q4	1886	1902	1891	1891
   q5	5250	5147	5127	5127
   q6	194	116	115	115
   q7	2128	1694	1732	1694
   q8	3099	3177	3176	3176
   q9	8199	8202	8184	8184
   q10	6091	3654	3624	3624
   q11	534	418	426	418
   q12	700	527	527	527
   q13	9408	3055	3049	3049
   q14	280	252	258	252
   q15	530	487	496	487
   q16	496	463	455	455
   q17	1680	1671	1662	1662
   q18	7852	7511	7469	7469
   q19	1667	1625	1607	1607
   q20	2095	1905	1899	1899
   q21	4788	4593	4634	4593
   q22	535	445	446	445
   Total cold run time: 64633 ms
   Total hot run time: 53832 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) forbid create table with illegal auto partition expr [doris]

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

   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)


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