[ https://issues.apache.org/jira/browse/HIVE-17230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16110888#comment-16110888 ]
Peter Vary commented on HIVE-17230: ----------------------------------- I have found this issue when I was trying to run several more tests with the TestBeeLineDriver to see if there is any further differences between the output of BeeLine, and HiveCLI. [~vihangk1], [~aihuaxu]: What do you think we should do with this difference? - Change the way BeeLine prints out timestamps? - Change the way HiveCLI prints out timestamps? - Document this as a known issue? I personally do not understand/like the HiveCLI version where the Timestamp nanoseconds are not displayed - in my view this column was specifically defined as a Timestamp because we expect it to be an exact time, so I would go for removing the formatting changes from the HiveCLI, but this is a backward incompatible change, and I might not see every aspect of this change. I would greatly value your input here [~aihuaxu], [~vihangk1]. Thanks, Peter > Timestamp format different in HiveCLI and Beeline > ------------------------------------------------- > > Key: HIVE-17230 > URL: https://issues.apache.org/jira/browse/HIVE-17230 > Project: Hive > Issue Type: Bug > Components: Beeline, CLI > Reporter: Peter Vary > Assignee: Peter Vary > > The issue can be reproduced with the following commands: > {code} > create table timestamp_test(t timestamp); > insert into table timestamp_test values('2000-01-01 01:00:00'); > select * from timestamp_test; > {code} > The timestamp is displayed without nanoseconds in HiveCLI: > {code} > 2000-01-01 01:00:00 > {code} > When the exact same timestamp is displayed in BeeLine it displays: > {code} > 2000-01-01 01:00:00.0 > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)