...
- arrays:
ARRAY<data_type>
- maps:
MAP<primitive_type, data_type>
structs: {{Wiki Markup 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.
Info | ||
---|---|---|
| ||
Timestamps were introduced in Hive 0.8.0 (HIVE-2272). |
...