Query Iceberg Tables already present in Glue

0

I have Iceberg tables that were created in Glue with Parquet files, but I am unable to query these tables from Athena. I had a similar situation with Delta Lake tables which was resolved by using the Glue Delta Crawler. Is there an extra step required in order to view and query Iceberg tables from Athena?

asked 2 years ago851 views
1 Answer
1

First off, I'd like to let you know that Athena only supports Iceberg tables built against the AWS Glue catalogue using the specifications established by the open source glue catalogue implementation. Additionally, in the TBL PROPERTIES clause, you must specify the 'table type' table property to 'ICEBERG' in order to construct an Iceberg table from Athena [1] : -

" CREATE TABLE [db_name.]table_name (col_name data_type [COMMENT col_comment] [, ...] ) [PARTITIONED BY (col_name | transform, ... )] LOCATION 's3://DOC-EXAMPLE-BUCKET/your-folder/' TBLPROPERTIES ( 'table_type' ='ICEBERG' [, property_name=property_value] ) "

In relation to using Apache Iceberg with Athena, I would also advise you to read over the many considerations and restrictions listed in the document found here [2].

Incase if you still face the issue , there can other backend issue which can only be seen through backend tool. So, I would request you to raise a case to Premium support regarding the same from the concerned account.

References :-

[1]: Creating Iceberg tables - https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-creating-tables.html

[2]: Considerations and limitations with using Iceberg tables with Athena - https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg.html#querying-iceberg-considerations-and-limitations

AWS
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions