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.
已提问 6 个月前668 查看次数
1 回答
- 最新
- 投票最多
- 评论最多
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.
相关内容
AWS 官方已更新 3 年前- AWS 官方已更新 2 年前
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