MaxCompute SQL network functions - IP, URL, and mask operations - MaxCompute

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.