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
