svn commit: r1747967 [3/4] - in /calcite/site: community/ css/ docs/

Sun, 12 Jun 2016 01:34:06 -0700 

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&gt; </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">&gt;</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 &copy;&nbsp;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&nbsp;License&nbsp;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>

Reply via email to