Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: add links to Hive Data Types & Type System (Tutorial)

...

HCatalog Data Type

Java Class in MapReduce

Values

TINYINT

java.lang.Byte

-128 to 127

SMALLINT

java.lang.Short

-(2^15) to (2^15)-1, which is -32,768 to 32,767

INT

java.lang.Integer

-(2^31) to (2^31)-1, which is -2,147,483,648 to 2,147,483,647

BIGINT

java.lang.Long

-(2^63) to (2^63)-1, which is -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

BOOLEAN

java.lang.Boolean

true or false

FLOAT

java.lang.Float

single-precision floating-point value

DOUBLE

java.lang.Double

double-precision floating-point value

DECIMAL

java.math.BigDecimal

exact floating-point value with 38-digit precision

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="0c18d09da9ecc92a-834e0dcb-4868419e-b55dacfc-315e4ac235541190fb9e9345"><ac:plain-text-body><![CDATA[

BINARY

byte[]

binary data

]]></ac:plain-text-body></ac:structured-macro>

STRING

java.lang.String

character string

STRUCT

java.util.List

structured data

ARRAY

java.util.List

values of one data type

MAP

java.util.Map

key-value pairs

For general information about Hive data types, see Hive Data Types and Type System.

Running MapReduce with HCatalog

...