Running SQL Queries on Amazon S3
Posted on Feb 9, 2018 by Nick Amato
Drill enables you to run SQL queries directly on data in S3. There's no need to ingest the data into a managed cluster or transform the data. This is a step-by-step tutorial on how to use Drill with S3.
Drill 1.12 Released
Posted on Dec 15, 2017 by Bridget Bevens
Apache Drill 1.12's highlights are: Kafka and OpenTSDB storage plugins, SSL and network encryption support, queue-based memory assignment for buffering operators, networking functions, and the ability to prevent users from accessing paths outside the root of a workspace.
Drill 1.11 Released
Posted on Jul 31, 2017 by Bridget Bevens
Apache Drill 1.11's highlights are: Cryptography-related functions, spill to disk for the hash aggregate operator, Format plugin support for PCAP files, ability to change the HDFS block Size for Parquet files, ability to store query profiles in memory, configurable CTAS directory and file permissions option, support for network encryption, relative paths stored in the metadata file, and support for ANSI_QUOTES.
Drill 1.10 Released
Posted on Mar 15, 2017 by Bridget Bevens
Apache Drill 1.10's highlights are: CTTAS, improved fault tolerance, Drill version and statistics in Web Console, implicit interpretation of INT96, and Kerberos authentication.
Drill 1.9 Released
Posted on Nov 29, 2016 by Bridget Bevens
Apache Drill 1.9's highlights are: asynchronous Parquet reader, Parquet filter pushdown, dynamic UDF support, and HTTPD format plugin.
Drill 1.8 Released
Posted on Aug 30, 2016 by Bridget Bevens
Apache Drill 1.8's highlights are: metadata cache pruning, IF EXISTS support, DESCRIBE SCHEMA command, multi-byte delimiter support, and new parameters for filter selectivity estimates.
Drill 1.7 Released
Posted on Jun 28, 2016 by Bridget Bevens
Apache Drill 1.7's highlights are: Monitoring via JMX, Hive CHAR data type support, and HBase 1.x support.
Drill 1.6 Released
Posted on Mar 16, 2016 by Bridget Bevens
Apache Drill 1.6's highlights are: Inbound impersonation and additional custom window frames.
Drill 1.5 Released
Posted on Feb 16, 2016 by Jason Altekruse, Bridget Bevens
Apache Drill 1.5's highlights are: Authentication and security for the Web interface and REST API, experimental query support for Apache Kudu (incubating), an improved memory allocator, and configurable caching for Hive metadata.
Drill 1.4 Released
Posted on Dec 14, 2015 by Jacques Nadeau
Apache Drill 1.4's highlights are: "select with options" queries that can change storage plugin settings, improved behavior when parsing CSV file header names, a variable to set non-pretty (e.g. compact) printing of JSON, and better drillbit.log files that include query text.
Drill 1.3 Released
Posted on Nov 23, 2015 by Jacques Nadeau
Drill 1.3 has been released. Users can now query Hadoop sequence files and text delimited files with headers. In addition, this release provides significant performance and usability improvements for working with Amazon S3. Drill 1.3 also adds support for heterogeneous types, enabling queries on datasets with columns that have more than one data type (commonly seen in JSON files, MongoDB collections, etc.).
Drill 1.2 Released
Posted on Oct 16, 2015 by Jacques Nadeau
Drill 1.2 has been released. This release includes a new JDBC storage plugin for querying relational databases, as well as new window functions such as `NTILE`, `FIRST_VALUE`, `LAST_VALUE`, `LEAD` and `LAG`. This release addresses 210 JIRAs, including performance, stability and documentation enhancements.
Drill Tutorial at NoSQL Now! 2015
Posted on Jul 23, 2015 by Tomer Shiran
Attend the 3-hour Drill tutorial at the NoSQL Now! 2015 conference to learn more about Apache Drill.
Drill 1.1 Released
Posted on Jul 5, 2015 by Jacques Nadeau
Drill 1.1 has been released, providing window functions, automatic partitioning, improved MongoDB support and more. This release addresses 162 JIRAs.
The Apache Software Foundation Announces Apache Drill 1.0
Posted on May 19, 2015 by Tomer Shiran
The Apache Software Foundation announced today the availability of Apache Drill 1.0, the schema-free SQL query engine for Apache Hadoop, NoSQL and cloud storage.
Drill 1.0 Released
Posted on May 19, 2015 by Tomer Shiran, Jacques Nadeau
Drill 1.0 has been released, representing a major milestone for the Drill community. Drill in now production-ready, making it easier than ever to explore and analyze data in non-relational datastores.
Drill 0.9 Released
Posted on May 4, 2015 by Tomer Shiran, Jacques Nadeau
The community has just released Drill 0.9, which includes 199 resolved JIRAs and numerous enhancements.
Apache Parquet Graduates to a Top-Level Project
Posted on Apr 30, 2015 by Tomer Shiran
The Apache Parquet project has graduated to a top-level project (TLP) at the Apache Software Foundation.
Drill 0.8 Released
Posted on Mar 31, 2015 by Tomer Shiran, Jacques Nadeau
The community has just released Drill 0.8, which includes 243 resolved JIRAs and numerous enhancements.
MicroStrategy Announces Drill Support
Posted on Mar 23, 2015 by Tomer Shiran
MicroStrategy announced that it is now certified with Apache Drill, providing a first-class BI experience for Hadoop and NoSQL databases.
Schema-free JSON Data Infrastructure
Posted on Jan 27, 2015 by Tomer Shiran
JSON has emerged as the de-facto standard data exchange format. Data infrastructure technologies such as Apache Drill, MongoDB and Elasticsearch are embracing JSON as their native data models, bringing game-changing ease-of-use and agility to developers and analysts.
Drill 0.7 Released
Posted on Dec 23, 2014 by Jacques Nadeau
The community has just released Drill 0.7, which includes 228 resolved JIRAs and numerous enhancements.
What's Coming in 2015?
Posted on Dec 16, 2014 by Tomer Shiran
Drill is now a top-level project, and the community is expanding rapidly. Find out more about some of the new features planned for 2015.
Apache Drill Q&A Panelist Spotlight
Posted on Dec 11, 2014 by Tomer Shiran
Join us on Twitter for a live Q&A on Wednesday, December 17.
Apache Drill Graduates to a Top-Level Project
Posted on Dec 2, 2014 by Tomer Shiran
Drill has graduated to a Top-Level Project at Apache. This marks a significant accomplishment for the Drill community, which now includes dozens of developers working at a variety of companies.
SQL on MongoDB
Posted on Nov 19, 2014 by Anil Kumar Batchu, Kamesh Bhallamudi
The MongoDB storage plugin for Drill enables analytical queries on MongoDB databases. Drill's schema-free JSON data model is a natural fit for MongoDB's data model.