The following datatypes are supported by Hive version 0.14:
Datatype group | Datatype | Format |
String | STRING | column_name STRING |
VARCHAR | column_name VARCHAR(max_length) | |
CHAR | column_name CHAR(length) | |
Numeric | TINYINT | column_name TINYINT |
SMALLINT | column_name SMALLINT | |
INT | column_name INT | |
BIGINT | column_name BIGINT | |
FLOAT | column_name FLOAT | |
DOUBLE | column_name DOUBLE | |
DECIMAL | column_name DECIMAL[(precision[,scale])] | |
Date/time type | TIMESTAMP | column_name TIMESTAMP |
DATE | column_name DATE | |
INTERVAL | column_name INTERVAL year to month | |
Miscellaneous type | BOOLEAN | column_name BOOLEAN |
BINARY | column_name BINARY | |
Complex type | ARRAY | column_name ARRAY < type > |
MAPS | column_name MAP < primitive_type, type > | |
STRUCT | column_name STRUCT < name : type [COMMENT 'comment_string'] > | |
UNION | column_name UNIONTYPE <int, double, array... |