You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2019/12/26 06:04:01 UTC

[drill] branch gh-pages updated: doc and website updates for the 1.17 release

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 374f55c  doc and website updates for the 1.17 release
374f55c is described below

commit 374f55c619f5b7aea5d5161ea21b6e341a682c3f
Author: bridget <br...@hpe.com>
AuthorDate: Wed Dec 25 22:02:47 2019 -0800

    doc and website updates for the 1.17 release
---
 _data/version.json                                 |  10 +-
 .../120-configuring-the-drill-shell.md             |   8 +-
 _docs/getting-started/010-drill-introduction.md    |  32 +-
 .../install/047-installing-drill-on-the-cluster.md |   8 +-
 .../011-running-drill-on-docker.md                 |  14 +-
 .../020-installing-drill-on-linux-and-mac-os-x.md  |   8 +-
 .../040-installing-drill-on-windows.md             |   4 +-
 .../050-starting-drill-on-windows.md               |   8 +-
 _docs/rn/004-1.17.0-rn.md                          | 433 +++++++++++++++++++++
 _docs/tutorials/020-drill-in-10-minutes.md         |   8 +-
 .../050-analyzing-highly-dynamic-datasets.md       |   4 +-
 blog/_posts/2019-12-26-drill-1.17-released.md      |  32 ++
 12 files changed, 533 insertions(+), 36 deletions(-)

