You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "dataroaring (via GitHub)" <gi...@apache.org> on 2024/03/15 14:01:20 UTC
[I] [Enhancement] when partition column is datetime, date should work in create table command [doris]
dataroaring opened a new issue, #32323:
URL: https://github.com/apache/doris/issues/32323
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Description
CREATE TABLE t_user
(
id int,
name string,
pdate DATETIME
)
PARTITION BY RANGE(`pdate`)(
PARTITION pd20230418 VALUES less than ("2023-04-20")
)
DISTRIBUTED BY HASH(`id`) BUCKETS 1;
ERROR 1105 (HY000): errCode = 2, detailMessage = Invalid range value format: errCode = 2, detailMessage = date literal [2023-04-20] is invalid: errCode = 2, detailMessage = Invalid datetime value: 2023-04-20
### Solution
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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.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: [I] [Enhancement] when partition column is datetime, date should work in create table command [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed issue #32323: [Enhancement] when partition column is datetime, date should work in create table command
URL: https://github.com/apache/doris/issues/32323
--
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: [I] [Enhancement] when partition column is datetime, date should work in create table command [doris]
Posted by "xiedeyantu (via GitHub)" <gi...@apache.org>.
xiedeyantu commented on issue #32323:
URL: https://github.com/apache/doris/issues/32323#issuecomment-1999821129
I want to try 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