Amazon Athena vs Apache Drill
Amazon Athena
aws.amazon.comApache Drill
drill.apache.orgSide by side
| Figure | Amazon Athena | Apache Drill |
|---|---|---|
| Price from | $0.30/mo | Free |
| Free plan | — | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | Yes | Yes |
| Self-hosted | — | Yes |
| Plans published | 3 | 1 |
| Spec score · Query Engine Software | 7.8 (#13) | 8.9 (#2) |
| Purpose | Amazon Athena is a serverless interactive query service for analyzing data in Amazon S3 with standard SQL. | Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL and cloud storage. |
| Security | Access to data can be controlled with IAM policies, access control lists, and S3 bucket policies, and Athena supports querying encrypted S3 data and writing encrypted results. | Documented security features include Kerberos, username and password authentication, Digest authentication, authorization and user impersonation. |
Plans
Amazon Athena
- SQL queries with Capacity Reservations$0.30 a month
- Apache Spark$0.35 a month
- SQL queries$5 a month
In their own words
Amazon Athena
Amazon Athena has no write-up on Specifiction yet; its figures are above.
Apache Drill
Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage. It can query raw data where it resides without first loading it, defining schemas, or transforming it. Its JSON data model supports complex and nested structures, and a single query can join data across multiple datastores. Listed sources include HBase, MongoDB, HDFS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS, and local files. JDBC and ODBC drivers connect Drill to tools including Tableau, Qlik, MicroStrategy, Spotfire, SAS, and Excel; developers can also use its REST API in custom applications. Drill can run embedded on a laptop or in distributed mode on a server cluster, and the homepage lists Mac, Windows, and Linux. Documented security options include Kerberos, username and password authentication, Digest, authorization, and impersonation. The software is free under Apache License 2.0. A compatibility limit: official support for Hadoop 2 and Java 8 was dropped with Drill 1.22.0.