Please enable JavaScript.
Coggle requires JavaScript to display documents.
Hive Data Types (Complex data types (MAP (MAP<data_type, data_type>)…
Hive Data Types
Complex data types
MAP
MAP<data_type, data_type>
-
STRUCT
STRUCT<col_name : data_type [COMMENT col_comment], ...>
UNION
UNION<data_type, data_type, ...>
Primitive data types
-
-
Numeric data types
DECIMAL
17-byte precision up to 38 digits -> DECIMAL(20,2)
DOUBLE
8-byte double-precision floating point -> 50,000,000.45
-
BIGINT
8-byte signed integer -> 50,000,000
INT
4-byte signed integer -> 1,000
SMALLINT
2-byte signed integer -> 20,000
-
-