Apache Hive (Hadoop) User Attributes

For information on the parameters in this dialog that are common to all readers, see:

For information on the parameters in this dialog that are common to all writers, see:

User attributes for this format are defined below.

Name The name of the field to be written.
Type

This format supports the following field types.

array

Complex type that represents an array.

bigint

Represents 64-bit signed integers.

binary

Represent a binary value.

boolean

Stores the logical values true or false.

char

Represents a fixed-length character string from 1 to 255.

date

Represents date data from January 1, 0001 to December 31, 9999.

See Standard FME Date/Time Format.

decimal

Represents a decimal number with a maximum precision of 38.

double

Represents a 64-bit double-precision floating point number.

float

Represents a 32-bit single-precision floating point number.

int

Represents a 32-bit (4-byte) signed integer.

map

Complex type, represents a map (a dictionary).

smallint

Represents 16-bit (2-byte) signed integer.

string

Represents a character string

struct

Represents a composite data type that contains a collection of other complex and simple data types.

timestamp

This type is used to represent date and time data from January 1, 0001 to December 31, 9999 with optional nanosecond precision.

See Standard FME Date/Time Format.

tinyint

Represents a 8-bit (1-byte) signed integer.

varchar

Represents a variable length character string of length 1 to 65535.

Note: Hive also supports “Union” and “Interval” column types. None of Hive JDBC drivers support the “Union” column type, and “Interval” column types will be read as a string.