You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jc...@apache.org on 2017/06/26 09:42:57 UTC
svn commit: r1799865 [1/2] - in /calcite/site: docs/ downloads/ img/ 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...
Author: jcamacho
Date: Mon Jun 26 09:42:55 2017
New Revision: 1799865
URL: http://svn.apache.org/viewvc?rev=1799865&view=rev
Log:
Update site with news for release 1.13.0
Added:
calcite/site/news/2017/06/
calcite/site/news/2017/06/26/
calcite/site/news/2017/06/26/release-1.13.0/
calcite/site/news/2017/06/26/release-1.13.0/index.html
Modified:
calcite/site/docs/history.html
calcite/site/docs/howto.html
calcite/site/docs/materialized_views.html
calcite/site/docs/reference.html
calcite/site/downloads/index.html
calcite/site/img/powered-by.png
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/index.html
calcite/site/news/releases/index.html
Modified: calcite/site/docs/history.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/history.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/docs/history.html (original)
+++ calcite/site/docs/history.html Mon Jun 26 09:42:55 2017
@@ -109,15 +109,232 @@
Downloads are available on the
<a href="/downloads/">downloads page</a>.</p>
-<h2 id="v1-13-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.13.0">1.13.0</a> / under development</h2>
+<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>
<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.9.2;
+Druid version 0.10.0;
other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
+<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
+a large number of new features as well as general improvements and bug-fixes.</p>
+
+<p>First, Calcite has been upgraded to use
+<a href="https://issues.apache.org/jira/browse/CALCITE-1807">Avatica 1.10.0</a>,
+which was recently released.</p>
+
+<p>Moreover, Calcite core includes improvements which aim at making it more powerful, stable and robust.
+In addition to numerous bux-fixes, we have implemented a
+<a href="https://issues.apache.org/jira/browse/CALCITE-1731">new materialized view rewriting algorithm</a>
+and <a href="https://issues.apache.org/jira/browse/CALCITE-1682">new metadata providers</a> which
+should prove useful for data processing systems relying on Calcite.</p>
+
+<p>In this release, we have also completed the work to
+<a href="https://issues.apache.org/jira/browse/CALCITE-1570">support the <code class="highlighter-rouge">MATCH_RECOGNIZE</code> clause</a>
+used in complex-event processing (CEP).</p>
+
+<p>In addition, more progress has been made for the different adapters.
+For instance, the Druid adapter now relies on
+<a href="https://issues.apache.org/jira/browse/CALCITE-1771">Druid 0.10.0</a> and
+it can generate more efficient plans where most of the computation can be pushed to Druid,
+e.g., <a href="https://issues.apache.org/jira/browse/CALCITE-1707">using extraction functions</a>.</p>
+
+<p>There is one minor but potentially breaking API change in
+[<a href="https://issues.apache.org/jira/browse/CALCITE-1788">CALCITE-1788</a>]
+(Simplify handling of position in the parser), requiring changes in the parameter
+lists of parser extension methods.</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-1570">CALCITE-1570</a>]
+Add <code class="highlighter-rouge">MATCH_RECOGNIZE</code> operator, for event pattern-matching
+ <ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1647">CALCITE-1647</a>]
+Classifier and <code class="highlighter-rouge">match_number</code> syntax support for <code class="highlighter-rouge">MATCH_RECOGNIZE</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1646">CALCITE-1646</a>]
+Partition by and order by syntax support for <code class="highlighter-rouge">MATCH_RECOGNIZE</code> (Zhiqiang-He)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1645">CALCITE-1645</a>]
+Row per match syntax support for <code class="highlighter-rouge">MATCH_RECOGNIZE</code> (Zhiqiang-He)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1644">CALCITE-1644</a>]
+Subset clause syntax support for <code class="highlighter-rouge">MATCH_RECOGNIZE</code> (Zhiqiang-He)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1643">CALCITE-1643</a>]
+<code class="highlighter-rouge">AFTER MATCH</code> sub-clause of <code class="highlighter-rouge">MATCH_RECOGNIZE</code> clause (Zhiqiang-He)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1642">CALCITE-1642</a>]
+Support <code class="highlighter-rouge">MEASURES</code> clause in <code class="highlighter-rouge">MATCH_RECOGNIZE</code> (Zhiqiang-He)</li>
+ </ul>
+ </li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1853">CALCITE-1853</a>]
+Push Count distinct into Druid when approximate results are acceptable (Zain Humayun)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1829">CALCITE-1829</a>]
+Add <code class="highlighter-rouge">TIME</code>/<code class="highlighter-rouge">TIMESTAMP</code>/<code class="highlighter-rouge">DATE</code> datatype handling to <code class="highlighter-rouge">RexImplicationChecker</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1613">CALCITE-1613</a>]
+Implement <code class="highlighter-rouge">EXTRACT</code> for time unit <code class="highlighter-rouge">DOW</code>, <code class="highlighter-rouge">DOY</code>; and fix <code class="highlighter-rouge">CENTURY</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1807">CALCITE-1807</a>]
+Upgrade to Avatica 1.10</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1802">CALCITE-1802</a>]
+Add post-aggregation step for Union in materialized view rewriting</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1795">CALCITE-1795</a>]
+Extend materialized view rewriting to produce rewritings using <code class="highlighter-rouge">Union</code> operators</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1797">CALCITE-1797</a>]
+Support view partial rewriting in aggregate materialized view rewriting</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1791">CALCITE-1791</a>]
+Support view partial rewriting in join materialized view rewriting</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1731">CALCITE-1731</a>]
+Rewriting of queries using materialized views with joins and aggregates</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1780">CALCITE-1780</a>]
+Add <code class="highlighter-rouge">required Order</code> and <code class="highlighter-rouge">requiresOver</code> parameters to the constructor of <code class="highlighter-rouge">SqlUserDefinedAggregate Function</code> (SunJincheng)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1306">CALCITE-1306</a>]
+Allow <code class="highlighter-rouge">GROUP BY</code> and <code class="highlighter-rouge">HAVING</code> to reference <code class="highlighter-rouge">SELECT</code> expressions by ordinal and alias (Rajeshbabu Chintaguntla)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1781">CALCITE-1781</a>]
+Allow expression in <code class="highlighter-rouge">CUBE</code> and <code class="highlighter-rouge">ROLLUP</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1771">CALCITE-1771</a>]
+Upgrade to Druid 0.10.0 (Nishant Bangarwa)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1772">CALCITE-1772</a>]
+Add a hook to allow <code class="highlighter-rouge">RelNode</code> expressions to be executed by JDBC driver</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1766">CALCITE-1766</a>]
+Support system functions having no args with parenthesis too (Ankit Singhal)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1760">CALCITE-1760</a>]
+Implement utility method to identify lossless casts</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1682">CALCITE-1682</a>]
+New metadata providers for expression column origin and all predicates in plan</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1753">CALCITE-1753</a>]
+Push expressions into null-generating side of a join if they are âstrongâ (null-preserving)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1759">CALCITE-1759</a>]
+Add SQL:2014 reserved words to parser</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-476">CALCITE-476</a>]
+Support distinct aggregates in window functions</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1738">CALCITE-1738</a>]
+Support <code class="highlighter-rouge">CAST</code> of literal values in filters pushed to Druid (Remus Rusanu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1758">CALCITE-1758</a>]
+Push to Druid <code class="highlighter-rouge">OrderBy</code>/<code class="highlighter-rouge">Limit</code> operation over time dimension and additional columns (Slim Bouguerra)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1707">CALCITE-1707</a>]
+Push <code class="highlighter-rouge">Extraction</code> filter on <code class="highlighter-rouge">Year</code>/<code class="highlighter-rouge">Month</code>/<code class="highlighter-rouge">Day</code> to druid (Slim Bouguerra)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1725">CALCITE-1725</a>]
+Push project aggregate of time extract to druid (Slim Bouguerra)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1747">CALCITE-1747</a>]
+<code class="highlighter-rouge">RelMdColumnUniqueness</code> for <code class="highlighter-rouge">HepRelVertex</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1749">CALCITE-1749</a>]
+Push filter conditions partially into Druid</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1730">CALCITE-1730</a>]
+Upgrade Druid to 0.9.2 (Nishant Bangarwa)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1702">CALCITE-1702</a>]
+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>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1855">CALCITE-1855</a>]
+Fix float values in Cassandra adapter</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1848">CALCITE-1848</a>]
+Rename MySource to FileSource (Darion Yaphet)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1852">CALCITE-1852</a>]
+Fix for <code class="highlighter-rouge">UnionMergeRule</code> to deal correctly with <code class="highlighter-rouge">EXCEPT</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1850">CALCITE-1850</a>]
+Extend <code class="highlighter-rouge">UnionMergeRule</code> to deal with more than 2 branches (Pengcheng Xiong)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1805">CALCITE-1805</a>]
+Druid adapter incorrectly pushes down <code class="highlighter-rouge">COUNT(c)</code>; Druid only supports <code class="highlighter-rouge">COUNT(*)</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1846">CALCITE-1846</a>]
+Metadata pulled up predicates should skip non-deterministic calls (Ted Xu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1819">CALCITE-1819</a>]
+Druid Adapter does not push the boolean operator <code class="highlighter-rouge"><></code> as a filter correctly (Zain Humayun)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1798">CALCITE-1798</a>]
+In JDBC adapter, generate dialect-specific SQL for <code class="highlighter-rouge">FLOOR</code> operator (Chris Baynes)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1812">CALCITE-1812</a>]
+Provide <code class="highlighter-rouge">RelMetadataQuery</code> from planner to rules and invalidate in <code class="highlighter-rouge">transformTo</code> (Remus Rusanu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1804">CALCITE-1804</a>]
+Cannot assign <code class="highlighter-rouge">NOT NULL</code> array to <code class="highlighter-rouge">NULLABLE</code> array (Ankit Singhal)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1810">CALCITE-1810</a>]
+Allow <code class="highlighter-rouge">NULL</code> for <code class="highlighter-rouge">ARRAY</code> constructor (Ankit Singhal)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1830">CALCITE-1830</a>]
+<code class="highlighter-rouge">ProcessBuilder</code> is security sensitive; move it to test suite to prevent accidents</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1816">CALCITE-1816</a>]
+<code class="highlighter-rouge">JaninoRelMetadataProvider</code> generated classes leak ACTIVE nodes on exception (Remus Rusanu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1690">CALCITE-1690</a>]
+Calcite timestamp literals cannot express precision above millisecond, <code class="highlighter-rouge">TIMESTAMP(3)</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1664">CALCITE-1664</a>]
+<code class="highlighter-rouge">CAST(<string> as TIMESTAMP)</code> adds part of sub-second fraction to the value</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1742">CALCITE-1742</a>]
+Create a read-consistent view of CalciteSchema for each statement compilation</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1800">CALCITE-1800</a>]
+JDBC adapter fails on query with <code class="highlighter-rouge">UNION</code> in <code class="highlighter-rouge">FROM</code> clause (Viktor Batytskyi, Minji Kim)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1788">CALCITE-1788</a>]
+Simplify handling of position in the parser</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1782">CALCITE-1782</a>]
+<code class="highlighter-rouge">AggregateExpandDistinctAggregatesRule</code> should work on <code class="highlighter-rouge">Aggregate</code> instead of <code class="highlighter-rouge">LogicalAggregate</code> (Haohui Mai)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1293">CALCITE-1293</a>]
+Bad code generated when argument to <code class="highlighter-rouge">COUNT(DISTINCT)</code> is a <code class="highlighter-rouge">GROUP BY</code> column</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1770">CALCITE-1770</a>]
+<code class="highlighter-rouge">CAST(NULL AS ...)</code> gives NPE (Slim Bouguerra)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1777">CALCITE-1777</a>]
+<code class="highlighter-rouge">WHERE FALSE</code> causes <code class="highlighter-rouge">AssertionError</code> (Slim Bouguerra)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1778">CALCITE-1778</a>]
+Query with <code class="highlighter-rouge">WHERE CASE</code> throws <code class="highlighter-rouge">AssertionError</code> âCast for just nullability not allowedâ</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1773">CALCITE-1773</a>]
+Add Test sql validator test for Pattern skip syntax in <code class="highlighter-rouge">MATCH_RECOGNIZE</code> (Zhiqiang-He)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1761">CALCITE-1761</a>]
+<code class="highlighter-rouge">TUMBLE</code>/<code class="highlighter-rouge">HOP</code>/<code class="highlighter-rouge">SESSION_START</code>/<code class="highlighter-rouge">END</code> do not resolve time field correctly</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1765">CALCITE-1765</a>]
+Druid adapter fail when the extract granularity is not supported (Slim Bouguerra)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1767">CALCITE-1767</a>]
+Fix join/aggregate rewriting rule when same table is referenced more than once</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1764">CALCITE-1764</a>]
+Adding sort ordering type for druid sort json field (Slim Bouguerra)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-715">CALCITE-715</a>]
+Add <code class="highlighter-rouge">PERIOD</code> type constructor and period operators (<code class="highlighter-rouge">CONTAINS</code>, <code class="highlighter-rouge">PRECEDES</code>, etc.)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1456">CALCITE-1456</a>]
+Change <code class="highlighter-rouge">SubstitutionVisitor</code> to use generic <code class="highlighter-rouge">RelBuilder</code> instead of Logical instances of the operators when possible</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1763">CALCITE-1763</a>]
+Recognize lossless casts in join/aggregate materialized view rewriting rule</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1639">CALCITE-1639</a>]
+<code class="highlighter-rouge">TIMESTAMPADD(MONTH, ...)</code> should return last day of month if the day overflows</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1754">CALCITE-1754</a>]
+In Csv adapter, convert <code class="highlighter-rouge">DATE</code> and <code class="highlighter-rouge">TIME</code> values to <code class="highlighter-rouge">int</code>, and <code class="highlighter-rouge">TIMESTAMP</code> values to <code class="highlighter-rouge">long</code> (Hongbin Ma)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1751">CALCITE-1751</a>]
+<code class="highlighter-rouge">PigRelBuilderStyleTest</code> test cases are flapping</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1750">CALCITE-1750</a>]
+Fix unit test failures when the path to the repository contains spaces</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1724">CALCITE-1724</a>]
+Wrong comparison for floats/double type in Druid (Slim Bouguerra)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1734">CALCITE-1734</a>]
+Select query result not parsed correctly with druid 0.9.2 (Nishant Bangarwa)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1732">CALCITE-1732</a>]
+<code class="highlighter-rouge">IndexOutOfBoundsException</code> when using <code class="highlighter-rouge">LATERAL TABLE</code> with more than one field (Godfrey He)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1722">CALCITE-1722</a>]
+Druid adapter uses un-scaled value of <code class="highlighter-rouge">DECIMAL</code> literals (Slim Bouguerra)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1723">CALCITE-1723</a>]
+Match <code class="highlighter-rouge">DruidProjectFilterTransposeRule</code> against <code class="highlighter-rouge">DruidQuery</code> (Nishant Bangarwa)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1714">CALCITE-1714</a>]
+Do not push group by on druid metrics fields (Slim Bouguerra)</li>
+</ul>
+
+<h4 id="web-site-and-documentation">Web site and documentation</h4>
+
+<ul>
+ <li>Michael Mior joins PMC</li>
+ <li>Add 3 new committers (Zhiqiang-He, Kevin Liew, Slim Bouguerra)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1854">CALCITE-1854</a>]
+Fix value range of TINYINT in documentation (James Xu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1827">CALCITE-1827</a>]
+Document <code class="highlighter-rouge">TIMESTAMPADD</code>, <code class="highlighter-rouge">TIMESTAMPDIFF</code> functions (SunJincheng)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1796">CALCITE-1796</a>]
+Update materialized views documentation</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1566">CALCITE-1566</a>]
+Better documentation on the use of materialized views</li>
+</ul>
+
<h2 id="v1-12-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.12.0">1.12.0</a> / 2017-03-24</h2>
<p><a href="../news/2017/03/24/release-1.12.0">Features of note</a> this release are
@@ -137,7 +354,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">New features</h3>
+<h3 id="new-features-1">New features</h3>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1666">CALCITE-1666</a>]
@@ -227,7 +444,7 @@ Add numeric scalar functions (Laurent Go
JDK9</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-1716">CALCITE-1716</a>]
@@ -376,7 +593,7 @@ Correlated scalar sub-query with multipl
(Kurt Young)</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>Maryann Xue joins PMC</li>
@@ -446,7 +663,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-1">New features</h4>
+<h4 id="new-features-2">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1551">CALCITE-1551</a>]
@@ -524,7 +741,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-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-1559">CALCITE-1559</a>]
@@ -614,7 +831,7 @@ Druid type is called <code class="highli
Add sub-query support for RelStructuredTypeFlattener</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>Change PMC chair</li>
@@ -643,7 +860,7 @@ other software versions as specified in
Support operator <code class="highlighter-rouge">!=</code> as an alternative to <code class="highlighter-rouge"><></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-1378">CALCITE-1378</a>]
@@ -674,7 +891,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-2">Web site and documentation</h4>
+<h4 id="web-site-and-documentation-3">Web site and documentation</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1393">CALCITE-1393</a>]
@@ -711,7 +928,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-2">New features</h4>
+<h4 id="new-features-3">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1208">CALCITE-1208</a>]
@@ -758,7 +975,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-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-30">CALCITE-30</a>]
@@ -827,7 +1044,7 @@ In <code class="highlighter-rouge">SqlKi
Calcite generate wrong field names in JDBC adapter</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-1229">CALCITE-1229</a>]
@@ -868,7 +1085,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-1177">CALCITE-1177</a>]
@@ -925,7 +1142,7 @@ Add <code class="highlighter-rouge">Proj
substitution</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-1281">CALCITE-1281</a>]
@@ -1004,7 +1221,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-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-1273">CALCITE-1273</a>]
@@ -1065,7 +1282,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-4">New features</h4>
+<h4 id="new-features-5">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1124">CALCITE-1124</a>]
@@ -1109,7 +1326,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-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-1147">CALCITE-1147</a>]
@@ -1176,7 +1393,7 @@ Upgrade Jackson</li>
Clean up maven POM files</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-1112">CALCITE-1112</a>]
@@ -1232,7 +1449,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-5">New features</h4>
+<h4 id="new-features-6">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-816">CALCITE-816</a>]
@@ -1337,7 +1554,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-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-1060">CALCITE-1060</a>]
@@ -1419,7 +1636,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-6">Web site and documentation</h4>
+<h4 id="web-site-and-documentation-7">Web site and documentation</h4>
<ul>
<li>Avatica
@@ -1475,7 +1692,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-6">New features</h4>
+<h4 id="new-features-7">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-911">CALCITE-911</a>]
@@ -1638,7 +1855,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-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-948">CALCITE-948</a>]
@@ -1726,7 +1943,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-7">New features</h4>
+<h4 id="new-features-8">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-748">CALCITE-748</a>]
@@ -1762,7 +1979,7 @@ exclusions otherwise</li>
Web site</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-741">CALCITE-741</a>]
@@ -1913,7 +2130,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-8">New features</h4>
+<h4 id="new-features-9">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-505">CALCITE-505</a>]
@@ -2042,7 +2259,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-9">New features</h4>
+<h4 id="new-features-10">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-366">CALCITE-366</a>]
@@ -2185,7 +2402,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-10">New features</h4>
+<h4 id="new-features-11">New features</h4>
<ul>
<li>SQL
@@ -2311,7 +2528,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-11">New features</h4>
+<h4 id="new-features-12">New features</h4>
<ul>
<li>SQL
@@ -2573,7 +2790,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-12">New features</h4>
+<h4 id="new-features-13">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-436">CALCITE-436</a>]
@@ -2624,7 +2841,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-13">New features</h4>
+<h4 id="new-features-14">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-430">CALCITE-430</a>]
@@ -2781,7 +2998,7 @@ most recently.</li>
<p>This is the first release under the Apache incubator process.</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-371">CALCITE-371</a>]
@@ -2913,7 +3130,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-15">New features</h4>
+<h4 id="new-features-16">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-310">CALCITE-310</a>]
@@ -2994,7 +3211,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-16">New features</h4>
+<h4 id="new-features-17">New features</h4>
<ul>
<li>Implement table functions.</li>
@@ -3079,7 +3296,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-17">New features</h4>
+<h4 id="new-features-18">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-214">CALCITE-214</a>]
@@ -3204,7 +3421,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-18">New features</h4>
+<h4 id="new-features-19">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>
Modified: calcite/site/docs/howto.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/howto.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/docs/howto.html (original)
+++ calcite/site/docs/howto.html Mon Jun 26 09:42:55 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.12.0-source.tar.gz
-<span class="gp">$ </span><span class="nb">cd </span>calcite-1.12.0
+<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
<span class="gp">$ </span>mvn install</code></pre></figure>
<p><a href="#running-tests">Running tests</a> describes how to run more or fewer
Modified: calcite/site/docs/materialized_views.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/materialized_views.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/docs/materialized_views.html (original)
+++ calcite/site/docs/materialized_views.html Mon Jun 26 09:42:55 2017
@@ -108,55 +108,374 @@
<ul id="markdown-toc">
<li><a href="#materialized-views-maintained-by-calcite" id="markdown-toc-materialized-views-maintained-by-calcite">Materialized views maintained by Calcite</a></li>
- <li><a href="#expose-materialized-views-from-adapters" id="markdown-toc-expose-materialized-views-from-adapters">Expose materialized views from adapters</a></li>
- <li><a href="#view-based-query-rewriting" id="markdown-toc-view-based-query-rewriting">View-based query rewriting</a></li>
+ <li><a href="#expose-materialized-views-to-calcite" id="markdown-toc-expose-materialized-views-to-calcite">Expose materialized views to Calcite</a> <ul>
+ <li><a href="#view-based-query-rewriting" id="markdown-toc-view-based-query-rewriting">View-based query rewriting</a> <ul>
+ <li><a href="#substitution-via-rules-transformation" id="markdown-toc-substitution-via-rules-transformation">Substitution via rules transformation</a></li>
+ <li><a href="#rewriting-using-plan-structural-information" id="markdown-toc-rewriting-using-plan-structural-information">Rewriting using plan structural information</a> <ul>
+ <li><a href="#rewriting-coverage" id="markdown-toc-rewriting-coverage">Rewriting coverage</a> <ul>
+ <li><a href="#join-rewriting" id="markdown-toc-join-rewriting">Join rewriting</a></li>
+ <li><a href="#aggregate-rewriting" id="markdown-toc-aggregate-rewriting">Aggregate rewriting</a></li>
+ <li><a href="#aggregate-rewriting-with-aggregation-rollup" id="markdown-toc-aggregate-rewriting-with-aggregation-rollup">Aggregate rewriting (with aggregation rollup)</a></li>
+ <li><a href="#query-partial-rewriting" id="markdown-toc-query-partial-rewriting">Query partial rewriting</a></li>
+ <li><a href="#view-partial-rewriting" id="markdown-toc-view-partial-rewriting">View partial rewriting</a></li>
+ <li><a href="#union-rewriting" id="markdown-toc-union-rewriting">Union rewriting</a></li>
+ <li><a href="#union-rewriting-with-aggregate" id="markdown-toc-union-rewriting-with-aggregate">Union rewriting with aggregate</a></li>
+ </ul>
+ </li>
+ <li><a href="#limitations" id="markdown-toc-limitations">Limitations</a></li>
+ </ul>
+ </li>
+ </ul>
+ </li>
+ <li><a href="#references" id="markdown-toc-references">References</a></li>
+ </ul>
+ </li>
</ul>
<h2 id="materialized-views-maintained-by-calcite">Materialized views maintained by Calcite</h2>
<p>For details, see the <a href="/docs/lattice.html">lattices documentation</a>.</p>
-<h2 id="expose-materialized-views-from-adapters">Expose materialized views from adapters</h2>
+<h2 id="expose-materialized-views-to-calcite">Expose materialized views to Calcite</h2>
-<p>Some adapters have their own notion of materialized views.
-For example, Apache Cassandra allows the user to define materialized views based on existing tables which are automatically maintained.
-The Cassandra adapter automatically exposes these materialized views to Calcite.
-By understanding some tables as materialized views, Calcite has the opportunity to automatically rewrite queries to use these views.</p>
+<p>Some Calcite adapters as well as projects that rely on Calcite have their own notion of materialized views.</p>
-<h2 id="view-based-query-rewriting">View-based query rewriting</h2>
+<p>For example, Apache Cassandra allows the user to define materialized views based on existing tables which are automatically maintained.
+The Cassandra adapter automatically exposes these materialized views to Calcite.</p>
+
+<p>Another example is Apache Hive. When a materialized view is created in Hive, the user can specify whether the view may be used in query optimization. If the user chooses to do so, the materialized view will be registered with Calcite.</p>
+
+<p>By registering materialized views in Calcite, the optimizer has the opportunity to automatically rewrite queries to use these views.</p>
+
+<h3 id="view-based-query-rewriting">View-based query rewriting</h3>
<p>View-based query rewriting aims to take an input query which can be answered using a preexisting view and rewrite the query to make use of the view.
-Calcite employs two forms of view-based query rewriting.
-The first is based on view substitution before the planning phase based on an extension of a {SubstitutionVisitor}.
-{MaterializedViewSubstitutionVisitor} aims to substitute part of the relational algebra tree with an equivalent expression which makes use of a materialized view.</p>
+Currently Calcite has two implementations of view-based query rewriting.</p>
+
+<h4 id="substitution-via-rules-transformation">Substitution via rules transformation</h4>
-<p>The following example is taken from the documentation of {SubstitutionVisitor}:</p>
+<p>The first approach is based on view substitution.
+<code class="highlighter-rouge">SubstitutionVisitor</code> and its extension <code class="highlighter-rouge">MaterializedViewSubstitutionVisitor</code> aim to substitute part of the relational algebra tree with an equivalent expression which makes use of a materialized view. The scan over the materialized view and the materialized view definition plan are registered with the planner. Afterwards, transformation rules that try to unify expressions in the plan are triggered. Expressions do not need to be equivalent to be replaced: the visitor might add a residual predicate on top of the expression if needed.</p>
+
+<p>The following example is taken from the documentation of <code class="highlighter-rouge">SubstitutionVisitor</code>:</p>
<ul>
<li>Query: <code class="highlighter-rouge">SELECT a, c FROM t WHERE x = 5 AND b = 4</code></li>
<li>Target (materialized view definition): <code class="highlighter-rouge">SELECT a, b, c FROM t WHERE x = 5</code></li>
- <li>Replacement: <code class="highlighter-rouge">SELECT * FROM mv</code></li>
<li>Result: <code class="highlighter-rouge">SELECT a, c FROM mv WHERE b = 4</code></li>
</ul>
-<p>Note that {result} uses the materialized view table {mv} and a simplified condition {b = 4}.
-This can accomplish a large number of rewritings, but only those based on star schemas.
-This type of rewriting cannot be used for more complex views.
-{MaterializedViewJoinRule} attempts to match queries to views defined using arbitrary queries.
-The logic of the rule is based on <a href="http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.95.113">this paper</a>.</p>
+<p>Note that <code class="highlighter-rouge">result</code> uses the materialized view table <code class="highlighter-rouge">mv</code> and a simplified condition <code class="highlighter-rouge">b = 4</code>.</p>
+
+<p>While this approach can accomplish a large number of rewritings, it has some limitations. Since the rule relies on transformation rules to create the equivalence between expressions in the query and the materialized view, it might need to enumerate exhaustively all possible equivalent rewritings for a given expression to find a materialized view substitution. However, this is not scalable in the presence of complex
+views, e.g., views with an arbitrary number of join operators.</p>
+
+<h4 id="rewriting-using-plan-structural-information">Rewriting using plan structural information</h4>
+
+<p>In turn, an alternative rule that attempts to match queries to views by extracting some structural information about the expression to replace has been proposed.</p>
+
+<p><code class="highlighter-rouge">AbstractMaterializedViewRule</code> builds on the ideas presented in [<a href="#ref-gl01">GL01</a>] and introduces some additional extensions.
+The rule can rewrite expressions containing arbitrary chains of Join, Filter, and Project operators.
+Additionally, the rule can rewrite expressions rooted at an Aggregate operator, rolling aggregations up if necessary. In turn, it can also produce rewritings using Union operators if the query can be partially answered from a view.</p>
+
+<p>To produce a larger number of rewritings, the rule relies on information exposed as constraints defined over the database tables, e.g., <em>foreign keys</em>, <em>primary keys</em>, <em>unique keys</em> or <em>not null</em>.</p>
+
+<h5 id="rewriting-coverage">Rewriting coverage</h5>
+
+<p>Let us illustrate with some examples the coverage of the view rewriting algorithm implemented in <code class="highlighter-rouge">AbstractMaterializedViewRule</code>. The examples are based on the following database schema.</p>
+
+<p><code class="highlighter-rouge">SQL
+CREATE TABLE depts(
+ deptno INT NOT NULL,
+ deptname VARCHAR(20),
+ PRIMARY KEY (deptno)
+);
+CREATE TABLE locations(
+ locationid INT NOT NULL,
+ state CHAR(2),
+ PRIMARY KEY (locationid)
+);
+CREATE TABLE emps(
+ empid INT NOT NULL,
+ deptno INT NOT NULL,
+ locationid INT NOT NULL,
+ empname VARCHAR(20) NOT NULL,
+ salary DECIMAL (18, 2),
+ PRIMARY KEY (empid),
+ FOREIGN KEY (deptno) REFERENCES depts(deptno),
+ FOREIGN KEY (locationid) REFERENCES locations(locationid)
+);
+</code></p>
+
+<h6 id="join-rewriting">Join rewriting</h6>
+
+<p>The rewriting can handle different join orders in the query and the view definition. In addition, the rule tries to detect when a compensation predicate could be used to produce a rewriting using a view.</p>
+
+<ul>
+ <li>Query:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid
+FROM depts
+JOIN (
+ SELECT empid, deptno
+ FROM emps
+ WHERE empid = 1) subq
+ON (depts.deptno = subq.deptno)
+</code></p>
+
+<ul>
+ <li>Materialized view definition:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid
+FROM emps
+JOIN depts USING (deptno)
+</code></p>
+
+<ul>
+ <li>Rewriting:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid
+FROM mv
+WHERE empid = 1
+</code></p>
+
+<h6 id="aggregate-rewriting">Aggregate rewriting</h6>
+
+<ul>
+ <li>Query:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT deptno
+FROM emps
+WHERE deptno > 10
+GROUP BY deptno
+</code></p>
+
+<ul>
+ <li>Materialized view definition:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid, deptno
+FROM emps
+WHERE deptno > 5
+GROUP BY empid, deptno
+</code></p>
+
+<ul>
+ <li>Rewriting:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT deptno
+FROM mv
+WHERE deptno > 10
+GROUP BY deptno
+</code></p>
+
+<h6 id="aggregate-rewriting-with-aggregation-rollup">Aggregate rewriting (with aggregation rollup)</h6>
+
+<ul>
+ <li>Query:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT deptno, COUNT(*) AS c, SUM(salary) AS s
+FROM emps
+GROUP BY deptno
+</code></p>
-<p>There are several limitations to the current implementation:</p>
+<ul>
+ <li>Materialized view definition:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid, deptno, COUNT(*) AS c, SUM(salary) AS s
+FROM emps
+GROUP BY empid, deptno
+</code></p>
<ul>
- <li>The query defining the view must use only inner joins</li>
- <li>Only equality predicates are supported</li>
- <li>Predicates on tables used in the view must exactly match predicates in the query</li>
- <li>Rewriting is unoptimized and will attempt to match all views against each query</li>
+ <li>Rewriting:</li>
</ul>
-<p>These limitations are not fundamental the approach however and will hopefully be removed in the future.
-Note that the rule is currently disabled by default.
-To make use of the rule, {MaterializedViewJoinRule.INSTANCE_PROJECT} and {MaterializedViewJoinRule.INSTANCE_TABLE_SCAN} need to be added to the planner.</p>
+<p><code class="highlighter-rouge">SQL
+SELECT deptno, SUM(c), SUM(s)
+FROM mv
+GROUP BY deptno
+</code></p>
+
+<h6 id="query-partial-rewriting">Query partial rewriting</h6>
+
+<p>Through the declared constraints, the rule can detect joins that only append columns without altering the tuples multiplicity and produce correct rewritings.</p>
+
+<ul>
+ <li>Query:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT deptno, COUNT(*)
+FROM emps
+GROUP BY deptno
+</code></p>
+
+<ul>
+ <li>Materialized view definition:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid, depts.deptno, COUNT(*) AS c, SUM(salary) AS s
+FROM emps
+JOIN depts USING (deptno)
+GROUP BY empid, depts.deptno
+</code></p>
+
+<ul>
+ <li>Rewriting:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT deptno, SUM(c)
+FROM mv
+GROUP BY deptno
+</code></p>
+
+<h6 id="view-partial-rewriting">View partial rewriting</h6>
+
+<ul>
+ <li>Query:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT deptname, state, SUM(salary) AS s
+FROM emps
+JOIN depts ON (emps.deptno = depts.deptno)
+JOIN locations ON (emps.locationid = locations.locationid)
+GROUP BY deptname, state
+</code></p>
+
+<ul>
+ <li>Materialized view definition:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid, deptno, state, SUM(salary) AS s
+FROM emps
+JOIN locations ON (emps.locationid = locations.locationid)
+GROUP BY empid, deptno, state
+</code></p>
+
+<ul>
+ <li>Rewriting:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT deptname, state, SUM(s)
+FROM mv
+JOIN depts ON (mv.deptno = depts.deptno)
+GROUP BY deptname, state
+</code></p>
+
+<h6 id="union-rewriting">Union rewriting</h6>
+
+<ul>
+ <li>Query:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid, deptname
+FROM emps
+JOIN depts ON (emps.deptno = depts.deptno)
+WHERE salary > 10000
+</code></p>
+
+<ul>
+ <li>Materialized view definition:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid, deptname
+FROM emps
+JOIN depts ON (emps.deptno = depts.deptno)
+WHERE salary > 12000
+</code></p>
+
+<ul>
+ <li>Rewriting:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid, deptname
+FROM mv
+UNION ALL
+SELECT empid, deptname
+FROM emps
+JOIN depts ON (emps.deptno = depts.deptno)
+WHERE salary > 10000 AND salary <= 12000
+</code></p>
+
+<h6 id="union-rewriting-with-aggregate">Union rewriting with aggregate</h6>
+
+<ul>
+ <li>Query:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid, deptname, SUM(salary) AS s
+FROM emps
+JOIN depts ON (emps.deptno = depts.deptno)
+WHERE salary > 10000
+GROUP BY empid, deptname
+</code></p>
+
+<ul>
+ <li>Materialized view definition:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid, deptname, SUM(salary) AS s
+FROM emps
+JOIN depts ON (emps.deptno = depts.deptno)
+WHERE salary > 12000
+GROUP BY empid, deptname
+</code></p>
+
+<ul>
+ <li>Rewriting:</li>
+</ul>
+
+<p><code class="highlighter-rouge">SQL
+SELECT empid, deptname, SUM(s)
+FROM (
+SELECT empid, deptname, s
+FROM mv
+UNION ALL
+SELECT empid, deptname, SUM(salary) AS s
+FROM emps
+JOIN depts ON (emps.deptno = depts.deptno)
+WHERE salary > 10000 AND salary <= 12000
+GROUP BY empid, deptname) subq
+GROUP BY empid, deptname
+</code></p>
+
+<h5 id="limitations">Limitations</h5>
+
+<p>This rule still presents some limitations. In particular, the rewriting rule attempts to match all views against each query. We plan to implement more refined filtering techniques such as those described in [<a href="#ref-gl01">GL01</a>].</p>
+
+<h3 id="references">References</h3>
+
+<ul>
+<li>[<a name="ref-gl01">GL01</a>] Jonathan Goldstein and Per-Ã¥ke Larson.
+ <a href="http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.95.113">Optimizing queries using materialized views: A practical, scalable solution</a>.
+ In <i>Proc. ACM SIGMOD Conf.</i>, 2001.</li>
+</ul>
Modified: calcite/site/docs/reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/reference.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/docs/reference.html (original)
+++ calcite/site/docs/reference.html Mon Jun 26 09:42:55 2017
@@ -104,6 +104,61 @@
-->
+<style>
+.container {
+ width: 400px;
+ height: 26px;
+}
+.gray {
+ width: 60px;
+ height: 26px;
+ background: gray;
+ float: left;
+}
+.r15 {
+ width: 40px;
+ height: 6px;
+ background: yellow;
+ margin-top: 4px;
+ margin-left: 10px;
+}
+.r12 {
+ width: 10px;
+ height: 6px;
+ background: yellow;
+ margin-top: 4px;
+ margin-left: 10px;
+}
+.r13 {
+ width: 20px;
+ height: 6px;
+ background: yellow;
+ margin-top: 4px;
+ margin-left: 10px;
+}
+.r2 {
+ width: 2px;
+ height: 6px;
+ background: yellow;
+ margin-top: 4px;
+ margin-left: 20px;
+}
+.r24 {
+ width: 20px;
+ height: 6px;
+ background: yellow;
+ margin-top: 4px;
+ margin-left: 20px;
+}
+.r35 {
+ width: 20px;
+ height: 6px;
+ background: yellow;
+ margin-top: 4px;
+ margin-left: 30px;
+}
+</style>
+
<p>The page describes the SQL dialect recognized by Calciteâs default SQL parser.</p>
<h2 id="grammar">Grammar</h2>
@@ -322,6 +377,7 @@ ALWAYS,
APPLY,
<strong>ARE</strong>,
<strong>ARRAY</strong>,
+<strong>ARRAY_MAX_CARDINALITY</strong>,
<strong>AS</strong>,
ASC,
<strong>ASENSITIVE</strong>,
@@ -336,6 +392,8 @@ ATTRIBUTES,
<strong>AVG</strong>,
BEFORE,
<strong>BEGIN</strong>,
+<strong>BEGIN_FRAME</strong>,
+<strong>BEGIN_PARTITION</strong>,
BERNOULLI,
<strong>BETWEEN</strong>,
<strong>BIGINT</strong>,
@@ -370,6 +428,7 @@ CHARACTER_SET_NAME,
CHARACTER_SET_SCHEMA,
<strong>CHAR_LENGTH</strong>,
<strong>CHECK</strong>,
+<strong>CLASSIFIER</strong>,
CLASS_ORIGIN,
<strong>CLOB</strong>,
<strong>CLOSE</strong>,
@@ -398,7 +457,7 @@ CONSTRAINT_CATALOG,
CONSTRAINT_NAME,
CONSTRAINT_SCHEMA,
CONSTRUCTOR,
-CONTAINS,
+<strong>CONTAINS</strong>,
CONTINUE,
<strong>CONVERT</strong>,
<strong>CORR</strong>,
@@ -416,6 +475,7 @@ CONTINUE,
<strong>CURRENT_DEFAULT_TRANSFORM_GROUP</strong>,
<strong>CURRENT_PATH</strong>,
<strong>CURRENT_ROLE</strong>,
+<strong>CURRENT_ROW</strong>,
<strong>CURRENT_SCHEMA</strong>,
<strong>CURRENT_TIME</strong>,
<strong>CURRENT_TIMESTAMP</strong>,
@@ -469,10 +529,13 @@ DYNAMIC_FUNCTION_CODE,
<strong>EACH</strong>,
<strong>ELEMENT</strong>,
<strong>ELSE</strong>,
+<strong>EMPTY</strong>,
<strong>END</strong>,
<strong>END-EXEC</strong>,
+<strong>END_FRAME</strong>,
+<strong>END_PARTITION</strong>,
EPOCH,
-EQUALS,
+<strong>EQUALS</strong>,
<strong>ESCAPE</strong>,
<strong>EVERY</strong>,
<strong>EXCEPT</strong>,
@@ -501,6 +564,7 @@ FOLLOWING,
FORTRAN,
FOUND,
FRAC_SECOND,
+<strong>FRAME_ROW</strong>,
<strong>FREE</strong>,
<strong>FROM</strong>,
<strong>FULL</strong>,
@@ -517,18 +581,21 @@ GOTO,
GRANTED,
<strong>GROUP</strong>,
<strong>GROUPING</strong>,
+<strong>GROUPS</strong>,
<strong>HAVING</strong>,
HIERARCHY,
<strong>HOLD</strong>,
<strong>HOUR</strong>,
<strong>IDENTITY</strong>,
IMMEDIATE,
+IMMEDIATELY,
IMPLEMENTATION,
<strong>IMPORT</strong>,
<strong>IN</strong>,
INCLUDING,
INCREMENT,
<strong>INDICATOR</strong>,
+<strong>INITIAL</strong>,
INITIALLY,
<strong>INNER</strong>,
<strong>INOUT</strong>,
@@ -554,17 +621,20 @@ KEY,
KEY_MEMBER,
KEY_TYPE,
LABEL,
+<strong>LAG</strong>,
<strong>LANGUAGE</strong>,
<strong>LARGE</strong>,
LAST,
<strong>LAST_VALUE</strong>,
<strong>LATERAL</strong>,
+<strong>LEAD</strong>,
<strong>LEADING</strong>,
<strong>LEFT</strong>,
LENGTH,
LEVEL,
LIBRARY,
<strong>LIKE</strong>,
+<strong>LIKE_REGEX</strong>,
<strong>LIMIT</strong>,
<strong>LN</strong>,
<strong>LOCAL</strong>,
@@ -576,6 +646,8 @@ M,
MAP,
<strong>MATCH</strong>,
MATCHED,
+<strong>MATCHES</strong>,
+<strong>MATCH_NUMBER</strong>,
<strong>MATCH_RECOGNIZE</strong>,
<strong>MAX</strong>,
MAXVALUE,
@@ -613,6 +685,8 @@ NESTING,
<strong>NORMALIZE</strong>,
NORMALIZED,
<strong>NOT</strong>,
+<strong>NTH_VALUE</strong>,
+<strong>NTILE</strong>,
<strong>NULL</strong>,
NULLABLE,
<strong>NULLIF</strong>,
@@ -620,12 +694,15 @@ NULLS,
NUMBER,
<strong>NUMERIC</strong>,
OBJECT,
+<strong>OCCURRENCES_REGEX</strong>,
OCTETS,
<strong>OCTET_LENGTH</strong>,
<strong>OF</strong>,
<strong>OFFSET</strong>,
<strong>OLD</strong>,
+<strong>OMIT</strong>,
<strong>ON</strong>,
+<strong>ONE</strong>,
<strong>ONLY</strong>,
<strong>OPEN</strong>,
OPTION,
@@ -654,17 +731,24 @@ PARTIAL,
<strong>PARTITION</strong>,
PASCAL,
PASSTHROUGH,
+PAST,
PATH,
<strong>PATTERN</strong>,
+<strong>PER</strong>,
+<strong>PERCENT</strong>,
<strong>PERCENTILE_CONT</strong>,
<strong>PERCENTILE_DISC</strong>,
<strong>PERCENT_RANK</strong>,
+<strong>PERIOD</strong>,
<strong>PERMUTE</strong>,
PLACING,
PLAN,
PLI,
+<strong>PORTION</strong>,
<strong>POSITION</strong>,
+<strong>POSITION_REGEX</strong>,
<strong>POWER</strong>,
+<strong>PRECEDES</strong>,
PRECEDING,
<strong>PRECISION</strong>,
<strong>PREPARE</strong>,
@@ -735,6 +819,7 @@ SCOPE_SCHEMA,
<strong>SECOND</strong>,
SECTION,
SECURITY,
+<strong>SEEK</strong>,
<strong>SELECT</strong>,
SELF,
<strong>SENSITIVE</strong>,
@@ -746,9 +831,11 @@ SESSION,
<strong>SESSION_USER</strong>,
<strong>SET</strong>,
SETS,
+<strong>SHOW</strong>,
<strong>SIMILAR</strong>,
SIMPLE,
SIZE,
+<strong>SKIP</strong>,
<strong>SMALLINT</strong>,
<strong>SOME</strong>,
SOURCE,
@@ -821,11 +908,15 @@ STRUCTURE,
STYLE,
SUBCLASS_ORIGIN,
<strong>SUBMULTISET</strong>,
+<strong>SUBSET</strong>,
SUBSTITUTE,
<strong>SUBSTRING</strong>,
+<strong>SUBSTRING_REGEX</strong>,
+<strong>SUCCEEDS</strong>,
<strong>SUM</strong>,
<strong>SYMMETRIC</strong>,
<strong>SYSTEM</strong>,
+<strong>SYSTEM_TIME</strong>,
<strong>SYSTEM_USER</strong>,
<strong>TABLE</strong>,
<strong>TABLESAMPLE</strong>,
@@ -850,6 +941,7 @@ TRANSACTIONS_ROLLED_BACK,
TRANSFORM,
TRANSFORMS,
<strong>TRANSLATE</strong>,
+<strong>TRANSLATE_REGEX</strong>,
<strong>TRANSLATION</strong>,
<strong>TREAT</strong>,
<strong>TRIGGER</strong>,
@@ -857,7 +949,9 @@ TRIGGER_CATALOG,
TRIGGER_NAME,
TRIGGER_SCHEMA,
<strong>TRIM</strong>,
+<strong>TRIM_ARRAY</strong>,
<strong>TRUE</strong>,
+<strong>TRUNCATE</strong>,
TYPE,
<strong>UESCAPE</strong>,
UNBOUNDED,
@@ -880,12 +974,14 @@ USER_DEFINED_TYPE_SCHEMA,
<strong>USING</strong>,
<strong>VALUE</strong>,
<strong>VALUES</strong>,
+<strong>VALUE_OF</strong>,
<strong>VARBINARY</strong>,
<strong>VARCHAR</strong>,
<strong>VARYING</strong>,
<strong>VAR_POP</strong>,
<strong>VAR_SAMP</strong>,
VERSION,
+<strong>VERSIONING</strong>,
VIEW,
WEEK,
<strong>WHEN</strong>,
@@ -945,7 +1041,7 @@ name will have been converted to upper c
<tr>
<td style="text-align: left">TINYINT</td>
<td style="text-align: left">1 byte signed integer</td>
- <td style="text-align: left">Range is -255 to 256</td>
+ <td style="text-align: left">Range is -128 to 127</td>
</tr>
<tr>
<td style="text-align: left">SMALLINT</td>
@@ -1027,11 +1123,6 @@ name will have been converted to upper c
<td style="text-align: left">Date time interval</td>
<td style="text-align: left">Examples: INTERVAL â1:5â YEAR TO MONTH, INTERVAL â45â DAY</td>
</tr>
- <tr>
- <td style="text-align: left">Anchored interval</td>
- <td style="text-align: left">Date time interval</td>
- <td style="text-align: left">Example: (DATE â1969-07-20â, DATE â1972-08-29â)</td>
- </tr>
</tbody>
</table>
@@ -1120,7 +1211,7 @@ the user or application to supply a time
<td style="text-align: left">left</td>
</tr>
<tr>
- <td style="text-align: left">BETWEEN, IN, LIKE, SIMILAR</td>
+ <td style="text-align: left">BETWEEN, IN, LIKE, SIMILAR, OVERLAPS, CONTAINS etc.</td>
<td style="text-align: left">-</td>
</tr>
<tr>
@@ -1627,24 +1718,31 @@ the user or application to supply a time
<td style="text-align: left">SECOND(date)</td>
<td style="text-align: left">Equivalent to <code class="highlighter-rouge">EXTRACT(SECOND FROM date)</code>. Returns an integer between 0 and 59.</td>
</tr>
+ <tr>
+ <td style="text-align: left">TIMESTAMPADD(timeUnit, integer, datetime)</td>
+ <td style="text-align: left">Returns <em>datetime</em> with an interval of (signed) <em>integer</em> <em>timeUnit</em>s added. Equivalent to <code class="highlighter-rouge">datetime + INTERVAL 'integer' timeUnit</code></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">TIMESTAMPDIFF(timeUnit, datetime, datetime2)</td>
+ <td style="text-align: left">Returns the (signed) number of <em>timeUnit</em> intervals between <em>datetime</em> and <em>datetime2</em>. Equivalent to <code class="highlighter-rouge">(datetime2 - datetime) timeUnit</code></td>
+ </tr>
</tbody>
</table>
+<p>Calls to niladic functions such as <code class="highlighter-rouge">CURRENT_DATE</code> do not accept parentheses in
+standard SQL. Calls with parentheses, such as <code class="highlighter-rouge">CURRENT_DATE()</code> are accepted in certain
+<a href="/apidocs/org/apache/calcite/sql/validate/SqlConformance.html#allowNiladicParentheses--">conformance levels</a>.</p>
+
<p>Not implemented:</p>
<ul>
- <li>EXTRACT(timeUnit FROM interval)</li>
<li>CEIL(interval)</li>
<li>FLOOR(interval)</li>
- <li>datetime - datetime timeUnit [ TO timeUnit ]</li>
- <li>interval OVERLAPS interval</li>
<li>+ interval</li>
<li>- interval</li>
<li>interval + interval</li>
<li>interval - interval</li>
<li>interval / interval</li>
- <li>datetime + interval</li>
- <li>datetime - interval</li>
</ul>
<h3 id="system-functions">System functions</h3>
@@ -1790,6 +1888,100 @@ the user or application to supply a time
<p>See also: UNNEST relational operator converts a collection to a relation.</p>
+<h3 id="period-predicates">Period predicates</h3>
+
+<table>
+ <tr>
+ <th>Operator syntax</th>
+ <th>Description</th>
+ </tr>
+ <tr>
+ <td>period1 CONTAINS dateTime</td>
+ <td>
+ <div class="container">
+ <div class="gray"><div class="r15"></div><div class="r2"></div></div>
+ </div>
+ </td>
+ </tr>
+ <tr>
+ <td>period1 CONTAINS period2</td>
+ <td>
+ <div class="container">
+ <div class="gray"><div class="r15"></div><div class="r24"></div></div>
+ <div class="gray"><div class="r15"></div><div class="r13"></div></div>
+ <div class="gray"><div class="r15"></div><div class="r35"></div></div>
+ <div class="gray"><div class="r15"></div><div class="r15"></div></div>
+ </div>
+ </td>
+ </tr>
+ <tr>
+ <td>period1 OVERLAPS period2</td>
+ <td>
+ <div class="container">
+ <div class="gray"><div class="r15"></div><div class="r24"></div></div>
+ <div class="gray"><div class="r15"></div><div class="r13"></div></div>
+ <div class="gray"><div class="r15"></div><div class="r35"></div></div>
+ <div class="gray"><div class="r15"></div><div class="r15"></div></div>
+ <div class="gray"><div class="r24"></div><div class="r15"></div></div>
+ <div class="gray"><div class="r13"></div><div class="r15"></div></div>
+ <div class="gray"><div class="r35"></div><div class="r15"></div></div>
+ <div class="gray"><div class="r24"></div><div class="r13"></div></div>
+ <div class="gray"><div class="r13"></div><div class="r24"></div></div>
+ </div>
+ </td>
+ </tr>
+ <tr>
+ <td>period1 EQUALS period2</td>
+ <td>
+ <div class="container">
+ <div class="gray"><div class="r15"></div><div class="r15"></div></div>
+ </div>
+ </td>
+ </tr>
+ <tr>
+ <td>period1 PRECEDES period2</td>
+ <td>
+ <div class="container">
+ <div class="gray"><div class="r12"></div><div class="r35"></div></div>
+ <div class="gray"><div class="r13"></div><div class="r35"></div></div>
+ </div>
+ </td>
+ </tr>
+ <tr>
+ <td>period1 IMMEDIATELY PRECEDES period2</td>
+ <td>
+ <div class="container">
+ <div class="gray"><div class="r13"></div><div class="r35"></div></div>
+ </div>
+ </td>
+ </tr>
+ <tr>
+ <td>period1 SUCCEEDS period2</td>
+ <td>
+ <div class="container">
+ <div class="gray"><div class="r35"></div><div class="r12"></div></div>
+ <div class="gray"><div class="r35"></div><div class="r13"></div></div>
+ </div>
+ </td>
+ </tr>
+ <tr>
+ <td>period1 IMMEDIATELY SUCCEEDS period2</td>
+ <td>
+ <div class="container">
+ <div class="gray"><div class="r35"></div><div class="r13"></div></div>
+ </div>
+ </td>
+ </tr>
+</table>
+
+<p>Where <em>period1</em> and <em>period2</em> are period expressions:</p>
+
+<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="n">period</span><span class="p">:</span>
+ <span class="p">(</span><span class="n">dateTime</span><span class="p">,</span> <span class="n">dateTime</span><span class="p">)</span>
+ <span class="o">|</span> <span class="p">(</span><span class="n">dateTime</span><span class="p">,</span> <span class="n">interval</span><span class="p">)</span>
+ <span class="o">|</span> <span class="n">PERIOD</span> <span class="p">(</span><span class="n">dateTime</span><span class="p">,</span> <span class="n">dateTime</span><span class="p">)</span>
+ <span class="o">|</span> <span class="n">PERIOD</span> <span class="p">(</span><span class="n">dateTime</span><span class="p">,</span> <span class="n">interval</span><span class="p">)</span></code></pre></figure>
+
<h3 id="jdbc-function-escape">JDBC function escape</h3>
<h4 id="numeric">Numeric</h4>
@@ -2508,7 +2700,7 @@ events in complex event processing (CEP)
<span class="p">[</span> <span class="n">PARTITION</span> <span class="k">BY</span> <span class="n">expression</span> <span class="p">[,</span> <span class="n">expression</span> <span class="p">]</span><span class="o">*</span> <span class="p">]</span>
<span class="p">[</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="n">orderItem</span> <span class="p">[,</span> <span class="n">orderItem</span> <span class="p">]</span><span class="o">*</span> <span class="p">]</span>
<span class="p">[</span> <span class="n">MEASURES</span> <span class="n">measureColumn</span> <span class="p">[,</span> <span class="n">measureColumn</span> <span class="p">]</span><span class="o">*</span> <span class="p">]</span>
- <span class="p">[</span> <span class="k">ON</span> <span class="k">ROW</span> <span class="n">PER</span> <span class="k">MATCH</span> <span class="o">|</span> <span class="k">ALL</span> <span class="k">ROWS</span> <span class="n">PER</span> <span class="k">MATCH</span> <span class="p">]</span>
+ <span class="p">[</span> <span class="n">ONE</span> <span class="k">ROW</span> <span class="n">PER</span> <span class="k">MATCH</span> <span class="o">|</span> <span class="k">ALL</span> <span class="k">ROWS</span> <span class="n">PER</span> <span class="k">MATCH</span> <span class="p">]</span>
<span class="p">[</span> <span class="k">AFTER</span> <span class="k">MATCH</span>
<span class="p">(</span> <span class="n">SKIP</span> <span class="k">TO</span> <span class="k">NEXT</span> <span class="k">ROW</span>
<span class="o">|</span> <span class="n">SKIP</span> <span class="n">PAST</span> <span class="k">LAST</span> <span class="k">ROW</span>
@@ -2517,10 +2709,13 @@ events in complex event processing (CEP)
<span class="o">|</span> <span class="n">SKIP</span> <span class="k">TO</span> <span class="k">variable</span> <span class="p">)</span>
<span class="p">]</span>
<span class="n">PATTERN</span> <span class="s1">'('</span> <span class="n">pattern</span> <span class="s1">')'</span>
- <span class="p">[</span> <span class="n">SUBSET</span> <span class="k">variable</span> <span class="p">[,</span> <span class="k">variable</span> <span class="p">]</span><span class="o">*</span> <span class="p">]</span>
+ <span class="p">[</span> <span class="n">SUBSET</span> <span class="n">subsetItem</span> <span class="p">[,</span> <span class="n">subsetItem</span> <span class="p">]</span><span class="o">*</span> <span class="p">]</span>
<span class="n">DEFINE</span> <span class="k">variable</span> <span class="k">AS</span> <span class="n">condition</span> <span class="p">[,</span> <span class="k">variable</span> <span class="k">AS</span> <span class="n">condition</span> <span class="p">]</span><span class="o">*</span>
<span class="s1">')'</span>
+<span class="n">subsetItem</span><span class="p">:</span>
+ <span class="k">variable</span> <span class="o">=</span> <span class="s1">'('</span> <span class="k">variable</span> <span class="p">[,</span> <span class="k">variable</span> <span class="p">]</span><span class="o">*</span> <span class="s1">')'</span>
+
<span class="n">measureColumn</span><span class="p">:</span>
<span class="n">expression</span> <span class="k">AS</span> <span class="k">alias</span>
@@ -2554,17 +2749,6 @@ events in complex event processing (CEP)
<p>In <em>patternQuantifier</em>, <em>repeat</em> is a positive integer,
and <em>minRepeat</em> and <em>maxRepeat</em> are non-negative integers.</p>
-<p>The following clauses are not implemented:</p>
-
-<ul>
- <li><code class="highlighter-rouge">PARTITION BY</code></li>
- <li><code class="highlighter-rouge">ORDER BY</code></li>
- <li><code class="highlighter-rouge">MEASURES</code></li>
- <li><code class="highlighter-rouge">ON ROW PER MATCH</code>, <code class="highlighter-rouge">ALL ROWS PER MATCH</code></li>
- <li><code class="highlighter-rouge">AFTER MATCH</code></li>
- <li><code class="highlighter-rouge">SUBSET</code></li>
-</ul>
-
Modified: calcite/site/downloads/index.html
URL: http://svn.apache.org/viewvc/calcite/site/downloads/index.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/downloads/index.html (original)
+++ calcite/site/downloads/index.html Mon Jun 26 09:42:55 2017
@@ -101,10 +101,16 @@
</thead>
<tbody>
<tr>
+ <td style="text-align: left"><a href="/docs/history.html#v1-13-0">1.13.0</a></td>
+ <td style="text-align: left">26 Jun 2017</td>
+ <td style="text-align: left"><a href="https://github.com/apache/calcite/commit/54b9823">54b9823</a></td>
+ <td style="text-align: left"><a href="http://www.apache.org/dyn/closer.lua?filename=calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.tar.gz&action=download">tar</a> (<a href="https://www.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.tar.gz.mds">digest</a> <a href="https://www.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://www.apache.org/dyn/closer.lua?filename=calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.zip&action=download">zip</a> (<a href="https://www.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.zip.mds">digest</a> <a href="https://www.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.zip.asc">pgp</a>)</td>
+ </tr>
+ <tr>
<td style="text-align: left"><a href="/docs/history.html#v1-12-0">1.12.0</a></td>
<td style="text-align: left">24 Mar 2017</td>
<td style="text-align: left"><a href="https://github.com/apache/calcite/commit/ea7ace1">ea7ace1</a></td>
- <td style="text-align: left"><a href="http://www.apache.org/dyn/closer.lua?filename=calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz&action=download">tar</a> (<a href="https://www.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz.mds">digest</a> <a href="https://www.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://www.apache.org/dyn/closer.lua?filename=calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip&action=download">zip</a> (<a href="https://www.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip.mds">digest</a> <a href="https://www.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip.asc">pgp</a>)</td>
+ <td style="text-align: left"><a href="http://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz">tar</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz.mds">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip">zip</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip.mds">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip.asc">pgp</a>)</td>
</tr>
<tr>
<td style="text-align: left"><a href="/docs/history.html#v1-11-0">1.11.0</a></td>
@@ -230,7 +236,7 @@ succeed.</p>
<span class="nt"><dependency></span>
<span class="nt"><groupId></span>org.apache.calcite<span class="nt"></groupId></span>
<span class="nt"><artifactId></span>calcite-core<span class="nt"></artifactId></span>
- <span class="nt"><version></span>1.12.0<span class="nt"></version></span>
+ <span class="nt"><version></span>1.13.0<span class="nt"></version></span>
<span class="nt"></dependency></span>
<span class="nt"></dependencies></span></code></pre></figure>
Modified: calcite/site/img/powered-by.png
URL: http://svn.apache.org/viewvc/calcite/site/img/powered-by.png?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
Binary files - no diff available.
Modified: calcite/site/news/2014/06/27/release-0.8.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2014/06/27/release-0.8.0-incubating/index.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/news/2014/06/27/release-0.8.0-incubating/index.html (original)
+++ calcite/site/news/2014/06/27/release-0.8.0-incubating/index.html Mon Jun 26 09:42:55 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
<option value="/news/2016/10/12/release-1.10.0/">Release 1.10.0</option>
@@ -173,6 +174,10 @@ new utility, <code class="highlighter-ro
<ul>
<li class="">
+ <a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/03/24/release-1.12.0/">1.12.0</a>
</li>
@@ -188,10 +193,6 @@ new utility, <code class="highlighter-ro
<a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
</li>
- <li class="">
- <a href="/news/2016/06/13/release-1.8.0/">1.8.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2014/08/19/release-0.9.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2014/08/19/release-0.9.0-incubating/index.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/news/2014/08/19/release-0.9.0-incubating/index.html (original)
+++ calcite/site/news/2014/08/19/release-0.9.0-incubating/index.html Mon Jun 26 09:42:55 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
<option value="/news/2016/10/12/release-1.10.0/">Release 1.10.0</option>
@@ -171,6 +172,10 @@
<ul>
<li class="">
+ <a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/03/24/release-1.12.0/">1.12.0</a>
</li>
@@ -186,10 +191,6 @@
<a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
</li>
- <li class="">
- <a href="/news/2016/06/13/release-1.8.0/">1.8.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2014/10/02/release-0.9.1-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2014/10/02/release-0.9.1-incubating/index.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/news/2014/10/02/release-0.9.1-incubating/index.html (original)
+++ calcite/site/news/2014/10/02/release-0.9.1-incubating/index.html Mon Jun 26 09:42:55 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
<option value="/news/2016/10/12/release-1.10.0/">Release 1.10.0</option>
@@ -171,6 +172,10 @@
<ul>
<li class="">
+ <a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/03/24/release-1.12.0/">1.12.0</a>
</li>
@@ -186,10 +191,6 @@
<a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
</li>
- <li class="">
- <a href="/news/2016/06/13/release-1.8.0/">1.8.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2014/11/05/release-0.9.2-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2014/11/05/release-0.9.2-incubating/index.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/news/2014/11/05/release-0.9.2-incubating/index.html (original)
+++ calcite/site/news/2014/11/05/release-0.9.2-incubating/index.html Mon Jun 26 09:42:55 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
<option value="/news/2016/10/12/release-1.10.0/">Release 1.10.0</option>
@@ -174,6 +175,10 @@ before you move on to 1.0.</p>
<ul>
<li class="">
+ <a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/03/24/release-1.12.0/">1.12.0</a>
</li>
@@ -189,10 +194,6 @@ before you move on to 1.0.</p>
<a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
</li>
- <li class="">
- <a href="/news/2016/06/13/release-1.8.0/">1.8.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/01/31/release-1.0.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/01/31/release-1.0.0-incubating/index.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/news/2015/01/31/release-1.0.0-incubating/index.html (original)
+++ calcite/site/news/2015/01/31/release-1.0.0-incubating/index.html Mon Jun 26 09:42:55 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
<option value="/news/2016/10/12/release-1.10.0/">Release 1.10.0</option>
@@ -184,6 +185,10 @@ and fixes about 30 bugs.</p>
<ul>
<li class="">
+ <a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/03/24/release-1.12.0/">1.12.0</a>
</li>
@@ -199,10 +204,6 @@ and fixes about 30 bugs.</p>
<a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
</li>
- <li class="">
- <a href="/news/2016/06/13/release-1.8.0/">1.8.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/03/13/release-1.1.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/03/13/release-1.1.0-incubating/index.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/news/2015/03/13/release-1.1.0-incubating/index.html (original)
+++ calcite/site/news/2015/03/13/release-1.1.0-incubating/index.html Mon Jun 26 09:42:55 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
<option value="/news/2016/10/12/release-1.10.0/">Release 1.10.0</option>
@@ -183,6 +184,10 @@ calling constructors directly.</p>
<ul>
<li class="">
+ <a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/03/24/release-1.12.0/">1.12.0</a>
</li>
@@ -198,10 +203,6 @@ calling constructors directly.</p>
<a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
</li>
- <li class="">
- <a href="/news/2016/06/13/release-1.8.0/">1.8.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/04/07/release-1.2.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/04/07/release-1.2.0-incubating/index.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/news/2015/04/07/release-1.2.0-incubating/index.html (original)
+++ calcite/site/news/2015/04/07/release-1.2.0-incubating/index.html Mon Jun 26 09:42:55 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
<option value="/news/2016/10/12/release-1.10.0/">Release 1.10.0</option>
@@ -183,6 +184,10 @@ improve implicit and explicit conversion
<ul>
<li class="">
+ <a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/03/24/release-1.12.0/">1.12.0</a>
</li>
@@ -198,10 +203,6 @@ improve implicit and explicit conversion
<a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
</li>
- <li class="">
- <a href="/news/2016/06/13/release-1.8.0/">1.8.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/04/24/new-committers/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/04/24/new-committers/index.html?rev=1799865&r1=1799864&r2=1799865&view=diff
==============================================================================
--- calcite/site/news/2015/04/24/new-committers/index.html (original)
+++ calcite/site/news/2015/04/24/new-committers/index.html Mon Jun 26 09:42:55 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
<option value="/news/2016/10/12/release-1.10.0/">Release 1.10.0</option>
@@ -177,6 +178,10 @@ committers for their work on Calcite. We
<ul>
<li class="">
+ <a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/03/24/release-1.12.0/">1.12.0</a>
</li>
@@ -192,10 +197,6 @@ committers for their work on Calcite. We
<a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
</li>
- <li class="">
- <a href="/news/2016/06/13/release-1.8.0/">1.8.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>