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.
preguntada hace 6 meses668 visualizaciones
1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
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.
Contenido relevante
OFICIAL DE AWSActualizada hace un año- OFICIAL DE AWSActualizada hace 3 años
- OFICIAL DE AWSActualizada hace 3 años
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