diff --git a/_data/version.json b/_data/version.json
index 7e32c10..aa1e5b6 100644
--- a/_data/version.json
+++ b/_data/version.json
@@ -1,7 +1,7 @@
 {
-  "display_version": "1.16",
-  "full_version": "1.16.0",
-  "release_date": "May 02, 2019",
-  "blog_post":"/blog/2019/05/02/drill-1.16-released",
-  "release_notes": "https://drill.apache.org/docs/apache-drill-1-16-0-release-notes/"
+  "display_version": "1.17",
+  "full_version": "1.17.0",
+  "release_date": "December 26, 2019",
+  "blog_post":"/blog/2019/12/26/drill-1.17-released",
+  "release_notes": "https://drill.apache.org/docs/apache-drill-1-17-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 900e8fe..0f0e5f7 100644
--- a/_docs/configure-drill/120-configuring-the-drill-shell.md
+++ b/_docs/configure-drill/120-configuring-the-drill-shell.md
@@ -1,11 +1,13 @@
 ---
 title: "Configuring the Drill Shell"
-date: 2019-05-02
+date: 2019-12-26
 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. 
+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:  
+Starting in Drill 1.17, Drill uses SQLLine 1.9. 
+
+Drill 1.16 uses SQLLine 1.7, which 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;
 	+------+-------------------------------------+
diff --git a/_docs/getting-started/010-drill-introduction.md b/_docs/getting-started/010-drill-introduction.md
index acbb266..7296d98 100644
--- a/_docs/getting-started/010-drill-introduction.md
+++ b/_docs/getting-started/010-drill-introduction.md
@@ -1,6 +1,6 @@
 ---
 title: "Drill Introduction"
-date: 2019-05-02
+date: 2019-12-26
 parent: "Getting Started"
 ---
 Drill is an Apache open-source SQL query engine for Big Data exploration.
@@ -10,6 +10,36 @@ applications, while still providing the familiarity and ecosystem of ANSI SQL,
 the industry-standard query language. Drill provides plug-and-play integration
 with existing Apache Hive and Apache HBase deployments.   
 
+## What's New in Apache Drill 1.17  
+* <a href='https://issues.apache.org/jira/browse/DRILL-6540'>DRILL-6540</a> - Upgrade to HADOOP-3.0 libraries. The hadoop-winutils version that worked for previous releases does not work with Drill 1.17 and later. Use the hadoop-winutils version provided with Drill 1.17 or use custom hadoop-winutils built for Hadoop 3.2.0.  
+* <a href='https://issues.apache.org/jira/browse/DRILL-6739'>DRILL-6739</a> - Update Kafka libs to 2.0.0+ version
+* <a href='https://issues.apache.org/jira/browse/DRILL-7401'>DRILL-7401</a> - Upgrade to Sqlline 1.9 
+* <a href='https://issues.apache.org/jira/browse/DRILL-7200'>DRILL-7200</a> - Update Calcite to 1.19.0 / 1.20.0
+* <a href='https://issues.apache.org/jira/browse/DRILL-5674'>DRILL-5674</a> - Support for .zip compression
+* <a href='https://issues.apache.org/jira/browse/DRILL-6835'>DRILL-6835</a> - Schema provision using File / Table Function
+* <a href='https://issues.apache.org/jira/browse/DRILL-7337'>DRILL-7337</a> - Support for vararg UDFs 
+* <a href='https://issues.apache.org/jira/browse/DRILL-7096'>DRILL-7096</a> - Develop vector for canonical Map<K,V>
+* <a href='https://issues.apache.org/jira/browse/DRILL-7343'>DRILL-7343</a> - User-Agent UDFs added
+
+Hive complex types support:
+* <a href='https://issues.apache.org/jira/browse/DRILL-7251'>DRILL-7251</a> - Read Hive array without nulls
+* <a href='https://issues.apache.org/jira/browse/DRILL-7252'>DRILL-7252</a> - Read Hive map using Dict<K,V> vector
+* <a href='https://issues.apache.org/jira/browse/DRILL-7253'>DRILL-7253</a> - Read Hive struct without nulls
+* <a href='https://issues.apache.org/jira/browse/DRILL-7254'>DRILL-7254</a> - Read Hive union without nulls
+* <a href='https://issues.apache.org/jira/browse/DRILL-7268'>DRILL-7268</a> - Read Hive array with parquet native reader
+
+New format plugins support:
+* <a href='https://issues.apache.org/jira/browse/DRILL-4303'>DRILL-4303</a> - ESRI Shapefile (shp) format plugin
+* <a href='https://issues.apache.org/jira/browse/DRILL-7177'>DRILL-7177</a> - Format Plugin for Excel Files
+* <a href='https://issues.apache.org/jira/browse/DRILL-6096'>DRILL-6096</a> - Provide mechanisms to specify field delimiters and quoted text for TextRecordWriter   
+* Parquet format improvements, including runtime row group pruning (<a href='https://issues.apache.org/jira/browse/DRILL-7062'>DRILL-7062</a>), empty parquet creation (<a href='https://issues.apache.org/jira/browse/DRILL-7156'>DRILL-7156</a>), reading (<a href='https://issues.apache.org/jira/browse/DRILL-4517'>DRILL-4517</a>) support, and more.
+
+Metastore support:
+* <a href='https://issues.apache.org/jira/browse/DRILL-7272'>DRILL-7272</a> - Implement Drill Iceberg Metastore plugin
+* <a href='https://issues.apache.org/jira/browse/DRILL-7273'>DRILL-7273</a> - Create operator for handling metadata
+* <a href='https://issues.apache.org/jira/browse/DRILL-7357'>DRILL-7357</a> - Expose Drill Metastore data through INFORMATION_SCHEMA    
+
+
 ## What's New in Apache Drill 1.16  
 - [ANALYZE TABLE statement]({{site.baseurl}}/docs/analyze-table/) to computes statistics on Parquet data ([DRILL-1328](https://issues.apache.org/jira/browse/DRILL-1328))   
 - [CREATE OR REPLACE SCHEMA command]({{site.baseurl}}/docs/create-or-replace-schema/) to define a schema for text files ([DRILL-6964](https://issues.apache.org/jira/browse/DRILL-6964))   
diff --git a/_docs/install/047-installing-drill-on-the-cluster.md b/_docs/install/047-installing-drill-on-the-cluster.md
index d367317..3486f16 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: 2019-05-02
+date: 2019-12-26
 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.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`  
+  1. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.17.0/apache-drill-1.17.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.17.0/apache-drill-1.17.0.tar.gz) with the command appropriate for your system:  
+       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.17.0/apache-drill-1.17.0.tar.gz`  
+       * `curl -o apache-drill-1.17.0.tar.gz http://apache.mirrors.hoobly.com/drill/drill-1.17.0/apache-drill-1.17.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 c1c9de0..9b3248b 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: 2019-05-31
+date: 2019-12-26
 parent: "Installing Drill in Embedded Mode"
 ---  
 
@@ -27,20 +27,20 @@ Whether you run the Docker container in detached or foreground mode, you start D
 | `-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.16.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.                           |
+| `drill/apache-drill:<version>` | The Docker Hub repository and tag. In the following   example, `drill/apache-drill` is   the repository and `1.17.0`   is the tag:     `drill/apache-drill:1.17.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 options to connect to SQLLine (the Drill shell):   
 
-       docker run -i --name drill-1.16.0 -p 8047:8047 -t drill/apache-drill:1.16.0 /bin/bash  
+       docker run -i --name drill-1.17.0 -p 8047:8047 -t drill/apache-drill:1.17.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:  
 
        Jun 29, 2018 3:28:21 AM org.glassfish.jersey.server.ApplicationHandler initialize
        INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
-       apache drill 1.16.0 
+       apache drill 1.17.0 
        "json ain't no thang"
        0: jdbc:drill:zk=local>  
 
@@ -54,17 +54,17 @@ 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.16.0 -p 8047:8047 --detach -t drill/apache-drill:1.16.0 /bin/bash
+       $ docker run -i --name drill-1.17.0 -p 8047:8047 --detach -t drill/apache-drill:1.17.0 /bin/bash
        <displays container ID>
 
-       $ docker exec -it drill-1.16.0 bash
+       $ docker exec -it drill-1.17.0 bash
        <connects to container>
 
        $ /opt/drill/bin/drill-localhost  
 
 After you issue the commands, the Drill process starts in a container. SQLLine prints a message, and the prompt appears:  
 
-       apache drill 1.16.0 
+       apache drill 1.17.0 
        "json ain't no thang"
        0: jdbc:drill:drillbit=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 46cebae..a72a86b 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: 2019-05-02
+date: 2019-12-26
 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.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`  
+2. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.17.0/apache-drill-1.17.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.17.0/apache-drill-1.17.0.tar.gz) with the command appropriate for your system:  
+       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.17.0/apache-drill-1.17.0.tar.gz`  
+       * `curl -o apache-drill-1.17.0.tar.gz http://www.apache.org/dyn/closer.cgi/drill/drill-1.17.0/apache-drill-1.17.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 e979db6..fb390e1 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-05-02
+date: 2019-12-26
 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.16.0/apache-drill-1.16.0.tar.gz).
+1. Download the latest version of Apache Drill [here](http://www-us.apache.org/dist/drill/drill-1.17.0/apache-drill-1.17.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/install/installing-drill-in-embedded-mode/050-starting-drill-on-windows.md b/_docs/install/installing-drill-in-embedded-mode/050-starting-drill-on-windows.md
index 2c72923..d6ce51e 100644
--- a/_docs/install/installing-drill-in-embedded-mode/050-starting-drill-on-windows.md
+++ b/_docs/install/installing-drill-in-embedded-mode/050-starting-drill-on-windows.md
@@ -1,26 +1,26 @@
 ---
 title: "Starting Drill on Windows"
-date: 2019-04-10
+date: 2019-12-26
 parent: "Installing Drill in Embedded Mode"
 ---
 Complete the following steps to launch the Drill:
 
 1. Open the Windows command prompt.  
 2. Navigate to the Drill installation folder, for example:  
-`cd \Users\user1\drill_repo\apache-drill-1.16.0-SNAPSHOT` 
+`cd \Users\user1\drill_repo\apache-drill-1.17.0-SNAPSHOT` 
 3. Go to the `bin` directory, for example:  
 `cd bin`
 4. Enter either of the following commands to start Drill:     
 	- `sqlline.bat -u "jdbc:drill:zk=local"`  
     - `drill-embedded.bat` (Supported in Drill 1.16 and later.)  
 
-			C:\Users\user1\drill_repo\apache-drill-1.16.0-SNAPSHOT\bin>drill-embedded.bat
+			C:\Users\user1\drill_repo\apache-drill-1.17.0-SNAPSHOT\bin>drill-embedded.bat
 		
 			DRILL_ARGS - " -u jdbc:drill:zk=local"
 			HADOOP_HOME not detected...
 			HBASE_HOME not detected...
 			Calculating Drill classpath...
-			Apache Drill 1.16.0-SNAPSHOT
+			Apache Drill 1.17.0-SNAPSHOT
 			"Drill never goes out of style."
 			apache drill>
 
diff --git a/_docs/rn/004-1.17.0-rn.md b/_docs/rn/004-1.17.0-rn.md
new file mode 100644
index 0000000..7438b81
--- /dev/null
+++ b/_docs/rn/004-1.17.0-rn.md
@@ -0,0 +1,433 @@
+---
+title: "Apache Drill 1.17.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:**  December 26, 2019
+
+Today, we're happy to announce the availability of Drill 1.17.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:   
+
+* <a href='https://issues.apache.org/jira/browse/DRILL-6540'>DRILL-6540</a> - Upgrade to HADOOP-3.0 libraries. The hadoop-winutils version that worked for previous releases does not work with Drill 1.17 and later. Use the hadoop-winutils version provided with Drill 1.17 or use custom hadoop-winutils built for Hadoop 3.2.0.  
+* <a href='https://issues.apache.org/jira/browse/DRILL-6739'>DRILL-6739</a> - Update Kafka libs to 2.0.0+ version
+* <a href='https://issues.apache.org/jira/browse/DRILL-7401'>DRILL-7401</a> - Upgrade to Sqlline 1.9 
+* <a href='https://issues.apache.org/jira/browse/DRILL-7200'>DRILL-7200</a> - Update Calcite to 1.19.0 / 1.20.0
+* <a href='https://issues.apache.org/jira/browse/DRILL-5674'>DRILL-5674</a> - Support for .zip compression
+* <a href='https://issues.apache.org/jira/browse/DRILL-6835'>DRILL-6835</a> - Schema provision using File / Table Function
+* <a href='https://issues.apache.org/jira/browse/DRILL-7337'>DRILL-7337</a> - Support for vararg UDFs 
+* <a href='https://issues.apache.org/jira/browse/DRILL-7096'>DRILL-7096</a> - Develop vector for canonical Map<K,V>
+* <a href='https://issues.apache.org/jira/browse/DRILL-7343'>DRILL-7343</a> - User-Agent UDFs added
+
+Hive complex types support:
+* <a href='https://issues.apache.org/jira/browse/DRILL-7251'>DRILL-7251</a> - Read Hive array without nulls
+* <a href='https://issues.apache.org/jira/browse/DRILL-7252'>DRILL-7252</a> - Read Hive map using Dict<K,V> vector
+* <a href='https://issues.apache.org/jira/browse/DRILL-7253'>DRILL-7253</a> - Read Hive struct without nulls
+* <a href='https://issues.apache.org/jira/browse/DRILL-7254'>DRILL-7254</a> - Read Hive union without nulls
+* <a href='https://issues.apache.org/jira/browse/DRILL-7268'>DRILL-7268</a> - Read Hive array with parquet native reader
+
+New format plugins support:
+* <a href='https://issues.apache.org/jira/browse/DRILL-4303'>DRILL-4303</a> - ESRI Shapefile (shp) format plugin
+* <a href='https://issues.apache.org/jira/browse/DRILL-7177'>DRILL-7177</a> - Format Plugin for Excel Files
+* <a href='https://issues.apache.org/jira/browse/DRILL-6096'>DRILL-6096</a> - Provide mechanisms to specify field delimiters and quoted text for TextRecordWriter   
+* Parquet format improvements, including runtime row group pruning (<a href='https://issues.apache.org/jira/browse/DRILL-7062'>DRILL-7062</a>), empty parquet creation (<a href='https://issues.apache.org/jira/browse/DRILL-7156'>DRILL-7156</a>), reading (<a href='https://issues.apache.org/jira/browse/DRILL-4517'>DRILL-4517</a>) support, and more.
+
+Metastore support:
+* <a href='https://issues.apache.org/jira/browse/DRILL-7272'>DRILL-7272</a> - Implement Drill Iceberg Metastore plugin
+* <a href='https://issues.apache.org/jira/browse/DRILL-7273'>DRILL-7273</a> - Create operator for handling metadata
+* <a href='https://issues.apache.org/jira/browse/DRILL-7357'>DRILL-7357</a> - Expose Drill Metastore data through INFORMATION_SCHEMA
+	
+The following sections list additional fixes and improvements in Drill 1.17.0:    
+ 
+<h2>        Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5491'>DRILL-5491</a>] -         NPE when reading a CSV file, with headers, but blank header line
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6965'>DRILL-6965</a>] -         Adjust table function usage for all storage plugins and implement schema parameter
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7168'>DRILL-7168</a>] -         Implement ALTER SCHEMA ADD / REMOVE COLUMN / PROPERTY commands
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7221'>DRILL-7221</a>] -         Exclude debug files generated by maven debug option from jar
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7240'>DRILL-7240</a>] -         Temp fix: Run-time rowgroup pruning match() fails on casting a Long to an Integer
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7244'>DRILL-7244</a>] -         Run-time rowgroup pruning match() fails on casting a Long to an Integer
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7271'>DRILL-7271</a>] -         Refactor Metadata interfaces and classes to contain all needed information for the File based Metastore
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7310'>DRILL-7310</a>] -         Move schema-related classes from exec module to be able to use them in metastore module
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7329'>DRILL-7329</a>] -         Implement metadata usage for Parquet format plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7331'>DRILL-7331</a>] -         Support Iceberg metadata expiration
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7356'>DRILL-7356</a>] -         Introduce session options for the Drill Metastore
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7387'>DRILL-7387</a>] -         Failed to get value by int key from map nested into struct
+</li>
+</ul>
+        
+<h2>        Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1834'>DRILL-1834</a>] -         Misleading error message when querying an empty Parquet file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3587'>DRILL-3587</a>] -         Select hive&#39;s struct data gives IndexOutOfBoundsException instead of unsupported error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3664'>DRILL-3664</a>] -         CAST integer zero , one to boolean false , true
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3676'>DRILL-3676</a>] -         Group by ordinal number of an output column results in parse error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3850'>DRILL-3850</a>] -         Execute multiple commands from sqlline -q
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3995'>DRILL-3995</a>] -         Scalar replacement bug with Common Subexpression Elimination
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4547'>DRILL-4547</a>] -         Javadoc fails with Java8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4788'>DRILL-4788</a>] -         Exporting from Parquet to CSV - commas in strings are not escaped
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4949'>DRILL-4949</a>] -         Need better handling of empty parquet files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5183'>DRILL-5183</a>] -         Drill doesn&#39;t seem to handle array values correctly in Parquet files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5436'>DRILL-5436</a>] -         Need a way to input password which contains space when calling sqlline
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5451'>DRILL-5451</a>] -         Query on csv file w/ header fails with an exception when non existing column is requested if file is over 4096 lines long
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5487'>DRILL-5487</a>] -         Vector corruption in CSV with headers and truncated last row
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5554'>DRILL-5554</a>] -         Wrong error type for &quot;SELECT a&quot; from a CSV file without headers
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5844'>DRILL-5844</a>] -         Incorrect values of TABLE_TYPE returned from method DatabaseMetaData.getTables of JDBC API
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5929'>DRILL-5929</a>] -         Misleading error for text file with blank line delimiter
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5983'>DRILL-5983</a>] -         Unsupported nullable converted type INT_8 for primitive type INT32 error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6181'>DRILL-6181</a>] -         CTAS should support writing nested structures (nested lists) to parquet.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6528'>DRILL-6528</a>] -         Planner setting the wrong number of records to read (Parquet Reader)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6723'>DRILL-6723</a>] -         Kafka reader fails on malformed JSON
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6885'>DRILL-6885</a>] -         CTAS for empty output doesn&#39;t create parquet file or folder
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6904'>DRILL-6904</a>] -         Update maven-javadoc-plugin to 3.0.1 version
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6958'>DRILL-6958</a>] -         CTAS csv with option
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6984'>DRILL-6984</a>] -         from table escape parameter not deleted when defined with value other than &#39;&quot;&#39; 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6990'>DRILL-6990</a>] -         IllegalStateException: The current reader doesn&#39;t support getting next information
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7050'>DRILL-7050</a>] -         RexNode convert exception in subquery
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7082'>DRILL-7082</a>] -         Inconsistent results with implicit partition columns, multi scans
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7083'>DRILL-7083</a>] -         Wrong data type for explicit partition column beyond file depth
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7084'>DRILL-7084</a>] -         ResultSet getObject method throws not implemented exception if the column type is NULL
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7105'>DRILL-7105</a>] -         Error while building the Drill native client
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7132'>DRILL-7132</a>] -         Metadata cache does not have correct min/max values for varchar and interval data types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7139'>DRILL-7139</a>] -         Date_add() can produce incorrect results when adding to a timestamp
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7148'>DRILL-7148</a>] -         TPCH query 17 increases execution time with Statistics enabled because join order is changed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7158'>DRILL-7158</a>] -         null values for varchar, interval, boolean are displayed as empty string in SqlLine
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7164'>DRILL-7164</a>] -         KafkaFilterPushdownTest is sometimes failing to pattern match correctly.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7167'>DRILL-7167</a>] -         DESCRIBE TABLE statement is not implemented 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7170'>DRILL-7170</a>] -         IllegalStateException: Record count not set for this vector container
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7171'>DRILL-7171</a>] -         Count(*) query on leaf level directory is not reading summary cache file.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7181'>DRILL-7181</a>] -         [Text V3 Reader] Exception with inadequate message is thrown if select columns as array with extractHeader set to true
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7187'>DRILL-7187</a>] -         Improve selectivity estimates for range predicates when using histogram
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7195'>DRILL-7195</a>] -         Query returns incorrect result or does not fail when cast with is null is used in filter condition
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7196'>DRILL-7196</a>] -         Queries are still runnable on disabled plugins
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7198'>DRILL-7198</a>] -         Issuing a control-C in Sqlline exits the session (it does cancel the query)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7199'>DRILL-7199</a>] -         Optimize the time taken to populate column statistics for non-interesting columns
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7204'>DRILL-7204</a>] -         Add proper validation when creating plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7205'>DRILL-7205</a>] -         Drill fails to start when authentication is disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7208'>DRILL-7208</a>] -         Drill commit is not shown if build Drill from the 1.16.0-rc1 release sources
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7225'>DRILL-7225</a>] -         Merging of columnTypeInfo for file with different schema throws NullPointerException during refresh metadata
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7227'>DRILL-7227</a>] -         TPCDS queries 47, 57, 59 fail to run with Statistics enabled at sf100
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7228'>DRILL-7228</a>] -         Histogram end points show high deviation for a sample data set
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7237'>DRILL-7237</a>] -         IllegalStateException in aggregation function &#39;single_value&#39; when there is a varchar datatype in the subquery results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7238'>DRILL-7238</a>] -         Drill does not use DirectScan for non-existent columns
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7242'>DRILL-7242</a>] -         Query with range predicate hits IOBE when accessing histogram buckets
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7245'>DRILL-7245</a>] -         TPCDS queries 1, 45, 65, 97 are 3x slower when Statistics is enabled at sf 100
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7250'>DRILL-7250</a>] -         Query with CTE fails when its name matches to the table name without access
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7257'>DRILL-7257</a>] -         [Text V3 Reader] dir0 is empty if a column filter returns all lines.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7258'>DRILL-7258</a>] -         [Text V3 Reader] Unsupported operation error is thrown when select a column with a long string
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7262'>DRILL-7262</a>] -         Parse Error appears on attempting to run several SQL queries at the same time in SQLLine
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7276'>DRILL-7276</a>] -         xss(bug) in apache drill Web UI latest verion 1.16.0 when authenticated 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7290'>DRILL-7290</a>] -         “Failed to construct kafka consumer” using Apache Drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7294'>DRILL-7294</a>] -         Prevent generating java beans using protostuff to avoid overriding classes with the same simple name declared as nested in the proto files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7297'>DRILL-7297</a>] -         Query hangs in planning stage when Error is thrown
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7306'>DRILL-7306</a>] -         Disable &quot;fast schema&quot; batch for new scan framework
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7307'>DRILL-7307</a>] -         casthigh for decimal type can lead to the issues with VarDecimalHolder
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7321'>DRILL-7321</a>] -         split function doesn&#39;t work without from
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7324'>DRILL-7324</a>] -         Many vector-validity errors from unit tests
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7327'>DRILL-7327</a>] -         Log Regex Plugin Won&#39;t Recognize Schema
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7332'>DRILL-7332</a>] -         Drill requires parentheses in the empty file for &#39;LOAD&#39; argument in the &#39;CREATE SCHEMA&#39; command
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7333'>DRILL-7333</a>] -         Batch of container count fixes
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7335'>DRILL-7335</a>] -         Error when reading csv file with headers only
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7338'>DRILL-7338</a>] -         REST API calls to Drill fail due to insufficient heap memory
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7341'>DRILL-7341</a>] -         Vector reAlloc may fails after exchange.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7345'>DRILL-7345</a>] -         Strange Behavior for UDFs with ComplexWriter Output
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7351'>DRILL-7351</a>] -         WebUI is Vulnerable to CSRF
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7353'>DRILL-7353</a>] -         Wrong driver class is written to the java.sql.Driver
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7358'>DRILL-7358</a>] -         Text reader returns nothing for count queries over empty files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7362'>DRILL-7362</a>] -         COUNT(*) on JSON with outer list results in JsonParse error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7367'>DRILL-7367</a>] -         Remove Server details from response headers
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7368'>DRILL-7368</a>] -         Query from Iceberg Metastore fails if filter column contains null
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7369'>DRILL-7369</a>] -         Schema for MaprDB tables is not used for the case when several fields are queried
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7372'>DRILL-7372</a>] -         MethodAnalyzer consumes too much memory
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7373'>DRILL-7373</a>] -         Fix problems involving reading from DICT type
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7376'>DRILL-7376</a>] -         Drill ignores Hive schema for MaprDB tables when group scan has star column
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7377'>DRILL-7377</a>] -         Can&#39;t Create Nested List using EVF with Late Schema
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7388'>DRILL-7388</a>] -         Apache Drill Kafka Storage module fails to return results for partitions containing single offset record
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7391'>DRILL-7391</a>] -         Wrong result when doing left outer join on CSV table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7394'>DRILL-7394</a>] -         JSON in Documentation Contains Typo
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7407'>DRILL-7407</a>] -         drill hive struct not support
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7413'>DRILL-7413</a>] -         Scan operator does not set the container record count
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7414'>DRILL-7414</a>] -         EVF incorrectly sets buffer writer index after rollover
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7424'>DRILL-7424</a>] -         Project operator fails to set the container row count
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7436'>DRILL-7436</a>] -         Fix record count, vector structure issues in several operators
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7439'>DRILL-7439</a>] -         Batch count fixes for six additional operators
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7440'>DRILL-7440</a>] -         Failure during loading of RepeatedCount functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7441'>DRILL-7441</a>] -         Fix issues with fillEmpties, offset vectors
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7446'>DRILL-7446</a>] -         Eclipse compilation issue in AbstractParquetGroupScan
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7448'>DRILL-7448</a>] -         Fix warnings when running Drill memory tests
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7450'>DRILL-7450</a>] -         Improve performance for ANALYZE command
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7456'>DRILL-7456</a>] -         Batch count fixes for 12 additional operators
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7462'>DRILL-7462</a>] -         Fix Links and Typos in Documentation 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7463'>DRILL-7463</a>] -         Apache license is not added to the generated classes
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7468'>DRILL-7468</a>] -         Metastore unit tests may fail when used sources from the release archive
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7469'>DRILL-7469</a>] -         Disable doclint for maven-javadoc-plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7470'>DRILL-7470</a>] -         drill-yarn unit tests print stack traces with NoSuchMethodError
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7471'>DRILL-7471</a>] -         describe table command fails with ClassCastException when metastore is enabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7472'>DRILL-7472</a>] -         Fix ser / de for sys and information_schema tables
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7473'>DRILL-7473</a>] -         Parquet reader failed to get field of repeated map
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7476'>DRILL-7476</a>] -         Info in some sys schema tables are missing if queried with limit clause
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7482'>DRILL-7482</a>] -         Fix missing artifact and overlapping classes warnings in Drill build
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7484'>DRILL-7484</a>] -         Malware found with some antiviruses in the Drill test resources folder
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7485'>DRILL-7485</a>] -         NPE on PCAP Batch Reader
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7490'>DRILL-7490</a>] -         limit is not pushed to JDBC storage plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7494'>DRILL-7494</a>] -         Unable to connect to Drill using JDBC driver when using custom authenticator
+</li>
+</ul>
+            
+<h2>        New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7326'>DRILL-7326</a>] -         Support repeated lists for CTAS parquet format
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7374'>DRILL-7374</a>] -         Support for IPV6 address
+</li>
+</ul>
+    
+<h2>        Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1709'>DRILL-1709</a>] -         desc =&gt; describe command
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1999'>DRILL-1999</a>] -         Drill should expose the Parquet logical schema rather than the physical schema
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4782'>DRILL-4782</a>] -         TO_TIME function cannot separate time from date time string
+</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-6332'>DRILL-6332</a>] -         DrillbitStartupException: Failure while initializing values in Drillbit
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6842'>DRILL-6842</a>] -         Export to CSV using CREATE TABLE AS (CTAS) wrong parsed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6951'>DRILL-6951</a>] -         Merge row set based mock data source
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6961'>DRILL-6961</a>] -         Error Occurred: Cannot connect to the db. query INFORMATION_SCHEMA.VIEWS : Maybe you have incorrect connection params or db unavailable now (timeout)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6974'>DRILL-6974</a>] -         SET option command
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6988'>DRILL-6988</a>] -         Utility of the too long error message when syntax error
+</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-7030'>DRILL-7030</a>] -         Make format plugins fully pluggable
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7174'>DRILL-7174</a>] -         Expose complex to Json control in the Drill C++ Client
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7206'>DRILL-7206</a>] -         Tuning hash join code using primitive int
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7222'>DRILL-7222</a>] -         Visualize estimated and actual row counts for a query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7261'>DRILL-7261</a>] -         Simplify Easy format config for new scan framework
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7278'>DRILL-7278</a>] -         Refactor result set loader projection mechanism
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7279'>DRILL-7279</a>] -         Support provided schema for CSV without headers
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7292'>DRILL-7292</a>] -         Remove V1, V2 text readers
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7293'>DRILL-7293</a>] -         Convert the regex (&quot;log&quot;) plugin to use EVF
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7302'>DRILL-7302</a>] -         Bump Apache Avro from 1.8.2 to 1.9.0
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7313'>DRILL-7313</a>] -         Use Hive schema for MaprDB native reader when field was empty and support all text mode
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7334'>DRILL-7334</a>] -         Update Iceberg Metastore Parquet write mode
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7385'>DRILL-7385</a>] -         Convert PCAP Format Plugin to EVF
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7402'>DRILL-7402</a>] -         Suppress batch dumps for expected failures in tests
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7403'>DRILL-7403</a>] -         Validate batch checks, vector integretity in unit tests
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7412'>DRILL-7412</a>] -         Minor unit test improvements
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7417'>DRILL-7417</a>] -         Add user logged in/out event in info level logs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7418'>DRILL-7418</a>] -         MetadataDirectGroupScan improvements
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7443'>DRILL-7443</a>] -         Enable PCAP Plugin to Reassemble TCP Streams
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7445'>DRILL-7445</a>] -         Create batch copier based on result set framework
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7486'>DRILL-7486</a>] -         Restructure row set reader builder
+</li>
+</ul>
+            
+<h2>        Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5506'>DRILL-5506</a>] -         Apache Drill Querying data from compressed .zip file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6642'>DRILL-6642</a>] -         Update protocol-buffers version
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6711'>DRILL-6711</a>] -         Use jitpack repository for Drill Calcite project artifacts instead of repository.mapr.com
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7236'>DRILL-7236</a>] -         SqlLine 1.8 upgrade
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7267'>DRILL-7267</a>] -         Add Slack Link in Documentation
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7314'>DRILL-7314</a>] -         Use TupleMetadata instead of concrete implementation
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7315'>DRILL-7315</a>] -         Revise precision and scale order in the method arguments
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7316'>DRILL-7316</a>] -         Move classes from org.apache.drill.metastore into org.apache.drill.exec.metastore package in java-exec module
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7317'>DRILL-7317</a>] -         Close ClassLoaders used for udf jars uploading when closing FunctionImplementationRegistry
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7339'>DRILL-7339</a>] -         Upgrade to Iceberg latest commits to fix issue with orphan files after delete in transaction
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7347'>DRILL-7347</a>] -         Upgrade Apache Iceberg to released version
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7350'>DRILL-7350</a>] -         Move RowSet related classes from test folder
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7360'>DRILL-7360</a>] -         Refactor WatchService code in Drillbit class
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7393'>DRILL-7393</a>] -         Revisit Drill tests to ensure that patching is executed before any test run
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7397'>DRILL-7397</a>] -         Fix logback errors when building the project
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7405'>DRILL-7405</a>] -         Build fails due to inaccessible apache-drill on S3 storage
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7409'>DRILL-7409</a>] -         Remove bigIntDictionary.parquet from project sources
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7453'>DRILL-7453</a>] -         Update joda-time to 2.10.5 to have correct time zone info
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7464'>DRILL-7464</a>] -         Apache Drill 1.17 Release Activities
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7474'>DRILL-7474</a>] -         Reduce size of Drill&#39;s tar.gz file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7479'>DRILL-7479</a>] -         Short-term fixes for metadata API parameterized type issues
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7481'>DRILL-7481</a>] -         Fix raw type warnings in Iceberg Metastore and related classes
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-7483'>DRILL-7483</a>] -         Add support for 12 and 13 java versions
+</li>
+</ul>
+                                                                                                                                            
+
diff --git a/_docs/tutorials/020-drill-in-10-minutes.md b/_docs/tutorials/020-drill-in-10-minutes.md
index ceb6848..2c1177c 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-05-02
+date: 2019-12-26
 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.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. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.17.0/apache-drill-1.17.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.17.0/apache-drill-1.17.0.tar.gz) with the command appropriate for your system:  
