You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by mm...@apache.org on 2017/10/02 17:08:05 UTC

svn commit: r1810559 [1/3] - in /calcite/site: docs/ downloads/ news/ news/2014/06/27/release-0.8.0-incubating/ news/2014/08/19/release-0.9.0-incubating/ news/2014/10/02/release-0.9.1-incubating/ news/2014/11/05/release-0.9.2-incubating/ news/2015/01/3...

Author: mmior
Date: Mon Oct  2 17:08:04 2017
New Revision: 1810559

URL: http://svn.apache.org/viewvc?rev=1810559&view=rev
Log:
Add release notes and update documentation for 1.14.0

Added:
    calcite/site/docs/spatial.html
    calcite/site/news/2017/10/
    calcite/site/news/2017/10/02/
    calcite/site/news/2017/10/02/release-1.14.0/
    calcite/site/news/2017/10/02/release-1.14.0/index.html
Modified:
    calcite/site/docs/adapter.html
    calcite/site/docs/algebra.html
    calcite/site/docs/avatica_json_reference.html
    calcite/site/docs/avatica_overview.html
    calcite/site/docs/avatica_protobuf_reference.html
    calcite/site/docs/avatica_roadmap.html
    calcite/site/docs/cassandra_adapter.html
    calcite/site/docs/druid_adapter.html
    calcite/site/docs/elasticsearch_adapter.html
    calcite/site/docs/file_adapter.html
    calcite/site/docs/history.html
    calcite/site/docs/howto.html
    calcite/site/docs/index.html
    calcite/site/docs/lattice.html
    calcite/site/docs/materialized_views.html
    calcite/site/docs/model.html
    calcite/site/docs/os_adapter.html
    calcite/site/docs/pig_adapter.html
    calcite/site/docs/powered_by.html
    calcite/site/docs/reference.html
    calcite/site/docs/stream.html
    calcite/site/docs/tutorial.html
    calcite/site/downloads/index.html
    calcite/site/news/2014/06/27/release-0.8.0-incubating/index.html
    calcite/site/news/2014/08/19/release-0.9.0-incubating/index.html
    calcite/site/news/2014/10/02/release-0.9.1-incubating/index.html
    calcite/site/news/2014/11/05/release-0.9.2-incubating/index.html
    calcite/site/news/2015/01/31/release-1.0.0-incubating/index.html
    calcite/site/news/2015/03/13/release-1.1.0-incubating/index.html
    calcite/site/news/2015/04/07/release-1.2.0-incubating/index.html
    calcite/site/news/2015/04/24/new-committers/index.html
    calcite/site/news/2015/05/30/release-1.3.0-incubating/index.html
    calcite/site/news/2015/06/05/algebra-builder/index.html
    calcite/site/news/2015/07/31/xldb-best-lightning-talk/index.html
    calcite/site/news/2015/09/02/release-1.4.0-incubating/index.html
    calcite/site/news/2015/10/22/calcite-graduates/index.html
    calcite/site/news/2015/11/08/new-committers/index.html
    calcite/site/news/2015/11/10/release-1.5.0/index.html
    calcite/site/news/2016/01/22/release-1.6.0/index.html
    calcite/site/news/2016/02/17/elser-pmc/index.html
    calcite/site/news/2016/02/17/streaming-sql-talk/index.html
    calcite/site/news/2016/03/22/cassandra-adapter/index.html
    calcite/site/news/2016/03/22/release-1.7.0/index.html
    calcite/site/news/2016/06/13/release-1.8.0/index.html
    calcite/site/news/2016/09/22/release-1.9.0/index.html
    calcite/site/news/2016/10/12/release-1.10.0/index.html
    calcite/site/news/2017/01/09/release-1.11.0/index.html
    calcite/site/news/2017/03/24/release-1.12.0/index.html
    calcite/site/news/2017/03/31/new-avatica-repository/index.html
    calcite/site/news/2017/06/26/release-1.13.0/index.html
    calcite/site/news/index.html
    calcite/site/news/releases/index.html

Modified: calcite/site/docs/adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/adapter.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/adapter.html (original)
+++ calcite/site/docs/adapter.html Mon Oct  2 17:08:04 2017
@@ -113,10 +113,14 @@ presenting the data as tables within a s
   <li><a href="cassandra_adapter.html">Cassandra adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/cassandra/package-summary.html">calcite-cassandra</a>)</li>
   <li>CSV adapter (<a href="/apidocs/org/apache/calcite/adapter/csv/package-summary.html">example/csv</a>)</li>
   <li><a href="druid_adapter.html">Druid adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/druid/package-summary.html">calcite-druid</a>)</li>
-  <li><a href="elasticsearch_adapter.html">Elasticsearch adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/elasticsearch/package-summary.html">calcite-elasticsearch</a>)</li>
+  <li><a href="elasticsearch_adapter.html">Elasticsearch adapter</a>
+(<a href="/apidocs/org/apache/calcite/adapter/elasticsearch2/package-summary.html">calcite-elasticsearch2</a>
+and
+<a href="/apidocs/org/apache/calcite/adapter/elasticsearch5/package-summary.html">calcite-elasticsearch5</a>)</li>
   <li><a href="file_adapter.html">File adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/file/package-summary.html">calcite-file</a>)</li>
   <li>JDBC adapter (part of <a href="/apidocs/org/apache/calcite/adapter/jdbc/package-summary.html">calcite-core</a>)</li>
   <li>MongoDB adapter (<a href="/apidocs/org/apache/calcite/adapter/mongodb/package-summary.html">calcite-mongodb</a>)</li>
+  <li><a href="os_adapter.html">OS adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/os/package-summary.html">calcite-os</a>)</li>
   <li><a href="pig_adapter.html">Pig adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/pig/package-summary.html">calcite-pig</a>)</li>
   <li>Solr cloud adapter (<a href="https://github.com/bluejoe2008/solr-sql">solr-sql</a>)</li>
   <li>Spark adapter (<a href="/apidocs/org/apache/calcite/adapter/spark/package-summary.html">calcite-spark</a>)</li>
@@ -325,7 +329,7 @@ For example,</p>
           
             
             
-            <a href="/docs/stream.html" class="next">Next</a>
+            <a href="/docs/spatial.html" class="next">Next</a>
           
       </div>
     </div>
@@ -392,6 +396,16 @@ For example,</p>
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/algebra.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/algebra.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/algebra.html (original)
+++ calcite/site/docs/algebra.html Mon Oct  2 17:08:04 2017
@@ -756,6 +756,16 @@ added to the stack.</p>
 
   
 
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
+  
+  
+  
+
+  
+
   <li class=""><a href="/docs/stream.html">Streaming</a></li>
 
 

Modified: calcite/site/docs/avatica_json_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_json_reference.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/avatica_json_reference.html (original)
+++ calcite/site/docs/avatica_json_reference.html Mon Oct  2 17:08:04 2017
@@ -144,6 +144,9 @@
 
   
   
+
+  
+  
     <div class="section-nav">
       <div class="left align-right">
           
@@ -223,6 +226,16 @@
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/avatica_overview.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_overview.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/avatica_overview.html (original)
+++ calcite/site/docs/avatica_overview.html Mon Oct  2 17:08:04 2017
@@ -138,6 +138,9 @@
 
   
   
+
+  
+  
     <div class="section-nav">
       <div class="left align-right">
           
@@ -217,6 +220,16 @@
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/avatica_protobuf_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_protobuf_reference.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/avatica_protobuf_reference.html (original)
+++ calcite/site/docs/avatica_protobuf_reference.html Mon Oct  2 17:08:04 2017
@@ -147,6 +147,9 @@
 
   
   
+
+  
+  
     <div class="section-nav">
       <div class="left align-right">
           
@@ -226,6 +229,16 @@
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/avatica_roadmap.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_roadmap.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/avatica_roadmap.html (original)
+++ calcite/site/docs/avatica_roadmap.html Mon Oct  2 17:08:04 2017
@@ -141,6 +141,9 @@
 
   
   
+
+  
+  
     <div class="section-nav">
       <div class="left align-right">
           
@@ -220,6 +223,16 @@
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/cassandra_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/cassandra_adapter.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/cassandra_adapter.html (original)
+++ calcite/site/docs/cassandra_adapter.html Mon Oct  2 17:08:04 2017
@@ -242,6 +242,9 @@ prove useful.</p>
   
   
 
+  
+  
+
 
         </article>
       </div>
@@ -303,6 +306,16 @@ prove useful.</p>
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/druid_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/druid_adapter.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/druid_adapter.html (original)
+++ calcite/site/docs/druid_adapter.html Mon Oct  2 17:08:04 2017
@@ -159,7 +159,6 @@ of the Druid adapter.</p>
               </span><span class="s2">"page"</span><span class="p">,</span><span class="w">
               </span><span class="s2">"regionIsoCode"</span><span class="p">,</span><span class="w">
               </span><span class="s2">"regionName"</span><span class="p">,</span><span class="w">
-              </span><span class="s2">"user"</span><span class="w">
             </span><span class="p">],</span><span class="w">
             </span><span class="nt">"metrics"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="w">
               </span><span class="p">{</span><span class="w">
@@ -184,8 +183,11 @@ of the Druid adapter.</p>
               </span><span class="p">{</span><span class="w">
                 </span><span class="nt">"name"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"user_unique"</span><span class="p">,</span><span class="w">
                 </span><span class="nt">"type"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"hyperUnique"</span><span class="p">,</span><span class="w">
-                </span><span class="nt">"fieldName"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"user"</span><span class="w">
+                </span><span class="nt">"fieldName"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"user_id"</span><span class="w">
               </span><span class="p">}</span><span class="w">
+            </span><span class="p">],</span><span class="w">
+            </span><span class="nt">"complexMetrics"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="w">
+              </span><span class="s2">"user_id"</span><span class="w">
             </span><span class="p">]</span><span class="w">
           </span><span class="p">}</span><span class="w">
         </span><span class="p">}</span><span class="w">
@@ -241,6 +243,20 @@ part of the query to Druid, including th
 but not the <code class="highlighter-rouge">ORDER BY ... LIMIT</code>. (We plan to lift this restriction;
 see [<a href="https://issues.apache.org/jira/browse/CALCITE-1206">CALCITE-1206</a>].)</p>
 
+<h1 id="complex-metrics">Complex Metrics</h1>
+<p>Druid has special metrics that produce quick but approximate results.
+Currently there are two types:</p>
+
+<ul>
+  <li><code class="highlighter-rouge">hyperUnique</code> - HyperLogLog data sketch used to estimate the cardinality of a dimension</li>
+  <li><code class="highlighter-rouge">thetaSketch</code> - Theta sketch used to also estimate the cardinality of a dimension,
+but can be used to perform set operations as well.</li>
+</ul>
+
+<p>In the model definition, there is an array of Strings called <code class="highlighter-rouge">complexMetrics</code> that declares
+the alias for each complex metric defined. The alias is used in SQL, but it’s real column name
+is used when Calcite generates the JSON query for druid.</p>
+
 <h1 id="foodmart-data-set">Foodmart data set</h1>
 
 <p>The test VM also includes a data set that denormalizes
