|
Data Type Definition
Keyword
|
Impala Data Type
|
Description
|
Data Type Returned
|
|---|---|---|---|
|
BIGINT
|
BIGINT
|
A signed eight-byte
integer, from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
|
BIGINT
|
|
CHAR(n)
|
CHAR1
|
A fixed-length character
string up to 255 characters.
|
CHAR
|
|
DATE
|
An ANSI SQL date type.
|
TIMESTAMP
|
|
|
DOUBLE
|
DOUBLE
|
An eight-byte, double-precision
floating-point number.
|
DOUBLE
|
|
FLOAT(p)
|
FLOAT
|
A four-byte, single-precision
floating-point number.
|
DOUBLE
|
|
INTEGER
|
INT
|
A signed four-byte integer,
from -2,147,483,648 to 2,147,483,647.
|
INTEGER
|
|
REAL
|
DOUBLE
|
An eight-byte, double-precision
floating-point number.
|
DOUBLE
|
|
SMALLINT
|
SMALLINT
|
A signed two-byte integer,
from -32,768 to 32,767.
|
SMALLINT
|
|
TIME
|
A time value.
|
TIMESTAMP
|
|
|
TIMESTAMP
|
TIMESTAMP
|
A UNIX timestamp with
optional nanosecond precision.
|
TIMESTAMP
|
|
TINYINT
|
TINYINT
|
A signed one-byte integer,
from -128 to 127.
|
TINYINT
|
|
VARCHAR(n)
|
VARCHAR1
|
A varying-length character
string.
|
VARCHAR
|
| 1Support for this data type is available in CDH 5.2 and later. In environments that use earlier CDH versions, which do not support the CHAR and VARCHAR types, columns defined as CHAR or VARCHAR are mapped to STRING. | |||
| 2Impala does not support this data type. When a DATE or TIME column is defined, it is created as a column of type TIMESTAMP. | |||