Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Connections
  4. Mappings in the Hadoop Environment
  5. Mapping Objects in the Hadoop Environment
  6. Monitoring Mappings in the Hadoop Environment
  7. Mappings in the Native Environment
  8. Profiles
  9. Native Environment Optimization
  10. Data Type Reference
  11. Function Reference
  12. Parameter Reference
  13. Multiple Blaze Instances on a Cluster

Function Support in a Hadoop Environment

Function Support in a Hadoop Environment

Some Informatica transformation language functions that are valid in the native environment might be supported with restrictions or unsupported in a Hadoop environment.
The following table lists functions and levels of support for functions on different engines in a Hadoop environment:
Function
Blaze Engine
Spark Engine
Hive Engine
ABORT
Not supported
Not supported
Not supported
AES_DECRYPT
Supported
Supported
Supported
AES_ENCRYPT
Supported
Supported
Supported
ANY
Supported
Supported with restrictions
Supported with restrictions
AVG
Supported
Supported with restrictions
Supported with restrictions
COMPRESS
Supported
Supported
Supported
COUNT
Supported
Supported with restrictions
Supported with restrictions
CRC32
Supported
Supported
Supported
CREATE_TIMESTAMP_TZ
Supported
Not supported
Not supported
CUME
Not supported
Not supported
Not supported
DECOMPRESS
Supported
Supported with restrictions
Supported
DEC_BASE64
Supported
Supported
Supported
ENC_BASE64
Supported
Supported
Supported
ERROR
Not supported
Not supported
Not supported
FIRST
Not supported
Not supported
Not supported
GET_TIMEZONE
Supported
Not supported
Not supported
GET_TIMESTAMP
Supported
Not supported
Not supported
LAST
Not supported
Not supported
Not supported
MAX (Dates)
Supported
Supported
Not supported
MAX (Numbers)
Supported
Supported with restrictions
Supported with restrictions
MAX (String)
Supported
Supported with restrictions
Supported with restrictions
MD5
Supported
Supported
Supported
MIN (Dates)
Supported
Supported
Not supported
MIN (Numbers)
Supported
Supported with restrictions
Supported with restrictions
MIN (String)
Supported
Supported with restrictions
Supported with restrictions
MOVINGAVG
Not supported
Not supported
Not supported
MOVINGSUM
Not supported
Not supported
Not supported
PERCENTILE
Supported
Supported with restrictions
Supported with restrictions
STDDEV
Supported
Supported with restrictions
Supported with restrictions
SUM
Supported
Supported with restrictions
Supported with restrictions
SYSTIMESTAMP
Supported
Supported with restrictions
Supported
TO_DECIMAL
Supported
Supported with restrictions
Supported with restrictions
TO_DECIMAL38
Supported
Supported with restrictions
Supported with restrictions
TO_TIMESTAMP_TZ
Supported
Not supported
Supported
UUID4
Supported
Supported
Supported with restrictions
UUID_UNPARSE
Supported
Supported
Supported with restrictions
VARIANCE
Supported
Supported with restrictions
Supported with restrictions
Functions not listed in this table are supported on all engines without restrictions.


Updated July 03, 2018