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,910 points
220 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,120 points
69 views
0 votes
1 answer

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,120 points
958 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
381 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
17 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.