What is the difference between Amazon Athena and S3 Select

0 votes
What is the difference between Athena and S3 Select? Can someone highlight the difference between these two? Thank you in advance.
Jan 17, 2019 in AWS by Anjali
• 2,950 points
9,396 views

1 answer to this question.

+1 vote

Athena can be used by AWS Console, AWS CLI but S3 Select is basically an API. Both works on S3 data but lets say you have a scenario like this you have 1GB csv file with 10 equal sized columns and you are summing the values on 1 column. With athena, athena downloads 1GB from s3 into athena, scans the file and sums the data. With S3 select, you get a 100MB file back that only contains the one column you want to sum, but you'd have to do the summing. With Athena+S3 Select, Athena requests just that column from S3, it returns 100MB to Athena, and then Athena does the summing for you.

Hope you got the answer.

answered Jan 17, 2019 by Edureka
• 4,220 points
Does Athena use s3 select internally without having to configure anything when using RegEx SerDe for example ?

Amazon Athena uses Presto with full standard SQL support and works with a variety of standard data formats, including CSV, JSON, ORC, Avro, and Parquet. Athena can handle complex analysis, including large joins, window functions, and arrays. Because Amazon Athena uses Amazon S3 as the underlying data store, it is highly available and durable with data redundantly stored across multiple facilities and multiple devices in each facility.

Hi. You said that Athena and S3 Select can be used together. How does that work?
```

With Athena+S3 Select, Athena requests just that column from S3, it returns 100MB to Athena, and then Athena does the summing for you.

```

You mean, "S3 Select requests just that column from S3....", right ?
Yes you can say that.

Related Questions In AWS

0 votes
1 answer

What is the difference between Amazon Cloudfront and S3

major difference is that cloudfront allows you ...READ MORE

answered Jul 10, 2018 in AWS by Priyaj
• 58,090 points
1,604 views
+1 vote
4 answers

What is the difference between Amazon ECS and Amazon EC2?

EC2 allows you to launch individual instances ...READ MORE

answered Jul 11, 2018 in AWS by Priyaj
• 58,090 points
42,501 views
0 votes
2 answers

What is the difference between Amazon SNS and Amazon SQS?

Amazon SQS and SNS are the two ...READ MORE

answered Sep 9, 2020 in AWS by Michael
• 140 points
2,949 views
0 votes
0 answers
0 votes
1 answer
+1 vote
2 answers
0 votes
2 answers
0 votes
1 answer

What are the benefits of Migration?

Answering your second question first, Data Centers ...READ MORE

answered Jan 18, 2019 in AWS by Edureka
• 4,220 points
418 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP