Hive’s unix_timestamp and from_unixtime functions

From the language manual:

Convert time string with given pattern to Unix time stamp (in seconds) The result of this function is in seconds.

Your result changes with the milliseconds portion of the date, but the unix functions only support seconds. For example:

SELECT unix_timestamp('10-Jun-15 10.00.00 AM', 'dd-MMM-yy hh.mm.ss a');

1433930400

SELECT from_unixtime(1433930400, 'dd-MMM-yy hh.mm.ss a');

10-Jun-15 10.00.00 AM

Related Posts:

  1. How to Update/Drop a Hive Partition?
  2. Hive Map-Join configuration mystery
  3. Hive dynamic partitioning
  4. Difference between `load data inpath ` and `location` in hive?
  5. Why is Fetch task in Hive works faster than Map-only task?
  6. Difference between INNER JOIN and LEFT SEMI JOIN
  7. Hive: how to show all partitions of a table?
  8. fs.hdfs.impl.disable.cache caused SparkSQL very slow
  9. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
  10. Difference between hive.tez.container.size and tez.task.resource.memory.mb
  11. how to write subquery and use “In” Clause in Hive

Leave a Comment

tech