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ヶ月前670ビュー
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年前
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