Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Connections
  4. Mappings in a Hadoop Environment
  5. Mappings in the Native Environment
  6. Profiles
  7. Native Environment Optimization
  8. POWERCENTERHELP
  9. Data Type Reference

Functions in a Hadoop Environment

Functions in a Hadoop Environment

Some transformation language functions that are valid in the native environment are not valid or have limitations in a Hadoop environment.
The following table describes the functions that are not valid or have limitations in a Hadoop environment:
Name
Limitation
ABORT
String argument is not valid.
CUME
Not valid
ERROR
String argument is not valid.
FIRST
Not valid. Use the ANY function to get any row.
LAST
Not valid. Use the ANY function to get any row.
MAX (Dates)
Not valid
MIN (Dates)
Not valid
MOVINGAVG
Not valid
MOVINGSUM
Not valid
UUID4()
Valid as an argument in UUID_UNPARSE or ENC_BASE64.
UUID_UNPARSE(Binary)
Valid if the argument is UUID4().
The Hadoop environment treats "/n" values as null values. If an aggregate function contains empty or NULL values, the Hadoop environment includes these values while performing an aggregate calculation.


Updated July 03, 2018