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

Hive Targets

Hive Targets

Hive targets are valid in mappings in a Hadoop environment with some restrictions.
Hive targets are valid in mappings in a Hadoop environment with the following restrictions:
  • The Data Integration Service does not run pre-mapping or post-mapping SQL commands against the target database for a Hive target. You cannot validate and run a mapping with PreSQL or PostSQL properties for a Hive target.
  • A mapping fails to run if the Hive target definition differs in the number and order of the columns from the relational table in the Hive database.
  • You must choose to truncate the target table to overwrite data to a Hive table with Hive version 0.7. The Data Integration Service ignores write, update override, delete, insert, and update strategy properties when it writes data to a Hive target.
  • A mapping fails to run when you use Unicode characters in a Hive target definition.
  • The Data Integration Service can truncate the partition in the Hive target in which the data is being inserted. You must choose to both truncate the partition in the Hive target and truncate the target table.


Updated July 03, 2018