Gwen Shapira created HIVE-6930:
----------------------------------
Summary: 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
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)
