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 in AWS by Anjali
• 2,930 points
903 views

1 answer to this question.

0 votes

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 by Edureka
• 4,180 points

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 9, 2018 in AWS by Priyaj
• 56,920 points
246 views
0 votes
2 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
• 56,920 points
2,272 views
0 votes
1 answer

What is the difference between Amazon SNS and Amazon SQS?

SNS is a distributed publish-subscribe system and the messages are pushed to ...READ MORE

answered Jul 30, 2018 in AWS by Mrunal
• 680 points
743 views
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 in AWS by Edureka
• 4,180 points
31 views