Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of wget.null@gmail.com designates
 209.85.215.176 as permitted sender)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 6.2 \(1499\))
Subject: Re: Change timestamp format in hive
From: Alexander Alten-Lorenz <wget.null@gmail.com>
In-Reply-To: 
 <CAN9TFXQVR9FCOAKLax9fUNw7w0ncFCBAns9X5Ev0bmxW1hvcFw@mail.gmail.com>
Date: Wed, 13 Feb 2013 10:48:06 +0100
Content-Transfer-Encoding: quoted-printable
Message-Id: <D9ED3A73-03B2-4017-9133-71A17C52AAE6@gmail.com>
References: 
 <CAN9TFXQVR9FCOAKLax9fUNw7w0ncFCBAns9X5Ev0bmxW1hvcFw@mail.gmail.com>
To: user@hive.apache.org

May =
https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-Da=
teFunctions help you?

- Alex

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

> Hi,
>=20
> 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".=20
> 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.=20
>=20
> Is there any way to set the timestamp format while creating the table. =
Or is there some other solution for this issue ?
>=20
> Thanks,
> Chunky.

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