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.gu...@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