What I normally do is use python in a map phase for this sort of stuff ... if a UDF is not available. Any scripting language would do the trick as well.
-Ajo On Thu, Feb 24, 2011 at 6:27 AM, Bejoy Ks <[email protected]> wrote: > Hi Experts > Could some one please help me out with this? Any similar situations > faced by any one in your real time hive queries? > If I have to go ahead with an User Defined Function for this, then how > could I implement and use the same in Hive? > Does Hive have any plans/JIRAs in progress with this functionality > implementation. > > Thank You > > Regards > Bejoy K S > > ------------------------------ > *From:* Bejoy Ks <[email protected]> > *To:* [email protected] > *Sent:* Wed, February 23, 2011 5:19:10 PM > *Subject:* How to add hours/minutes to a timestamp column in Hive Query > > Hi > Is there any function in hive with which we can add hours/minutes to a > given stamp. > Say I have a timestamp oriented column 'Arrival_Time', to do some database > oriented calculations i have to add 4 hours to the 'Arrival_Time' in my Hive > Query. How do I accomplish this? I have see in hive documentation that we > can use the date_add(string startdate, int days) method to add days to a > date. Any similar methods for time stamps to add hours? > > Regards > Bejoy KS > > >
