Impala Data Type _impala

Data type and description
BIGINT
This data type stores numeric values, which range from 9223372036854775808 to 9223372036854775807. This data type is used in CREATE TABLE and ALTER TABLE statements.
BOOLEAN
This data type stores only true or false values, which are used for the column definition of the CREATE TABLE statement.
CHAR
This data type is a fixed-length storage that is padded with spaces and can store a maximum length of 255.
DECIMAL
This data type is used to store decimal values and is used in CREATE TABLE and ALTER TABLE statements.
DOUBLE
This data type is used to store floating-point values in the range of positive or negative 4.94065645841246544e-324d-1.79769313486231570e + 308.
FLOAT
This data type is used to store positive or negative 1.40129846432481707e-45. Single-precision floating-point value data type in the range of 3.40282346638528860E + 38.
Int
This data type is used to store 4-byte integers ranging from 2147483648 to 2147483647.
SMALLINT
This data type is used to store 2-byte integers, ranging from 32768 to 32767.
STRING
This is used to store string values.
TIMESTAMP
This data type is used to represent points in time.
TINYINT
This data type is used to store 1-byte integer values ranging from 128 to 127.
VARCHAR
This data type is used to store variable-length characters with a maximum length of 65,535.
ARRAY
This is a complex data type that is used to store a variable number of ordered elements.
Map
This is a complex data type that is used to store a variable number of key-value pairs.
Struct
This is a complex data type that represents multiple fields for a single project.