[IMPALA-6105] unix_timestamp() documentation doesn't mention unit

• Type: Documentation
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.10.0
• Fix Version/s: Impala 2.10.0
• Component/s: Docs
• Epic Color: ghx-label-8
• Assignee: Alexandra Rodoni
• Reporter: Tim Armstrong
• Created: 24/Oct/17 18:28
• Updated: 30/Jan/18 19:17
• Resolved: 30/Jan/18 19:17

Description

When reading through the docs I noticed that unix_timestamp() doesn't explicitly say what unit it returns (I believe it is seconds). I saw this create some confusion for a user: http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Get-timestamp-in-milliseconds-in-Impala/m-p/61214#M3755?eid=1&aid=1

See https://impala.incubator.apache.org/docs/build/html/topics/impala_datetime_functions.html

Purpose: Returns an integer value representing the current date and time as a delta from the Unix epoch, or converts from a specified date and time value represented as a TIMESTAMP or STRING.