@@ -397,6 +413,9 @@ and the two tables in Druid (<code class
   
   
 
+  
+  
+
 
         </article>
       </div>
@@ -458,6 +477,16 @@ and the two tables in Druid (<code class
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/elasticsearch_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/elasticsearch_adapter.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/elasticsearch_adapter.html (original)
+++ calcite/site/docs/elasticsearch_adapter.html Mon Oct  2 17:08:04 2017
@@ -128,7 +128,7 @@ in the model definition.</p>
     </span><span class="p">{</span><span class="w">
       </span><span class="nt">"type"</span><span class="p">:</span><span class="w"> </span><span class="s2">"custom"</span><span class="p">,</span><span class="w">
       </span><span class="nt">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"elasticsearch"</span><span class="p">,</span><span class="w">
-      </span><span class="nt">"factory"</span><span class="p">:</span><span class="w"> </span><span class="s2">"org.apache.calcite.adapter.elasticsearch.ElasticsearchSchemaFactory"</span><span class="p">,</span><span class="w">
+      </span><span class="nt">"factory"</span><span class="p">:</span><span class="w"> </span><span class="s2">"org.apache.calcite.adapter.elasticsearch2.Elasticsearch2SchemaFactory"</span><span class="p">,</span><span class="w">
       </span><span class="nt">"operand"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w">
         </span><span class="nt">"coordinates"</span><span class="p">:</span><span class="w"> </span><span class="s2">"{'127.0.0.1': 9300}"</span><span class="p">,</span><span class="w">
         </span><span class="nt">"userConfig"</span><span class="p">:</span><span class="w"> </span><span class="s2">"{'bulk.flush.max.actions': 10, 'bulk.flush.max.size.mb': 1}"</span><span class="p">,</span><span class="w">
@@ -138,6 +138,9 @@ in the model definition.</p>
   </span><span class="p">]</span><span class="w">
 </span><span class="p">}</span></code></pre></figure>
 
+<p>This adapter is targeted for Elasticsearch 2.x. To use Calcite with Elasticsearch 5.x+ you can use the factory
+of the adapter targeted for Elasticsearch 5.x: <code class="highlighter-rouge">org.apache.calcite.adapter.elasticsearch5.Elasticsearch5SchemaFactory</code></p>
+
 <p>Assuming this file is stored as <code class="highlighter-rouge">model.json</code>, you can connect to
 Elasticsearch via <a href="https://github.com/julianhyde/sqlline"><code class="highlighter-rouge">sqlline</code></a> as
 follows:</p>
@@ -264,6 +267,9 @@ it.</p>
   
   
 
+  
+  
+
 
         </article>
       </div>
@@ -325,6 +331,16 @@ it.</p>
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/file_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/file_adapter.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/file_adapter.html (original)
+++ calcite/site/docs/file_adapter.html Mon Oct  2 17:08:04 2017
@@ -400,6 +400,9 @@ files) and being able to form URLs dynam
   
   
 
+  
+  
+
 
         </article>
       </div>
@@ -461,6 +464,16 @@ files) and being able to form URLs dynam
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/history.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/history.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/history.html (original)
+++ calcite/site/docs/history.html Mon Oct  2 17:08:04 2017
@@ -109,7 +109,7 @@
 Downloads are available on the
 <a href="/downloads/">downloads page</a>.</p>
 
-<h2 id="v1-14-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.14.0">1.14.0</a> / under development</h2>
+<h2 id="v1-15-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.15.0">1.15.0</a> / under development</h2>
 
 <p>Compatibility: This release is tested
 on Linux, macOS, Microsoft Windows;
@@ -118,6 +118,118 @@ Guava versions 14.0 to 21.0;
 Druid version 0.10.0;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
