ipv4_network_int64¶
Description¶
Converts IPv4 network addresses to integer representation.
Given an IPv4 network address string in dotted-quad format, convert the address to an integer representing the address in big-endian (network) byte order, masked either to the slash-masksize mask, or to the natural class A, B, C, or private network format.
CIDR formatting (in which the dotted-quad address is followed by a slash and a netmask size component) is supported.
Using this function you can decode CIDR network addresses, as well as classic “class” and “private” subnet addresses.
Masks formats, and derived masks, are:
Value |
Mask |
Explanation |
|---|---|---|
8.8.4.4 |
255.0.0.0 |
Class A |
10.0.0.0 |
255.0.0.0 |
Private 10.x.y.z |
10.0.0.0/16 |
255.255.0.0 |
Mask /16 |
127.0.0.1 |
255.0.0.0 |
Class A |
127.0.0.1/24 |
255.255.255.0 |
Mask /24 |
128.1.2.3 |
255.255.0.0 |
Class B |
172.30.2.3 |
255.240.0.0 |
Private 172.{16-31}.x.y |
192.168.0.3 |
255.255.0.0 |
Private 192.168.x.y |
200.1.2.3 |
255.255.255.0 |
Class C |
Return type¶
int64
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
ipv4_network_int64(ipv4)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
ipv4 |
string |
no |
no |
none |
Examples¶
make_col ipint:ipv4_network_int64(ipstr)
Assuming there’s a string input column with IP addresses, outputs the corresponding network addresses as integers in network byte order.
ipstr (input) |
ipint (output) |
|---|---|
8.8.4.4 |
134217728 |
10.0.0.1 |
167772160 |
10.0.0.1/16 |
167772160 |
127.0.0.1 |
2130706432 |
127.0.0.1/24 |
2130706432 |
128.1.2.3 |
2147549184 |
172.30.2.3 |
2887647232 |
192.168.0.3 |
3232235520 |
200.1.2.3 |
3355509248 |
1.2.3.300 |
null |
1.2.3.4.5 |
null |
1.2.3 |
null |
localhost |
null |