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

Switch to Plain View
Hive >> mail # user >> Change timestamp format in hive

Chunky Gupta 2013-02-13, 09:43
Copy link to this message
Re: Change timestamp format in hive
May https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-DateFunctions help you?

- Alex

On Feb 13, 2013, at 10:43 AM, Chunky Gupta <[EMAIL PROTECTED]> 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
German Hadoop LinkedIn Group: http://goo.gl/N8pCF
Dean Wampler 2013-02-13, 14:43