+<h2 id="v1-14-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.14.0">1.14.0</a> / 2017-09-06</h2>
+
+<p>This release brings some big new features.
+The <code class="highlighter-rouge">GEOMETRY</code> data type was added along with 35 associated functions as the start of support for Simple Feature Access.
+There are also two new adapters.
+Firstly, the Elasticsearch 5 adapter which now exists in parallel with the previous Elasticsearch 2 adapter.
+Additionally there is now an <a href="/docs/os_adapter.html">OS adapter</a> which exposes operating system metrics as relational tables.
+<code class="highlighter-rouge">ThetaSketch</code> and <code class="highlighter-rouge">HyperUnique</code> support has also been added to the Druid adapter.</p>
+
+<p>Several minor improvements are added as well including improved <code class="highlighter-rouge">MATCH_RECOGNIZE</code> support, quantified comparison predicates, and <code class="highlighter-rouge">ARRAY</code> and <code class="highlighter-rouge">MULTISET</code> support for UDFs.
+A full list of new features is given below.</p>
+
+<p>There are also a few breaking changes.
+The return type of <code class="highlighter-rouge">RANK</code> and other aggregate functions has been changed.
+There also changes to <code class="highlighter-rouge">Aggregate</code> in order to improve compatibility with Apache Hive.
+Finally, the <code class="highlighter-rouge">Schema#snapshot()</code> interface has been upgraded to allow for more flexible versioning.</p>
+
+<p>Compatibility: This release is tested
+on Linux, macOS, Microsoft Windows;
+using Oracle JDK 1.7, 1.8, 9;
+Guava versions 14.0 to 21.0;
+Druid version 0.10.0;
+other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
+
+<h4 id="new-features">New features</h4>
+
+<ul>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1968">CALCITE-1968</a>]  OpenGIS Simple Feature Access SQL 1.2.1: add <code class="highlighter-rouge">GEOMETRY</code> data type and first 35 functions
+Add Spatial page, document GIS functions in SQL reference (indicating
+which ones are implemented), and add “countries” data set for testing.</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1967">CALCITE-1967</a>]  Elasticsearch 5 adapter (Christian Beikov)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1911">CALCITE-1911</a>]  In <code class="highlighter-rouge">MATCH_RECOGNIZE</code>, support <code class="highlighter-rouge">WITHIN</code> sub-clause (Dian Fu)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1897">CALCITE-1897</a>]  Add ‘%’ operator as an alternative to ‘MOD’ (sunjincheng)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1787">CALCITE-1787</a>]  Add <code class="highlighter-rouge">ThetaSketch</code> and <code class="highlighter-rouge">HyperUnique</code> support to Calcite via rolled up columns (Zain Humayun)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1896">CALCITE-1896</a>]  OS adapter and <code class="highlighter-rouge">sqlsh</code>
+    <ul>
+      <li>Vmstat table function for sqlsh</li>
+    </ul>
+  </li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1864">CALCITE-1864</a>]  Allow <code class="highlighter-rouge">NULL</code> literal as argument</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1834">CALCITE-1834</a>]  Allow user-defined functions to have arguments that are <code class="highlighter-rouge">ARRAY</code> or <code class="highlighter-rouge">MULTISET</code> (Ankit Singhal)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1886">CALCITE-1886</a>]  Support <code class="highlighter-rouge">"LIMIT [offset,] row_count"</code>, per MySQL (Kaiwang Chen)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1845">CALCITE-1845</a>]  Quantified comparison predicates (SOME, ANY, ALL)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1709">CALCITE-1709</a>]  Support mixing table columns with extended columns in DML (Rajeshbabu Chintaguntla)</li>
+</ul>
+
+<h4 id="bug-fixes-api-changes-and-minor-enhancements">Bug-fixes, API changes and minor enhancements</h4>
+
+<ul>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1931">CALCITE-1931</a>]
+Change the return type of <code class="highlighter-rouge">RANK</code> and other aggregate functions.
+Various aggregate functions that used to return <code class="highlighter-rouge">INTEGER</code> now return other
+types: <code class="highlighter-rouge">RANK</code>, <code class="highlighter-rouge">DENSE_RANK</code>, and <code class="highlighter-rouge">NTILE</code> now return <code class="highlighter-rouge">BIGINT</code>;
+<code class="highlighter-rouge">CUME_DIST</code> and <code class="highlighter-rouge">PERCENT_RANK</code> now return <code class="highlighter-rouge">DOUBLE</code>.
+(<strong>This is a breaking change</strong>.)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1947">CALCITE-1947</a>]  Add <code class="highlighter-rouge">TIME</code>/<code class="highlighter-rouge">TIMESTAMP</code> with local time zone types to optimizer</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1972">CALCITE-1972</a>]  Create <code class="highlighter-rouge">.sha512</code> and <code class="highlighter-rouge">.md5</code> digests for release artifacts</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1941">CALCITE-1941</a>]  Refine interface <code class="highlighter-rouge">Schema#snapshot()</code>
+(<strong>This is a breaking change</strong>.)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1069">CALCITE-1069</a>]  In <code class="highlighter-rouge">Aggregate</code>, deprecate indicators, and allow <code class="highlighter-rouge">GROUPING</code> to be used as an aggregate function
+(<strong>This is a breaking change</strong>.)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1969">CALCITE-1969</a>]  Annotate user-defined functions as strict and semi-strict</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1945">CALCITE-1945</a>]  Make return types of <code class="highlighter-rouge">AVG</code>, <code class="highlighter-rouge">VARIANCE</code>, <code class="highlighter-rouge">STDDEV</code> and <code class="highlighter-rouge">COVAR</code> customizable via RelDataTypeSystem</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1966">CALCITE-1966</a>]  Allow normal views to act as materialization table (Christian Beikov)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1953">CALCITE-1953</a>]  Rewrite <code class="highlighter-rouge">"NOT (x IS FALSE)" to "x IS NOT FALSE"; "x IS TRUE"</code> would be wrong</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1943">CALCITE-1943</a>]  Add back <code class="highlighter-rouge">NavigationExpander</code> and <code class="highlighter-rouge">NavigationReplacer</code> in <code class="highlighter-rouge">SqlValidatorImpl</code> (Dian Fu)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1963">CALCITE-1963</a>]  Upgrade checkstyle, and fix code to comply</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1944">CALCITE-1944</a>]  Window function applied to sub-query that returns dynamic star gets wrong plan (Volodymyr Vysotskyi)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1954">CALCITE-1954</a>]  Column from outer join should be null, whether or not it is aliased</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1959">CALCITE-1959</a>]  Reduce the amount of metadata and <code class="highlighter-rouge">tableName</code> calls in Druid (Zain Humayun)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1930">CALCITE-1930</a>]  Fix <code class="highlighter-rouge">AggregateExpandDistinctAggregatesRule</code> when there are multiple <code class="highlighter-rouge">AggregateCalls</code> referring to the same input</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1936">CALCITE-1936</a>]  Allow <code class="highlighter-rouge">ROUND()</code> and <code class="highlighter-rouge">TRUNCATE()</code> to take one operand, defaulting scale to 0</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1931">CALCITE-1931</a>]  Change the return type of RANK and other aggregate functions</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1932">CALCITE-1932</a>]  <code class="highlighter-rouge">Project.getPermutation()</code> should return null if not a permutation (e.g. repeated <code class="highlighter-rouge">InputRef</code>)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1925">CALCITE-1925</a>]  In <code class="highlighter-rouge">JaninoRelMetadataProvider</code>, cache null values (Ted Xu)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1849">CALCITE-1849</a>]  Support <code class="highlighter-rouge">RexSubQuery</code> in <code class="highlighter-rouge">RelToSqlConverter</code></li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1909">CALCITE-1909</a>]  Output <code class="highlighter-rouge">rowType</code> of Match should include <code class="highlighter-rouge">PARTITION BY</code> and <code class="highlighter-rouge">ORDER BY</code> columns</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1929">CALCITE-1929</a>]  Deprecate class <code class="highlighter-rouge">RelDataTypeFactory.FieldInfoBuilder</code></li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1895">CALCITE-1895</a>]  MSSQL’s SUBSTRING operator has different syntax (Chris Baynes)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1919">CALCITE-1919</a>]  <code class="highlighter-rouge">NullPointerException</code> when target in <code class="highlighter-rouge">ReflectiveSchema</code> belongs to root package (Lim Chee Hau)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1907">CALCITE-1907</a>]  Table function with 1 column gives <code class="highlighter-rouge">ClassCastException</code></li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1841">CALCITE-1841</a>]  Create handlers for JDBC dialect-specific generated SQL (Chris Baynes)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1898">CALCITE-1898</a>]  <code class="highlighter-rouge">LIKE</code> must match ‘.’ (period) literally</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1900">CALCITE-1900</a>]  Detect cyclic views and give useful error message</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1893">CALCITE-1893</a>]  Add MYSQL_5 conformance</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1883">CALCITE-1883</a>]  <code class="highlighter-rouge">HepPlanner</code> should force garbage collect whenever a root registered (Ted Xu)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1889">CALCITE-1889</a>]  Accept compound identifiers in <code class="highlighter-rouge">SqlValidatorUtil.checkIdentifierListForDuplicates()</code> (Rajeshbabu Chintaguntla)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1881">CALCITE-1881</a>]  Can’t distinguish overloaded user-defined functions that have DATE and TIMESTAMP arguments (余启)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1803">CALCITE-1803</a>]  Push Project that follows Aggregate down to Druid (Junxian Wu)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1828">CALCITE-1828</a>]  Push the FILTER clause into Druid as a Filtered Aggregator (Zain Humayun)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1871">CALCITE-1871</a>]  Nesting <code class="highlighter-rouge">LAST</code> within <code class="highlighter-rouge">PREV</code> is not parsed correctly for <code class="highlighter-rouge">MATCH_RECOGNIZE</code></li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1877">CALCITE-1877</a>]  Move the Pig test data files into target for the test runtime</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1815">CALCITE-1815</a>]  Switch Pig adapter to depend on avatica-core instead of full avatica</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1826">CALCITE-1826</a>]  Generate dialect-specific SQL for <code class="highlighter-rouge">FLOOR</code> operator when in a <code class="highlighter-rouge">GROUP BY</code> (Chris Baynes)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1842">CALCITE-1842</a>]  <code class="highlighter-rouge">Sort.computeSelfCost()</code><code class="highlighter-rouge"> calls </code>makeCost()`` with arguments in wrong order (Junxian Wu)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1874">CALCITE-1874</a>]  In Frameworks, make <code class="highlighter-rouge">SqlToRelConverter</code> configurable</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1873">CALCITE-1873</a>]  In a “GROUP BY ordinal” query, validator gives invalid “Expression is not being grouped” error if column has alias</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1833">CALCITE-1833</a>]  User-defined aggregate functions with more than one parameter (hzyuemeng1)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1860">CALCITE-1860</a>]  Duplicate null predicates cause <code class="highlighter-rouge">NullPointerException</code> in <code class="highlighter-rouge">RexUtil</code> (Ruidong Li)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1859">CALCITE-1859</a>]  NPE in validate method of <code class="highlighter-rouge">VolcanoPlanner</code></li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1818">CALCITE-1818</a>]  Handle <code class="highlighter-rouge">SqlKind.DYNAMIC</code> (parameters) in <code class="highlighter-rouge">SqlImplementor</code> (Dylan Adams)</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1856">CALCITE-1856</a>]  Add option <code class="highlighter-rouge">StructKind.PEEK_FIELDS_NO_EXPAND</code>, similar to <code class="highlighter-rouge">PEEK_FIELDS</code> but is not expanded in <code class="highlighter-rouge">"SELECT *"</code> (Shuyi Chen)</li>
+</ul>
+
+<h4 id="web-site-and-documentation">Web site and documentation</h4>
+
+<ul>
+  <li>Add committer Chris Baynes</li>
+  <li>Add DataEngConf talk</li>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1901">CALCITE-1901</a>]  SQL reference should say that “ONLY” is required after “FETCH … ROWS”</li>
+</ul>
+
 <h2 id="v1-13-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.13.0">1.13.0</a> / 2017-06-20</h2>
 
 <p>This release comes three months after 1.12.0. It includes more than 75 resolved issues, comprising
