Amazon Athena: Query S3 Using SQL

kermatt wrote: post #3

"Amazon Athena uses Presto with ANSI SQL support and works with a variety of standard data formats, including CSV, JSON, ORC, and Parquet." I wonder if this is essentially a Presto SaaS product?

Yes

Re: Amazon Athena: Query S3 Using SQL

#5

Post by estefan » Wed, Nov 30, 2016, 5:45 PM UTC

jakozaur wrote: post #2

Looks very similar to Google Big Query. Even the pricing is same: $5 / TB of data scanned.

When I tried it it was slower than bigquery. Plus you've got to mess about creating hive schemas.

Re: Amazon Athena: Query S3 Using SQL

#6

Post by neximo64 » Wed, Nov 30, 2016, 5:52 PM UTC

Any examples of queries and what this can do? S3 was file storage as far as i thought?

Re: Amazon Athena: Query S3 Using SQL

#7

Post by guywithabike » Wed, Nov 30, 2016, 5:52 PM UTC

estefan wrote: post #5

jakozaur wrote: post #2

Looks very similar to Google Big Query. Even the pricing is same: $5 / TB of data scanned.

When I tried it it was slower than bigquery. Plus you've got to mess about creating hive schemas.

TFA states: "Amazon Athena uses Presto with ANSI SQL support and works with a variety of standard data formats, including CSV, JSON, ORC, and Parquet."

Re: Amazon Athena: Query S3 Using SQL

#8

Post by jackmaney » Wed, Nov 30, 2016, 5:54 PM UTC

estefan wrote: post #5

jakozaur wrote: post #2

Looks very similar to Google Big Query. Even the pricing is same: $5 / TB of data scanned.

When I tried it it was slower than bigquery. Plus you've got to mess about creating hive schemas.

> Q: What data formats does Amazon Athena support?

> Amazon Athena supports a wide variety of data formats like CSV, TSV, JSON, or Textfiles and also supports open source columnar formats such as Apache ORC and Apache Parquet. Athena also supports compressed data in Snappy, Zlib, and GZIP formats. By compressing, partitioning, and using columnar formats you can improve performance and reduce your costs.

https://aws.amazon.com/athena/faqs/

Re: Amazon Athena: Query S3 Using SQL

#9

Post by spullara » Wed, Nov 30, 2016, 5:59 PM UTC

It looks really interesting but I'm surprised they launched it with the create table flow broken. The query you see here was generated by their wizard...

https://www.dropbox.com/s/s4cw5x7yyrdl3ch/Screenshot%202016-...

Re: Amazon Athena: Query S3 Using SQL

#10

Post by spullara » Wed, Nov 30, 2016, 6:00 PM UTC

estefan wrote: post #5

jakozaur wrote: post #2

Looks very similar to Google Big Query. Even the pricing is same: $5 / TB of data scanned.

When I tried it it was slower than bigquery. Plus you've got to mess about creating hive schemas.

I don't know why you are getting downvoted. For all those data formats you have to painstakingly make table schemas for them before you can query them. Not like Snowflake or BigQuery. One of the biggest strikes against Presto IMHO.