Table of Contents

Search

  1. Version 10.2.2
  2. Version 10.2.1
  3. Version 10.2
  4. Version 10.1.1
  5. Version 10.1

Release Guide

Release Guide

Functions Supported in the Hadoop Environment

Functions Supported in the Hadoop Environment

Effective in 10.1.1, the following support changes affect functions in the Hadoop environment:
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.


Updated December 18, 2019