@@ -155,7 +267,7 @@ Guava versions 14.0 to 21.0;
 Druid version 0.10.0;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features">New features</h4>
+<h4 id="new-features-1">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1570">CALCITE-1570</a>]
@@ -233,7 +345,7 @@ Upgrade Druid to 0.9.2 (Nishant Bangarwa
 Support extended columns in DML (Kevin Liew)</li>
 </ul>
 
-<h4 id="bug-fixes-api-changes-and-minor-enhancements">Bug-fixes, API changes and minor enhancements</h4>
+<h4 id="bug-fixes-api-changes-and-minor-enhancements-1">Bug-fixes, API changes and minor enhancements</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1855">CALCITE-1855</a>]
@@ -320,7 +432,7 @@ Match <code class="highlighter-rouge">Dr
 Do not push group by on druid metrics fields (Slim Bouguerra)</li>
 </ul>
 
-<h4 id="web-site-and-documentation">Web site and documentation</h4>
+<h4 id="web-site-and-documentation-1">Web site and documentation</h4>
 
 <ul>
   <li>Michael Mior joins PMC</li>
@@ -354,7 +466,7 @@ Guava versions 14.0 to 21.0;
 Druid version 0.9.1.1;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h3 id="new-features-1">New features</h3>
+<h3 id="new-features-2">New features</h3>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1666">CALCITE-1666</a>]
@@ -444,7 +556,7 @@ Add numeric scalar functions (Laurent Go
 JDK9</li>
 </ul>
 
-<h4 id="bug-fixes-api-changes-and-minor-enhancements-1">Bug-fixes, API changes and minor enhancements</h4>
+<h4 id="bug-fixes-api-changes-and-minor-enhancements-2">Bug-fixes, API changes and minor enhancements</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1716">CALCITE-1716</a>]
@@ -593,7 +705,7 @@ Correlated scalar sub-query with multipl
 (Kurt Young)</li>
 </ul>
 
-<h4 id="web-site-and-documentation-1">Web site and documentation</h4>
+<h4 id="web-site-and-documentation-2">Web site and documentation</h4>
 
 <ul>
   <li>Maryann Xue joins PMC</li>
@@ -663,7 +775,7 @@ Guava versions 14.0 to 19.0;
 Druid version 0.9.1.1;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features-2">New features</h4>
+<h4 id="new-features-3">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1551">CALCITE-1551</a>]
@@ -741,7 +853,7 @@ Implement JDBC functions: <code class="h
 Add <code class="highlighter-rouge">AS JSON</code> as output option for <code class="highlighter-rouge">EXPLAIN</code></li>
 </ul>
 
-<h4 id="bug-fixes-api-changes-and-minor-enhancements-2">Bug-fixes, API changes and minor enhancements</h4>
+<h4 id="bug-fixes-api-changes-and-minor-enhancements-3">Bug-fixes, API changes and minor enhancements</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1559">CALCITE-1559</a>]
@@ -831,7 +943,7 @@ Druid type is called <code class="highli
 Add sub-query support for RelStructuredTypeFlattener</li>
 </ul>
 
-<h4 id="web-site-and-documentation-2">Web site and documentation</h4>
+<h4 id="web-site-and-documentation-3">Web site and documentation</h4>
 
 <ul>
   <li>Change PMC chair</li>
@@ -860,7 +972,7 @@ other software versions as specified in
 Support operator <code class="highlighter-rouge">!=</code> as an alternative to <code class="highlighter-rouge">&lt;&gt;</code></li>
 </ul>
 
-<h4 id="bug-fixes-api-changes-and-minor-enhancements-3">Bug-fixes, API changes and minor enhancements</h4>
+<h4 id="bug-fixes-api-changes-and-minor-enhancements-4">Bug-fixes, API changes and minor enhancements</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1378">CALCITE-1378</a>]
@@ -891,7 +1003,7 @@ Druid Filter translation incorrect if in
 Allow Calcite JDBC Driver minor version to be greater than 9</li>
 </ul>
 
-<h4 id="web-site-and-documentation-3">Web site and documentation</h4>
+<h4 id="web-site-and-documentation-4">Web site and documentation</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1393">CALCITE-1393</a>]
@@ -928,7 +1040,7 @@ using Oracle JDK 1.7, 1.8;
 Guava versions 14.0 to 19.0;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features-3">New features</h4>
+<h4 id="new-features-4">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1208">CALCITE-1208</a>]
@@ -975,7 +1087,7 @@ Convert predicates on <code class="highl
 Introduce <code class="highlighter-rouge">UnionPullUpConstantsRule</code></li>
 </ul>
 
-<h4 id="bug-fixes-api-changes-and-minor-enhancements-4">Bug-fixes, API changes and minor enhancements</h4>
+<h4 id="bug-fixes-api-changes-and-minor-enhancements-5">Bug-fixes, API changes and minor enhancements</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-30">CALCITE-30</a>]
@@ -1044,7 +1156,7 @@ In <code class="highlighter-rouge">SqlKi
 Calcite generate wrong field names in JDBC adapter</li>
 </ul>
 
-<h4 id="web-site-and-documentation-4">Web site and documentation</h4>
+<h4 id="web-site-and-documentation-5">Web site and documentation</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1229">CALCITE-1229</a>]
@@ -1085,7 +1197,7 @@ using Oracle JDK 1.7, 1.8;
 Guava versions 14.0 to 19.0;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features-4">New features</h4>
+<h4 id="new-features-5">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1177">CALCITE-1177</a>]
@@ -1142,7 +1254,7 @@ Add <code class="highlighter-rouge">Proj
 substitution</li>
 </ul>
 
-<h4 id="bug-fixes-api-changes-and-minor-enhancements-5">Bug-fixes, API changes and minor enhancements</h4>
+<h4 id="bug-fixes-api-changes-and-minor-enhancements-6">Bug-fixes, API changes and minor enhancements</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1281">CALCITE-1281</a>]
@@ -1221,7 +1333,7 @@ Allow <code class="highlighter-rouge">Sq
 Allow apache-rat to be run outside of release process</li>
 </ul>
 
-<h4 id="web-site-and-documentation-5">Web site and documentation</h4>
+<h4 id="web-site-and-documentation-6">Web site and documentation</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1273">CALCITE-1273</a>]
@@ -1282,7 +1394,7 @@ using Oracle JDK 1.7, 1.8;
 Guava versions 12.0.1 to 19.0;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features-5">New features</h4>
+<h4 id="new-features-6">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1124">CALCITE-1124</a>]
@@ -1326,7 +1438,7 @@ In <code class="highlighter-rouge">RelBu
 Not valid to convert <code class="highlighter-rouge">Aggregate</code> on empty to empty if its <code class="highlighter-rouge">GROUP BY</code> key is empty</li>
 </ul>
 
-<h4 id="bug-fixes-api-changes-and-minor-enhancements-6">Bug-fixes, API changes and minor enhancements</h4>
+<h4 id="bug-fixes-api-changes-and-minor-enhancements-7">Bug-fixes, API changes and minor enhancements</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1147">CALCITE-1147</a>]
@@ -1393,7 +1505,7 @@ Upgrade Jackson</li>
 Clean up maven POM files</li>
 </ul>
 
-<h4 id="web-site-and-documentation-6">Web site and documentation</h4>
+<h4 id="web-site-and-documentation-7">Web site and documentation</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1112">CALCITE-1112</a>]
@@ -1449,7 +1561,7 @@ on Linux, Mac OS X, Microsoft Windows;
 using Oracle JDK 1.7, 1.8;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features-6">New features</h4>
+<h4 id="new-features-7">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-816">CALCITE-816</a>]
@@ -1554,7 +1666,7 @@ Composite <code class="highlighter-rouge
 Add description to <code class="highlighter-rouge">SortProjectTransposeRule</code>’s constructor</li>
 </ul>
 
-<h4 id="bug-fixes-api-changes-and-minor-enhancements-7">Bug-fixes, API changes and minor enhancements</h4>
+<h4 id="bug-fixes-api-changes-and-minor-enhancements-8">Bug-fixes, API changes and minor enhancements</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1060">CALCITE-1060</a>]
@@ -1636,7 +1748,7 @@ Exception while validating <code class="
 Rename <code class="highlighter-rouge">timezone</code> connection property to <code class="highlighter-rouge">timeZone</code></li>
 </ul>
 
-<h4 id="web-site-and-documentation-7">Web site and documentation</h4>
+<h4 id="web-site-and-documentation-8">Web site and documentation</h4>
 
 <ul>
   <li>Avatica
@@ -1692,7 +1804,7 @@ multi-sets.  You can follow this example
 language, and immediately taking advantage of Calcite’s back-ends and
 optimizer rules. It’s all just algebra, after all!</p>
 
-<h4 id="new-features-7">New features</h4>
+<h4 id="new-features-8">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-911">CALCITE-911</a>]
@@ -1855,7 +1967,7 @@ Add API to execute queries expressed as
   <li>In RelBuilder, build expressions by table alias</li>
 </ul>
 
-<h4 id="bug-fixes-api-changes-and-minor-enhancements-8">Bug-fixes, API changes and minor enhancements</h4>
+<h4 id="bug-fixes-api-changes-and-minor-enhancements-9">Bug-fixes, API changes and minor enhancements</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-948">CALCITE-948</a>]
@@ -1943,7 +2055,7 @@ this release includes improvements to la
 and adds a builder API so that you can easily create relational
 algebra expressions.</p>
 
-<h4 id="new-features-8">New features</h4>
+<h4 id="new-features-9">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-748">CALCITE-748</a>]
@@ -1979,7 +2091,7 @@ exclusions otherwise</li>
     Web site</li>
 </ul>
 
-<h4 id="bug-fixes-api-changes-and-minor-enhancements-9">Bug-fixes, API changes and minor enhancements</h4>
+<h4 id="bug-fixes-api-changes-and-minor-enhancements-10">Bug-fixes, API changes and minor enhancements</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-741">CALCITE-741</a>]
@@ -2130,7 +2242,7 @@ and
 <a href="https://issues.apache.org/jira/browse/CALCITE-704">filtered aggregate functions</a>
 and various improvements to Avatica.</p>
 
-<h4 id="new-features-9">New features</h4>
+<h4 id="new-features-10">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-505">CALCITE-505</a>]
@@ -2259,7 +2371,7 @@ distribution among relational expression
 and [<a href="https://issues.apache.org/jira/browse/CALCITE-307">CALCITE-307</a>]
 improve implicit and explicit conversions in SQL.</p>
 
-<h4 id="new-features-10">New features</h4>
+<h4 id="new-features-11">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-366">CALCITE-366</a>]
@@ -2402,7 +2514,7 @@ later.</p>
 <code class="highlighter-rouge">RelNode</code>. We strongly suggest that you use these rather than
 calling constructors directly.</p>
 
-<h4 id="new-features-11">New features</h4>
+<h4 id="new-features-12">New features</h4>
 
 <ul>
   <li>SQL
@@ -2528,7 +2640,7 @@ improvements to the algorithms that impl
 including an interpreter that can evaluate queries without compilation;
 and fixes about 30 bugs.</p>
 
-<h4 id="new-features-12">New features</h4>
+<h4 id="new-features-13">New features</h4>
 
 <ul>
   <li>SQL
@@ -2790,7 +2902,7 @@ packages and lots of classes, in what we
 have an existing application, it’s worth upgrading to this first,
 before you move on to 1.0.</p>
 
-<h4 id="new-features-13">New features</h4>
+<h4 id="new-features-14">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-436">CALCITE-436</a>]
@@ -2841,7 +2953,7 @@ Push predicates through <code class="hig
 
 <p>This is the first release as Calcite. (The project was previously called Optiq.)</p>
 
-<h4 id="new-features-14">New features</h4>
+<h4 id="new-features-15">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-430">CALCITE-430</a>]
@@ -2998,7 +3110,7 @@ most recently.</li>
 
 <p>This is the first release under the Apache incubator process.</p>
 
-<h4 id="new-features-15">New features</h4>
+<h4 id="new-features-16">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-371">CALCITE-371</a>]
@@ -3130,7 +3242,7 @@ Add unit test for <code class="highlight
 
 <h2 id="v0-8"><a href="https://github.com/apache/calcite/releases/tag/optiq-parent-0.8">0.8</a> / 2014-06-27</h2>
 
-<h4 id="new-features-16">New features</h4>
+<h4 id="new-features-17">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-310">CALCITE-310</a>]
@@ -3211,7 +3323,7 @@ Window functions throw exception without
 
 <h2 id="v0-7"><a href="https://github.com/apache/calcite/releases/tag/optiq-parent-0.7">0.7</a> / 2014-05-13</h2>
 
-<h4 id="new-features-17">New features</h4>
+<h4 id="new-features-18">New features</h4>
 
 <ul>
   <li>Implement table functions.</li>
@@ -3296,7 +3408,7 @@ Suspicious map.get in VolcanoPlanner.rer
 
 <h2 id="v0-6"><a href="https://github.com/apache/calcite/releases/tag/optiq-parent-0.6">0.6</a> / 2014-04-11</h2>
 
-<h4 id="new-features-18">New features</h4>
+<h4 id="new-features-19">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-214">CALCITE-214</a>]
@@ -3421,7 +3533,7 @@ and obsolete our copy of the resource fr
 
 <h2 id="v0-5"><a href="https://github.com/apache/calcite/releases/tag/optiq-parent-0.5">0.5</a> / 2014-03-14</h2>
 
-<h4 id="new-features-19">New features</h4>
+<h4 id="new-features-20">New features</h4>
 
 <ul>
   <li>Allow <code class="highlighter-rouge">quoting</code>, <code class="highlighter-rouge">quotedCasing</code>, <code class="highlighter-rouge">unquotedCasing</code>, and <code class="highlighter-rouge">caseSensitive</code>
@@ -3986,6 +4098,9 @@ conflicts in multithreaded usage</li>
 
   
   
+
+  
+  
     <div class="section-nav">
       <div class="left align-right">
           
@@ -4065,6 +4180,16 @@ conflicts in multithreaded usage</li>
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/howto.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/howto.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/howto.html (original)
+++ calcite/site/docs/howto.html Mon Oct  2 17:08:04 2017
@@ -155,8 +155,8 @@ and Java (JDK 7, 8 or 9) on your path.</
 <code class="highlighter-rouge">cd</code> to the root directory of the unpacked source,
 then build using maven:</p>
 
-<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="gp">$ </span>tar xvfz calcite-1.13.0-source.tar.gz
-<span class="gp">$ </span><span class="nb">cd </span>calcite-1.13.0
+<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="gp">$ </span>tar xvfz calcite-1.14.0-source.tar.gz
+<span class="gp">$ </span><span class="nb">cd </span>calcite-1.14.0
 <span class="gp">$ </span>mvn install</code></pre></figure>
 
 <p><a href="#running-tests">Running tests</a> describes how to run more or fewer
@@ -553,7 +553,7 @@ notes.  To test Guava version x.y, speci
     </ul>
   </li>
   <li>Trigger a
-<a href="https://scan.coverity.com/projects/2966">Coverity scan</a>
+<a href="https://scan.coverity.com/projects/julianhyde-calcite">Coverity scan</a>
 by merging the latest code into the <code class="highlighter-rouge">julianhyde/coverity_scan</code> branch,
 and when it completes, make sure that there are no important issues.</li>
   <li>Add release notes to <code class="highlighter-rouge">site/_docs/history.md</code>. Include the commit history,
@@ -594,9 +594,12 @@ git clean -xn
 mvn clean
 
 <span class="c"># Do a dry run of the release:prepare step, which sets version numbers</span>
+<span class="c"># (accept the default tag name of calcite-X.Y.Z)</span>
 mvn -DdryRun<span class="o">=</span><span class="nb">true</span> -DskipTests -DreleaseVersion<span class="o">=</span>X.Y.Z -DdevelopmentVersion<span class="o">=</span>X.Y+1.Z-SNAPSHOT -Papache-release -Darguments<span class="o">=</span><span class="s2">"-Dgpg.passphrase=</span><span class="k">${</span><span class="nv">GPG_PASSPHRASE</span><span class="k">}</span><span class="s2">"</span> release:prepare 2&gt;&amp;1 | tee /tmp/prepare-dry.log</code></pre></figure>
 
-<p>Check the artifacts:</p>
+<p>Check the artifacts.
+Note that when performing the dry run <code class="highlighter-rouge">SNAPSHOT</code> will appear in any file or directory names given below.
+The version will be automatically changed when performing the release for real.</p>
 
 <ul>
   <li>In the <code class="highlighter-rouge">target</code> directory should be these 8 files, among others:
@@ -604,11 +607,11 @@ mvn -DdryRun<span class="o">=</span><spa
       <li>apache-calcite-X.Y.Z-src.tar.gz</li>
       <li>apache-calcite-X.Y.Z-src.tar.gz.asc</li>
       <li>apache-calcite-X.Y.Z-src.tar.gz.md5</li>
-      <li>apache-calcite-X.Y.Z-src.tar.gz.sha1</li>
+      <li>apache-calcite-X.Y.Z-src.tar.gz.sha256</li>
       <li>apache-calcite-X.Y.Z-src.zip</li>
       <li>apache-calcite-X.Y.Z-src.zip.asc</li>
       <li>apache-calcite-X.Y.Z-src.zip.md5</li>
-      <li>apache-calcite-X.Y.Z-src.zip.sha1</li>
+      <li>apache-calcite-X.Y.Z-src.zip.sha256</li>
     </ul>
   </li>
   <li>Note that the file names start <code class="highlighter-rouge">apache-calcite-</code>.</li>
@@ -634,7 +637,8 @@ present and does not contain un-substitu
   <li>Check PGP, per <a href="https://httpd.apache.org/dev/verification.html">this</a></li>
 </ul>
 
-<p>Now, remove the <code class="highlighter-rouge">-DdryRun</code> flag and run the release for real.</p>
+<p>Now, remove the <code class="highlighter-rouge">-DdryRun</code> flag and run the release for real.
+For this step you’ll have to add the <a href="https://maven.apache.org/developers/committer-settings.html">Apache servers</a> to <code class="highlighter-rouge">~/.m2/settings.xml</code>.</p>
 
 <figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="c"># Prepare sets the version numbers, creates a tag, and pushes it to git</span>
 mvn -DdryRun<span class="o">=</span><span class="nb">false</span> -DskipTests -DreleaseVersion<span class="o">=</span>X.Y.Z -DdevelopmentVersion<span class="o">=</span>X.Y+1.Z-SNAPSHOT -Papache-release -Darguments<span class="o">=</span><span class="s2">"-Dgpg.passphrase=</span><span class="k">${</span><span class="nv">GPG_PASSPHRASE</span><span class="k">}</span><span class="s2">"</span> release:prepare 2&gt;&amp;1 | tee /tmp/prepare.log
@@ -664,13 +668,6 @@ mkdir -p ~/dist/dev
 svn co https://dist.apache.org/repos/dist/dev/calcite
 <span class="nb">popd</span>
 
-<span class="c"># Replace digest files with a single digest</span>
-<span class="nb">cd </span>target
-<span class="k">for </span>f <span class="k">in</span> <span class="k">*</span>.tar.gz <span class="k">*</span>.zip; <span class="k">do
-  </span>rm <span class="k">${</span><span class="nv">f</span><span class="k">}</span>.md5 <span class="k">${</span><span class="nv">f</span><span class="k">}</span>.sha1
-  gpg --print-mds <span class="k">${</span><span class="nv">f</span><span class="k">}</span> &gt; <span class="k">${</span><span class="nv">f</span><span class="k">}</span>.mds
-<span class="k">done</span>
-
 <span class="c"># Move the files into a directory</span>
 mkdir ~/dist/dev/calcite/apache-calcite-X.Y.Z-rcN
 mv apache-calcite-<span class="k">*</span> ~/dist/dev/calcite/apache-calcite-X.Y.Z-rcN
@@ -942,6 +939,9 @@ as a template. Be sure to include a brie
 
   
   
+
+  
+  
     <div class="section-nav">
       <div class="left align-right">
           
@@ -1021,6 +1021,16 @@ as a template. Be sure to include a brie
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/index.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/index.html (original)
+++ calcite/site/docs/index.html Mon Oct  2 17:08:04 2017
@@ -313,6 +313,16 @@ more details in the <a href="reference.h
 
   
 
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
+  
+  
+  
+
+  
+
   <li class=""><a href="/docs/stream.html">Streaming</a></li>
 
 

Modified: calcite/site/docs/lattice.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/lattice.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/lattice.html (original)
+++ calcite/site/docs/lattice.html Mon Oct  2 17:08:04 2017
@@ -242,6 +242,9 @@ tiles).</p>
 
   
   
+
+  
+  
     <div class="section-nav">
       <div class="left align-right">
           
@@ -321,6 +324,16 @@ tiles).</p>
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/materialized_views.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/materialized_views.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/materialized_views.html (original)
+++ calcite/site/docs/materialized_views.html Mon Oct  2 17:08:04 2017
@@ -534,6 +534,9 @@ GROUP BY empid, deptname
   
   
 
