Data Engineering Integration
- Data Engineering Integration 10.2.2 Service Pack 1
- All Products
Hive Data Type
| Transformation Data Type
| Range and Description
|
---|---|---|
Binary
| Binary
| 1 to 104,857,600 bytes. You can read and write data of Binary data type in a Hadoop environment. You can use the user-defined functions to transform the binary data type.
|
Tiny Int
| Integer
| -32,768 to 32,767
|
Integer
| Integer
| -2,147,483,648 to 2,147,483,647 Precision 10, scale 0
|
Bigint
| Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0
|
Decimal
| Decimal
| For transformations that support precision up to 38 digits, the precision is 1 to 38 digits, and the scale is 0 to 38.
For transformations that support precision up to 28 digits, the precision is 1 to 28 digits, and the scale is 0 to 28.
If a mapping is not enabled for high precision, the Data Integration Service converts all decimal values to double values.
If a mapping is enabled for high precision, the Data Integration Service converts decimal values with precision greater than 38 digits to double values.
|
Double
| Double
| Precision 15
|
Float
| Double
| Precision 15
|
String
| String
| 1 to 104,857,600 characters
|
Boolean
| Integer
| 1 or 0
The default transformation type for boolean is integer. You can also set this to string data type with values of True and False.
|
Array
| String
| 1 to 104,857,600 characters
|
Struct
| String
| 1 to 104,857,600 characters
|
Map
| String
| 1 to 104,857,600 characters
|
Timestamp
| datetime
| The time stamp format is YYYY-MM-DD HH:MM:SS.fffffffff. Precision 29, scale 9.
|
Date
| datetime
| 0000-0101 to 999912-31. Hive date format is YYYY-MM-DD. Precision 10, scale 0.
|
Char
| String
| 1 to 255 characters
|
Varchar
| String
| 1 to 65355 characters
|