/    /  Hive Datatypes

Hive Datatypes:

This hive data types are similar to SQL language data types just with some differences. We can say that we have 4 different types of datatypes in hive. They are,

  • Numeric datatypes– Example of numeric datatypes are TINYINT(1-byte),SMALLINT (2-byte),INT/INTEGER (4-byte),BIGINT (8-byte),FLOAT (4-byte),DOUBLE (8-byte),DECIMAL,NUMERIC (same as DECIMAL, starting with Hive 3.0.0)
  • Date type–TIMESTAMP, DATE and INTERVAL.
  • String Types-String, varchar, char
  • Complex Types-Arrays, Map, structs, union