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

Reply via email to