Concatenation operator

The || operator performs binary concatenation.

Binary functions

Function Syntax Description
length length(binary) → bigint Returns the length of a binary block in bytes.
concat concat(binary1, ..., binaryN) → varbinary Returns the concatenation of binary1, binary2, …, binaryN.
to_base64 to_base64(binary) → varchar Encodes binary data into a Base64 string representation.
from_base64 from_base64(string) → varbinary Base64 decoding
to_base64url to_base64url(binary) → varchar Encodes binary into a Base64 string representation by using the URL safe alphabet.
from_base64url from_base64url(string) → varbinary Decodes binary data from a Base64-encoded string by using the URL safe alphabet.
to_hex to_hex(binary) → varchar Encodes binary data into a hex string representation.
from_hex from_hex(string) → varbinary Decodes binary data from a hex encoded string.
to_big_endian_64 to_big_endian_64(bigint) → varbinary Encodes bigint values into a 64-bit two's complement big endian format.
from_big_endian_64 from_big_endian_64(binary) → bigint Decodes bigint values from a 64-bit two's complement big endian binary.
to_ieee754_32 to_ieee754_32(real) → varbinary Encodes real in a 32-bit big endian binary in the IEEE 754 single-precision floating-point format.
to_ieee754_64 to_ieee754_64(double) → varbinary Encodes double in a 64-bit big endian binary in the IEEE 754 double-precision floating-point format.
crc32 crc32(binary) → bigint Computes the CRC-32 of binary.
md5 md5(binary) → varbinary Computes the MD5 hash of binary.
sha1 sha1(binary) → varbinary Computes the SHA-1 hash of binary.
sha256 sha256(binary) → varbinary Computes the SHA-256 hash of binary.
sha512 sha512(binary) → varbinary Computes the SHA-512 hash of binary.
xxhash64 xxhash64(binary) → varbinary Computes the xxHash 64 hash of binary.