Supported data types - Amazon Athena

Supported data types

Athena can query Iceberg tables that contain the following data types:

binary boolean date decimal double float int list long map string struct timestamp without time zone

For more information about Iceberg table types, see the schemas page for Iceberg in the Apache documentation.

The following table shows the relationship between Athena data types and Iceberg table data types.

Iceberg type Athena type Notes
boolean boolean
- tinyint Not supported for Iceberg tables in Athena.
- smallint Not supported for Iceberg tables in Athena.
int int In Athena DML statements, this type is INTEGER.
long bigint
double double
float float
decimal(P, S) decimal(P, S) P is precision, S is scale.
- char Not supported for Iceberg tables in Athena.
string string In Athena DML statements, this type is VARCHAR.
binary binary
date date
time - Only Iceberg timestamp (without time zone) is supported for Athena Iceberg DDL statements like CREATE TABLE, but all timestamp types can be queried through Athena.
timestamp timestamp
timestamptz timestamptz
list<E> array
map<K,V> map
struct<...> struct
fixed(L) - The fixed(L) type is not currently supported in Athena.

For more information about data types in Athena, see Data types in Amazon Athena.