The table create statement from Presto to AWS Glue metastore fails with error "Lock is not supported by default".
presto> create schema isl_progress with(location='s3://xxxxxx/'); CREATE SCHEMA presto> create table isl_progress.sprint_details(sprint_id int, sprint_progress_pct varchar); Query 20221114_115537_00033_tb3fw failed: Lock is not supported by default
Is there a way to avoid the Lock. Or how this issue can be addressed?
Below is my Presto connector configuration.
cat iceberg.properties
connector.name=iceberg
iceberg.file-format=PARQUET
hive.metastore = glue
hive.metastore.glue.endpoint-url = https://XXXXXXXXX.amazonaws.com
hive.parquet.use-column-names = true
hive.non-managed-table-writes-enabled=true
hive.metastore.glue.region=XXXXX
hive.metastore.glue.aws-access-key=XXXXXX
hive.metastore.glue.aws-secret-key=XXXXXX
#iceberg.hive.lock-check-max-wait-ms=50
iceberg.max-partitions-per-writer=4
hive.non-managed-table-writes-enabled=true
hive.s3select-pushdown.enabled=true
hive.s3.connect-timeout=50000s
hive.s3.socket-timeout=50000s
hive.s3.max-connections=1000
hive.s3.multipart.min-file-size=1000MB
hive.s3.multipart.min-part-size=200MB
