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 Threaded View
Hive >> mail # user >> Dates in Hive


Copy link to this message
-
Re: Dates in Hive
I don't have the language manual in frot of me, but I would suggest casting dateint to string, then using the unix_timestamp function. From_unixtime should get it back into a date time string

Matt

On Jun 25, 2012, at 8:05 PM, sonia gehlot <[EMAIL PROTECTED]> wrote:

> Hi All,
>
> A simple question on dates, how can I convert integer column dateint in "yyyymmdd" format to string column in "yyyy-mm-dd" format in hive.
>
> Thanks in advance.
>
> Sonia
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