PARSE_URL
Description
The PARSE_URL function is mainly used to parse URL strings and extract various components from them, such as protocols, hosts, paths, query parameters, etc.
Syntax
PARSE_URL( <url>, <name> )
Parameters
| Parameter | Description |
|---|---|
<url> | URL that need to be parsed |
<name> | The parts to be extracted, and the optional values include PROTOCOL, HOST, PATH, REF, AUTHORITY, FILE, USERINFO, PORT, QUERY (case insensitive). |
Return Value
Returns a specified part of <url>. Special cases:
- If any Parameter is NULL, NULL will be returned.
- If
<name>is passed with other illegal values, an error will be occurred.
Examples
SELECT parse_url ('https://doris.apache.org/', 'HOST');
+------------------------------------------------+
| parse_url('https://doris.apache.org/', 'HOST') |
+------------------------------------------------+
| doris.apache.org |
+------------------------------------------------+
SELECT parse_url ('https://doris.apache.org/', null);
+----------------------------------------------+
| parse_url('https://doris.apache.org/', NULL) |
+----------------------------------------------+
| NULL |
+----------------------------------------------+
相关命令
如果想获取 QUERY 中的特定Parameter，可使用extract_url_parameter。
