Impala supports a set of data types that you can use for table columns, expression values, and function arguments and return values.
- BIGINT Data Type
- BOOLEAN Data Type
- CHAR Data Type (CDH 5.2 or later only)
- DECIMAL Data Type (CDH 5.1 or later 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
- VARCHAR Data Type (CDH 5.2 or later only)
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.