You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2017/01/06 19:13:04 UTC
svn commit: r1777693 [1/2] - in /calcite/site: ./ community/ develop/ 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-inc...
Author: jhyde
Date: Fri Jan 6 19:13:04 2017
New Revision: 1777693
URL: http://svn.apache.org/viewvc?rev=1777693&view=rev
Log:
Refresh site for release 1.11 and copyright year 2017
Modified:
calcite/site/community/index.html
calcite/site/develop/index.html
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/history.html
calcite/site/docs/howto.html
calcite/site/docs/index.html
calcite/site/docs/lattice.html
calcite/site/docs/model.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/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/index.html
calcite/site/news/releases/index.html
Modified: calcite/site/community/index.html
URL: http://svn.apache.org/viewvc/calcite/site/community/index.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/community/index.html (original)
+++ calcite/site/community/index.html Fri Jan 6 19:13:04 2017
@@ -346,7 +346,7 @@ Calcite, or attend one of the <a href="#
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/develop/index.html
URL: http://svn.apache.org/viewvc/calcite/site/develop/index.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/develop/index.html (original)
+++ calcite/site/develop/index.html Fri Jan 6 19:13:04 2017
@@ -198,7 +198,7 @@ or just by answering questions on the li
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/adapter.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/adapter.html (original)
+++ calcite/site/docs/adapter.html Fri Jan 6 19:13:04 2017
@@ -922,7 +922,7 @@ Connections can be local or remote (JSON
<p>where <code class="highlighter-rouge">property</code>, <code class="highlighter-rouge">property2</code> are properties as described below.
(Connect strings are compliant with OLE DB Connect String syntax,
as implemented by Avatica’s
-<a href="/apidocs/org/apache/calcite/avatica/ConnectStringParser.html">ConnectStringParser</a>.)</p>
+<a href="/avatica/apidocs/org/apache/calcite/avatica/ConnectStringParser.html">ConnectStringParser</a>.)</p>
<h2 id="jdbc-connect-string-parameters">JDBC connect string parameters</h2>
@@ -940,7 +940,7 @@ as implemented by Avatica’s
</tr>
<tr>
<td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#CONFORMANCE">conformance</a></td>
- <td style="text-align: left">SQL conformance level. Values: “default” (the default, similar to “pragmatic_2003”), “oracle_10”, “pragmatic_99”, “pragmatic_2003”, “strict_92”, “strict_99”, “strict_2003”.</td>
+ <td style="text-align: left">SQL conformance level. Values: DEFAULT (the default, similar to PRAGMATIC_2003), ORACLE_10, ORACLE_12, PRAGMATIC_99, PRAGMATIC_2003, STRICT_92, STRICT_99, STRICT_2003, SQL_SERVER_2008.</td>
</tr>
<tr>
<td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#CREATE_MATERIALIZATIONS">createMaterializations</a></td>
@@ -951,6 +951,10 @@ as implemented by Avatica’s
<td style="text-align: left">How NULL values should be sorted if neither NULLS FIRST nor NULLS LAST are specified in a query. The default, HIGH, sorts NULL values the same as Oracle.</td>
</tr>
<tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#DRUID_FETCH">druidFetch</a></td>
+ <td style="text-align: left">How many rows the Druid adapter should fetch at a time when executing SELECT queries.</td>
+ </tr>
+ <tr>
<td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#FORCE_DECORRELATE">forceDecorrelate</a></td>
<td style="text-align: left">Whether the planner should try de-correlating as much as possible. Default true.</td>
</tr>
@@ -971,10 +975,18 @@ as implemented by Avatica’s
<td style="text-align: left">URI of the JSON model file.</td>
</tr>
<tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#PARSER_FACTORY">parserFactory</a></td>
+ <td style="text-align: left">Parser factory. The name of a class that implements <a href="/apidocs/org/apache/calcite/sql/parser/SqlParserImplFactory.html">SqlParserImplFactory</a> and has a public default constructor or an <code class="highlighter-rouge">INSTANCE</code> constant.</td>
+ </tr>
+ <tr>
<td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#QUOTING">quoting</a></td>
<td style="text-align: left">How identifiers are quoted. Values are DOUBLE_QUOTE, BACK_QUOTE, BRACKET. If not specified, value from <code class="highlighter-rouge">lex</code> is used.</td>
</tr>
<tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#QUOTED_CASING">quotedCasing</a></td>
+ <td style="text-align: left">How identifiers are stored if they are quoted. Values are UNCHANGED, TO_UPPER, TO_LOWER. If not specified, value from <code class="highlighter-rouge">lex</code> is used.</td>
+ </tr>
+ <tr>
<td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#SCHEMA">schema</a></td>
<td style="text-align: left">Name of initial schema.</td>
</tr>
@@ -1306,7 +1318,7 @@ For example,</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/algebra.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/algebra.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/algebra.html (original)
+++ calcite/site/docs/algebra.html Fri Jan 6 19:13:04 2017
@@ -1070,7 +1070,7 @@ field #8.</p>
<p>But through the builder API, you specify which field of which input.
To reference “SAL”, internal field #5,
-write <code class="highlighter-rouge">builder.field(2, 0, "SAL")</code>
+write <code class="highlighter-rouge">builder.field(2, 0, "SAL")</code>, <code class="highlighter-rouge">builder.field(2, "EMP", "SAL")</code>,
or <code class="highlighter-rouge">builder.field(2, 0, 5)</code>.
This means “the field #5 of input #0 of two inputs”.
(Why does it need to know that there are two inputs? Because they are stored on
@@ -1079,7 +1079,7 @@ If we did not tell the builder that were
to go for input #0.)</p>
<p>Similarly, to reference “DNAME”, internal field #9 (8 + 1),
-write <code class="highlighter-rouge">builder.field(2, 1, "DNAME")</code>
+write <code class="highlighter-rouge">builder.field(2, 1, "DNAME")</code>, <code class="highlighter-rouge">builder.field(2, "DEPT", "DNAME")</code>,
or <code class="highlighter-rouge">builder.field(2, 1, 1)</code>.</p>
<h3 id="api-summary">API summary</h3>
@@ -1186,6 +1186,7 @@ return the <code class="highlighter-roug
<li><code class="highlighter-rouge">all</code> boolean</li>
<li><code class="highlighter-rouge">distinct</code> boolean</li>
<li><code class="highlighter-rouge">alias</code> String</li>
+ <li><code class="highlighter-rouge">varHolder</code> <a href="/apidocs/org/apache/calcite/util/Holder.html">Holder</a> of <a href="/apidocs/org/apache/calcite/rex/RexCorrelVariable.html">RexCorrelVariable</a></li>
</ul>
<p>The builder methods perform various optimizations, including:
@@ -1194,6 +1195,28 @@ return the <code class="highlighter-roug
simplifies (converting say <code class="highlighter-rouge">x = 1 AND TRUE</code> to <code class="highlighter-rouge">x = 1</code>)
* If you apply <code class="highlighter-rouge">sort</code> then <code class="highlighter-rouge">limit</code>, the effect is as if you had called <code class="highlighter-rouge">sortLimit</code></p>
+<p>There are annotation methods that add information to the top relational
+expression on the stack:</p>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">Method</th>
+ <th style="text-align: left">Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left"><code class="highlighter-rouge">as(alias)</code></td>
+ <td style="text-align: left">Assigns a table alias to the top relational expression on the stack</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><code class="highlighter-rouge">variable(varHolder)</code></td>
+ <td style="text-align: left">Creates a correlation variable referencing the top relational expression</td>
+ </tr>
+ </tbody>
+</table>
+
<h3 id="stack-methods">Stack methods</h3>
<table>
@@ -1261,6 +1284,22 @@ added to the stack.</p>
<td style="text-align: left">Reference, by ordinal, to a field of the (<code class="highlighter-rouge">inputCount</code> - <code class="highlighter-rouge">inputOrdinal</code>)th relational expression</td>
</tr>
<tr>
+ <td style="text-align: left"><code class="highlighter-rouge">field(inputCount, alias, fieldName)</code></td>
+ <td style="text-align: left">Reference, by table alias and field name, to a field at most <code class="highlighter-rouge">inputCount - 1</code> elements from the top of the stack</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><code class="highlighter-rouge">field(alias, fieldName)</code></td>
+ <td style="text-align: left">Reference, by table alias and field name, to a field of the top-most relational expressions</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><code class="highlighter-rouge">field(expr, fieldName)</code></td>
+ <td style="text-align: left">Reference, by name, to a field of a record-valued expression</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><code class="highlighter-rouge">field(expr, fieldOrdinal)</code></td>
+ <td style="text-align: left">Reference, by ordinal, to a field of a record-valued expression</td>
+ </tr>
+ <tr>
<td style="text-align: left"><code class="highlighter-rouge">fields(fieldOrdinalList)</code></td>
<td style="text-align: left">List of expressions referencing input fields by ordinal</td>
</tr>
@@ -1657,7 +1696,7 @@ added to the stack.</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/avatica_json_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_json_reference.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/avatica_json_reference.html (original)
+++ calcite/site/docs/avatica_json_reference.html Fri Jan 6 19:13:04 2017
@@ -2096,7 +2096,7 @@ SQL or by a DatabaseMetaData operation w
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/avatica_overview.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_overview.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/avatica_overview.html (original)
+++ calcite/site/docs/avatica_overview.html Fri Jan 6 19:13:04 2017
@@ -1275,7 +1275,7 @@ At some point Avatica could become a sep
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/avatica_protobuf_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_protobuf_reference.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/avatica_protobuf_reference.html (original)
+++ calcite/site/docs/avatica_protobuf_reference.html Fri Jan 6 19:13:04 2017
@@ -2160,7 +2160,7 @@ SQL or by a DatabaseMetaData operation w
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/avatica_roadmap.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_roadmap.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/avatica_roadmap.html (original)
+++ calcite/site/docs/avatica_roadmap.html Fri Jan 6 19:13:04 2017
@@ -1197,7 +1197,7 @@
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/cassandra_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/cassandra_adapter.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/cassandra_adapter.html (original)
+++ calcite/site/docs/cassandra_adapter.html Fri Jan 6 19:13:04 2017
@@ -1249,7 +1249,7 @@ prove useful.</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/druid_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/druid_adapter.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/druid_adapter.html (original)
+++ calcite/site/docs/druid_adapter.html Fri Jan 6 19:13:04 2017
@@ -1404,7 +1404,7 @@ and the two tables in Druid (<code class
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/elasticsearch_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/elasticsearch_adapter.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/elasticsearch_adapter.html (original)
+++ calcite/site/docs/elasticsearch_adapter.html Fri Jan 6 19:13:04 2017
@@ -1271,7 +1271,7 @@ it.</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/history.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/history.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/history.html (original)
+++ calcite/site/docs/history.html Fri Jan 6 19:13:04 2017
@@ -882,9 +882,236 @@
Downloads are available on the
<a href="/downloads/">downloads page</a>.</p>
+<h2 id="v1-11-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.11.0">1.11.0</a> / 2017-01-11</h2>
+
+<p>Nearly three months after the previous release, there is a long list
+of improvements and bug-fixes, many of them making planner rules
+smarter.</p>
+
+<p>Several adapters have improvements:</p>
+
+<ul>
+ <li>The JDBC adapter can now push down DML (<code class="highlighter-rouge">INSERT</code>, <code class="highlighter-rouge">UPDATE</code>, <code class="highlighter-rouge">DELETE</code>),
+windowed aggregates (<code class="highlighter-rouge">OVER</code>), <code class="highlighter-rouge">IS NULL</code> and <code class="highlighter-rouge">IS NOT NULL</code> operators.</li>
+ <li>The Cassandra adapter now supports authentication.</li>
+ <li>Several key bug-fixes in the Druid adapter.</li>
+</ul>
+
+<p>For correlated and uncorrelated sub-queries, we generate more
+efficient plans (for example, in some correlated queries we no longer
+require a sub-query to generate the values of the correlating
+variable), can now handle multiple correlations, and have also fixed a
+few correctness bugs.</p>
+
+<p>New SQL syntax:</p>
+
+<ul>
+ <li><code class="highlighter-rouge">CROSS APPLY</code> and <code class="highlighter-rouge">OUTER APPLY</code>;</li>
+ <li><code class="highlighter-rouge">MINUS</code> as a synonym for <code class="highlighter-rouge">EXCEPT</code>;</li>
+ <li>an <code class="highlighter-rouge">AS JSON</code> option for the <code class="highlighter-rouge">EXPLAIN</code> command;</li>
+ <li>compound identifiers in the target list of <code class="highlighter-rouge">INSERT</code>, allowing you to
+insert into individual fields of record-valued columns (or column
+families if you are using the Apache Phoenix adapter).</li>
+</ul>
+
+<p>A variety of new and extended built-in functions: <code class="highlighter-rouge">CONVERT</code>, <code class="highlighter-rouge">LTRIM</code>,
+<code class="highlighter-rouge">RTRIM</code>, 3-parameter <code class="highlighter-rouge">LOCATE</code> and <code class="highlighter-rouge">POSITION</code>, <code class="highlighter-rouge">RAND</code>, <code class="highlighter-rouge">RAND_INTEGER</code>,
+and <code class="highlighter-rouge">SUBSTRING</code> applied to binary types.</p>
+
+<p>There are minor but potentially breaking API changes in
+[<a href="https://issues.apache.org/jira/browse/CALCITE-1519">CALCITE-1519</a>]
+(interface <code class="highlighter-rouge">SubqueryConverter</code> becomes <code class="highlighter-rouge">SubQueryConverter</code> and some
+similar changes in the case of classes and methods) and
+[<a href="https://issues.apache.org/jira/browse/CALCITE-1530">CALCITE-1530</a>]
+(rename <code class="highlighter-rouge">Shuttle</code> to <code class="highlighter-rouge">Visitor</code>, and create a new class <code class="highlighter-rouge">Visitor<R></code>).
+See the cases for more details.</p>
+
+<p>Compatibility: This release is tested
+on Linux, macOS, Microsoft Windows;
+using Oracle JDK 1.7, 1.8;
+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">New features</h4>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1551">CALCITE-1551</a>]
+Preserve alias in <code class="highlighter-rouge">RelBuilder.project</code> (Jess Balint)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1552">CALCITE-1552</a>]
+Add <code class="highlighter-rouge">RAND</code> function, returning <code class="highlighter-rouge">DOUBLE</code> values in the range 0..1</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1414">CALCITE-1414</a>]
+Add <code class="highlighter-rouge">RAND_INTEGER</code> function, which returns a random integer modulo N (Julian
+Feinauer)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1540">CALCITE-1540</a>]
+Support multiple columns in <code class="highlighter-rouge">PARTITION BY</code> clause of window function
+(Hongbin Ma)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1534">CALCITE-1534</a>]
+Allow compound identifiers in <code class="highlighter-rouge">INSERT</code> target column list</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1529">CALCITE-1529</a>]
+Support <code class="highlighter-rouge">CREATE TABLE</code> in tests (and only in tests)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1527">CALCITE-1527</a>]
+Support DML in the JDBC adapter (Christian Tzolov)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1523">CALCITE-1523</a>]
+In <code class="highlighter-rouge">RelBuilder</code>, add <code class="highlighter-rouge">field</code> method to reference input to join by alias (Jess
+Balint)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1524">CALCITE-1524</a>]
+Add a project to the planner root so that rules know which output fields are
+used</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1425">CALCITE-1425</a>]
+Support two-level column structure in <code class="highlighter-rouge">INSERT</code>/<code class="highlighter-rouge">UPDATE</code>/<code class="highlighter-rouge">MERGE</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1472">CALCITE-1472</a>]
+Support <code class="highlighter-rouge">CROSS</code>/<code class="highlighter-rouge">OUTER APPLY</code> syntax (Jark Wu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1506">CALCITE-1506</a>]
+Push <code class="highlighter-rouge">OVER</code> clause to underlying SQL via JDBC adapter (Christian Tzolov)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1509">CALCITE-1509</a>]
+Allow overriding the convertlet table in CalcitePrepareImpl (Gian Merlino)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1483">CALCITE-1483</a>]
+Generate simpler logic for <code class="highlighter-rouge">NOT IN</code> if we can deduce that the key is never null</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1497">CALCITE-1497</a>]
+Infer <code class="highlighter-rouge">IS NOT NULL</code>, and project predicates</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1489">CALCITE-1489</a>]
+Add rule, <code class="highlighter-rouge">AggregateValuesRule</code>, that applies to an <code class="highlighter-rouge">Aggregate</code> on an empty
+relation (Gian Merlino)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1447">CALCITE-1447</a>]
+Implement <code class="highlighter-rouge">INTERSECT DISTINCT</code> by rewriting to <code class="highlighter-rouge">UNION ALL</code> and counting
+(Pengcheng Xiong)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1389">CALCITE-1389</a>]
+Add a rewrite rule to use materialized views with joins</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1125">CALCITE-1125</a>]
+<code class="highlighter-rouge">MINUS</code> as a synonym for <code class="highlighter-rouge">EXCEPT</code> (enabled in Oracle10 conformance)
+(Chandni Singh)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1453">CALCITE-1453</a>]
+Support <code class="highlighter-rouge">ANY</code> type with binary comparison and arithmetic operators
+(Jungtaek Lim)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1444">CALCITE-1444</a>]
+Add <code class="highlighter-rouge">CONVERT</code> function (Laurent Goujon)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1448">CALCITE-1448</a>]
+Add rules to flatten and prune <code class="highlighter-rouge">Intersect</code> and <code class="highlighter-rouge">Minus</code>;
+flatten set-operators if the top is <code class="highlighter-rouge">DISTINCT</code> and bottom is <code class="highlighter-rouge">ALL</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1426">CALCITE-1426</a>]
+Support customized star expansion in <code class="highlighter-rouge">Table</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1454">CALCITE-1454</a>]
+Allow custom implementations of <code class="highlighter-rouge">SqlConformance</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1417">CALCITE-1417</a>]
+In <code class="highlighter-rouge">RelBuilder</code>, simplify “CAST(literal TO type)” to a literal when possible</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1443">CALCITE-1443</a>]
+Add authentication support in Cassandra adapter</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1404">CALCITE-1404</a>]
+Implement <code class="highlighter-rouge">FILTER</code> on aggregate functions in <code class="highlighter-rouge">Interpreter</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1418">CALCITE-1418</a>]
+Implement <code class="highlighter-rouge">SUBSTRING</code> function for <code class="highlighter-rouge">BINARY</code> and <code class="highlighter-rouge">VARBINARY</code> (Jungtaek Lim)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1422">CALCITE-1422</a>]
+In JDBC adapter, allow <code class="highlighter-rouge">IS NULL</code> and <code class="highlighter-rouge">IS NOT NULL</code> operators in generated SQL
+join condition (Viktor Batytskyi)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1419">CALCITE-1419</a>]
+Implement JDBC functions: <code class="highlighter-rouge">LTRIM</code>, <code class="highlighter-rouge">RTRIM</code> and 3-parameter <code class="highlighter-rouge">LOCATE</code> and
+<code class="highlighter-rouge">POSITION</code> (Jungtaek Lim)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-917">CALCITE-917</a>]
+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">Bug-fixes, API changes and minor enhancements</h4>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1559">CALCITE-1559</a>]
+Convert example models to stricter JSON</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1560">CALCITE-1560</a>]
+Remove <code class="highlighter-rouge">avatica</code> directory from <code class="highlighter-rouge">sqlline</code>’s class path</li>
+ <li>Remove non-ASCII characters from Java source files</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1511">CALCITE-1511</a>]
+Decorrelation fails if query has more than one <code class="highlighter-rouge">EXISTS</code> in <code class="highlighter-rouge">WHERE</code> clause</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1555">CALCITE-1555</a>]
+Improve <code class="highlighter-rouge">RelNode</code> validation</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1548">CALCITE-1548</a>]
+Instantiate function objects once per query</li>
+ <li>Add lock to <code class="highlighter-rouge">JdbcAdapterTest</code>, to ensure that tests that modify data run in
+series</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1519">CALCITE-1519</a>]
+Standardize on “sub-query” rather than “subquery” in class names and comments</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1493">CALCITE-1493</a>]
+Wrong plan for <code class="highlighter-rouge">NOT IN</code> correlated queries</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1526">CALCITE-1526</a>]
+Use <code class="highlighter-rouge">Strong</code> to infer whether a predicate’s inputs may be null</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1530">CALCITE-1530</a>]
+Create a visitor to traverse linq4j expressions without mutating them, and
+rename <code class="highlighter-rouge">Visitor</code> to <code class="highlighter-rouge">Shuttle</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1507">CALCITE-1507</a>]
+<code class="highlighter-rouge">OFFSET</code> cannot be pushed through a <code class="highlighter-rouge">JOIN</code> if the non-preserved side of outer
+join is not count-preserving</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1522">CALCITE-1522</a>]
+Fix error message for <code class="highlighter-rouge">SetOp</code> with incompatible args (Jess Balint)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1532">CALCITE-1532</a>]
+In <code class="highlighter-rouge">HttpUtils</code>, don’t log HTTP requests; they may contain user name, password</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1037">CALCITE-1037</a>]
+Column uniqueness is calculated incorrectly for <code class="highlighter-rouge">Correlate</code> (Alexey Makhmutov)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1495">CALCITE-1495</a>]
+<code class="highlighter-rouge">SemiJoinRule</code> should not apply to <code class="highlighter-rouge">RIGHT</code> and <code class="highlighter-rouge">FULL JOIN</code>, and should strip
+<code class="highlighter-rouge">LEFT JOIN</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1516">CALCITE-1516</a>]
+Upgrade <code class="highlighter-rouge">hydromatic-resource-maven-plugin</code>, and re-work <code class="highlighter-rouge">SaffronProperties</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1498">CALCITE-1498</a>]
+Avoid <code class="highlighter-rouge">LIMIT</code> with trivial <code class="highlighter-rouge">ORDER BY</code> being pushed through <code class="highlighter-rouge">JOIN</code> endlessly</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1501">CALCITE-1501</a>]
+<code class="highlighter-rouge">EnumerableUnion</code> should use array comparator when row format is <code class="highlighter-rouge">ARRAY</code> (Dayue
+Gao)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1502">CALCITE-1502</a>]
+<code class="highlighter-rouge">AssertionError</code> in <code class="highlighter-rouge">ReduceExpressionsRule</code> when <code class="highlighter-rouge">CASE</code> is used with optional
+value and literal (Serhii Harnyk)</li>
+ <li>Cosmetic changes, and deprecate some methods</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1486">CALCITE-1486</a>]
+Invalid “Invalid literal” error for complex expression</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1488">CALCITE-1488</a>]
+<code class="highlighter-rouge">ValuesReduceRule</code> should ignore empty <code class="highlighter-rouge">Values</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1384">CALCITE-1384</a>]
+Extension point for <code class="highlighter-rouge">ALTER</code> statements (Gabriel Reid)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1484">CALCITE-1484</a>]
+Upgrade Apache parent POM to version 18</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1482">CALCITE-1482</a>]
+Fix leak on CassandraSchema creation</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1479">CALCITE-1479</a>]
+<code class="highlighter-rouge">AssertionError</code> in <code class="highlighter-rouge">ReduceExpressionsRule</code> on multi-column <code class="highlighter-rouge">IN</code> sub-query
+(Gian Merlino)</li>
+ <li>Upgrade <code class="highlighter-rouge">Quidem</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1416">CALCITE-1416</a>]
+Make classes implement <code class="highlighter-rouge">AutoCloseable</code> where possible (Chinmay Kolhatkar)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1474">CALCITE-1474</a>]
+Upgrade <code class="highlighter-rouge">aggdesigner</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1270">CALCITE-1270</a>]
+Upgrade to <code class="highlighter-rouge">avatica-1.9</code>, <code class="highlighter-rouge">sqlline-1.2.0</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1461">CALCITE-1461</a>]
+Hard-coded class name in <code class="highlighter-rouge">JaninoRelMetadataProvider</code> breaks shading (Jark Wu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1465">CALCITE-1465</a>]
+Store constants as a derived field in <code class="highlighter-rouge">RelOptPredicateList</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1429">CALCITE-1429</a>]
+Druid adapter must send <code class="highlighter-rouge">fromNext</code> when requesting rows from Druid (Jiarong
+Wei)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1430">CALCITE-1430</a>]
+In Druid adapter, <code class="highlighter-rouge">pagingIdentifiers</code> might have more than one value (Jiarong
+Wei)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1442">CALCITE-1442</a>]
+Interval fractional second precision returns wrong value (Laurent Goujon)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1434">CALCITE-1434</a>]
+User-defined aggregate function that uses a generic interface (Arun Mahadevan)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1431">CALCITE-1431</a>]
+<code class="highlighter-rouge">RelDataTypeFactoryImpl.copyType()</code> did not copy <code class="highlighter-rouge">StructKind</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1424">CALCITE-1424</a>]
+Druid type is called <code class="highlighter-rouge">FLOAT</code>, not <code class="highlighter-rouge">DOUBLE</code> (Jiarong Wei)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1415">CALCITE-1415</a>]
+Add sub-query support for RelStructuredTypeFlattener</li>
+</ul>
+
+<h4 id="web-site-and-documentation">Web site and documentation</h4>
+
+<ul>
+ <li>Change PMC chair</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1459">CALCITE-1459</a>]
+Add Apache Apex to “Powered By” page (Chinmay Kolhatkar)</li>
+</ul>
+
<h2 id="v1-10-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.10.0">1.10.0</a> / 2016-10-12</h2>
-<p>This release comes shortly after 1.9.0. It includes mainly bug fixes for the core and
+<p>This release comes shortly after 1.9.0. It includes mainly bug-fixes for the core and
Druid adapter. For the latest, we fixed an
<a href="https://issues.apache.org/jira/browse/CALCITE-1403">important issue</a> that
prevented us from handling consistently time dimensions in different time zones.</p>
@@ -896,14 +1123,14 @@ 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>
-<p>New Feature</p>
+<h4 id="new-feature">New feature</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1374">CALCITE-1374</a>]
Support operator <code class="highlighter-rouge">!=</code> as an alternative to <code class="highlighter-rouge"><></code></li>
</ul>
-<p>Bug fixes, API changes and minor enhancements</p>
+<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-1378">CALCITE-1378</a>]
@@ -934,7 +1161,7 @@ Druid Filter translation incorrect if in
Allow Calcite JDBC Driver minor version to be greater than 9</li>
</ul>
-<p>Web site and documentation</p>
+<h4 id="web-site-and-documentation-1">Web site and documentation</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1393">CALCITE-1393</a>]
@@ -946,7 +1173,7 @@ Exclude packages <code class="highlighte
<p>This release includes extensions and fixes for the Druid adapter. New features were
added, such as the capability to
<a href="https://issues.apache.org/jira/browse/CALCITE-1357">recognize and translate Timeseries and TopN Druid queries</a>.
-Moreover, this release contains multiple bug fixes over the initial implementation of the
+Moreover, this release contains multiple bug-fixes over the initial implementation of the
adapter. It is worth mentioning that most of these fixes were contributed by Druid developers,
which demonstrates the good reception of the adapter by that community.</p>
@@ -971,7 +1198,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>
-<p>New Feature</p>
+<h4 id="new-features-1">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1208">CALCITE-1208</a>]
@@ -982,7 +1209,7 @@ Add streaming CSV table (Zhen Wang)</li>
Support <code class="highlighter-rouge">LATERAL TABLE</code> (Jark Wu)</li>
</ul>
-<p>Druid adapter</p>
+<h4 id="druid-adapter">Druid adapter</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1292">CALCITE-1292</a>]
@@ -999,7 +1226,7 @@ Recognize Druid <code class="highlighter
Push filters on time dimension to Druid</li>
</ul>
-<p>Planner rules</p>
+<h4 id="planner-rules">Planner rules</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1220">CALCITE-1220</a>]
@@ -1018,7 +1245,7 @@ Convert predicates on <code class="highl
Introduce <code class="highlighter-rouge">UnionPullUpConstantsRule</code></li>
</ul>
-<p>Bug fixes, API changes and minor enhancements</p>
+<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-30">CALCITE-30</a>]
@@ -1087,7 +1314,7 @@ In <code class="highlighter-rouge">SqlKi
Calcite generate wrong field names in JDBC adapter</li>
</ul>
-<p>Web site and documentation</p>
+<h4 id="web-site-and-documentation-2">Web site and documentation</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1229">CALCITE-1229</a>]
@@ -1128,7 +1355,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>
-<p>New features</p>
+<h4 id="new-features-2">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1177">CALCITE-1177</a>]
@@ -1166,7 +1393,7 @@ In Druid adapter, deduce tables and colu
Allow numeric connection properties, and ‘K’, ‘M’, ‘G’ suffixes</li>
</ul>
-<p>Planner rules</p>
+<h4 id="planner-rules-1">Planner rules</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1235">CALCITE-1235</a>]
@@ -1185,7 +1412,7 @@ Add <code class="highlighter-rouge">Proj
substitution</li>
</ul>
-<p>Bug fixes, API changes and minor enhancements</p>
+<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-1281">CALCITE-1281</a>]
@@ -1264,7 +1491,7 @@ Allow <code class="highlighter-rouge">Sq
Allow apache-rat to be run outside of release process</li>
</ul>
-<p>Web site and documentation</p>
+<h4 id="web-site-and-documentation-3">Web site and documentation</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1273">CALCITE-1273</a>]
@@ -1325,7 +1552,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>
-<p>New features</p>
+<h4 id="new-features-3">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1124">CALCITE-1124</a>]
@@ -1342,7 +1569,7 @@ table (Hsuan-Yi Chu)</li>
Sub-query inside aggregate function</li>
</ul>
-<p>Planner rules</p>
+<h4 id="planner-rules-2">Planner rules</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1158">CALCITE-1158</a>]
@@ -1369,7 +1596,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>
-<p>Bug fixes, API changes and minor enhancements</p>
+<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-1147">CALCITE-1147</a>]
@@ -1436,7 +1663,7 @@ Upgrade Jackson</li>
Clean up maven POM files</li>
</ul>
-<p>Web site and documentation</p>
+<h4 id="web-site-and-documentation-4">Web site and documentation</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1112">CALCITE-1112</a>]
@@ -1458,7 +1685,7 @@ Delete old releases from mirroring syste
<h2 id="v1-6-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.6.0">1.6.0</a> / 2016-01-22</h2>
<p>As usual in this release, there are new SQL features, improvements to
-planning rules and Avatica, and lots of bug fixes. We’ll spotlight a
+planning rules and Avatica, and lots of bug-fixes. We’ll spotlight a
couple of features make it easier to handle complex queries.</p>
<p>[<a href="https://issues.apache.org/jira/browse/CALCITE-816">CALCITE-816</a>]
@@ -1492,7 +1719,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>
-<p>New features</p>
+<h4 id="new-features-4">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-816">CALCITE-816</a>]
@@ -1527,7 +1754,7 @@ Overloaded Table Functions with named ar
If <code class="highlighter-rouge">NULLS FIRST</code>/<code class="highlighter-rouge">NULLS LAST</code> not specified, sort <code class="highlighter-rouge">NULL</code> values high</li>
</ul>
-<p>Avatica features and bug fixes</p>
+<h4 id="avatica-features-and-bug-fixes">Avatica features and bug-fixes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1040">CALCITE-1040</a>]
@@ -1546,7 +1773,7 @@ Add server’s address in each respon
Propagate the cause, not just the cause’s message, from <code class="highlighter-rouge">JdbcMeta</code></li>
</ul>
-<p>Planner rules</p>
+<h4 id="planner-rules-3">Planner rules</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1057">CALCITE-1057</a>]
@@ -1597,7 +1824,7 @@ Composite <code class="highlighter-rouge
Add description to <code class="highlighter-rouge">SortProjectTransposeRule</code>’s constructor</li>
</ul>
-<p>Bug fixes, API changes and minor enhancements</p>
+<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-1060">CALCITE-1060</a>]
@@ -1679,7 +1906,7 @@ Exception while validating <code class="
Rename <code class="highlighter-rouge">timezone</code> connection property to <code class="highlighter-rouge">timeZone</code></li>
</ul>
-<p>Web site and documentation</p>
+<h4 id="web-site-and-documentation-5">Web site and documentation</h4>
<ul>
<li>Avatica
@@ -1735,7 +1962,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>
-<p>New features</p>
+<h4 id="new-features-5">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-911">CALCITE-911</a>]
@@ -1772,7 +1999,7 @@ Add original SQL string as a field in th
Add <code class="highlighter-rouge">RelRoot</code>, a contract for the result of a relational expression</li>
</ul>
-<p>Avatica features and bug fixes</p>
+<h4 id="avatica-features-and-bug-fixes-1">Avatica features and bug-fixes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-951">CALCITE-951</a>]
@@ -1813,7 +2040,7 @@ Break out Avatica documentation and add
Protocol buffer serialization over HTTP for Avatica Server (Josh Elser)</li>
</ul>
-<p>Materializations</p>
+<h4 id="materializations">Materializations</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-952">CALCITE-952</a>]
@@ -1836,7 +2063,7 @@ Xue)</li>
Allow user to specify sort order of an <code class="highlighter-rouge">ArrayTable</code></li>
</ul>
-<p>Planner rules</p>
+<h4 id="planner-rules-4">Planner rules</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-953">CALCITE-953</a>]
@@ -1881,7 +2108,7 @@ Chu)</li>
Push <code class="highlighter-rouge">Aggregate</code> with <code class="highlighter-rouge">Filter</code> through <code class="highlighter-rouge">Union(all)</code></li>
</ul>
-<p>RelBuilder and Piglet</p>
+<h4 id="relbuilder-and-piglet">RelBuilder and Piglet</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-933">CALCITE-933</a>]
@@ -1898,7 +2125,7 @@ Add API to execute queries expressed as
<li>In RelBuilder, build expressions by table alias</li>
</ul>
-<p>Bug fixes, API changes and minor enhancements</p>
+<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-948">CALCITE-948</a>]
@@ -1930,7 +2157,7 @@ Obsolete <code class="highlighter-rouge"
Type of ‘Java<long> * `INTEGER`' should be `BIGINT`</long></li>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-894">CALCITE-894</a>]
Do not generate redundant column alias for the left relation when
-translating <code class="highlighter-rouge">IN</code> subquery (Maryann Xue)</li>
+translating <code class="highlighter-rouge">IN</code> sub-query (Maryann Xue)</li>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-897">CALCITE-897</a>]
Enable debugging using “-Dcalcite.debug”</li>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-885">CALCITE-885</a>]
@@ -1981,12 +2208,12 @@ Type inference when converting <code cla
<h2 id="v1-4-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.4.0-incubating">1.4.0-incubating</a> / 2015-09-02</h2>
-<p>In addition to a large number of bug fixes and minor enhancements,
+<p>In addition to a large number of bug-fixes and minor enhancements,
this release includes improvements to lattices and materialized views,
and adds a builder API so that you can easily create relational
algebra expressions.</p>
-<p>New features</p>
+<h4 id="new-features-6">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-748">CALCITE-748</a>]
@@ -2003,7 +2230,7 @@ non-trivial cases (Amogh Margoor)</li>
<li>Add various <code class="highlighter-rouge">BitSet</code> and <code class="highlighter-rouge">ImmutableBitSet</code> utilities</li>
</ul>
-<p>Website updates</p>
+<h4 id="web-site-updates">Web site updates</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-810">CALCITE-810</a>]
@@ -2022,7 +2249,7 @@ exclusions otherwise</li>
Web site</li>
</ul>
-<p>Bug fixes, API changes and minor enhancements</p>
+<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-741">CALCITE-741</a>]
@@ -2063,7 +2290,7 @@ manager declarations</li>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-813">CALCITE-813</a>]
Upgrade <code class="highlighter-rouge">updateCount</code>, <code class="highlighter-rouge">maxRows</code> from int to long</li>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-714">CALCITE-714</a>]
- When de-correlating, push join condition into subquery</li>
+ When de-correlating, push join condition into sub-query</li>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-751">CALCITE-751</a>]
Push aggregate with aggregate functions through join</li>
<li>Add <code class="highlighter-rouge">RelBuilder.avg</code></li>
@@ -2173,7 +2400,7 @@ and
<a href="https://issues.apache.org/jira/browse/CALCITE-704">filtered aggregate functions</a>
and various improvements to Avatica.</p>
-<p>New features</p>
+<h4 id="new-features-7">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-505">CALCITE-505</a>]
@@ -2187,7 +2414,7 @@ Remote fetch in Calcite JDBC driver</li>
<li>Support Date, Time, Timestamp parameters</li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes">API changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-722">CALCITE-722</a>]
@@ -2208,7 +2435,7 @@ Add a <code class="highlighter-rouge">SW
<code class="highlighter-rouge">Primitive.DOUBLE.min</code> should be large and negative</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes">Bug-fixes and internal changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-688">CALCITE-688</a>]
@@ -2302,7 +2529,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>
-<p>New features</p>
+<h4 id="new-features-8">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-366">CALCITE-366</a>]
@@ -2340,7 +2567,7 @@ joins on the same key (Jesus Camacho Rod
</li>
</ul>
-<p>Avatica features and bug fixes</p>
+<h4 id="avatica-features-and-bug-fixes-2">Avatica features and bug-fixes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-670">CALCITE-670</a>]
@@ -2381,7 +2608,7 @@ Add Avatica support for <code class="hig
Add Avatica support for <code class="highlighter-rouge">getTables</code> (Julian Hyde and Nick Dimiduk)</li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes-1">API changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-617">CALCITE-617</a>]
@@ -2391,7 +2618,7 @@ is not null (Jesus Camacho Rodriguez)</l
SQL standard <code class="highlighter-rouge">REAL</code> is 4 bytes, <code class="highlighter-rouge">FLOAT</code> is 8 bytes</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-1">Bug-fixes and internal changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-672">CALCITE-672</a>]
@@ -2445,7 +2672,7 @@ later.</p>
<code class="highlighter-rouge">RelNode</code>. We strongly suggest that you use these rather than
calling constructors directly.</p>
-<p>New features</p>
+<h4 id="new-features-9">New features</h4>
<ul>
<li>SQL
@@ -2502,7 +2729,7 @@ Add <code class="highlighter-rouge">RelD
</li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes-2">API changes</h4>
<ul>
<li>Many sub-classes of <code class="highlighter-rouge">RelNode</code> now have a static <code class="highlighter-rouge">create</code> method
@@ -2527,7 +2754,7 @@ Use user-given names in <code class="hig
Remove <code class="highlighter-rouge">Project.flags</code> (methods are deprecated, to be removed before 2.0)</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-2">Bug-fixes and internal changes</h4>
<ul>
<li>Remove the <code class="highlighter-rouge">LICENSE</code> file of calcite-example-csv (the former
@@ -2571,7 +2798,7 @@ improvements to the algorithms that impl
including an interpreter that can evaluate queries without compilation;
and fixes about 30 bugs.</p>
-<p>New features</p>
+<h4 id="new-features-10">New features</h4>
<ul>
<li>SQL
@@ -2669,7 +2896,7 @@ Remote JDBC driver</li>
</li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes-3">API changes</h4>
<ul>
<li>The great code re-org
@@ -2706,7 +2933,7 @@ Make parser accept configurable max leng
Remove <code class="highlighter-rouge">OneRow</code> and <code class="highlighter-rouge">Empty</code> relational expressions; <code class="highlighter-rouge">Values</code> will suffice</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-3">Bug-fixes and internal changes</h4>
<ul>
<li>Build improvements
@@ -2833,14 +3060,14 @@ 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>
-<p>New features</p>
+<h4 id="new-features-11">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-436">CALCITE-436</a>]
Simpler SPI to query <code class="highlighter-rouge">Table</code></li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes-4">API changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-447">CALCITE-447</a>]
@@ -2849,7 +3076,7 @@ Change semi-join rules to make use of fa
Add <code class="highlighter-rouge">RelOptRuleOperand</code> constructor that takes a predicate</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-4">Bug-fixes and internal changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-397">CALCITE-397</a>]
@@ -2884,7 +3111,7 @@ Push predicates through <code class="hig
<p>This is the first release as Calcite. (The project was previously called Optiq.)</p>
-<p>New features</p>
+<h4 id="new-features-12">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-430">CALCITE-430</a>]
@@ -2957,7 +3184,7 @@ dummy expression</li>
</li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes-5">API changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-413">CALCITE-413</a>]
@@ -2979,7 +3206,7 @@ Change return type of <code class="highl
</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-5">Bug-fixes and internal changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-386">CALCITE-386</a>]
@@ -3041,7 +3268,7 @@ most recently.</li>
<p>This is the first release under the Apache incubator process.</p>
-<p>New features</p>
+<h4 id="new-features-13">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-371">CALCITE-371</a>]
@@ -3076,7 +3303,7 @@ In <code class="highlighter-rouge">SqlRu
Support multiple parameters in <code class="highlighter-rouge">COUNT(DISTINCT x, y, ...)</code></li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes-6">API changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-343">CALCITE-343</a>]
@@ -3100,7 +3327,7 @@ properties of <code class="highlighter-r
Add <code class="highlighter-rouge">Context</code> and <code class="highlighter-rouge">FrameworkConfig</code></li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-6">Bug-fixes and internal changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-380">CALCITE-380</a>]
@@ -3173,7 +3400,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>
-<p>New features</p>
+<h4 id="new-features-14">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-310">CALCITE-310</a>]
@@ -3197,7 +3424,7 @@ Add <code class="highlighter-rouge">SqlR
</li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes-7">API changes</h4>
<ul>
<li>Re-organize planner initialization,
@@ -3215,7 +3442,7 @@ including for <code class="highlighter-r
</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-7">Bug-fixes and internal changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-312">CALCITE-312</a>]
@@ -3254,7 +3481,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>
-<p>New features</p>
+<h4 id="new-features-15">New features</h4>
<ul>
<li>Implement table functions.</li>
@@ -3292,7 +3519,7 @@ Add adapter that generates TPC-H data</l
<a href="http://openjdk.java.net/projects/code-tools/jmh/">JMH</a>.</li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes-8">API changes</h4>
<ul>
<li>Provide an option to create root schema without the “metadata” schema.</li>
@@ -3307,7 +3534,7 @@ wrappers. (Tobi Vollebregt and Julian Hy
<li>SqlAdvisor callable from client via JDBC.</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-8">Bug-fixes and internal changes</h4>
<ul>
<li>Add Apache incubator proposal.</li>
@@ -3339,7 +3566,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>
-<p>New features</p>
+<h4 id="new-features-16">New features</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-214">CALCITE-214</a>]
@@ -3366,7 +3593,7 @@ Improve query performance of optiq over
<li>Add Phoenix (HBase) SQL dialect (Bruno Dumon)</li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes-9">API changes</h4>
<ul>
<li>Obsolete <code class="highlighter-rouge">RexImpTable.AggregateImplementor</code> and rename <code class="highlighter-rouge">AggImplementor2</code>.
@@ -3394,7 +3621,7 @@ Common base class for TableFunction, Sca
<li>Move around some operator classes and singletons.</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-9">Bug-fixes and internal changes</h4>
<ul>
<li>Upgrade to linq4j-0.2.</li>
@@ -3464,7 +3691,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>
-<p>New features</p>
+<h4 id="new-features-17">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>
@@ -3480,7 +3707,7 @@ Optiq should recognize ‘SYSTEM TABL
<li>Support querying ARRAY columns from JDBC source. (Gabriel Reid)</li>
</ul>
-<p>API changes</p>
+<h4 id="api-changes-10">API changes</h4>
<ul>
<li>Add
@@ -3506,7 +3733,7 @@ now sub-classes of <code class="highligh
(<strong>This is a breaking change</strong>.)</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-10">Bug-fixes and internal changes</h4>
<ul>
<li>Generate optiq-core-VERSION-tests.jar not parent-VERSION-tests.jar.</li>
@@ -3567,7 +3794,7 @@ the spark profile.)</li>
<h2 id="v0-4-18"><a href="https://github.com/apache/calcite/releases/tag/optiq-parent-0.4.18">0.4.18</a> / 2014-02-14</h2>
-<p>API and functionality changes</p>
+<h4 id="api-and-functionality-changes">API and functionality changes</h4>
<ul>
<li>Configurable lexical policy
@@ -3624,7 +3851,7 @@ empty up the tree. (We already do this f
<li><code class="highlighter-rouge">RexNode</code> and its sub-classes are now immutable.</li>
</ul>
-<p>Bug-fixes and internal changes</p>
+<h4 id="bug-fixes-and-internal-changes-11">Bug-fixes and internal changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-61">CALCITE-16</a>]
@@ -3676,7 +3903,7 @@ strings.</li>
<h2 id="v0-4-17"><a href="https://github.com/apache/calcite/releases/tag/optiq-parent-0.4.17">0.4.17</a> / 2014-01-13</h2>
-<p>API changes</p>
+<h4 id="api-changes-11">API changes</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-106">CALCITE-106</a>]
@@ -3703,7 +3930,7 @@ now has a type-factory, so you can just
Externalize RelNode to and from JSON</li>
</ul>
-<p>Tuning</p>
+<h4 id="tuning">Tuning</h4>
<ul>
<li>If <code class="highlighter-rouge">EnumerableAggregateRel</code> has no aggregate functions, generate a
@@ -3731,7 +3958,7 @@ replace <code class="highlighter-rouge">
a fast O(n) get, and fast scan.</li>
</ul>
-<p>Other</p>
+<h4 id="other">Other</h4>
<ul>
<li>[<a href="https://issues.apache.org/jira/browse/CALCITE-87">CALCITE-87</a>]
@@ -4281,7 +4508,7 @@ conflicts in multithreaded usage</li>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/howto.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/howto.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/howto.html (original)
+++ calcite/site/docs/howto.html Fri Jan 6 19:13:04 2017
@@ -928,8 +928,8 @@ and Java (JDK 1.7 or later, 1.8 preferre
<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.10.0-source.tar.gz
-<span class="gp">$ </span><span class="nb">cd </span>calcite-1.10.0
+<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="gp">$ </span>tar xvfz calcite-1.11.0-source.tar.gz
+<span class="gp">$ </span><span class="nb">cd </span>calcite-1.11.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
@@ -1301,6 +1301,7 @@ mvn -Papache-release -Dgpg.passphrase<sp
<li>Set up signing keys as described above.</li>
<li>Make sure you are using JDK 1.7 (not 1.8).</li>
<li>Check that <code class="highlighter-rouge">README</code> and <code class="highlighter-rouge">site/_docs/howto.md</code> have the correct version number.</li>
+ <li>Check that <code class="highlighter-rouge">NOTICE</code> has the current copyright year.</li>
<li>Set <code class="highlighter-rouge">version.major</code> and <code class="highlighter-rouge">version.minor</code> in <code class="highlighter-rouge">pom.xml</code>.</li>
<li>Make sure build and tests succeed, including with <code class="highlighter-rouge">-P it,it-oracle</code>.</li>
<li>Make sure that <code class="highlighter-rouge">mvn javadoc:javadoc javadoc:test-javadoc</code> succeeds
@@ -1961,7 +1962,7 @@ as a template. Be sure to include a brie
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/index.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/index.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/index.html (original)
+++ calcite/site/docs/index.html Fri Jan 6 19:13:04 2017
@@ -1251,7 +1251,7 @@ more details in the <a href="reference.h
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/lattice.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/lattice.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/lattice.html (original)
+++ calcite/site/docs/lattice.html Fri Jan 6 19:13:04 2017
@@ -1267,7 +1267,7 @@ tiles).</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/model.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/model.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/model.html (original)
+++ calcite/site/docs/model.html Fri Jan 6 19:13:04 2017
@@ -1643,7 +1643,7 @@ when you want to pass the column as a me
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/powered_by.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/powered_by.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/powered_by.html (original)
+++ calcite/site/docs/powered_by.html Fri Jan 6 19:13:04 2017
@@ -1257,7 +1257,7 @@ on your site.</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/reference.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/reference.html (original)
+++ calcite/site/docs/reference.html Fri Jan 6 19:13:04 2017
@@ -946,9 +946,10 @@ form.</p>
<span class="o">|</span> <span class="err">{</span>
<span class="k">select</span>
<span class="o">|</span> <span class="n">selectWithoutFrom</span>
- <span class="o">|</span> <span class="n">query</span> <span class="k">UNION</span> <span class="p">[</span> <span class="k">ALL</span> <span class="p">]</span> <span class="n">query</span>
- <span class="o">|</span> <span class="n">query</span> <span class="k">EXCEPT</span> <span class="n">query</span>
- <span class="o">|</span> <span class="n">query</span> <span class="k">INTERSECT</span> <span class="n">query</span>
+ <span class="o">|</span> <span class="n">query</span> <span class="k">UNION</span> <span class="p">[</span> <span class="k">ALL</span> <span class="o">|</span> <span class="k">DISTINCT</span> <span class="p">]</span> <span class="n">query</span>
+ <span class="o">|</span> <span class="n">query</span> <span class="k">EXCEPT</span> <span class="p">[</span> <span class="k">ALL</span> <span class="o">|</span> <span class="k">DISTINCT</span> <span class="p">]</span> <span class="n">query</span>
+ <span class="o">|</span> <span class="n">query</span> <span class="n">MINUS</span> <span class="p">[</span> <span class="k">ALL</span> <span class="o">|</span> <span class="k">DISTINCT</span> <span class="p">]</span> <span class="n">query</span>
+ <span class="o">|</span> <span class="n">query</span> <span class="k">INTERSECT</span> <span class="p">[</span> <span class="k">ALL</span> <span class="o">|</span> <span class="k">DISTINCT</span> <span class="p">]</span> <span class="n">query</span>
<span class="err">}</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="k">LIMIT</span> <span class="err">{</span> <span class="k">count</span> <span class="o">|</span> <span class="k">ALL</span> <span class="err">}</span> <span class="p">]</span>
@@ -982,7 +983,9 @@ form.</p>
<span class="n">tableExpression</span><span class="p">:</span>
<span class="n">tableReference</span> <span class="p">[,</span> <span class="n">tableReference</span> <span class="p">]</span><span class="o">*</span>
- <span class="o">|</span> <span class="n">tableExpression</span> <span class="p">[</span> <span class="k">NATURAL</span> <span class="p">]</span> <span class="p">[</span> <span class="k">LEFT</span> <span class="o">|</span> <span class="k">RIGHT</span> <span class="o">|</span> <span class="k">FULL</span> <span class="p">]</span> <span class="k">JOIN</span> <span class="n">tableExpression</span> <span class="p">[</span> <span class="n">joinCondition</span> <span class="p">]</span>
+ <span class="o">|</span> <span class="n">tableExpression</span> <span class="p">[</span> <span class="k">NATURAL</span> <span class="p">]</span> <span class="p">[</span> <span class="p">(</span> <span class="k">LEFT</span> <span class="o">|</span> <span class="k">RIGHT</span> <span class="o">|</span> <span class="k">FULL</span> <span class="p">)</span> <span class="p">[</span> <span class="k">OUTER</span> <span class="p">]</span> <span class="p">]</span> <span class="k">JOIN</span> <span class="n">tableExpression</span> <span class="p">[</span> <span class="n">joinCondition</span> <span class="p">]</span>
+ <span class="o">|</span> <span class="n">tableExpression</span> <span class="k">CROSS</span> <span class="k">JOIN</span> <span class="n">tableExpression</span>
+ <span class="o">|</span> <span class="n">tableExpression</span> <span class="p">[</span> <span class="k">CROSS</span> <span class="o">|</span> <span class="k">OUTER</span> <span class="p">]</span> <span class="n">APPLY</span> <span class="n">tableExpression</span>
<span class="n">joinCondition</span><span class="p">:</span>
<span class="k">ON</span> <span class="n">booleanExpression</span>
@@ -1056,6 +1059,13 @@ may refer to tables in the FROM clause o
but is not standard SQL and is only allowed in certain
<a href="/apidocs/org/apache/calcite/sql/validate/SqlConformance.html#isFromRequired--">conformance levels</a>.</p>
+<p>MINUS is equivalent to EXCEPT,
+but is not standard SQL and is only allowed in certain
+<a href="/apidocs/org/apache/calcite/sql/validate/SqlConformance.html#isMinusAllowed--">conformance levels</a>.</p>
+
+<p>CROSS APPLY and OUTER APPLY are only allowed in certain
+<a href="/apidocs/org/apache/calcite/sql/validate/SqlConformance.html#isApplyAllowed--">conformance levels</a>.</p>
+
<h2 id="keywords">Keywords</h2>
<p>The following is a list of SQL keywords.
@@ -1076,6 +1086,7 @@ AFTER,
ALWAYS,
<strong>AND</strong>,
<strong>ANY</strong>,
+APPLY,
<strong>ARE</strong>,
<strong>ARRAY</strong>,
<strong>AS</strong>,
@@ -1118,7 +1129,7 @@ CENTURY,
CHAIN,
<strong>CHAR</strong>,
<strong>CHARACTER</strong>,
-CHARACTERISTICTS,
+CHARACTERISTICS,
CHARACTERS,
<strong>CHARACTER_LENGTH</strong>,
CHARACTER_SET_CATALOG,
@@ -1342,6 +1353,7 @@ MESSAGE_TEXT,
MICROSECOND,
MILLENNIUM,
<strong>MIN</strong>,
+<strong>MINUS</strong>,
<strong>MINUTE</strong>,
MINVALUE,
<strong>MOD</strong>,
@@ -1446,6 +1458,7 @@ READ,
RELATIVE,
<strong>RELEASE</strong>,
REPEATABLE,
+REPLACE,
<strong>RESET</strong>,
RESTART,
RESTRICT,
@@ -2113,6 +2126,14 @@ the user or application to supply a time
<td style="text-align: left">FLOOR(numeric)</td>
<td style="text-align: left">Rounds <em>numeric</em> down, and returns the largest number that is less than or equal to <em>numeric</em></td>
</tr>
+ <tr>
+ <td style="text-align: left">RAND([seed])</td>
+ <td style="text-align: left">Generates a random double between 0 and 1 inclusive, optionally initializing the random number generator with <em>seed</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">RAND_INTEGER([seed, ] numeric)</td>
+ <td style="text-align: left">Generates a random integer between 0 and <em>numeric</em> - 1 inclusive, optionally initializing the random number generator with <em>seed</em></td>
+ </tr>
</tbody>
</table>
@@ -3260,7 +3281,7 @@ Here are some examples:</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/stream.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/stream.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/stream.html (original)
+++ calcite/site/docs/stream.html Fri Jan 6 19:13:04 2017
@@ -2144,7 +2144,7 @@ MillWheel: Fault-Tolerant Stream Process
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/docs/tutorial.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/tutorial.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/docs/tutorial.html (original)
+++ calcite/site/docs/tutorial.html Fri Jan 6 19:13:04 2017
@@ -1834,7 +1834,7 @@ relational operators?</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/downloads/index.html
URL: http://svn.apache.org/viewvc/calcite/site/downloads/index.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/downloads/index.html (original)
+++ calcite/site/downloads/index.html Fri Jan 6 19:13:04 2017
@@ -242,7 +242,7 @@ forth.</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/index.html
URL: http://svn.apache.org/viewvc/calcite/site/index.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/index.html (original)
+++ calcite/site/index.html Fri Jan 6 19:13:04 2017
@@ -148,7 +148,7 @@
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
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=1777693&r1=1777692&r2=1777693&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 Fri Jan 6 19:13:04 2017
@@ -266,7 +266,7 @@ new utility, <code class="highlighter-ro
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
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=1777693&r1=1777692&r2=1777693&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 Fri Jan 6 19:13:04 2017
@@ -264,7 +264,7 @@
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
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=1777693&r1=1777692&r2=1777693&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 Fri Jan 6 19:13:04 2017
@@ -264,7 +264,7 @@
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
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=1777693&r1=1777692&r2=1777693&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 Fri Jan 6 19:13:04 2017
@@ -267,7 +267,7 @@ before you move on to 1.0.</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
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=1777693&r1=1777692&r2=1777693&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 Fri Jan 6 19:13:04 2017
@@ -277,7 +277,7 @@ and fixes about 30 bugs.</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
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=1777693&r1=1777692&r2=1777693&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 Fri Jan 6 19:13:04 2017
@@ -276,7 +276,7 @@ calling constructors directly.</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
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=1777693&r1=1777692&r2=1777693&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 Fri Jan 6 19:13:04 2017
@@ -276,7 +276,7 @@ improve implicit and explicit conversion
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
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=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/news/2015/04/24/new-committers/index.html (original)
+++ calcite/site/news/2015/04/24/new-committers/index.html Fri Jan 6 19:13:04 2017
@@ -270,7 +270,7 @@ committers for their work on Calcite. We
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/news/2015/05/30/release-1.3.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/05/30/release-1.3.0-incubating/index.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/news/2015/05/30/release-1.3.0-incubating/index.html (original)
+++ calcite/site/news/2015/05/30/release-1.3.0-incubating/index.html Fri Jan 6 19:13:04 2017
@@ -268,7 +268,7 @@ and various improvements to Avatica.</p>
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
Modified: calcite/site/news/2015/06/05/algebra-builder/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/06/05/algebra-builder/index.html?rev=1777693&r1=1777692&r2=1777693&view=diff
==============================================================================
--- calcite/site/news/2015/06/05/algebra-builder/index.html (original)
+++ calcite/site/news/2015/06/05/algebra-builder/index.html Fri Jan 6 19:13:04 2017
@@ -315,7 +315,7 @@ extensive set of query-optimization rule
<img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are © 2016
+ <p>The contents of this website are © 2017
<a href="https://www.apache.org/">Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">