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 <[email protected]>
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'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'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 'NOT' to arguments of type 'NOT<CHAR(2)>'.
+</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 "label"
+</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 "ERROR: Non-scalar sub-query used in an
expression" 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'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 "No default schema
selected" 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
"is true" and "is null" 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'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 "NumberFormatException"
+</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 "SHOW FILES" 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 & 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 "debug"
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 "Failed to aggregate or route the RFW" due to
"java.lang.ArrayIndexOutOfBoundsException" do not complete
+</li>
+<li>[<a
href='https://issues.apache.org/jira/browse/DRILL-6999'>DRILL-6999</a>] -
Queries failed with "Failed to aggregate or route the RFW" due to
"java.lang.ArrayIndexOutOfBoundsException"
+</li>
+<li>[<a
href='https://issues.apache.org/jira/browse/DRILL-7000'>DRILL-7000</a>] -
Queries failing with "Failed to aggregate or route the RFW" 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'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'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 "No enum constant
QueueSelectionPolicy.SelectionPolicy.bestfit"
+</li>
+<li>[<a
href='https://issues.apache.org/jira/browse/DRILL-7142'>DRILL-7142</a>] -
Add space after > 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 "drill-env.sh" and "distrib-env.sh"
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 "compliant" 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 'ALLOW_BACKSLASH_ESCAPING_ANY_CHARACTER'
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: 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/).
+
