PowerExchange for HBase User Guide

PowerExchange for HBase User Guide

HBase and Transformation Data Types

HBase and Transformation Data Types

The following table lists the HBase data types that the Data Integration Service supports and the corresponding transformation data types:
HBase 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.
String
String
1 to 104,857,600 characters
Short
Integer
-2,147,483,648 to 2,147,483,647
Integer
Integer
-2,147,483,648 to 2,147,483,647
Float
Decimal
Precision 1 to 28
Long
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Double
Double
Precision 15
DateTime
Date/Time
Date and time formats are specified by using any of the Java date and time pattern strings. For example,
The "EEE, d MMM yyyy HH:mm:ss z" pattern string is interpreted as Wed, 14 Dec 2013 12:08:56. The "yyyy.MM.dd HH:mm:ss z" pattern string is interpreted as 2013.12.14 12:08:56 PDT.


Updated September 24, 2018