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년 전- 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