drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [1/3] drill git commit: 1.2 update
Date Sat, 17 Oct 2015 16:57:56 GMT
Repository: drill
Updated Branches:
  refs/heads/gh-pages 23445859d -> 450e2714b

1.2 update

Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/f83cda82
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/f83cda82
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/f83cda82

Branch: refs/heads/gh-pages
Commit: f83cda82affbde003fa7e66eb374881a2160cc44
Parents: 0c9fd5e
Author: Tomer Shiran <tshiran@gmail.com>
Authored: Sat Oct 17 09:54:14 2015 -0700
Committer: Tomer Shiran <tshiran@gmail.com>
Committed: Sat Oct 17 09:54:14 2015 -0700

 _data/version.json                           |  8 ++--
 blog/_posts/2015-10-16-drill-1.2-released.md | 46 +++++++++++++++++++++++
 2 files changed, 50 insertions(+), 4 deletions(-)

diff --git a/_data/version.json b/_data/version.json
index 9f01bfa..04ec6ea 100644
--- a/_data/version.json
+++ b/_data/version.json
@@ -1,7 +1,7 @@
-  "display_version": "1.1",
-  "full_version": "1.1.0",
-  "release_date": "July 5, 2015",
-  "blog_post": "/blog/2015/07/05/drill-1.1-released/",
+  "display_version": "1.2",
+  "full_version": "1.2.0",
+  "release_date": "October 16, 2015",
+  "blog_post": "/blog/2015/10/16/drill-1.2-released/",
   "release_notes": "https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12329689"

diff --git a/blog/_posts/2015-10-16-drill-1.2-released.md b/blog/_posts/2015-10-16-drill-1.2-released.md
new file mode 100644
index 0000000..e9bf263
--- /dev/null
+++ b/blog/_posts/2015-10-16-drill-1.2-released.md
@@ -0,0 +1,46 @@
+layout: post
+title: "Drill 1.2 Released"
+code: drill-1.2-released
+excerpt: 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.
+authors: ["jnadeau"]
+Today I'm happy to announce the availability of the Drill 1.2 release. This release addresses
[217 JIRAs](https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12332042&projectId=12313820)
on top of the 1.1 release. Highlights include:
+## Relational Database Support
+Drill now includes a JDBC storage plugin for querying relational databases (RDBMSs). Users
can run SQL queries that join data between non-relational datastores (eg, MongoDB, HBase,
HDFS, S3) and relational databases (eg, MySQL, Oracle). For example, a single query can join
log files in HDFS with a users table in MySQL. Drill automatically pushes execution (projections,
filters, partial joins, etc.) down into the RDBMS whenever possible.
+## New Window Functions
+The 1.2 release adds additional window functions: `NTILE`, `FIRST_VALUE`, `LAST_VALUE`, `LEAD`
and `LAG`. Drill now supports [15 different window functions](/docs/sql-window-functions-introduction/):
+  * Value Functions: `FIRST_VALUE`, `LAST_VALUE`, `LEAD`, `LAG`
+  * Aggregate Functions: `AVG`, `COUNT`, `MAX`, `MIN`, `SUM`
+  * Ranking Functions: `CUME_DIST`, `DENSE_RANK`, `NTILE`, `PERCENT_RANK`, `RANK`, `ROW_NUMBER`
+In addition to supporting new window functions, Drill 1.2 adds support for multiple window
functions in a single query. A query can contain multiple window functions that slice up the
data in different ways by means of different `OVER` clauses, but they all act on the same
collection of rows.
+## Parquet Metadata Caching
+When running a query against a directory tree with Parquet files, Drill scans the directory
and reads the footers of the files during the planning phase. This allows Drill to prune partitions
and optimize query execution for data locality. However, this process can be time consuming
for directory trees with thousands of files. Drill 1.2 includes [a new feature](/docs/optimizing-parquet-reading/)
that caches the metadata information so that subsequent queries don't need to scan all the
files. The cache is automatically maintained based on the directory timestamps.
+## Performance Improvements on HBase and Hive Tables
+Drill 1.2 introduces a faster read path for HBase and Hive tables. When querying Hive tables
backed by Parquet files, Drill now uses a high-performance Parquet reader rather than the
Hive SerDe.
+## `DROP TABLE` for Files and Directories
+Drill 1.2 allows users to drop file- and directory-based tables with a SQL command (`DROP
+## Enhanced MongoDB Integration
+Drill 1.2 supports extended JSON types, addressing previous issues with queries on MongoDB
+## Many More Fixes
+Drill 1.2 includes hundreds of [other fixes and enhancements](https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12332042&projectId=12313820).
+Download the [Drill 1.2 release](https://drill.apache.org/download/) now and let us know
your thoughts.
+Drill On!
+Jacques Nadeau

View raw message