Apache Drill provides the following list of IP network functions that are used to support the network activities such as converting an IP address into the integer, converting integer IP into the dotted decimal notation, and so on.
The below is the list of Apache Drill IP network functions and their descriptions.
| IP Network Function | Output of the Function | Description |
|---|---|---|
| inet_aton() | INT | This function is used to convert the IPv4 address into the integer form. |
| inet_ntoa( ) | VARCHAR | This function is used to convert an integer IP into decimal notation. |
| in_network( , ) | BOOLEAN | The return type of this function is True in case the IP address is present in the CIDR block. |
| address_count( ) | INT | This function returns the count of IPs from a CIDR block. |
| broadcast_address( ) | VARCHAR | The function is used to return the broadcast address of a CIDR block. |
| netmask( ) | VARCHAR | This function is used to return the netmask of a CIDR block. |
| low_address() | VARCHAR | This function is used to return the first address of the CIDR block. |
| high_address() | VARCHAR | This function is used to return the last address of the CIDR block. |
| url_encode( ) | VARCHAR | The return type of this function is a URL encoded string. |
| url_decode( ) | VARCHAR | This function is used to Decodes a URL into the encoded string. |
| is_valid_IP() | BOOLEAN | The function returns the boolean true if the IP address is valid. |
| is_private_ip() | BOOLEAN | The function returns the boolean true in case the IP is a private IPv4 address. |
| is_valid_IPv4() | BOOLEAN | If the IP address is a valid IPv4 address then BOOLEAN true is returned. |
| is_valid_IPv6() | BOOLEAN | If the IP address is a valid IPv6 address then BOOLEAN true is returned. |