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