You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/07/06 03:02:37 UTC
[1/3] drill git commit: New Drill 1.1 Release blog post
Repository: drill
Updated Branches:
refs/heads/gh-pages 1b5fb2ee9 -> 74cf0be06
New Drill 1.1 Release blog post
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/78b61c57
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/78b61c57
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/78b61c57
Branch: refs/heads/gh-pages
Commit: 78b61c577b78542722f777f4e9efe31fd699cd61
Parents: 1b5fb2e
Author: Jacques Nadeau <ja...@gmail.com>
Authored: Sun Jul 5 11:41:24 2015 -0700
Committer: Jacques Nadeau <ja...@gmail.com>
Committed: Sun Jul 5 11:41:24 2015 -0700
----------------------------------------------------------------------
blog/_posts/2015-07-05-drill-1.1-released.md | 62 +++++++++++++++++++++++
1 file changed, 62 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/78b61c57/blog/_posts/2015-07-05-drill-1.1-released.md
----------------------------------------------------------------------
diff --git a/blog/_posts/2015-07-05-drill-1.1-released.md b/blog/_posts/2015-07-05-drill-1.1-released.md
new file mode 100644
index 0000000..9ba95a7
--- /dev/null
+++ b/blog/_posts/2015-07-05-drill-1.1-released.md
@@ -0,0 +1,62 @@
+---
+layout: post
+title: "Drill 1.1 Released"
+code: drill-1.1-released
+excerpt: Drill 1.1 has been released, providing even more world class SQL capabilities, better support for querying a wide variety of non-relational datastores and a number of exciting new features.
+authors: ["jnadeau"]
+---
+
+Today I'm happy to announce the availability of the Drill 1.1 release. This release addresses [162 JIRAs](https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12329689) on top of May's 1.0 release. Highlights include:
+
+#### Automatic Partitioning for Parquet files
+Drill now supports creating partitions automatically when using CREATE TABLE AS (CTAS) to generate Parquet files. By leveraging the unique capabilities of the Parquet file format, Drill is able provide this capability and still maintain data integrity and compatibility with all other systems that consume Parquet (a world first). This functionality can be exercised by utilizing the new [PARTITION BY](https://drill.apache.org/docs/partition-by-clause/) clause support.
+
+#### Support for Window Functions
+Drill now has first-class support for SQL Window Functions. This includes support for:
+
+ * Aggregate Functions: AVG, COUNT, MAX, MIN, SUM
+ * Ranking Functions: CUME_DIST, DENSE_RANK, PERCENT_RANK, RANK and ROW_NUMBER
+
+The community has done an excellent job providing a [comprehensive set of documentation](https://drill.apache.org/docs/sql-window-functions-introduction/) so that you can starting using window functions immediately.
+
+#### Hive Storage Plugin Enhancements
+We've enhanced Drill to work even better with Hive. We started by upgrading Drill's support to work with Hive 1.0. In addition, Drill now provides a very powerful new security feature called [delegated Hive impersonation](https://drill.apache.org/docs/configuring-user-impersonation-with-hive-authorization/). Compatibility and performance are also improved with better data type support (including support for binary, tinyint and smallint data types) and better concurrency.
+
+#### SQL Union Improvements
+We've enhanced support for SQL UNION functionality. Drill now supports both UNION and UNION ALL capabilities. We've also improved the query optimizer to better optimize plans that include the UNION clause.
+
+#### New Features For Complex Data
+Drill's complex data capabilities continue to be the best in the market, now including support for COUNT aggregations on various types of complex objects. Drill also now has improved FLATTEN capabilities to support very large complex objects.
+
+#### Improved JDBC Driver Compatibility
+Apache Drill's JDBC driver continues to be improved. This includes a number of enhancements and fixes to better support JDBC tools including [MicroStrategy](https://drill.apache.org/docs/using-microstrategy-analytics-with-apache-drill/), [Tibco Spotfire](https://drill.apache.org/docs/using-tibco-spotfire-desktop-with-drill/), [JReport](https://drill.apache.org/docs/configuring-jreport-with-drill/) and [SQuirreL](https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/).
+
+The Apache Drill community now publishes the JDBC driver for easy inclusion in your personal application through the use of Maven coordinates. You can incorporate Drill's JDBC driver into your application by [downloading it directly](http://search.maven.org/remotecontent?filepath=org/apache/drill/exec/drill-jdbc-all/1.1.0/drill-jdbc-all-1.1.0.jar) or referencing the following coordinates within your Maven application.
+
+ <dependency>
+ <groupId>org.apache.drill.exec</groupId>
+ <artifactId>drill-jdbc-all</artifactId>
+ <version>1.1.0</version>
+ </dependency>
+
+
+#### MongoDB 3.0 Support
+Drill's support for MongoDB has been improved. Drill now uses MongoDB's latest Java Driver and has enhanced connection pooling for better performance and resilience in large-scale deployments. Learn more on using the [MongoDB for Drill plugin](https://drill.apache.org/docs/mongodb-plugin-for-apache-drill/).
+
+#### Many More Fixes
+Drill include a number of other smaller fixes and enhancements for a [number of things](https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12329689) including:
+
+ * improvements for certain types of exists and correlated subqueries
+ * fixes for running Drill on Windows
+ * improvements in implicit casting capabilities in schemaless scenarios
+ * improvements in INFORMATION_SCHEMA
+ * Fixes for both the WebUI and the Drill REST API
+
+
+#### More Frequent Releases
+The amazing Drill community continues to be the driving force behind these rapid iterative releases. Thanks to all the [committers]({{ site.baseurl }}/team/) and contributors that made this release possible! The community's goal continues to be maintaining a 4-6 release cycle throughout the summer. This means you will have many more enhancements to look for in the next few months. If you use Drill, want to, or want to help develop it, drop by in [the community](https://drill.apache.org/mailinglists/).
+
+Download the [Drill 1.1.0 release](https://drill.apache.org/download/) now and let us know your thoughts.
+
+Drill On!
+Jacques Nadeau
[2/3] drill git commit: Merge pull request #2 from jacques-n/patch-1
Posted by ts...@apache.org.
Merge pull request #2 from jacques-n/patch-1
Add release 1.1 post
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/5c02ddff
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/5c02ddff
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/5c02ddff
Branch: refs/heads/gh-pages
Commit: 5c02ddfff727300f10bf8bee293e16f0c5828ad9
Parents: d476ce5 78b61c5
Author: Tomer Shiran <ts...@gmail.com>
Authored: Sun Jul 5 17:31:12 2015 -0700
Committer: Tomer Shiran <ts...@gmail.com>
Committed: Sun Jul 5 17:31:12 2015 -0700
----------------------------------------------------------------------
_data/docs.json | 1022 ++++++++++++++----
_docs/110-troubleshooting.md | 237 ++--
_docs/archived-pages/030-partition-pruning.md | 75 --
.../010-configure-drill-introduction.md | 24 +-
.../020-configuring-drill-memory.md | 2 +
...ser-impersonation-with-hive-authorization.md | 254 +++++
.../configure-drill/100-ports-used-by-drill.md | 14 +-
.../120-configuring-the-drill-shell.md | 10 +-
.../010-configuration-options-introduction.md | 6 +-
.../020-start-up-options.md | 16 +-
.../040-persistent-configuration-storage.md | 22 +-
.../020-storage-plugin-registration.md | 2 +
.../035-plugin-configuration-basics.md | 9 +-
.../040-file-system-storage-plugin.md | 4 +-
_docs/connect-a-data-source/050-workspaces.md | 21 +-
.../070-hive-storage-plugin.md | 6 +-
.../connect-a-data-source/100-mapr-db-format.md | 2 +-
.../040-parquet-format.md | 2 +-
.../060-text-files-csv-tsv-psv.md | 89 ++
.../020-develop-a-simple-function.md | 2 +-
.../030-developing-an-aggregate-function.md | 2 +-
.../010-compiling-drill-from-source.md | 9 +-
.../020-drill-patch-review-tool.md | 2 +-
_docs/getting-started/010-drill-introduction.md | 8 +
_docs/img/18.png | Bin 18137 -> 65920 bytes
.../030-starting-drill-on-linux-and-mac-os-x.md | 2 +
.../050-starting-drill-on-windows.md | 2 +
.../odbc-jdbc-interfaces/015-using-jdbc-driver | 100 --
.../015-using-jdbc-driver.md | 2 +-
.../020-configuring-odbc-on-linux.md | 6 +-
.../040-testing-the-odbc-connection.md | 34 +-
.../030-browsing-data-and-creating-views.md | 19 +-
...0-using-tibco-spotfire-desktop-with-drill.md | 48 +
.../040-using-tibco-spotfire-with-drill.md | 50 -
.../050-configuring-spotfire-server.md | 123 ++-
...using-apache-drill-with-tableau-9-desktop.md | 19 +-
...-using-apache-drill-with-tableau-9-server.md | 8 +-
.../performance-tuning/020-partition-pruning.md | 31 +-
_docs/query-data/010-query-data-introduction.md | 38 +-
.../020-querying-parquet-files.md | 2 +-
.../040-querying-directories.md | 3 +-
.../010-sample--data-donuts.md | 2 +-
_docs/rn/070-0.9.0-rn.md | 29 +
_docs/sql-reference/055-sql-window-functions.md | 4 +
.../065-query-directory-functions.md | 2 +-
_docs/sql-reference/090-sql-extensions.md | 2 +-
.../data-types/010-supported-data-types.md | 2 +-
.../data-types/020-date-time-and-timestamp.md | 4 +-
.../sql-commands/005-supported-sql-commands.md | 18 +-
.../sql-commands/010-alter-session.md | 2 +-
.../sql-commands/020-alter-system.md | 2 +-
.../sql-commands/030-create-table-as.md | 75 +-
.../sql-commands/035-partition-by-clause.md | 171 +++
.../sql-commands/050-create-view.md | 6 +-
.../sql-commands/080-select-list.md | 2 +-
.../sql-commands/081-from-clause.md | 32 +-
.../sql-commands/087-union-set-operator.md | 11 +-
.../sql-commands/089-with-clause.md | 12 +-
.../sql-functions/020-data-type-conversion.md | 2 +-
.../030-date-time-functions-and-arithmetic.md | 74 +-
.../010-sql-window-functions-introduction.md | 186 ++++
.../020-aggregate-window-functions.md | 184 ++++
.../030-ranking-window-functions.md | 150 +++
.../040-sql-window-functions-examples.md | 92 ++
_docs/tutorials/010-tutorials-introduction.md | 2 +-
.../030-analyzing-the-yelp-academic-dataset.md | 2 +-
blog/_posts/2015-07-05-drill-1.1-released.md | 62 ++
67 files changed, 2705 insertions(+), 752 deletions(-)
----------------------------------------------------------------------
[3/3] drill git commit: Updated download links and blog post
Posted by ts...@apache.org.
Updated download links and blog post
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/74cf0be0
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/74cf0be0
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/74cf0be0
Branch: refs/heads/gh-pages
Commit: 74cf0be06d00c82202daedceb395d74879cd01b6
Parents: 5c02ddf
Author: Tomer Shiran <ts...@gmail.com>
Authored: Sun Jul 5 18:03:21 2015 -0700
Committer: Tomer Shiran <ts...@gmail.com>
Committed: Sun Jul 5 18:03:21 2015 -0700
----------------------------------------------------------------------
_data/version.json | 6 +--
blog/_posts/2015-07-05-drill-1.1-released.md | 50 +++++++++++------------
2 files changed, 27 insertions(+), 29 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/74cf0be0/_data/version.json
----------------------------------------------------------------------
diff --git a/_data/version.json b/_data/version.json
index d923285..c369ac9 100644
--- a/_data/version.json
+++ b/_data/version.json
@@ -1,5 +1,5 @@
{
- "display_version": "1.0",
- "full_version": "1.0.0",
- "release_date": "May 19, 2015"
+ "display_version": "1.1",
+ "full_version": "1.1.0",
+ "release_date": "July 5, 2015"
}
http://git-wip-us.apache.org/repos/asf/drill/blob/74cf0be0/blog/_posts/2015-07-05-drill-1.1-released.md
----------------------------------------------------------------------
diff --git a/blog/_posts/2015-07-05-drill-1.1-released.md b/blog/_posts/2015-07-05-drill-1.1-released.md
index 9ba95a7..1013495 100644
--- a/blog/_posts/2015-07-05-drill-1.1-released.md
+++ b/blog/_posts/2015-07-05-drill-1.1-released.md
@@ -2,36 +2,35 @@
layout: post
title: "Drill 1.1 Released"
code: drill-1.1-released
-excerpt: Drill 1.1 has been released, providing even more world class SQL capabilities, better support for querying a wide variety of non-relational datastores and a number of exciting new features.
+excerpt: Drill 1.1 has been released, providing window functions, automatic partitioning, improved MongoDB support and more. This release addresses 162 JIRAs.
authors: ["jnadeau"]
---
-
Today I'm happy to announce the availability of the Drill 1.1 release. This release addresses [162 JIRAs](https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12329689) on top of May's 1.0 release. Highlights include:
-#### Automatic Partitioning for Parquet files
-Drill now supports creating partitions automatically when using CREATE TABLE AS (CTAS) to generate Parquet files. By leveraging the unique capabilities of the Parquet file format, Drill is able provide this capability and still maintain data integrity and compatibility with all other systems that consume Parquet (a world first). This functionality can be exercised by utilizing the new [PARTITION BY](https://drill.apache.org/docs/partition-by-clause/) clause support.
+#### Automatic Partitioning for Parquet Files
+Drill now supports creating partitions automatically when using `CREATE TABLE AS` (CTAS) to generate Parquet files. By leveraging the unique capabilities of the Parquet file format, Drill is able provide this capability and still maintain data integrity and compatibility with all other systems that consume Parquet (a world's first). This functionality can be exercised by utilizing the new [`PARTITION BY`](https://drill.apache.org/docs/partition-by-clause/) clause support.
+
+#### Window Functions
+Drill now has first-class support for SQL window Functions. This includes:
-#### Support for Window Functions
-Drill now has first-class support for SQL Window Functions. This includes support for:
+ * Aggregate Functions: `AVG`, `COUNT`, `MAX`, `MIN`, `SUM`
+ * Ranking Functions: `CUME_DIST`, `DENSE_RANK`, `PERCENT_RANK`, `RANK` and `ROW_NUMBER`
- * Aggregate Functions: AVG, COUNT, MAX, MIN, SUM
- * Ranking Functions: CUME_DIST, DENSE_RANK, PERCENT_RANK, RANK and ROW_NUMBER
-
-The community has done an excellent job providing a [comprehensive set of documentation](https://drill.apache.org/docs/sql-window-functions-introduction/) so that you can starting using window functions immediately.
+The community has done an excellent job providing a [comprehensive documentation](https://drill.apache.org/docs/sql-window-functions-introduction/) so that you can start using window functions immediately.
#### Hive Storage Plugin Enhancements
-We've enhanced Drill to work even better with Hive. We started by upgrading Drill's support to work with Hive 1.0. In addition, Drill now provides a very powerful new security feature called [delegated Hive impersonation](https://drill.apache.org/docs/configuring-user-impersonation-with-hive-authorization/). Compatibility and performance are also improved with better data type support (including support for binary, tinyint and smallint data types) and better concurrency.
+We've enhanced Drill to work even better with Hive. We started by upgrading Drill's support to work with Hive 1.0. In addition, Drill now provides a powerful new security feature called [delegated Hive impersonation](https://drill.apache.org/docs/configuring-user-impersonation-with-hive-authorization/). Compatibility and performance are also improved with better data type support (including support for binary, tinyint and smallint data types) and better concurrency.
-#### SQL Union Improvements
-We've enhanced support for SQL UNION functionality. Drill now supports both UNION and UNION ALL capabilities. We've also improved the query optimizer to better optimize plans that include the UNION clause.
+#### SQL `UNION` Improvements
+We've enhanced support for SQL `UNION` functionality. Drill now supports both `UNION` and `UNION ALL` capabilities. We've also improved the query optimizer to better optimize plans that include the `UNION` clause.
#### New Features For Complex Data
-Drill's complex data capabilities continue to be the best in the market, now including support for COUNT aggregations on various types of complex objects. Drill also now has improved FLATTEN capabilities to support very large complex objects.
+Drill's complex data capabilities continue to be the best in the market, now including support for `COUNT` aggregations on various types of complex objects. Also, Drill's `FLATTEN` function now supports very large complex objects.
#### Improved JDBC Driver Compatibility
-Apache Drill's JDBC driver continues to be improved. This includes a number of enhancements and fixes to better support JDBC tools including [MicroStrategy](https://drill.apache.org/docs/using-microstrategy-analytics-with-apache-drill/), [Tibco Spotfire](https://drill.apache.org/docs/using-tibco-spotfire-desktop-with-drill/), [JReport](https://drill.apache.org/docs/configuring-jreport-with-drill/) and [SQuirreL](https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/).
+Apache Drill's JDBC driver continues to improve. This includes a number of enhancements and fixes to better support JDBC tools including [MicroStrategy](https://drill.apache.org/docs/using-microstrategy-analytics-with-apache-drill/), [TIBCO Spotfire](https://drill.apache.org/docs/using-tibco-spotfire-desktop-with-drill/), [JReport](https://drill.apache.org/docs/configuring-jreport-with-drill/) and [SQuirreL](https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/).
-The Apache Drill community now publishes the JDBC driver for easy inclusion in your personal application through the use of Maven coordinates. You can incorporate Drill's JDBC driver into your application by [downloading it directly](http://search.maven.org/remotecontent?filepath=org/apache/drill/exec/drill-jdbc-all/1.1.0/drill-jdbc-all-1.1.0.jar) or referencing the following coordinates within your Maven application.
+The Apache Drill community now publishes the JDBC driver for easy inclusion in your application through the use of Maven coordinates. You can incorporate Drill's JDBC driver into your application by [downloading it directly](http://search.maven.org/remotecontent?filepath=org/apache/drill/exec/drill-jdbc-all/1.1.0/drill-jdbc-all-1.1.0.jar) or referencing the following coordinates within your Maven application.
<dependency>
<groupId>org.apache.drill.exec</groupId>
@@ -41,22 +40,21 @@ The Apache Drill community now publishes the JDBC driver for easy inclusion in y
#### MongoDB 3.0 Support
-Drill's support for MongoDB has been improved. Drill now uses MongoDB's latest Java Driver and has enhanced connection pooling for better performance and resilience in large-scale deployments. Learn more on using the [MongoDB for Drill plugin](https://drill.apache.org/docs/mongodb-plugin-for-apache-drill/).
+Drill now uses MongoDB's latest Java driver and has enhanced connection pooling for better performance and resilience in large-scale deployments. Learn more about using the [MongoDB plugin](https://drill.apache.org/docs/mongodb-plugin-for-apache-drill/).
#### Many More Fixes
-Drill include a number of other smaller fixes and enhancements for a [number of things](https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12329689) including:
-
- * improvements for certain types of exists and correlated subqueries
- * fixes for running Drill on Windows
- * improvements in implicit casting capabilities in schemaless scenarios
- * improvements in INFORMATION_SCHEMA
- * Fixes for both the WebUI and the Drill REST API
+Drill includes a variety of [other fixes and enhancements](https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12329689) including:
+ * Improvements for certain types of exists and correlated subqueries
+ * Fixes for running Drill on Windows
+ * Improvements in implicit casting capabilities in schemaless scenarios
+ * Improvements in `INFORMATION_SCHEMA`
+ * Fixes for the Web UI and the REST API
#### More Frequent Releases
The amazing Drill community continues to be the driving force behind these rapid iterative releases. Thanks to all the [committers]({{ site.baseurl }}/team/) and contributors that made this release possible! The community's goal continues to be maintaining a 4-6 release cycle throughout the summer. This means you will have many more enhancements to look for in the next few months. If you use Drill, want to, or want to help develop it, drop by in [the community](https://drill.apache.org/mailinglists/).
Download the [Drill 1.1.0 release](https://drill.apache.org/download/) now and let us know your thoughts.
-Drill On!
-Jacques Nadeau
+Drill On!
+Jacques Nadeau
\ No newline at end of file