Data Types

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.

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.

• ARRAY Complex Type (Impala 2.3 or higher only)

• BIGINT Data Type

• BOOLEAN Data Type

• CHAR Data Type (Impala 2.0 or higher only)

• DECIMAL Data Type (Impala 3.0 or higher only)

• DOUBLE Data Type

• FLOAT Data Type

• INT Data Type

• MAP Complex Type (Impala 2.3 or higher only)

• REAL Data Type

• SMALLINT Data Type

• STRING Data Type

• STRUCT Complex Type (Impala 2.3 or higher only)

• TIMESTAMP Data Type

• TINYINT Data Type

• VARCHAR Data Type (Impala 2.0 or higher only)

• Complex Types (Impala 2.3 or higher only)

Parent topic: Impala SQL Language Reference