Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - Dates in Hive


+
sonia gehlot 2012-06-26, 00:05
Copy link to this message
-
Re: Dates in Hive
Matt Tucker 2012-06-26, 00:10
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
+
alo alt 2012-06-26, 05:35
+
VanHuy Pham 2012-06-26, 06:18
+
sonia gehlot 2012-06-26, 18:06