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

Reply via email to