- Drill is able to query complex semi-structured data in situ without requiring users to define schemas or transform data
- Drill supports the ANSI SQL 2003 standard syntax ecosystem and dozens of NoSQL databases and file systems
The Apache Drill Project announced the release of Apache DrillTM v1.19, the schema-free Big Data SQL query engine for Apache Hadoop, NoSQL, and Cloud storage. It said that as an “SQL-on-Hadoop” engine, Apache Drill is easy to deploy, highly performant, able to quickly process trillions of records, and scalable from a single laptop to a 1000-node cluster.
With its schema-free JSON model (the first distributed SQL query engine of its kind), Drill is able to query complex semi-structured data in situ without requiring users to define schemas or transform data. It provides plug-and-play integration with existing Hive and HBase deployments, and is extensible out-of-the-box to access multiple data sources, like S3 and Apache HDFS, HBase, and Hive. Drill can directly query data from REST APIs to include platforms like SalesForce and ServiceNow.
Drill supports the ANSI SQL 2003 standard syntax ecosystem and dozens of NoSQL databases and file systems, including Apache HBase, MongoDB, Elasticsearch, Cassandra, REST APIs, , HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, NAS, local files, and more. Drill leverages familiar BI tools (such as Apache Superset, Tableau, MicroStrategy, QlikView and Excel) and data virtualization and visualization tools, and runs interactive queries on Hive tables with different Hive metastores.
Drill is designed from the ground up to support high-performance analysis on rapidly evolving data on modern Big Data applications. v1.19 reflects more than 100 changes, improvements, and new features that include new connectors for Apache Cassandra, Elasticsearch, and Splunk, new format Reader for XML without schemas, added Avro support for Kafka plugin, integrated password vault for secure credential storage. It comes with support for Linux ARM64 systems and added streaming for Drill’s REST API.
Developers, analysts, business users, and data scientists use Apache Drill for data exploration and analysis for its enterprise-grade reliability, security, and performance.