hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ferdinand Xu (JIRA)" <j...@apache.org>
Subject [jira] [Work started] (HIVE-6930) Beeline should nicely format timestamps when displaying results
Date Mon, 25 Aug 2014 02:56:59 GMT

     [ https://issues.apache.org/jira/browse/HIVE-6930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Work on HIVE-6930 started by Ferdinand Xu.

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

Mime
View raw message