Presto 0.189 Documentation

6.10. Binary Functions and Operators

6.10. Binary Functions and Operators

Binary Operators

The || operator performs concatenation.

Binary Functions

length(binary) → bigint

Returns the length of binary in bytes.

concat(binary1, ..., binaryN) → varbinary

Returns the concatenation of binary1, binary2, ..., binaryN. This function provides the same functionality as the SQL-standard concatenation operator (||).

to_base64(binary) → varchar

Encodes binary into a base64 string representation.

from_base64(string) → varbinary

Decodes binary data from the base64 encoded string.

to_base64url(binary) → varchar

Encodes binary into a base64 string representation using the URL safe alphabet.

from_base64url(string) → varbinary

Decodes binary data from the base64 encoded string using the URL safe alphabet.

to_hex(binary) → varchar

Encodes binary into a hex string representation.

from_hex(string) → varbinary

Decodes binary data from the hex encoded string.

to_big_endian_64(bigint) → varbinary

Encodes bigint in a 64-bit 2’s complement big endian format.

from_big_endian_64(binary) → bigint

Decodes bigint value from a 64-bit 2’s complement big endian binary.

to_ieee754_32(real) → varbinary

Encodes real in a 32-bit big-endian binary according to IEEE 754 single-precision floating-point format.

to_ieee754_64(double) → varbinary

Encodes double in a 64-bit big-endian binary according to IEEE 754 double-precision floating-point format.

crc32(binary) → bigint

Computes the CRC-32 of binary. For general purpose hashing, use xxhash64(), as it is much faster and produces a better quality hash.

md5(binary) → varbinary

Computes the md5 hash of binary.

sha1(binary) → varbinary

Computes the sha1 hash of binary.

sha256(binary) → varbinary

Computes the sha256 hash of binary.

sha512(binary) → varbinary

Computes the sha512 hash of binary.

xxhash64(binary) → varbinary

Computes the xxhash64 hash of binary.