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 2025/10/16 09:28:38 UTC

[PR] [Enhancement](grammar) Support omit auto keyword for auto range partition [doris]

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

   ### What problem does this PR solve?
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   
   when use auto range partition, support omit 'auto' keyword:
   
   ```sql
   CREATE TABLE not_auto_expr (
       `TIME_STAMP` date NOT NULL
   )
   partition by range (date_trunc(`TIME_STAMP`, 'day'))()
   DISTRIBUTED BY HASH(`TIME_STAMP`) BUCKETS 10
   PROPERTIES (
       "replication_allocation" = "tag.location.default: 1"
   );
   ```
   --- it's auto range partition
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [x] Regression test
       - [ ] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [x] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [x] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
   
   


-- 
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] [Enhancement](grammar) Support omit auto keyword for auto range partition [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 30.07 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 5fc3000f133ae1e4ed569f8366561dfa2b616fb5, data reload: false
   
   query1	0.05	0.06	0.05
   query2	0.09	0.05	0.05
   query3	0.25	0.08	0.08
   query4	1.60	0.12	0.12
   query5	0.28	0.26	0.26
   query6	1.19	0.64	0.64
   query7	0.03	0.03	0.03
   query8	0.05	0.04	0.04
   query9	0.62	0.52	0.51
   query10	0.60	0.58	0.58
   query11	0.17	0.11	0.11
   query12	0.15	0.12	0.12
   query13	0.64	0.61	0.61
   query14	1.03	1.05	1.01
   query15	0.86	0.85	0.86
   query16	0.43	0.41	0.41
   query17	1.07	1.06	1.06
   query18	0.21	0.20	0.20
   query19	1.96	1.86	1.82
   query20	0.01	0.01	0.02
   query21	15.42	0.95	0.60
   query22	0.75	1.25	0.69
   query23	14.86	1.38	0.68
   query24	7.42	1.23	0.35
   query25	0.30	0.12	0.13
   query26	0.72	0.16	0.13
   query27	0.06	0.06	0.05
   query28	8.69	1.38	0.93
   query29	12.55	3.84	3.27
   query30	0.28	0.13	0.12
   query31	2.82	0.60	0.39
   query32	3.24	0.56	0.49
   query33	3.04	3.04	3.06
   query34	16.10	5.54	4.89
   query35	4.94	4.95	4.87
   query36	0.71	0.51	0.51
   query37	0.10	0.07	0.07
   query38	0.07	0.05	0.04
   query39	0.03	0.03	0.03
   query40	0.18	0.14	0.14
   query41	0.08	0.04	0.04
   query42	0.03	0.03	0.03
   query43	0.04	0.04	0.03
   Total cold run time: 103.72 s
   Total hot run time: 30.07 s
   ```
   </details>
   


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

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

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


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


Re: [PR] [Enhancement](grammar) Support omit auto keyword for auto range partition [doris]

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

   
   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).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and after the optimization?
       


-- 
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] [Enhancement](grammar) Support omit auto keyword for auto range partition [doris]

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

   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] [Enhancement](grammar) Support omit auto keyword for auto range partition [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 190134 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 5fc3000f133ae1e4ed569f8366561dfa2b616fb5, data reload: false
   
   query1	1080	454	415	415
   query2	6574	1666	1681	1666
   query3	6746	230	223	223
   query4	25360	23680	23288	23288
   query5	5116	633	487	487
   query6	361	234	209	209
   query7	4654	498	287	287
   query8	297	255	254	254
   query9	8715	2601	2579	2579
   query10	538	340	279	279
   query11	15706	15446	14745	14745
   query12	186	118	117	117
   query13	1665	556	421	421
   query14	11449	9198	9218	9198
   query15	233	187	189	187
   query16	7673	686	482	482
   query17	1189	777	601	601
   query18	2037	414	327	327
   query19	240	232	198	198
   query20	153	155	136	136
   query21	216	147	121	121
   query22	4441	4694	4526	4526
   query23	34763	33823	34051	33823
   query24	8565	2495	2554	2495
   query25	651	571	505	505
   query26	1268	294	218	218
   query27	2674	517	363	363
   query28	4502	2199	2230	2199
   query29	976	609	509	509
   query30	372	246	209	209
   query31	916	880	776	776
   query32	97	74	72	72
   query33	612	408	398	398
   query34	835	869	563	563
   query35	844	899	802	802
   query36	1015	1064	922	922
   query37	126	111	84	84
   query38	3530	3597	3421	3421
   query39	1484	1421	1417	1417
   query40	216	122	113	113
   query41	62	58	57	57
   query42	120	104	108	104
   query43	480	494	461	461
   query44	1326	852	816	816
   query45	187	182	178	178
   query46	826	1000	633	633
   query47	1757	1822	1740	1740
   query48	397	420	328	328
   query49	777	493	435	435
   query50	635	689	404	404
   query51	3833	3979	3941	3941
   query52	115	110	108	108
   query53	241	271	206	206
   query54	623	578	530	530
   query55	83	81	87	81
   query56	339	326	319	319
   query57	1184	1173	1147	1147
   query58	282	274	277	274
   query59	2611	2605	2694	2605
   query60	351	329	325	325
   query61	161	154	145	145
   query62	813	757	681	681
   query63	232	199	191	191
   query64	4383	1132	899	899
   query65	4005	3971	3965	3965
   query66	1079	429	320	320
   query67	15571	14999	14962	14962
   query68	7368	887	594	594
   query69	487	328	280	280
   query70	1350	1195	1279	1195
   query71	502	335	326	326
   query72	5844	4944	4894	4894
   query73	526	574	354	354
   query74	8876	9207	8958	8958
   query75	3867	3378	2778	2778
   query76	3340	1152	722	722
   query77	779	402	344	344
   query78	9603	9800	9064	9064
   query79	1999	822	594	594
   query80	644	568	496	496
   query81	483	339	234	234
   query82	439	173	140	140
   query83	270	275	256	256
   query84	262	113	96	96
   query85	876	474	429	429
   query86	340	297	303	297
   query87	3711	3755	3559	3559
   query88	3927	2307	2339	2307
   query89	401	332	305	305
   query90	2080	223	245	223
   query91	180	168	135	135
   query92	92	72	67	67
   query93	1710	986	654	654
   query94	702	454	333	333
   query95	405	334	318	318
   query96	488	595	282	282
   query97	2940	2971	2879	2879
   query98	245	219	213	213
   query99	1368	1418	1318	1318
   Total cold run time: 276652 ms
   Total hot run time: 190134 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] [Enhancement](grammar) Support omit auto keyword for auto range partition [doris]

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

   # FE Regression Coverage Report
   Increment line coverage `  100.00% (2/2)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57060_5fc3000f133ae1e4ed569f8366561dfa2b616fb5_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57060_5fc3000f133ae1e4ed569f8366561dfa2b616fb5_merge_fe/report/index.html)
   


-- 
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] [Enhancement](grammar) Support omit auto keyword for auto range partition [doris]

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

   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] [Enhancement](grammar) Support omit auto keyword for auto range partition [doris]

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

   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] [Enhancement](grammar) Support omit auto keyword for auto range partition [doris]

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


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