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 2016/03/02 21:39:50 UTC
svn commit: r1733361 - in /calcite/site/docs: adapter.html history.html
howto.html
Author: jhyde
Date: Wed Mar 2 20:39:49 2016
New Revision: 1733361
URL: http://svn.apache.org/viewvc?rev=1733361&view=rev
Log:
Add SQL-Gremlin to adapters page; add compatibility note for Guava
Modified:
calcite/site/docs/adapter.html
calcite/site/docs/history.html
calcite/site/docs/howto.html
Modified: calcite/site/docs/adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/adapter.html?rev=1733361&r1=1733360&r2=1733361&view=diff
==============================================================================
--- calcite/site/docs/adapter.html (original)
+++ calcite/site/docs/adapter.html Wed Mar 2 20:39:49 2016
@@ -706,8 +706,6 @@
-->
<ul>
- <li><a href="https://github.com/apache/drill">Apache Drill adapter</a></li>
- <li>Cascading adapter (<a href="https://github.com/Cascading/lingual">Lingual</a>)</li>
<li>Cassandra adapter (<a href="/apidocs/org/apache/calcite/adapter/cassandra/package-summary.html">calcite-cassandra</a>)</li>
<li>CSV adapter (<a href="/apidocs/org/apache/calcite/adapter/csv/package-summary.html">example/csv</a>)</li>
<li>JDBC adapter (part of <a href="/apidocs/org/apache/calcite/adapter/jdbc/package-summary.html">calcite-core</a>)</li>
@@ -717,12 +715,119 @@
<li>Eclipse Memory Analyzer (MAT) adapter (<a href="https://github.com/vlsi/mat-calcite-plugin">mat-calcite-plugin</a>)</li>
</ul>
+<h2 id="engines">Engines</h2>
+
+<p>The following standalone engines are powered by Apache Calcite.</p>
+
+<ul>
+ <li><a href="https://drill.apache.org">Apache Drill</a>
+uses Calcite for SQL parsing and query optimization</li>
+ <li><a href="https://flink.apache.org">Apache Flink</a>
+uses Calcite for parsing both regular and streaming SQL,
+and for query optimization</li>
+ <li><a href="https://hive.apache.org">Apache Hive</a>
+uses Calcite for query optimization</li>
+ <li><a href="https://kylin.apache.org">Apache Kylin</a>
+uses Calcite for SQL parsing and query optimization</li>
+ <li><a href="https://phoenix.apache.org">Apache Phoenix</a>
+uses Calcite for SQL parsing and query optimization (under development),
+and also uses Avatica for its remote JDBC driver</li>
+ <li><a href="https://github.com/milinda/samza-sql">SamzaSQL</a>,
+an extension to
+<a href="https://samza.apache.org">Apache Samza</a>,
+uses Calcite for parsing streaming SQL and query optimization</li>
+ <li><a href="https://storm.apache.org">Apache Storm</a>
+uses Calcite for parsing streaming SQL and query optimization</li>
+ <li>Cascading adapter (<a href="https://github.com/Cascading/lingual">Lingual</a>)</li>
+ <li><a href="https://github.com/twilmes/sql-gremlin">SQL-Gremlin</a>,
+a SQL interface to a
+<a href="http://tinkerpop.incubator.apache.org/">Apache TinkerPop</a>-enabled
+graph database</li>
+</ul>
+
<h2 id="drivers">Drivers</h2>
<ul>
<li><a href="/apidocs/org/apache/calcite/jdbc/package-summary.html">JDBC driver</a></li>
</ul>
+<p>The basic form of the JDBC connect string is</p>
+
+<p>jdbc:calcite:property=value;property2=value2</p>
+
+<p>where <code>property</code>, <code>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>
+
+<p>JDBC connect string parameters</p>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">Property</th>
+ <th style="text-align: left">Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#CASE_SENSITIVE">caseSensitive</a></td>
+ <td style="text-align: left">Whether identifiers are matched case-sensitively. If not specified, value from <code>lex</code> is used.</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#CREATE_MATERIALIZATIONS">createMaterializations</a></td>
+ <td style="text-align: left">Whether Calcite should create materializations. Default false.</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#DEFAULT_NULL_COLLATION">materializationsEnabled</a></td>
+ <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#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>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#FUN">fun</a></td>
+ <td style="text-align: left">Collection of built-in functions and operators. Valid values: âstandardâ (the default), âoracleâ.</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#LEX">lex</a></td>
+ <td style="text-align: left">Lexical policy. Values are ORACLE (default), MYSQL, MYSQL_ANSI, SQL_SERVER, JAVA.</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#MATERIALIZATIONS_ENABLED">materializationsEnabled</a></td>
+ <td style="text-align: left">Whether Calcite should use materializations. Default false.</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#MODEL">model</a></td>
+ <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#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>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>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#SPARK">spark</a></td>
+ <td style="text-align: left">Specifies whether Spark should be used as the engine for processing that cannot be pushed to the source system. If false (the default), Calcite generates code that implements the Enumerable interface.</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#TIME_ZONE">timeZone</a></td>
+ <td style="text-align: left">Time zone, for example âgmt-3â. Default is the JVMâs time zone.</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#TYPE_SYSTEM">typeSystem</a></td>
+ <td style="text-align: left">Type system. The name of a class that implements <a href="/apidocs/org/apache/calcite/rel/type/RelDataTypeSystem.html">RelDataTypeSystem</a> and has a public default constructor or an <code>INSTANCE</code> constant.</td>
+ </tr>
+ <tr>
+ <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#UNQUOTED_CASING">unquotedCasing</a></td>
+ <td style="text-align: left">How identifiers are stored if they are not quoted. Values are UNCHANGED, TO_UPPER, TO_LOWER. If not specified, value from <code>lex</code> is used.</td>
+ </tr>
+ </tbody>
+</table>
Modified: calcite/site/docs/history.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/history.html?rev=1733361&r1=1733360&r2=1733361&view=diff
==============================================================================
--- calcite/site/docs/history.html (original)
+++ calcite/site/docs/history.html Wed Mar 2 20:39:49 2016
@@ -716,13 +716,123 @@ Downloads are available on the
with <a href="http://slf4j.org/">SLF4J</a>. SLF4J provides an API which Calcite can use
independent of the logging implementation. This ultimately provides additional
flexibility to users, allowing them to configure Calciteâs logging within their
-own chosen logging framework. This work was done in <a href="https://issues.apache.org/jira/browse/CALCITE-669">CALCITE-669</a>.</p>
+own chosen logging framework. This work was done in
+[<a href="https://issues.apache.org/jira/browse/CALCITE-669">CALCITE-669</a>].</p>
<p>For users experienced with configuring JUL in Calcite previously, there are some
differences as some the JUL logging levels do not exist in SLF4J: <code>FINE</code>,
<code>FINER</code>, and <code>FINEST</code>, specifically. To deal with this, <code>FINE</code> was mapped
to SLF4Jâs <code>DEBUG</code> level, while <code>FINER</code> and <code>FINEST</code> were mapped to SLF4Jâs <code>TRACE</code>.</p>
+<p>Compatibility: This release is tested
+on Linux, Mac OS X, Microsoft Windows;
+using Oracle JDK 1.7, 1.8;
+Guava versions 13.0.1 to 19.0;
+other software versions as specified in <code>pom.xml</code>.</p>
+
+<p>New features</p>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1066">CALCITE-1066</a>]
+Add Oracle function table, and functions <code>DECODE</code>, <code>NVL</code>, <code>LTRIM</code>, <code>RTRIM</code>,
+<code>GREATEST</code>, <code>LEAST</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1080">CALCITE-1080</a>]
+Cassandra adapter (Michael Mior)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1062">CALCITE-1062</a>]
+In validation, lookup a (possibly overloaded) operator from an operator
+table (Hsuan-Yi Chu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-551">CALCITE-551</a>]
+Sub-query inside aggregate function</li>
+</ul>
+
+<p>Avatica features and bug fixes</p>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-642">CALCITE-642</a>]
+Add an avatica-metrics API
+ <ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1085">CALCITE-1085</a>]
+Use a NoopContext singleton in NoopTimer</li>
+ </ul>
+ </li>
+</ul>
+
+<p>Planner rules</p>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1109">CALCITE-1109</a>]
+Fix up condition when pushing <code>Filter</code> through <code>Aggregate</code> (Amogh Margoor)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1100">CALCITE-1100</a>]
+If constant reduction no-ops, donât create a new <code>RelNode</code> (Hsuan-Yi Chu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1076">CALCITE-1076</a>]
+Update <code>RelMdDistribution</code> to match other metadata APIs (Ted Xu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1056">CALCITE-1056</a>]
+In <code>RelBuilder</code>, simplify predicates, and optimize away <code>WHERE FALSE</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1059">CALCITE-1059</a>]
+Not valid to convert <code>Aggregate</code> on empty to empty if its <code>GROUP BY</code> key is empty</li>
+</ul>
+
+<p>Bug fixes, API changes and minor enhancements</p>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1111">CALCITE-1111</a>]
+Upgrade Guava, and test on a range of Guava versions</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1054">CALCITE-1054</a>]
+Wrong code generation for <code>TIMESTAMP</code> values that may be <code>NULL</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-604">CALCITE-604</a>]
+Tune metadata by generating a dispatcher at runtime</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1063">CALCITE-1063</a>]
+Flat lists for 4, 5, 6 elements</li>
+ <li>Add Orinoco schema (streaming retail data), accessible from Quidem scripts</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1097">CALCITE-1097</a>]
+Exception when executing query with too many aggregation columns (chenzhifa)</li>
+ <li>Add tests for leap days</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-553">CALCITE-553</a>]
+In maven, enable compiler profiles by default</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1031">CALCITE-1031</a>]
+In prepared statement, <code>CsvScannableTable.scan</code> is called twice</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1046">CALCITE-1046</a>]
+Matchers for testing SQL query results</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1083">CALCITE-1083</a>]
+<code>SqlNode.equalsDeep</code> has O(n ^ 2) performance</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-998">CALCITE-998</a>]
+Exception when calling <code>STDDEV_SAMP</code>, <code>STDDEV_POP</code> (Matthew Shaer)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1071">CALCITE-1071</a>]
+Improve hash functions</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1072">CALCITE-1072</a>]
+CSV adapter incorrectly parses <code>TIMESTAMP</code> values after noon (Chris Albright)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-669">CALCITE-669</a>]
+Mass removal of Java Logging for SLF4J</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1068">CALCITE-1068</a>]
+Deprecate <code>Stacks</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1067">CALCITE-1067</a>]
+Test failures due to clashing temporary table names</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-864">CALCITE-864</a>]
+Correlation variable has incorrect row type if it is populated by right side
+of a Join</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1021">CALCITE-1021</a>]
+Upgrade Jackson</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-999">CALCITE-999</a>]
+Clean up maven POM files</li>
+</ul>
+
+<p>Web site and documentation</p>
+
+<ul>
+ <li>Add SQL-Gremlin to Adapters page</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1090">CALCITE-1090</a>]
+Revise Streaming SQL specification</li>
+ <li>Appoint Josh Elser to PMC</li>
+ <li>Add âStreaming SQLâ talk</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-623">CALCITE-623</a>]
+Add a small blurb to the site about Jenkins for CI</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1070">CALCITE-1070</a>]
+Upgrade to new Apache logo</li>
+ <li>Document how to announce a release</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1074">CALCITE-1074</a>]
+Delete old releases from mirroring system</li>
+</ul>
+
<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
@@ -755,6 +865,11 @@ cyclic metadata calls and produce a safe
request. It will also allow us to add finer-grained caching and
further tune the metadata layer.</p>
+<p>Compatibility: This release is tested
+on Linux, Mac OS X, Microsoft Windows;
+using Oracle JDK 1.7, 1.8;
+other software versions as specified in <code>pom.xml</code>.</p>
+
<p>New features</p>
<ul>
Modified: calcite/site/docs/howto.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/howto.html?rev=1733361&r1=1733360&r2=1733361&view=diff
==============================================================================
--- calcite/site/docs/howto.html (original)
+++ calcite/site/docs/howto.html Wed Mar 2 20:39:49 2016
@@ -1130,13 +1130,30 @@ mvn -Papache-release -Dgpg.passphrase<sp
<li>Make sure you are using JDK 1.7 (not 1.8).</li>
<li>Check that <code>README</code> and <code>site/_docs/howto.md</code> have the correct version number.</li>
<li>Set <code>version.major</code> and <code>version.minor</code> in <code>pom.xml</code>.</li>
- <li>Make sure build and tests succeed, including with
--Dcalcite.test.db={mysql,hsqldb}, -Dcalcite.test.slow,
--Dcalcite.test.mongodb, -Dcalcite.test.splunk.</li>
+ <li>Make sure build and tests succeed, including with <code>-P it,it-oracle</code>.
+Supported configurations are:
+ <ul>
+ <li>JDK 1.7, 1.8;</li>
+ <li>Linux, Mac OS X, and Windows;</li>
+ <li>Guava versions 13.0.1, 18.0 (the default) and 19.0 (specify <code>-Dguava.version=x.y</code>)</li>
+ </ul>
+ </li>
+ <li>Optional extra tests:
+ <ul>
+ <li><code>-Dcalcite.test.db=mysql</code></li>
+ <li><code>-Dcalcite.test.db=hsqldb</code></li>
+ <li><code>-Dcalcite.test.slow</code></li>
+ <li><code>-Dcalcite.test.mongodb</code></li>
+ <li><code>-Dcalcite.test.splunk</code></li>
+ </ul>
+ </li>
<li>Trigger a
<a href="https://scan.coverity.com/projects/2966">Coverity scan</a>
by merging the latest code into the <code>julianhyde/coverity_scan</code> branch,
and when it completes, make sure that there are no important issues.</li>
+ <li>Add release notes to <code>site/_docs/history.md</code>. Include the commit history,
+and say which versions of Java, Guava and operating systems the release is
+tested against. </li>
<li>Make sure that
<a href="https://issues.apache.org/jira/issues/?jql=project%20%3D%20CALCITE%20AND%20status%20%3D%20Resolved%20and%20fixVersion%20is%20null">
every âresolvedâ JIRA case</a> (including duplicates) has