drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [drill] branch gh-pages updated: updates for Drill 1.16 release
Date Thu, 02 May 2019 16:08:24 GMT
This is an automated email from the ASF dual-hosted git repository.

bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git


The following commit(s) were added to refs/heads/gh-pages by this push:
     new ad4a960  updates for Drill 1.16 release
ad4a960 is described below

commit ad4a96074307fb067e5292bb1d9359596f7081eb
Author: Bridget Bevens <bbevens@maprtech.com>
AuthorDate: Thu May 2 09:07:41 2019 -0700

    updates for Drill 1.16 release
---
 _data/version.json                                 |  10 +-
 .../120-configuring-the-drill-shell.md             |   1 +
 .../install/047-installing-drill-on-the-cluster.md |   8 +-
 .../011-running-drill-on-docker.md                 |  10 +-
 .../020-installing-drill-on-linux-and-mac-os-x.md  |   8 +-
 .../040-installing-drill-on-windows.md             |   4 +-
 _docs/rn/005-1.16.0-rn.md                          | 499 +++++++++++++++++++++
 _docs/rn/{001-1.15.0-rn.md => 006-1.15.0-rn.md}    |   0
 _docs/rn/{002-1.14.0-rn.md => 007-1.14.0-rn.md}    |   0
 _docs/rn/{003-1.13.0-rn.md => 008-1.13.0-rn.md}    |   0
 .../sql-commands/009-analyze-table.md              |   2 +-
 _docs/tutorials/020-drill-in-10-minutes.md         |   8 +-
 .../050-analyzing-highly-dynamic-datasets.md       |   4 +-
 blog/_posts/2019-05-02-drill-1.16-released.md      |  32 ++
 14 files changed, 559 insertions(+), 27 deletions(-)

diff --git a/_data/version.json b/_data/version.json
index 30f2977..df55191 100644
--- a/_data/version.json
+++ b/_data/version.json
@@ -1,7 +1,7 @@
 {
-  "display_version": "1.15",
-  "full_version": "1.15.0",
-  "release_date": "December 31, 2018",
-  "blog_post":"/blog/2018/12/31/drill-1.15-released",
-  "release_notes": "https://drill.apache.org/docs/apache-drill-1-15-0-release-notes/"
+  "display_version": "1.16",
+  "full_version": "1.16.0",
+  "release_date": "May 02, 2018",
+  "blog_post":"/blog/2019/05/02/drill-1.16-released",
+  "release_notes": "https://drill.apache.org/docs/apache-drill-1-16-0-release-notes/"
 }
diff --git a/_docs/configure-drill/120-configuring-the-drill-shell.md b/_docs/configure-drill/120-configuring-the-drill-shell.md
index c3c60d6..900e8fe 100644
--- a/_docs/configure-drill/120-configuring-the-drill-shell.md
+++ b/_docs/configure-drill/120-configuring-the-drill-shell.md
@@ -6,6 +6,7 @@ parent: "Configure Drill"
 Drill uses SQLLine as the Drill shell. SQLLine is a pure-Java console-based utility for connecting to relational databases and running SQL commands. 
 
 Starting in Drill 1.16, Drill uses SQLLine 1.7. This upgrade changes the default Drill prompt to `apache drill>`. If you switch to a specific schema, for example `dfs.tmp`, the prompt includes the current schema, as shown:  
+  
 	use dfs.tmp;
 	+------+-------------------------------------+
 	|  ok  |               summary               |
diff --git a/_docs/install/047-installing-drill-on-the-cluster.md b/_docs/install/047-installing-drill-on-the-cluster.md
index 1290673..d367317 100644
--- a/_docs/install/047-installing-drill-on-the-cluster.md
+++ b/_docs/install/047-installing-drill-on-the-cluster.md
@@ -1,13 +1,13 @@
 ---
 title: "Installing Drill on the Cluster"
-date: 2018-12-30
+date: 2019-05-02
 parent: "Installing Drill in Distributed Mode"
 ---
 You install Drill on nodes in the cluster, configure a cluster ID, and add Zookeeper information, as described in the following steps:
 
-  1. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz) with the command appropriate for your system:  
-       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz`  
-       * `curl -o apache-drill-1.15.0.tar.gz http://apache.mirrors.hoobly.com/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz`  
+  1. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz) with the command appropriate for your system:  
+       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz`  
+       * `curl -o apache-drill-1.16.0.tar.gz http://apache.mirrors.hoobly.com/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz`  
   2. Extract the tarball to the directory of your choice, such as `/opt`:  
   `tar -xzvf apache-drill-<version>.tar.gz`
   3. In `drill-override.conf,` use the Drill `cluster ID`, and provide ZooKeeper host names and port numbers to configure a connection to your ZooKeeper quorum.  
diff --git a/_docs/install/installing-drill-in-embedded-mode/011-running-drill-on-docker.md b/_docs/install/installing-drill-in-embedded-mode/011-running-drill-on-docker.md
index d6e6cbc..471999d 100644
--- a/_docs/install/installing-drill-in-embedded-mode/011-running-drill-on-docker.md
+++ b/_docs/install/installing-drill-in-embedded-mode/011-running-drill-on-docker.md
@@ -1,6 +1,6 @@
 ---
 title: "Running Drill on Docker"
-date: 2018-12-30
+date: 2019-05-02
 parent: "Installing Drill in Embedded Mode"
 ---  
 
