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/06/12 08:33:23 UTC
svn commit: r1747967 [3/4] - in /calcite/site: community/ css/ docs/
Added: calcite/site/docs/elasticsearch_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/elasticsearch_adapter.html?rev=1747967&view=auto
==============================================================================
--- calcite/site/docs/elasticsearch_adapter.html (added)
+++ calcite/site/docs/elasticsearch_adapter.html Sun Jun 12 08:33:22 2016
@@ -0,0 +1,2158 @@
+<!DOCTYPE HTML>
+<html lang="en-US">
+<head>
+ <meta charset="UTF-8">
+ <title>Elasticsearch adapter</title>
+ <meta name="viewport" content="width=device-width,initial-scale=1">
+ <meta name="generator" content="Jekyll v3.0.3">
+ <link rel="stylesheet" href="//fonts.googleapis.com/css?family=Lato:300,300italic,400,400italic,700,700italic,900">
+ <link rel="stylesheet" href="/css/screen.css">
+ <link rel="icon" type="image/x-icon" href="/favicon.ico">
+ <!--[if lt IE 9]>
+ <script src="/js/html5shiv.min.js"></script>
+ <script src="/js/respond.min.js"></script>
+ <![endif]-->
+</head>
+
+
+<body class="wrap">
+ <header role="banner">
+ <nav class="mobile-nav show-on-mobiles">
+ <ul>
+ <li class="">
+ <a href="/">Home</a>
+ </li>
+ <li class="">
+ <a href="/downloads/">Download</a>
+ </li>
+ <li class="">
+ <a href="/community/">Community</a>
+ </li>
+ <li class="">
+ <a href="/develop/">Develop</a>
+ </li>
+ <li class="">
+ <a href="/news/">News</a>
+ </li>
+ <li class="current">
+ <a href="/docs/">Docs</a>
+ </li>
+</ul>
+
+ </nav>
+ <div class="grid">
+ <div class="unit one-third center-on-mobiles">
+ <h1>
+ <a href="/">
+ <span class="sr-only">Apache Calcite</span>
+ <img src="/img/logo.png" width="226" height="140" alt="Calcite Logo">
+ </a>
+ </h1>
+ </div>
+ <nav class="main-nav unit two-thirds hide-on-mobiles">
+ <ul>
+ <li class="">
+ <a href="/">Home</a>
+ </li>
+ <li class="">
+ <a href="/downloads/">Download</a>
+ </li>
+ <li class="">
+ <a href="/community/">Community</a>
+ </li>
+ <li class="">
+ <a href="/develop/">Develop</a>
+ </li>
+ <li class="">
+ <a href="/news/">News</a>
+ </li>
+ <li class="current">
+ <a href="/docs/">Docs</a>
+ </li>
+</ul>
+
+ </nav>
+ </div>
+</header>
+
+
+ <section class="docs">
+ <div class="grid">
+
+ <div class="docs-nav-mobile unit whole show-on-mobiles">
+ <select onchange="if (this.value) window.location.href=this.value">
+ <option value="">Navigate the docs…</option>
+
+ <optgroup label="Overview">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </optgroup>
+
+ <optgroup label="Advanced">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </optgroup>
+
+ <optgroup label="Avatica">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </optgroup>
+
+ <optgroup label="Reference">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </optgroup>
+
+ <optgroup label="Meta">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </optgroup>
+
+ </select>
+</div>
+
+
+ <div class="unit four-fifths">
+ <article>
+ <h1>Elasticsearch adapter</h1>
+ <!--
+
+-->
+
+<p>For instructions on downloading and building Calcite, start with the
+<a href="/docs/tutorial.html">tutorial</a>.</p>
+
+<p>Once you’ve managed to compile the project, you can return here to
+start querying Elasticsearch with Calcite. First, we need a
+<a href="/docs/model.html">model definition</a>.
+The model gives Calcite the necessary parameters to create an instance
+of the Elasticsearch adapter. The models can contain
+definitions of
+<a href="/docs/model.html#materialization">materializations</a>.
+The name of the tables defined in the model definition corresponds to
+<a href="https://www.elastic.co/blog/what-is-an-elasticsearch-index">types</a> in
+Elasticsearch. The schema/database is represented by the <code class="highlighter-rouge">index</code> parameter
+in the model definition.</p>
+
+<p>A basic example of a model file is given below:</p>
+
+<figure class="highlight"><pre><code class="language-json" data-lang="json"><span class="p">{</span><span class="w">
+ </span><span class="nt">"version"</span><span class="p">:</span><span class="w"> </span><span class="s2">"1.0"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"defaultSchema"</span><span class="p">:</span><span class="w"> </span><span class="s2">"elasticsearch"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"schemas"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="w">
+ </span><span class="p">{</span><span class="w">
+ </span><span class="nt">"type"</span><span class="p">:</span><span class="w"> </span><span class="s2">"custom"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"elasticsearch"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"factory"</span><span class="p">:</span><span class="w"> </span><span class="s2">"org.apache.calcite.adapter.elasticsearch.ElasticsearchSchemaFactory"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"operand"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w">
+ </span><span class="nt">"coordinates"</span><span class="p">:</span><span class="w"> </span><span class="s2">"{'127.0.0.1': 9300}"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"userConfig"</span><span class="p">:</span><span class="w"> </span><span class="s2">"{'bulk.flush.max.actions': 10, 'bulk.flush.max.size.mb': 1}"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"index"</span><span class="p">:</span><span class="w"> </span><span class="s2">"usa"</span><span class="w">
+ </span><span class="p">}</span><span class="w">
+ </span><span class="p">}</span><span class="w">
+ </span><span class="p">]</span><span class="w">
+</span><span class="p">}</span></code></pre></figure>
+
+<p>Assuming this file is stored as <code class="highlighter-rouge">model.json</code>, you can connect to
+Elasticsearch via <a href="https://github.com/julianhyde/sqlline"><code class="highlighter-rouge">sqlline</code></a> as
+follows:</p>
+
+<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="gp">$ </span>./sqlline
+<span class="gp">sqlline> </span>!connect jdbc:calcite:model<span class="o">=</span>model.json admin admin</code></pre></figure>
+
+<p><code class="highlighter-rouge">sqlline</code> will now accept SQL queries which access your Elasticsearch types.
+The purpose of this adapter is to compile the query into the most efficient
+Elasticsearch SEARCH JSON possible by exploiting filtering and sorting directly
+in Elasticsearch where possible.</p>
+
+<p>For example, in the example dataset there is an Elasticsearch type
+named <code class="highlighter-rouge">zips</code> under index named <code class="highlighter-rouge">usa</code>.</p>
+
+<p>We can issue a simple query to fetch the names of all the states
+stored in the type <code class="highlighter-rouge">zips</code>. By default, Elasticsearch returns only 10 rows:</p>
+
+<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="n">sqlline</span><span class="o">></span> <span class="k">SELECT</span> <span class="o">*</span> <span class="k">from</span> <span class="nv">"zips"</span><span class="p">;</span></code></pre></figure>
+
+<figure class="highlight"><pre><code class="language-json" data-lang="json"><span class="err">_MAP=</span><span class="p">{</span><span class="err">pop=13367,</span><span class="w"> </span><span class="err">loc=[-72.505565,</span><span class="w"> </span><span class="err">42.067203],</span><span class="w"> </span><span class="err">city=EAST</span><span class="w"> </span><span class="err">LONGMEADOW,</span><span class="w"> </span><span class="err">id=01028,</span><span class="w"> </span><span class="err">state=MA</span><span class="p">}</span><span class="w">
+</span><span class="err">_MAP=</span><span class="p">{</span><span class="err">pop=1652,</span><span class="w"> </span><span class="err">loc=[-72.908793,</span><span class="w"> </span><span class="err">42.070234],</span><span class="w"> </span><span class="err">city=TOLLAND,</span><span class="w"> </span><span class="err">id=01034,</span><span class="w"> </span><span class="err">state=MA</span><span class="p">}</span><span class="w">
+</span><span class="err">_MAP=</span><span class="p">{</span><span class="err">pop=3184,</span><span class="w"> </span><span class="err">loc=[-72.616735,</span><span class="w"> </span><span class="err">42.38439],</span><span class="w"> </span><span class="err">city=HATFIELD,</span><span class="w"> </span><span class="err">id=01038,</span><span class="w"> </span><span class="err">state=MA</span><span class="p">}</span><span class="w">
+</span><span class="err">_MAP=</span><span class="p">{</span><span class="err">pop=43704,</span><span class="w"> </span><span class="err">loc=[-72.626193,</span><span class="w"> </span><span class="err">42.202007],</span><span class="w"> </span><span class="err">city=HOLYOKE,</span><span class="w"> </span><span class="err">id=01040,</span><span class="w"> </span><span class="err">state=MA</span><span class="p">}</span><span class="w">
+</span><span class="err">_MAP=</span><span class="p">{</span><span class="err">pop=2084,</span><span class="w"> </span><span class="err">loc=[-72.873341,</span><span class="w"> </span><span class="err">42.265301],</span><span class="w"> </span><span class="err">city=HUNTINGTON,</span><span class="w"> </span><span class="err">id=01050,</span><span class="w"> </span><span class="err">state=MA</span><span class="p">}</span><span class="w">
+</span><span class="err">_MAP=</span><span class="p">{</span><span class="err">pop=1350,</span><span class="w"> </span><span class="err">loc=[-72.703403,</span><span class="w"> </span><span class="err">42.354292],</span><span class="w"> </span><span class="err">city=LEEDS,</span><span class="w"> </span><span class="err">id=01053,</span><span class="w"> </span><span class="err">state=MA</span><span class="p">}</span><span class="w">
+</span><span class="err">_MAP=</span><span class="p">{</span><span class="err">pop=8194,</span><span class="w"> </span><span class="err">loc=[-72.319634,</span><span class="w"> </span><span class="err">42.101017],</span><span class="w"> </span><span class="err">city=MONSON,</span><span class="w"> </span><span class="err">id=01057,</span><span class="w"> </span><span class="err">state=MA</span><span class="p">}</span><span class="w">
+</span><span class="err">_MAP=</span><span class="p">{</span><span class="err">pop=1732,</span><span class="w"> </span><span class="err">loc=[-72.204592,</span><span class="w"> </span><span class="err">42.062734],</span><span class="w"> </span><span class="err">city=WALES,</span><span class="w"> </span><span class="err">id=01081,</span><span class="w"> </span><span class="err">state=MA</span><span class="p">}</span><span class="w">
+</span><span class="err">_MAP=</span><span class="p">{</span><span class="err">pop=9808,</span><span class="w"> </span><span class="err">loc=[-72.258285,</span><span class="w"> </span><span class="err">42.261831],</span><span class="w"> </span><span class="err">city=WARE,</span><span class="w"> </span><span class="err">id=01082,</span><span class="w"> </span><span class="err">state=MA</span><span class="p">}</span><span class="w">
+</span><span class="err">_MAP=</span><span class="p">{</span><span class="err">pop=4441,</span><span class="w"> </span><span class="err">loc=[-72.203639,</span><span class="w"> </span><span class="err">42.20734],</span><span class="w"> </span><span class="err">city=WEST</span><span class="w"> </span><span class="err">WARREN,</span><span class="w"> </span><span class="err">id=01092,</span><span class="w"> </span><span class="err">state=MA</span><span class="p">}</span></code></pre></figure>
+
+<p>While executing this query, the Elasticsearch adapter is able to recognize
+that <code class="highlighter-rouge">city</code> can be filtered by Elasticsearch and <code class="highlighter-rouge">state</code> can be sorted by
+Elasticsearch in ascending order.</p>
+
+<p>The final source json given to Elasticsearch is below:</p>
+
+<figure class="highlight"><pre><code class="language-json" data-lang="json"><span class="p">{</span><span class="w">
+ </span><span class="nt">"query"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w">
+ </span><span class="nt">"constant_score"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w">
+ </span><span class="nt">"filter"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w">
+ </span><span class="nt">"bool"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w">
+ </span><span class="nt">"must"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="w">
+ </span><span class="p">{</span><span class="w">
+ </span><span class="nt">"term"</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="w">
+ </span><span class="nt">"city"</span><span class="p">:</span><span class="w"> </span><span class="s2">"springfield"</span><span class="w">
+ </span><span class="p">}</span><span class="w">
+ </span><span class="p">}</span><span class="w">
+ </span><span class="p">]</span><span class="w">
+ </span><span class="p">}</span><span class="w">
+ </span><span class="p">}</span><span class="w">
+ </span><span class="p">}</span><span class="w">
+ </span><span class="p">},</span><span class="w">
+ </span><span class="nt">"fields"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="w">
+ </span><span class="s2">"city"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"state"</span><span class="w">
+ </span><span class="p">],</span><span class="w">
+ </span><span class="nt">"script_fields"</span><span class="p">:</span><span class="w"> </span><span class="p">{},</span><span class="w">
+ </span><span class="nt">"sort"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="w">
+ </span><span class="p">{</span><span class="w">
+ </span><span class="nt">"state"</span><span class="p">:</span><span class="w"> </span><span class="s2">"asc"</span><span class="w">
+ </span><span class="p">}</span><span class="w">
+ </span><span class="p">]</span><span class="w">
+</span><span class="p">}</span></code></pre></figure>
+
+<p>This is the initial version of the Calcite Elasticsearch adapter.
+Work is in progress to introduce new features like aggregations into
+it.</p>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </article>
+ </div>
+
+ <div class="unit one-fifth hide-on-mobiles">
+ <aside>
+
+ <h4>Overview</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/index.html">Background</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/algebra.html">Algebra</a></li>
+
+
+
+</ul>
+
+
+ <h4>Advanced</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/adapter.html">Adapters</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/stream.html">Streaming</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/lattice.html">Lattices</a></li>
+
+
+
+</ul>
+
+
+ <h4>Avatica</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/avatica_overview.html">Overview</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li>
+
+
+
+</ul>
+
+
+ <h4>Reference</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/reference.html">SQL language</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/model.html">JSON models</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/howto.html">HOWTO</a></li>
+
+
+
+</ul>
+
+
+ <h4>Meta</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/history.html">History</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/api/">API</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/testapi/">Test API</a></li>
+
+
+
+</ul>
+
+
+ </aside>
+</div>
+
+
+ <div class="clear"></div>
+
+ </div>
+ </section>
+
+
+ <footer role="contentinfo">
+ <div id="poweredby">
+ <a href="http://www.apache.org/">
+ <span class="sr-only">Apache</span>
+ <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
+ <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">
+ Apache License v2</a>. Apache Calcite and its logo are
+ trademarks of the Apache Software Foundation.</p>
+ </div>
+</footer>
+
+ <script>
+ var anchorForId = function (id) {
+ var anchor = document.createElement("a");
+ anchor.className = "header-link";
+ anchor.href = "#" + id;
+ anchor.innerHTML = "<span class=\"sr-only\">Permalink</span><i class=\"fa fa-link\"></i>";
+ anchor.title = "Permalink";
+ return anchor;
+ };
+
+ var linkifyAnchors = function (level, containingElement) {
+ var headers = containingElement.getElementsByTagName("h" + level);
+ for (var h = 0; h < headers.length; h++) {
+ var header = headers[h];
+
+ if (typeof header.id !== "undefined" && header.id !== "") {
+ header.appendChild(anchorForId(header.id));
+ }
+ }
+ };
+
+ document.onreadystatechange = function () {
+ if (this.readyState === "complete") {
+ var contentBlock = document.getElementsByClassName("docs")[0] || document.getElementsByClassName("news")[0];
+ if (!contentBlock) {
+ return;
+ }
+ for (var level = 1; level <= 6; level++) {
+ linkifyAnchors(level, contentBlock);
+ }
+ }
+ };
+</script>
+
+
+</body>
+</html>
Modified: calcite/site/docs/history.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/history.html?rev=1747967&r1=1747966&r2=1747967&view=diff
==============================================================================
--- calcite/site/docs/history.html (original)
+++ calcite/site/docs/history.html Sun Jun 12 08:33:22 2016
@@ -128,6 +128,10 @@
+
+
+
+
@@ -170,6 +174,10 @@
+
+
+
+
@@ -212,6 +220,10 @@
+
+
+
+
</optgroup>
@@ -261,6 +273,10 @@
+
+
+
+
@@ -303,6 +319,10 @@
+
+
+
+
@@ -345,6 +365,10 @@
+
+
+
+
</optgroup>
@@ -394,6 +418,10 @@
+
+
+
+
@@ -436,6 +464,10 @@
+
+
+
+
@@ -478,6 +510,10 @@
+
+
+
+
@@ -520,6 +556,10 @@
+
+
+
+
</optgroup>
@@ -569,6 +609,10 @@
+
+
+
+
@@ -611,6 +655,10 @@
+
+
+
+
@@ -653,6 +701,10 @@
+
+
+
+
</optgroup>
@@ -702,6 +754,10 @@
+
+
+
+
@@ -744,6 +800,10 @@
+
+
+
+
@@ -786,6 +846,10 @@
+
+
+
+
@@ -828,6 +892,10 @@
+
+
+
+
</optgroup>
@@ -848,6 +916,188 @@
Downloads are available on the
<a href="/downloads/">downloads page</a>.</p>
+<h2 id="v1-8-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.8.0">1.8.0</a> / 2016-06-13</h2>
+
+<p>This release adds adapters for
+<a href="https://issues.apache.org/jira/browse/CALCITE-1253">Elasticsearch</a> and
+<a href="https://issues.apache.org/jira/browse/CALCITE-1121">Druid</a>.
+It is also now easier to
+<a href="https://issues.apache.org/jira/browse/CALCITE-1259">make a JDBC connection based upon a single adapter</a>.</p>
+
+<p>There are several new SQL features: <code class="highlighter-rouge">UNNEST</code> with
+<a href="https://issues.apache.org/jira/browse/CALCITE-855">multiple arguments</a>,
+<a href="https://issues.apache.org/jira/browse/CALCITE-1250">MAP arguments</a>
+and <a href="https://issues.apache.org/jira/browse/CALCITE-1225">with a JOIN</a>;
+a <a href="https://issues.apache.org/jira/browse/CALCITE-1168">DESCRIBE</a> statement;
+and a <a href="https://issues.apache.org/jira/browse/CALCITE-1115">TRANSLATE</a>
+function like the one in Oracle and PostgreSQL.
+We also added support for
+<a href="https://issues.apache.org/jira/browse/CALCITE-1120">SELECT without FROM</a>
+(equivalent to the <code class="highlighter-rouge">VALUES</code> clause, and widely used in MySQL and PostgreSQL),
+and added a
+<a href="/docs/adapter.html#jdbc-connect-string-parameters">conformance</a>
+parameter to allow you to selectively enable this and other SQL features.</p>
+
+<p>And a couple of dozen bug-fixes and enhancements to planner rules and APIs.</p>
+
+<p>Compatibility: This release is tested
+on Linux, Mac OS X, Microsoft Windows;
+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>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1177">CALCITE-1177</a>]
+Extend list of supported time units in <code class="highlighter-rouge">EXTRACT</code>, <code class="highlighter-rouge">CEIL</code> and <code class="highlighter-rouge">FLOOR</code> functions
+(Venki Korukanti)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1259">CALCITE-1259</a>]
+Allow connecting to a single schema without writing a model</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-750">CALCITE-750</a>]
+Support aggregates within windowed aggregates (Gautam Parai)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1250">CALCITE-1250</a>]
+<code class="highlighter-rouge">UNNEST</code> applied to <code class="highlighter-rouge">MAP</code> data type (Johannes Schulte)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1253">CALCITE-1253</a>]
+Elasticsearch adapter (Subhobrata Dey)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1228">CALCITE-1228</a>]
+Bind parameters in <code class="highlighter-rouge">INSERT</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1120">CALCITE-1120</a>]
+<code class="highlighter-rouge">SELECT</code> without <code class="highlighter-rouge">FROM</code> (Jimmy Xiang)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-855">CALCITE-855</a>]
+<code class="highlighter-rouge">UNNEST</code> with multiple arguments</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1225">CALCITE-1225</a>]
+<code class="highlighter-rouge">UNNEST</code> with <code class="highlighter-rouge">JOIN</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1115">CALCITE-1115</a>]
+Add <code class="highlighter-rouge">TRANSLATE</code> function with 3 parameters, like the one in Oracle (Javanshir
+Yelchiyev)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1168">CALCITE-1168</a>]
+Add <code class="highlighter-rouge">DESCRIBE</code> statement (Arina Ielchiieva)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1121">CALCITE-1121</a>]
+Druid adapter
+ <ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1276">CALCITE-1276</a>]
+In Druid adapter, deduce tables and columns if not specified</li>
+ </ul>
+ </li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1207">CALCITE-1207</a>]
+Allow numeric connection properties, and ‘K’, ‘M’, ‘G’ suffixes</li>
+</ul>
+
+<p>Planner rules</p>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1235">CALCITE-1235</a>]
+Fully push down <code class="highlighter-rouge">LIMIT</code> + <code class="highlighter-rouge">OFFSET</code> in Cassandra</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1216">CALCITE-1216</a>]
+Rule to convert <code class="highlighter-rouge">Filter</code>-on-<code class="highlighter-rouge">Scan</code> to materialized view (Amogh Margoor)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1200">CALCITE-1200</a>]
+Extend <code class="highlighter-rouge">RelOptUtil.splitJoinCondition</code> to handle <code class="highlighter-rouge">IS NOT DISTINCT FROM</code>
+(Venki Korukanti)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1211">CALCITE-1211</a>]
+Allow free use of <code class="highlighter-rouge">CassandraSort</code> for <code class="highlighter-rouge">LIMIT</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1210">CALCITE-1210</a>]
+Allow UUID filtering in Cassandra</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1182">CALCITE-1182</a>]
+Add <code class="highlighter-rouge">ProjectRemoveRule</code> to pre-processing program of materialization
+substitution</li>
+</ul>
+
+<p>Bug fixes, API changes and minor enhancements</p>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1281">CALCITE-1281</a>]
+Druid adapter wrongly returns all numeric values as <code class="highlighter-rouge">int</code> or <code class="highlighter-rouge">float</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1279">CALCITE-1279</a>]
+Druid “select” query gives <code class="highlighter-rouge">ClassCastException</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1277">CALCITE-1277</a>]
+Rat fails on source distribution due to <code class="highlighter-rouge">git.properties</code></li>
+ <li>Update KEYS</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1252">CALCITE-1252</a>]
+Handle <code class="highlighter-rouge">ANY</code> type in <code class="highlighter-rouge">RexBuilder.ensureType</code> and <code class="highlighter-rouge">TypeFactory.leastRestrictive</code>
+(Mehand Baid, Minji Kim)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1151">CALCITE-1151</a>]
+Fix <code class="highlighter-rouge">SqlSetOption</code> to correctly handle <code class="highlighter-rouge">SqlOperator.createCall</code>
+(Sudheesh Katkam, Minji Kim)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1106">CALCITE-1106</a>]
+Expose constructor for <code class="highlighter-rouge">ProjectJoinTransposeRule</code> (Minji Kim)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1107">CALCITE-1107</a>]
+Make <code class="highlighter-rouge">SqlSumEmptyIsZeroAggFunction</code> constructor public (Minji Kim)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1269">CALCITE-1269</a>]
+Replace <code class="highlighter-rouge">IntList</code> with Guava <code class="highlighter-rouge">Ints</code> class</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1239">CALCITE-1239</a>]
+Upgrade to avatica-1.8.0</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1266">CALCITE-1266</a>]
+<code class="highlighter-rouge">RelBuilder.field</code> gets offsets wrong</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1264">CALCITE-1264</a>]
+<code class="highlighter-rouge">Litmus</code> argument interpolation (Chris Baynes)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1245">CALCITE-1245</a>]
+Allow <code class="highlighter-rouge">RelBuilder.scan</code> to take qualified table name (Chris Baynes)</li>
+ <li>Move code from <code class="highlighter-rouge">Enumerables</code> to <code class="highlighter-rouge">EnumerableDefaults</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1246">CALCITE-1246</a>]
+Cleanup duplicate variables in <code class="highlighter-rouge">JoinPushThroughJoinRule</code> (Yi Xinglu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1241">CALCITE-1241</a>]
+Add a Freemarker variable for adding non reserved keyword list to <code class="highlighter-rouge">Parser.jj</code>
+template (Venki Korukanti)
+ <ul>
+ <li>Create a table in <code class="highlighter-rouge">SqlParserTest</code> of reserved keywords from various versions
+of the SQL standard</li>
+ </ul>
+ </li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1150">CALCITE-1150</a>]
+Add dynamic record type and dynamic star for schema-on-read table</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1238">CALCITE-1238</a>]
+Unparsing a query with <code class="highlighter-rouge">LIMIT</code> but no <code class="highlighter-rouge">ORDER BY</code> gives invalid SQL (Emmanuel
+Bastien)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1230">CALCITE-1230</a>]
+Add SQLSTATE reference data as <code class="highlighter-rouge">enum SqlState</code> in Avatica, and
+deprecate <code class="highlighter-rouge">SqlStateCodes</code> in Calcite</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1199">CALCITE-1199</a>]
+Incorrect trimming of <code class="highlighter-rouge">CHAR</code> when performing cast to <code class="highlighter-rouge">VARCHAR</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1219">CALCITE-1219</a>]
+Add method <code class="highlighter-rouge">SqlOperatorBinding.isOperandLiteral()</code> (Hsuan-Yi Chu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1222">CALCITE-1222</a>]
+<code class="highlighter-rouge">DatabaseMetaData.getColumnLabel</code> returns null when query has <code class="highlighter-rouge">ORDER BY</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1215">CALCITE-1215</a>]
+Fix missing override in <code class="highlighter-rouge">CassandraTable</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1212">CALCITE-1212</a>]
+Fix NPE on some Cassandra projects</li>
+ <li>Remove trailing spaces from all source files</li>
+ <li>Move HTTP utilities from Splunk adapter to core</li>
+ <li>Test case for
+[<a href="https://issues.apache.org/jira/browse/PHOENIX-2767">PHOENIX-2767</a>],
+non-constant in <code class="highlighter-rouge">IN</code></li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1166">CALCITE-1166</a>]
+Disallow sub-classes of <code class="highlighter-rouge">RelOptRuleOperand</code></li>
+ <li>Remove all calls to deprecated methods</li>
+ <li>Add class <code class="highlighter-rouge">ConsList</code></li>
+ <li>More of [<a href="https://issues.apache.org/jira/browse/CALCITE-999">CALCITE-999</a>]
+Clean up maven POM files</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1204">CALCITE-1204</a>]
+Fix invalid Javadoc and suppress checkstyle “errors”</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1170">CALCITE-1170</a>]
+Allow <code class="highlighter-rouge">SqlSetOperator</code> to be overridden, as a regular <code class="highlighter-rouge">SqlOperator</code> can
+(Hsuan-Yi Chu)</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-746">CALCITE-746</a>]
+Allow apache-rat to be run outside of release process</li>
+</ul>
+
+<p>Web site and documentation</p>
+
+<ul>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1273">CALCITE-1273</a>]
+Following
+[<a href="https://issues.apache.org/jira/browse/CALCITE-306">CALCITE-306</a>],
+update references to <code class="highlighter-rouge">EnumerableTableAccessRel</code> to <code class="highlighter-rouge">EnumerableTableScan</code></li>
+ <li>Fix typo in SQL (Yi Xinglu)</li>
+ <li>Site: add committer, and post slides/video from Polyalgebra talk</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1203">CALCITE-1203</a>]
+Update to github-pages-67</li>
+ <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1202">CALCITE-1202</a>]
+Lock version of Jekyll for bundler</li>
+ <li>Site: add upcoming talks, and fix link to Apache phonebook</li>
+</ul>
+
<h2 id="v1-7-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.7.0">1.7.0</a> / 2016-03-22</h2>
<p>This is the first Apache Calcite release since
@@ -3630,6 +3880,7 @@ conflicts in multithreaded usage</li>
+
@@ -3681,6 +3932,14 @@ conflicts in multithreaded usage</li>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -3688,6 +3947,7 @@ conflicts in multithreaded usage</li>
+
@@ -3767,6 +4027,14 @@ conflicts in multithreaded usage</li>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -3774,6 +4042,7 @@ conflicts in multithreaded usage</li>
+
@@ -3800,6 +4069,7 @@ conflicts in multithreaded usage</li>
+
@@ -3814,6 +4084,7 @@ conflicts in multithreaded usage</li>
+
@@ -3885,6 +4156,14 @@ conflicts in multithreaded usage</li>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -3892,6 +4171,7 @@ conflicts in multithreaded usage</li>
+
@@ -3947,6 +4227,14 @@ conflicts in multithreaded usage</li>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -3962,6 +4250,7 @@ conflicts in multithreaded usage</li>
+
@@ -3985,6 +4274,10 @@ conflicts in multithreaded usage</li>
+
+
+
+
<li class=""><a href="/docs/avatica_overview.html">Overview</a></li>
@@ -3992,6 +4285,7 @@ conflicts in multithreaded usage</li>
+
@@ -4023,6 +4317,10 @@ conflicts in multithreaded usage</li>
+
+
+
+
<li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li>
@@ -4030,6 +4328,7 @@ conflicts in multithreaded usage</li>
+
@@ -4049,6 +4348,10 @@ conflicts in multithreaded usage</li>
+
+
+
+
<li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li>
@@ -4056,6 +4359,7 @@ conflicts in multithreaded usage</li>
+
@@ -4083,6 +4387,10 @@ conflicts in multithreaded usage</li>
+
+
+
+
<li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li>
@@ -4098,6 +4406,7 @@ conflicts in multithreaded usage</li>
+
@@ -4165,6 +4474,14 @@ conflicts in multithreaded usage</li>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -4172,6 +4489,7 @@ conflicts in multithreaded usage</li>
+
@@ -4231,6 +4549,14 @@ conflicts in multithreaded usage</li>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -4238,6 +4564,7 @@ conflicts in multithreaded usage</li>
+
@@ -4285,6 +4612,14 @@ conflicts in multithreaded usage</li>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -4300,6 +4635,7 @@ conflicts in multithreaded usage</li>
+
@@ -4343,16 +4679,6 @@ conflicts in multithreaded usage</li>
- <li class="current"><a href="/docs/history.html">History</a></li>
-
-
-
-
-
-
-
-
-
@@ -4361,26 +4687,17 @@ conflicts in multithreaded usage</li>
+ <li class="current"><a href="/docs/history.html">History</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -4413,16 +4730,6 @@ conflicts in multithreaded usage</li>
- <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
-
-
-
-
-
-
-
-
-
@@ -4459,34 +4766,17 @@ conflicts in multithreaded usage</li>
+ <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -4499,12 +4789,14 @@ conflicts in multithreaded usage</li>
-
+ <li class=""><a href="/docs/api/">API</a></li>
+
+
@@ -4585,6 +4877,11 @@ conflicts in multithreaded usage</li>
+
+
+
+ <li class=""><a href="/docs/testapi/">Test API</a></li>
+
</ul>
Modified: calcite/site/docs/howto.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/howto.html?rev=1747967&r1=1747966&r2=1747967&view=diff
==============================================================================
--- calcite/site/docs/howto.html (original)
+++ calcite/site/docs/howto.html Sun Jun 12 08:33:22 2016
@@ -128,6 +128,10 @@
+
+
+
+
@@ -170,6 +174,10 @@
+
+
+
+
@@ -212,6 +220,10 @@
+
+
+
+
</optgroup>
@@ -261,6 +273,10 @@
+
+
+
+
@@ -303,6 +319,10 @@
+
+
+
+
@@ -345,6 +365,10 @@
+
+
+
+
</optgroup>
@@ -394,6 +418,10 @@
+
+
+
+
@@ -436,6 +464,10 @@
+
+
+
+
@@ -478,6 +510,10 @@
+
+
+
+
@@ -520,6 +556,10 @@
+
+
+
+
</optgroup>
@@ -569,6 +609,10 @@
+
+
+
+
@@ -611,6 +655,10 @@
+
+
+
+
@@ -653,6 +701,10 @@
+
+
+
+
</optgroup>
@@ -702,6 +754,10 @@
+
+
+
+
@@ -744,6 +800,10 @@
+
+
+
+
@@ -786,6 +846,10 @@
+
+
+
+
@@ -828,6 +892,10 @@
+
+
+
+
</optgroup>
@@ -894,8 +962,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.7.0-source.tar.gz
-<span class="gp">$ </span><span class="nb">cd </span>calcite-1.7.0
+<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="gp">$ </span>tar xvfz calcite-1.8.0-source.tar.gz
+<span class="gp">$ </span><span class="nb">cd </span>calcite-1.8.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
@@ -966,7 +1034,7 @@ Splunk must be installed and running.</l
<h2 id="running-integration-tests">Running integration tests</h2>
<p>For testing Calcite’s external adapters, a test virtual machine should be used.
-The VM includes H2, HSQLDB, MySQL, MongoDB, and PostgreSQL.</p>
+The VM includes Cassandra, Druid, H2, HSQLDB, MySQL, MongoDB, and PostgreSQL.</p>
<p>Test VM requires 5GiB of disk space and it takes 30 minutes to build.</p>
@@ -1700,6 +1768,7 @@ as a template. Be sure to include a brie
+
@@ -1751,6 +1820,14 @@ as a template. Be sure to include a brie
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -1758,6 +1835,7 @@ as a template. Be sure to include a brie
+
@@ -1837,6 +1915,14 @@ as a template. Be sure to include a brie
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -1844,6 +1930,7 @@ as a template. Be sure to include a brie
+
@@ -1870,6 +1957,7 @@ as a template. Be sure to include a brie
+
@@ -1884,6 +1972,7 @@ as a template. Be sure to include a brie
+
@@ -1955,6 +2044,14 @@ as a template. Be sure to include a brie
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -1962,6 +2059,7 @@ as a template. Be sure to include a brie
+
@@ -2017,6 +2115,14 @@ as a template. Be sure to include a brie
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -2032,6 +2138,7 @@ as a template. Be sure to include a brie
+
@@ -2055,6 +2162,10 @@ as a template. Be sure to include a brie
+
+
+
+
<li class=""><a href="/docs/avatica_overview.html">Overview</a></li>
@@ -2062,6 +2173,7 @@ as a template. Be sure to include a brie
+
@@ -2093,6 +2205,10 @@ as a template. Be sure to include a brie
+
+
+
+
<li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li>
@@ -2100,6 +2216,7 @@ as a template. Be sure to include a brie
+
@@ -2119,6 +2236,10 @@ as a template. Be sure to include a brie
+
+
+
+
<li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li>
@@ -2126,6 +2247,7 @@ as a template. Be sure to include a brie
+
@@ -2153,6 +2275,10 @@ as a template. Be sure to include a brie
+
+
+
+
<li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li>
@@ -2168,6 +2294,7 @@ as a template. Be sure to include a brie
+
@@ -2235,6 +2362,14 @@ as a template. Be sure to include a brie
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -2242,6 +2377,7 @@ as a template. Be sure to include a brie
+
@@ -2301,6 +2437,14 @@ as a template. Be sure to include a brie
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -2308,6 +2452,7 @@ as a template. Be sure to include a brie
+
@@ -2355,6 +2500,14 @@ as a template. Be sure to include a brie
+
+
+
+
+
+
+
+
<li class="current"><a href="/docs/howto.html">HOWTO</a></li>
@@ -2370,17 +2523,10 @@ as a template. Be sure to include a brie
-
-
-
-
-
-
-
-
+
@@ -2413,16 +2559,6 @@ as a template. Be sure to include a brie
- <li class=""><a href="/docs/history.html">History</a></li>
-
-
-
-
-
-
-
-
-
@@ -2439,26 +2575,17 @@ as a template. Be sure to include a brie
+ <li class=""><a href="/docs/history.html">History</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -2483,16 +2610,6 @@ as a template. Be sure to include a brie
- <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
-
-
-
-
-
-
-
-
-
@@ -2537,26 +2654,17 @@ as a template. Be sure to include a brie
+ <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -2569,12 +2677,14 @@ as a template. Be sure to include a brie
-
+ <li class=""><a href="/docs/api/">API</a></li>
+
+
@@ -2655,6 +2765,11 @@ as a template. Be sure to include a brie
+
+
+
+ <li class=""><a href="/docs/testapi/">Test API</a></li>
+
</ul>
Modified: calcite/site/docs/index.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/index.html?rev=1747967&r1=1747966&r2=1747967&view=diff
==============================================================================
--- calcite/site/docs/index.html (original)
+++ calcite/site/docs/index.html Sun Jun 12 08:33:22 2016
@@ -128,6 +128,10 @@
+
+
+
+
@@ -170,6 +174,10 @@
+
+
+
+
@@ -212,6 +220,10 @@
+
+
+
+
</optgroup>
@@ -261,6 +273,10 @@
+
+
+
+
@@ -303,6 +319,10 @@
+
+
+
+
@@ -345,6 +365,10 @@
+
+
+
+
</optgroup>
@@ -394,6 +418,10 @@
+
+
+
+
@@ -436,6 +464,10 @@
+
+
+
+
@@ -478,6 +510,10 @@
+
+
+
+
@@ -520,6 +556,10 @@
+
+
+
+
</optgroup>
@@ -569,6 +609,10 @@
+
+
+
+
@@ -611,6 +655,10 @@
+
+
+
+
@@ -653,6 +701,10 @@
+
+
+
+
</optgroup>
@@ -702,6 +754,10 @@
+
+
+
+
@@ -744,6 +800,10 @@
+
+
+
+
@@ -786,6 +846,10 @@
+
+
+
+
@@ -828,6 +892,10 @@
+
+
+
+
</optgroup>
@@ -998,6 +1066,7 @@ more details in the <a href="reference.h
+
@@ -1049,6 +1118,14 @@ more details in the <a href="reference.h
+
+
+
+
+
+
+
+
<li class="current"><a href="/docs/index.html">Background</a></li>
@@ -1056,6 +1133,7 @@ more details in the <a href="reference.h
+
@@ -1135,6 +1213,14 @@ more details in the <a href="reference.h
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -1142,6 +1228,7 @@ more details in the <a href="reference.h
+
@@ -1168,6 +1255,7 @@ more details in the <a href="reference.h
+
@@ -1182,6 +1270,7 @@ more details in the <a href="reference.h
+
@@ -1253,6 +1342,14 @@ more details in the <a href="reference.h
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -1260,6 +1357,7 @@ more details in the <a href="reference.h
+
@@ -1315,6 +1413,14 @@ more details in the <a href="reference.h
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -1330,6 +1436,7 @@ more details in the <a href="reference.h
+
@@ -1353,6 +1460,10 @@ more details in the <a href="reference.h
+
+
+
+
<li class=""><a href="/docs/avatica_overview.html">Overview</a></li>
@@ -1360,6 +1471,7 @@ more details in the <a href="reference.h
+
@@ -1391,6 +1503,10 @@ more details in the <a href="reference.h
+
+
+
+
<li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li>
@@ -1398,6 +1514,7 @@ more details in the <a href="reference.h
+
@@ -1417,6 +1534,10 @@ more details in the <a href="reference.h
+
+
+
+
<li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li>
@@ -1424,6 +1545,7 @@ more details in the <a href="reference.h
+
@@ -1451,6 +1573,10 @@ more details in the <a href="reference.h
+
+
+
+
<li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li>
@@ -1466,6 +1592,7 @@ more details in the <a href="reference.h
+
@@ -1533,6 +1660,14 @@ more details in the <a href="reference.h
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -1540,6 +1675,7 @@ more details in the <a href="reference.h
+
@@ -1599,6 +1735,14 @@ more details in the <a href="reference.h
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -1606,6 +1750,7 @@ more details in the <a href="reference.h
+
@@ -1653,6 +1798,14 @@ more details in the <a href="reference.h
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -1668,17 +1821,10 @@ more details in the <a href="reference.h
-
-
-
-
-
-
-
-
+
@@ -1711,16 +1857,6 @@ more details in the <a href="reference.h
- <li class=""><a href="/docs/history.html">History</a></li>
-
-
-
-
-
-
-
-
-
@@ -1737,26 +1873,17 @@ more details in the <a href="reference.h
+ <li class=""><a href="/docs/history.html">History</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -1781,16 +1908,6 @@ more details in the <a href="reference.h
- <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
-
-
-
-
-
-
-
-
-
@@ -1835,26 +1952,17 @@ more details in the <a href="reference.h
+ <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -1867,12 +1975,14 @@ more details in the <a href="reference.h
-
+ <li class=""><a href="/docs/api/">API</a></li>
+
+
@@ -1953,6 +2063,11 @@ more details in the <a href="reference.h
+
+
+
+ <li class=""><a href="/docs/testapi/">Test API</a></li>
+
</ul>
Modified: calcite/site/docs/lattice.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/lattice.html?rev=1747967&r1=1747966&r2=1747967&view=diff
==============================================================================
--- calcite/site/docs/lattice.html (original)
+++ calcite/site/docs/lattice.html Sun Jun 12 08:33:22 2016
@@ -128,6 +128,10 @@
+
+
+
+
@@ -170,6 +174,10 @@
+
+
+
+
@@ -212,6 +220,10 @@
+
+
+
+
</optgroup>
@@ -261,6 +273,10 @@
+
+
+
+
@@ -303,6 +319,10 @@
+
+
+
+
@@ -345,6 +365,10 @@
+
+
+
+
</optgroup>
@@ -394,6 +418,10 @@
+
+
+
+
@@ -436,6 +464,10 @@
+
+
+
+
@@ -478,6 +510,10 @@
+
+
+
+
@@ -520,6 +556,10 @@
+
+
+
+
</optgroup>
@@ -569,6 +609,10 @@
+
+
+
+
@@ -611,6 +655,10 @@
+
+
+
+
@@ -653,6 +701,10 @@
+
+
+
+
</optgroup>
@@ -702,6 +754,10 @@
+
+
+
+
@@ -744,6 +800,10 @@
+
+
+
+
@@ -786,6 +846,10 @@
+
+
+
+
@@ -828,6 +892,10 @@
+
+
+
+
</optgroup>
@@ -1014,6 +1082,7 @@ tiles).</p>
+
@@ -1065,6 +1134,14 @@ tiles).</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -1072,6 +1149,7 @@ tiles).</p>
+
@@ -1151,6 +1229,14 @@ tiles).</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -1158,6 +1244,7 @@ tiles).</p>
+
@@ -1184,6 +1271,7 @@ tiles).</p>
+
@@ -1198,6 +1286,7 @@ tiles).</p>
+
@@ -1269,6 +1358,14 @@ tiles).</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -1276,6 +1373,7 @@ tiles).</p>
+
@@ -1331,6 +1429,14 @@ tiles).</p>
+
+
+
+
+
+
+
+
<li class="current"><a href="/docs/lattice.html">Lattices</a></li>
@@ -1346,6 +1452,7 @@ tiles).</p>
+
@@ -1369,6 +1476,10 @@ tiles).</p>
+
+
+
+
<li class=""><a href="/docs/avatica_overview.html">Overview</a></li>
@@ -1376,6 +1487,7 @@ tiles).</p>
+
@@ -1407,6 +1519,10 @@ tiles).</p>
+
+
+
+
<li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li>
@@ -1414,6 +1530,7 @@ tiles).</p>
+
@@ -1433,6 +1550,10 @@ tiles).</p>
+
+
+
+
<li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li>
@@ -1440,6 +1561,7 @@ tiles).</p>
+
@@ -1467,6 +1589,10 @@ tiles).</p>
+
+
+
+
<li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li>
@@ -1482,6 +1608,7 @@ tiles).</p>
+
@@ -1549,6 +1676,14 @@ tiles).</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -1556,6 +1691,7 @@ tiles).</p>
+
@@ -1615,6 +1751,14 @@ tiles).</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -1622,6 +1766,7 @@ tiles).</p>
+
@@ -1669,6 +1814,14 @@ tiles).</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -1684,17 +1837,10 @@ tiles).</p>
-
-
-
-
-
-
-
-
+
@@ -1727,16 +1873,6 @@ tiles).</p>
- <li class=""><a href="/docs/history.html">History</a></li>
-
-
-
-
-
-
-
-
-
@@ -1753,26 +1889,17 @@ tiles).</p>
+ <li class=""><a href="/docs/history.html">History</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -1797,16 +1924,6 @@ tiles).</p>
- <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
-
-
-
-
-
-
-
-
-
@@ -1851,26 +1968,17 @@ tiles).</p>
+ <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -1883,12 +1991,14 @@ tiles).</p>
-
+ <li class=""><a href="/docs/api/">API</a></li>
+
+
@@ -1969,6 +2079,11 @@ tiles).</p>
+
+
+
+ <li class=""><a href="/docs/testapi/">Test API</a></li>
+
</ul>
Modified: calcite/site/docs/model.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/model.html?rev=1747967&r1=1747966&r2=1747967&view=diff
==============================================================================
--- calcite/site/docs/model.html (original)
+++ calcite/site/docs/model.html Sun Jun 12 08:33:22 2016
@@ -128,6 +128,10 @@
+
+
+
+
@@ -170,6 +174,10 @@
+
+
+
+
@@ -212,6 +220,10 @@
+
+
+
+
</optgroup>
@@ -261,6 +273,10 @@
+
+
+
+
@@ -303,6 +319,10 @@
+
+
+
+
@@ -345,6 +365,10 @@
+
+
+
+
</optgroup>
@@ -394,6 +418,10 @@
+
+
+
+
@@ -436,6 +464,10 @@
+
+
+
+
@@ -478,6 +510,10 @@
+
+
+
+
@@ -520,6 +556,10 @@
+
+
+
+
</optgroup>
@@ -569,6 +609,10 @@
+
+
+
+
@@ -611,6 +655,10 @@
+
+
+
+
@@ -653,6 +701,10 @@
+
+
+
+
</optgroup>
@@ -702,6 +754,10 @@
+
+
+
+
@@ -744,6 +800,10 @@
+
+
+
+
@@ -786,6 +846,10 @@
+
+
+
+
@@ -828,6 +892,10 @@
+
+
+
+
</optgroup>
@@ -1390,6 +1458,7 @@ when you want to pass the column as a me
+
@@ -1441,6 +1510,14 @@ when you want to pass the column as a me
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -1448,6 +1525,7 @@ when you want to pass the column as a me
+
@@ -1527,6 +1605,14 @@ when you want to pass the column as a me
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -1534,6 +1620,7 @@ when you want to pass the column as a me
+
@@ -1560,6 +1647,7 @@ when you want to pass the column as a me
+
@@ -1574,6 +1662,7 @@ when you want to pass the column as a me
+
@@ -1645,6 +1734,14 @@ when you want to pass the column as a me
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -1652,6 +1749,7 @@ when you want to pass the column as a me
+
@@ -1707,6 +1805,14 @@ when you want to pass the column as a me
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -1722,6 +1828,7 @@ when you want to pass the column as a me
+
@@ -1745,6 +1852,10 @@ when you want to pass the column as a me
+
+
+
+
<li class=""><a href="/docs/avatica_overview.html">Overview</a></li>
@@ -1752,6 +1863,7 @@ when you want to pass the column as a me
+
@@ -1783,6 +1895,10 @@ when you want to pass the column as a me
+
+
+
+
<li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li>
@@ -1790,6 +1906,7 @@ when you want to pass the column as a me
+
@@ -1809,6 +1926,10 @@ when you want to pass the column as a me
+
+
+
+
<li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li>
@@ -1816,6 +1937,7 @@ when you want to pass the column as a me
+
@@ -1843,6 +1965,10 @@ when you want to pass the column as a me
+
+
+
+
<li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li>
@@ -1858,6 +1984,7 @@ when you want to pass the column as a me
+
@@ -1925,6 +2052,14 @@ when you want to pass the column as a me
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -1932,6 +2067,7 @@ when you want to pass the column as a me
+
@@ -1991,6 +2127,14 @@ when you want to pass the column as a me
+
+
+
+
+
+
+
+
<li class="current"><a href="/docs/model.html">JSON models</a></li>
@@ -1998,6 +2142,7 @@ when you want to pass the column as a me
+
@@ -2045,6 +2190,14 @@ when you want to pass the column as a me
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -2060,17 +2213,10 @@ when you want to pass the column as a me
-
-
-
-
-
-
-
-
+
@@ -2103,16 +2249,6 @@ when you want to pass the column as a me
- <li class=""><a href="/docs/history.html">History</a></li>
-
-
-
-
-
-
-
-
-
@@ -2129,26 +2265,17 @@ when you want to pass the column as a me
+ <li class=""><a href="/docs/history.html">History</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -2173,16 +2300,6 @@ when you want to pass the column as a me
- <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
-
-
-
-
-
-
-
-
-
@@ -2227,26 +2344,17 @@ when you want to pass the column as a me
+ <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -2259,12 +2367,14 @@ when you want to pass the column as a me
-
+ <li class=""><a href="/docs/api/">API</a></li>
+
+
@@ -2345,6 +2455,11 @@ when you want to pass the column as a me
+
+
+
+ <li class=""><a href="/docs/testapi/">Test API</a></li>
+
</ul>
Modified: calcite/site/docs/powered_by.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/powered_by.html?rev=1747967&r1=1747966&r2=1747967&view=diff
==============================================================================
--- calcite/site/docs/powered_by.html (original)
+++ calcite/site/docs/powered_by.html Sun Jun 12 08:33:22 2016
@@ -128,6 +128,10 @@
+
+
+
+
@@ -170,6 +174,10 @@
+
+
+
+
@@ -212,6 +220,10 @@
+
+
+
+
</optgroup>
@@ -261,6 +273,10 @@
+
+
+
+
@@ -303,6 +319,10 @@
+
+
+
+
@@ -345,6 +365,10 @@
+
+
+
+
</optgroup>
@@ -394,6 +418,10 @@
+
+
+
+
@@ -436,6 +464,10 @@
+
+
+
+
@@ -478,6 +510,10 @@
+
+
+
+
@@ -520,6 +556,10 @@
+
+
+
+
</optgroup>
@@ -569,6 +609,10 @@
+
+
+
+
@@ -611,6 +655,10 @@
+
+
+
+
@@ -653,6 +701,10 @@
+
+
+
+
</optgroup>
@@ -702,6 +754,10 @@
+
+
+
+
@@ -744,6 +800,10 @@
+
+
+
+
@@ -786,6 +846,10 @@
+
+
+
+
@@ -828,6 +892,10 @@
+
+
+
+
</optgroup>
@@ -999,6 +1067,7 @@ on your site.</p>
+
@@ -1050,6 +1119,14 @@ on your site.</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -1057,6 +1134,7 @@ on your site.</p>
+
@@ -1136,6 +1214,14 @@ on your site.</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -1143,6 +1229,7 @@ on your site.</p>
+
@@ -1169,6 +1256,7 @@ on your site.</p>
+
@@ -1183,6 +1271,7 @@ on your site.</p>
+
@@ -1254,6 +1343,14 @@ on your site.</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -1261,6 +1358,7 @@ on your site.</p>
+
@@ -1316,6 +1414,14 @@ on your site.</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -1331,6 +1437,7 @@ on your site.</p>
+
@@ -1354,6 +1461,10 @@ on your site.</p>
+
+
+
+
<li class=""><a href="/docs/avatica_overview.html">Overview</a></li>
@@ -1361,6 +1472,7 @@ on your site.</p>
+
@@ -1392,6 +1504,10 @@ on your site.</p>
+
+
+
+
<li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li>
@@ -1399,6 +1515,7 @@ on your site.</p>
+
@@ -1418,6 +1535,10 @@ on your site.</p>
+
+
+
+
<li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li>
@@ -1425,6 +1546,7 @@ on your site.</p>
+
@@ -1452,6 +1574,10 @@ on your site.</p>
+
+
+
+
<li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li>
@@ -1467,6 +1593,7 @@ on your site.</p>
+
@@ -1534,6 +1661,14 @@ on your site.</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -1541,6 +1676,7 @@ on your site.</p>
+
@@ -1600,6 +1736,14 @@ on your site.</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -1607,6 +1751,7 @@ on your site.</p>
+
@@ -1654,6 +1799,14 @@ on your site.</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -1669,17 +1822,10 @@ on your site.</p>
-
-
-
-
-
-
-
-
+
@@ -1712,16 +1858,6 @@ on your site.</p>
- <li class=""><a href="/docs/history.html">History</a></li>
-
-
-
-
-
-
-
-
-
@@ -1738,26 +1874,17 @@ on your site.</p>
+ <li class=""><a href="/docs/history.html">History</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -1782,16 +1909,6 @@ on your site.</p>
- <li class="current"><a href="/docs/powered_by.html">Powered By Calcite</a></li>
-
-
-
-
-
-
-
-
-
@@ -1836,26 +1953,17 @@ on your site.</p>
+ <li class="current"><a href="/docs/powered_by.html">Powered By Calcite</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -1868,12 +1976,14 @@ on your site.</p>
-
+ <li class=""><a href="/docs/api/">API</a></li>
+
+
@@ -1954,6 +2064,11 @@ on your site.</p>
+
+
+
+ <li class=""><a href="/docs/testapi/">Test API</a></li>
+
</ul>
Modified: calcite/site/docs/reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/reference.html?rev=1747967&r1=1747966&r2=1747967&view=diff
==============================================================================
--- calcite/site/docs/reference.html (original)
+++ calcite/site/docs/reference.html Sun Jun 12 08:33:22 2016
@@ -128,6 +128,10 @@
+
+
+
+
@@ -170,6 +174,10 @@
+
+
+
+
@@ -212,6 +220,10 @@
+
+
+
+
</optgroup>
@@ -261,6 +273,10 @@
+
+
+
+
@@ -303,6 +319,10 @@
+
+
+
+
@@ -345,6 +365,10 @@
+
+
+
+
</optgroup>
@@ -394,6 +418,10 @@
+
+
+
+
@@ -436,6 +464,10 @@
+
+
+
+
@@ -478,6 +510,10 @@
+
+
+
+
@@ -520,6 +556,10 @@
+
+
+
+
</optgroup>
@@ -569,6 +609,10 @@
+
+
+
+
@@ -611,6 +655,10 @@
+
+
+
+
@@ -653,6 +701,10 @@
+
+
+
+
</optgroup>
@@ -702,6 +754,10 @@
+
+
+
+
@@ -744,6 +800,10 @@
+
+
+
+
@@ -786,6 +846,10 @@
+
+
+
+
@@ -828,6 +892,10 @@
+
+
+
+
</optgroup>
@@ -910,6 +978,7 @@ form.</p>
<span class="o">|</span> <span class="k">WITH</span> <span class="n">withItem</span> <span class="p">[</span> <span class="p">,</span> <span class="n">withItem</span> <span class="p">]</span><span class="o">*</span> <span class="n">query</span>
<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>
@@ -936,6 +1005,10 @@ form.</p>
<span class="p">[</span> <span class="k">HAVING</span> <span class="n">booleanExpression</span> <span class="p">]</span>
<span class="p">[</span> <span class="n">WINDOW</span> <span class="n">windowName</span> <span class="k">AS</span> <span class="n">windowSpec</span> <span class="p">[,</span> <span class="n">windowName</span> <span class="k">AS</span> <span class="n">windowSpec</span> <span class="p">]</span><span class="o">*</span> <span class="p">]</span>
+<span class="n">selectWithoutFrom</span><span class="p">:</span>
+ <span class="k">SELECT</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="err">{</span> <span class="o">*</span> <span class="o">|</span> <span class="n">projectItem</span> <span class="p">[,</span> <span class="n">projectItem</span> <span class="p">]</span><span class="o">*</span> <span class="err">}</span>
+
<span class="n">projectItem</span><span class="p">:</span>
<span class="n">expression</span> <span class="p">[</span> <span class="p">[</span> <span class="k">AS</span> <span class="p">]</span> <span class="n">columnAlias</span> <span class="p">]</span>
<span class="o">|</span> <span class="n">tableAlias</span> <span class="p">.</span> <span class="o">*</span>
@@ -1011,6 +1084,10 @@ function).</p>
<p>An IN, EXISTS or scalar sub-query may be correlated; that is, it
may refer to tables in the FROM clause of an enclosing query.</p>
+<p><em>selectWithoutFrom</em> is equivalent to VALUES,
+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>
+
<h2 id="keywords">Keywords</h2>
<p>The following is a list of SQL keywords.
@@ -1069,6 +1146,7 @@ CATALOG,
CATALOG_NAME,
<strong>CEIL</strong>,
<strong>CEILING</strong>,
+CENTURY,
CHAIN,
<strong>CHAR</strong>,
<strong>CHARACTER</strong>,
@@ -1142,6 +1220,7 @@ DATETIME_INTERVAL_PRECISION,
<strong>DAY</strong>,
<strong>DEALLOCATE</strong>,
<strong>DEC</strong>,
+DECADE,
<strong>DECIMAL</strong>,
<strong>DECLARE</strong>,
<strong>DEFAULT</strong>,
@@ -1168,6 +1247,8 @@ DISPATCH,
<strong>DISTINCT</strong>,
DOMAIN,
<strong>DOUBLE</strong>,
+DOW,
+DOY,
<strong>DROP</strong>,
<strong>DYNAMIC</strong>,
DYNAMIC_FUNCTION,
@@ -1177,6 +1258,7 @@ DYNAMIC_FUNCTION_CODE,
<strong>ELSE</strong>,
<strong>END</strong>,
<strong>END-EXEC</strong>,
+EPOCH,
EQUALS,
<strong>ESCAPE</strong>,
<strong>EVERY</strong>,
@@ -1289,6 +1371,7 @@ MESSAGE_OCTET_LENGTH,
MESSAGE_TEXT,
<strong>METHOD</strong>,
MICROSECOND,
+MILLENNIUM,
<strong>MIN</strong>,
<strong>MINUTE</strong>,
MINVALUE,
@@ -1694,7 +1777,7 @@ name will have been converted to upper c
<p>Where:</p>
<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="n">timeUnit</span><span class="p">:</span>
- <span class="k">YEAR</span> <span class="o">|</span> <span class="k">MONTH</span> <span class="o">|</span> <span class="k">DAY</span> <span class="o">|</span> <span class="n">HOUR</span> <span class="o">|</span> <span class="k">MINUTE</span> <span class="o">|</span> <span class="k">SECOND</span></code></pre></figure>
+ <span class="n">MILLENNIUM</span> <span class="o">|</span> <span class="n">CENTURY</span> <span class="o">|</span> <span class="n">DECADE</span> <span class="o">|</span> <span class="k">YEAR</span> <span class="o">|</span> <span class="n">QUARTER</span> <span class="o">|</span> <span class="k">MONTH</span> <span class="o">|</span> <span class="n">WEEK</span> <span class="o">|</span> <span class="n">DOY</span> <span class="o">|</span> <span class="n">DOW</span> <span class="o">|</span> <span class="k">DAY</span> <span class="o">|</span> <span class="n">HOUR</span> <span class="o">|</span> <span class="k">MINUTE</span> <span class="o">|</span> <span class="k">SECOND</span> <span class="o">|</span> <span class="n">EPOCH</span></code></pre></figure>
<p>Note:</p>
@@ -2867,6 +2950,7 @@ Here are some examples:</p>
+
@@ -2918,6 +3002,14 @@ Here are some examples:</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -2925,6 +3017,7 @@ Here are some examples:</p>
+
@@ -3004,6 +3097,14 @@ Here are some examples:</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -3011,6 +3112,7 @@ Here are some examples:</p>
+
@@ -3037,6 +3139,7 @@ Here are some examples:</p>
+
@@ -3051,6 +3154,7 @@ Here are some examples:</p>
+
@@ -3122,6 +3226,14 @@ Here are some examples:</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -3129,6 +3241,7 @@ Here are some examples:</p>
+
@@ -3184,6 +3297,14 @@ Here are some examples:</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -3199,6 +3320,7 @@ Here are some examples:</p>
+
@@ -3222,6 +3344,10 @@ Here are some examples:</p>
+
+
+
+
<li class=""><a href="/docs/avatica_overview.html">Overview</a></li>
@@ -3229,6 +3355,7 @@ Here are some examples:</p>
+
@@ -3260,6 +3387,10 @@ Here are some examples:</p>
+
+
+
+
<li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li>
@@ -3267,6 +3398,7 @@ Here are some examples:</p>
+
@@ -3286,6 +3418,10 @@ Here are some examples:</p>
+
+
+
+
<li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li>
@@ -3293,6 +3429,7 @@ Here are some examples:</p>
+
@@ -3320,6 +3457,10 @@ Here are some examples:</p>
+
+
+
+
<li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li>
@@ -3335,6 +3476,7 @@ Here are some examples:</p>
+
@@ -3402,6 +3544,14 @@ Here are some examples:</p>
+
+
+
+
+
+
+
+
<li class="current"><a href="/docs/reference.html">SQL language</a></li>
@@ -3409,6 +3559,7 @@ Here are some examples:</p>
+
@@ -3468,6 +3619,14 @@ Here are some examples:</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -3475,6 +3634,7 @@ Here are some examples:</p>
+
@@ -3522,6 +3682,14 @@ Here are some examples:</p>
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -3537,17 +3705,10 @@ Here are some examples:</p>
-
-
-
-
-
-
-
-
+
@@ -3580,16 +3741,6 @@ Here are some examples:</p>
- <li class=""><a href="/docs/history.html">History</a></li>
-
-
-
-
-
-
-
-
-
@@ -3606,26 +3757,17 @@ Here are some examples:</p>
+ <li class=""><a href="/docs/history.html">History</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -3650,16 +3792,6 @@ Here are some examples:</p>
- <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
-
-
-
-
-
-
-
-
-
@@ -3704,26 +3836,17 @@ Here are some examples:</p>
+ <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
+
-
-
-
+
@@ -3736,12 +3859,14 @@ Here are some examples:</p>
-
+ <li class=""><a href="/docs/api/">API</a></li>
+
+
@@ -3822,6 +3947,11 @@ Here are some examples:</p>
+
+
+
+ <li class=""><a href="/docs/testapi/">Test API</a></li>
+
</ul>