Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Supported data types for Iceberg tables in Athena

Focus mode
Supported data types for Iceberg tables in Athena - Amazon Athena

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.

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.