Apache Drill
6.7#3 in data federation softwareFree planFree planAPILinuxmacOSSelf-hosted
VisitApache Drill vs PGSpider
What both publish
| Fact | Apache Drill | PGSpider |
|---|---|---|
| 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. |
Apache Drill plans
- Apache DrillFree
PGSpider plans
- PGSpiderFree
Pick Apache Drill if…
It suits users who want to query raw data across Hadoop, NoSQL, cloud, or local sources, and developers building applications with its REST API. BI users can connect through the listed JDBC and ODBC drivers.
Pick PGSpider if…
PGSpider may suit Linux users who want to query data across multiple sources through SQL and can build and self-host software. It is relevant to teams that need parallel queries or Multi-Tenant virtual tables.