Supported datatypes

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