URL_DECODE

Unescapes the given URL encoded value.

This function is the inverse of URL_ENCODE.

url_decode(value) → varchar

Unescapes the URL encoded value. This function is the inverse of url_encode().

Syntax

URL_DECODE(VALUE)

Arguments

VALUE

Type: string

A URL encoded value.

Returns

Type: string

The decoded VALUE.

---

Examples

"SELECT url_decode('The+quick+brown+fox') = 'The quick brown fox' AND url_decode('Comment+%235') = 'Comment #5' AND url_decode('%26%24%23_line_%21123') = '&$#line!123' AND url_decode('') = '' AND url_decode('word%2Bword++word') = 'word+word word'"

VALUE	Output
The+quick+brown+fox	The quick brown fox
Comment+%235	Comment #5
%26%24%23_line_%21123	&$#_line_!123
''	''
word%2Bword++word	word+word word

Transformation job example

SQL

CREATE JOB function_operator_example
    ADD_MISSING_COLUMNS = true	
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data 
  MAP_COLUMNS_BY_NAME
    SELECT 
        URL_DECODE('The+quick+brown+fox') AS url_example1,
        URL_DECODE('Comment+%235') AS url_example2
    FROM default_glue_catalog.upsolver_samples.orders_raw_data 
    WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
    LIMIT 1;

Query result

url_example1	url_example2
The quick brown fox	Comment #5