Skip to content

ICEBERG_COMMIT_ERROR

1

I am getting this error when trying to run a MERGE INTO query from Athena. How can I create/alter an APACHE-ICEBERG table so that I can change the default value of the parameter commit.retry.num-retries? Thanks

asked 3 years ago2.8K views
2 Answers
1

Reference Document

https://iceberg.apache.org/docs/latest/hive/

CREATE EXTERNAL TABLE my_database.my_table
STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler'
TBLPROPERTIES (
  'iceberg.mr.catalog'='hive',
  'commit.retry.num-retries'='<custom_number_of_retries>'
)
AS SELECT ...

===

ALTER TABLE my_database.my_table
SET TBLPROPERTIES (
  'commit.retry.num-retries'='<custom_number_of_retries>'
)

please review and update according to reference document

EXPERT
answered 3 years ago
  • What does 'iceberg.mr.catalog'='hive', is doing in the Athena context?

    The reason why I'm asking is

    "ErrorMessage": "Unsupported table property key: iceberg.mr.catalog"
    
1

did someone able to find the solution?can u pls let me know?

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.