@@ -30,14 +30,14 @@ The following table describes the options:
 | `-t`                           | Allocates a pseudo-tty (a shell).                                                                                                                                                                                                                                                                                        |
 | `--name`                       | Identifies the container. If you do not use this   option to identify a name for the container, the daemon generates a container ID for you. When you use this option to identify a container name,   you can use the name to reference the container within a Docker network in   foreground or detached mode.  |
 | `-p`                           | The TCP port for the Drill Web UI. If needed, you can   change this port using the `drill.exec.http.port` [start-up option]({{site.baseurl}}/docs/start-up-options/).                                                                                                                                                                                                 |
-| `drill/apache-drill:<version>` | The Docker Hub repository and tag. In the following   example, `drill/apache-drill` is   the repository and `1.15.0`   is the tag:     `drill/apache-drill:1.15.0`     The tag correlates with the version of Drill. When a new version of Drill   is available, you can use the new version as the tag.                           |
+| `drill/apache-drill:<version>` | The Docker Hub repository and tag. In the following   example, `drill/apache-drill` is   the repository and `1.15.0`   is the tag:     `drill/apache-drill:1.16.0`     The tag correlates with the version of Drill. When a new version of Drill   is available, you can use the new version as the tag.                           |
 | `bin/bash`                     | Connects to the Drill container using a bash shell.                                                                                                                                                                                                                                                      |  
 
 ### Running the Drill Docker Container in Foreground Mode  
 
 Open a terminal window (Command Prompt or PowerShell, but not PowerShell ISE) and then issue the following command and opitons to connect to SQLLine (the Drill shell):   
 
-       docker run -i --name drill-1.15.0 -p 8047:8047 -t drill/apache-drill:1.15.0 /bin/bash  
+       docker run -i --name drill-1.16.0 -p 8047:8047 -t drill/apache-drill:1.16.0 /bin/bash  
 
 When you issue the docker run command, the Drill process starts in a container. SQLLine prints a message, and the prompt appears:  
 
@@ -57,10 +57,10 @@ Open a terminal window (Command Prompt or PowerShell, but not PowerShell ISE) an
 
 **Note:** When you run the Drill Docker container in Detached mode, you connect to SQLLine (the Drill shell) using drill-localhost.  
 
-       $ docker run -i --name drill-1.15.0 -p 8047:8047 --detach -t drill/apache-drill:1.15.0 /bin/bash
+       $ docker run -i --name drill-1.16.0 -p 8047:8047 --detach -t drill/apache-drill:1.16.0 /bin/bash
        <displays container ID>
 
-       $ docker exec -it drill-1.15.0 bash
+       $ docker exec -it drill-1.16.0 bash
        <connects to container>
 
        $ /opt/drill/bin/drill-localhost  
diff --git a/_docs/install/installing-drill-in-embedded-mode/020-installing-drill-on-linux-and-mac-os-x.md b/_docs/install/installing-drill-in-embedded-mode/020-installing-drill-on-linux-and-mac-os-x.md
index b9ffccb..46cebae 100644
--- a/_docs/install/installing-drill-in-embedded-mode/020-installing-drill-on-linux-and-mac-os-x.md
+++ b/_docs/install/installing-drill-in-embedded-mode/020-installing-drill-on-linux-and-mac-os-x.md
@@ -1,6 +1,6 @@
 ---
 title: "Installing Drill on Linux and Mac OS X"
-date: 2018-12-30
+date: 2019-05-02
 parent: "Installing Drill in Embedded Mode"
 ---
 First, check that you [meet the prerequisites]({{site.baseurl}}/docs/embedded-mode-prerequisites), and then install Apache Drill on Linux or Mac OS X:
@@ -8,9 +8,9 @@ First, check that you [meet the prerequisites]({{site.baseurl}}/docs/embedded-mo
 Complete the following steps to install Drill:  
 
 1. In a terminal window, change to the directory where you want to install Drill.  
-2. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz) with the command appropriate for your system:  
-       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz`  
-       * `curl -o apache-drill-1.15.0.tar.gz http://www.apache.org/dyn/closer.cgi/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz`  
+2. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz) with the command appropriate for your system:  
+       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz`  
+       * `curl -o apache-drill-1.16.0.tar.gz http://www.apache.org/dyn/closer.cgi/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz`  
 3. Copy the downloaded file to the directory where you want to install Drill.  
 4. Extract the contents of the Drill `.tar.gz` file. Use sudo only if necessary:  
 `tar -xvzf <.tar.gz file name>`  
diff --git a/_docs/install/installing-drill-in-embedded-mode/040-installing-drill-on-windows.md b/_docs/install/installing-drill-in-embedded-mode/040-installing-drill-on-windows.md
index 6ba365e..e979db6 100644
--- a/_docs/install/installing-drill-in-embedded-mode/040-installing-drill-on-windows.md
+++ b/_docs/install/installing-drill-in-embedded-mode/040-installing-drill-on-windows.md
@@ -1,6 +1,6 @@
 ---
 title: "Installing Drill on Windows"
-date: 2019-04-10
+date: 2019-05-02
 parent: "Installing Drill in Embedded Mode"
 ---
 
@@ -49,7 +49,7 @@ You, or the user that will start Drill, must manually create and own UDF directo
 
 ## Download and Install Drill 
 
