[
https://issues.apache.org/jira/browse/IMPALA-1772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17574065#comment-17574065
]
Csaba Ringhofer commented on IMPALA-1772:
-----------------------------------------
[~jianzhang.zj]
Looked into the list of functions.
Some of them are already implemented:
- quarter
- daysbetween (using datediff)
- monthenddate (using lastday)
The others are not implemented, but I also couldn't find these exact functions
in other databases:
- monthstartdate (trunc can be used as workaround)
- yearstartdate (trunc can be used as workaround)
- yearstartdate (date add + trunc can be used as workaround)
>These functions still seem useful
I wrote this a bit too early, I didn't realize that the ones that are exist in
other databases are already implemented.
Will try to ask around whether to remaining ones are actually useful.
> Additional date / time functions
> --------------------------------
>
> Key: IMPALA-1772
> URL: https://issues.apache.org/jira/browse/IMPALA-1772
> Project: IMPALA
> Issue Type: New Feature
> Components: Backend
> Affects Versions: Impala 2.1.1
> Reporter: Henry Robinson
> Assignee: Jian Zhang
> Priority: Minor
> Labels: built-in-function, ramp-up
> Fix For: Impala 2.6.0
>
>
> Some missing BI functions:
> * daysbetween - ideally use arithmetic with '-' like Oracle
> * -quarter done via IMPALA-6537-
> * monthenddate
> * monthstartdate
> * yearenddate
> * yearstartdate
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
