- Más nuevo
- Más votos
- Más comentarios
Hi,
as described in the Athena Documentation Delete works only with Iceberg tables.
Tables catalogued in the AWS Glue Catalog from file formats as csv, parquet, orc, json, etc. are append only; a data lake it is not transactional unless you start using an open table format as Iceberg, Hudi or Delta. Currently Athena supports only Iceberg for deletes.
To learn more on how to create and work with a Iceberg table in the AWS Glue Catalog refer to this documentation page from LakeFormation and the following blog posts: Introducing AWS Glue crawler and create table support for Apache Iceberg format , AWS Glue Data Catalog now supports automatic compaction of Apache Iceberg tables, Perform upserts in a data lake using Amazon Athena and Apache Iceberg
hope this helps
Contenido relevante
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace un año