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:52 UTC
[2/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/020-1.0.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/020-1.0.0-rn.md b/_docs/rn/020-1.0.0-rn.md
deleted file mode 100755
index 6ccea14..0000000
--- a/_docs/rn/020-1.0.0-rn.md
+++ /dev/null
@@ -1,505 +0,0 @@
----
-title: "Apache Drill 1.0.0 Release Notes"
-parent: "Release Notes"
----
-**Release date:** May 19, 2015
-
-Today we're happy to announce the availability of Drill 1.0.0, providing additional enhancements and bug fixes. This release includes the following new features, enhancements, unresolved issues, and bug fixes:
-
-<h2> Sub-task
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2150'>DRILL-2150</a>] - Create an abstraction for repeated value vectors.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2358'>DRILL-2358</a>] - Ensure DrillScanRel differentiates skip-all, scan-all & scan-some in a backward compatible fashion
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2893'>DRILL-2893</a>] - ScanBatch throws a NullPointerException instead of returning OUT_OF_MEMORY
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2895'>DRILL-2895</a>] - AbstractRecordBatch.buildSchema() should properly handle OUT_OF_MEMORY outcome
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2902'>DRILL-2902</a>] - Add support for context UDFs: user (and its synonyms session_user, system_user) and current_schema
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2905'>DRILL-2905</a>] - RootExec implementations should properly handle IterOutcome.OUT_OF_MEMORY
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2920'>DRILL-2920</a>] - properly handle OutOfMemoryException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2947'>DRILL-2947</a>] - AllocationHelper.allocateNew() doesn't have a consistent behavior when it can't allocate
-</li>
-</ul>
-
-<h2> Unresolved Issues
-</h2>
-<ul>
- <li>[<a href='https://issues.apache.org/jira/browse/DRILL-1868'>DRILL-1868</a>] Aliases are not allowed in WHERE, HAVING and GROUP BY clauses. Drill should return an error when such aliases are encountered, but instead Drill returns an incorrect result.
- </li>
- <li>[<a href='https://issues.apache.org/jira/browse/DRILL-2015'>DRILL-2015</a>] Casting a numeric value that does not fit the data type of the value and causes overflow returns an incorrect result.
- </li>
- <li>[<a href='https://issues.apache.org/jira/browse/DRILL-2355'>DRILL-2355</a>] Drill output from the TRUNC function in some cases includes an extra .0 in the result. Drill binds TRUNC functions having two input parameters to the function holder. The output type of TRUNC functions is FLOAT8 when the input is FLOAT8, resulting in the extra .0.
- </li>
-</ul>
-<h2> Bug Fixes
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-148'>DRILL-148</a>] - Remove sandbox directory from source control, it is no longer utilized
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-625'>DRILL-625</a>] - Server does not release resources even after client connection is closed
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-708'>DRILL-708</a>] - TRUNC(n1) function returns a decimal instead of int
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-994'>DRILL-994</a>] - Reduce hbase timeout when it is not reachable
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1245'>DRILL-1245</a>] - Drill should pinpoint to the "Problem Record" when it fails to parse a json file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1440'>DRILL-1440</a>] - Allow delimited files to have customizable quote characters
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1460'>DRILL-1460</a>] - JsonReader fails reading files with decimal numbers and integers in the same field
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1502'>DRILL-1502</a>] - Can't connect to mongo when requiring auth
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1503'>DRILL-1503</a>] - CTAS does not work against mongo plugin
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1542'>DRILL-1542</a>] - Early fragment termination causes non running intermediate fragments to error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1545'>DRILL-1545</a>] - Json files can only be read when they have a .json extension
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1727'>DRILL-1727</a>] - REPEATED_CONTAINS sometimes doesn't work
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1827'>DRILL-1827</a>] - Unit test framework reports expected and actual values backwards in unordered comparison
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1832'>DRILL-1832</a>] - Select * from json file failed with java.lang.IllegalArgumentException: null
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1866'>DRILL-1866</a>] - Tests that include limit sporadically fail when run as part of entire test suite on Linux
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1891'>DRILL-1891</a>] - Error message does not get propagated correctly when reading from JSON file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1973'>DRILL-1973</a>] - Tableau query causes parsing error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1980'>DRILL-1980</a>] - Create table with a Cast to interval day results in a file which cannot be read
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2005'>DRILL-2005</a>] - Create table fails to write out a parquet file created from hive- read works fine
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2006'>DRILL-2006</a>] - Implement text reader with advanced capabilities
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2036'>DRILL-2036</a>] - select * query returns wrong result when column name in json file changes case
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2073'>DRILL-2073</a>] - Filter on a field in a nested repeated type throws an exception
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2074'>DRILL-2074</a>] - Queries fail with OutOfMemory Exception when Hash Join & Agg are turned off
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2085'>DRILL-2085</a>] - Failed to propagate error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2091'>DRILL-2091</a>] - NPE in AbstractSqlAccessor
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2093'>DRILL-2093</a>] - Columns of time and timestamp data type are not stored correctly in json format on CTAS
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2140'>DRILL-2140</a>] - RPC Error querying JSON with empty nested maps
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2141'>DRILL-2141</a>] - Data type error in group by and order by for JSON
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2158'>DRILL-2158</a>] - Failure while attempting to start Drillbit in embedded mode.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2179'>DRILL-2179</a>] - better handle column called 'Timestamp'
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2181'>DRILL-2181</a>] - Throw proper error message when flatten is used within an 'order by' or 'group by'
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2201'>DRILL-2201</a>] - clear error message on join on complex type
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2208'>DRILL-2208</a>] - Error message must be updated when query contains operations on a flattened column
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2219'>DRILL-2219</a>] - Concurrent modification exception in TopLevelAllocator if a child allocator is added during loop in close()
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2221'>DRILL-2221</a>] - CTAS (JSON) creates unreadable files when writing empty arrays
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2228'>DRILL-2228</a>] - Projecting '*' returns all nulls when we have flatten in a filter and order by
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2229'>DRILL-2229</a>] - SQL syntax errors should use SQLSyntaxErrorException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2232'>DRILL-2232</a>] - Flatten functionality not well defined when we use flatten in an order by without projecting it
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2264'>DRILL-2264</a>] - Incorrect data when we use aggregate functions with flatten
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2277'>DRILL-2277</a>] - COUNT(*) should return 0 instead of an empty result set when there are no records
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2281'>DRILL-2281</a>] - Drill never returns when we use aggregate functions after a join with an order by
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2292'>DRILL-2292</a>] - CTAS broken when we have repeated maps
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2301'>DRILL-2301</a>] - Query fails when multiple table aliases are provided for CTEs
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2340'>DRILL-2340</a>] - count(*) fails with subquery not containing limit
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2350'>DRILL-2350</a>] - Star query failed with exception on JSON data
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2376'>DRILL-2376</a>] - UNION ALL on Aggregates with GROUP BY returns incomplete results
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2404'>DRILL-2404</a>] - After we cancel a query, DRILL sometimes hangs for the next query
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2408'>DRILL-2408</a>] - CTAS should not create empty folders when underlying query returns no results
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2411'>DRILL-2411</a>] - Scalar SUM/AVG over empty result set returns no rows instead of NULL
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2423'>DRILL-2423</a>] - DROP VIEW against non-existent views fails with ZK error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2425'>DRILL-2425</a>] - Wrong results when identifier change cases within the same data file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2437'>DRILL-2437</a>] - enhance exception injection to support session level injections
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2452'>DRILL-2452</a>] - ResultSet.getDouble should not throw an exception when the underlying type is a FLOAT
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2476'>DRILL-2476</a>] - Handle IterOutcome.STOP in buildSchema()
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2506'>DRILL-2506</a>] - IOOB with order by and limit
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2511'>DRILL-2511</a>] - Assert with full outer join when one of the join predicates is of a required type (nullabe parquet)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2528'>DRILL-2528</a>] - Drill-JDBC-All Jar uses outdated classes
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2532'>DRILL-2532</a>] - Glob not always fired for DFS storage engine
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2533'>DRILL-2533</a>] - Metrics displayed in the profile UI should be rounded off instead of being truncated
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2535'>DRILL-2535</a>] - Column labels on drill profile page are incorrect
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2536'>DRILL-2536</a>] - Peak Mem column in the profile page displays 0 when value is less than 1MB
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2545'>DRILL-2545</a>] - Killing a JDBC client program does not kill the query on drillbits
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2548'>DRILL-2548</a>] - JDBC driver prints misleading SQL exception on getting record batches with no data
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2552'>DRILL-2552</a>] - ZK disconnect to foreman node results in hung query on client
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2554'>DRILL-2554</a>] - Incorrect results for repeated values when using jdbc
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2569'>DRILL-2569</a>] - Minor fragmentId in Profile UI gets truncated to the last 2 digits
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2570'>DRILL-2570</a>] - Broken JDBC-All Jar packaging can cause missing XML classes
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2589'>DRILL-2589</a>] - Creating a view with duplicate column names should fail or give a warning to the user
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2598'>DRILL-2598</a>] - Order by with limit on complex type throw IllegalStateException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2617'>DRILL-2617</a>] - Errors in the execution stack will cause DeferredException to throw an IllegalStateException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2624'>DRILL-2624</a>] - org.apache.drill.common.StackTrace prints garbage for line numbers
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2662'>DRILL-2662</a>] - Exception type not being included when propagating exception message
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2723'>DRILL-2723</a>] - Inaccurate row count estimate for text files results in BroadcastExchange
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2750'>DRILL-2750</a>] - Running 1 or more queries against Drillbits having insufficient DirectMem renders the Drillbits in an unusable state
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2753'>DRILL-2753</a>] - Implicit cast fails when comparing a double column and a varchar literal
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2754'>DRILL-2754</a>] - Allocation bug in splitAndTransfer method causing some flatten queries to fail
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2755'>DRILL-2755</a>] - Use and handle InterruptedException during query processing
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2757'>DRILL-2757</a>] - Verify operators correctly handle low memory conditions and cancellations
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2776'>DRILL-2776</a>] - querying a .json file that contains a repeated type returns the wrong results
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2778'>DRILL-2778</a>] - Killing the drillbit which is the foreman results in hung sqlline
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2780'>DRILL-2780</a>] - java.lang.IllegalStateException files open exceptions in drillbit.out
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2793'>DRILL-2793</a>] - Killing a non foreman node results in direct memory being held on
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2801'>DRILL-2801</a>] - ORDER BY produces extra records
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2806'>DRILL-2806</a>] - Querying data from compressed csv file returns nulls and unreadable data
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2809'>DRILL-2809</a>] - Increase the default value of partitioner_sender_threads_factor
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2811'>DRILL-2811</a>] - Need option to specify Drillbit in the connection URI to connect to that specific Drillbit
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2816'>DRILL-2816</a>] - system error does not display the original Exception message
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2823'>DRILL-2823</a>] - Merge join should use implicit cast
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2824'>DRILL-2824</a>] - Function resolution should be deterministic
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2826'>DRILL-2826</a>] - Improve resilience to memory leaks and unclosed allocators
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2841'>DRILL-2841</a>] - Web UI very slow in a multi node machine
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2847'>DRILL-2847</a>] - DrillBufs from the RPC layer are being leaked
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2848'>DRILL-2848</a>] - Disable decimal data type by default
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2849'>DRILL-2849</a>] - Difference in query results over CSV file created by CTAS, compared to results over original CSV file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2865'>DRILL-2865</a>] - Drillbit runs out of memory on multiple consecutive CTAS
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2870'>DRILL-2870</a>] - Fix return type of aggregate functions to be nullable
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2871'>DRILL-2871</a>] - Plan for TPC-H 20 changed with DRILL-1384 (or DRILL-2761) causing performance degradation
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2872'>DRILL-2872</a>] - Result from json file returns data from map type fields as "null"
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2875'>DRILL-2875</a>] - IllegalStateException when querying the public yelp json dataset
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2878'>DRILL-2878</a>] - FragmentExecutor.closeOutResources() is not called if an exception happens in the Foreman before the fragment executor starts running
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2884'>DRILL-2884</a>] - Have cancel() cause "query canceled" rather than just "ResultSet closed"
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2886'>DRILL-2886</a>] - JDBC driver doesn't detect lost connection
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2887'>DRILL-2887</a>] - Fix bad applications of JdbcTest.connect()
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2889'>DRILL-2889</a>] - Rename JdbcTest to JdbcTestBase.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2894'>DRILL-2894</a>] - FixedValueVectors shouldn't set it's data buffer to null when it fails to allocate it
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2897'>DRILL-2897</a>] - Update Limit 0 to avoid parallelization
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2904'>DRILL-2904</a>] - Fix wrong "before rows" message to "after rows" message
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2907'>DRILL-2907</a>] - Drill performance degrades significantly over time - resource leak
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2914'>DRILL-2914</a>] - regression: Mondrian query534.q, drill give wrong result
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2921'>DRILL-2921</a>] - Query with a mix of distinct and not distinct scalar aggregates runs out of memory
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2927'>DRILL-2927</a>] - Pending query in resource queue starts after timeout
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2928'>DRILL-2928</a>] - C++ Client - io_service needs to be reset if it runs out of work
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2932'>DRILL-2932</a>] - Error text reported via System.out.println rather than thrown SQLException's message
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2934'>DRILL-2934</a>] - Exception when distinct aggregate is compared to numeric literal with decimal point
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2936'>DRILL-2936</a>] - TPCH 4 and 18 SF100 hangs when hash agg is turned off
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2940'>DRILL-2940</a>] - Large allocations are not released until GC kicks in
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2942'>DRILL-2942</a>] - Allow Use of epoll RPC layer on Linux
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2943'>DRILL-2943</a>] - Drill parsing error during deserialization for an Order-By
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2944'>DRILL-2944</a>] - Switch to G1GC to reduce GC cpu overhead.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2951'>DRILL-2951</a>] - Tables are not visible when Drillbit is specified in the connection URL
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2953'>DRILL-2953</a>] - Group By + Order By query results are not ordered.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2957'>DRILL-2957</a>] - Netty Memory Manager doesn't move empty chunks between lists
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2959'>DRILL-2959</a>] - Compression codecs are leaking or slow to recapture memory
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2960'>DRILL-2960</a>] - Default hive storage plugin missing from fresh drill install
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2961'>DRILL-2961</a>] - Statement.setQueryTimeout() should throw a SQLException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2962'>DRILL-2962</a>] - Correlated subquery with scalar aggregate or scalar aggregate with expression throws and error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2963'>DRILL-2963</a>] - Exists with empty left batch causes IllegalStateException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2966'>DRILL-2966</a>] - HAVING clause with CASE statement with IN predicate causes assertion
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2968'>DRILL-2968</a>] - crash on parquet file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2971'>DRILL-2971</a>] - If Bit<>Bit connection is unexpectedly closed and we were already blocked on writing to socket, we'll stay forever in ResettableBarrier.await()
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2973'>DRILL-2973</a>] - Error messages not showing up in sqlline
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2976'>DRILL-2976</a>] - Set default of extended JSON support for output to false until issues are resolved
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2977'>DRILL-2977</a>] - In WorkManager, startFragmentPendingRemote() and addFragmentRunner() need to be permuted
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2978'>DRILL-2978</a>] - FragmentManager is not removed from the WorkEventBus if it's FragmentExecutor is cancelled before it starts running
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2979'>DRILL-2979</a>] - Storage HBase doesn't support customized hbase property zookeeper.znode.parent
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2989'>DRILL-2989</a>] - TPCDS Query corrupts Drillbits and causing subsequent unrelated queries to hang (and timeout)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2993'>DRILL-2993</a>] - SQLLine hangs when we cancel a query in the middle of displaying results
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2994'>DRILL-2994</a>] - Incorrect error message when disconnecting from server (using direct connection to drillbit)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2998'>DRILL-2998</a>] - Update C++ client to send/receive heartbeat message
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3000'>DRILL-3000</a>] - I got JIRA report #3000. Now ... to use it for good or evil?
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3001'>DRILL-3001</a>] - Some functional tests fail when new text reader is disabled
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3005'>DRILL-3005</a>] - Spurious Error messages when using PrintingResultsListener
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3006'>DRILL-3006</a>] - CTAS with interval data type creates invalid parquet file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3007'>DRILL-3007</a>] - Update Drill configuration settings to avoid mmap threshold increases on Linux
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3009'>DRILL-3009</a>] - Reduce the IN list threshold to take advantage of Values operator
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3010'>DRILL-3010</a>] - Convert bad command error messages into UserExceptions in SqlHandlers
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3012'>DRILL-3012</a>] - Values Operator doesn't propagate operator id
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3017'>DRILL-3017</a>] - NPE when cleaning up some RecordReader implementations
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3018'>DRILL-3018</a>] - Queries with scalar aggregate and non equality (non correlated) fail to plan
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3020'>DRILL-3020</a>] - Some exception message text not displayed in SQLLine, etc.; copy to thrown SQLException's message
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3022'>DRILL-3022</a>] - Ensure sequential shutdown of Drillbits
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3033'>DRILL-3033</a>] - Add memory leak fixes found so far in DRILL-1942 to 1.0
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3037'>DRILL-3037</a>] - Unable to query on hdfs after moving to 0.9.0 version
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3046'>DRILL-3046</a>] - Memory Leak after cancelling a query
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3047'>DRILL-3047</a>] - Command failed while establishing connection
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3048'>DRILL-3048</a>] - Disable assertions by default
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3049'>DRILL-3049</a>] - Increase sort spooling threshold
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3050'>DRILL-3050</a>] - Increase query context max memory
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3051'>DRILL-3051</a>] - Integer overflow in TimedRunnable
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3052'>DRILL-3052</a>] - canceling a fragment executor before it starts running will cause the Foreman to wait indefinitely for a terminal message from that fragment
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3057'>DRILL-3057</a>] - A query that used to work before now fails in the optimizer
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3058'>DRILL-3058</a>] - RemoteConnection of RPC double closes the connection
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3061'>DRILL-3061</a>] - Fix memory leaks in TestDrillbitResilience
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3062'>DRILL-3062</a>] - regression: Mondrian query447.q - lots of rows missing in result set
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3063'>DRILL-3063</a>] - TestQueriesOnLargeFile leaks memory with 16M limit
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3065'>DRILL-3065</a>] - Memory Leak at ExternalSortBatch
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3066'>DRILL-3066</a>] - AtomicRemainder - Tried to close remainder, but it has already been closed.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3069'>DRILL-3069</a>] - Wrong result for aggregate query with filter on SF100
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3070'>DRILL-3070</a>] - Memory Leak when we run out of memory
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3071'>DRILL-3071</a>] - RecordBatchLoader#load leaks memory if an exception is thrown while loading the batch.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3072'>DRILL-3072</a>] - Profile UI fails to load when there is an empty json profile
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3074'>DRILL-3074</a>] - ReconnectingClient.waitAndRun can stuck in infinite loop if it fails to establish the connection
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3077'>DRILL-3077</a>] - sqlline's return code is 0 even when it force exits due to failed sql command
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3079'>DRILL-3079</a>] - Move JSON Execution Plan parsing to FragmentExecutor
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3080'>DRILL-3080</a>] - Error message is invalid if workload queue times out
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3081'>DRILL-3081</a>] - Fix situation where Drill reports null <--> null in connection error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3085'>DRILL-3085</a>] - In ExternalSortBatch, Memory Leak in Runtime Generation Code
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3087'>DRILL-3087</a>] - Union All returns incorrect results.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3088'>DRILL-3088</a>] - IllegalStateException: Cleanup before finished. 0 out of 1 strams have finished
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3089'>DRILL-3089</a>] - Revert to 4 forked test and allow override from command line
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3092'>DRILL-3092</a>] - Memory leak when an allocation fails near the creation of a RecordBatchData object
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3093'>DRILL-3093</a>] - Leaking RawBatchBuffer
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3098'>DRILL-3098</a>] - Set Unix style "line.separator" for tests
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3099'>DRILL-3099</a>] - FileSelection's selectionRoot does not include the scheme and authority
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3100'>DRILL-3100</a>] - TestImpersonationDisabledWithMiniDFS fails on Windows
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3101'>DRILL-3101</a>] - Setting "slice_target" to 1 changes the order of the columns in a "select *" query with order by
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3103'>DRILL-3103</a>] - EncoderException: RpcEncoder must produce at least one message.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3105'>DRILL-3105</a>] - OutOfMemoryError: GC overhead limit exceeded
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3107'>DRILL-3107</a>] - Dynamic partition pruning fails on Windows (TestDirectoryExplorerUDFs)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3109'>DRILL-3109</a>] - Cancellation from sqlline is broken with the updated version
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3110'>DRILL-3110</a>] - OutOfMemoryError causes memory accounting leak
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3112'>DRILL-3112</a>] - Drill UI profile page shows exceptions where a long running query is submitted via the UI
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3114'>DRILL-3114</a>] - Sqlline throws exception at launch
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3115'>DRILL-3115</a>] - SQLLine colors do not work well with CYGWIN
-</li>
-</ul>
-
-<h2> Improvement
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1662'>DRILL-1662</a>] - drillbit.sh stop should timeout
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2433'>DRILL-2433</a>] - Implicit cast between date and timestamp is missing in joins
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2508'>DRILL-2508</a>] - Add new column to sys.options table that exposes whether or not the current system value is the default
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2602'>DRILL-2602</a>] - Throw an error on schema change during streaming aggregation
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2697'>DRILL-2697</a>] - Pause injections should pause indefinitely until signalled
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2725'>DRILL-2725</a>] - Faster work assignment logic
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2772'>DRILL-2772</a>] - Display status of query when viewing the query's profile page
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2946'>DRILL-2946</a>] - Tableau 9.0 Desktop Enablement Document
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2955'>DRILL-2955</a>] - Enable color in sqlline for exceptions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2969'>DRILL-2969</a>] - Readers don't report number of records read in profile
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2981'>DRILL-2981</a>] - Add simplified activity log
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2982'>DRILL-2982</a>] - Tableau 9.0 Server Enablement Documentation
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2984'>DRILL-2984</a>] - UserException is logging through its parent class logger
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3027'>DRILL-3027</a>] - Add convenience methods to test builder for creating nested baseline values
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3053'>DRILL-3053</a>] - add unchecked exception injection site in ChildAllocator
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3084'>DRILL-3084</a>] - Add drill-* convenience methods for common cli startup commands
-</li>
-</ul>
-
-<h2> New Feature
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1573'>DRILL-1573</a>] - Add configuration to skip header row in text files
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2382'>DRILL-2382</a>] - enhance exception injection to support node-specific injections
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2383'>DRILL-2383</a>] - add exception and pause injections for testing drillbit stability
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2658'>DRILL-2658</a>] - Add ilike and regex substring functions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2958'>DRILL-2958</a>] - Move Drill to alternative cost-based planner for Join planning
-</li>
-</ul>
-
-<h2> Task
-</h2>
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2316'>DRILL-2316</a>] - Docs Enhancement: Data Sources and File Formats, Basics Tutorial
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2336'>DRILL-2336</a>] - configuration storage plugin docs update
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2364'>DRILL-2364</a>] - JSON Data Model Reference 2nd draft
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2381'>DRILL-2381</a>] - write lexical structures section, JSON/Parquet reference fixes, updates to data types
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2397'>DRILL-2397</a>] - Enhance SQL Ref Data Types docs
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2736'>DRILL-2736</a>] - review feedback on multitenancy and user auth
-</li>
-</ul>
-
-You can now [download Drill 1.0.0]({{ site.baseurl }}/download/).
-
-
-
http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/020-1.1.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/020-1.1.0-rn.md b/_docs/rn/020-1.1.0-rn.md
new file mode 100644
index 0000000..5f3ed11
--- /dev/null
+++ b/_docs/rn/020-1.1.0-rn.md
@@ -0,0 +1,367 @@
+---
+title: "Apache Drill 1.1.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:** July 5, 2015
+
+It has been about 6 weeks since the release of Drill 1.0.0. Today we're happy to announce the availability of Drill 1.1.0, providing 119 additional enhancements and bug fixes.
+
+## Noteworthy New Features in Drill 1.1.0
+
+Drill now supports window functions, automatic partitioning, and Hive impersonation.
+
+### [Ranking Window Functions]({{site.baseurl}}/docs/ranking-window-functions/)
+
+* ROW_NUMBER
+* RANK
+* DENSE_RANK
+* PERCENT_RANK
+* CUME _DIST
+
+### [Aggregate Window Functions]({{site.baseurl}}/docs/aggregate-window-functions/)
+
+* COUNT
+* SUM
+* MIN
+* MAX
+* AVG
+
+### [Automatic Partitioning]({{site.baseurl}}/docs/partition-pruning/#automatic-partitioning) in CTAS (DRILL-3333)
+
+When a table is created with a partition by clause, the parquet writer will create separate files for the different partition values. The data will first be sorted by the partition keys, and the parquet writer will create a new file when it encounters a new value for the partition columns.
+
+When queries are issued against data that was created this way, partition pruning will work if the filter contains a partition column. Unlike directory-based partitioning, no view is required, nor is it necessary to reference the dir* column names.
+
+### [Hive impersonation]({{site.baseurl}}/docs/configuring-user-impersonation-with-hive-authorization) support (DRILL-3203)
+
+When impersonation is enabled, Drill now supports impersonating the user who issued the query when accessing Hive metadata/data (instead of accessing Hive as the user that started the drillbit).
+
+## Enhancements and Bug Fixes
+
+<h2>Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3203'>DRILL-3203</a>] - Add support for impersonation in Hive storage plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3277'>DRILL-3277</a>] - SUM(CAST(columns[0] AS INT)) OVER(...) gives wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3278'>DRILL-3278</a>] - SUM(CAST(columns[0] AS BIGINT)) OVER(...) gives wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3281'>DRILL-3281</a>] - window functions that involve TIME columns generate wrong results
+</li>
+</ul>
+<h2>Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-669'>DRILL-669</a>] - Information Schema should be schema sensitive
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1315'>DRILL-1315</a>] - Allow specifying Zookeeper root znode and cluster-id as JDBC parameters
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1673'>DRILL-1673</a>] - Flatten function can not work well with nested arrays.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1820'>DRILL-1820</a>] - Fix broken SCM and project links caused by graduation of Drill to a Apache TLP
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2023'>DRILL-2023</a>] - Hive function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2137'>DRILL-2137</a>] - ResultsSetMetaData.getColumnName() returns "none" (rather than right class name)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2310'>DRILL-2310</a>] - Drill fails to start in embedded mode on windows
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2346'>DRILL-2346</a>] - Star is not expanded correctly in create view if view fields are specified
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2403'>DRILL-2403</a>] - TimePrintMillis.toString() misses leading zeros in post-decimal-point part
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2416'>DRILL-2416</a>] - Zookeeper in sqlline connection string does not override the entry from drill-override.conf
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2447'>DRILL-2447</a>] - Calling getObject on a closed ResultSet object should throw a SQLException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2449'>DRILL-2449</a>] - JDBC : DatabaseMetaData.getProcedures should return an empty result set
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2450'>DRILL-2450</a>] - JDBC : DatabaseMetaData.getColumns is missing the 'COLUMN_SIZE' in the result set
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2462'>DRILL-2462</a>] - JDBC : ResultSetMetaData.isNullable returns true even when the column is a required one
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2480'>DRILL-2480</a>] - [umbrella] Identify, fix INFORMATION_SCHEMA and JDBC metadata bugs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2494'>DRILL-2494</a>] - Binding parameters to a PreparedStatement throws a SQLException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2531'>DRILL-2531</a>] - getColumns() not right/implemented for INTERVAL types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2555'>DRILL-2555</a>] - JDBC driver throws RuntimeExceptions rather than SQLExceptions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2592'>DRILL-2592</a>] - Jdbc-all driver includes transitive dependencies
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2595'>DRILL-2595</a>] - Sqlline Usage needs to be corrected
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2622'>DRILL-2622</a>] - C++ Client valgrind errors in sync API
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2628'>DRILL-2628</a>] - sqlline hangs and then asserts when trying to execute anything on a dead JDBC connection
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2763'>DRILL-2763</a>] - [umbrella] Implement INFORMATION_SCHEMA.COLUMNS enough for relevant tools
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2782'>DRILL-2782</a>] - Decide, implement behavior for transaction-related JDBC methods
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2866'>DRILL-2866</a>] - Incorrect error message reporting schema change when streaming aggregation and hash join are disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2903'>DRILL-2903</a>] - Update TestDrillbitResilience tests so that they correctly manage canceled queries that get to complete too quickly.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2923'>DRILL-2923</a>] - Ensure all unit tests pass without assertions enabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2967'>DRILL-2967</a>] - Incompatible types error reported in a "not in" query with compatible data types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2985'>DRILL-2985</a>] - REGRESSION : NPE seen for project distinct values from CSV
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2988'>DRILL-2988</a>] - Correlated exists subquery returns wrong result if join columns in subquery are not fully qualified
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3004'>DRILL-3004</a>] - Failure in planning join when disabling hash join and exchanges
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3019'>DRILL-3019</a>] - Extra column in Schema of Recordbatch from scanning Values
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3028'>DRILL-3028</a>] - Exception in correlated subquery with exists when columns in subquery are not qualified
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3032'>DRILL-3032</a>] - Join between complex (nested repeated lists) data results in "LATE type is not supported"
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3034'>DRILL-3034</a>] - Apply UserException to port-binding error; handle UserException in embedded-Drill case
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3035'>DRILL-3035</a>] - Create ControlsInjector interface to enforce implementing methods
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3078'>DRILL-3078</a>] - Tracking bug for ODBC doc changes from Simba
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3094'>DRILL-3094</a>] - TPCH query 15 returns non-deterministic result
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3120'>DRILL-3120</a>] - Windows startup throws NPE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3125'>DRILL-3125</a>] - Drill UI Profile page fails to load for a query in some scenarios
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3134'>DRILL-3134</a>] - Doc: "Supported ... Types" section doesn't include complex types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3143'>DRILL-3143</a>] - MaterializedField#clone should deep copy itself without disregarding its children
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3144'>DRILL-3144</a>] - Doc.: JDBC Driver section is SQuirrel-specific, should be moved
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3147'>DRILL-3147</a>] - tpcds-sf1-parquet query 73 causes memory leak
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3155'>DRILL-3155</a>] - Composite vectors leak memory
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3159'>DRILL-3159</a>] - Make JDBC throttling threshold configurable
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3172'>DRILL-3172</a>] - Can not plan exception when over clause is empty
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3173'>DRILL-3173</a>] - Invalid inputs are NOT handled properly by Window functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3177'>DRILL-3177</a>] - Upgrade Mongo java driver to 3.0.1
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3179'>DRILL-3179</a>] - Example output doesn't match example data (ticket_sales.json) in Complex JSON doc
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3182'>DRILL-3182</a>] - Window function with DISTINCT qualifier returns seemingly incorrect result
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3183'>DRILL-3183</a>] - Query that uses window functions returns NPE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3188'>DRILL-3188</a>] - Restrict the types of window frames that can be specified
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3190'>DRILL-3190</a>] - Invalid FragmentState transition from CANCELLATION_REQUESTED in QueryManager
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3195'>DRILL-3195</a>] - Throw unsupported exception for Window functions that are not currently supported
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3196'>DRILL-3196</a>] - Disable multiple partition by clauses in the same sql query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3197'>DRILL-3197</a>] - Query that uses window functions fails
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3198'>DRILL-3198</a>] - JDBC driver returns null from DatabaseMetaData.getTypeInfo(...)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3199'>DRILL-3199</a>] - GenericAccessor doesn't support isNull
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3204'>DRILL-3204</a>] - Problem in name resolution with window functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3206'>DRILL-3206</a>] - Memory leak in window functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3208'>DRILL-3208</a>] - Hive : Tpch (SF 0.01) query 10 fails with a system error when the data is backed by hive tables
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3210'>DRILL-3210</a>] - Star is not expanded correctly in projection list when used with window function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3214'>DRILL-3214</a>] - Config option to cast empty string to null does not cast empty string to null
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3215'>DRILL-3215</a>] - Describe table from hive storage does not connect to "default" database
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3216'>DRILL-3216</a>] - Fix existing(+) INFORMATION_SCHEMA.COLUMNS columns
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3218'>DRILL-3218</a>] - Window function usage throws CompileException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3220'>DRILL-3220</a>] - IOB Exception when using constants in window functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3245'>DRILL-3245</a>] - Error message needs to be fixed.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3254'>DRILL-3254</a>] - Average over window functions returns wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3255'>DRILL-3255</a>] - Queries must fail when invalid-positions are specified in order by clause of a window function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3260'>DRILL-3260</a>] - Conflicting servlet-api jar causing web UI to be slow
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3262'>DRILL-3262</a>] - Rename missed .impl.DrillDatabaseMetaData to .impl.DrillDatabaseMetaDataImpl to
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3263'>DRILL-3263</a>] - Read smallint and tinyint data from hive as integer until these types are well supported throughout Drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3265'>DRILL-3265</a>] - Query with window function and sort below that spills to disk runs out of memory
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3266'>DRILL-3266</a>] - Drill's hive storage plugin cannot find RegexSerDe
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3268'>DRILL-3268</a>] - queries with empty OVER() clause return empty result set
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3269'>DRILL-3269</a>] - Window function query takes too long to complete and return results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3273'>DRILL-3273</a>] - Hive function 'concat_ws' not working from drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3275'>DRILL-3275</a>] - Difference in expected results - query that uses window functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3285'>DRILL-3285</a>] - Split DrillCursor.next(), clean up DrillCursor for clarity
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3293'>DRILL-3293</a>] - CTAS with window function fails with UnsupportedOperationException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3294'>DRILL-3294</a>] - False schema change exception in CTAS with AVG window function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3296'>DRILL-3296</a>] - Group By Union Distinct fails at planning
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3298'>DRILL-3298</a>] - Wrong result with SUM window function and order by without partition by in the OVER clause
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3305'>DRILL-3305</a>] - DrillOptiq should raise appropriate error message while dealing with unknown RexNode
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3306'>DRILL-3306</a>] - Concurrently Running hive queries results in a deadlock situation
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3307'>DRILL-3307</a>] - Query with window function runs out of memory
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3311'>DRILL-3311</a>] - sqlline hangs when query is cancelled while results are returned from the server
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3316'>DRILL-3316</a>] - Different SQLHandlers should go through the same planning logics for the same SELECT statement.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3318'>DRILL-3318</a>] - SUM(CAST(col as INT)) shows different results when used in window functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3321'>DRILL-3321</a>] - ZK PStore configuration needed to prevent Drill Web UI problems
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3324'>DRILL-3324</a>] - CTAS broken with the new auto partition feature ( Not in master yet)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3326'>DRILL-3326</a>] - Query with unsupported windows function containing "AS" blocks correct error message
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3327'>DRILL-3327</a>] - row_number function returns incorrect result when only order by clause is specified
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3328'>DRILL-3328</a>] - Cannot cast hive binary to varchar
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3333'>DRILL-3333</a>] - Add support for auto-partitioning in parquet writer
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3337'>DRILL-3337</a>] - Queries with Window Function DENSE_RANK fail with SchemaChangeException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3343'>DRILL-3343</a>] - Seemingly incorrect result with SUM window functions and float data type
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3344'>DRILL-3344</a>] - When Group By clause is present, the argument in window function should not refer to any column outside Group By
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3345'>DRILL-3345</a>] - TestWindowFrame fails to properly check cases involving multiple batches
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3346'>DRILL-3346</a>] - Windowing query over View should display a better error message
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3357'>DRILL-3357</a>] - Error when adding 2 columns together
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3359'>DRILL-3359</a>] - Drill should throw and error when window function defined using WINDOW AS uses ROWS UNBOUNDED PRECEDING
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3361'>DRILL-3361</a>] - CTAS Auto Partitioning: Fails when we use boolean as the partition type
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3370'>DRILL-3370</a>] - FLATTEN error with a where clause
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3373'>DRILL-3373</a>] - CTAS partition by with empty list of partitioning columns should be blocked in parser
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3374'>DRILL-3374</a>] - CTAS with PARTITION BY, partition column name from view can not be resolved
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3376'>DRILL-3376</a>] - Reading individual files created by CTAS with partition causes an exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3377'>DRILL-3377</a>] - Can't partition by expression when columns are explicitly specified in the CTAS column list
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3378'>DRILL-3378</a>] - Average over window on a view returns wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3380'>DRILL-3380</a>] - CTAS Auto Partitioning : We are not pruning when we use functions in the select list
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3398'>DRILL-3398</a>] - WebServer is leaking memory for queries submitted through REST API or WebUI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3400'>DRILL-3400</a>] - After shifting CTAS's data, query on CTAS table failed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3404'>DRILL-3404</a>] - Filter on window function does not appear in query plan
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3408'>DRILL-3408</a>] - CTAS partition by columns[i] from csv fails
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3410'>DRILL-3410</a>] - Partition Pruning : We are doing a prune when we shouldn't
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3411'>DRILL-3411</a>] - CTAS Partition by column in deeper layer fails
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3413'>DRILL-3413</a>] - Use DIGEST mechanism in creating Hive MetaStoreClient for proxy users when SASL authentication is enabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3418'>DRILL-3418</a>] - Partition Pruning : We are over-pruning and this leads to wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3422'>DRILL-3422</a>] - Multiple unit test failures on Windows with current master
+</li>
+</ul>
+
+<h2>Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-745'>DRILL-745</a>] - Drill fails to read the schema of avro tables from hive when the schema is in a separate file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-959'>DRILL-959</a>] - drill fails to display binary in hive correctly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1862'>DRILL-1862</a>] - over clause with only order by clause throws an exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2086'>DRILL-2086</a>] - mapr profile - use MapR 4.0.2
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2272'>DRILL-2272</a>] - Tibco Spotfire Desktop configuration for Drill documentation
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2405'>DRILL-2405</a>] - Generate test data for window function instead of downloading it from S3
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2746'>DRILL-2746</a>] - Filter is not pushed into subquery past UNION ALL
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2764'>DRILL-2764</a>] - REST API should return exception details on error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2839'>DRILL-2839</a>] - ODBC Driver Doc to point to latest available Driver, also provide compatibility matrix for Drill and ODBC version
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2997'>DRILL-2997</a>] - Remove references to groupCount from SerializedField
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3025'>DRILL-3025</a>] - Tibco Spotfire Server - JDBC - Configuration Document
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3108'>DRILL-3108</a>] - Replace templated returns with covariant return overrides
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3130'>DRILL-3130</a>] - Project can be pushed below union all / union to improve performance
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3148'>DRILL-3148</a>] - JReport enablement document for Drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3200'>DRILL-3200</a>] - Add Window functions: ROW_NUMBER, RANK, PERCENT_RANK, DENSE_RANK and CUME_DIST
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3240'>DRILL-3240</a>] - Fetch hadoop maven profile specific Hive version in Hive storage plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3304'>DRILL-3304</a>] - improve org.apache.drill.exec.expr.TypeHelper error messages when UnsupportedOprationException is thrown
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3319'>DRILL-3319</a>] - UserExceptions should be logged from the right class
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3320'>DRILL-3320</a>] - Do away with "rebuffing" Drill jar
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3421'>DRILL-3421</a>] - Add new outputformat=json
+</li>
+</ul>
+
+<h2> New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1169'>DRILL-1169</a>] - Add support for UNION (distinct type)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3246'>DRILL-3246</a>] - Query planning support for partition by clause in Drill's CTAS statement
+</li>
+</ul>
+
+<h2> Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2420'>DRILL-2420</a>] - [umbrella] Identify, fix DatabaseMetaData.getColumns() bugs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2952'>DRILL-2952</a>] - Hive 1.0 plugin for Drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2983'>DRILL-2983</a>] - Bridget's User Auth Doc
+</li>
+</ul>
+
+
+
http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/030-0.9.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/030-0.9.0-rn.md b/_docs/rn/030-0.9.0-rn.md
deleted file mode 100755
index fcc5b8e..0000000
--- a/_docs/rn/030-0.9.0-rn.md
+++ /dev/null
@@ -1,29 +0,0 @@
----
-title: "Apache Drill 0.9.0 Release Notes"
-parent: "Release Notes"
----
-It has been about a month since the release of Drill 0.8, which included [more than 240 improvements]({{ site.baseurl }}/blog/2016/08/30/drill-1.8-released/). Today we're happy to announce the availability of Drill 0.9, providing additional enhancements and bug fixes. In fact, this release includes [200 resolved JIRAs](https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12328813). Some of the noteworthy features in Drill 0.9 are:
-
-* **Authentication** ([DRILL-2674](https://issues.apache.org/jira/browse/DRILL-2674)). Drill now supports username/password authentication through the Java and C++ clients, as well as JDBC and ODBC. On the server-side, Drill leverages Linux PAM to securely validate the credentials. Users can choose to use an external user directory such as Active Directory or LDAP. To enable authentication, set the `security.user.auth` option in `drill-override.conf`.
-* **Impersonation** ([DRILL-2363](https://issues.apache.org/jira/browse/DRILL-2363)). Queries now execute and access resources using the identity of the user who submitted the query. Previously, all queries would run as the same user (eg, `drill`). With the new impersonation capability, the query will fail if the submitting user does not have permission to read the requested file(s) in the distributed file system. To enable impersonation, set the `drill.exec.impersonation` option in `drill-override.conf`.
-* **Ownership chaining**. Drill now allows views with different owners to be chained. This represents a very flexible access control solution. For example, an administrator with access to raw, sensitive data could create a view called `masked` which would expose only a subset of the data to other users. The administrator would enable users to read the `masked` view but not the raw data. Note that Drill provides an option `max_chained_user_hops` that specifies how many ownership changed are allowed in a chain, thereby providing administrators (or data stewards) more control over sharing of data.
-* **MongoDB authentication** ([DRILL-1502](https://issues.apache.org/jira/browse/DRILL-1502)). Drill can now connect to a MongoDB cluster that requires authentication.
-* **Extended JSON datatypes**. Our friends at MongoDB invented [extended JSON](http://docs.mongodb.org/manual/reference/mongodb-extended-json/) - a set of extensions to the JSON format for supporting additional data types. We decided to embrace extended JSON in Drill. For example, standard JSON doesn't have a time type, so a time could be represented as either a string or a number: `{"foo": "19:20:30.450Z"}` is just a string. With extended JSON, the `$time` qualifier can be used to specify that `foo` is a time `{"foo": {"$time": "19:20:30.450Z"}}`.
- We now support a number of qualifiers including `$bin`, `$date`, `$time`, `$interval`, `$numberLong` and `$dateDay` (see [the example](https://github.com/apache/drill/blob/master/exec/java-exec/src/test/resources/vector/complex/extended.json)). We're in the process of adding some additional qualifiers to make sure that all of MongoDB's extended types are supported (this is particularly important when querying data in MongoDB).
-* **Avro support** ([DRILL-1512](https://issues.apache.org/jira/browse/DRILL-1512)). Drill can now read Avro files. This patch was contributed by Andrew Selden at Elastic.co (formerly known as Elasticsearch).
-* **Improved error messages** ([DRILL-2675](https://issues.apache.org/jira/browse/DRILL-2675) and more). It can be challenging for a complex distributed system like Drill to translate low-level internal conditions into actionable messages to the user. This release includes several enhancements that enable Drill to accomplish just that in a variety of cases.
-* **Parquet and Calcite enhancements** ([DRILL-1410](https://issues.apache.org/jira/browse/DRILL-1410) and [DRILL-1384](https://issues.apache.org/jira/browse/DRILL-1384)). Drill isn't a traditional query engine - it's the first analytical query engine with a JSON data model. This has required us to enhance Parquet (our columnar format) and Calcite (our SQL parser). These enhancements have now been contributed back to those projects, and Drill is using the latest versions which include these enhancements.
-* **New sys tables for memory and thread information** ([DRILL-2275](https://issues.apache.org/jira/browse/DRILL-2275)). Drill includes two new `sys` tables that provide real-time metrics about memory utilization and threads on each of the nodes in the cluster. You can run a simple `SELECT *` to see what information is available:
-
- ```sql
- SELECT * FROM sys.drillmemory;
- SELECT * FROM sys.drillbitthreads;
- ```
-
-* **Support for very wide tables** ([DRILL-2739](https://issues.apache.org/jira/browse/DRILL-2739)). Drill previously had some issues with tables that had more than 4095 colums. This limitation has been addressed.
-
-You can now [download Drill 0.9]({{ site.baseurl }}/download/). As always, you can check out the official [release notes]({{ site.baseurl }}/docs/release-notes/) for more details.
-
-We're gearing up for Drill's 1.0 release later this month. Stay tuned!
-
-