Function | Description | Changes |
|---|---|---|
AES_DECRYPT | Returns decrypted data to string format. | Supported on the Spark engine. Previously supported only on the Blaze and Hive engines. |
AES_ENCRYPT | Returns data in encrypted format. | Supported on the Spark engine. Previously supported only on the Blaze and Hive engines. |
COMPRESS | Compresses data using the zlib 1.2.1 compression algorithm. | Supported on the Spark engine. Previously supported only on the Blaze and Hive engines. |
CRC32 | Returns a 32-bit Cyclic Redundancy Check (CRC32) value. | Supported on the Spark engine. Previously supported only on the Blaze and Hive engines. |
DECOMPRESS | Decompresses data using the zlib 1.2.1 compression algorithm. | Supported with restrictions on the Spark engine. Previously supported only on the Blaze and Hive engines. |
DEC_BASE64 | Decodes a base 64 encoded value and returns a string with the binary data representation of the data. | Supported on the Spark engine. Previously supported only on the Blaze and Hive engines. |
ENC_BASE64 | Encodes data by converting binary data to string data using Multipurpose Internet Mail Extensions (MIME) encoding. | Supported on the Spark engine. Previously supported only on the Blaze and Hive engines. |
MD5 | Calculates the checksum of the input value. The function uses Message-Digest algorithm 5 (MD5). | Supported on the Spark engine. Previously supported only on the Blaze and Hive engines. |
UUID4 | Returns a randomly generated 16-byte binary value that complies with variant 4 of the UUID specification described in RFC 4122. | Supported on the Spark engine without restrictions. Previously supported on the Blaze engine without restrictions and on the Spark and Hive engines with restrictions. |
UUID_UNPARSE | Converts a 16-byte binary value to a 36-character string representation as specified in RFC 4122. | Supported on the Spark engine without restrictions. Previously supported on the Blaze engine without restrictions and on the Spark and Hive engines with restrictions. |