Page History

...

• arrays: ARRAY<data_type>
• maps: MAP<primitive_type, data_type>
• Wiki Markupstructs: {{STRUCT<col_name : data_type \ [COMMENT col_comment\], ...>}}
• union: UNIONTYPE<data_type, data_type, ...> (Note: Only available starting with Hive 0.7.0)

...

Timestamps are interpreted to be timezoneless and stored as an offset from the UNIX epoch. Convenience UDFs for conversion to and from timezones are provided (to_utc_timestamp, from_utc_timestamp).
All existing datetime UDFs (month, day, year, hour, etc.) work with the TIMESTAMP data type.unmigrated-wiki-markup

Timestamps in text files have to use the format {{yyyy-mm-dd hh:mm:ss\[.f...\]}}. If they are in another format declare them as the appropriate type (INT, FLOAT, STRING, etc.) and use a UDF to convert them to timestamps.

...