Live data from Hacker News

Amazon Athena: Query S3 Using SQL

aws.amazon.com

41–45 of 45 posts

Re: Amazon Athena: Query S3 Using SQL

#41

Earlier quoted context omitted.

Are you talking about this? you left out a word. Simply point to your data in Amazon S3

Still makes no sense. Please explain if you understand.

To me the obvious use case is querying your log files as stored on s3. Query for a specific combination of features, or do some (simple) processing on them.

It's really only useful for a small list of file formats. Doesn't really do much for you if you primarily use s3 for binary data or static web hosting.

Re: Amazon Athena: Query S3 Using SQL

#44
post #37

$5 a terabyte jeebus...don't f that query up

Just like with BigQuery, a carefully thought out partitioning scheme is critical, or your queries need to be carefully locked down to prevent excessive table scanning. I burned through my BigQuery trial credit fast, by not using partitions during a quick-and-dirty test.
Post reply on HN