Table of Contents

Search

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

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 July 25, 2019