Apache Drill vs SQuirreL SQL Client
Apache Drill
drill.apache.orgSQuirreL SQL Client
squirrel-sql.sourceforge.ioSide by side
| Figure | Apache Drill | SQuirreL SQL Client |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| API | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · SQL Query Tools | 9.0 (#3) | 8.1 (#12) |
| License | The Apache Drill site identifies the project as licensed under the Apache License, Version 2.0. | The project says it has been released under the GNU Lesser General Public License since version 1.1beta2. |
| Purpose | Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL and cloud storage. | SQuirreL is a graphical Java client for viewing JDBC database structure, browsing table data, and issuing SQL commands. |
| Security | Documented security features include Kerberos, username and password authentication, Digest authentication, authorization and user impersonation. | Version 5.1.0 highlights enhanced security for encrypting Alias passwords. |
| Support | The project directs questions to its drill-dev mailing list and welcomes contributions. | The project directs users to its mailing lists for usage questions and developer discussion; posting requires subscription. |
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.
SQuirreL SQL Client
SQuirreL SQL Client has no write-up on Specifiction yet; its figures are above.