+  
+  
+
 
         </article>
       </div>
@@ -595,6 +598,16 @@ GROUP BY empid, deptname
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/model.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/model.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/model.html (original)
+++ calcite/site/docs/model.html Mon Oct  2 17:08:04 2017
@@ -618,6 +618,9 @@ when you want to pass the column as a me
 
   
   
+
+  
+  
     <div class="section-nav">
       <div class="left align-right">
           
@@ -697,6 +700,16 @@ when you want to pass the column as a me
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/os_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/os_adapter.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/os_adapter.html (original)
+++ calcite/site/docs/os_adapter.html Mon Oct  2 17:08:04 2017
@@ -385,6 +385,9 @@ into <a href="https://github.com/julianh
   
   
 
+  
+  
+
 
         </article>
       </div>
@@ -446,6 +449,16 @@ into <a href="https://github.com/julianh
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/pig_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/pig_adapter.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/pig_adapter.html (original)
+++ calcite/site/docs/pig_adapter.html Mon Oct  2 17:08:04 2017
@@ -222,6 +222,9 @@ So, Piglet is basically the opposite of
   
   
 
+  
+  
+
 
         </article>
       </div>
@@ -283,6 +286,16 @@ So, Piglet is basically the opposite of
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+  
   
   
   

Modified: calcite/site/docs/powered_by.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/powered_by.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/powered_by.html (original)
+++ calcite/site/docs/powered_by.html Mon Oct  2 17:08:04 2017
@@ -257,6 +257,9 @@ graph database.</p>
 
   
   
+
+  
+  
     <div class="section-nav">
       <div class="left align-right">
           
@@ -336,6 +339,16 @@ graph database.</p>
 
 
   
+  
+  
+  
+
+  
+
+  <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+