Athena fails adding table properties to an iceberg table
0
I am trying to add a table property to an iceberg table from Athena.
ALTER TABLE silver.table_name SET TBLPROPERTIES (
'write.merge.mode'='merge-on-read'
)
The query fails with error : Unsupported table property key: write.merge.mode
I have tried several other props and the command fails in the same way. I suspect Athena does not recognize that my table is an Iceberg one.
asked 6 months ago617 views
1 Answer
- Newest
- Most votes
- Most comments
0
Athena only allows special Athena Iceberg properties to be set for an Iceberg table:
https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-managing-tables.html#querying-iceberg-alter-table-set-properties
https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-creating-tables.html#querying-iceberg-table-properties
I suggest you make other changes using Spark or the Iceberg API.
Relevant content
- asked 9 months ago
- asked 3 months ago
AWS OFFICIALUpdated 2 months ago- AWS OFFICIALUpdated 3 months ago
The table IS NOT created from Athena but from iceberg library in spark. Actually you can change the write mode of an iceberg table after it has been created.
Either way, the properties Athena uses in the table are not the ones in the Iceberg table, you cannot change then that way