Apache Drill vs PGSpider
Apache Drill
drill.apache.orgPGSpider
github.comSide by side
| Figure | Apache Drill | PGSpider |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | Yes |
| API | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Data Federation Software | 9.0 (#1) | 7.6 (#12) |
| Data sources | The site lists support for sources including HBase, MongoDB, HDFS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS, and local files. | The README demonstrates PostgreSQL and SQLite and lists PostgreSQL, MySQL, Oracle, GridDB, PGSpider, InfluxDB v2.0, and Amazon S3 Parquet storage for migration. |
| Deployment | Drill can run embedded on a laptop or in distributed mode on a cluster of servers. | The README documents building from source and installing to /usr/local/pgspider. |
| License | The Apache Drill site identifies the project as licensed under the Apache License, Version 2.0. | The included license permits use, copying, modification, and distribution without a fee, and disclaims warranties and an obligation to provide support or updates. |
| Purpose | Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL and cloud storage. | PGSpider is a SQL cluster engine for distributed big data that accesses data sources through Foreign Data Wrappers. |
Plans
In their own words
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.