Network functions

MaxCompute SQL provides network functions to process STRING and BINARY network data. Use these functions to convert IP address formats, parse URLs, and retrieve network masks.

Function	Feature
NET_HOST	Parses the hostname from a STRING URL.
NET_IP_FROM_STRING	Converts an IPv4 or IPv6 address from STRING to BINARY format. Note Returns an error if the input is invalid.
NET_IP_NET_MASK	Generates an IPv4 or IPv6 network mask from a given mask length.
NET_IPV4_TO_INT64	Converts an IPv4 address from BINARY to BIGINT format.
NET_IP_TO_STRING	Converts an IPv4 or IPv6 address from BINARY to STRING format.
NET_PUBLIC_SUFFIX	Parses the public suffix (such as com, org, or net) from a STRING URL.
NET_REG_DOMAIN	Parses the registered domain from a STRING URL. A registered domain consists of the public suffix and the preceding label.
NET_SAFE_IP_FROM_STRING	Converts an IPv4 or IPv6 address from STRING to BINARY format. Note Similar to NET_IP_FROM_STRING, but returns NULL instead of an error for invalid input.
TCPING	Tests connectivity to a specific port on a target domain or IP address.