Data types supported by Hive

      Comments Off on Data types supported by Hive
Primitive data types:
a. Numeric types:
i. TINYINT
ii. SMALLINT
iii. INT
iv. BIGINT
v. FLOAT
vi. DOUBLE
b. String types:
i. STRING
ii. CHAR
iii. VARCHAR
c. Date and Time types:
i. TIMESTAMP
ii. DATE
d. Boolean type: BOOLEAN

Complex data types:
a. Arrays: ARRAY<data_type>
b. Maps: MAP<primitive_type, data_type>
c. Structs: STRUCT<col_name : data_type [COMMENT col_comment], ...>
d. Union: UNIONTYPE<data_type, data_type, ...>

Note: In Hive, the data type of a column must be specified when the table is created, and cannot be changed later. Additionally, Hive provides a way to cast data from one type to another using the CAST function.