Apache Drill
6.7#3 in data federation softwareFree planFree planAPILinuxmacOSSelf-hosted
Visit| Fact | Apache Drill | Teiid |
|---|---|---|
| Deployment | Drill can run embedded on a laptop or in distributed mode on a cluster of servers. | The project describes Spring Boot, WildFly, embedded Java, and OpenShift deployment options. |
| License | The Apache Drill site identifies the project as licensed under the Apache License, Version 2.0. | The community page says that starting with Teiid 10.0, the majority of Teiid and related project code is under the Apache License 2.0. |
| Purpose | Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL and cloud storage. | Teiid is a Java data virtualization query engine that integrates data from multiple sources through a uniform API. |
| Security | Documented security features include Kerberos, username and password authentication, Digest authentication, authorization and user impersonation. | The site describes Teiid as providing secure data access and says Spring Boot projects can select security integration among their dependencies. |
| Support | The project directs questions to its drill-dev mailing list and welcomes contributions. | The site directs users to community channels including Stack Overflow, a legacy forum, GitHub, and project issue trackers. |
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.
Teiid suits Java developers integrating multiple enterprise data sources, particularly those targeting OpenShift. It may be a poor fit for big-data, LDAP-style virtualization, or primarily streaming workloads.