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 2017/07/31 04:45:55 UTC

[5/6] drill git commit: Doc updates for the Drill 1.11 Release

http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/003-1.8.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/003-1.8.0-rn.md b/_docs/rn/003-1.8.0-rn.md
deleted file mode 100644
index c577ad5..0000000
--- a/_docs/rn/003-1.8.0-rn.md
+++ /dev/null
@@ -1,173 +0,0 @@
----
-title: "Apache Drill 1.8.0 Release Notes"
-parent: "Release Notes"
----
-
-**Release date:**  August 30, 2016
-
-Today, we're happy to announce the availability of Drill 1.8.0. You can download it [here](https://drill.apache.org/download/).
-
-## New Features
-This release of Drill provides the following new features: 
-
-- Metadata cache pruning
-- IF EXISTS parameter with the DROP TABLE and DROP VIEW commands
-- DESCRIBE SCHEMA command
-- Multi-byte delimiter support
-- New parameters for filter selectivity estimates  
-
-## Configuration and Launch Script Changes 
-This release of Drill also includes the following changes to the configuration and launch scripts: 
-
-- The `$DRILL_HOME/conf/drill-env.sh` file has been simplified. Default Drill settings have moved out of this file and now reside in `$DRILL_HOME/bin/drill-config.sh`. The `drill-env.sh` file now ships with descriptions of the options that you can set. You can override many settings by creating an entry in `$DRILL_HOME/conf/drill-env.sh`.  ([DRILL-4581](https://issues.apache.org/jira/browse/DRILL-4581))  
-- Due to issues at high concurrency, the native Linux epoll transport is now disabled by default. ([DRILL-4623](https://issues.apache.org/jira/browse/DRILL-4623))  
- 
-Changes to the Drill launch scripts provide a new option that simplifies the Drill upgrade for Drill 1.8 and later. The new scripts support a “site directory” that holds site-specific files separate from the Drill product directory. The site directory is a simple extension of the config directory in previous Drill releases. You can add a “jars” subdirectory to the config directory for your custom jars instead of storing them in $DRILL_HOME. You can even add native libraries in the new “lib” directory and Drill automatically loads them. 
-
-Example:  
-
-       /my/conf/dir
-       |- drill-override.conf
-       |- drill-env.sh
-       |- jars
-          |- myudf.jar
-       |- lib
-          |- mysecurity.so
-
-To use the site directory:
-
-       drillbit.sh —site /my/conf/dir start
-
-Note that `--config` still works as well.
-
-You can set an environment variable for the directory:
-
-       export DRILL_CONF_DIR=/my/conf/dir
-       drillbit.sh start
-
-The site directory works with `drillbit.sh` and the various Drill client scripts.
-
-To upgrade Drill using the new site directory, just delete the old Drill product directory and expand the Drill archive to create a new one. There is no need to back up and merge files each time you upgrade because the site files are not affected by an upgrade. Using the site directory, you can have different site directories for different Drill sessions: one for development, another for test, and so on. You can use the site directory to run multiple Drill clusters from as single Drill installation by creating a site directory for each Drill cluster and then configuring Drill. 
-
-The following sections list additional bug fixes and improvements:  
-
-    
-<h2>        Sub-task
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4581'>DRILL-4581</a>] -         Various problems in the Drill startup scripts
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4728'>DRILL-4728</a>] -         Add support for new metadata fetch APIs
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4729'>DRILL-4729</a>] -         Add support for prepared statement implementation on server side
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4732'>DRILL-4732</a>] -         Update JDBC driver to use the new prepared statement APIs on DrillClient
-</li>
-</ul>
-                            
-<h2>        Bug
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3726'>DRILL-3726</a>] -         Drill is not properly interpreting CRLF (0d0a). CR gets read as content.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4147'>DRILL-4147</a>] -         Union All operator runs in a single fragment
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4175'>DRILL-4175</a>] -         IOBE may occur in Calcite RexProgramBuilder when queries are submitted concurrently
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4341'>DRILL-4341</a>] -         Fails to parse string literals containing escaped quotes
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4574'>DRILL-4574</a>] -         Avro Plugin: Flatten does not work correctly on record items
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4623'>DRILL-4623</a>] -         Disable Epoll by Default
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4658'>DRILL-4658</a>] -         cannot specify tab as a fieldDelimiter in table function
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4664'>DRILL-4664</a>] -         ScanBatch.isNewSchema() returns wrong result for map datatype
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4665'>DRILL-4665</a>] -         Partition pruning not working for hive partitioned table with &#39;LIKE&#39; and &#39;=&#39; filter
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4704'>DRILL-4704</a>] -         select statement behavior is inconsistent for decimal values in parquet
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4707'>DRILL-4707</a>] -         Conflicting columns names under case-insensitive policy lead to either memory leak or incorrect result
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4715'>DRILL-4715</a>] -         Java compilation error for a query with large number of expressions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4743'>DRILL-4743</a>] -         HashJoin&#39;s not fully parallelized in query plan
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4746'>DRILL-4746</a>] -         Verification Failures (Decimal values) in drill&#39;s regression tests
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4759'>DRILL-4759</a>] -         Drill throwing array index out of bound exception when reading a parquet file written by map reduce program.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4767'>DRILL-4767</a>] -         Parquet reader throw IllegalArgumentException for int32 type with GZIP compression
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4768'>DRILL-4768</a>] -         Drill may leak hive meta store connection if hive meta store client call hits error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4769'>DRILL-4769</a>] -         forman spins query int32 data with snappy compression
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4770'>DRILL-4770</a>] -         ParquetRecordReader throws NPE querying a single int64 column file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4783'>DRILL-4783</a>] -         Flatten on CONVERT_FROM fails with ClassCastException if resultset is empty
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4785'>DRILL-4785</a>] -         Limit 0 queries regressed in Drill 1.7.0 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4794'>DRILL-4794</a>] -         Regression: Wrong result for query with disjunctive partition filters
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4801'>DRILL-4801</a>] -         Setting extractHeader attribute for CSV format does not propagate to all drillbits 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4816'>DRILL-4816</a>] -         sqlline -f failed to read the query file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4825'>DRILL-4825</a>] -         Wrong data with UNION ALL when querying different sub-directories under the same table
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4833'>DRILL-4833</a>] -         Union-All with a small cardinality input on one side does not get parallelized
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4836'>DRILL-4836</a>] -         ZK Issue during Drillbit startup, possibly due to race condition
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4846'>DRILL-4846</a>] -         Eliminate extra operations during metadata cache pruning
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4852'>DRILL-4852</a>] -         COUNT(*) query against a large JSON table slower by 2x
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4854'>DRILL-4854</a>] -         Incorrect logic in log directory checks in drill-config.sh
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4857'>DRILL-4857</a>] -         When no partition pruning occurs with metadata caching there&#39;s a performance regression
-</li>
-</ul>
-                        
-<h2>        Improvement
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2330'>DRILL-2330</a>] -         Add support for nested aggregate expressions for window aggregates
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3149'>DRILL-3149</a>] -         TextReader should support multibyte line delimiters
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3710'>DRILL-3710</a>] -         Make the 20 in-list optimization configurable
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4530'>DRILL-4530</a>] -         Improve metadata cache performance for queries with single partition 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4751'>DRILL-4751</a>] -         Remove dumpcat script from Drill distribution
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4766'>DRILL-4766</a>] -         FragmentExecutor should use EventProcessor and avoid blocking rpc threads
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4786'>DRILL-4786</a>] -         Improve metadata cache performance for queries with multiple partitions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4822'>DRILL-4822</a>] -         Extend distrib-env.sh search to consider site directory
-</li>
-</ul>
-            
-<h2>        New Feature
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4514'>DRILL-4514</a>] -         Add describe schema &lt;schema_name&gt; command
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4673'>DRILL-4673</a>] -         Implement &quot;DROP TABLE IF EXISTS&quot; for drill to prevent FAILED status on command return
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4819'>DRILL-4819</a>] -         Update MapR version to 5.2.0
-</li>
-</ul>
-                                                        
-<h2>        Task
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4499'>DRILL-4499</a>] -         Remove unused classes
-</li>
-</ul>
-                
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/003-1.9.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/003-1.9.0-rn.md b/_docs/rn/003-1.9.0-rn.md
new file mode 100644
index 0000000..93710db
--- /dev/null
+++ b/_docs/rn/003-1.9.0-rn.md
@@ -0,0 +1,180 @@
+---
+title: "Apache Drill 1.9.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:**  November 29, 2016
+
+Today, we're happy to announce the availability of Drill 1.9.0. You can download it [here](https://drill.apache.org/download/).
+
+## New Features
+This release of Drill provides the following new features: 
+
+- Asynchronous Parquet reader
+- Parquet filter pushdown  
+- Dynamic UDF support  
+- HTTPD format plugin  
+
+The following sections list additional bug fixes and improvements:  
+
+<h2>        Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4420'>DRILL-4420</a>] -         C client and ODBC driver should move to using the new metadata methods provided by DRILL-4385
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4452'>DRILL-4452</a>] -         Update avatica version for Drill jdbc
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4560'>DRILL-4560</a>] -         ZKClusterCoordinator does not call DrillbitStatusListener.drillbitRegistered for new bits
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4968'>DRILL-4968</a>] -         Add column size information to ColumnMetadata
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4969'>DRILL-4969</a>] -         Basic implementation for displaySize
+</li>
+</ul>
+                            
+<h2>        Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1996'>DRILL-1996</a>] -         C++ Client: Make Cancel API Public
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3898'>DRILL-3898</a>] -         No space error during external sort does not cancel the query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4203'>DRILL-4203</a>] -         Parquet File : Date is stored wrongly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4369'>DRILL-4369</a>] -         Database driver fails to report any major or minor version information
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4370'>DRILL-4370</a>] -         DatabaseMetadata returning &lt;Properties resource apache-drill-jdbc.properties not loaded&gt;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4525'>DRILL-4525</a>] -         Query with BETWEEN clause on Date and Timestamp values fails with Validation Error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4542'>DRILL-4542</a>] -         if external sort fails to spill to disk, memory is leaked and wrong error message is displayed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4618'>DRILL-4618</a>] -         random numbers generator function broken
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4763'>DRILL-4763</a>] -         Parquet file with DATE logical type produces wrong results for simple SELECT
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4767'>DRILL-4767</a>] -         Parquet reader throw IllegalArgumentException for int32 type with GZIP compression
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4769'>DRILL-4769</a>] -         forman spins query int32 data with snappy compression
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4770'>DRILL-4770</a>] -         ParquetRecordReader throws NPE querying a single int64 column file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4823'>DRILL-4823</a>] -         Fix OOM while trying to prune partitions with reasonable data size
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4824'>DRILL-4824</a>] -         JSON with complex nested data produces incorrect output with missing fields
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4826'>DRILL-4826</a>] -         Query against INFORMATION_SCHEMA.TABLES degrades as the number of views increases
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4862'>DRILL-4862</a>] -         wrong results - use of convert_from(binary_string(key),&#39;UTF8&#39;) in filter results in wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4870'>DRILL-4870</a>] -         drill-config.sh sets JAVA_HOME incorrectly for the Mac
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4874'>DRILL-4874</a>] -         &quot;No UserGroupInformation while generating ORC splits&quot; - hive known issue in 1.2.0-mapr-1607 release.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4877'>DRILL-4877</a>] -         max(dir0), max(dir1) query against parquet data slower by 2X
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4880'>DRILL-4880</a>] -         Support JDBC driver registration using ServiceLoader 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4884'>DRILL-4884</a>] -         Fix IOB exception in limit n query when n is beyond 65535.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4888'>DRILL-4888</a>] -         putIfAbsent for ZK stores is not atomic
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4894'>DRILL-4894</a>] -         Fix unit test failure in &#39;storage-hive/core&#39; module
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4905'>DRILL-4905</a>] -         Push down the LIMIT to the parquet reader scan to limit the numbers of records read
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4906'>DRILL-4906</a>] -         CASE Expression with constant generates class exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4911'>DRILL-4911</a>] -         SimpleParallelizer should avoid plan serialization for logging purpose when debug logging is not enabled.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4921'>DRILL-4921</a>] -         Scripts drill_config.sh,  drillbit.sh, and drill-embedded fail when accessed via a symbolic link
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4925'>DRILL-4925</a>] -         Add types filter to getTables metadata API
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4930'>DRILL-4930</a>] -         Metadata results are not sorted
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4934'>DRILL-4934</a>] -         ServiceEngine does not use property useIP for DrillbitStartup
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4941'>DRILL-4941</a>] -         UnsupportedOperationException : CASE WHEN true or null then 1 else 0 end
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4945'>DRILL-4945</a>] -         Missing subtype information in metadata returned by prepared statement
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4950'>DRILL-4950</a>] -         Consume Spurious Empty Batches in JDBC
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4954'>DRILL-4954</a>] -         allTextMode in the MapRDB plugin always return nulls
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4964'>DRILL-4964</a>] -         Drill fails to connect to hive metastore after hive metastore is restarted unless drillbits are restarted also
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4972'>DRILL-4972</a>] -         Drillbit shuts down immediately after starting if embedded web server is disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4974'>DRILL-4974</a>] -         NPE in FindPartitionConditions.analyzeCall() for &#39;holistic&#39; expressions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4989'>DRILL-4989</a>] -         Fix TestParquetWriter.testImpalaParquetBinaryAsTimeStamp_DictChange
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4990'>DRILL-4990</a>] -         Use new HDFS API access instead of listStatus to check if users have permissions to access workspace.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4993'>DRILL-4993</a>] -         Documentation: Wrong output displayed for convert_from() with a map
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5004'>DRILL-5004</a>] -         Parquet date correction gives null pointer exception if there is no createdBy entry in the metadata
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5007'>DRILL-5007</a>] -         Dynamic UDF lazy-init does not work correctly in multi-node cluster
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5009'>DRILL-5009</a>] -         Query with a simple join fails on Hive generated parquet
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5047'>DRILL-5047</a>] -         When session option is string, query profile is displayed incorrectly on Web UI
+</li>
+</ul>
+                        
+<h2>        Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1950'>DRILL-1950</a>] -         Implement filter pushdown for Parquet
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3178'>DRILL-3178</a>] -         csv reader should allow newlines inside quotes 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4653'>DRILL-4653</a>] -         Malformed JSON should not stop the entire query from progressing
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4674'>DRILL-4674</a>] -         Allow casting to boolean the same literals as in Postgre
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4752'>DRILL-4752</a>] -         Remove submit_plan script from Drill distribution
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4771'>DRILL-4771</a>] -         Drill should avoid doing the same join twice if count(distinct) exists
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4792'>DRILL-4792</a>] -         Include session options used for a query as part of the profile
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4800'>DRILL-4800</a>] -         Improve parquet reader performance
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4927'>DRILL-4927</a>] -         Add support for Null Equality Joins
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4967'>DRILL-4967</a>] -         Adding template_name to source code generated using freemarker template
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4986'>DRILL-4986</a>] -         Allow users to customize the Drill log file name
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4987'>DRILL-4987</a>] -         Use ImpersonationUtil in RemoteFunctionRegistry
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5031'>DRILL-5031</a>] -         Documentation for HTTPD Parser
+</li>
+</ul>
+            
+<h2>        New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1268'>DRILL-1268</a>] -         C++ Client. Write Unit Test for Drill Client
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3423'>DRILL-3423</a>] -         Add New HTTPD format plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4714'>DRILL-4714</a>] -         Add metadata and prepared statement APIs to DrillClient&lt;-&gt;Drillbit interface
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4726'>DRILL-4726</a>] -         Dynamic UDFs support
+</li>
+</ul>
+                                                        
+<h2>        Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4853'>DRILL-4853</a>] -         Update C++ protobuf source files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4886'>DRILL-4886</a>] -         Merge maprdb format plugin source code
+</li>
+</ul>
+                
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/004-1.7.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/004-1.7.0-rn.md b/_docs/rn/004-1.7.0-rn.md
deleted file mode 100644
index 454ca28..0000000
--- a/_docs/rn/004-1.7.0-rn.md
+++ /dev/null
@@ -1,159 +0,0 @@
----
-title: "Apache Drill 1.7.0 Release Notes"
-parent: "Release Notes"
----
-
-**Release date:**  June 28, 2016
-
-Today, we're happy to announce the availability of Drill 1.7.0. You can download it [here](https://drill.apache.org/download/).
-
-This release provides Monitoring via JMX, Hive CHAR data type support, HBase 1.x support, and the following bug fixes and improvements:  
-    
-<h2>        Sub-task
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4372'>DRILL-4372</a>] -         Drill Operators and Functions should correctly expose their types within Calcite
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4487'>DRILL-4487</a>] -         add unit test for DRILL-4449
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4725'>DRILL-4725</a>] -         Improvements to InfoSchema RecordGenerator needed for DRILL-4714
-</li>
-</ul>
-                            
-<h2>        Bug
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2100'>DRILL-2100</a>] -         Drill not deleting spooling files
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2385'>DRILL-2385</a>] -         count on complex objects failed with missing function implementation
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2593'>DRILL-2593</a>] -         500 error when crc for a query profile is out of sync
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3705'>DRILL-3705</a>] -         Query runs out of memory, reported as FAILED and leaves thread running 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3714'>DRILL-3714</a>] -         Query runs out of memory and remains in CANCELLATION_REQUESTED state until drillbit is restarted
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3743'>DRILL-3743</a>] -         query hangs on sqlline once Drillbit on foreman node is killed
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3745'>DRILL-3745</a>] -         Hive CHAR not supported
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3763'>DRILL-3763</a>] -         Cancel (Ctrl-C) one of concurrent queries results in ChannelClosedException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3826'>DRILL-3826</a>] -         Concurrent Query Submission leads to Channel Closed Exception
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3833'>DRILL-3833</a>] -         Concurrent Queries Failed Unexpectedly
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4143'>DRILL-4143</a>] -         REFRESH TABLE METADATA - Permission Issues with metadata files
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4237'>DRILL-4237</a>] -         Skew in hash distribution
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4298'>DRILL-4298</a>] -         SYSTEM ERROR: ChannelClosedException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4317'>DRILL-4317</a>] -         Exceptions on SELECT and CTAS with large CSV files
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4376'>DRILL-4376</a>] -         Wrong results when doing a count(*) on part of directories with metadata cache
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4459'>DRILL-4459</a>] -         SchemaChangeException while querying hive json table
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4472'>DRILL-4472</a>] -         Pushing Filter past Union All fails: DRILL-3257 regressed DRILL-2746 but unit test update break test goal
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4476'>DRILL-4476</a>] -         Enhance Union-All operator for dealing with empty left input or empty both inputs
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4478'>DRILL-4478</a>] -         binary_string cannot convert buffer that were not start from 0 correctly
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4479'>DRILL-4479</a>] -         JsonReader should pick a less restrictive type when creating the default column
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4484'>DRILL-4484</a>] -         NPE when querying  empty directory 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4490'>DRILL-4490</a>] -         Count(*) function returns as optional instead of required
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4494'>DRILL-4494</a>] -         Window sum over integer column returns incorrect results.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4529'>DRILL-4529</a>] -         SUM() with windows function result in mismatch nullability
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4531'>DRILL-4531</a>] -         Query with filter and aggregate hangs in planning phase
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4589'>DRILL-4589</a>] -         Reduce planning time for file system partition pruning by reducing filter evaluation overhead
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4592'>DRILL-4592</a>] -         Explain plan statement should show plan in WebUi
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4593'>DRILL-4593</a>] -         Remove OldAssignmentCreator in FileSystemPlugin
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4614'>DRILL-4614</a>] -         Drill must appoint one data type per one column for self-describing data while querying directories 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4657'>DRILL-4657</a>] -         Rank() will return wrong results if a frame of data is too big (more than 2 batches)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4676'>DRILL-4676</a>] -         Foreman.moveToState can block forever if called by the foreman thread while the query is still being setup
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4679'>DRILL-4679</a>] -         CONVERT_FROM()  json format fails if 0 rows are received from upstream operator
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4688'>DRILL-4688</a>] -         String functions may produce incorrect result when input has multi-byte character
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4701'>DRILL-4701</a>] -         Fix log name and missing lines in logs on Web UI
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4716'>DRILL-4716</a>] -         status.json doesn&#39;t work in drill ui
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4727'>DRILL-4727</a>] -         Exclude netty from HBase Client&#39;s transitive dependencies
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4733'>DRILL-4733</a>] -         max(dir0) reading more columns than necessary
-</li>
-</ul>
-                        
-<h2>        Improvement
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3559'>DRILL-3559</a>] -         Make filename available to sql statments just like dirN
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3894'>DRILL-3894</a>] -         Directory functions (MaxDir, MinDir ..) should have optional filename parameter
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4501'>DRILL-4501</a>] -         Complete MapOrListWriter for all supported data types
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4523'>DRILL-4523</a>] -         Disallow using loopback address in distributed mode
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4544'>DRILL-4544</a>] -         Improve error messages for REFRESH TABLE METADATA command
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4549'>DRILL-4549</a>] -         Add support for more truncation units in date_trunc function
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4571'>DRILL-4571</a>] -         Add link to local Drill logs from the web UI
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4573'>DRILL-4573</a>] -         Zero copy LIKE, REGEXP_MATCHES, SUBSTR
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4577'>DRILL-4577</a>] -         Improve performance for query on INFORMATION_SCHEMA when HIVE is plugged in
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4584'>DRILL-4584</a>] -         JDBC/ODBC Client IP in Drill audit logs
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4654'>DRILL-4654</a>] -         Expose New System Metrics
-</li>
-</ul>
-            
-<h2>        New Feature
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3474'>DRILL-3474</a>] -         Add implicit file columns support
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4132'>DRILL-4132</a>] -         Ability to submit simple type of physical plan directly to EndPoint DrillBit for execution
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4199'>DRILL-4199</a>] -         Add Support for HBase 1.X
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4446'>DRILL-4446</a>] -         Improve current fragment parallelization module
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4607'>DRILL-4607</a>] -         Add a split function that allows to separate string by a delimiter
-</li>
-</ul>
-                                                        
-<h2>        Task
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4050'>DRILL-4050</a>] -         Add zip archives to the list of artifacts in verify_release.sh
-</li>
-</ul>
-        
-<h2>        Test
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4170'>DRILL-4170</a>] -         how many concurrent users can be supported
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4437'>DRILL-4437</a>] -         Implement framework for testing operators in isolation
-</li>
-</ul>
-        
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/004-1.8.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/004-1.8.0-rn.md b/_docs/rn/004-1.8.0-rn.md
new file mode 100644
index 0000000..c577ad5
--- /dev/null
+++ b/_docs/rn/004-1.8.0-rn.md
@@ -0,0 +1,173 @@
+---
+title: "Apache Drill 1.8.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:**  August 30, 2016
+
+Today, we're happy to announce the availability of Drill 1.8.0. You can download it [here](https://drill.apache.org/download/).
+
+## New Features
+This release of Drill provides the following new features: 
+
+- Metadata cache pruning
+- IF EXISTS parameter with the DROP TABLE and DROP VIEW commands
+- DESCRIBE SCHEMA command
+- Multi-byte delimiter support
+- New parameters for filter selectivity estimates  
+
+## Configuration and Launch Script Changes 
+This release of Drill also includes the following changes to the configuration and launch scripts: 
+
+- The `$DRILL_HOME/conf/drill-env.sh` file has been simplified. Default Drill settings have moved out of this file and now reside in `$DRILL_HOME/bin/drill-config.sh`. The `drill-env.sh` file now ships with descriptions of the options that you can set. You can override many settings by creating an entry in `$DRILL_HOME/conf/drill-env.sh`.  ([DRILL-4581](https://issues.apache.org/jira/browse/DRILL-4581))  
+- Due to issues at high concurrency, the native Linux epoll transport is now disabled by default. ([DRILL-4623](https://issues.apache.org/jira/browse/DRILL-4623))  
+ 
+Changes to the Drill launch scripts provide a new option that simplifies the Drill upgrade for Drill 1.8 and later. The new scripts support a “site directory” that holds site-specific files separate from the Drill product directory. The site directory is a simple extension of the config directory in previous Drill releases. You can add a “jars” subdirectory to the config directory for your custom jars instead of storing them in $DRILL_HOME. You can even add native libraries in the new “lib” directory and Drill automatically loads them. 
+
+Example:  
+
+       /my/conf/dir
+       |- drill-override.conf
+       |- drill-env.sh
+       |- jars
+          |- myudf.jar
+       |- lib
+          |- mysecurity.so
+
+To use the site directory:
+
+       drillbit.sh —site /my/conf/dir start
+
+Note that `--config` still works as well.
+
+You can set an environment variable for the directory:
+
+       export DRILL_CONF_DIR=/my/conf/dir
+       drillbit.sh start
+
+The site directory works with `drillbit.sh` and the various Drill client scripts.
+
+To upgrade Drill using the new site directory, just delete the old Drill product directory and expand the Drill archive to create a new one. There is no need to back up and merge files each time you upgrade because the site files are not affected by an upgrade. Using the site directory, you can have different site directories for different Drill sessions: one for development, another for test, and so on. You can use the site directory to run multiple Drill clusters from as single Drill installation by creating a site directory for each Drill cluster and then configuring Drill. 
+
+The following sections list additional bug fixes and improvements:  
+
+    
+<h2>        Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4581'>DRILL-4581</a>] -         Various problems in the Drill startup scripts
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4728'>DRILL-4728</a>] -         Add support for new metadata fetch APIs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4729'>DRILL-4729</a>] -         Add support for prepared statement implementation on server side
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4732'>DRILL-4732</a>] -         Update JDBC driver to use the new prepared statement APIs on DrillClient
+</li>
+</ul>
+                            
+<h2>        Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3726'>DRILL-3726</a>] -         Drill is not properly interpreting CRLF (0d0a). CR gets read as content.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4147'>DRILL-4147</a>] -         Union All operator runs in a single fragment
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4175'>DRILL-4175</a>] -         IOBE may occur in Calcite RexProgramBuilder when queries are submitted concurrently
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4341'>DRILL-4341</a>] -         Fails to parse string literals containing escaped quotes
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4574'>DRILL-4574</a>] -         Avro Plugin: Flatten does not work correctly on record items
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4623'>DRILL-4623</a>] -         Disable Epoll by Default
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4658'>DRILL-4658</a>] -         cannot specify tab as a fieldDelimiter in table function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4664'>DRILL-4664</a>] -         ScanBatch.isNewSchema() returns wrong result for map datatype
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4665'>DRILL-4665</a>] -         Partition pruning not working for hive partitioned table with &#39;LIKE&#39; and &#39;=&#39; filter
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4704'>DRILL-4704</a>] -         select statement behavior is inconsistent for decimal values in parquet
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4707'>DRILL-4707</a>] -         Conflicting columns names under case-insensitive policy lead to either memory leak or incorrect result
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4715'>DRILL-4715</a>] -         Java compilation error for a query with large number of expressions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4743'>DRILL-4743</a>] -         HashJoin&#39;s not fully parallelized in query plan
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4746'>DRILL-4746</a>] -         Verification Failures (Decimal values) in drill&#39;s regression tests
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4759'>DRILL-4759</a>] -         Drill throwing array index out of bound exception when reading a parquet file written by map reduce program.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4767'>DRILL-4767</a>] -         Parquet reader throw IllegalArgumentException for int32 type with GZIP compression
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4768'>DRILL-4768</a>] -         Drill may leak hive meta store connection if hive meta store client call hits error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4769'>DRILL-4769</a>] -         forman spins query int32 data with snappy compression
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4770'>DRILL-4770</a>] -         ParquetRecordReader throws NPE querying a single int64 column file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4783'>DRILL-4783</a>] -         Flatten on CONVERT_FROM fails with ClassCastException if resultset is empty
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4785'>DRILL-4785</a>] -         Limit 0 queries regressed in Drill 1.7.0 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4794'>DRILL-4794</a>] -         Regression: Wrong result for query with disjunctive partition filters
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4801'>DRILL-4801</a>] -         Setting extractHeader attribute for CSV format does not propagate to all drillbits 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4816'>DRILL-4816</a>] -         sqlline -f failed to read the query file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4825'>DRILL-4825</a>] -         Wrong data with UNION ALL when querying different sub-directories under the same table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4833'>DRILL-4833</a>] -         Union-All with a small cardinality input on one side does not get parallelized
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4836'>DRILL-4836</a>] -         ZK Issue during Drillbit startup, possibly due to race condition
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4846'>DRILL-4846</a>] -         Eliminate extra operations during metadata cache pruning
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4852'>DRILL-4852</a>] -         COUNT(*) query against a large JSON table slower by 2x
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4854'>DRILL-4854</a>] -         Incorrect logic in log directory checks in drill-config.sh
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4857'>DRILL-4857</a>] -         When no partition pruning occurs with metadata caching there&#39;s a performance regression
+</li>
+</ul>
+                        
+<h2>        Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2330'>DRILL-2330</a>] -         Add support for nested aggregate expressions for window aggregates
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3149'>DRILL-3149</a>] -         TextReader should support multibyte line delimiters
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3710'>DRILL-3710</a>] -         Make the 20 in-list optimization configurable
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4530'>DRILL-4530</a>] -         Improve metadata cache performance for queries with single partition 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4751'>DRILL-4751</a>] -         Remove dumpcat script from Drill distribution
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4766'>DRILL-4766</a>] -         FragmentExecutor should use EventProcessor and avoid blocking rpc threads
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4786'>DRILL-4786</a>] -         Improve metadata cache performance for queries with multiple partitions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4822'>DRILL-4822</a>] -         Extend distrib-env.sh search to consider site directory
+</li>
+</ul>
+            
+<h2>        New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4514'>DRILL-4514</a>] -         Add describe schema &lt;schema_name&gt; command
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4673'>DRILL-4673</a>] -         Implement &quot;DROP TABLE IF EXISTS&quot; for drill to prevent FAILED status on command return
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4819'>DRILL-4819</a>] -         Update MapR version to 5.2.0
+</li>
+</ul>
+                                                        
+<h2>        Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4499'>DRILL-4499</a>] -         Remove unused classes
+</li>
+</ul>
+                
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/005-1.6.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/005-1.6.0-rn.md b/_docs/rn/005-1.6.0-rn.md
deleted file mode 100644
index 3894261..0000000
--- a/_docs/rn/005-1.6.0-rn.md
+++ /dev/null
@@ -1,126 +0,0 @@
----
-title: "Apache Drill 1.6.0 Release Notes"
-parent: "Release Notes"
----
-
-**Release date:**  March 16, 2016
-
-Today, we're happy to announce the availability of Drill 1.6.0. You can download it [here](https://drill.apache.org/download/).
-
-This release provides inbound impersonation, additional custom window frames, and the following bug fixes and improvements:  
-
-<h2>        Sub-task
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3488'>DRILL-3488</a>] -         Allow Java 1.8
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4261'>DRILL-4261</a>] -         add support for RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4262'>DRILL-4262</a>] -         add support for ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4263'>DRILL-4263</a>] -         add support for RANGE BETWEEN CURRENT ROW AND CURRENT ROW
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4331'>DRILL-4331</a>] -         TestFlattenPlanning.testFlattenPlanningAvoidUnnecessaryProject fail in Java 8
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4332'>DRILL-4332</a>] -         tests in TestFrameworkTest fail in Java 8
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4334'>DRILL-4334</a>] -         tests in TestMongoFilterPushDown fail in Java 8
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4465'>DRILL-4465</a>] -         Refactor Parsing and Planning to canonicalize planning and parsing
-</li>
-</ul>
-                            
-<h2>        Bug
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3547'>DRILL-3547</a>] -         IndexOutOfBoundsException on directory with ~20 subdirectories
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3581'>DRILL-3581</a>] -         Google Guava version is so old it causes incompatibilities with other libs
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3688'>DRILL-3688</a>] -         Drill should honor &quot;skip.header.line.count&quot; and &quot;skip.footer.line.count&quot; attributes of Hive table
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4225'>DRILL-4225</a>] -         TestDateFunctions#testToChar fails when the locale is non-English
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4279'>DRILL-4279</a>] -         Improve performance for skipAll query against Text/JSON/Parquet table
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4287'>DRILL-4287</a>] -         Do lazy reading of parquet metadata cache file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4323'>DRILL-4323</a>] -         Hive Native Reader : A simple count(*) throws Incoming batch has an empty schema error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4339'>DRILL-4339</a>] -         Avro Reader can not read records - Regression
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4354'>DRILL-4354</a>] -         Remove sessions in anonymous (user auth disabled) mode in WebUI server
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4375'>DRILL-4375</a>] -         Fix the maven release profile, broken by jdbc jar size enforcer added in DRILL-4291
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4384'>DRILL-4384</a>] -         Query profile is missing important information on WebUi
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4387'>DRILL-4387</a>] -         Improve execution side when it handles skipAll query
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4392'>DRILL-4392</a>] -         CTAS with partition writes an internal field into generated parquet files
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4410'>DRILL-4410</a>] -         ListVector causes OversizedAllocationException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4434'>DRILL-4434</a>] -         Remove (or deprecate) GroupScan.enforceWidth and use GroupScan.getMinParallelization
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4441'>DRILL-4441</a>] -         IN operator does not work with Avro reader
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4443'>DRILL-4443</a>] -         MIN/MAX on VARCHAR throw a NullPointerException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4449'>DRILL-4449</a>] -         Wrong results when using metadata cache with specific set of queries
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4457'>DRILL-4457</a>] -         Difference in results returned by window function over BIGINT data
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4467'>DRILL-4467</a>] -         Invalid projection created using PrelUtil.getColumns
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4474'>DRILL-4474</a>] -         Inconsistent behavior while using COUNT in select (Apache drill 1.2.0)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4482'>DRILL-4482</a>] -         Avro no longer selects data correctly from a sub-structure
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4483'>DRILL-4483</a>] -         Fix text plan issue in query profiles
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4486'>DRILL-4486</a>] -         Expression serializer incorrectly serializes escaped characters
-</li>
-</ul>
-                        
-<h2>        Improvement
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4260'>DRILL-4260</a>] -         Adding support for some custom window frames
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4297'>DRILL-4297</a>] -         Provide a new interface to send custom messages
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4313'>DRILL-4313</a>] -         C++ client - Improve method of drillbit selection from cluster
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4327'>DRILL-4327</a>] -         Fix rawtypes warning emitted by compiler
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4359'>DRILL-4359</a>] -         EndpointAffinity missing equals method
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4361'>DRILL-4361</a>] -         Allow for FileSystemPlugin subclasses to override FormatCreator
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4363'>DRILL-4363</a>] -         Apply row count based pruning for parquet table in LIMIT n query
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4383'>DRILL-4383</a>] -         Allow passign custom configuration options to a file system through the storage plugin config
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4423'>DRILL-4423</a>] -         TestCsvHeader#testEmptyFinalColumn is causing the unit test framework to print 10K rows in Stdout
-</li>
-</ul>
-            
-<h2>        New Feature
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2517'>DRILL-2517</a>] -         Apply Partition pruning before reading files during planning
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4314'>DRILL-4314</a>] -         Unit Test Framework Enhancement: Schema check for zero-row query
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4485'>DRILL-4485</a>] -         MapR profile - use MapR 5.1.0
-</li>
-</ul>
-                                                        
-<h2>        Task
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4295'>DRILL-4295</a>] -         Obsolete protobuf generated files under protocol/
-</li>
-</ul>
-                
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/005-1.7.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/005-1.7.0-rn.md b/_docs/rn/005-1.7.0-rn.md
new file mode 100644
index 0000000..454ca28
--- /dev/null
+++ b/_docs/rn/005-1.7.0-rn.md
@@ -0,0 +1,159 @@
+---
+title: "Apache Drill 1.7.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:**  June 28, 2016
+
+Today, we're happy to announce the availability of Drill 1.7.0. You can download it [here](https://drill.apache.org/download/).
+
+This release provides Monitoring via JMX, Hive CHAR data type support, HBase 1.x support, and the following bug fixes and improvements:  
+    
+<h2>        Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4372'>DRILL-4372</a>] -         Drill Operators and Functions should correctly expose their types within Calcite
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4487'>DRILL-4487</a>] -         add unit test for DRILL-4449
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4725'>DRILL-4725</a>] -         Improvements to InfoSchema RecordGenerator needed for DRILL-4714
+</li>
+</ul>
+                            
+<h2>        Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2100'>DRILL-2100</a>] -         Drill not deleting spooling files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2385'>DRILL-2385</a>] -         count on complex objects failed with missing function implementation
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2593'>DRILL-2593</a>] -         500 error when crc for a query profile is out of sync
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3705'>DRILL-3705</a>] -         Query runs out of memory, reported as FAILED and leaves thread running 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3714'>DRILL-3714</a>] -         Query runs out of memory and remains in CANCELLATION_REQUESTED state until drillbit is restarted
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3743'>DRILL-3743</a>] -         query hangs on sqlline once Drillbit on foreman node is killed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3745'>DRILL-3745</a>] -         Hive CHAR not supported
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3763'>DRILL-3763</a>] -         Cancel (Ctrl-C) one of concurrent queries results in ChannelClosedException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3826'>DRILL-3826</a>] -         Concurrent Query Submission leads to Channel Closed Exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3833'>DRILL-3833</a>] -         Concurrent Queries Failed Unexpectedly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4143'>DRILL-4143</a>] -         REFRESH TABLE METADATA - Permission Issues with metadata files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4237'>DRILL-4237</a>] -         Skew in hash distribution
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4298'>DRILL-4298</a>] -         SYSTEM ERROR: ChannelClosedException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4317'>DRILL-4317</a>] -         Exceptions on SELECT and CTAS with large CSV files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4376'>DRILL-4376</a>] -         Wrong results when doing a count(*) on part of directories with metadata cache
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4459'>DRILL-4459</a>] -         SchemaChangeException while querying hive json table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4472'>DRILL-4472</a>] -         Pushing Filter past Union All fails: DRILL-3257 regressed DRILL-2746 but unit test update break test goal
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4476'>DRILL-4476</a>] -         Enhance Union-All operator for dealing with empty left input or empty both inputs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4478'>DRILL-4478</a>] -         binary_string cannot convert buffer that were not start from 0 correctly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4479'>DRILL-4479</a>] -         JsonReader should pick a less restrictive type when creating the default column
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4484'>DRILL-4484</a>] -         NPE when querying  empty directory 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4490'>DRILL-4490</a>] -         Count(*) function returns as optional instead of required
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4494'>DRILL-4494</a>] -         Window sum over integer column returns incorrect results.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4529'>DRILL-4529</a>] -         SUM() with windows function result in mismatch nullability
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4531'>DRILL-4531</a>] -         Query with filter and aggregate hangs in planning phase
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4589'>DRILL-4589</a>] -         Reduce planning time for file system partition pruning by reducing filter evaluation overhead
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4592'>DRILL-4592</a>] -         Explain plan statement should show plan in WebUi
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4593'>DRILL-4593</a>] -         Remove OldAssignmentCreator in FileSystemPlugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4614'>DRILL-4614</a>] -         Drill must appoint one data type per one column for self-describing data while querying directories 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4657'>DRILL-4657</a>] -         Rank() will return wrong results if a frame of data is too big (more than 2 batches)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4676'>DRILL-4676</a>] -         Foreman.moveToState can block forever if called by the foreman thread while the query is still being setup
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4679'>DRILL-4679</a>] -         CONVERT_FROM()  json format fails if 0 rows are received from upstream operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4688'>DRILL-4688</a>] -         String functions may produce incorrect result when input has multi-byte character
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4701'>DRILL-4701</a>] -         Fix log name and missing lines in logs on Web UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4716'>DRILL-4716</a>] -         status.json doesn&#39;t work in drill ui
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4727'>DRILL-4727</a>] -         Exclude netty from HBase Client&#39;s transitive dependencies
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4733'>DRILL-4733</a>] -         max(dir0) reading more columns than necessary
+</li>
+</ul>
+                        
+<h2>        Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3559'>DRILL-3559</a>] -         Make filename available to sql statments just like dirN
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3894'>DRILL-3894</a>] -         Directory functions (MaxDir, MinDir ..) should have optional filename parameter
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4501'>DRILL-4501</a>] -         Complete MapOrListWriter for all supported data types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4523'>DRILL-4523</a>] -         Disallow using loopback address in distributed mode
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4544'>DRILL-4544</a>] -         Improve error messages for REFRESH TABLE METADATA command
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4549'>DRILL-4549</a>] -         Add support for more truncation units in date_trunc function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4571'>DRILL-4571</a>] -         Add link to local Drill logs from the web UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4573'>DRILL-4573</a>] -         Zero copy LIKE, REGEXP_MATCHES, SUBSTR
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4577'>DRILL-4577</a>] -         Improve performance for query on INFORMATION_SCHEMA when HIVE is plugged in
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4584'>DRILL-4584</a>] -         JDBC/ODBC Client IP in Drill audit logs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4654'>DRILL-4654</a>] -         Expose New System Metrics
+</li>
+</ul>
+            
+<h2>        New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3474'>DRILL-3474</a>] -         Add implicit file columns support
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4132'>DRILL-4132</a>] -         Ability to submit simple type of physical plan directly to EndPoint DrillBit for execution
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4199'>DRILL-4199</a>] -         Add Support for HBase 1.X
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4446'>DRILL-4446</a>] -         Improve current fragment parallelization module
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4607'>DRILL-4607</a>] -         Add a split function that allows to separate string by a delimiter
+</li>
+</ul>
+                                                        
+<h2>        Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4050'>DRILL-4050</a>] -         Add zip archives to the list of artifacts in verify_release.sh
+</li>
+</ul>
+        
+<h2>        Test
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4170'>DRILL-4170</a>] -         how many concurrent users can be supported
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4437'>DRILL-4437</a>] -         Implement framework for testing operators in isolation
+</li>
+</ul>
+        
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/006-1.5.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/006-1.5.0-rn.md b/_docs/rn/006-1.5.0-rn.md
deleted file mode 100644
index 6a8be3c..0000000
--- a/_docs/rn/006-1.5.0-rn.md
+++ /dev/null
@@ -1,162 +0,0 @@
----
-title: "Apache Drill 1.5.0 Release Notes"
-parent: "Release Notes"
----
-
-**Release date:**  February 16, 2016
-
-Today, we're happy to announce the availability of Drill 1.5.0. You can download it [here](https://drill.apache.org/download/).
-
-This release provides [authentication and security for the Web interface and REST API]({{site.baseurl}}/docs/configuring-web-console-and-rest-api-security/), experimental query support for Apache Kudu (incubating), an [improved memory allocator]({{site.baseurl}}/docs/configuring-drill-memory/), [configurable caching for Hive metadata]({{site.baseurl}}/docs/hive-metadata-caching/), and the following bug fixes and improvements:
-
-
-    
-<h2>        Sub-task
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4131'>DRILL-4131</a>] -         Update RPC layer to use child allocators of the RootAllocator rather than using the PooledByteBufAllocatorL directly
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4187'>DRILL-4187</a>] -         Introduce a state to separate queries pending execution from those pending in the queue.
-</li>
-</ul>
-                            
-<h2>        Bug
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2653'>DRILL-2653</a>] -         All additions to storage plugin configuration gets wiped out if info is not correct 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3353'>DRILL-3353</a>] -         Non data-type related schema changes errors
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3739'>DRILL-3739</a>] -         NPE on select from Hive for HBase table
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3845'>DRILL-3845</a>] -         PartitionSender doesn&#39;t send last batch for receivers that already terminated
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3848'>DRILL-3848</a>] -         Increase timeout time on several tests that time out frequently.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3869'>DRILL-3869</a>] -         Trailing semicolon causes web UI to fail
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4035'>DRILL-4035</a>] -         NPE seen on Functional test run using JDK 8
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4044'>DRILL-4044</a>] -         NPE in partition pruning test on (JDK8 + Drill 1.3)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4121'>DRILL-4121</a>] -         External Sort may not spill if above a receiver
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4126'>DRILL-4126</a>] -         Adding HiveMetaStore caching when impersonation is enabled. 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4127'>DRILL-4127</a>] -         HiveSchema.getSubSchema() should use lazy loading of all the table names
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4128'>DRILL-4128</a>] -         null pointer at org.apache.drill.exec.vector.accessor.AbstractSqlAccessor.getString(AbstractSqlAccessor.java:101)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4152'>DRILL-4152</a>] -         Add additional logging and metrics to the Parquet reader
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4161'>DRILL-4161</a>] -         Make Hive Metastore client caching user configurable.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4168'>DRILL-4168</a>] -         NULLIF function documentation should be corrected
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4174'>DRILL-4174</a>] -         fix for DRILL-4081 mistakenly regresses the fix for DRILL-3786
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4180'>DRILL-4180</a>] -         IllegalArgumentException while reading JSON files
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4192'>DRILL-4192</a>] -         Dir0 and Dir1 from drill-1.4 are messed up
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4194'>DRILL-4194</a>] -         Improve the performance of metadata fetch operation in HiveScan
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4196'>DRILL-4196</a>] -         some TPCDS queries return wrong result when hash join is disabled
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4201'>DRILL-4201</a>] -         DrillPushFilterPastProject should allow partial filter pushdown. 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4205'>DRILL-4205</a>] -          Simple query hit IndexOutOfBoundException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4208'>DRILL-4208</a>] -         Storage plugin configuration persistence not working for Apache Drill
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4209'>DRILL-4209</a>] -         Error in hive-to-drill-data-type-mapping documentation 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4210'>DRILL-4210</a>] -         typo in documentation
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4228'>DRILL-4228</a>] -         Wrong query is mentioned &quot;To identify drill-version&quot; in documentation.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4230'>DRILL-4230</a>] -         NullReferenceException when SELECTing from empty mongo collection
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4234'>DRILL-4234</a>] -         Drill running out of memory for a simple CTAS query
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4235'>DRILL-4235</a>] -         Hit IllegalStateException when exec.queue.enable=ture 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4243'>DRILL-4243</a>] -         CTAS with partition by, results in Out Of Memory
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4246'>DRILL-4246</a>] -         New allocator causing a flatten regression test to fail with IllegalStateException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4250'>DRILL-4250</a>] -         File system directory-based partition pruning does not work when a directory contains both subdirectories and files.  
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4256'>DRILL-4256</a>] -         Performance regression in hive planning
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4257'>DRILL-4257</a>] -         Ensure shutting down a Drillbit also shuts down all StoragePlugins
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4277'>DRILL-4277</a>] -         Jdbc Storage Plugin doesn&#39;t correctly add metadata for physical serialization
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4278'>DRILL-4278</a>] -         Memory leak when using LIMIT
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4285'>DRILL-4285</a>] -         maven cannot find Could not find artifact org.freemarker:freemarker:jar:2.3.24-SNAPSHOT in apache.snapshots
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4291'>DRILL-4291</a>] -         Ensure the jdbc-all driver jar includes classes required to return VarChar[]
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4322'>DRILL-4322</a>] -         User exception created upon failed DROP TABLE eats the underlying exception
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4328'>DRILL-4328</a>] -         Fix for backward compatibility regression caused by DRILL-4198
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4349'>DRILL-4349</a>] -         parquet reader returns wrong results when reading a nullable column that starts with a large number of nulls (&gt;30k)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4353'>DRILL-4353</a>] -         Expired sessions in web server are not cleaning up resources, leading to resource leak
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4354'>DRILL-4354</a>] -         Remove sessions in anonymous (user auth disabled) mode in WebUI server
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4380'>DRILL-4380</a>] -         Fix performance regression: in creation of FileSelection in ParquetFormatPlugin to not set files if metadata cache is available.
-</li>
-</ul>
-                        
-<h2>        Improvement
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3201'>DRILL-3201</a>] -         Drill UI Authentication
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3478'>DRILL-3478</a>] -         Bson Record Reader for Mongo storage plugin
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4163'>DRILL-4163</a>] -         Support schema changes for MergeJoin operator.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4169'>DRILL-4169</a>] -         Upgrade Hive Storage Plugin to work with latest stable Hive (v1.2.1)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4198'>DRILL-4198</a>] -         Enhance StoragePlugin interface to expose logical space rules for planning purpose
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4212'>DRILL-4212</a>] -         Update Storage-Mongo to use the preferred API&#39;s
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4213'>DRILL-4213</a>] -         add page last updated to Drill docs
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4236'>DRILL-4236</a>] -         ExternalSort should use the new allocator functionality to better manage it&#39;s memory usage
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4239'>DRILL-4239</a>] -         Update documentation to reflect 64bit requirement to run Drill on Windows. 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4242'>DRILL-4242</a>] -         Update Mongo storage layer
-</li>
-</ul>
-            
-<h2>        New Feature
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4238'>DRILL-4238</a>] -         Allow custom messages to be sent on control channel
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4241'>DRILL-4241</a>] -         Add Experimental Kudu plugin
-</li>
-</ul>
-                                                        
-<h2>        Task
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4288'>DRILL-4288</a>] -         Obsolete generated files under protocol/
-</li>
-</ul>
-                
-<h2>        Wish
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3624'>DRILL-3624</a>] -         Enhance Web UI to be able to select schema (&quot;use&quot;)
-</li>
-</ul>

