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... |