hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Sunderlin <>
Subject Hive function to convert numeric IP address to "dot" format?
Date Thu, 22 Oct 2015 18:44:53 GMT
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.


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

View raw message