[HIVE-19370] Issue: ADD Months function on timestamp datatype fields in hive

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.1.0, 4.0.0-alpha-1
• Assignee: Bharath Krishna
• Reporter: Amit Chauhan
• Created: 01/May/18 05:37
• Updated: 21/Oct/22 06:59
• Resolved: 01/Jun/18 10:56

Description

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

Issue Links

• links to: Review Board