drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject drill-site git commit: 1.2 update
Date Sat, 17 Oct 2015 16:57:10 GMT
Repository: drill-site
Updated Branches:
  refs/heads/asf-site 17f8f098d -> cc29952b3


1.2 update


Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/cc29952b
Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/cc29952b
Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/cc29952b

Branch: refs/heads/asf-site
Commit: cc29952b378e16d745e57788ab45b36f36acdeab
Parents: 17f8f09
Author: Tomer Shiran <tshiran@gmail.com>
Authored: Sat Oct 17 10:00:50 2015 -0700
Committer: Tomer Shiran <tshiran@gmail.com>
Committed: Sat Oct 17 10:00:50 2015 -0700

----------------------------------------------------------------------
 .../index.html                                  |   5 +-
 .../drill-tutorial-at-nosql-now-2015/index.html |   5 +-
 blog/2015/10/16/drill-1.2-released/index.html   | 211 +++++++++++++++++++
 blog/index.html                                 |   5 +
 .../index.html                                  |   2 +-
 docs/useful-research/index.html                 |   2 +-
 download/index.html                             |  12 +-
 feed.xml                                        |  94 ++++++---
 index.html                                      |   2 +-
 9 files changed, 291 insertions(+), 47 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill-site/blob/cc29952b/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html
----------------------------------------------------------------------
diff --git a/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html b/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html
index 548a456..ad88286 100644
--- a/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html
+++ b/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html
@@ -127,8 +127,9 @@
   <div class="addthis_sharing_toolbox"></div>
 
   <article class="post-content">
-    <p><script type="text/javascript" src="//addthisevent.com/libs/1.5.8/ate.min.js"></script>
-<a href="/blog/2014/12/11/apache-drill-qa-panelist-spotlight/" title="Add to Calendar"
class="addthisevent">
+    <script type="text/javascript" src="//addthisevent.com/libs/1.5.8/ate.min.js"></script>
+
+<p><a href="/blog/2014/12/11/apache-drill-qa-panelist-spotlight/" title="Add to
Calendar" class="addthisevent">
     Add to Calendar
     <span class="_start">12-17-2014 11:30:00</span>
     <span class="_end">12-17-2014 12:30:00</span>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/cc29952b/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/index.html b/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/index.html
index 22fb027..09d4215 100644
--- a/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/index.html
+++ b/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/index.html
@@ -127,8 +127,9 @@
   <div class="addthis_sharing_toolbox"></div>
 
   <article class="post-content">
-    <p><script type="text/javascript" src="//addthisevent.com/libs/1.5.8/ate.min.js"></script>
-<a href="/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/" title="Add to Calendar" class="addthisevent">
+    <script type="text/javascript" src="//addthisevent.com/libs/1.5.8/ate.min.js"></script>
+
+<p><a href="/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/" title="Add to Calendar"
class="addthisevent">
     Add to Calendar
     <span class="_start">08-20-2015 13:00:00</span>
     <span class="_end">08-20-2014 16:15:00</span>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/cc29952b/blog/2015/10/16/drill-1.2-released/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/10/16/drill-1.2-released/index.html b/blog/2015/10/16/drill-1.2-released/index.html
