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

Rules and Guidelines for Hive Sources on the Blaze Engine

Rules and Guidelines for Hive Sources on the Blaze Engine

You can include Hive sources in an Informatica mapping that runs on the Blaze engine.
Consider the following rules and guidelines when you configure a Hive source in a mapping that runs on the Blaze engine:
  • Hive sources for a Blaze mapping include the TEXT, Sequence, Avro, RC, ORC, and Parquet storage formats.
  • A mapping that runs on the Blaze engine can have bucketed Hive sources and Hive ACID tables.
  • Hive ACID tables must be bucketed.
  • The Blaze engine supports Hive tables that are enabled for locking.
  • Hive sources can contain quoted identifiers in Hive table names, column names, and schema names.
  • The TEXT storage format in a Hive source for a Blaze mapping can support ASCII characters as column delimiters and the newline characters as a row separator. You cannot use hex values of ASCII characters. For example, use a semicolon (;) instead of 3B.
  • You can define an SQL override in the Hive source for a Blaze mapping.


Updated November 09, 2018