Showing posts with label data types in hive. Show all posts
Showing posts with label data types in hive. Show all posts

Friday, March 30, 2012

Data type in hive : What all data types we can specify in hive


Type of Data                   Size Limit
-----------------------------------------------
TINYINT                          1 byte
SMALLINT                      2 byte

INT                                  4 byte
BIGINT                            8 byte
FLOAT                            4 byte  (single precision floating point numbers)
DOUBLE                         8 byte (double precision floating point numbers)
BOOLEAN                       TRUE/FALSE value
STRING                           Max size is 2GB.

Maps:  : Contains Key Pair Value 
Arrays  : Contains collection of same data types
Structs : Contains collection of different data types

Syntax of creating table in hive :

Featured Posts

Kali Linux Remote Desktop: Access GNOME from Windows Using Native RDP

  Kali Linux + GNOME 50 + GNOME Remote Desktop + Windows Remote Desktop (MSTSC) Getting a full GNOME desktop remotely on Kali Linux can be ...