Thanks Mark Ohh, that was long to ip conversion. I thought, ip (dots) has been removed some where.
Love to hear from you. Cheers On Thu, Nov 5, 2015 at 9:05 PM, Mark Sunderlin <mark.sunder...@teamaol.com> wrote: > Actually, I found a UDF that does this very nicely! > > > https://github.com/petrabarus/HiveUDFs/blob/master/src/main/java/net/petrabarus/hiveudfs/LongToIP.java > > Share and enjoy! > > -- > Mark E. Sunderlin > Data Architect // Data Solutions > P: 703-265-6935 // C: 540-327-6222 // 22000 AOL Way, Dulles, VA 20166 > AIM: MESunderlin // Slack: @Mark.Sunderlin > > On Thu, Oct 22, 2015 at 2:55 PM, Vikas Parashar <para.vi...@gmail.com> > wrote: > >> Hi Mark, >> >> You can segregate it at the input level. Could you please explain how >> your data are ingesting in DB. >> >> On Fri, Oct 23, 2015 at 12:14 AM, Mark Sunderlin < >> mark.sunder...@teamaol.com> wrote: >> >>> Does hive have a built in function to return a dotted-quad >>> representation of an IP address given a network address as an integer >>> as input? >>> >>> If not, does anyone have SQL they would be willing to share that does >>> this? >>> >>> What I am looking for: My data is in the below "raw" format, I want it >>> in the "dot" format. >>> >>> raw_formatdot_format166136010699.6.87.234162645867796.241.202.53 >>> >>> -- >>> Mark E. Sunderlin >>> Data Architect // Data Solutions >>> P: 703-265-6935 // C: 540-327-6222 // 22000 AOL Way, Dulles, VA 20166 >>> AIM: MESunderlin // Slack: @Mark.Sunderlin >>> >>> >>> >> >
