hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Alten-Lorenz <wget.n...@gmail.com>
Subject Re: Change timestamp format in hive
Date Wed, 13 Feb 2013 09:48:06 GMT
May https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-DateFunctions help
you?

- Alex

On Feb 13, 2013, at 10:43 AM, Chunky Gupta <chunky.gupta@vizury.com> wrote:

> Hi,
> 
> I have a log file which has timestamp in format "YYYY-MM-DD-HH:MM:SS". But since the
timestamp datatype format in hive is "YYYY-MM-DD HH:MM:SS". 
> I created a table with datatype of that column as TIMESTAMP. But when I load the data
it is throwing error. I think it is because of difference in format. 
> 
> Is there any way to set the timestamp format while creating the table. Or is there some
other solution for this issue ?
> 
> Thanks,
> Chunky.

--
Alexander Alten-Lorenz
http://mapredit.blogspot.com
German Hadoop LinkedIn Group: http://goo.gl/N8pCF


Mime
View raw message