Data Types

The Simba Impala ODBC Driver supports many common data formats, converting between Impala data types and SQL data types.

The table below lists the supported data type mappings.

Impala Type	SQL Type
ARRAY	SQL_VARCHAR
BIGINT	SQL_BIGINT
BOOLEAN	SQL_BOOLEAN
CHAR Note: Only available in CDH 5.2 or later.	SQL_CHAR Note: SQL_WCHAR is returned instead if the Use SQL Unicode Types configuration option (the `UseUnicodeSqlCharacterTypes` key) is enabled.
DATE Note: DATE data types are only supported in Impala 3.3 or later.	SQL_DATE
DECIMAL Note: Only available in CDH 5.2 or later.	SQL_DECIMAL
DOUBLE Note: REAL is an alias for DOUBLE.	SQL_DOUBLE
FLOAT	SQL_REAL
INT	SQL_INTEGER
MAP	SQL_VARCHAR
SMALLINT	SQL_SMALLINT
STRUCT	SQL_VARCHAR
TIMESTAMP	SQL_TIMESTAMP
TINYINT	SQL_TINYINT
VARCHAR Note: Only available in CDH 5.2 or later.	SQL_VARCHAR Note: SQL_WVARCHAR is returned instead if the Use SQL Unicode Types configuration option (the `UseUnicodeSqlCharacterTypes` key) is enabled.