drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [2/3] drill git commit: Doc and website updates for the 1.13 release
Date Sun, 18 Mar 2018 20:04:12 GMT
http://git-wip-us.apache.org/repos/asf/drill/blob/d8dd5d3d/_docs/rn/001-1.13.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/001-1.13.0-rn.md b/_docs/rn/001-1.13.0-rn.md
new file mode 100644
index 0000000..01c4ae6
--- /dev/null
+++ b/_docs/rn/001-1.13.0-rn.md
@@ -0,0 +1,294 @@
+---
+title: "Apache Drill 1.13.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:**  March 18, 2018
+
+Today, we're happy to announce the availability of Drill 1.13.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:  
+
+- JDK 8 support. ([DRILL-1491](https://issues.apache.org/jira/browse/DRILL-1491))    
+- Upgrade to [Calcite version 1.15](https://calcite.apache.org/docs/history.html#v1-15-0). ([DRILL-3993](https://issues.apache.org/jira/browse/DRILL-3993)) 
+- JDBC Statement.setQueryTimeout(int) support to cancel queries if they do not complete within the specified time. ([DRILL-3640](https://issues.apache.org/jira/browse/DRILL-3640))  
+- Batch processing improvements that enable you to [limit the amount of memory]({{site.baseurl}}/docs/configuring-drill-memory/#modifying-memory-allocated-to-queries) that the Flatten, Merge Join, and External Sort operators allocate to outgoing batches. ([DRILL-6123](https://issues.apache.org/jira/browse/DRILL-6123))  
+- Enhanced DESCRIBE command. ([DRILL-4559](https://issues.apache.org/jira/browse/DRILL-4559))   
+- Support for SPNEGO to extend Kerberos to Web applications through HTTP. ([DRILL-5425](https://issues.apache.org/jira/browse/DRILL-5425))   
+- Ability to run [Drill under YARN]({{site.baseurl}}/docs/drill-on-yarn/). ([DRILL-1170](https://issues.apache.org/jira/browse/DRILL-1170))   
+- Parquet filter pushdown support for IS [NOT] NULL, TRUE, and FALSE operators and implicit and explicit casts for timestamp, date, and time data types. ([DRILL-6174](https://issues.apache.org/jira/browse/DRILL-6174))  
+- Performance improvements with support for project push down, filter push down, and partition pruning on dynamically expanded columns when represented as a star in the ITEM operator. ([DRILL-6118](https://issues.apache.org/jira/browse/DRILL-6118))  
+- Updated Hive libraries and the Drill Hive client updated to 2.3.2 with support for querying Hive transactional ORC bucketed tables. ([DRILL-5978](https://issues.apache.org/jira/browse/DRILL-5978))
+- Ability to automatically manage memory allocations during Drill startup. ([DRILL-5741](https://issues.apache.org/jira/browse/DRILL-5741))  
+- Ability to query an empty directory and use it for queries with any JOIN and UNION (UNION ALL) operators. ([Drill-4185](https://issues.apache.org/jira/browse/DRILL-4185))  
+- Non-numeric support for JSON processing. ([Drill-5919](https://issues.apache.org/jira/browse/DRILL-5919))  
+- New options to that enable you to configure the number of Jetty acceptors and selectors ([DRILL-5994](https://issues.apache.org/jira/browse/DRILL-5994))  
+- Support SQL syntax highlighting of queries, auto-complete support in SQL editors, and snippets. ([DRILL-5868](https://issues.apache.org/jira/browse/DRILL-5868))  
+- Improved performance of the Single Merge Exchange operator. ([DRILL-6115](https://issues.apache.org/jira/browse/DRILL-6115))   
+- Like operator optimization. [DRILL-5879](https://issues.apache.org/jira/browse/DRILL-5879)    
+- User/Distribution-specific configuration checks during startup ([DRILL-5741](https://issues.apache.org/jira/browse/DRILL-5741)).    
+  
+
+The following sections list all fixes and improvements:  
+
+<h2>        Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4333'>DRILL-4333</a>] -         tests in Drill2489CallsAfterCloseThrowExceptionsTest fail in Java 8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5068'>DRILL-5068</a>] -         Create a system table for completed profiles - sys.profiles
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6036'>DRILL-6036</a>] -         Create a sys.connections table
+</li>
+</ul>
+        
+<h2>        Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4120'>DRILL-4120</a>] -         dir0 does not work when the directory structure contains Avro files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4329'>DRILL-4329</a>] -         13 Unit tests are failing with JDK 8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4469'>DRILL-4469</a>] -         SUM window query returns incorrect results over integer data
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4708'>DRILL-4708</a>] -         connection closed unexpectedly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4923'>DRILL-4923</a>] -         Use of CASE WHEN inside a sub-query results in AssertionError
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4942'>DRILL-4942</a>] -         incorrect result  - case when (not null is null) then true else false end
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5170'>DRILL-5170</a>] -         JMockit-based unit tests fail when run under Java 8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5286'>DRILL-5286</a>] -         When rel and target candidate set is the same, planner should not need to do convert for the relNode since it must have been done
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5377'>DRILL-5377</a>] -         Five-digit year dates are displayed incorrectly via jdbc
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5690'>DRILL-5690</a>] -         RepeatedDecimal18Vector does not pass scale, precision to data vector
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5730'>DRILL-5730</a>] -         Fix Unit Test failures on JDK 8 And Some JDK 7 versions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5768'>DRILL-5768</a>] -         Drill planer should not allow select * with group by clause
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5833'>DRILL-5833</a>] -         Parquet reader fails with assertion error for Decimal9, Decimal18 types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5851'>DRILL-5851</a>] -         Empty table during a join operation with a non empty table produces cast exception 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5880'>DRILL-5880</a>] -         java.sql.SQLException: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5902'>DRILL-5902</a>] -         Queries encounter random failure due to RPC connection timed out
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5926'>DRILL-5926</a>] -         TestValueVector tests fail sporadically
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5961'>DRILL-5961</a>] -         For long running queries (&gt; 10 min) Drill may raise FragmentSetupException for completed/cancelled fragments
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5963'>DRILL-5963</a>] -         Canceling a query hung in planning state, leaves the query in ENQUEUED state for ever.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5967'>DRILL-5967</a>] -         Memory leak by HashPartitionSender
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5971'>DRILL-5971</a>] -         Fix INT64, INT32 logical types in complex parquet reader
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5996'>DRILL-5996</a>] -         Unable to re-run queries from Profiles tab with impersonation and without authentication 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6020'>DRILL-6020</a>] -         NullPointerException with Union setting on when querying JSON untyped path
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6021'>DRILL-6021</a>] -         Show shutdown button when authentication is not enabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6040'>DRILL-6040</a>] -         Need to add usage for graceful_stop to drillbit.sh
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6044'>DRILL-6044</a>] -         Shutdown button does not work from WebUI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6054'>DRILL-6054</a>] -         Issues in FindPartitionConditions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6070'>DRILL-6070</a>] -         Hash join with empty tables should not do casting of data types to INT&lt;OPTIONAL&gt;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6079'>DRILL-6079</a>] -         Memory leak caused by ParquetRowGroupScan
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6080'>DRILL-6080</a>] -         Sort incorrectly limits batch size to 65535 records rather than 65536
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6081'>DRILL-6081</a>] -         Duration of completed queries is continuously increasing
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6083'>DRILL-6083</a>] -         RestClientFixture does not connect to the correct webserver port
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6085'>DRILL-6085</a>] -         Travis build sometimes fails becomes vm suddenly exits.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6088'>DRILL-6088</a>] -         MainLoginPageModel errors out when http.auth.mechanisms is not configured
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6090'>DRILL-6090</a>] -         While connecting to drill-bits using JDBC Driver through Zookeeper, a lot of &quot;Curator-Framework-0&quot; threads are created if connection to drill-bit is not successful(no drill-bits are up/reachable)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6093'>DRILL-6093</a>] -         Unneeded columns in Drill logical project
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6099'>DRILL-6099</a>] -         Drill does not push limit past project (flatten) if it cannot be pushed into scan
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6100'>DRILL-6100</a>] -         Intermittent failure while reading Parquet file footer during planning phase
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6111'>DRILL-6111</a>] -         NullPointerException with Kafka Storage Plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6117'>DRILL-6117</a>] -         Query End time is not being set
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6119'>DRILL-6119</a>] -         The OpenTSDB storage plugin is not included in the Drill distribution
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6124'>DRILL-6124</a>] -         testCountDownLatch can be null in PartitionerDecorator depending on user&#39;s injection controls config
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6127'>DRILL-6127</a>] -         NullPointerException happens when submitting physical plan to the Hive storage plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6128'>DRILL-6128</a>] -         Wrong Result with Nested Loop Join
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6129'>DRILL-6129</a>] -         Query fails on nested data type schema change
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6137'>DRILL-6137</a>] -         Join Failure When Some Json File Partitions Empty
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6140'>DRILL-6140</a>] -         Operators listed in Profiles Page doesn&#39;t always correspond with operator specified in Physical Plan
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6143'>DRILL-6143</a>] -         Make Fragment Runner&#39;s RPC Timeout a SystemOption
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6144'>DRILL-6144</a>] -         Make directMemory amount configurable in tests
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6148'>DRILL-6148</a>] -         TestSortSpillWithException is sometimes failing.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6151'>DRILL-6151</a>] -         Fragment executors may terminate without sending final batch to a downstream causing query to hang
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6154'>DRILL-6154</a>] -         NaN, Infinity issues
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6164'>DRILL-6164</a>] -         Heap memory leak during parquet scan and OOM
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6172'>DRILL-6172</a>] -         setValueCount of VariableLengthVectors throws IOB exception when called with 0 value after clearing vectors
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6185'>DRILL-6185</a>] -         Error is displaying while accessing query profiles via the Web-UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6187'>DRILL-6187</a>] -         Exception in RPC communication between DataClient/ControlClient and respective servers when bit-to-bit security is on
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6188'>DRILL-6188</a>] -         Fix C++ client build on Centos 7 and OSX 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6189'>DRILL-6189</a>] -         Security: passwords logging and file permisions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6190'>DRILL-6190</a>] -         Packets can be bigger than strictly legal
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6191'>DRILL-6191</a>] -         Need more information on TCP flags
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6192'>DRILL-6192</a>] -         Drill is vulnerable to CVE-2017-12197
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6195'>DRILL-6195</a>] -         Quering Hive non-partitioned transactional tables via Drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6197'>DRILL-6197</a>] -         Duplicate entries in inputProfiles of minor fragments for specific operators
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6198'>DRILL-6198</a>] -         OpenTSDB unit tests fail when Lilith client is run
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6204'>DRILL-6204</a>] -         Pass tables columns without partition columns to empty Hive reader
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6205'>DRILL-6205</a>] -         Reduce memory consumption of testFlattenUpperLimit test
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6216'>DRILL-6216</a>] -         Metadata mismatch when connecting to a Drill 1.12.0 with a Drill-1.13.0-SNAPSHOT driver
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6217'>DRILL-6217</a>] -         NaN/Inf: NestedLoopJoin processes NaN values incorrectly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6226'>DRILL-6226</a>] -         Projection pushdown does not occur with Calcite upgrade
+</li>
+</ul>
+            
+<h2>        New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1170'>DRILL-1170</a>] -         YARN support for Drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5425'>DRILL-5425</a>] -         Support HTTP Kerberos auth using SPNEGO
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5868'>DRILL-5868</a>] -         Support SQL syntax highlighting of queries
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6068'>DRILL-6068</a>] -         Drill should support user/distribution specific configuration checks during startup
+</li>
+</ul>
+    
+<h2>        Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3640'>DRILL-3640</a>] -         Drill JDBC driver support Statement.setQueryTimeout(int)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3958'>DRILL-3958</a>] -         Improve error message when JDBC driver not found
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4185'>DRILL-4185</a>] -         UNION ALL involving empty directory on any side of union all results in Failed query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4559'>DRILL-4559</a>] -         Re-work DESCRIBE command after moving to Calcite master branch
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5688'>DRILL-5688</a>] -         Add repeated map support to column accessors
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5741'>DRILL-5741</a>] -         Automatically manage memory allocations during startup
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5879'>DRILL-5879</a>] -         Optimize &quot;Like&quot; operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5919'>DRILL-5919</a>] -         Add non-numeric support for JSON processing
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5966'>DRILL-5966</a>] -         Upgrade DRILL to Calcite 1.13.0
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5973'>DRILL-5973</a>] -         Support injection of time-bound pauses in server
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5974'>DRILL-5974</a>] -         Read JSON non-relational fields using text mode
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5978'>DRILL-5978</a>] -         Updating of Apache and MapR Hive libraries to 2.3.2 and 2.1.1-mapr-1710 versions respectively
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5993'>DRILL-5993</a>] -         Improve Performance of Copiers used by SV Remover, Top N etc.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5994'>DRILL-5994</a>] -         enable configuring number of Jetty acceptors and selectors
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6002'>DRILL-6002</a>] -         Avoid memory copy from direct buffer to heap while spilling to local disk
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6025'>DRILL-6025</a>] -         Execution time of a running query shown as &#39;NOT AVAILABLE&#39;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6028'>DRILL-6028</a>] -         Allow splitting generated code in ChainedHashTable into blocks to avoid &quot;code too large&quot; error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6049'>DRILL-6049</a>] -         Rollup of hygiene changes from &quot;batch size&quot; project
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6063'>DRILL-6063</a>] -         Set correct ThreadContext ClassLoader before using Hadoop Configuration class in DrillClient
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6071'>DRILL-6071</a>] -         Limit batch size for flatten operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6089'>DRILL-6089</a>] -         Validate That Planner Does Not Assume HashJoin Preserves Ordering for FS, MaprDB, or Hive
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6102'>DRILL-6102</a>] -         CurrentModification Exception in BaseAllocator when debugging
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6106'>DRILL-6106</a>] -         Use valueOf method instead of constructor since valueOf has a higher performance by caching frequently requested values.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6114'>DRILL-6114</a>] -         Complete internal metadata layer for improved batch handling
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6115'>DRILL-6115</a>] -         SingleMergeExchange is not scaling up when many minor fragments are allocated for a query.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6118'>DRILL-6118</a>] -         Handle item star columns during project  /  filter push down and directory pruning
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6123'>DRILL-6123</a>] -         Limit batch size for Merge Join based on memory
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6126'>DRILL-6126</a>] -         Allocate memory for value vectors upfront in flatten operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6153'>DRILL-6153</a>] -         Revised operator framework
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6163'>DRILL-6163</a>] -         Switch Travis To Java 8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6174'>DRILL-6174</a>] -         Parquet pushdown planning improvements
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6177'>DRILL-6177</a>] -         Merge Join - Allocate memory for outgoing value vectors based on sizes of incoming batches.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6180'>DRILL-6180</a>] -         Use System Option &quot;output_batch_size&quot; for External Sort
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6210'>DRILL-6210</a>] -         Enhance the test schema builder for remaining types
+</li>
+</ul>
+            
+<h2>        Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1491'>DRILL-1491</a>] -         Support for JDK 8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3993'>DRILL-3993</a>] -         Rebase Drill on Calcite master branch
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6130'>DRILL-6130</a>] -         Fix NPE during physical plan submission for various storage plugins
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6138'>DRILL-6138</a>] -         Move RecordBatchSizer to org.apache.drill.exec.record package
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6208'>DRILL-6208</a>] -         Fix FunctionInitializerTest#testConcurrentFunctionBodyLoad to use Mockito instead of JMockit
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6213'>DRILL-6213</a>] -         During restart drillbit should be killed forcefully if exceeds allowed timeout
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6218'>DRILL-6218</a>] -         Update release profile to not generate MD5 checksum
+</li>
+</ul>
+               
+

http://git-wip-us.apache.org/repos/asf/drill/blob/d8dd5d3d/_docs/rn/009-1.12.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/009-1.12.0-rn.md b/_docs/rn/009-1.12.0-rn.md
new file mode 100644
index 0000000..3c8fe4e
--- /dev/null
+++ b/_docs/rn/009-1.12.0-rn.md
@@ -0,0 +1,430 @@
+---
+title: "Apache Drill 1.12.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:**  December 15, 2017
+
+Today, we're happy to announce the availability of Drill 1.12.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: 
+
+- Kafka and OpenTSDB storage plugins (DRILL-4779, DRILL-5337)
+- SSL/TLS support (DRILL-5431)
+- Network encryption support (DRILL-5682)
+- Queue-based memory assignment for buffering operators (DRILL-5716)
+- A collection of networking functions that facilitate network analysis using Drill (DRILL-5834)
+- Support for the libpam4j PAM authenticator (DRILL-5820)
+- Filter pushdown for Parquet can handle files with multiple rowgroups (DRILL-5795)
+- UTF-8 is enabled in the query string by default (DRILL-5772)
+- IF NOT EXISTS support for CREATE TABLE and CREATE VIEWS (DRILL-5952)
+- Geometry functions, `ST_AsGeoJSON` and `ST_AsJSON`, that return GeoJSON and JSON representations (DRILL-5962, DRILL-5960) 
+- JMX metrics for failed and canceled queries (DRILL-5909)
+- Syntax highlighting and error checking for storage plugin configurations (DRILL-5981)
+- System options improvements, including a new internal system options table (DRILL-5723)
+- Ability to prevent users from accessing a path outside the current workspace (DRILL-5964)
+- Ability to put the server in quiescent mode for a graceful shutdown (DRILL-4286)
+- The Drill Web Console lists the completion of successfully completed queries as "successful" (DRILL-5923)
+
+  
+
+The following sections list additional bug fixes and improvements:  
+
+<h2>        Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5253'>DRILL-5253</a>] -         External sort fails with OOM error (Fails to allocate sv2)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5801'>DRILL-5801</a>] -         Label the Gantt chart that indicates the lifespan details of the various minor fragments
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5802'>DRILL-5802</a>] -         Provide a sortable table for tables within a query profile
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5803'>DRILL-5803</a>] -         Show the hostname for each minor fragment in operator table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5867'>DRILL-5867</a>] -         List profiles in pages rather than a long verbose listing
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5881'>DRILL-5881</a>] -         Java Client: [Threat Modeling] Drillbit may be spoofed by an attacker and this may lead to data being written to the attacker&#39;s target instead of Drillbit
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5882'>DRILL-5882</a>] -         C++ Client: [Threat Modeling] Drillbit may be spoofed by an attacker and this may lead to data being written to the attacker&#39;s target instead of Drillbit
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6031'>DRILL-6031</a>] -         Document support for dots in field names 
+</li>
+</ul>
+                            
+<h2>        Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1051'>DRILL-1051</a>] -         Casting timestamp as date gives wrong result for dates earlier than 1883
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1499'>DRILL-1499</a>] -         Different column order could appear in the result set for a schema-less select * query, even there are no changing schemas.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3241'>DRILL-3241</a>] -         Query with window function runs out of direct memory and does not report back to client that it did
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3407'>DRILL-3407</a>] -         CTAS Auto Partition : The plan for count(*) should show the list of files scanned
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3449'>DRILL-3449</a>] -         When Foreman node dies, the FragmentExecutor still tries to send status updates to Foreman
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3827'>DRILL-3827</a>] -         Empty metadata file causes queries on the table to fail
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3829'>DRILL-3829</a>] -         Metadata Caching : Drill should ignore a corrupted cache file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4139'>DRILL-4139</a>] -         Fix parquet partition pruning for BIT, INTERVAL and DECIMAL types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4255'>DRILL-4255</a>] -         SELECT DISTINCT query over JSON data returns UNSUPPORTED OPERATION
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4640'>DRILL-4640</a>] -         Unable to submit physical plan from Web UI on Windows
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4686'>DRILL-4686</a>] -         Aggregation query over HBase table results in IllegalStateException: Failure while reading vector
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4734'>DRILL-4734</a>] -         Query against HBase table on a 5 node cluster fails with SchemaChangeException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4735'>DRILL-4735</a>] -         Count(dir0) on parquet returns 0 result
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5002'>DRILL-5002</a>] -         Using hive&#39;s date functions on top of date column gives wrong results for local time-zone
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5146'>DRILL-5146</a>] -         Unnecessary spilling to disk by sort when we only have 5000 rows with one column
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5166'>DRILL-5166</a>] -         Select with options returns NPE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5185'>DRILL-5185</a>] -         Union all not passing type info when the output contains 0 rows
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5268'>DRILL-5268</a>] -         SYSTEM ERROR: UnsupportedOperationException: Unable to get size for minor type [MAP] and mode [REQUIRED]
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5269'>DRILL-5269</a>] -         SYSTEM ERROR: JsonMappingException: No suitable constructor found for type [simple type, class org.apache.drill.exec.store.direct.DirectSubScan]
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5327'>DRILL-5327</a>] -         Hash aggregate can return empty batch which can cause schema change exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5339'>DRILL-5339</a>] -         Web UI: flaws in query profile display on error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5341'>DRILL-5341</a>] -         Web UI: remove duplicating link to documentation in Options page
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5346'>DRILL-5346</a>] -         Web UI: remove link on user in query profile list
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5357'>DRILL-5357</a>] -         Partition pruning information not available in query plan for COUNT aggregate query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5416'>DRILL-5416</a>] -         Vectors read from disk report incorrect memory sizes
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5442'>DRILL-5442</a>] -         Managed Sort: IndexOutOfBounds with a join over an inlist
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5443'>DRILL-5443</a>] -         Managed External Sort fails with OOM while spilling to disk
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5445'>DRILL-5445</a>] -         Assertion Error in Managed External Sort when dealing with repeated maps
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5447'>DRILL-5447</a>] -         Managed External Sort : Unable to allocate sv2 vector
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5464'>DRILL-5464</a>] -         Fix JSON reader when it deals with empty file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5465'>DRILL-5465</a>] -         Managed external sort results in an OOM
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5478'>DRILL-5478</a>] -         Spill file size parameter is not honored by the managed external sort
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5480'>DRILL-5480</a>] -         Empty batch returning from HBase may cause SchemaChangeException even when data does not have different schema
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5507'>DRILL-5507</a>] -         Millions of &quot;Failure finding Drillbit running on host&quot; info messages in foreman logs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5513'>DRILL-5513</a>] -         Managed External Sort : OOM error during the merge phase
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5519'>DRILL-5519</a>] -         Sort fails to spill and results in an OOM
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5525'>DRILL-5525</a>] -         Inconsistent, unhelpful semantics for batch, field schema comparison
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5546'>DRILL-5546</a>] -         Schema change problems caused by empty batch
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5547'>DRILL-5547</a>] -         Drill config options and session options do not work as intended
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5564'>DRILL-5564</a>] -         IllegalStateException: allocator[op:21:1:5:HashJoinPOP]: buffer space (16674816) + prealloc space (0) + child space (0) != allocated (16740352)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5582'>DRILL-5582</a>] -         [Threat Modeling] Drillbit may be spoofed by an attacker and this may lead to data being written to the attacker&#39;s target instead of Drillbit
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5594'>DRILL-5594</a>] -         Excessive buffer reallocations during merge phase of external sort
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5597'>DRILL-5597</a>] -         Incorrect &quot;bits&quot; vector allocation in nullable vectors allocateNew()
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5602'>DRILL-5602</a>] -         Repeated List Vector fails to initialize the offset vector
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5617'>DRILL-5617</a>] -         Spill file name collisions when spill file is on a shared file system
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5645'>DRILL-5645</a>] -         negation of expression causes null pointer exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5660'>DRILL-5660</a>] -         Drill 1.10 queries fail due to Parquet Metadata &quot;corruption&quot; from DRILL-3867
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5663'>DRILL-5663</a>] -         Drillbit fails to start when only keystore path is provided without keystore password.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5675'>DRILL-5675</a>] -         Drill C++ Client Date Time Literals Support Metadata Mapping is Incorrect
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5686'>DRILL-5686</a>] -         Warning for sasl.max_wrapped_size contain incorrect syntax
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5687'>DRILL-5687</a>] -         Disable TestMergeJoinWithSchemaChanges#testMissingAndNewColumns
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5694'>DRILL-5694</a>] -         hash agg spill to disk, second phase OOM
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5698'>DRILL-5698</a>] -         Drill should start in embedded mode using java 1.8.0_144
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5699'>DRILL-5699</a>] -         Drill Web UI Page Source Has Links To External Sites
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5701'>DRILL-5701</a>] -         drill.connections.rpc.&lt;user/control/data&gt;.&lt;encrypted/unencrypted&gt; metric not behaving correctly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5702'>DRILL-5702</a>] -         Jdbc Driver Class not found
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5710'>DRILL-5710</a>] -         drill-config.sh incorrectly exits with Java 1.7 or later is required to run Apache Drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5714'>DRILL-5714</a>] -         Fix NPE when mapr-db plugin is used in table function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5715'>DRILL-5715</a>] -         Performance of refactored HashAgg operator regressed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5717'>DRILL-5717</a>] -         change some date time unit cases with specific timezone or Local
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5721'>DRILL-5721</a>] -         Query with only root fragment and no non-root fragment hangs when Drillbit to Drillbit Control Connection has network issues
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5725'>DRILL-5725</a>] -         Update Jackson version to 2.7.8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5727'>DRILL-5727</a>] -         Update release profile to generate SHA-512 checksum.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5729'>DRILL-5729</a>] -         Fix Travis Checks
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5737'>DRILL-5737</a>] -         Hash Agg uses more than the allocated memory under certain low memory conditions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5740'>DRILL-5740</a>] -         hash agg fail to read spill file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5743'>DRILL-5743</a>] -         Using order by clause in a select * query on hbase table returns only the row_key and order by field(s)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5744'>DRILL-5744</a>] -         External sort fails with OOM error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5745'>DRILL-5745</a>] -         Invalid &quot;location&quot; information in Drill web server
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5746'>DRILL-5746</a>] -         Pcap PR manually edited Protobuf files, values lost on next build
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5749'>DRILL-5749</a>] -         Foreman and Netty threads occure deadlock 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5751'>DRILL-5751</a>] -         Fix unit tests to use local file system even if it is not set by default
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5753'>DRILL-5753</a>] -         Managed External Sort: One or more nodes ran out of memory while executing the query.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5755'>DRILL-5755</a>] -         TOP_N_SORT operator does not free memory while running
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5757'>DRILL-5757</a>] -         CONVERT_TO_JSON function is failed while using non-existence field as a parameter.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5761'>DRILL-5761</a>] -         Disable Lilith ClassicMultiplexSocketAppender by default
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5763'>DRILL-5763</a>] -         Fix NPE during MapRDBSubScan deserialization
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5765'>DRILL-5765</a>] -         Json query profile is not shown on Web UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5766'>DRILL-5766</a>] -         Stored XSS in APACHE DRILL
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5771'>DRILL-5771</a>] -         Fix serDe errors for format plugins
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5775'>DRILL-5775</a>] -         Select * query on a maprdb binary table fails
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5790'>DRILL-5790</a>] -         PCAP format explicitly opens local file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5792'>DRILL-5792</a>] -         CONVERT_FROM_JSON on an empty file throws runtime exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5804'>DRILL-5804</a>] -         External Sort times out, may be infinite loop
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5811'>DRILL-5811</a>] -         Large number of &quot;Failure finding Drillbit&quot; messages when using MFS
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5812'>DRILL-5812</a>] -         Restore the minor fragment Gantt chart Canvas
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5816'>DRILL-5816</a>] -         Hash function produces skewed results on String values with same leading prefix
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5819'>DRILL-5819</a>] -         Default value of security.admin.user_groups and security.admin.users is &quot;true&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5822'>DRILL-5822</a>] -         The query with &quot;SELECT *&quot; with &quot;ORDER BY&quot; clause and `planner.slice_target`=1 doesn&#39;t preserve column order
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5824'>DRILL-5824</a>] -         1st phase Hash Aggregate allocates more memory than the limit
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5830'>DRILL-5830</a>] -         Resolve regressions to MapR DB from DRILL-5546
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5838'>DRILL-5838</a>] -         Fix MaprDB filter pushdown for the case of nested field (reg. of DRILL-4264)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5839'>DRILL-5839</a>] -         Handle Empty Batches in Merge Receiver
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5840'>DRILL-5840</a>] -         A query that includes sort completes, and then loses Drill connection. Drill becomes unresponsive, and cannot restart because it cannot communicate with Zookeeper
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5845'>DRILL-5845</a>] -         Columns returned by select with &quot;ORDER BY&quot; and &quot;LIMIT&quot; clauses are not in correct order.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5849'>DRILL-5849</a>] -         Add freemarker lib to dependencyManagement to ensure proper version is used when resolving dependency version conflicts
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5853'>DRILL-5853</a>] -         Sort removal based on NULL direction
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5854'>DRILL-5854</a>] -         IllegalStateException when empty batch is received.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5857'>DRILL-5857</a>] -         Fix NumberFormatException in Hive unit tests
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5859'>DRILL-5859</a>] -         Time for query queuing timeout not display correctly in WebUI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5863'>DRILL-5863</a>] -         Sortable table incorrectly sorts minor fragments and time elements lexically instead of sorting by implicit value
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5864'>DRILL-5864</a>] -         Selecting a non-existing field from a MapR-DB JSON table fails with NPE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5872'>DRILL-5872</a>] -         Deserialization of profile JSON fails due to totalCost being reported as &quot;NaN&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5874'>DRILL-5874</a>] -         NPE in AnonWebUserConnection.cleanupSession()
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5878'>DRILL-5878</a>] -         TableNotFound exception is being reported for a wrong storage plugin.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5887'>DRILL-5887</a>] -         Display process user/ groups in Drill UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5888'>DRILL-5888</a>] -         jdbc-all-jar unit tests broken because of dependency on hadoop.security
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5890'>DRILL-5890</a>] -         Tests Leak Many Open File Descriptors
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5895'>DRILL-5895</a>] -         Fix unit tests for mongo storage plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5896'>DRILL-5896</a>] -         Handle vector creation in HbaseRecordReader to avoid NullableInt vectors later
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5898'>DRILL-5898</a>] -         Query returns columns in the wrong order
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5906'>DRILL-5906</a>] -         java.lang.NullPointerException while quering Hive ORC tables on MapR cluster. 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5923'>DRILL-5923</a>] -         State of a successfully completed query shown as &quot;COMPLETED&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5941'>DRILL-5941</a>] -         Skip header / footer logic works incorrectly for Hive tables when file has several input splits
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5972'>DRILL-5972</a>] -         Slow performance for query on INFORMATION_SCHEMA.TABLE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5979'>DRILL-5979</a>] -         unnable to access temporary table from drill web interface
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5986'>DRILL-5986</a>] -         Update jackson-databind version to 2.7.9.1
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5987'>DRILL-5987</a>] -         Two versions of javassist on the classpath
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6006'>DRILL-6006</a>] -         Label current is missing on Web UI since the same drillbits with different status are considered to be different
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6007'>DRILL-6007</a>] -         web ui index page is refreshed at high pace 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6017'>DRILL-6017</a>] -         Fix for SHUTDOWN button being visible for non Admin users
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6019'>DRILL-6019</a>] -         Only admin should be able to access shutdown resources
+</li>
+<li>Order by doesn't sort columns when window function is involved in the query</li>
+<li>MIN MAX DIR tests fail and return incorrect results</li>
+<li>header.line.count does not work for Hive table with data file size &gt; chunk size</li>
+<li>lang.NoClassDefFoundError exception not handled in org.apache.drill.exec.rpc.security.ClientAuthenticatorProvider</li>
+<li>Investigate jackson-databind vulnerabilities CVE-2017-15095 &amp; CVE-2017-7525</li>
+<li>Null Pointer Exception with query using table function</li>
+<li>Fix XSS vulnerabilities in Drill</li>
+<li>Some queries in concurrent execution get stuck in STARTING phase</li>
+<li>hashagg.num_partitions cannot be set by "alter session" or "alter system"</li>
+<li>Query with 2-way JOIN fails with "Hash join does not support schema changes"</li>
+<li>RowKeyJoin is generated instead of IndexScan for queries with derived table/ table functions</li>
+<li>ConvertCountToDirectScan rule enhancements</li>
+<li>Drill wrong old date-time values displaying</li>
+<li>Warning message "Exception while trying to prune partition" when query on view</li>
+<li>Drill not able to read MapR-DB when FQDN is longer than 64 characters</li>
+<li>Pam authentication with Centrify doesn't work by JPam restriction</li>
+<li>Hash aggregate does not support schema changes</li>
+<li>Simple query with only one join condition failed with "Hash join does not support schema changes"</li>
+<li>UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL].</li>
+<li>Query on TPC-H SF100 dataset fails with "Hash join does not support schema changes" [MapR-DB JSON Tables]</li>
+</ul>
+                                        
+<h2>        Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1691'>DRILL-1691</a>] -         ConvertCountToDirectScan rule should be applicable for 2 or more COUNT aggregates
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4264'>DRILL-4264</a>] -         Allow field names to include dots
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5089'>DRILL-5089</a>] -         Skip initializing all enabled storage plugins for every query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5106'>DRILL-5106</a>] -         Refactor SkipRecordsInspector to exclude check for predefined file formats
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5259'>DRILL-5259</a>] -         Allow listing a user-defined number of profiles 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5338'>DRILL-5338</a>] -         Web UI: add better visual indication for PLANNING, QUEUED, EXECUTION in Query Profile that they are part of total time duration
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5704'>DRILL-5704</a>] -         Improve error message on client side when queries fail with &quot;Failed to create schema tree.&quot; when Impersonation is enabled and logins are anonymous
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5709'>DRILL-5709</a>] -         Provide a value vector method to convert a vector to nullable
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5716'>DRILL-5716</a>] -         Queue-based memory assignment for buffering operators
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5726'>DRILL-5726</a>] -         Support Impersonation without authentication for REST API
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5795'>DRILL-5795</a>] -         Filter pushdown for parquet handles multi rowgroup file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5808'>DRILL-5808</a>] -         Reduce memory allocator strictness for &quot;managed&quot; operators
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5815'>DRILL-5815</a>] -         Provide option to set query memory as percent of total
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5832'>DRILL-5832</a>] -         Migrate OperatorFixture to use SystemOptionManager rather than mock
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5834'>DRILL-5834</a>] -         Add Networking Functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5842'>DRILL-5842</a>] -         Refactor and simplify the fragment, operator contexts for testing
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5862'>DRILL-5862</a>] -         Update project parent pom xml to the latest ASF version
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5893'>DRILL-5893</a>] -         Maven forkCount property is too aggressive causing builds to fail on some machines.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5899'>DRILL-5899</a>] -         Simple pattern matchers can work with DrillBuf directly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5909'>DRILL-5909</a>] -         need new JMX metrics for (FAILED and CANCELED) queries
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5910'>DRILL-5910</a>] -         Logging exception when  custom AuthenticatorFactory not found
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5921'>DRILL-5921</a>] -         Counters metrics should be listed in table
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5943'>DRILL-5943</a>] -         Avoid the strong check introduced by DRILL-5582 for PLAIN mechanism
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5952'>DRILL-5952</a>] -         Implement &quot;CREATE TABLE IF NOT EXISTS&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5960'>DRILL-5960</a>] -         Add function STAsGeoJSON to extend GIS support
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5962'>DRILL-5962</a>] -         Add function STAsJSON to extend GIS support
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5964'>DRILL-5964</a>] -         Do not allow queries to access paths outside the current workspace root
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5980'>DRILL-5980</a>] -         Make queryType param for REST API case insensitive
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5981'>DRILL-5981</a>] -         Add Syntax Highlighting and Error Checking to Storage Plugin Config Page
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5989'>DRILL-5989</a>] -         Run Smoke Tests On Travis
+</li>
+</ul>
+            
+<h2>        New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4286'>DRILL-4286</a>] -         Have an ability to put server in quiescent mode of operation
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4779'>DRILL-4779</a>] -         Kafka storage plugin support
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5337'>DRILL-5337</a>] -         OpenTSDB storage plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5431'>DRILL-5431</a>] -         Support SSL
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5682'>DRILL-5682</a>] -         Apache Drill should support network encryption
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5723'>DRILL-5723</a>] -         Support System/Session Internal Options And Additional Option System Fixes
+</li>
+</ul>
+                                                                    
+<h2>        Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5601'>DRILL-5601</a>] -         Rollup of External Sort memory management fixes
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5685'>DRILL-5685</a>] -         Provide a way to set common environment variable between sqlline and Drillbit differently.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5758'>DRILL-5758</a>] -         Rollup of external sort fixes to issues found by QA
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5772'>DRILL-5772</a>] -         Enable UTF-8 support in query string by default
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5781'>DRILL-5781</a>] -         Fix unit test failures to use tests config even if default config is available
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5820'>DRILL-5820</a>] -         Add support for libpam4j Pam Authenticator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5911'>DRILL-5911</a>] -         Upgrade esri-geometry-api version to 2.0.0 to avoid dependency on org.json library
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5917'>DRILL-5917</a>] -         Ban org.json:json library in Drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6000'>DRILL-6000</a>] -         Graceful Shutdown Unit Tests Should Not Be Run On Travis
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-6011'>DRILL-6011</a>] -         Update log info message in DrillClient
+</li>
+</ul>
+                
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/d8dd5d3d/_docs/tutorials/020-drill-in-10-minutes.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/020-drill-in-10-minutes.md b/_docs/tutorials/020-drill-in-10-minutes.md
index b3c252e..96e6a39 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: 2017-12-16 06:24:23 UTC
+date: 2018-03-18 20:02:37 UTC
 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.12.0/apache-drill-1.12.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.12.0/apache-drill-1.12.0.tar.gz) with the command appropriate for your system:  