new file mode 100644
index 0000000..f6827f7
--- /dev/null
+++ b/blog/2015/10/16/drill-1.2-released/index.html
@@ -0,0 +1,211 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+<meta name=viewport content="width=device-width, initial-scale=1">
+
+
+<title>Drill 1.2 Released - Apache Drill</title>
+
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet"
type="text/css"/>
+<link href='//fonts.googleapis.com/css?family=PT+Sans' rel='stylesheet' type='text/css'/>
+<link href="/css/site.css" rel="stylesheet" type="text/css"/>
+
+<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"/>
+<link rel="icon" href="/favicon.ico" type="image/x-icon"/>
+
+<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" language="javascript"
type="text/javascript"></script>
+<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js"
language="javascript" type="text/javascript"></script>
+<script language="javascript" type="text/javascript" src="/js/modernizr.custom.js"></script>
+<script language="javascript" type="text/javascript" src="/js/script.js"></script>
+<script language="javascript" type="text/javascript" src="/js/drill.js"></script>
+
+</head>
+
+
+<body onResize="resized();">
+  <div class="page-wrap">
+    <div class="bui"></div>
+
+<div id="menu" class="mw">
+<ul>
+  <li class='toc-categories'>
+  <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa fa-bars"></i></a>
+  </li>
+  <li class="logo"><a href="/"></a></li>
+  <li class='expand-menu'>
+  <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span
class='expand-icon'><i class="fa fa-bars"></i></span></a>
+  </li>
+  <li class='clear-float'></li>
+  <li class="documentation-menu">
+    <a href="/docs/">Documentation</a>
+    <ul>
+      
+        <li><a href="/docs/getting-started/">Getting Started</a></li>
+      
+        <li><a href="/docs/architecture/">Architecture</a></li>
+      
+        <li><a href="/docs/tutorials/">Tutorials</a></li>
+      
+        <li><a href="/docs/install-drill/">Install Drill</a></li>
+      
+        <li><a href="/docs/configure-drill/">Configure Drill</a></li>
+      
+        <li><a href="/docs/connect-a-data-source/">Connect a Data Source</a></li>
+      
+        <li><a href="/docs/odbc-jdbc-interfaces/">ODBC/JDBC Interfaces</a></li>
+      
+        <li><a href="/docs/query-data/">Query Data</a></li>
+      
+        <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+      
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
+        <li><a href="/docs/sql-reference/">SQL Reference</a></li>
+      
+        <li><a href="/docs/data-sources-and-file-formats/">Data Sources and File
Formats</a></li>
+      
+        <li><a href="/docs/develop-custom-functions/">Develop Custom Functions</a></li>
+      
+        <li><a href="/docs/troubleshooting/">Troubleshooting</a></li>
+      
+        <li><a href="/docs/developer-information/">Developer Information</a></li>
+      
+        <li><a href="/docs/release-notes/">Release Notes</a></li>
+      
+        <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
+      
+        <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+      
+    </ul>
+  </li>
+  <li class='nav'>
+    <a href="/community-resources/">Community</a>
+    <ul>
+      <li><a href="/team/">Team</a></li>
+      <li><a href="/mailinglists/">Mailing Lists</a></li>
+      <li><a href="/community-resources/">Community Resources</a></li>
+    </ul>
+  </li>
+  <li class='nav'><a href="/faq/">FAQ</a></li>
+  <li class='nav'><a href="/blog/">Blog</a></li>
+  <li id="twitter-menu-item"><a href="https://twitter.com/apachedrill" title="apachedrill
on twitter" target="_blank"><img src="/images/twitter_32_26_white.png" alt="twitter
logo" align="center"></a> </li>
+  <li class='search-bar'>
+    <form id="drill-search-form">
+      <input type="text" placeholder="Search Apache Drill" id="drill-search-term" />
+      <button type="submit">
+        <i class="fa fa-search"></i>
+      </button>
+    </form>
+  </li>
+  <li class="d">
+    <a href="/download/">
+      <i class="fa fa-cloud-download"></i> Download
+    </a>
+  </li>
+</ul>
+</div>
+
+    <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+<div class="post int_text">
+  <header class="post-header">
+    <div class="int_title">
+      <h1 class="post-title">Drill 1.2 Released</h1>
+    </div>
+    <p class="post-meta">
+    
+      
+      
+      <strong>Author:</strong> Jacques Nadeau (PMC Chair and Committer, Apache
Drill)<br />
+    
+<strong>Date:</strong> Oct 16, 2015
+</p>
+  </header>
+  <div class="addthis_sharing_toolbox"></div>
+
+  <article class="post-content">
+    <p>Today I&#39;m happy to announce the availability of the Drill 1.2 release.
This release addresses <a href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12332042&amp;projectId=12313820">217
JIRAs</a> on top of the 1.1 release. Highlights include:</p>
+
+<h2 id="relational-database-support">Relational Database Support</h2>
+
+<p>Drill now includes a JDBC storage plugin for querying relational databases (RDBMSs).
Users can run SQL queries that join data between non-relational datastores (eg, MongoDB, HBase,
HDFS, S3) and relational databases (eg, MySQL, Oracle). For example, a single query can join
log files in HDFS with a users table in MySQL. Drill automatically pushes execution (projections,
filters, partial joins, etc.) down into the RDBMS whenever possible.</p>
+
+<h2 id="new-window-functions">New Window Functions</h2>
+
+<p>The 1.2 release adds additional window functions: <code>NTILE</code>,
<code>FIRST_VALUE</code>, <code>LAST_VALUE</code>, <code>LEAD</code>
and <code>LAG</code>. Drill now supports <a href="/docs/sql-window-functions-introduction/">15
different window functions</a>:</p>
+
+<ul>
+<li>Value Functions: <code>FIRST_VALUE</code>, <code>LAST_VALUE</code>,
<code>LEAD</code>, <code>LAG</code></li>
+<li>Aggregate Functions: <code>AVG</code>, <code>COUNT</code>,
<code>MAX</code>, <code>MIN</code>, <code>SUM</code></li>
+<li>Ranking Functions: <code>CUME_DIST</code>, <code>DENSE_RANK</code>,
<code>NTILE</code>, <code>PERCENT_RANK</code>, <code>RANK</code>,
<code>ROW_NUMBER</code></li>
+</ul>
+
+<p>In addition to supporting new window functions, Drill 1.2 adds support for multiple
window functions in a single query. A query can contain multiple window functions that slice
up the data in different ways by means of different <code>OVER</code> clauses,
but they all act on the same collection of rows.</p>
+
+<h2 id="parquet-metadata-caching">Parquet Metadata Caching</h2>
+
+<p>When running a query against a directory tree with Parquet files, Drill scans the
directory and reads the footers of the files during the planning phase. This allows Drill
to prune partitions and optimize query execution for data locality. However, this process
can be time consuming for directory trees with thousands of files. Drill 1.2 includes <a
href="/docs/optimizing-parquet-reading/">a new feature</a> that caches the metadata
information so that subsequent queries don&#39;t need to scan all the files. The cache
is automatically maintained based on the directory timestamps.</p>
+
+<h2 id="performance-improvements-on-hbase-and-hive-tables">Performance Improvements
on HBase and Hive Tables</h2>
+
+<p>Drill 1.2 introduces a faster read path for HBase and Hive tables. When querying
Hive tables backed by Parquet files, Drill now uses a high-performance Parquet reader rather
than the Hive SerDe.</p>
+
+<h2 id="drop-table-for-files-and-directories"><code>DROP TABLE</code> for
Files and Directories</h2>
+
+<p>Drill 1.2 allows users to drop file- and directory-based tables with a SQL command
(<code>DROP TABLE</code>).</p>
+
+<h2 id="enhanced-mongodb-integration">Enhanced MongoDB Integration</h2>
+
+<p>Drill 1.2 supports extended JSON types, addressing previous issues with queries
on MongoDB collections. </p>
+
+<h2 id="many-more-fixes">Many More Fixes</h2>
+
+<p>Drill 1.2 includes hundreds of <a href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12332042&amp;projectId=12313820">other
fixes and enhancements</a>.</p>
+
+<p>Download the <a href="https://drill.apache.org/download/">Drill 1.2 release</a>
now and let us know your thoughts.</p>
+
+<p>Drill On!
+Jacques Nadeau</p>
+
+  </article>
+ <div id="disqus_thread"></div>
+    <script type="text/javascript">
+        /* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
+        var disqus_shortname = 'drill'; // required: replace example with your forum shortname
+
+        /* * * DON'T EDIT BELOW THIS LINE * * */
+        (function() {
+            var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async
= true;
+            dsq.src = '//' + disqus_shortname + '.disqus.com/embed.js';
+            (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
+        })();
+    </script>
+    <noscript>Please enable JavaScript to view the <a href="http://disqus.com/?ref_noscript">comments
powered by Disqus.</a></noscript>
+    
+</div>
+<script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-548b2caa33765e8d"
async="async"></script>
+
+  </div>
+  <p class="push"></p>
+<div id="footer" class="mw">
+<div class="wrapper">
+Copyright © 2012-2014 The Apache Software Foundation, licensed under the Apache License,
Version 2.0.<br>
+Apache and the Apache feather logo are trademarks of The Apache Software Foundation. Other
names appearing on the site may be trademarks of their respective owners.<br/><br/>
+</div>
+</div>
+
+  <script>
+(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+ga('create', 'UA-53379651-1', 'auto');
+ga('send', 'pageview');
+</script>
+
+</body>
+</html>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/cc29952b/blog/index.html
----------------------------------------------------------------------
diff --git a/blog/index.html b/blog/index.html
index 2ea127b..7f27d37 100644
--- a/blog/index.html
+++ b/blog/index.html
@@ -114,6 +114,11 @@
 </div>
 
 <div class="int_text" align="left"><!-- previously: site.posts -->
+<p><a class="post-link" href="/blog/2015/10/16/drill-1.2-released/">Drill 1.2
Released</a><br/>
+<span class="post-date">Posted on Oct 16, 2015
+by Jacques Nadeau</span>
+<br/>Drill 1.2 has been released. This release includes a new JDBC storage plugin for
querying relational databases, as well as new window functions such as `NTILE`, `FIRST_VALUE`,
`LAST_VALUE`, `LEAD` and `LAG`. This release addresses 210 JIRAs, including performance, stability
and documentation enhancements.</p>
+<!-- previously: site.posts -->
 <p><a class="post-link" href="/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/">Drill
Tutorial at NoSQL Now! 2015</a><br/>
 <span class="post-date">Posted on Jul 23, 2015
 by Tomer Shiran</span>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/cc29952b/docs/tutorial-develop-a-simple-function/index.html
----------------------------------------------------------------------
diff --git a/docs/tutorial-develop-a-simple-function/index.html b/docs/tutorial-develop-a-simple-function/index.html
index 59eec82..efab821 100644
--- a/docs/tutorial-develop-a-simple-function/index.html
+++ b/docs/tutorial-develop-a-simple-function/index.html
@@ -1149,7 +1149,7 @@
 
 <p>Even to a seasoned Java developer, the eval() method might look a bit strange because
Drill generates the final code on the fly to fulfill a query request. This technique leverages
Java’s just-in-time (JIT) compiler for maximum speed.</p>
 
-Basic Coding Rules</h2>
+<h2 id="basic-coding-rules">Basic Coding Rules</h2>
 
 <p>To leverage Java’s just-in-time (JIT) compiler for maximum speed, you need to
adhere to some basic rules.</p>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/cc29952b/docs/useful-research/index.html
----------------------------------------------------------------------
diff --git a/docs/useful-research/index.html b/docs/useful-research/index.html
index d0b2ecb..d1e80c3 100644
--- a/docs/useful-research/index.html
+++ b/docs/useful-research/index.html
@@ -1044,7 +1044,7 @@
 <li><a href="https://github.com/rgrzywinski/field-stripe/">https://github.com/rgrzywinski/field-stripe/</a></li>
 </ul>
 
-Code generation / Physical plan generation</h2>
+<h2 id="code-generation-/-physical-plan-generation">Code generation / Physical plan
generation</h2>
 
 <ul>
 <li><a href="http://www.vldb.org/pvldb/vol4/p539-neumann.pdf">http://www.vldb.org/pvldb/vol4/p539-neumann.pdf</a>
(SLIDES: <a href="http://www.vldb.org/2011/files/slides/research9/rSession9-3.pdf">http://www.vldb.org/2011/files/slides/research9/rSession9-3.pdf</a>)</li>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/cc29952b/download/index.html
----------------------------------------------------------------------
diff --git a/download/index.html b/download/index.html
index 4ee39c5..3b1763c 100644
--- a/download/index.html
+++ b/download/index.html
@@ -114,23 +114,23 @@
 </div>
 
 <div class="int_text" align="left"><link href="/css/download.css" rel="stylesheet"
type="text/css">
-<p>Drill 1.1 was released on July 5, 2015.</p>
+<p>Drill 1.2 was released on October 16, 2015.</p>
 
 <div id="download_bar">
 <div class="table">
 <ul id="download_buttons">
-<li><a href="http://www.apache.org/dyn/closer.cgi/drill/drill-1.1.0/apache-drill-1.1.0.tar.gz"
class="find" id="apachemirror">Find an Apache Mirror</a></li>
-<li><a href="http://getdrill.org/drill/download/apache-drill-1.1.0.tar.gz" rel="nofollow"
class="dl" id="directdownload">Direct File Download</a></li>
+<li><a href="http://www.apache.org/dyn/closer.cgi/drill/drill-1.2.0/apache-drill-1.2.0.tar.gz"
class="find" id="apachemirror">Find an Apache Mirror</a></li>
+<li><a href="http://getdrill.org/drill/download/apache-drill-1.2.0.tar.gz" rel="nofollow"
class="dl" id="directdownload">Direct File Download</a></li>
 <li><a href="/docs/interfaces-introduction/" class="dl">Client Drivers (ODBC/JDBC)</a></li>
 </ul>
 </div>
 </div>
 
-<p>Additional resources for Drill 1.1:</p>
+<p>Additional resources for Drill 1.2:</p>
 <ul>
-<li><a href="/blog/2015/07/05/drill-1.1-released/">Blog post</a></li>
+<li><a href="/blog/2015/10/16/drill-1.2-released/">Blog post</a></li>
 <li><a href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12329689">Release
notes (JIRA)</a></li>
-<li><a href="https://github.com/apache/drill/tree/1.1.0">Source code</a></li>
+<li><a href="https://github.com/apache/drill/tree/1.2.0">Source code</a></li>
 </ul>
 
 <p>If you're looking for an older release, see the <a href="/docs/release-notes/">release
notes</a>.

http://git-wip-us.apache.org/repos/asf/drill-site/blob/cc29952b/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index fcbf5e0..2daca2f 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,14 +6,69 @@
 </description>
     <link>/</link>
     <atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
-    <pubDate>Thu, 15 Oct 2015 15:34:22 -0700</pubDate>
-    <lastBuildDate>Thu, 15 Oct 2015 15:34:22 -0700</lastBuildDate>
-    <generator>Jekyll v2.5.2</generator>
+    <pubDate>Sat, 17 Oct 2015 09:56:45 -0700</pubDate>
+    <lastBuildDate>Sat, 17 Oct 2015 09:56:45 -0700</lastBuildDate>
+    <generator>Jekyll v2.5.3</generator>
+    
+      <item>
+        <title>Drill 1.2 Released</title>
+        <description>&lt;p&gt;Today I&amp;#39;m happy to announce the availability
of the Drill 1.2 release. This release addresses &lt;a href=&quot;https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12332042&amp;amp;projectId=12313820&quot;&gt;217
JIRAs&lt;/a&gt; on top of the 1.1 release. Highlights include:&lt;/p&gt;
+
+&lt;h2 id=&quot;relational-database-support&quot;&gt;Relational Database
Support&lt;/h2&gt;
+
+&lt;p&gt;Drill now includes a JDBC storage plugin for querying relational databases
(RDBMSs). Users can run SQL queries that join data between non-relational datastores (eg,
MongoDB, HBase, HDFS, S3) and relational databases (eg, MySQL, Oracle). For example, a single
query can join log files in HDFS with a users table in MySQL. Drill automatically pushes execution
(projections, filters, partial joins, etc.) down into the RDBMS whenever possible.&lt;/p&gt;
+
+&lt;h2 id=&quot;new-window-functions&quot;&gt;New Window Functions&lt;/h2&gt;
+
+&lt;p&gt;The 1.2 release adds additional window functions: &lt;code&gt;NTILE&lt;/code&gt;,
&lt;code&gt;FIRST_VALUE&lt;/code&gt;, &lt;code&gt;LAST_VALUE&lt;/code&gt;,
&lt;code&gt;LEAD&lt;/code&gt; and &lt;code&gt;LAG&lt;/code&gt;.
Drill now supports &lt;a href=&quot;/docs/sql-window-functions-introduction/&quot;&gt;15
different window functions&lt;/a&gt;:&lt;/p&gt;
+
+&lt;ul&gt;
+&lt;li&gt;Value Functions: &lt;code&gt;FIRST_VALUE&lt;/code&gt;,
&lt;code&gt;LAST_VALUE&lt;/code&gt;, &lt;code&gt;LEAD&lt;/code&gt;,
&lt;code&gt;LAG&lt;/code&gt;&lt;/li&gt;
+&lt;li&gt;Aggregate Functions: &lt;code&gt;AVG&lt;/code&gt;, &lt;code&gt;COUNT&lt;/code&gt;,
&lt;code&gt;MAX&lt;/code&gt;, &lt;code&gt;MIN&lt;/code&gt;,
&lt;code&gt;SUM&lt;/code&gt;&lt;/li&gt;
+&lt;li&gt;Ranking Functions: &lt;code&gt;CUME_DIST&lt;/code&gt;,
&lt;code&gt;DENSE_RANK&lt;/code&gt;, &lt;code&gt;NTILE&lt;/code&gt;,
&lt;code&gt;PERCENT_RANK&lt;/code&gt;, &lt;code&gt;RANK&lt;/code&gt;,
&lt;code&gt;ROW_NUMBER&lt;/code&gt;&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;p&gt;In addition to supporting new window functions, Drill 1.2 adds support for
multiple window functions in a single query. A query can contain multiple window functions
that slice up the data in different ways by means of different &lt;code&gt;OVER&lt;/code&gt;
clauses, but they all act on the same collection of rows.&lt;/p&gt;
+
+&lt;h2 id=&quot;parquet-metadata-caching&quot;&gt;Parquet Metadata Caching&lt;/h2&gt;
+
+&lt;p&gt;When running a query against a directory tree with Parquet files, Drill
scans the directory and reads the footers of the files during the planning phase. This allows
Drill to prune partitions and optimize query execution for data locality. However, this process
can be time consuming for directory trees with thousands of files. Drill 1.2 includes &lt;a
href=&quot;/docs/optimizing-parquet-reading/&quot;&gt;a new feature&lt;/a&gt;
that caches the metadata information so that subsequent queries don&amp;#39;t need to
scan all the files. The cache is automatically maintained based on the directory timestamps.&lt;/p&gt;
+
+&lt;h2 id=&quot;performance-improvements-on-hbase-and-hive-tables&quot;&gt;Performance
Improvements on HBase and Hive Tables&lt;/h2&gt;
+
+&lt;p&gt;Drill 1.2 introduces a faster read path for HBase and Hive tables. When
querying Hive tables backed by Parquet files, Drill now uses a high-performance Parquet reader
rather than the Hive SerDe.&lt;/p&gt;
+
+&lt;h2 id=&quot;drop-table-for-files-and-directories&quot;&gt;&lt;code&gt;DROP
TABLE&lt;/code&gt; for Files and Directories&lt;/h2&gt;
+
+&lt;p&gt;Drill 1.2 allows users to drop file- and directory-based tables with a SQL
command (&lt;code&gt;DROP TABLE&lt;/code&gt;).&lt;/p&gt;
+
+&lt;h2 id=&quot;enhanced-mongodb-integration&quot;&gt;Enhanced MongoDB Integration&lt;/h2&gt;
+
+&lt;p&gt;Drill 1.2 supports extended JSON types, addressing previous issues with
queries on MongoDB collections. &lt;/p&gt;
+
+&lt;h2 id=&quot;many-more-fixes&quot;&gt;Many More Fixes&lt;/h2&gt;
+
+&lt;p&gt;Drill 1.2 includes hundreds of &lt;a href=&quot;https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12332042&amp;amp;projectId=12313820&quot;&gt;other
fixes and enhancements&lt;/a&gt;.&lt;/p&gt;
+
+&lt;p&gt;Download the &lt;a href=&quot;https://drill.apache.org/download/&quot;&gt;Drill
1.2 release&lt;/a&gt; now and let us know your thoughts.&lt;/p&gt;
+
+&lt;p&gt;Drill On!
+Jacques Nadeau&lt;/p&gt;
+</description>
+        <pubDate>Fri, 16 Oct 2015 00:00:00 -0700</pubDate>
+        <link>/blog/2015/10/16/drill-1.2-released/</link>
+        <guid isPermaLink="true">/blog/2015/10/16/drill-1.2-released/</guid>
+        
+        
+        <category>blog</category>
+        
+      </item>
     
       <item>
         <title>Drill Tutorial at NoSQL Now! 2015</title>
-        <description>&lt;p&gt;&lt;script type=&quot;text/javascript&quot;
src=&quot;//addthisevent.com/libs/1.5.8/ate.min.js&quot;&gt;&lt;/script&gt;
-&lt;a href=&quot;/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/&quot; title=&quot;Add
to Calendar&quot; class=&quot;addthisevent&quot;&gt;
+        <description>&lt;script type=&quot;text/javascript&quot; src=&quot;//addthisevent.com/libs/1.5.8/ate.min.js&quot;&gt;&lt;/script&gt;
+
+&lt;p&gt;&lt;a href=&quot;/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/&quot;
title=&quot;Add to Calendar&quot; class=&quot;addthisevent&quot;&gt;
     Add to Calendar
     &lt;span class=&quot;_start&quot;&gt;08-20-2015 13:00:00&lt;/span&gt;
     &lt;span class=&quot;_end&quot;&gt;08-20-2014 16:15:00&lt;/span&gt;
@@ -383,34 +438,5 @@ Tomer Shiran&lt;/p&gt;
         
       </item>
     
-      <item>
-        <title>Drill 0.7 Released</title>
-        <description>&lt;p&gt;I&amp;#39;m excited to announce that the
community has just released Drill 0.7, which includes &lt;a href=&quot;https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&amp;amp;version=12327473&quot;&gt;228
resolved JIRAs&lt;/a&gt; and numerous enhancements such as: &lt;/p&gt;
-
-&lt;ul&gt;
-&lt;li&gt;No dependency on UDP multicast. Drill can now work on EC2, as well as clusters
with multiple subnets or multihomed configurations&lt;/li&gt;
-&lt;li&gt;&lt;a href=&quot;https://cwiki.apache.org/confluence/display/DRILL/Partition+Pruning&quot;&gt;Automatic
partition pruning&lt;/a&gt; based on directory structures&lt;/li&gt;
-&lt;li&gt;New nested data functions: &lt;a href=&quot;https://cwiki.apache.org/confluence/display/DRILL/KVGEN+Function&quot;&gt;KVGEN&lt;/a&gt;
and &lt;a href=&quot;https://cwiki.apache.org/confluence/display/DRILL/FLATTEN+Function&quot;&gt;FLATTEN&lt;/a&gt;&lt;/li&gt;
-&lt;li&gt;Fast &amp;quot;schema&amp;quot; return. This provides a better
experience when using BI tools&lt;/li&gt;
-&lt;li&gt;Hive 0.13 Metastore support&lt;/li&gt;
-&lt;li&gt;Improved performance for queries on JSON data&lt;/li&gt;
-&lt;/ul&gt;
-
-&lt;p&gt;You can now &lt;a href=&quot;/download/&quot;&gt;download
Drill 0.7&lt;/a&gt;. As always, you may check out the official &lt;a href=&quot;https://cwiki.apache.org/confluence/display/DRILL/Release+Notes&quot;&gt;release
notes&lt;/a&gt; for more details.&lt;/p&gt;
-
-&lt;p&gt;In case you&amp;#39;re interested in understanding more about where
we&amp;#39;re heading, check out Tomer&amp;#39;s recent blog post outlining some of
the &lt;a href=&quot;/blog/2014/12/16/whats-coming-in-2015/&quot;&gt;planned
initiatives for 2015&lt;/a&gt;.&lt;/p&gt;
-
-&lt;p&gt;Happy Drilling!&lt;br&gt;
-Jacques Nadeau&lt;/p&gt;
-</description>
-        <pubDate>Tue, 23 Dec 2014 00:00:00 -0800</pubDate>
-        <link>/blog/2014/12/23/drill-0.7-released/</link>
-        <guid isPermaLink="true">/blog/2014/12/23/drill-0.7-released/</guid>
-        
-        
-        <category>blog</category>
-        
-      </item>
-    
   </channel>
 </rss>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/cc29952b/index.html
----------------------------------------------------------------------
diff --git a/index.html b/index.html
index 48c0974..f1a6ae8 100644
--- a/index.html
+++ b/index.html
@@ -166,7 +166,7 @@ $(document).ready(function() {
 
 </div><!-- header -->
 <div class="alertbar">
-  <div class="news">News:</div><div><a href="/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/">Drill
Tutorial at NoSQL Now! 2015</a><br/><span>(Tomer Shiran)</span></div><div><a
href="/blog/2015/07/05/drill-1.1-released/">Drill 1.1 Released</a><br/><span>(Jacques
Nadeau)</span></div>
+  <div class="news">News:</div><div><a href="/blog/2015/10/16/drill-1.2-released/">Drill
1.2 Released</a><br/><span>(Jacques Nadeau)</span></div><div><a
href="/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/">Drill Tutorial at NoSQL Now!
2015</a><br/><span>(Tomer Shiran)</span></div>
 </div>
 
 <div class="mw introWrapper">


Mime
View raw message