hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amit Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-19370) Issue: ADD Months function on timestamp datatype fields in hive
Date Mon, 14 May 2018 06:40:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-19370?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16473811#comment-16473811
] 

Amit Chauhan commented on HIVE-19370:
-------------------------------------

[~bharos92] I think this should be fine,

IMO if string   [correct]value is provided user should cast it as timestamp and the Default
TS format and provide as input for adding months.

for TS format you can document that udf expects in default TS format and that should be sufficient.

 

Thanks for taking this up.

 

> Issue: ADD Months function on timestamp datatype fields in hive
> ---------------------------------------------------------------
>
>                 Key: HIVE-19370
>                 URL: https://issues.apache.org/jira/browse/HIVE-19370
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Amit Chauhan
>            Assignee: Bharathkrishna Guruvayoor Murali
>            Priority: Major
>         Attachments: HIVE-19370.01.patch
>
>
> *Issue:*
> while using ADD_Months function on a timestamp datatype column the output omits the time
part[HH:MM:SS] part from output.
> which should not be the case.
> *query:* EMAIL_FAILURE_DTMZ is of datatype timestamp in hive.
> hive> select CUSTOMER_ID,EMAIL_FAILURE_DTMZ,ADD_MONTHS (EMAIL_FAILURE_DTMZ , 1) from TABLE1
where CUSTOMER_ID=125674937;
> OK
> 125674937   2015-12-09 12:25:53     2016-01-09
> *hiver version :*
> hive> !hive --version;
>  Hive 1.2.1000.2.5.6.0-40
>  
> can you please help if somehow I can get below as output:
>  
> 125674937   2015-12-09 12:25:53           2016-01-09 12:25:53



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message