Re: Date format in Hive

2013-12-24 Thread Sreenath
you can use python rather than java. its simpler to learn and easier to write On Tue, Dec 24, 2013 at 2:08 PM, yogesh dhari wrote: > Java nahi aati, to udf kaha se likhu.. > > koi hive ka function hi bata ya work around it.. > > ya fir shell script me kaisey kerney ka h ... > > > On Tue, Dec 24

Re: Date format in Hive

2013-12-24 Thread yogesh dhari
Java nahi aati, to udf kaha se likhu.. koi hive ka function hi bata ya work around it.. ya fir shell script me kaisey kerney ka h ... On Tue, Dec 24, 2013 at 12:47 PM, wrote: > Hello Dhari, > > Write a hive udf, > 1.which ll take date as argument. > 2.extract yr, mon,date from string, create

RE: Date format in Hive

2013-12-23 Thread ashok.samal
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 [yogeshh...@

Re: Date format in Hive

2013-12-23 Thread Nitin Pawar
easiest way would be something like this cast ((regexp_replace(column, '-', '') as int)*100 then you can do datetime conversion and end up doing same magic other way On Tue, Dec 24, 2013 at 12:24 PM, yogesh dhari wrote: > Hello All, > > I have a hive table in which dates are stored in string