Supported data types with Apache Iceberg tables
This topic describes the supported data types that Redshift Spectrum can read from tables in Apache Iceberg format.
Amazon Redshift 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 data types, see the Schemas for
Iceberg
The following table shows the relationship between Amazon Redshift data types and Iceberg table data types.
| Iceberg type | Amazon Redshift type | Notes |
|---|---|---|
boolean |
boolean |
|
| - | tinyint |
Not supported for Iceberg tables in Amazon Redshift. |
| - | smallint |
Not supported for Iceberg tables in Amazon Redshift. |
int |
int |
In Amazon Redshift SQL statements, this type is INTEGER. |
long |
bigint |
|
double |
double precision |
|
float |
real |
|
decimal(P, S) |
decimal(P, S) |
P is precision, S is scale. |
| - | char |
Not supported for Iceberg tables in Redshift Spectrum. |
string |
string |
In Amazon Redshift SQL statements, this type is VARCHAR. |
binary |
binary |
|
date |
date |
|
time |
- | |
timestamp |
timestamp |
|
timestamptz |
- |
|
list<E> |
array |
|
map<K,V> |
map |
|
struct<...> |
struct |
|
fixed(L) |
- | The fixed(L) type is not currently supported in Redshift Spectrum. |
For more information about data types in Amazon Redshift, see Data types.
