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