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