Preface
Introduction to Informatica Big Data Management
Mappings in the Hadoop Environment
Mapping Sources in the Hadoop Environment
Mapping Targets in the Hadoop Environment
Mapping Transformations in the Hadoop Environment
Processing Hierarchical Data on the Spark Engine
Configuring Transformations to Process Hierarchical Data
Processing Unstructured and Semi-structured Data with an Intelligent Structure Model
Stateful Computing on the Spark Engine
Monitoring Mappings in the Hadoop Environment
Mappings in the Native Environment
Profiles
Native Environment Optimization
Cluster Workflows
Connections
Data Type Reference
Function Reference
- Function Support in the Hadoop Environment
- Function and Data Type Processing
  - Rules and Guidelines for Spark Engine Processing
  - Rules and Guidelines for Hive Engine Processing
Parameter Reference
- Parameters Overview
- Parameter Usage

Big Data Management User Guide

Back Next

High Precision Decimal Data Type on the Hive Engine

In high-precision mode, the Hive engine supports decimal data types with precision up to 38 digits and a maximum scale of 38. The scale must be less than the precision.

When you run mappings in high-precision mode, the Hive engine maintains the precision at a maximum of 38 digits. As a result, precision loss can occur due to data overflow or intermediate calculations.

To minimize precision loss, configure the precision and scale to accurately reflect the data.

Mappings in the Hadoop Environment

Precision Loss Due to Data Overflow

Precision Loss Due to Intermediate Calculations

Precision and Scale in Multiplication User-Defined Functions

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal