Amazon Athena - S3 location error

Question

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)

Answer 1

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