Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Built-in Functions/ String Functions/ parse_url
Updated on 2023-12-21 GMT+08:00
View PDF

parse_url

This character is used to return the specified part of a given URL. Valid values of partToExtract include HOST, PATH, QUERY, REF, PROTOCOL, AUTHORITY, FILE, and USERINFO.

For example, parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'HOST') returns 'facebook.com'.

When the second parameter is set to QUERY, the third parameter can be used to extract the value of a specific parameter. For example, parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'QUERY', 'k1') returns 'v1'.

Syntax

parse_url(string urlString, string partToExtract [, string keyToExtract])

Parameters

Table 1 Parameters

Parameter

Mandatory

Type

Description

urlString

Yes

STRING

URL. If the URL is invalid, an error is reported.

partToExtract

Yes

STRING

The value is case-insensitive and can be HOST, PATH, QUERY, REF, PROTOCOL, AUTHORITY, FILE, or USERINFO.

keyToExtract

No

STRING

If the value of partToExtract is QUERY, the value is obtained based on the key.

Return Values

The return value is of the STRING type. The return rules are as follows:

  • If the value of urlString, partToExtract, or keyToExtract is NULL, NULL is returned.
  • If the value of partToExtract does not meet requirements, an error is reported.

Example Code

The value example.com is returned.

select parse_url('file://username@example.com:666/over/there/index.dtb?type=animal&name=narwhal#nose', 'HOST');

The value /over/there/index.dtb is returned.

select parse_url('file://username@example.com:666/over/there/index.dtb?type=animal&name=narwhal#nose', 'PATH');

The value animal is returned.

select parse_url('file://username@example.com:666/over/there/index.dtb?type=animal&name=narwhal#nose', 'QUERY', 'type');

The value nose is returned.

select parse_url('file://username@example.com:666/over/there/index.dtb?type=animal&name=narwhal#nose', 'REF');

The value file is returned.

select parse_url('file://username@example.com:666/over/there/index.dtb?type=animal&name=narwhal#nose', 'PROTOCOL');

The value username@example.com:8042 is returned.

select parse_url('file://username@example.com:666/over/there/index.dtb?type=animal&name=narwhal#nose', 'AUTHORITY');

The value username is returned.

select parse_url('file://username@example.com:666/over/there/index.dtb?type=animal&name=narwhal#nose', 'USERINFO');
Parent topic: String Functions