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