Base64
This section contains reference documentation for base64 encode and decode functions.
toBase64
returns Base64 encoded string of input binary data (bytes
type).fromBase64
returns binary data (represented as a Hex string) from Base64-encoded string.
toBase64(bytesCol)fromBase64(stringCol)
SELECT toBase64(toUtf8('hello!')) AS encoded
FROM ignoreMe
encoded |
---|
aGVsbG8h |
SELECT fromUtf8(fromBase64('aGVsbG8h')) AS decoded
FROM ignoreMe
decoded |
---|
hello! |
Note that without UTF8 string conversion, returned BYTES will be represented as a Hex string following Pinot's BYTES column representation. See the example below.
SELECT fromBase64('aGVsbG8h') AS decoded
FROM ignoreMe
decoded |
---|
68656c6c6f21 |
Note that the following query will throw compilation error as string is not a valid input type for
toBase64
.SELECT toBase64('hello!') AS encoded
FROM ignoreMe
Last modified 8mo ago