You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Alex Rodoni (JIRA)" <ji...@apache.org> on 2019/08/03 02:38:00 UTC
[jira] [Comment Edited] (IMPALA-7369) Implement DATE builtin
functions
[ https://issues.apache.org/jira/browse/IMPALA-7369?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16899330#comment-16899330 ]
Alex Rodoni edited comment on IMPALA-7369 at 8/3/19 2:37 AM:
-------------------------------------------------------------
[~attilaj] I am not able to execute the following functions on nightly7 build - neither with TIMESTAMP or DATE. And they are not documented currently even for TIMESTAMP.
DATE ADD_YEARS(DATE d, INT/BIGINT num_years),
DATE SUB_YEARS(DATE d, INT/BIGINT num_years)
DATE SUB_MONTH(...)
DATE ADD_DAYS(DATE d, INT/BIGINT num_days),
DATE SUB_DAYS(DATE d, INT/BIGINT num_days)
DATE ADD_WEEKS(DATE d, INT/BIGINT num_weeks),
DATE SUB_WEEKS(DATE d, INT/BIGINT num_weeks)
was (Author: arodoni_cloudera):
[~attilaj] I am not able to execute the following functions on nightly7 build - neither with TIMESTAMP or DATE. And they are not documented currently even for TIMESTAMP.
DATE ADD_YEARS(DATE d, INT/BIGINT num_years),
DATE SUB_YEARS(DATE d, INT/BIGINT num_years)
DATE ADD_DAYS(DATE d, INT/BIGINT num_days),
DATE SUB_DAYS(DATE d, INT/BIGINT num_days)
DATE ADD_WEEKS(DATE d, INT/BIGINT num_weeks),
DATE SUB_WEEKS(DATE d, INT/BIGINT num_weeks)
> 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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org