[jira] [Commented] (HIVE-6930) Beeline should nicely format timestamps when displaying results

["Peter Vary (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-6930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15358873#comment-15358873 ] 

Peter Vary commented on HIVE-6930:
----------------------------------

[~gwenshap] [~Ferd] I was trying to reproduce the problem, but was unable.
Reading the code I was suspecting, that the beeline numberFormat setting might affect the formatting of the objects, but it was working as designed, and did not affect the formatting of the timestamps. I used the same method, as described by Ferdinand.

If you do not object till Monday, I would close this issue as "Cannot reproduce".

If you find a way to reproduce, feel free to reopen it any time.

Thanks,
Peter

> Beeline should nicely format timestamps when displaying results
> ---------------------------------------------------------------
>
>                 Key: HIVE-6930
>                 URL: https://issues.apache.org/jira/browse/HIVE-6930
>             Project: Hive
>          Issue Type: Improvement
>          Components: CLI
>    Affects Versions: 0.12.0
>            Reporter: Gwen Shapira
>            Assignee: Ferdinand Xu
>
> When I have a timestamp column in my query, I get the results back as the bigint with number of seconds since epoch. Not very user friendly or readable.
> This means that all my queries need to include stuff like:
> select from_unixtime(cast(round(transaction_ts/1000) as bigint))...
> which is not too readable either :)
> Other SQL query tools automatically convert timestamps to some standard readable date format. They even let users specify the default formatting by setting a parameter (for example NLS_DATE_FORMAT for Oracle).
> I'd love to see something like that in beeline.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)