Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
http://mapredit.blogspot.com
German Hadoop LinkedIn Group: http://goo.gl/N8pCF
+
Dean Wampler 2013-02-13, 14:43
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB