int64_to_ipv4#

Description#

Converts integer-encoded IPv4 addresses to dotted-quad notation.

Given an integer that represents an IPv4 address in big-endian (network) byte order, return the corresponding dotted-quad representation as a string. Returns null if the input number is negative or too large.

Return type#

string

Domain#

This is a scalar function (calculates a single output value for a single input row.)

Categories#

Usage#

int64_to_ipv4(int)

Argument

Type

Optional

Repeatable

Restrictions

int

int64

no

no

none

Examples#

make_col ipint:int64_to_ipv4(ipint)

Assuming there’s an integer input representing an IPv4 address in big-endian (network) byte order, return dotted-quad string version of that address.

ipint (input)

ipstr (output)

-1

null

0

0.0.0.0

134743044

8.8.4.4

167772161

10.0.0.1

2130706433

127.0.0.1

2147549699

128.1.2.3

2887647747

172.30.2.3

3232235523

192.168.0.3

3355509251

200.1.2.3

4294967295

255.255.255.255

4294967296

null