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.
Data types supported by Hive
Comments Off on Data types supported by Hive