Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> how to transform the date format in hive?


Copy link to this message
-
how to transform the date format in hive?
Hi All,

Assume we have two time stamp like:    9/15/2002  8:05   and    9/15/2002
9:05

if we need to evaluate the difference of these two time stamp in terms of
hours ( or minutes ), how to do that?

Hive seems only support the format  'yyyy-MM-dd HH:mm:ss' , how can we
transform the two time stamps into the format that can be processed by
hive?

thanks for any suggestion in advance.
+
Tom Hubina 2012-11-21, 23:59
+
Ruslan Al-Fakikh 2012-11-22, 11:57
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB