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 :

Quick install HBase in “pseudo distributed” mode and connect from Java

On first reading of the HBase documentation, setting up pseudo distributed mode sounds very simple. The problem is that there a lot of gotchas, which can make life very difficult indeed. Consequently, many people follow a twisted journey to their final destination, and when they finally get there, aren’t sure which of the measures they took were needed, and which were not. This is reflected by a degree of misinformation on the Web, and I will try and present here a reasonably minimal way of getting up and running (that is not even to say that every step I take is absolutely necessary even, but I’ll mention where I’m not sure).

Step 1: Check your IP setup
I believe this is one of the main causes of the weirdness that can happen. So, if you’re on Ubuntu check your hosts file. If you see something like:
127.0.0.1 localhost
127.0.1.1 <server fqn> <server name, as in /etc/hostname>
get rid of the second line, and change to
127.0.0.1 locahost
<server ip> <server fqn> <server name, as in /etc/hostname>
e.g.
127.0.0.1 localhost
23.201.99.100 hbase.mycompany.com hbase