Apache Drill
6.7#3 in data federation softwareFree planFree planAPILinuxmacOSSelf-hosted
Visit
| Fact | Apache Drill | Spotfire Data Virtualization |
|---|---|---|
| Deployment | Drill can run embedded on a laptop or in distributed mode on a cluster of servers. | Spotfire data virtualization can be deployed on-premises, in private or public clouds, and in containerized environments such as Kubernetes and Docker. |
| Security | Documented security features include Kerberos, username and password authentication, Digest authentication, authorization and user impersonation. | The data virtualization datasheet describes authentication, authorization, encryption, fine-grained access controls, traceability, and uniform policies across data sources. |
| Support | The project directs questions to its drill-dev mailing list and welcomes contributions. | Spotfire provides a support portal, knowledge base, product documentation, and a community discussion forum. |
| What it does | Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage. | Spotfire Enterprise Advanced Data Services virtualizes data across sources so teams can access and query distributed data without replication. |
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.
It suits teams querying data distributed across sources, including organizations with multiple departments, projects, and thousands of users. Business users can also use its directory to discover and share curated datasets.