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 >> >> >> >