[
https://issues.apache.org/jira/browse/IMPALA-7369?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16900238#comment-16900238
]
Attila Jeges commented on IMPALA-7369:
--------------------------------------
[~arodoni_cloudera] The commit message was incorrect. I'm sorry about the
confusion.
The correct function names are:
DATE YEARS_ADD(DATE d, INT/BIGINT num_years)
DATE YEARS_SUB(DATE d, INT/BIGINT num_years)
DATE MONTHS_ADD(DATE d, INT/BIGINT num_months), alternative name: ADD_MONTHS(..)
DATE MONTHS_SUB(DATE d, INT/BIGINT num months)
DATE DAYS_ADD(DATE d, INT/BIGINT num_days), alternative names: DATE_ADD(..),
ADDDATE(..)
DATE DAYS_SUB(DATE d, INT/BIGINT num_days), alternative names: DATE_SUB(..),
SUBDATE(..)
DATE WEEKS_ADD(DATE d, INT/BIGINT num_weeks)
DATE WEEKS_SUB(DATE d, INT/BIGINT num_weeks)
These functions should work for TIMESTAMPs as well.
> Implement DATE builtin functions
> --------------------------------
>
> Key: IMPALA-7369
> URL: https://issues.apache.org/jira/browse/IMPALA-7369
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Attila Jeges
> Assignee: Attila Jeges
> Priority: Major
> Fix For: Impala 3.3.0
>
>
> - Built-in functions supported in Hive should be implemented in Impala es
> well.
> - Already implemented TIMESTAMP built-in functions that work on the date part
> of timestamps should be implemented for DATE types too.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
