[HIVE-17230] Timestamp format different in HiveCLI and Beeline

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Component/s: Beeline, CLI
• Assignee: Marta Kuczora Assign to me
• Reporter: Peter Vary
• Created: 02/Aug/17 13:12
• Updated: 17/Oct/17 23:14

Description

The issue can be reproduced with the following commands:

create table timestamp_test(t timestamp);
insert into table timestamp_test values('2000-01-01 01:00:00');
select * from timestamp_test;

The timestamp is displayed without nanoseconds in HiveCLI:

2000-01-01 01:00:00

When the exact same timestamp is displayed in BeeLine it displays:

2000-01-01 01:00:00.0