You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "WinkerDu (via GitHub)" <gi...@apache.org> on 2023/02/21 03:07:30 UTC

[GitHub] [doris] WinkerDu opened a new issue, #16967: [Enhancement] Support function `microseconds_add` for datetimev2

WinkerDu opened a new issue, #16967:
URL: https://github.com/apache/doris/issues/16967

   ### 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
   
   As descriptions in #16561 
   Now Doris already supports DATETIMEV2 which could have precision up to microseconds. But function microseconds_add is not supported yet
   
   `CREATE TABLE datetime_table (date datetime(3) NOT NULL COMMENT '数据灌入日期时间' ) distributed by hash(date) buckets 1 properties("replication_num"="1");`
   
   <img width="1499" alt="image" src="https://user-images.githubusercontent.com/11454734/220237107-c5a279ff-88b8-48c9-bd61-1308a04a3f61.png">
   
   
   ### Solution
   
   1. Introduce new TimeUnit `MICROSECONDS` to `vdatetime_value`
   2. `date_add_interval` computation should handle `MICROSECONDS` unit
   
   ### Are you willing to submit PR?
   
   - [X] 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

[GitHub] [doris] BiteTheDDDDt closed issue #16967: [Enhancement] Support function `microseconds_add` for datetimev2

Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt closed issue #16967: [Enhancement] Support function `microseconds_add` for datetimev2
URL: https://github.com/apache/doris/issues/16967


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