+       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.17.0/apache-drill-1.17.0.tar.gz`  
+       * `curl -o apache-drill-1.17.0.tar.gz http://apache.mirrors.hoobly.com/drill/drill-1.17.0/apache-drill-1.17.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 77075c4..354ceb7 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: 2019-05-02
+date: 2019-12-26
 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.16.0.tar
+    tar -xvf apache-drill-1.17.0.tar
 
 Install Drill locally on your desktop (embedded mode). You don’t need Hadoop.
 
diff --git a/blog/_posts/2019-12-26-drill-1.17-released.md b/blog/_posts/2019-12-26-drill-1.17-released.md
new file mode 100644
index 0000000..564bb8d
--- /dev/null
+++ b/blog/_posts/2019-12-26-drill-1.17-released.md
@@ -0,0 +1,32 @@
+---
+layout: post
+title: "Drill 1.17 Released"
+code: drill-1.17-released
+excerpt: Apache Drill 1.17's highlights are&#58; Hadoop, Kafka, Sqlline, and Calcite upgrades, .zip compression, file/table function for schema provisioning, new UDFs, and more.
+authors: ["bbevens"]
+---
+
+Today, we're happy to announce the availability of Drill 1.17.0. You can download it [here](https://drill.apache.org/download/).  
+
+This release provides the following bug fixes and improvements:
+
+## Hive complex types support:
+* <a href='https://issues.apache.org/jira/browse/DRILL-7251'>DRILL-7251</a> - Read Hive array without nulls
+* <a href='https://issues.apache.org/jira/browse/DRILL-7252'>DRILL-7252</a> - Read Hive map using Dict<K,V> vector
+* <a href='https://issues.apache.org/jira/browse/DRILL-7253'>DRILL-7253</a> - Read Hive struct without nulls
+* <a href='https://issues.apache.org/jira/browse/DRILL-7254'>DRILL-7254</a> - Read Hive union without nulls
+* <a href='https://issues.apache.org/jira/browse/DRILL-7268'>DRILL-7268</a> - Read Hive array with parquet native reader
+
+## New format plugins support:
+* <a href='https://issues.apache.org/jira/browse/DRILL-4303'>DRILL-4303</a> - ESRI Shapefile (shp) format plugin
+* <a href='https://issues.apache.org/jira/browse/DRILL-7177'>DRILL-7177</a> - Format Plugin for Excel Files
+* <a href='https://issues.apache.org/jira/browse/DRILL-6096'>DRILL-6096</a> - Provide mechanisms to specify field delimiters and quoted text for TextRecordWriter   
+* Parquet format improvements, including runtime row group pruning (<a href='https://issues.apache.org/jira/browse/DRILL-7062'>DRILL-7062</a>), empty parquet creation (<a href='https://issues.apache.org/jira/browse/DRILL-7156'>DRILL-7156</a>), reading (<a href='https://issues.apache.org/jira/browse/DRILL-4517'>DRILL-4517</a>) support, and more.
+
+## Metastore support:
+* <a href='https://issues.apache.org/jira/browse/DRILL-7272'>DRILL-7272</a> - Implement Drill Iceberg Metastore plugin
+* <a href='https://issues.apache.org/jira/browse/DRILL-7273'>DRILL-7273</a> - Create operator for handling metadata
+* <a href='https://issues.apache.org/jira/browse/DRILL-7357'>DRILL-7357</a> - Expose Drill Metastore data through INFORMATION_SCHEMA
+
+You can find a complete list of improvements and JIRAs resolved in the 1.17.0 release [here]({{site.baseurl}}/docs/apache-drill-1-17-0-release-notes/).
+