drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [3/7] drill git commit: Doc updates for Drill 1.10
Date Wed, 15 Mar 2017 02:43:30 GMT
http://git-wip-us.apache.org/repos/asf/drill/blob/b7b848e6/_docs/rn/001-1.10.0-rn.md
----------------------------------------------------------------------
diff --git a/_docs/rn/001-1.10.0-rn.md b/_docs/rn/001-1.10.0-rn.md
new file mode 100644
index 0000000..be2cc1b
--- /dev/null
+++ b/_docs/rn/001-1.10.0-rn.md
@@ -0,0 +1,307 @@
+---
+title: "Apache Drill 1.10.0 Release Notes"
+parent: "Release Notes"
+---
+
+**Release date:**  March 15, 2017
+
+Today, we're happy to announce the availability of Drill 1.10.0. You can download it [here](https://drill.apache.org/download/).
+
+## New Features
+This release of Drill provides the following new features: 
+
+- Support for the Create Temporary Table As (CTTAS) command.
+- JDBC connection option that improves fault tolerance  when connecting directly to a Drill
node from a client.  
+- Drill writes standard Parquet date values and automatically detects and corrects any corrupted
date values. 
+- The Drill Web Console displays the Drill version running on each Drill node in the cluster.
+- Drill can implicitly interpret the INT96 timestamp data type in Parquet files.
+- Support for Kerberos authentication.  
+
+The following sections list additional bug fixes and improvements:  
+    
+<h2>        Sub-task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4272'>DRILL-4272</a>]
-         When sort runs out of memory and query fails, resources are seemingly not freed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4301'>DRILL-4301</a>]
-         OOM : Unable to allocate sv2 for 1000 records, and not enough batchGroups to spill.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4730'>DRILL-4730</a>]
-         Update JDBC DatabaseMetaData implementation to use new Metadata APIs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5008'>DRILL-5008</a>]
-         Refactor, document and simplify ExternalSortBatch
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5011'>DRILL-5011</a>]
-         External Sort Batch memory use depends on record width
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5014'>DRILL-5014</a>]
-         ExternalSortBatch cache size, spill count differs from config setting
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5017'>DRILL-5017</a>]
-         Config param drill.exec.sort.external.batch.size is not used
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5019'>DRILL-5019</a>]
-         ExternalSortBatch spills all batches to disk even if even one spills
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5020'>DRILL-5020</a>]
-         ExternalSortBatch has inconsistent notions of the memory limit
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5022'>DRILL-5022</a>]
-         ExternalSortBatch sets two different limits for &quot;copier&quot; memory
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5023'>DRILL-5023</a>]
-         ExternalSortBatch does not spill fully, throws off spill calculations
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5025'>DRILL-5025</a>]
-         ExternalSortBatch provides weak control over spill file size
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5026'>DRILL-5026</a>]
-         ExternalSortBatch uses two memory allocators; one will do
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5027'>DRILL-5027</a>]
-         ExternalSortBatch is inefficient: rewrites data unnecessarily
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5055'>DRILL-5055</a>]
-         External Sort does not delete spill file if error occurs during close
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5062'>DRILL-5062</a>]
-         External sort refers to the deprecated HDFS fs.default.name param
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5066'>DRILL-5066</a>]
-         External sort attempts to retry sv2 memory alloc, even if can never succeed
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5210'>DRILL-5210</a>]
-         External Sort BatchGroup leaks memory if an OOM occurs during read
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5262'>DRILL-5262</a>]
-         NPE in managed external sort while spilling to disk
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5264'>DRILL-5264</a>]
-         Managed External Sort fails with OOM
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5267'>DRILL-5267</a>]
-         Managed external sort spills too often with Parquet data
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5285'>DRILL-5285</a>]
-         Provide detailed, accurate estimate of size consumed by a record batch
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5294'>DRILL-5294</a>]
-         Managed External Sort throws an OOM during the merge and spill phase
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5310'>DRILL-5310</a>]
-         Memory leak in managed sort if OOM during sv2 allocation
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5312'>DRILL-5312</a>]
-         &quot;Record batch sizer&quot; does not include overhead for variable-sized
vectors
+</li>
+</ul>
+                            
+<h2>        Bug
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1808'>DRILL-1808</a>]
-         Large compilation unit tests fails due to high memory allocation
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2293'>DRILL-2293</a>]
-         CTAS does not clean up when it fails
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3562'>DRILL-3562</a>]
-         Query fails when using flatten on JSON data where some documents have an empty array
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4578'>DRILL-4578</a>]
-         &quot;children&quot; missing from results of full scan over JSON data
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4764'>DRILL-4764</a>]
-         Parquet file with INT_16, etc. logical types not supported by simple SELECT
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4812'>DRILL-4812</a>]
-         Wildcard queries fail on Windows
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4850'>DRILL-4850</a>]
-         TPCDS Query 33 failed in the second and 3rd runs, but succeeded in the 1st run
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4872'>DRILL-4872</a>]
-         NPE from CTAS partitioned by a projected casted null
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4919'>DRILL-4919</a>]
-         Fix select count(1) / count(*) on csv with header
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4938'>DRILL-4938</a>]
-         Report UserException when constant expression reduction fails
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4963'>DRILL-4963</a>]
-         Issues when overloading Drill native functions with dynamic UDFs
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4982'>DRILL-4982</a>]
-         Hive Queries degrade when queries switch between different formats
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4994'>DRILL-4994</a>]
-         Prepared statement stopped working between 1.8.0 client and &lt; 1.8.0 server
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4995'>DRILL-4995</a>]
-         Allow lazy init when dynamic UDF support is disabled
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4996'>DRILL-4996</a>]
-         Parquet Date auto-correction is not working in auto-partitioned parquet files generated
by drill-1.6
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5005'>DRILL-5005</a>]
-         Potential issues with external sort info in query profile
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5015'>DRILL-5015</a>]
-         As per documentation, when issuing a list of drillbits in the connection string,
we always attempt to connect only to the first one
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5032'>DRILL-5032</a>]
-         Drill query on hive parquet table failed with OutOfMemoryError: Java heap space
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5034'>DRILL-5034</a>]
-         Select timestamp from hive generated parquet always return in UTC
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5039'>DRILL-5039</a>]
-         NPE - CTAS PARTITION BY (&lt;char-type-column&gt;)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5040'>DRILL-5040</a>]
-         Interrupted CTAS should not succeed &amp; should not create physical file on
disk
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5044'>DRILL-5044</a>]
-         Fix retry logic to handle VersionMismatchException by not deleting jars in remote
UDFs area
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5048'>DRILL-5048</a>]
-         Fix type mismatch error in case statement with null timestamp
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5050'>DRILL-5050</a>]
-         C++ client library has symbol resolution issues when loaded by a process that already
uses boost::asio
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5051'>DRILL-5051</a>]
-         DRILL-5051: Fix incorrect result returned in nest query with offset specified
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5070'>DRILL-5070</a>]
-         Code gen: create methods in fixed order to allow test verification
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5081'>DRILL-5081</a>]
-         Excessive info level logging introduced in DRILL-4203
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5086'>DRILL-5086</a>]
-         ClassCastException when filter pushdown is used with a bigint or float column and
metadata caching.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5088'>DRILL-5088</a>]
-         Error when reading DBRef column
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5091'>DRILL-5091</a>]
-         JDBC unit test fail on Java 8
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5094'>DRILL-5094</a>]
-         Assure Comparator to be transitive
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5097'>DRILL-5097</a>]
-         Using store.parquet.reader.int96_as_timestamp gives IOOB whereas convert_from works
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5104'>DRILL-5104</a>]
-         Foreman sets external sort memory allocation even for a physical plan
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5112'>DRILL-5112</a>]
-         Unit tests derived from PopUnitTestBase fail in IDE due to config errors
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5113'>DRILL-5113</a>]
-         Upgrade Maven RAT plugin to avoid annoying XML errors
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5117'>DRILL-5117</a>]
-         Compile error when query a json file with 1000+columns
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5119'>DRILL-5119</a>]
-         Update MapR version to 5.2.0.40963-mapr
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5121'>DRILL-5121</a>]
-         A memory leak is observed when exact case is not specified for a column in a filter
condition
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5127'>DRILL-5127</a>]
-         Revert the fix for DRILL-4831
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5157'>DRILL-5157</a>]
-         Multiple Snappy versions on class path; causes unit test failures
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5159'>DRILL-5159</a>]
-         ProjectMergeRule in Drill should operate on RelNodes with same convention trait.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5164'>DRILL-5164</a>]
-         Equi-join query results in CompileException when inputs have large number of columns
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5167'>DRILL-5167</a>]
-         C++ connector does not set escape string for metadata search pattern
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5190'>DRILL-5190</a>]
-         Display planning and queued time for a query in its profile page
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5196'>DRILL-5196</a>]
-         Could not run a single MongoDB unit test case through command line or IDE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5207'>DRILL-5207</a>]
-         Improve Parquet scan pipelining
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5208'>DRILL-5208</a>]
-         Finding path to java executable should be deterministic
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5218'>DRILL-5218</a>]
-         Support Disabling Heartbeats in C++ Client
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5224'>DRILL-5224</a>]
-         CTTAS: fix errors connected with system path delimiters (Windows)
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5230'>DRILL-5230</a>]
-         Translation of millisecond duration into hours is incorrect
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5238'>DRILL-5238</a>]
-         CTTAS: unable to resolve temporary table if workspace is indicated without schema
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5242'>DRILL-5242</a>]
-         The UI breaks when trying to render profiles having unknown metrics
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5243'>DRILL-5243</a>]
-         Fix TestContextFunctions.sessionIdUDFWithinSameSession unit test
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5252'>DRILL-5252</a>]
-         A condition returns always true
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5263'>DRILL-5263</a>]
-         Prevent left NLJoin with non scalar subqueries
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5266'>DRILL-5266</a>]
-         Parquet Reader produces &quot;low density&quot; record batches - bits vs.
bytes
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5273'>DRILL-5273</a>]
-         CompliantTextReader exhausts 4 GB memory when reading 5000 small files
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5274'>DRILL-5274</a>]
-         Exception thrown in Drillbit shutdown in UDF cleanup code
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5275'>DRILL-5275</a>]
-         Sort spill serialization is slow due to repeated buffer allocations
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5284'>DRILL-5284</a>]
-         Roll-up of final fixes for managed sort
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5287'>DRILL-5287</a>]
-         Provide option to skip updates of ephemeral state changes in Zookeeper
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5293'>DRILL-5293</a>]
-         Poor performance of Hash Table due to same hash value as distribution below
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5304'>DRILL-5304</a>]
-         Queries fail intermittently when there is skew in data distribution
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5313'>DRILL-5313</a>]
-         C++ client build failure on linux
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5326'>DRILL-5326</a>]
-         Unit tests failures related to the SERVER_METADTA
+</li>
+</ul>
+                    
+<h2>        Improvement
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3510'>DRILL-3510</a>]
-         Add ANSI_QUOTES option so that Drill&#39;s SQL Parser will recognize ANSI_SQL
identifiers 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4217'>DRILL-4217</a>]
-         Query parquet file treat INT_16 &amp; INT_8 as INT32
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4280'>DRILL-4280</a>]
-         Kerberos Authentication
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4373'>DRILL-4373</a>]
-         Drill and Hive have incompatible timestamp representations in parquet
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4604'>DRILL-4604</a>]
-         Generate warning on Web UI if drillbits version mismatch is detected
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4864'>DRILL-4864</a>]
-         Add ANSI format for date/time functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4956'>DRILL-4956</a>]
-         Temporary tables support
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4980'>DRILL-4980</a>]
-         Upgrading of the approach of parquet date correctness status detection
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4987'>DRILL-4987</a>]
-         Use ImpersonationUtil in RemoteFunctionRegistry
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5043'>DRILL-5043</a>]
-         Function that returns a unique id per session/connection similar to MySQL&#39;s
CONNECTION_ID()
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5052'>DRILL-5052</a>]
-         Option to debug generated Java code using an IDE
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5056'>DRILL-5056</a>]
-         UserException does not write full message to log
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5065'>DRILL-5065</a>]
-         Optimize count(*) queries on MapR-DB JSON Tables
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5080'>DRILL-5080</a>]
-         Create a memory-managed version of the External Sort operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5085'>DRILL-5085</a>]
-         Add / update description for dynamic UDFs directories in drill-env.sh and drill-module.conf
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5098'>DRILL-5098</a>]
-         Improving fault tolerance for connection between client and foreman node.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5108'>DRILL-5108</a>]
-         Reduce output from Maven git-commit-id-plugin
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5116'>DRILL-5116</a>]
-         Enable generated code debugging in each Drill operator
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5123'>DRILL-5123</a>]
-         Write query profile after sending final response to client to improve latency
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5126'>DRILL-5126</a>]
-         Provide simplified, unified &quot;cluster fixture&quot; for tests
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5172'>DRILL-5172</a>]
-         Display elapsed time for queries in the UI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5195'>DRILL-5195</a>]
-         Publish Operator and MajorFragment Stats in Profile page
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5215'>DRILL-5215</a>]
-         CTTAS: disallow temp tables in view expansion logic
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5221'>DRILL-5221</a>]
-         cancel message is delayed until queryid or data is received
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5254'>DRILL-5254</a>]
-         Enhance default reduction factors in optimizer
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5255'>DRILL-5255</a>]
-         Unit tests fail due to CTTAS temporary name space checks
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5257'>DRILL-5257</a>]
-         Provide option to save query profiles sync, async or not at all
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5258'>DRILL-5258</a>]
-         Allow &quot;extended&quot; mock tables access from SQL queries
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5259'>DRILL-5259</a>]
-         Allow listing a user-defined number of profiles 
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5260'>DRILL-5260</a>]
-         Refinements to new &quot;Cluster Fixture&quot; test framework
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5270'>DRILL-5270</a>]
-         Improve loading of profiles listing in the WebUI
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5290'>DRILL-5290</a>]
-         Provide an option to build operator table once for built-in static functions and
reuse it across queries.
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5301'>DRILL-5301</a>]
-         Add server metadata API
+</li>
+</ul>
+                
+<h2>        New Feature
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4935'>DRILL-4935</a>]
-         Allow drillbits to advertise a configurable host address to Zookeeper
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4979'>DRILL-4979</a>]
-         Make dataport configurable
+</li>
+</ul>
+                                                    
+<h2>        Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-5354'>DRILL-5354</a>]
-         Create CTTAS Documentaion
+</li>
+</ul>
+            
+<h2>        Test
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/DRILL-4253'>DRILL-4253</a>]
-         Some functional tests are failing because sort limit is too low
+</li>
+</ul>
+         
+
+                
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/b7b848e6/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/005-supported-sql-commands.md b/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
index 5a87073..6605469 100644
--- a/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
+++ b/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
@@ -1,6 +1,6 @@
 ---
 title: Supported SQL Commands
