1 of 1

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.

Signature

toBase64(bytesCol)
fromBase64(stringCol)

For better readability, the following examples converts string hello! into BYTES using function and converts the decoded BYTES into string using .

encoded

decoded

Note that without UTF8 string conversion, returned BYTES will be represented as a Hex string following Pinot's . See the example below.

decoded

Note that the following query will throw compilation error as string is not a valid input type for toBase64.

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)

For better readability, the following examples converts string hello! into BYTES using function and converts the decoded BYTES into string using .

encoded

decoded

Note that without UTF8 string conversion, returned BYTES will be represented as a Hex string following Pinot's . See the example below.

decoded

Note that the following query will throw compilation error as string is not a valid input type for toBase64.