-       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.12.0/apache-drill-1.12.0.tar.gz`  
-       * `curl -o apache-drill-1.12.0.tar.gz http://apache.mirrors.hoobly.com/drill/drill-1.12.0/apache-drill-1.12.0.tar.gz`   
+2. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.13.0/apache-drill-1.13.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.13.0/apache-drill-1.13.0.tar.gz) with the command appropriate for your system:  
+       * `wget http://apache.mirrors.hoobly.com/drill/drill-1.13.0/apache-drill-1.13.0.tar.gz`  
+       * `curl -o apache-drill-1.13.0.tar.gz http://apache.mirrors.hoobly.com/drill/drill-1.13.0/apache-drill-1.13.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>`  
@@ -75,7 +75,7 @@ Start Drill in embedded mode using the `drill-embedded` command:
 
 You can install Drill on Windows. First, set the JAVA_HOME environment variable, and then install Drill. Complete the following steps to install Drill:
 
-1. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.12.0/apache-drill-1.12.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.12.0/apache-drill-1.12.0.tar.gz).  
+1. Download the latest version of Apache Drill [here](http://apache.mirrors.hoobly.com/drill/drill-1.13.0/apache-drill-1.13.0.tar.gz) or from the [Apache Drill mirror site](http://www.apache.org/dyn/closer.cgi/drill/drill-1.13.0/apache-drill-1.13.0.tar.gz).  
 2. Move the `apache-drill-<version>.tar.gz` file to a directory where you want to install Drill.  
 3. Unzip the `TAR.GZ` file using a third-party tool. If the tool you use does not unzip the TAR file as well as the `TAR.GZ` file, unzip the `apache-drill-<version>.tar` to extract the Drill software. The extraction process creates the installation directory named apache-drill-<version> containing the Drill software. 
 

http://git-wip-us.apache.org/repos/asf/drill/blob/d8dd5d3d/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
----------------------------------------------------------------------
diff --git a/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md b/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
index bc17acf..052d4fa 100644
--- a/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
+++ b/_docs/tutorials/050-analyzing-highly-dynamic-datasets.md
@@ -1,6 +1,6 @@
 ---
 title: "Analyzing Highly Dynamic Datasets"
-date: 2018-02-08 02:32:57 UTC
+date: 2018-03-18 20:02:38 UTC
 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.12.0.tar
+    tar -xvf apache-drill-1.13.0.tar
 
 Install Drill locally on your desktop (embedded mode). You don’t need Hadoop.
 

http://git-wip-us.apache.org/repos/asf/drill/blob/d8dd5d3d/blog/_posts/2018-3-18-drill-1.13-released.md
----------------------------------------------------------------------
diff --git a/blog/_posts/2018-3-18-drill-1.13-released.md b/blog/_posts/2018-3-18-drill-1.13-released.md
new file mode 100644
index 0000000..6b8ea3a
--- /dev/null
+++ b/blog/_posts/2018-3-18-drill-1.13-released.md
@@ -0,0 +1,39 @@
+---
+layout: post
+title: "Drill 1.13 Released"
+code: drill-1.13-released
+excerpt: Apache Drill 1.13's highlights are&#58; YARN support, support for HTTP Kerberos authentication using SPNEGO, SQL syntax highlighting of queries, and user and distribution specific configuration checks during startup.
+authors: ["bbevens"]
+---
+
+Today, we're happy to announce the availability of Drill 1.13.0. You can download it [here](https://drill.apache.org/download/).
+
+The release provides the following bug fixes and improvements:
+
+## Ability to Run Drill Under YARN (DRILL-1170)
+You can run Drill as a YARN application ([Drill-on-YARN]({{site.baseurl}}/docs/drill-on-yarn/)) if you want Drill to work alongside other applications, such as Hadoop and Spark, in a YARN-managed cluster. YARN assigns resources, such as memory and CPU, to applications in the cluster and eliminates the manual steps associated with installation and resource allocation for stand-alone applications in a multi-tenant environment. YARN automatically deploys (localizes) the Drill software onto each Drill node and manages the Drill cluster. Drill becomes a long-running application with YARN. You can monitor the Drill-on-YARN cluster using the Application Master web UI.
+
+
+
+## SPNEGO Support (DRILL-5425)
+
+You can use SPNEGO to extend Kerberos authentication to Web applications through HTTP. 
+
+## SQL Syntax Support (DRILL-5868)   
+Query syntax appears highlighted in the Drill Web Console. In addition to syntax highlighting, auto-complete is supported in all SQL editors, including the Edit Query tab within an existing profile to rerun the query. For browsers like Chrome, you can type Ctrl+Space for a drop-down list and then use arrow keys for navigating through options. An auto-complete feature that specifies Drill keywords and functions, and the ability to write SQL from templates using snippets. 
+
+
+## User/Distribution-Specific Configuration Checks During Startup (DRILL-5741) 
+
+ You can define the maximum amount of cumulative memory allocated to the Drill process during startup through the `DRILLBIT_MAX_PROC_MEM` environment variable. For example, if you set `DRILLBIT_MAX_PROC_MEM to 40G`, the total amount of memory allocated to the following memory parameters cannot exceed 40G:  
+
+- `DRILL_HEAP=8G ` 
+- `DRILL_MAX_DIRECT_MEMORY=10G`  
+- `DRILLBIT_CODE_CACHE_SIZE=1024M`
+
+At startup, an auto-setup.sh script performs a check to see if these memory parameters are declared. If the parameters are declared, the script performs a check to verify that the cumulative memory of the parameters does not exceed the value specified by `DRILLBIT_MAX_PROC_MEM`. If the cumulative memory exceeds the total amount of memory defined by `DRILLBIT_MAX_PROC_MEM`, Drill returns an error message with instructions.
+
+
+ 
+You can find a complete list of JIRAs resolved in the 1.13.0 release [here]({{site.baseurl}}/docs/apache-drill-1-13-0-release-notes/).
+


Mime
View raw message