[
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)
