amazon-web-services - Amazon Athena - S3 位置错误

Question

在 S3 存储桶上运行 Amazon Athena 查询时出现以下错误。

我在 CloudFront 访问日志上运行此查询。

CREATE EXTERNAL TABLE IF NOT EXISTS cloudfront.cf_logs (
  `date` date,
  `time` string,
  `location` string,
  `bytes` int,
  `requestip` string,
  `method` string,
  `host` string,
  `uri` string,
  `status` int,
  `referrer` string,
  `os` string,
  `browser` string,
  `browserversion` string 
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
) LOCATION 's3://cloudfront-access/test-sh/'
TBLPROPERTIES ('has_encrypted_data'='false');

错误返回:

Your query has the following error(s):

The S3 location provided to save your query results is invalid. Please
check your S3 location is correct and is in the same region and try
again. If you continue to see the issue, contact customer support for
further assistance. (Service: AmazonAthena; Status Code: 400; Error
Code: InvalidRequestException; Request ID:
f8cd2762-1e7-a2f9-e5eb1d865406)

Answer 1

Amazon Athena 将每个查询的输出保存在 Amazon S3 存储桶中。错误消息是说 Athena 无法访问此存储桶。

点击 Settings屏幕顶部的链接

验证是否显示了存储桶名称(如果您愿意，可以随意更改)

在 Amazon S3 管理控制台中验证同一区域中是否存在该名称的存储桶。如果没有，请创建存储桶。