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";>
