hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chunky Gupta <chunky.gu...@vizury.com>
Subject Change timestamp format in hive
Date Wed, 13 Feb 2013 09:43:24 GMT
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.

Mime
View raw message