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
5,971 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,200 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 9, 2018 in AWS by Priyaj
• 57,700 points
694 views
0 votes
3 answers
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 in AWS by Michael
• 140 points
1,465 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, 2019 in AWS by Edureka
• 4,200 points
66 views