Apache Pinot Docs
latest
Search…
⌃K

Url

This section contains reference documentation for the url functions.
Returns the url-encoded or url-decoded string of the input string with UTF_8 encoding, formatting details see java.net.URLEncoder

Signature

encodeUrl(string)
decodeUrl(string)

Usage Examples

SELECT concat('https://www.google.com/search?q=', encodeUrl('key1=val1 key2=45% key3=#47'),'') AS encoded
FROM ignoreMe
encoded
https://www.google.com/search?q=key1%3Dval1+key2%3D45%25+key3%3D%2347
SELECT decodeUrl('https://www.google.com/search?q=key1%3Dval1+key2%3D45%25+key3%3D%2347') AS decoded
FROM ignoreMe
decoded
https://www.google.com/search?q=key1=val1 key2=45% key3=#47
Last modified 8mo ago