-date: 2016-07-22 00:26:58 UTC
+date: 2017-03-14 22:11:02 UTC
 parent: "SQL Commands"
 ---
 The following table provides a list of the SQL commands that Drill supports,
@@ -13,6 +13,7 @@ with their descriptions and example syntax:
 | [ALTER SYSTEM RESET]({{site.baseurl}}/docs/alter-system)                 | Changes a system
setting back to its default system setting. For a list of Drill options and their descriptions,
see [Planning and Execution Options]{{site.baseurl/docs/planning-and-execution-options/}}.
                                         | ALTER SYSTEM RESET \`option_name`;            
                                                                    |
 | [ALTER SYSTEM RESET ALL]({{site.baseurl}}/docs/alter-system)             | Changes all
system settings back to their default system values. For a list of Drill options and their
descriptions, see [Planning and Execution Options]{{site.baseurl/docs/planning-and-execution-options/}}.
                                     | ALTER SYSTEM RESET ALL;                           
                                                                |
 | [CREATE TABLE AS(CTAS)]({{site.baseurl}}/docs/create-table-as-ctas/)     | Creates a new
table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE
AS (CTAS) statement in place of INSERT INTO.                                             
                                              | CREATE TABLE name AS query;              
                                                                         |
+| [CREATE TEMPORARY TABLE AS(CTTAS)]({{site.baseurl}}/docs/create-temp-table-as-cttas/) 
   | Stores the results of a query in a temporary table.                                 
                                                          | CREATE TEMPORARY TABLE name AS
