hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vikas Parashar <para.vi...@gmail.com>
Subject Re: Hive function to convert numeric IP address to "dot" format?
Date Thu, 05 Nov 2015 15:51:08 GMT
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.sunderlin@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.vikas@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.sunderlin@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
>>>
>>>
>>>
>>
>

Mime
View raw message