MaxCompute:NET_HOST

Compare NET_HOST, NET_PUBLIC_SUFFIX, and NET_REG_DOMAIN

The following example runs NET_HOST, NET_PUBLIC_SUFFIX, and NET_REG_DOMAIN side by side across a range of URL formats, including standard URLs, IPv6 addresses, internationalized domain names, and unsupported URI schemes.

SELECT input
,description
,NET_HOST(input) AS HOST
,NET_PUBLIC_SUFFIX(input) AS SUFFIX
,NET_REG_DOMAIN(input) AS DOMAIN
FROM (
  SELECT "" AS input, "invalid input" AS description
  UNION ALL SELECT "http://abc.xyz", "standard URL"
  UNION ALL SELECT "//user:password@a.b:80/path?query",
                   "standard URL with relative scheme, port, path and query, but no public suffix"
  UNION ALL SELECT "https://[::1]:80", "standard URL with IPv6 host"
  UNION ALL SELECT "http://example.web.china", "standard URL with internationalized domain name"
  UNION ALL SELECT "    www.Example.Co.UK    ",
                   "non-standard URL with spaces, upper case letters, and without scheme"
  UNION ALL SELECT "mailto:?to=&subject=&body=", "URI rather than URL--unsupported"
);

Output:

+-----------------------------------+-------------------------------------------------------------------------------+-------------------+------------+---------------+
| input                             | description                                                                   | host              | suffix     | domain        |
+-----------------------------------+-------------------------------------------------------------------------------+-------------------+------------+---------------+
|                                   | invalid input                                                                 | NULL              | NULL       | NULL          |
| http://abc.xyz                    | standard URL                                                                  | abc.xyz           | xyz        | abc.xyz       |
| //user:password@a.b:80/path?query | standard URL with relative scheme, port, path and query, but no public suffix | a.b               | NULL       | NULL          |
| https://[::1]:80                  | standard URL with IPv6 host                                                   | [::1]             | NULL       | NULL          |
| http://example.web.china          | standard URL with internationalized domain name                               | example.web.china | china      | web.china     |
|         www.Example.Co.UK         | non-standard URL with spaces, upper case letters, and without scheme          | www.Example.Co.UK | Co.UK      | Example.Co.UK |
| mailto:?to=&subject=&body=        | URI rather than URL--unsupported                                              | mailto            | NULL       | NULL          |
+-----------------------------------+-------------------------------------------------------------------------------+-------------------+------------+---------------+

Filter rows by hostname

Use NET_HOST in a WHERE clause to keep only rows matching a specific host:

SELECT *
FROM your_table
WHERE NET_HOST(url_column) = 'abc.xyz';