query;                                                                                   
    |
 | [CREATE VIEW]({{site.baseurl}}/docs/create-view)                         | Creates a virtual
structure for the result set of a stored query.-                                         
                                                                                         
                                               | CREATE [OR REPLACE] VIEW [workspace.]view_name
[ (column_name [, ...]) ] AS query;                                 |
 | [DESCRIBE ]({{site.baseurl}}/docs/describe)                              | Returns information
about columns in a table or view.                                                        
                                                                                         
                                             | DESCRIBE [workspace.]table_name           
                                                                        |
 | [DROP VIEW]({{site.baseurl}}/docs/drop-view)                             | Removes a view.
                                                                                         
                                                                                         
                                                 | DROP VIEW [workspace.]view_name ;     
                                                                            |

http://git-wip-us.apache.org/repos/asf/drill/blob/b7b848e6/_docs/sql-reference/sql-commands/079-select.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/079-select.md b/_docs/sql-reference/sql-commands/079-select.md
index 9d7d781..96a0087 100644
--- a/_docs/sql-reference/sql-commands/079-select.md
+++ b/_docs/sql-reference/sql-commands/079-select.md
@@ -1,6 +1,6 @@
 ---
 title: "SELECT"
-date:  
+date: 2017-03-14 22:11:02 UTC
 parent: "SQL Commands"
 ---
 Drill supports the following ANSI standard clauses in the SELECT statement:
