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: local policy)
From: <ashok.samal@wipro.com>
To: <user@hive.apache.org>
Subject: RE: Date format in Hive
Thread-Topic: Date format in Hive
Thread-Index: AQHPAHUVrySoGhyEnUunmt7XnUUrxppi7ptG
Date: Tue, 24 Dec 2013 07:17:40 +0000
Message-ID: <765C20A3B9276145875E35CED1AED0473CD9D7E0@BLR-SJP-MBX-6.wipro.com>
References: 
 <CAAc1kg1MZgPwpLVshQwgaUFbPhDNOCG83Q3OXGuNmQicoS8dLw@mail.gmail.com>
In-Reply-To: 
 <CAAc1kg1MZgPwpLVshQwgaUFbPhDNOCG83Q3OXGuNmQicoS8dLw@mail.gmail.com>
Accept-Language: en-US, en-IN
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
content-transfer-encoding: quoted-printable
MIME-Version: 1.0

Hello Dhari,

Write a hive udf, 
1.which ll take date as argument.
2.extract yr, mon,date from string, create a new string combining them
3. convert it to numeric and multiply 100..
4. return this value from udf.

Thanks,
Ashok
________________________________________
From: yogesh dhari [yogeshhive@gmail.com]
Sent: Tuesday, December 24, 2013 12:24 PM
To: user@hive.apache.org
Subject: Date format in Hive

Hello All,

I have a hive table in which dates are stored in string format.

like

2013-01-01
2013-02-01
2013-03-01


I have a use case where I need this date like
20130101
20130201
20130301

and want to multiply each with 100
like

2013010100
2013020100
2013030100


How can I do it into Hive

pls help.

Thanks & Regards
Yogesh

The information contained in this electronic message and any attachments to=
 this message are intended for the exclusive use of the addressee(s) and may=
 contain proprietary, confidential or privileged information. If you are not=
 the intended recipient, you should not disseminate, distribute or copy this=
 e-mail. Please notify the sender immediately and destroy all copies of this=
 message and any attachments. 

WARNING: Computer viruses can be transmitted via email. The recipient should=
 check this email and any attachments for the presence of viruses. The compa=
ny accepts no liability for any damage caused by any virus transmitted by th=
is email.

www.wipro.com