drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [3/6] drill git commit: Doc updates for the Drill 1.11 Release
Date Mon, 31 Jul 2017 04:45:53 GMT
http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/010-1.1.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/010-1.1.0-rn.md b/_docs/rn/010-1.1.0-rn.md
deleted file mode 100755
index 5f3ed11..0000000
--- a/_docs/rn/010-1.1.0-rn.md
+++ /dev/null
@@ -1,367 +0,0 @@
----
-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 &quot;none&quot; (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 &#39;COLUMN_SIZE&#39; 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 &quot;not in&quot; 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 &quot;LATE type is not supported&quot;
-</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:  &quot;Supported ... Types&quot; section doesn&#39;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&#39;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&#39;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 &quot;default&quot; 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&#39;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 &#39;concat_ws&#39; 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 &quot;AS&quot; 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&#39;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&#39;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&#39;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 &quot;rebuffing&quot; 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&#39;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&#39;s User Auth Doc
-</li>
-</ul>
-
-
-

http://git-wip-us.apache.org/repos/asf/drill/blob/ec54d586/_docs/rn/010-1.2.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/010-1.2.0-rn.md b/_docs/rn/010-1.2.0-rn.md
new file mode 100644
index 0000000..572db45
--- /dev/null
+++ b/_docs/rn/010-1.2.0-rn.md
@@ -0,0 +1,509 @@
+---
+title: "Apache Drill 1.2.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:**  October 16, 2015
+
+Today we're happy to announce the availability of Drill 1.2.0, providing more than 150 bug fixes and a number of new features. These release notes include links to the following Jira issues:
+
+* [Enhancements and bug fixes]({{site.baseurl}}/docs/apache-drill-1-2-0-release-notes/#enhancements-and-bug-fixes)
+* [Important unresolved issues]({{site.baseurl}}/docs/apache-drill-1-2-0-release-notes/#important-unresolved-issues)
+
+## Noteworthy New Features in Drill 1.2.0
+
+This release of Drill introduces a number of enhancements, including the following ones:
+
+* Support for JDBC data sources, such as MySQL, through a [new JDBC Storage plugin]({{site.baseurl}}/docs/rdbms-storage-plugin/#example:-working-with-mysql)  
+* Improvements in the Drill JDBC driver including inclusion of
+[Javadocs]({{site.baseurl}}/api/1.2/jdbc/) and better application dependency compatibility  
+* Enhancements to Avro file formats  
+  * [Support for complex data types](https://issues.apache.org/jira/browse/DRILL-3565), such as UNION and MAP  
+  * [Optimized Avro file processing](https://issues.apache.org/jira/browse/DRILL-3720) (block-wise)  
+* Partition pruning improvements  
+* A number of new [SQL window functions]({{site.baseurl}}/docs/sql-window-functions)  
+  * NTILE  
+  * LAG and LEAD  
+  * FIRST_VALUE and LAST_VALUE  
+* [HTTPS support]({{site.baseurl}}/docs/configuring-web-console-and-rest-api-security/) for Web Console operations  
+* Performance improvements for [querying HBase]({{site.baseurl}}/docs/querying-hbase/#querying-big-endian-encoded-data), which includes leveraging [ordered byte encoding]({{site.baseurl}}/docs/querying-hbase/#leveraging-hbase-ordered-byte-encoding)  
+* [Optimized reads]({{site.baseurl}}/docs/querying-hive/#optimizing-reads-of-parquet-backed-tables) of Parquet-backed, Hive tables  
+* Read support for the [Parquet INT96 type]({{site.baseurl}}/docs/parquet-format/#about-int96-support) and a new TIMESTAMP_IMPALA type used with the [CONVERT_FROM]({{site.baseurl}}/docs/supported-data-types/#data-types-for-convert_to-and-convert_from-functions) function decodes a timestamp from Hive or Impala.  
+* [Parquet metadata caching]({{site.baseurl}}/docs/optimizing-parquet-metadata-reading/) to improve query performance on a large number of files
+* [DROP TABLE]({{site.baseurl}}/docs/drop-table/) command  
+* Improved correlated subqueries  
+* Union Distinct  
+* Improved LIMIT processing  
+
+## Enhancements and Bug Fixes
+
+<h2>        Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3364'>DRILL-3364</a>] -         Prune scan range if the filter is on the leading field with byte comparable encoding
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3553'>DRILL-3553</a>] -         add support for LEAD and LAG window functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3608'>DRILL-3608</a>] -         add support for FIRST_VALUE and LAST_VALUE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3616'>DRILL-3616</a>] -         Memory leak in a cleanup code after canceling queries with window functions spilling to disk
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3619'>DRILL-3619</a>] -         Add support for NTILE window function
+</li>
+</ul>
+                            
+<h2>        Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-343'>DRILL-343</a>] -         Document update required to describe sqlline usage for Windows
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1395'>DRILL-1395</a>] -         UNION ALL query fails &quot;while setting up Foreman&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1457'>DRILL-1457</a>] -         Limit operator optimization : push limit operator past exchange operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1651'>DRILL-1651</a>] -         Allow Filter to push past Project with ITEM operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1773'>DRILL-1773</a>] -         Issues when using JAVA code through Drill JDBC driver
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1795'>DRILL-1795</a>] -         TPCH SF1000 Queries fail with DecoderException: java.lang.NullPointerException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1816'>DRILL-1816</a>] -         Scan Error with JSON on large no of records with Complex Types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1831'>DRILL-1831</a>] -         LIKE operator not working with SQL [charlist] Wildcard
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1929'>DRILL-1929</a>] -         After canceling query in sqlline subsequent query in same session hangs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1938'>DRILL-1938</a>] -         Fix error message when reserved words are used in query.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1976'>DRILL-1976</a>] -         Possible Memory Leak in drill jdbc client when dealing with wide columns (5000 chars long)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2050'>DRILL-2050</a>] -         Accountor closed with outstanding buffer
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2053'>DRILL-2053</a>] -         Column names are case sensitive if column is coming from WITH clause
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2095'>DRILL-2095</a>] -         Order by on a repeated index inside a sub query results in an NPE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2098'>DRILL-2098</a>] -         correct startup on windows
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2166'>DRILL-2166</a>] -         left join with complex type throw ClassTransformationException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2190'>DRILL-2190</a>] -         Failure to order by function if DISTINCT clause is present
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2274'>DRILL-2274</a>] -         Unable to allocate sv2 buffer after repeated attempts : JOIN, Order by used in query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2304'>DRILL-2304</a>] -         Case sensitivity - system and session options are case sensitive
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2312'>DRILL-2312</a>] -         JDBC driver returning incorrect data after extended usage
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2313'>DRILL-2313</a>] -         Query fails when one of the operands is a DATE literal without an explicit cast
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2318'>DRILL-2318</a>] -         Query fails when an ORDER BY clause is used with WITH-CLAUSE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2361'>DRILL-2361</a>] -         Column aliases cannot include dots
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2398'>DRILL-2398</a>] -         IS NOT DISTINCT FROM predicate returns incorrect result when used as a join filter
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2418'>DRILL-2418</a>] -         Memory leak during execution if comparison function is not found
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2445'>DRILL-2445</a>] -         JDBC : Connection.rollback method currently throws UnsuportedOperationException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2451'>DRILL-2451</a>] -         JDBC : Connection.commit throws an UnsupportedOperationException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2459'>DRILL-2459</a>] -         INFO._SCHEMA&#39;s CHARACTER_MAXIMUM_LENGTH is -1 for type CHAR
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2482'>DRILL-2482</a>] -         JDBC : calling getObject when the actual column type is &#39;NVARCHAR&#39; results in NoClassDefFoundError
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2519'>DRILL-2519</a>] -         INFORMATION_SCHEMA.COLUMNS is missing &lt;interval_qualifier&gt; info
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2522'>DRILL-2522</a>] -         Implement INFORMATION_SCHEMA.* enough for relevant tools [bug]
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2530'>DRILL-2530</a>] -         getColumns() doesn&#39;t return right COLUMN_SIZE for INTERVAL types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2588'>DRILL-2588</a>] -         Profile UI: &quot;First Start&quot; field contains incorrect data  
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2625'>DRILL-2625</a>] -         org.apache.drill.common.StackTrace should follow standard stacktrace format
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2643'>DRILL-2643</a>] -         HashAggBatch/HashAggTemplate call incoming.cleanup() twice resulting in warnings
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2644'>DRILL-2644</a>] -         Data Types page should list and describe all data types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2649'>DRILL-2649</a>] -         Math and Trig page seems to refer to types that are not Drill SQL types
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2650'>DRILL-2650</a>] -         Cancelled queries json profile shows query end time occurs before fragments end time 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2688'>DRILL-2688</a>] -         Use of ORDER BY on right side of Union All results in SqlValidatorException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2721'>DRILL-2721</a>] -         Identify, fix _existing_ INFO._SCHEMA columns in conflict with SQL spec. by 1.0
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2722'>DRILL-2722</a>] -         Query profile data not being sent/received (and web UI not updated)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2724'>DRILL-2724</a>] -         Implicit cast test fails in Union All query (reports type mismatch)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2727'>DRILL-2727</a>] -         CTAS select * from CSV file results in Exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2737'>DRILL-2737</a>] -         Sqlline throws Runtime exception when JDBC ResultSet throws a SQLException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2745'>DRILL-2745</a>] -         Query returns IOB Exception when JSON data with empty arrays is input to flatten function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2760'>DRILL-2760</a>] -         Quoted strings from CSV file appear in query output in different forms
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2777'>DRILL-2777</a>] -         CTAS, order by and flatten of repeated list result in ExpandConversionRule error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2800'>DRILL-2800</a>] -         Performance regression introduced with commit: a6df26a  (Patch for DRILL-2512)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2802'>DRILL-2802</a>] -         Projecting dir[n] by itself results in projecting of all columns
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2815'>DRILL-2815</a>] -         Some PathScanner logging, misc. cleanup.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2837'>DRILL-2837</a>] -         Resolve what Statement.cancel() really should do
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2843'>DRILL-2843</a>] -         Reading empty CSV file fails with error (rather than yielding zero rows)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2851'>DRILL-2851</a>] -         Memory LEAK - FLATTEN function fails when input array has 99,999 integer type elements
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2852'>DRILL-2852</a>] -         CASTing the column &#39;dir0&#39; in view causes partition pruning to fail 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2862'>DRILL-2862</a>] -         Convert_to/Convert_From throw assertion when an incorrect encoding type is specified
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2864'>DRILL-2864</a>] -         Unable to cast string literal with the valid value in ISO 8601 format to interval
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2867'>DRILL-2867</a>] -         Session level parameter drill.exec.testing.controls  appears to be set even though it was not
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2890'>DRILL-2890</a>] -         C++ Client: Update query submitter usage to clarify using authentication 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2924'>DRILL-2924</a>] -         IOBException when querying a table which has 1 file and a subfolder with 1 file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2935'>DRILL-2935</a>] -         Casting varchar to varbinary fails
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2937'>DRILL-2937</a>] -         Result for integer values from json files contains &quot;$numberLong&quot; in front of value
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2949'>DRILL-2949</a>] -         TPC-DS queries 1 and 30 fail with CannotPlanException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3030'>DRILL-3030</a>] -         Foreman hangs trying to cancel non-root fragments
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3045'>DRILL-3045</a>] -         Drill is not partition pruning due to internal off-heap memory limit for planning phase
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3056'>DRILL-3056</a>] -         Numeric literal in an IN list is casted to decimal even when decimal type is disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3076'>DRILL-3076</a>] -         USING clause should not be supported in drill 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3095'>DRILL-3095</a>] -         Memory Leak : Failure while closing accountor.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3096'>DRILL-3096</a>] -         &quot;State change requested from ... --&gt; ... for &quot; blank after &quot;for&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3122'>DRILL-3122</a>] -         Changing a session option to default value results in status as changed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3133'>DRILL-3133</a>] -         MergingRecordBatch can leak memory if query is canceled before batches in rawBatches were loaded
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3141'>DRILL-3141</a>] -         sqlline throws an exception when query is cancelled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3151'>DRILL-3151</a>] -         ResultSetMetaData not as specified by JDBC (null/dummy value, not &quot;&quot;/etc.)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3153'>DRILL-3153</a>] -         DatabaseMetaData.getIdentifierQuoteString() returns (standard) double-quote, not Drill&#39;s back quote
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3156'>DRILL-3156</a>] -         Calcite tracing is broken in Drill 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3160'>DRILL-3160</a>] -         Make JDBC Javadoc documentation available to users
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3163'>DRILL-3163</a>] -         Fix hang/ leak issue exposed by TestDrillbitResilience#foreman_runTryEnd
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3189'>DRILL-3189</a>] -         Disable ALLOW PARTIAL/DISALLOW PARTIAL in window function grammar
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3243'>DRILL-3243</a>] -         Need a better error message - Use of alias in window function definition
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3257'>DRILL-3257</a>] -         TPCDS query 74 results in a StackOverflowError on Scale Factor 1
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3271'>DRILL-3271</a>] -         Hive : Tpch 01.q fails with a verification issue for SF100 dataset
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3284'>DRILL-3284</a>] -         Document incompatibility between drill&#39;s to_date and hive&#39;s unix_timestamp
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3287'>DRILL-3287</a>] -         Changing session level parameter back to the default value does not change it&#39;s status back to DEFAULT
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3292'>DRILL-3292</a>] -         SUM(constant) OVER(...) returns wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3297'>DRILL-3297</a>] -         Using rank, dense_rank, percent_rank, cume_dist, row_number window functions without OVER clause results in cryptic schema change error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3312'>DRILL-3312</a>] -         PageReader.allocatePageData() calls BufferAllocator.buffer(int) but doesn&#39;t check if the result is null
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3322'>DRILL-3322</a>] -         Something broken in or around RPC timeout setup?
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3347'>DRILL-3347</a>] -         Resolve: ResultSet.getObject(...) for VARCHAR returns ...hadoop.io.Text, not String
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3348'>DRILL-3348</a>] -         NPE when two different window functions are used in projection list and order by clauses
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3360'>DRILL-3360</a>] -         Window function defined within another window function 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3382'>DRILL-3382</a>] -         CTAS with order by clause fails with IOOB exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3393'>DRILL-3393</a>] -         Quotes not being recognized in tab delimited (tsv) files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3412'>DRILL-3412</a>] -         Projections are not getting push down below Window operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3441'>DRILL-3441</a>] -         CompliantTextRecordReader#isStarQuery loops indefinitely
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3445'>DRILL-3445</a>] -         BufferAllocator.buffer() implementations should throw an OutOfMemoryRuntimeException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3448'>DRILL-3448</a>] -         typo in QueryManager.DrillbitStatusListener will cause the Foreman to hang if a Drillbit dies
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3455'>DRILL-3455</a>] -         If a drillbit, that contains fragments for the current query, dies the QueryManager will fail the query even if those fragments already finished successfully
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3463'>DRILL-3463</a>] -         Unit test of project pushdown in TestUnionAll should put more precisely plan attribute  in plan verification. 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3464'>DRILL-3464</a>] -         Index out of bounds exception while performing concat()
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3476'>DRILL-3476</a>] -         Filter on nested element gives wrong results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3479'>DRILL-3479</a>] -         Sqlline from drill v1.1.0 displays version as 1.0.0
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3483'>DRILL-3483</a>] -         Clarify CommonConstants&#39; constants.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3484'>DRILL-3484</a>] -         Error using functions with no parameters when `drill.exec.functions.cast_empty_string_to_null` is set to true
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3497'>DRILL-3497</a>] -         Throw UserException#validationError for errors when modifying options
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3500'>DRILL-3500</a>] -         Provide additional information while registering storage plugin optimizer rules
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3502'>DRILL-3502</a>] -         JDBC driver can cause conflicts
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3503'>DRILL-3503</a>] -         Make PruneScanRule have a pluggable partitioning mechanism
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3509'>DRILL-3509</a>] -         Empty JSON files trigger exception when used in a union
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3537'>DRILL-3537</a>] -         Empty Json file can potentially result into wrong results 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3542'>DRILL-3542</a>] -         Rebase Drill on Calcite 1.4.0 release
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3550'>DRILL-3550</a>] -         Incorrect results reading complex data with schema change
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3551'>DRILL-3551</a>] -         CTAS from complex Json source with schema change  is not written (and hence not read back ) correctly
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3554'>DRILL-3554</a>] -         Union over TIME and TIMESTAMP values throws SchemaChangeException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3555'>DRILL-3555</a>] -         Changing defaults for planner.memory.max_query_memory_per_node causes queries with window function to fail
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3557'>DRILL-3557</a>] -         Reading empty CSV file fails with SYSTEM ERROR
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3566'>DRILL-3566</a>] -         Calling Connection.prepareStatement throws a ClassCastException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3573'>DRILL-3573</a>] -         Enable TPC-H query 17 in unit tests
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3574'>DRILL-3574</a>] -         Empty Over Clause should trigger Union-Exchange to be added below
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3579'>DRILL-3579</a>] -         Drill on Hive query fails if partition table has __HIVE_DEFAULT_PARTITION__
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3580'>DRILL-3580</a>] -         wrong plan for window function queries containing function(col1 + colb)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3583'>DRILL-3583</a>] -         SUM on varchar column produces incorrect error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3595'>DRILL-3595</a>] -         Wrong results returned by query that uses LEAD window function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3596'>DRILL-3596</a>] -         Allow only (&lt;expression&gt;) or (&lt;expression&gt;, 1) for LEAD and LAG window functions as input parameters
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3599'>DRILL-3599</a>] -         Wrong results returned by LEAD(col-name, -1) 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3601'>DRILL-3601</a>] -         LEAD function used without OVER clause should not plan
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3604'>DRILL-3604</a>] -         LEAD(&lt;varchar-column&gt;) returns IOB Exception 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3605'>DRILL-3605</a>] -         Wrong results - Lead(char-column) 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3606'>DRILL-3606</a>] -         Wrong results - Lead(char-column) without PARTITION BY clause
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3617'>DRILL-3617</a>] -         Apply &quot;shading&quot; to JDBC-all Jar file to avoid version conflicts
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3621'>DRILL-3621</a>] -         Wrong results when Drill on Hbase query contains rowkey &quot;or&quot; or &quot;IN&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3622'>DRILL-3622</a>] -         With user authentication enabled, only admin users should be able to change system options
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3635'>DRILL-3635</a>] -         IllegalArgumentException - not a Parquet file (too small)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3638'>DRILL-3638</a>] -         Incorrect results LEAD(&lt;float-type-column&gt;) 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3642'>DRILL-3642</a>] -         External Sort will leak memory if query is cancelled while it&#39;s spilling to disk
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3643'>DRILL-3643</a>] -         NTILE(0) returns RuntimeException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3645'>DRILL-3645</a>] -         typo in drill documentation 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3648'>DRILL-3648</a>] -         NTILE function returns incorrect results
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3649'>DRILL-3649</a>] -         LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3653'>DRILL-3653</a>] -         Assert in a query with both avg aggregate and avg window aggregate functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3654'>DRILL-3654</a>] -         FIRST_VALUE(&lt;char-column&gt;/&lt;varchar-column&gt;) returns IOB Exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3657'>DRILL-3657</a>] -         Wrong result with SUM(1) window function when multiple partitions are present
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3658'>DRILL-3658</a>] -         Missing org.apache.hadoop in the JDBC jar
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3663'>DRILL-3663</a>] -         Drill View aliases being lost via ‘order by’
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3667'>DRILL-3667</a>] -         Random Assertion Error while planning
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3668'>DRILL-3668</a>] -         Incorrect results FIRST_VALUE function
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3673'>DRILL-3673</a>] -         Memory leak in parquet writer on CTAS
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3677'>DRILL-3677</a>] -         Wrong result with LEAD window function when used in multiple windows in the same query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3679'>DRILL-3679</a>] -         IOB Exception : when window functions used in outer and inner query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3680'>DRILL-3680</a>] -         window function query returns Incorrect results 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3684'>DRILL-3684</a>] -         CTAS : Memory Leak when using CTAS with tpch sf100
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3685'>DRILL-3685</a>] -         Failure to execute query with NTILE and ROW_NUMBER window functions with different window definitions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3689'>DRILL-3689</a>] -         incorrect results : aggregate AVG returns wrong results over results returned by LEAD function.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3690'>DRILL-3690</a>] -         Partitioning pruning produces wrong results when there are nested expressions in the filter
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3691'>DRILL-3691</a>] -         CTAS Memory Leak : IllegalStateException
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3700'>DRILL-3700</a>] -         Exception in a query with multiple fist_value window functions with different partitions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3702'>DRILL-3702</a>] -         PartitionPruning hit ClassCastException in Interpreter when the pruning filter expression is of non-nullable type.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3707'>DRILL-3707</a>] -         Fix for DRILL-3616 can cause a NullPointerException in ExternalSort cleanup
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3711'>DRILL-3711</a>] -         Windows unit test failure on 1.2 snapshot 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3716'>DRILL-3716</a>] -         Drill should push filter past aggregate in order to improve query performance.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3718'>DRILL-3718</a>] -         quotes in .tsv trigger exception 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3719'>DRILL-3719</a>] -         Adding negative sign in front of EXTRACT triggers Assertion Error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3732'>DRILL-3732</a>] -         Drill leaks memory if external sort hits out of disk space exception
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3735'>DRILL-3735</a>] -         Directory pruning is not happening when number of files is larger than 64k
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3736'>DRILL-3736</a>] -         Documentation for partition is misleading/wrong syntax
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3737'>DRILL-3737</a>] -         CTAS from empty text file fails with NPE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3746'>DRILL-3746</a>] -         Hive query fails if the table contains external partitions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3757'>DRILL-3757</a>] -         Link to IntelliJ IDEA settings jar on the contributors guidelines page is broken.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3758'>DRILL-3758</a>] -         InvalidRecordException while selecting from a table with multiple parquet file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3767'>DRILL-3767</a>] -         SchemaPath.getCompoundPath(String...strings) reverses it&#39;s input array
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3773'>DRILL-3773</a>] -         Mongo RecordReader projection pushdown doesn&#39;t work past first level paths
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3778'>DRILL-3778</a>] -         Add rest of DRILL-3160 (making JDBC Javadoc available)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3779'>DRILL-3779</a>] -         NPE during mergeAndSpill operation of external sort
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3781'>DRILL-3781</a>] -         Using CURRENT_DATE in a group by throws a column not found error for hive tables and csv files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3783'>DRILL-3783</a>] -         Incorrect results : COUNT(&lt;column-name&gt;) over results returned by UNION ALL 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3784'>DRILL-3784</a>] -         simple Jdbc program fails with NoClassDefFoundError
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3788'>DRILL-3788</a>] -         Directory based partition pruning not taking effect with metadata caching
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3809'>DRILL-3809</a>] -         PrelFinalizable.SHUTTLE causes ArrayIndexOutOfBoundsException when multiple queries are run concurrently
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3811'>DRILL-3811</a>] -         AtomicRemainder incorrectly accounts for transferred allocations
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3817'>DRILL-3817</a>] -         Refresh metadata does not work when used with sub schema  
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3819'>DRILL-3819</a>] -         Remove redundant filter for files start with &quot;.&quot;
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3884'>DRILL-3884</a>] -         Hive native scan has lower parallelization leading to performance degradation
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3892'>DRILL-3892</a>] -         Metadata cache not being leveraged when partition pruning is taking place
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3901'>DRILL-3901</a>] -         Performance regression with doing Explain of COUNT(*) over 100K files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3917'>DRILL-3917</a>] -         IllegalArgumentException when running query after creating metadata cache
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3918'>DRILL-3918</a>] -         Avoid extra loading of the metadata cache file
+</li>
+</ul>
+                        
+<h2>        Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1666'>DRILL-1666</a>] -         Provide Test cases for Mongo Storage plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2332'>DRILL-2332</a>] -         Drill should be consistent with Implicit casting rules across data formats
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2424'>DRILL-2424</a>] -         Ignore hidden files in directory path
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2699'>DRILL-2699</a>] -         Collect all cleanup errors before reporting a failure to the client
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2748'>DRILL-2748</a>] -         Filter is not pushed down into subquery with the group by
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2908'>DRILL-2908</a>] -         Support reading the Parquet int 96 type
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3121'>DRILL-3121</a>] -         Hive partition pruning is not happening
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3209'>DRILL-3209</a>] -         [Umbrella] Plan reads of Hive tables as native Drill reads when a native reader for the underlying table format exists
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3295'>DRILL-3295</a>] -         UNION (distinct type) is supported now
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3341'>DRILL-3341</a>] -         Move OperatorWrapper list and FragmentWrapper list creation to ProfileWrapper ctor
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3354'>DRILL-3354</a>] -         TestBuilder can check if the number of result batches equals some expected value
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3450'>DRILL-3450</a>] -         Rename NonRootStatusReporter to FragmentStatusReporter
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3467'>DRILL-3467</a>] -         Restrict &#39;show databases&#39; based on underlying permissions.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3536'>DRILL-3536</a>] -         Add support for LEAD, LAG, NTILE, FIRST_VALUE and LAST_VALUE window functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3545'>DRILL-3545</a>] -         Need documentation on BINARY_STRING and STRING_BINARY functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3565'>DRILL-3565</a>] -         Add support for Avro UNION type
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3589'>DRILL-3589</a>] -         JDBC driver maven artifact includes a lot of unnecessary dependencies
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3652'>DRILL-3652</a>] -         Need to document order of operations with window functions and flatten
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3720'>DRILL-3720</a>] -         Avro Record Reader should process Avro files by per block basis
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3888'>DRILL-3888</a>] -         Build test jars for all Drill Modules
+</li>
+</ul>
+            
+<h2>        New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2743'>DRILL-2743</a>] -         Parquet file metadata caching
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3180'>DRILL-3180</a>] -         Apache Drill JDBC storage plugin to query rdbms systems such as MySQL and Netezza from Apache Drill
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3470'>DRILL-3470</a>] -         Add support for multiple partition by clauses for window functions in the same query
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3492'>DRILL-3492</a>] -         Add support for encoding of Drill data types into byte ordered format
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3725'>DRILL-3725</a>] -         Add HTTPS support for Drill web interface
+</li>
+</ul>
+                                                        
+<h2>        Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2693'>DRILL-2693</a>] -         doc programmatically submit queries to Drill 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3683'>DRILL-3683</a>] -         [Unit Test] Add expected plan for tests in TestWindowFunctions suite
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3799'>DRILL-3799</a>] -         Create Simple HBase Tutorial
+</li>
+</ul>
+
+## Important Unresolved Issues
+
+* The Drill error message about JSON syntax that appears when Drill cannot find the JDBC driver during configuration of the JDBC storage plugin is misleading. To configure the JDBC plugin, you must put the JDBC driver in the `<drill_installation_directory>/jars/3rdparty` directory. [DRILL-3985](https://issues.apache.org/jira/browse/DRILL-3958)  
+* The MySQL TEXT type is not supported. The popular classicmodels database uses the TEXT type, and therefore cannot be used as is until this issue is resolved. [DRILL-3956](https://issues.apache.org/jira/browse/DRILL-3956)
+
+
+
+
+
+
+


Mime
View raw message