Base64
This section contains reference documentation for base64 encode and decode functions.
Encoding scheme follows java.util.Base64.Encoder
toBase64
returns Base64 encoded string of input binary data (bytes
type).fromBase64
returns binary data (represented as a Hex string) from Base64-encoded string.
Signature
toBase64(bytesCol)
fromBase64(stringCol)
Usage Examples
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.
Note that the following query will throw compilation error as string is not a valid input type for toBase64
.
Last updated