[
https://issues.apache.org/jira/browse/HIVE-6930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14102326#comment-14102326
]
Lars Francke commented on HIVE-6930:
------------------------------------
If this is implemented then it should be an optional thing, disabled by
default. Otherwise you'd run into issues with timezones etc.
> 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.2#6252)
