Amazon Athena - S3 location error

0 votes

While running an Amazon Athena query on an S3 bucket I am getting an error:

I am running this query on CloudFront access logs.

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');

Error:-

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)
Jan 16 in AWS by Anjali
• 2,900 points
27 views

1 answer to this question.

0 votes

You must know this that Amazon Athena saves the output of each query in Amazon S3 bucket. 

The error message is saying that Athena is unable to access this bucket. So to change the settings and make the desired changes you can do the following things:-

  • Click the Settings link at the top of the screen
  • Verify that a bucket name is shown (feel free to change it if you wish)
  • Verify in the Amazon S3 management console that a bucket of that name exists in the same region. If not, create the bucket.
Now try doing the same it will work properly
answered Jan 16 by Sneha

Related Questions In AWS

0 votes
1 answer
0 votes
1 answer
+4 votes
5 answers

Usage of Amazon Cloudfront or S3

When to use S3? S3 is like many ...READ MORE

answered Apr 3, 2018 in AWS by brat_1
• 7,080 points
81 views
0 votes
1 answer
+1 vote
2 answers
0 votes
1 answer

AWS Access Key error when uploading to S3

You can try getting creating a new ...READ MORE

answered Feb 6 in AWS by Priyaj
• 56,160 points
841 views