ipv4_to_int64¶
Description¶
Given an IPv4 address string in dotted-quad format, convert the address to an integer representing the address.
Addresses are handled in big-endian (network) byte order.
Return type¶
int64
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
ipv4_to_int64(ipv4)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
ipv4 |
string |
no |
no |
none |
Examples¶
make_col ipint:ipv4_to_int64(ipstr)
Assuming there’s a string input column with IP addresses, outputs the corresponding parsed ip addresses as integers in network byte order.
ipstr (input) |
ipint (output) |
|---|---|
8.8.4.4 |
134743044 |
10.0.0.1 |
167772161 |
10.0.0.1/16 |
null |
127.0.0.1 |
2130706433 |
127.0.0.1/24 |
null |
128.1.2.3 |
2147549699 |
172.30.2.3 |
2887647747 |
192.168.0.3 |
3232235523 |
200.1.2.3 |
3355509251 |
1.2.3.300 |
null |
1.2.3.4.5 |
null |
1.2.3 |
null |
localhost |
null |