Question

I m 在Athena创建Iceberg表格,如:

CREATE TABLE IF NOT EXISTS table1 (`col1` string, `col2` string) 
LOCATION  s3://my-bucket/path/table1/ 
TBLPROPERTIES ( table_type = ICEBERG ,  format = parquet )

并试图在表格中添加价值观,如:

INSERT INTO table1 VALUES ( hello ,  iceberg )

我遇到这样的错误:

GENERIC_INTERNAL_ERROR:
io.trino.hdfs.s3.TrinoS3FileSystem$UnrecoverableS3OperationException:
com.amazonaws.services.s3.model.AmazonS3Exception:
The specified key does not exist. (Service: Amazon S3; Status Code: 404; Error Code: NoSuchKey; Request ...

我做了什么错误?

Answer 1

The location is being set incorrectly, and should not include a trailing /.

核对<代码>aws s3 ls s3 http://my-bucket/path/table1/ - 收到。如果你看到<代码>/的关键,例如s3 http://my-bucket/path/table1/metadata/...,你就遇到了这一问题。 <代码>/是一个有用的信号,表明您的外在条目中添加了<代码>/。

简而言之,在座标上没有挂图<>/。

CREATE TABLE IF NOT EXISTS table1 (`col1` string, `col2` string) 
LOCATION  s3://my-bucket/path/table1 
TBLPROPERTIES ( table_type = ICEBERG ,  format = parquet )

友情链接