http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/006-1.6.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/006-1.6.0-rn.md b/_docs/rn/006-1.6.0-rn.md
new file mode 100644
index 0000000..3894261
--- /dev/null
+++ b/_docs/rn/006-1.6.0-rn.md
@@ -0,0 +1,126 @@
+---
+title: "Apache Drill 1.6.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:**  March 16, 2016
+
+Today, we're happy to announce the availability of Drill 1.6.0. You can download it [here](https://drill.apache.org/download/).
+
+This release provides inbound impersonation, additional custom window frames, and the following bug fixes and improvements:  
+
+<h2>        Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3488'>DRILL-3488</a>] -         Allow Java 1.8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4261'>DRILL-4261</a>] -         add support for RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4262'>DRILL-4262</a>] -         add support for ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4263'>DRILL-4263</a>] -         add support for RANGE BETWEEN CURRENT ROW AND CURRENT ROW
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4331'>DRILL-4331</a>] -         TestFlattenPlanning.testFlattenPlanningAvoidUnnecessaryProject fail in Java 8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4332'>DRILL-4332</a>] -         tests in TestFrameworkTest fail in Java 8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4334'>DRILL-4334</a>] -         tests in TestMongoFilterPushDown fail in Java 8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4465'>DRILL-4465</a>] -         Refactor Parsing and Planning to canonicalize planning and parsing
+</li>
+</ul>
+                            
+<h2>        Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3547'>DRILL-3547</a>] -         IndexOutOfBoundsException on directory with ~20 subdirectories
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3581'>DRILL-3581</a>] -         Google Guava version is so old it causes incompatibilities with other libs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3688'>DRILL-3688</a>] -         Drill should honor &quot;skip.header.line.count&quot; and &quot;skip.footer.line.count&quot; attributes of Hive table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4225'>DRILL-4225</a>] -         TestDateFunctions#testToChar fails when the locale is non-English
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4279'>DRILL-4279</a>] -         Improve performance for skipAll query against Text/JSON/Parquet table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4287'>DRILL-4287</a>] -         Do lazy reading of parquet metadata cache file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4323'>DRILL-4323</a>] -         Hive Native Reader : A simple count(*) throws Incoming batch has an empty schema error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4339'>DRILL-4339</a>] -         Avro Reader can not read records - Regression
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4354'>DRILL-4354</a>] -         Remove sessions in anonymous (user auth disabled) mode in WebUI server
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4375'>DRILL-4375</a>] -         Fix the maven release profile, broken by jdbc jar size enforcer added in DRILL-4291
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4384'>DRILL-4384</a>] -         Query profile is missing important information on WebUi
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4387'>DRILL-4387</a>] -         Improve execution side when it handles skipAll query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4392'>DRILL-4392</a>] -         CTAS with partition writes an internal field into generated parquet files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4410'>DRILL-4410</a>] -         ListVector causes OversizedAllocationException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4434'>DRILL-4434</a>] -         Remove (or deprecate) GroupScan.enforceWidth and use GroupScan.getMinParallelization
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4441'>DRILL-4441</a>] -         IN operator does not work with Avro reader
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4443'>DRILL-4443</a>] -         MIN/MAX on VARCHAR throw a NullPointerException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4449'>DRILL-4449</a>] -         Wrong results when using metadata cache with specific set of queries
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4457'>DRILL-4457</a>] -         Difference in results returned by window function over BIGINT data
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4467'>DRILL-4467</a>] -         Invalid projection created using PrelUtil.getColumns
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4474'>DRILL-4474</a>] -         Inconsistent behavior while using COUNT in select (Apache drill 1.2.0)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4482'>DRILL-4482</a>] -         Avro no longer selects data correctly from a sub-structure
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4483'>DRILL-4483</a>] -         Fix text plan issue in query profiles
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4486'>DRILL-4486</a>] -         Expression serializer incorrectly serializes escaped characters
+</li>
+</ul>
+                        
+<h2>        Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4260'>DRILL-4260</a>] -         Adding support for some custom window frames
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4297'>DRILL-4297</a>] -         Provide a new interface to send custom messages
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4313'>DRILL-4313</a>] -         C++ client - Improve method of drillbit selection from cluster
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4327'>DRILL-4327</a>] -         Fix rawtypes warning emitted by compiler
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4359'>DRILL-4359</a>] -         EndpointAffinity missing equals method
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4361'>DRILL-4361</a>] -         Allow for FileSystemPlugin subclasses to override FormatCreator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4363'>DRILL-4363</a>] -         Apply row count based pruning for parquet table in LIMIT n query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4383'>DRILL-4383</a>] -         Allow passign custom configuration options to a file system through the storage plugin config
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4423'>DRILL-4423</a>] -         TestCsvHeader#testEmptyFinalColumn is causing the unit test framework to print 10K rows in Stdout
+</li>
+</ul>
+            
+<h2>        New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2517'>DRILL-2517</a>] -         Apply Partition pruning before reading files during planning
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4314'>DRILL-4314</a>] -         Unit Test Framework Enhancement: Schema check for zero-row query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4485'>DRILL-4485</a>] -         MapR profile - use MapR 5.1.0
+</li>
+</ul>
+                                                        
+<h2>        Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4295'>DRILL-4295</a>] -         Obsolete protobuf generated files under protocol/
+</li>
+</ul>
+                
\ No newline at end of file