-1. Download the latest version of Apache Drill [here](http://www-us.apache.org/dist/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz).
+1. Download the latest version of Apache Drill [here](http://www-us.apache.org/dist/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz).
 2. Move the downloaded file to the directory where you want to install Drill.
 3. Unzip the GZ file using a third-party tool. If the tool you use does not unzip the underlying TAR file as well as the GZ file, perform a second unzip to extract the Drill software. The extraction process creates the installation directory containing the Drill software.  
 4. [Start Drill]({{site.baseurl}}/docs/starting-drill-on-windows). 
diff --git a/_docs/rn/005-1.16.0-rn.md b/_docs/rn/005-1.16.0-rn.md
new file mode 100644
index 0000000..3e19f55
--- /dev/null
+++ b/_docs/rn/005-1.16.0-rn.md
@@ -0,0 +1,499 @@
+---
+title: "Apache Drill 1.16.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:**  May 2, 2019
+
+Today, we're happy to announce the availability of Drill 1.16.0. You can download it [here](https://drill.apache.org/download/).
+
+## New Features and Improvements  
+
+This release of Drill provides the following new features and improvements:  
+
+
+- [ANALYZE TABLE statement]({{site.baseurl}}/docs/analyze-table/) to computes statistics on Parquet data   
+- [CREATE OR REPLACE SCHEMA command]({{site.baseurl}}/docs/create-or-replace-schema/) to define a schema for text files   
+- [REFRESH TABLE METADATA command]({{site.baseurl}}/docs/refresh-table-metadata/) can generate metadata cache files for specific columns  
+- [SYSLOG (RFC-5424) Format Plugin]({{site.baseurl}}/docs/syslog-format-plugin/)  
+- [NEAREST DATE function]({{site.baseurl}}/docs/date-time-functions-and-arithmetic/#nearestdate) to facilitate time series analysis
+- [Format plugin for LTSV files]({{site.baseurl}}/docs/ltsv-format-plugin/)  
+- Ability to query Hive views, like querying Hive tables in a hive schema, for example `SELECT * FROM hive.`hive_view`;
+- [Upgrade to SQLLine 1.7]({{site.baseurl}}/docs/configuring-the-drill-shell/) changes the default prompt to `apache drill (schema_name)>` or you can define a custom prompt using the command `!set prompt <new-prompt>`. ([DRILL-6989](https://issues.apache.org/jira/browse/DRILL-6989)) 
+- Calcite updated to version 1.18.0 ([DRILL-6862](https://issues.apache.org/jira/browse/DRILL-6862))    
+- Several Drill Web UI improvements, including:
+	- [Storage plugin management improvements](https://drill.apache.org/docs/configuring-storage-plugins/#exporting-storage-plugin-configurations) ([DRILL-6562](https://issues.apache.org/jira/browse/DRILL-6562))  
+	- [Query progress indicators and warnings ]({{site.baseurl}}/docs/query-profiles/#query-profile-warnings) ([DRILL-6879](https://issues.apache.org/jira/browse/DRILL-6879))
+	- Ability to [limit the result size for better UI response]({{site.baseurl}}/docs/planning-and-execution-options/#setting-an-auto-limit-on-the-number-of-rows-returned-for-result-sets) ([DRILL-6050](https://issues.apache.org/jira/browse/DRILL-6050))  
+	- Ability to [sort the list of profiles in the Drill Web UI]({{site.baseurl}}/docs/query-profiles/#viewing-a-query-profile) ([DRILL-6942](https://issues.apache.org/jira/browse/DRILL-6942)) 
+	- [Display query state in query result page]({{site.baseurl}}/docs/starting-the-web-ui/#running-queries-from-the-web-ui) ([DRILL-6939](https://issues.apache.org/jira/browse/DRILL-6939))  
+	- [Button to reset the options filter](https://drill.apache.org/docs/planning-and-execution-options/#setting-options-from-the-drill-web-ui) ([DRILL-6921](https://issues.apache.org/jira/browse/DRILL-6921))  
+	
+The following sections provide a complete list of all the fixes and improvements in Drill 1.16.0:   
+
+<h2>        Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6780'>DRILL-6780</a>] -         Caching Dependencies
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6846'>DRILL-6846</a>] -         Store test results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6852'>DRILL-6852</a>] -         Adapt current Parquet Metadata cache implementation to use Drill Metastore API
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6964'>DRILL-6964</a>] -         Implement CREATE / DROP TABLE SCHEMA commands
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7058'>DRILL-7058</a>] -         Refresh command to support subset of columns
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7063'>DRILL-7063</a>] -         Create separate summary file for schema, totalRowCount, totalNullCount (includes maintenance)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7064'>DRILL-7064</a>] -         Leverage the summary&#39;s totalRowCount and totalNullCount for COUNT() queries (also prevent eager expansion of files)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7065'>DRILL-7065</a>] -         Ensure backward compatibility is maintained 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7066'>DRILL-7066</a>] -         Auto-refresh should pick up existing columns from metadata cache
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7068'>DRILL-7068</a>] -         Support memory adjustment framework for resource management with Queues
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7073'>DRILL-7073</a>] -         CREATE SCHEMA command / TupleSchema / ColumnMetadata improvements
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7089'>DRILL-7089</a>] -         Implement caching of BaseMetadata classes
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7092'>DRILL-7092</a>] -         Rename map to struct in schema definition
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7095'>DRILL-7095</a>] -         Expose Tuple Metadata to the physical operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7116'>DRILL-7116</a>] -         Adapt statistics to use Drill Metastore API
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7117'>DRILL-7117</a>] -         Support creation of histograms for numeric data types (except Decimal) and date/time/timestamp
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7119'>DRILL-7119</a>] -         Modify selectivity calculations to use histograms for supported data types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7138'>DRILL-7138</a>] -         Implement command to describe schema for table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7157'>DRILL-7157</a>] -         Wrap SchemaParsingException into UserException when creating schema
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7159'>DRILL-7159</a>] -         After renaming MAP to STRUCT typeString method still outputs MAP name
+</li>
+</ul>
+        
+<h2>        Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-407'>DRILL-407</a>] -         JSON max number value returns INFINITY in drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-808'>DRILL-808</a>] -         Sqlline use schema does not change the displayed schema
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1243'>DRILL-1243</a>] -         Drill&#39;s error message not clear when it fails reading json files containing arrays of hetrogeneous types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2326'>DRILL-2326</a>] -         Scalar replacement fails in TestConvertFunctions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3090'>DRILL-3090</a>] -         sqlline : save SQL to script file and replay from script, results in error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3846'>DRILL-3846</a>] -         Metadata Caching : A count(*) query took more time with the cache in place
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4211'>DRILL-4211</a>] -         Column aliases not pushed down to JDBC stores in some cases when Drill expects aliased columns to be returned.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4312'>DRILL-4312</a>] -         JDBC PlugIN - MySQL Causes errors in Drill INFORMATION_SCHEMA
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4374'>DRILL-4374</a>] -         Drill rewrites Postgres query with ambiguous column references
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4395'>DRILL-4395</a>] -         equi-inner join of two tables in Postgres returns null one of the projected columns
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4400'>DRILL-4400</a>] -         Cannot apply &#39;NOT&#39; to arguments of type &#39;NOT&lt;CHAR(2)&gt;&#39;.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4403'>DRILL-4403</a>] -          AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4407'>DRILL-4407</a>] -         Group by subquery causes Java NPE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4408'>DRILL-4408</a>] -         re-written query projecting an aggregate on a boolean not supported by Postgres
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4436'>DRILL-4436</a>] -         Result data gets mixed up when various tables have a column &quot;label&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4677'>DRILL-4677</a>] -         Cast to TIMESTAMP within value constructor results in IllegalArgumentException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4814'>DRILL-4814</a>] -         extractHeader attribute not working with the table function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4858'>DRILL-4858</a>] -         REPEATED_COUNT on an array of maps and an array of arrays is not implemented
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4902'>DRILL-4902</a>] -         nested aggregate query does not complain about missing GROUP BY clause
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4939'>DRILL-4939</a>] -         to_date function returns incorrect result
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4946'>DRILL-4946</a>] -         org.objectweb.asm.tree.analysis.AnalyzerException printed to console in embedded mode
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5161'>DRILL-5161</a>] -         Several TestConvertFunctions tests produce scalar replacement errors
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5295'>DRILL-5295</a>] -         Unable to query INFORMATION_SCHEMA.`TABLES` if MySql storage plugin enabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5581'>DRILL-5581</a>] -         Query with CASE statement returns wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5683'>DRILL-5683</a>] -         Incorrect query result when query uses NOT(IS NOT NULL) expression 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5713'>DRILL-5713</a>] -         Doing joins on tables that share column names in a JDBC store returns incorrect results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6013'>DRILL-6013</a>] -         requesting INFORMATION_SCHEMA with a postgresql connector generates a null pointer exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6066'>DRILL-6066</a>] -         AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes: validated type
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6260'>DRILL-6260</a>] -         Query fails with &quot;ERROR: Non-scalar sub-query used in an expression&quot; when it contains a cast expression around a scalar sub-query 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6369'>DRILL-6369</a>] -         typeof() fails for constants
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6377'>DRILL-6377</a>] -         typeof() does not return DECIMAL scale, precision
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6458'>DRILL-6458</a>] -         NPE when error while applying rule ReduceExpressionsRule_Project
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6524'>DRILL-6524</a>] -         Two CASE statements in projection influence results of each other
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6533'>DRILL-6533</a>] -         (type|sqlType|drillType|mode)Of functions fail when used with constants
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6707'>DRILL-6707</a>] -         Query with 10-way merge join fails with IllegalArgumentException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6722'>DRILL-6722</a>] -         Query from parquet with case-then and arithmetic operation returns a wrong result
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6734'>DRILL-6734</a>] -         Unable to find value vector of path `EXPR$0`, returning null instance.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6830'>DRILL-6830</a>] -         Hook.REL_BUILDER_SIMPLIFY handler didn&#39;t removed cause performance degression
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6849'>DRILL-6849</a>] -         Runtime filter queries with nested broadcast returns wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6855'>DRILL-6855</a>] -         Query from non-existent proxy user fails with &quot;No default schema selected&quot; when impersonation is enabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6856'>DRILL-6856</a>] -         Wrong result returned if the query filters a boolean column with both &quot;is true&quot; and &quot;is null&quot; conditions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6869'>DRILL-6869</a>] -         Drill allows to create views outside workspace
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6871'>DRILL-6871</a>] -         Enabling runtime filter eliminates more incoming rows than it should.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6875'>DRILL-6875</a>] -         Drill doesn&#39;t try to update connection for S3 after session expired
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6893'>DRILL-6893</a>] -         Invalid output for star and self-join queries for RDBMS Storage Plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6894'>DRILL-6894</a>] -         CTAS and CTTAS are not working on S3 storage when cache is disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6906'>DRILL-6906</a>] -         File permissions are not being honored
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6911'>DRILL-6911</a>] -         Documentation issue - Hadoop core-site.xml is not supported by Drill to read S3 credentials
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6914'>DRILL-6914</a>] -         Query with RuntimeFilter and SemiJoin fails with IllegalStateException: Memory was leaked by query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6918'>DRILL-6918</a>] -         Querying empty topics fails with &quot;NumberFormatException&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6927'>DRILL-6927</a>] -         Query fails when hive table with timestamp data is queried with enabled int96_as_timestamp and optimize_scan_with_native_reader options
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6928'>DRILL-6928</a>] -         Update description for exec.query.return_result_set_for_ddl option to reflect it affects JDBC connections only
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6929'>DRILL-6929</a>] -         maprfs-XXX-mapr.jar is present in jars/3rdparty folder for default profile
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6931'>DRILL-6931</a>] -         Drill &quot;SHOW FILES&quot; command duplicates empty S3 folders as subfolders
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6933'>DRILL-6933</a>] -         Ctrl+Enter meta combo not working on Windows &amp; mac OS
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6934'>DRILL-6934</a>] -         Update the option documentation for planner.enable_unnest_lateral
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6936'>DRILL-6936</a>] -         Graceful shutdown test fails if loopback address is set in hosts
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6937'>DRILL-6937</a>] -         sys.functions table needs a fix in the names column
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6941'>DRILL-6941</a>] -         Incorrect EARLY_LIMIT0_OPT_KEY description
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6944'>DRILL-6944</a>] -         UnsupportedOperationException thrown for view over MapR-DB binary table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6947'>DRILL-6947</a>] -         RuntimeFilter memory leak due to BF ByteBuf ownership transferring 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6954'>DRILL-6954</a>] -         Move commons libs used in UDFs module to the dependency management
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6959'>DRILL-6959</a>] -         Query with filter with cast to timestamp literal does not return any results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6960'>DRILL-6960</a>] -         Auto Limit Wrapping should not apply to non-select query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6967'>DRILL-6967</a>] -         TIMESTAMPDIFF returns incorrect value for SQL_TSI_QUARTER
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6969'>DRILL-6969</a>] -         Inconsistent results when reading MaprDB JSON tables using hive plugin when native reader is enabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6970'>DRILL-6970</a>] -         Issue with LogRegex format plugin where drillbuf was overflowing 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6972'>DRILL-6972</a>] -         Error: Could not find or load main class sqlline.SqlLine
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6976'>DRILL-6976</a>] -         SchemaChangeException happens when using split function in subquery if it returns empty result.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6978'>DRILL-6978</a>] -         typeOf drillTypeOf sqlTypeOf not work with generated tables
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6991'>DRILL-6991</a>] -         Kerberos ticket is being dumped in the log if log level is &quot;debug&quot; for stdout 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6997'>DRILL-6997</a>] -         Semijoin is changing the join ordering for some tpcds queries.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6998'>DRILL-6998</a>] -         Queries failing with &quot;Failed to aggregate or route the RFW&quot; due to &quot;java.lang.ArrayIndexOutOfBoundsException&quot; do not complete
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6999'>DRILL-6999</a>] -         Queries failed with &quot;Failed to aggregate or route the RFW&quot; due to &quot;java.lang.ArrayIndexOutOfBoundsException&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7000'>DRILL-7000</a>] -         Queries failing with &quot;Failed to aggregate or route the RFW&quot; do not complete
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7002'>DRILL-7002</a>] -         RuntimeFilter produce wrong results while setting exec.hashjoin.num_partitions=1
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7008'>DRILL-7008</a>] -         Drillbits: clear stale shutdown hook on close
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7016'>DRILL-7016</a>] -         Wrong query result with RuntimeFilter enabled when order of join and filter condition is swapped
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7021'>DRILL-7021</a>] -         HTTPD Throws NPE and Doesn&#39;t Recognize Timeformat
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7022'>DRILL-7022</a>] -         Partition pruning is not happening the first time after the metadata auto refresh
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7034'>DRILL-7034</a>] -         Window function over a malformed CSV file crashes the JVM 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7035'>DRILL-7035</a>] -         Drill C++ Client crashes on multiple SaslAuthenticatorImpl Destruction due to communication error 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7041'>DRILL-7041</a>] -         CompileException happens if a nested coalesce function returns null
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7045'>DRILL-7045</a>] -         UDF string_binary java.lang.IndexOutOfBoundsException:
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7047'>DRILL-7047</a>] -         Drill C++ Client crash due to Dangling stack ptr to sasl_callback_t 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7049'>DRILL-7049</a>] -         REST API returns the toString of byte arrays (VARBINARY types)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7054'>DRILL-7054</a>] -         PCAP timestamp in milliseconds
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7056'>DRILL-7056</a>] -         Drill fails with NPE when starting in distributed mode and 31010 port is used
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7061'>DRILL-7061</a>] -         Selecting option to limit results to 1000 on web UI causes parse error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7072'>DRILL-7072</a>] -         Query with semi join fails for JDBC storage plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7076'>DRILL-7076</a>] -         NPE is logged when querying postgres tables
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7079'>DRILL-7079</a>] -         Drill can&#39;t query views from the S3 storage when plain authentication is enabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7085'>DRILL-7085</a>] -         Drill Statistics: analyze table cmd fails
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7100'>DRILL-7100</a>] -         parquet RecordBatchSizerManager : IllegalArgumentException: the requested size must be non-negative
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7101'>DRILL-7101</a>] -         IllegalArgumentException when reading parquet data
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7103'>DRILL-7103</a>] -         BSON Recored reader: wrong timestamp values
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7107'>DRILL-7107</a>] -         Unable to connect to Drill 1.15 through ZK
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7108'>DRILL-7108</a>] -         With statistics enabled TPCH 16 has two additional exchange operators
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7109'>DRILL-7109</a>] -         Statistics adds external sort, which spills to disk
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7111'>DRILL-7111</a>] -         Table function fails to query directories
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7113'>DRILL-7113</a>] -         Issue with filtering null values from MapRDB-JSON
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7114'>DRILL-7114</a>] -         ANALYZE command generates warnings for stats file and materialization
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7118'>DRILL-7118</a>] -         Filter not getting pushed down on MapR-DB tables.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7120'>DRILL-7120</a>] -         Query fails with ChannelClosedException when Statistics is disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7121'>DRILL-7121</a>] -         TPCH 4 takes longer when Statistics is disabled.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7122'>DRILL-7122</a>] -         TPCDS queries 29 25 17 are slower when Statistics is disabled.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7123'>DRILL-7123</a>] -         TPCDS query 83 runs slower when Statistics is disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7124'>DRILL-7124</a>] -         Fix logger for ShowFilesHandler
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7125'>DRILL-7125</a>] -         REFRESH TABLE METADATA fails after upgrade from Drill 1.13.0 to Drill 1.15.0
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7126'>DRILL-7126</a>] -         Contrib format-ltsv is not being included in distribution
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7130'>DRILL-7130</a>] -         IllegalStateException: Read batch count [0] should be greater than zero
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7140'>DRILL-7140</a>] -         RM: Drillbits fail with &quot;No enum constant QueueSelectionPolicy.SelectionPolicy.bestfit&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7142'>DRILL-7142</a>] -         Add space after &gt; in SqlLine prompt
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7144'>DRILL-7144</a>] -         sqlline option : !set useLineContinuation false, fails with ParseException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7145'>DRILL-7145</a>] -         Exceptions happened during retrieving values from ValueVector are not being displayed at the Drill Web UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7146'>DRILL-7146</a>] -         Query failing with NPE when ZK queue is enabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7147'>DRILL-7147</a>] -         Source order of &quot;drill-env.sh&quot; and &quot;distrib-env.sh&quot; should be swapped
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7150'>DRILL-7150</a>] -         Fix timezone conversion for timestamp from maprdb after the transition from PDT to PST
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7152'>DRILL-7152</a>] -         Histogram creation throws exception for all nulls column
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7153'>DRILL-7153</a>] -         Drill Fails to Build using JDK 1.8.0_65
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7154'>DRILL-7154</a>] -         TPCH query 4, 17 and 18 take longer with sf 1000 when Statistics are disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7160'>DRILL-7160</a>] -         exec.query.max_rows QUERY-level options are shown on Profiles tab
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7166'>DRILL-7166</a>] -         Count(*) queries with wildcards in table name are reading metadata cache and returning wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7182'>DRILL-7182</a>] -         TPCDS query 64 degrades due to Statistics even when disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7183'>DRILL-7183</a>] -         TPCDS query 10, 35, 69 take longer with sf 1000 when Statistics are disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7185'>DRILL-7185</a>] -         Drill Fails to Read Large Packets
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7186'>DRILL-7186</a>] -         Missing storage.json REST endpoint
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7190'>DRILL-7190</a>] -         Missing backward compatibility for REST API with DRILL-6562
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7201'>DRILL-7201</a>] -         Strange symbols in error window (Windows)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7202'>DRILL-7202</a>] -         Failed query shows warning that fragments has made no progress
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7213'>DRILL-7213</a>] -         drill-format-mapr.jar contains stale git.properties file
+</li>
+</ul>
+        
+<h2>        New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-540'>DRILL-540</a>] -         Allow querying hive views in Drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6992'>DRILL-6992</a>] -         Support column histogram statistics
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7014'>DRILL-7014</a>] -         Format plugin for LTSV files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7048'>DRILL-7048</a>] -         Implement JDBC Statement.setMaxRows() with System Option
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7077'>DRILL-7077</a>] -         Add Function to Facilitate Time Series Analysis
+</li>
+</ul>
+        
+<h2>        Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-416'>DRILL-416</a>] -         Make Drill work with SELECT without FROM
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-912'>DRILL-912</a>] -         Project push down tests rely on JSON pushdown but JSON reader no longer supports pushdown.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1328'>DRILL-1328</a>] -         Support table statistics
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1506'>DRILL-1506</a>] -         Current Schema Not Shown In the sqlline Prompt
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1669'>DRILL-1669</a>] -         Custom sqlline Prompt
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5509'>DRILL-5509</a>] -         Upgrade Drill protobuf support from 2.5.0 to latest 3.3
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5603'>DRILL-5603</a>] -         Replace String file paths to Hadoop Path
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5696'>DRILL-5696</a>] -         Change default compiler strategy
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5773'>DRILL-5773</a>] -         Project pushdown into a subquery with select *
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6050'>DRILL-6050</a>] -         Provide a limit to number of rows fetched for a query in UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6430'>DRILL-6430</a>] -         Drill Should Not Fail If It Sees Deprecated Options Stored In Zookeeper Or Locally
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6562'>DRILL-6562</a>] -         Plugin Management improvements
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6582'>DRILL-6582</a>] -         SYSLOG (RFC-5424) Format Plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6879'>DRILL-6879</a>] -         Indicate a warning in the WebUI when a query makes little to no progress for a while
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6880'>DRILL-6880</a>] -         Hash-Join: Many null keys on the build side form a long linked chain in the Hash Table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6901'>DRILL-6901</a>] -         Move SchemaBuilder from test to main for use outside tests
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6903'>DRILL-6903</a>] -         SchemaBuilder improvements
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6910'>DRILL-6910</a>] -         A filtering column remains in scan when filter pruning happens
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6921'>DRILL-6921</a>] -         Add button to reset Options filter
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6939'>DRILL-6939</a>] -         Indicate when a query is submitted and is in progress
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6942'>DRILL-6942</a>] -         Provide ability to sort list of profiles on Drill web UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6950'>DRILL-6950</a>] -         Row set-based scan framework
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6952'>DRILL-6952</a>] -         Merge row set based &quot;compliant&quot; text reader
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6962'>DRILL-6962</a>] -         Function coalesce returns an Error when none of the columns in coalesce exist in a parquet file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6971'>DRILL-6971</a>] -         Display query state in query result page
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6977'>DRILL-6977</a>] -         Improve Hive tests configuration
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6985'>DRILL-6985</a>] -         Fix sqlline.bat issues on Windows and add drill-embedded.bat
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7006'>DRILL-7006</a>] -         Support type conversion shims in RowSetWriter
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7007'>DRILL-7007</a>] -         Revise row-set based tests to use simplified verify method
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7011'>DRILL-7011</a>] -         Allow hybrid model in the Row set-based scan framework
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7018'>DRILL-7018</a>] -         Parquet File fails with IndexOutOfBoundsException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7024'>DRILL-7024</a>] -         Refactor ColumnWriter to simplify type-conversion shim
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7028'>DRILL-7028</a>] -         Reduce the planning time of queries on large Parquet tables with large metadata cache files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7031'>DRILL-7031</a>] -         Add Travis job that runs protobuf generation command and checks if all protobufs are up-to-date
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7032'>DRILL-7032</a>] -         Ignore corrupt rows in a PCAP file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7036'>DRILL-7036</a>] -         Improve UI for alert and error messages
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7038'>DRILL-7038</a>] -         Queries on partitioned columns scan the entire datasets
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7042'>DRILL-7042</a>] -         Apache Drill v1.15.0 failed to generate deb/rpm package
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7051'>DRILL-7051</a>] -         Upgrade to Jetty 9.3 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7052'>DRILL-7052</a>] -         Relative path for URL redirection
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7060'>DRILL-7060</a>] -         Support JsonParser Feature &#39;ALLOW_BACKSLASH_ESCAPING_ANY_CHARACTER&#39; in JsonReader
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7069'>DRILL-7069</a>] -         Poor performance of transformBinaryInMetadataCache
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7070'>DRILL-7070</a>] -         Fix deb and rpm issues on apache drill master branch
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7074'>DRILL-7074</a>] -         Fixes and improvements to the scan framework for CSV
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7075'>DRILL-7075</a>] -         Fix debian package issue with control files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7081'>DRILL-7081</a>] -         Upgrade GlassFish Jersey and Javax Servlet dependecies
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7086'>DRILL-7086</a>] -         Enhance row-set scan framework to use external schema
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7110'>DRILL-7110</a>] -         Skip writing profile when an ALTER SESSION is executed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7115'>DRILL-7115</a>] -         Improve Hive schema show tables performance
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7143'>DRILL-7143</a>] -         Enforce column-level constraints when using a schema
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7165'>DRILL-7165</a>] -         Redundant Checksum calculating for ASC files
+</li>
+</ul>
+            
+<h2>        Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5658'>DRILL-5658</a>] -         Documentation for Drill Crypto Functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6862'>DRILL-6862</a>] -         Update Calcite to 1.18.0 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6907'>DRILL-6907</a>] -         Fix hive-exec-shaded classes recognition in IntelliJ IDEA
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6946'>DRILL-6946</a>] -         Implement java.sql.Connection setSchema and getSchema methods in DrillConnectionImpl
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6955'>DRILL-6955</a>] -         storage-jdbc unit tests improvements
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6989'>DRILL-6989</a>] -         Upgrade to SqlLine 1.7.0
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7019'>DRILL-7019</a>] -         Add check for redundant imports
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7106'>DRILL-7106</a>] -         Fix Intellij warning for FieldSchemaNegotiator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7155'>DRILL-7155</a>] -         Create a standard logging message for batch sizes generated by individual operators
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7188'>DRILL-7188</a>] -         Revert DRILL-6642: Update protocol-buffers version
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7189'>DRILL-7189</a>] -         Revert DRILL-7105 Error while building the Drill native client
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7207'>DRILL-7207</a>] -         Update the copyright year in NOTICE.txt file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7212'>DRILL-7212</a>] -         Add gpg key with apache.org email for sorabh
+</li>
+</ul>   
+    
+                                                                                
\ No newline at end of file
diff --git a/_docs/rn/001-1.15.0-rn.md b/_docs/rn/006-1.15.0-rn.md
similarity index 100%
rename from _docs/rn/001-1.15.0-rn.md
rename to _docs/rn/006-1.15.0-rn.md
diff --git a/_docs/rn/002-1.14.0-rn.md b/_docs/rn/007-1.14.0-rn.md
similarity index 100%
rename from _docs/rn/002-1.14.0-rn.md
rename to _docs/rn/007-1.14.0-rn.md
diff --git a/_docs/rn/003-1.13.0-rn.md b/_docs/rn/008-1.13.0-rn.md
similarity index 100%
rename from _docs/rn/003-1.13.0-rn.md
rename to _docs/rn/008-1.13.0-rn.md
diff --git a/_docs/sql-reference/sql-commands/009-analyze-table.md b/_docs/sql-reference/sql-commands/009-analyze-table.md
index 36f624c..22ec084 100644
--- a/_docs/sql-reference/sql-commands/009-analyze-table.md
+++ b/_docs/sql-reference/sql-commands/009-analyze-table.md
@@ -115,7 +115,7 @@ If you use any of these words in a Drill query, you must enclose the word in bac
 
 - After you run the ANALYZE TABLE statement, you can view the profile for ANALYZE in the Drill Web UI. Go to `http://<drill-hostname-or-ip>:8047/profiles`, and click the ANALYZE TABLE statement for which you want to view the profile.  
 - Should you notice any performance issues, you may want to decrease the value of the `planner.slice_target` option.   
-- Generating statistics on large data sets can unnecessarily consume time and resources, such as memory and CPU. ANALYZE TABLE can compute statistics on a sample (subset of the data indicated as a percentage) to limit the amount of resources needed for computation. Drill still scans the entire data set, but only computes on the rows selected for sampling. Rows are randomly selected for the sample. Note that the quality of statistics increases with the sample size.    
+- Generating statistics on large data sets can consume time and resources, such as memory and CPU. ANALYZE TABLE can compute statistics on a sample (subset of the data indicated as a percentage) to limit the amount of resources needed for computation. Drill still scans the entire data set, but only computes on the rows selected for sampling. Rows are randomly selected for the sample. Note that the quality of statistics increases with the sample size.    
  
 ## Queries that Benefit from Statistics
 Typically, the types of queries that benefit from statistics are those that include:
diff --git a/_docs/tutorials/020-drill-in-10-minutes.md b/_docs/tutorials/020-drill-in-10-minutes.md
index ae6ceb3..ceb6848 100644
--- a/_docs/tutorials/020-drill-in-10-minutes.md
+++ b/_docs/tutorials/020-drill-in-10-minutes.md
@@ -1,6 +1,6 @@
 ---
 title: "Drill in 10 Minutes"
-date: 2019-04-08
+date: 2019-05-02
 parent: "Tutorials"
 description: Get started with Drill in 10 minutes or less.
 ---
@@ -45,9 +45,9 @@ The output looks something like this:
 Complete the following steps to install Drill:  
 
 1. In a terminal window, change to the directory where you want to install Drill.  
-2. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz) with the command appropriate for your system:  
-       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz`  
-       * `curl -o apache-drill-1.15.0.tar.gz http://apache.mirrors.hoobly.com/drill/drill-1.15.0/apache-drill-1.15.0.tar.gz`   
+2. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz) with the command appropriate for your system:  
+       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz`  
+       * `curl -o apache-drill-1.16.0.tar.gz http://apache.mirrors.hoobly.com/drill/drill-1.16.0/apache-drill-1.16.0.tar.gz`   
 3. Copy the downloaded file to the directory where you want to install Drill.  
 4. Extract the contents of the Drill .tar.gz file. Use `sudo` if necessary:  
 `tar -xvzf <.tar.gz file name>`  
diff --git a/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md b/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
index f598879..77075c4 100644
--- a/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
+++ b/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
@@ -1,6 +1,6 @@
 ---
 title: "Analyzing Highly Dynamic Datasets"
-date: 2018-12-30
+date: 2019-05-02
 parent: "Tutorials"
 ---
 
@@ -33,7 +33,7 @@ The element names that you see in the `checkin_info` are unknown upfront and can
 Step 1: First download Drill, if you have not yet done so, onto your machine
 
     http://drill.apache.org/download/
-    tar -xvf apache-drill-1.15.0.tar
+    tar -xvf apache-drill-1.16.0.tar
 
 Install Drill locally on your desktop (embedded mode). You don’t need Hadoop.
 
diff --git a/blog/_posts/2019-05-02-drill-1.16-released.md b/blog/_posts/2019-05-02-drill-1.16-released.md
new file mode 100644
index 0000000..0cfee85
--- /dev/null
+++ b/blog/_posts/2019-05-02-drill-1.16-released.md
@@ -0,0 +1,32 @@
+---
+layout: post
+title: "Drill 1.16 Released"
+code: drill-1.16-released
+excerpt: Apache Drill 1.16's highlights are&#58; table statistics, schema provisioning for text files, parquet metadata caching improvements, several Web UI improvements, and more.
+authors: ["bbevens"]
+---
+
+Today, we're happy to announce the availability of Drill 1.16.0. You can download it [here](https://drill.apache.org/download/).
+
+This release provides the following bug fixes and improvements:
+
+## Table Statistics  
+The [ANALYZE TABLE statement]({{site.baseurl}}/docs/analyze-table/)  computes statistics and generates histograms for numeric data types.   
+
+## Schema Provisioning for Text Files
+The [CREATE OR REPLACE SCHEMA command]({{site.baseurl}}/docs/create-or-replace-schema/) defines a schema for text files (alpha phase).  
+   
+## Parquet Metadata Caching Improvements  
+The [REFRESH TABLE METADATA command]({{site.baseurl}}/docs/refresh-table-metadata/) can generate metadata cache files for specific columns. 
+   
+## Drill Web UI Enhancements  
+Enhancements include:   
+	- [Storage plugin management improvements](https://drill.apache.org/docs/configuring-storage-plugins/#exporting-storage-plugin-configurations)  
+	- [Query progress indicators and warnings ]({{site.baseurl}}/docs/query-profiles/#query-profile-warnings)   
+	- Ability to [limit the result size for better UI response]({{site.baseurl}}/docs/planning-and-execution-options/#setting-an-auto-limit-on-the-number-of-rows-returned-for-result-sets)   
+	- Ability to [sort the list of profiles in the Drill Web UI]({{site.baseurl}}/docs/query-profiles/#viewing-a-query-profile)   
+	- [Display query state in query result page]({{site.baseurl}}/docs/starting-the-web-ui/#running-queries-from-the-web-ui)   
+	- [Button to reset the options filter](https://drill.apache.org/docs/planning-and-execution-options/#setting-options-from-the-drill-web-ui)   
+
+You can find a complete list of improvements and JIRAs resolved in the 1.16.0 release [here]({{site.baseurl}}/docs/apache-drill-1-16-0-release-notes/).
+


Mime
View raw message