@@ -19,6 +19,7 @@ Drill supports the following ANSI standard clauses in the SELECT statement:
 You can use the same SELECT syntax in the following commands:
 
   * CREATE TABLE AS (CTAS)
+  * CREATE TEMPORARY TABLES AS (CTTAS)
   * CREATE VIEW
 
 INSERT INTO SELECT is not yet supported.

http://git-wip-us.apache.org/repos/asf/drill/blob/b7b848e6/_docs/sql-reference/sql-commands/120-use.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/120-use.md b/_docs/sql-reference/sql-commands/120-use.md
index f9f5899..395f716 100644
--- a/_docs/sql-reference/sql-commands/120-use.md
+++ b/_docs/sql-reference/sql-commands/120-use.md
@@ -1,11 +1,12 @@
 ---
 title: "USE"
-date:  
+date: 2017-03-14 22:11:03 UTC
 parent: "SQL Commands"
 ---
 The USE command changes the schema context to the specified schema. When you
 issue the USE command to switch to a particular schema, Drill queries that
 schema only.
+**Note:** You must include the full path to a file or table whenever there is a temporary
table in the session with the same name. See [CTTAS]({{site.baseurl}}/docs/create-temp-table-as).

 
 ## Syntax
 
@@ -26,7 +27,7 @@ workspaces in Drill. See [Storage Plugin Registration]({{ site.baseurl }}/docs/s
 ## Usage Notes
 
 Issue the USE command to change to a particular schema. When you use a schema,
-you do not have to include the full path to a file or table in your query.  
+you do not have to include the full path to a file or table in your query.
   
 For example, to query a file named `donuts.json` in the
 `/users/max/drill/json/` directory, you must include the full file path in


Mime
View raw message