Impala supports a set of data types that you can use for table columns, expression values, and function arguments and return values.

  Note: Currently, Impala supports only scalar types, not composite or nested types. Accessing a table containing any columns with unsupported types causes an error.

Continue reading:

• BIGINT Data Type
• BOOLEAN Data Type
• DECIMAL Data Type (CDH 5.1 or higher only)
• DOUBLE Data Type
• FLOAT Data Type
• INT Data Type
• REAL Data Type
• SMALLINT Data Type
• STRING Data Type
• TIMESTAMP Data Type
• TINYINT Data Type

For the notation to write literals of each of these data types, see Literals.

See SQL Differences Between Impala and Hive for differences between Impala and Hive data types.