calcite-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jh...@apache.org
Subject svn commit: r1785020 - /calcite/site/docs/
Date Wed, 01 Mar 2017 19:32:36 GMT
Author: jhyde
Date: Wed Mar  1 19:32:35 2017
New Revision: 1785020

URL: http://svn.apache.org/viewvc?rev=1785020&view=rev
Log:
Site changes for [CALCITE-1598], [CALCITE-1661], [CALCITE-1615], [CALCITE-884], [CALCITE-1652]

Added:
    calcite/site/docs/file_adapter.html
    calcite/site/docs/pig_adapter.html
Modified:
    calcite/site/docs/adapter.html
    calcite/site/docs/algebra.html
    calcite/site/docs/avatica_json_reference.html
    calcite/site/docs/avatica_overview.html
    calcite/site/docs/avatica_protobuf_reference.html
    calcite/site/docs/avatica_roadmap.html
    calcite/site/docs/cassandra_adapter.html
    calcite/site/docs/druid_adapter.html
    calcite/site/docs/elasticsearch_adapter.html
    calcite/site/docs/history.html
    calcite/site/docs/howto.html
    calcite/site/docs/index.html
    calcite/site/docs/lattice.html
    calcite/site/docs/model.html
    calcite/site/docs/powered_by.html
    calcite/site/docs/reference.html
    calcite/site/docs/stream.html
    calcite/site/docs/tutorial.html

Modified: calcite/site/docs/adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/adapter.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/adapter.html (original)
+++ calcite/site/docs/adapter.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,6 +878,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -862,6 +926,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -887,14 +955,22 @@ presenting the data as tables within a s
   <li>CSV adapter (<a href="/apidocs/org/apache/calcite/adapter/csv/package-summary.html">example/csv</a>)</li>
   <li><a href="druid_adapter.html">Druid adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/druid/package-summary.html">calcite-druid</a>)</li>
   <li><a href="elasticsearch_adapter.html">Elasticsearch adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/elasticsearch/package-summary.html">calcite-elasticsearch</a>)</li>
+  <li><a href="file_adapter.html">File adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/file/package-summary.html">calcite-file</a>)</li>
   <li>JDBC adapter (part of <a href="/apidocs/org/apache/calcite/adapter/jdbc/package-summary.html">calcite-core</a>)</li>
   <li>MongoDB adapter (<a href="/apidocs/org/apache/calcite/adapter/mongodb/package-summary.html">calcite-mongodb</a>)</li>
+  <li><a href="pig_adapter.html">Pig adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/pig/package-summary.html">calcite-pig</a>)</li>
   <li>Solr cloud adapter (<a href="https://github.com/bluejoe2008/solr-sql">solr-sql</a>)</li>
   <li>Spark adapter (<a href="/apidocs/org/apache/calcite/adapter/spark/package-summary.html">calcite-spark</a>)</li>
   <li>Splunk adapter (<a href="/apidocs/org/apache/calcite/adapter/splunk/package-summary.html">calcite-splunk</a>)</li>
   <li>Eclipse Memory Analyzer (MAT) adapter (<a href="https://github.com/vlsi/mat-calcite-plugin">mat-calcite-plugin</a>)</li>
 </ul>
 
+<h3 id="other-language-interfaces">Other language interfaces</h3>
+
+<ul>
+  <li>Piglet (<a href="/apidocs/org/apache/calcite/piglet/package-summary.html">calcite-piglet</a>) runs queries in a subset of <a href="https://pig.apache.org/docs/r0.7.0/piglatin_ref1.html">Pig Latin</a></li>
+</ul>
+
 <h2 id="engines">Engines</h2>
 
 <p>Many projects and products use Apache Calcite for SQL parsing,
@@ -935,6 +1011,10 @@ as implemented by Avatica’s
   </thead>
   <tbody>
     <tr>
+      <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#APPROXIMATE_DECIMAL">approximateDecimal</a></td>
+      <td style="text-align: left">Whether approximate results from aggregate functions on <code class="highlighter-rouge">DECIMAL</code> types are acceptable</td>
+    </tr>
+    <tr>
       <td style="text-align: left"><a href="/apidocs/org/apache/calcite/config/CalciteConnectionProperty.html#APPROXIMATE_DISTINCT_COUNT">approximateDistinctCount</a></td>
       <td style="text-align: left">Whether approximate results from <code class="highlighter-rouge">COUNT(DISTINCT ...)</code> aggregate functions are acceptable</td>
     </tr>

Modified: calcite/site/docs/algebra.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/algebra.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/algebra.html (original)
+++ calcite/site/docs/algebra.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/avatica_json_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_json_reference.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/avatica_json_reference.html (original)
+++ calcite/site/docs/avatica_json_reference.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/avatica_overview.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_overview.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/avatica_overview.html (original)
+++ calcite/site/docs/avatica_overview.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/avatica_protobuf_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_protobuf_reference.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/avatica_protobuf_reference.html (original)
+++ calcite/site/docs/avatica_protobuf_reference.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/avatica_roadmap.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_roadmap.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/avatica_roadmap.html (original)
+++ calcite/site/docs/avatica_roadmap.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/cassandra_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/cassandra_adapter.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/cassandra_adapter.html (original)
+++ calcite/site/docs/cassandra_adapter.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/druid_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/druid_adapter.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/druid_adapter.html (original)
+++ calcite/site/docs/druid_adapter.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/elasticsearch_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/elasticsearch_adapter.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/elasticsearch_adapter.html (original)
+++ calcite/site/docs/elasticsearch_adapter.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Added: calcite/site/docs/file_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/file_adapter.html?rev=1785020&view=auto
==============================================================================
--- calcite/site/docs/file_adapter.html (added)
+++ calcite/site/docs/file_adapter.html Wed Mar  1 19:32:35 2017
@@ -0,0 +1,1483 @@
+<!DOCTYPE HTML>
+<html lang="en-US">
+<head>
+  <meta charset="UTF-8">
+  <title>File 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>File adapter</h1>
+          <!--
+
+-->
+
+<h1 id="overview">Overview</h1>
+
+<p>The file adapter is able to read files in a variety of formats,
+and can also read files over various protocols, such as HTTP.</p>
+
+<p>For example if you define:</p>
+
+<ul>
+  <li>States - http://en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States</li>
+  <li>Cities - http://en.wikipedia.org/wiki/List_of_United_States_cities_by_population</li>
+</ul>
+
+<p>You can then write a query like:</p>
+
+<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="k">select</span>
+	<span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="nv">"City Count"</span><span class="p">,</span>
+	<span class="k">sum</span><span class="p">(</span><span class="mi">100</span> <span class="o">*</span> <span class="k">c</span><span class="p">.</span><span class="nv">"Population"</span> <span class="o">/</span> <span class="n">s</span><span class="p">.</span><span class="nv">"Population"</span><span class="p">)</span> <span class="nv">"Pct State Population"</span>
+<span class="k">from</span> <span class="nv">"Cities"</span> <span class="k">c</span><span class="p">,</span> <span class="nv">"States"</span> <span class="n">s</span>
+<span class="k">where</span> <span class="k">c</span><span class="p">.</span><span class="nv">"State"</span> <span class="o">=</span> <span class="n">s</span><span class="p">.</span><span class="nv">"State"</span> <span class="k">and</span> <span class="n">s</span><span class="p">.</span><span class="nv">"State"</span> <span class="o">=</span> <span class="s1">'California'</span><span class="p">;</span></code></pre></figure>
+
+<p>And learn that California has 69 cities of 100k or more
+comprising almost 1/2 of the state’s population:</p>
+
+<p><code class="highlighter-rouge">
++---------------------+----------------------+
+|     City Count      | Pct State Population |
++---------------------+----------------------+
+| 69                  | 48.574217177106576   |
++---------------------+----------------------+
+</code></p>
+
+<h1 id="a-simple-example">A simple example</h1>
+
+<p>Let’s start with a simple example. First, we need a
+<a href="/docs/model.html">model definition</a>,
+as follows.</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">"SALES"</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">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"SALES"</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">"factory"</span><span class="p">:</span><span class="w"> </span><span class="s2">"org.apache.calcite.adapter.file.FileSchemaFactory"</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">"tables"</span><span class="p">:</span><span class="w"> </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">"EMPS"</span><span class="p">,</span><span class="w">
+        </span><span class="nt">"url"</span><span class="p">:</span><span class="w"> </span><span class="s2">"file:file/src/test/resources/sales/EMPS.html"</span><span class="w">
+      </span><span class="p">},</span><span class="w"> </span><span class="err">{</span><span class="w">
+        </span><span class="nt">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"DEPTS"</span><span class="w">
+        </span><span class="s2">"url"</span><span class="err">:</span><span class="w"> </span><span class="s2">"file:file/src/test/resources/sales/DEPTS.html"</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>Schemas are defined as a list of tables, each containing minimally a
+table name and a url.  If a page has more than one table, you can
+include in a table definition <code class="highlighter-rouge">selector</code> and <code class="highlighter-rouge">index</code> fields to specify the
+desired table.  If there is no table specification, the file adapter
+chooses the largest table on the page.</p>
+
+<p><code class="highlighter-rouge">EMPS.html</code> contains a single HTML table:</p>
+
+<figure class="highlight"><pre><code class="language-xml" data-lang="xml"><span class="nt">&lt;html&gt;</span>
+  <span class="nt">&lt;body&gt;</span>
+    <span class="nt">&lt;table&gt;</span>
+      <span class="nt">&lt;thead&gt;</span>
+        <span class="nt">&lt;tr&gt;</span>
+          <span class="nt">&lt;th&gt;</span>EMPNO<span class="nt">&lt;/th&gt;</span>
+          <span class="nt">&lt;th&gt;</span>NAME<span class="nt">&lt;/th&gt;</span>
+          <span class="nt">&lt;th&gt;</span>DEPTNO<span class="nt">&lt;/th&gt;</span>
+        <span class="nt">&lt;/tr&gt;</span>
+      <span class="nt">&lt;/thead&gt;</span>
+      <span class="nt">&lt;tbody&gt;</span>
+        <span class="nt">&lt;tr&gt;</span>
+          <span class="nt">&lt;td&gt;</span>100<span class="nt">&lt;/td&gt;</span>
+          <span class="nt">&lt;td&gt;</span>Fred<span class="nt">&lt;/td&gt;</span>
+          <span class="nt">&lt;td&gt;</span>30<span class="nt">&lt;/td&gt;</span>
+        <span class="nt">&lt;/tr&gt;</span>
+        <span class="nt">&lt;tr&gt;</span>
+          <span class="nt">&lt;td&gt;</span>110<span class="nt">&lt;/td&gt;</span>
+          <span class="nt">&lt;td&gt;</span>Eric<span class="nt">&lt;/td&gt;</span>
+          <span class="nt">&lt;td&gt;</span>20<span class="nt">&lt;/td&gt;</span>
+        <span class="nt">&lt;/tr&gt;</span>
+        <span class="nt">&lt;tr&gt;</span>
+          <span class="nt">&lt;td&gt;</span>110<span class="nt">&lt;/td&gt;</span>
+          <span class="nt">&lt;td&gt;</span>John<span class="nt">&lt;/td&gt;</span>
+          <span class="nt">&lt;td&gt;</span>40<span class="nt">&lt;/td&gt;</span>
+        <span class="nt">&lt;/tr&gt;</span>
+        <span class="nt">&lt;tr&gt;</span>
+          <span class="nt">&lt;td&gt;</span>120<span class="nt">&lt;/td&gt;</span>
+          <span class="nt">&lt;td&gt;</span>Wilma<span class="nt">&lt;/td&gt;</span>
+          <span class="nt">&lt;td&gt;</span>20<span class="nt">&lt;/td&gt;</span>
+        <span class="nt">&lt;/tr&gt;</span>
+        <span class="nt">&lt;tr&gt;</span>
+          <span class="nt">&lt;td&gt;</span>130<span class="nt">&lt;/td&gt;</span>
+          <span class="nt">&lt;td&gt;</span>Alice<span class="nt">&lt;/td&gt;</span>
+          <span class="nt">&lt;td&gt;</span>40<span class="nt">&lt;/td&gt;</span>
+        <span class="nt">&lt;/tr&gt;</span>
+      <span class="nt">&lt;/tbody&gt;</span>
+    <span class="nt">&lt;/table&gt;</span>
+  <span class="nt">&lt;/body&gt;</span>
+<span class="nt">&lt;/html&gt;</span></code></pre></figure>
+
+<p>The model file is stored as <code class="highlighter-rouge">file/src/test/resources/sales.json</code>,
+so you can connect 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>file/src/test/resources/sales.json admin admin
+<span class="gp">sqlline&gt; </span><span class="k">select</span> <span class="k">*</span> from sales.emps;
++-------+--------+------+
+| EMPNO | DEPTNO | NAME |
++-------+--------+------+
+| 100   | 30     | Fred |
+| 110   | 20     | Eric |
+| 110   | 40     | John |
+| 120   | 20     | Wilma |
+| 130   | 40     | Alice |
++-------+--------+------+
+5 rows selected </code></pre></figure>
+
+<h1 id="mapping-tables">Mapping tables</h1>
+
+<p>Now for a more complex example. This time we connect to Wikipedia via
+HTTP, read pages for US states and cities, and extract data from HTML
+tables on those pages. The tables have more complex formats, and the
+file adapter helps us locate and parse data in those tables.</p>
+
+<p>Tables can be simply defined for immediate gratification:</p>
+
+<figure class="highlight"><pre><code class="language-json" data-lang="json"><span class="p">{</span><span class="w">
+	</span><span class="err">tableName:</span><span class="w"> </span><span class="nt">"RawCities"</span><span class="err">,</span><span class="w">
+	</span><span class="err">url</span><span class="p">:</span><span class="w"> </span><span class="s2">"http://en.wikipedia.org/wiki/List_of_United_States_cities_by_population"</span><span class="w">
+</span><span class="p">}</span></code></pre></figure>
+
+<p>And subsequently refined for better usability / querying:</p>
+
+<figure class="highlight"><pre><code class="language-json" data-lang="json"><span class="p">{</span><span class="w">
+	</span><span class="err">tableName:</span><span class="w"> </span><span class="nt">"Cities"</span><span class="err">,</span><span class="w">
+	</span><span class="err">url</span><span class="p">:</span><span class="w"> </span><span class="s2">"http://en.wikipedia.org/wiki/List_of_United_States_cities_by_population"</span><span class="p">,</span><span class="w">
+	</span><span class="err">path</span><span class="p">:</span><span class="w"> </span><span class="s2">"#mw-content-text &gt; table.wikitable.sortable"</span><span class="p">,</span><span class="w">
+	</span><span class="err">index</span><span class="p">:</span><span class="w"> </span><span class="mi">0</span><span class="p">,</span><span class="w">
+	</span><span class="err">fieldDefs</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="w">
+	  </span><span class="p">{</span><span class="err">th:</span><span class="w"> </span><span class="nt">"2012 rank"</span><span class="err">,</span><span class="w"> </span><span class="err">name</span><span class="p">:</span><span class="w"> </span><span class="s2">"Rank"</span><span class="p">,</span><span class="w"> </span><span class="err">type</span><span class="p">:</span><span class="w"> </span><span class="s2">"int"</span><span class="p">,</span><span class="w"> </span><span class="err">pattern</span><span class="p">:</span><span class="w"> </span><span class="s2">"(\\d+)"</span><span class="p">,</span><span class="w"> </span><span class="err">matchGroup</span><span class="p">:</span><span class="w"> </span><span class="mi">0</span><span class="p">},</span><span class="w">
+	  </span><span class="p">{</span><span class="err">th:</span><span class="w"> </span><span class="nt">"City"</span><span class="err">,</span><span class="w"> </span><span class="err">selector</span><span class="p">:</span><span class="w"> </span><span class="s2">"a"</span><span class="p">,</span><span class="w"> </span><span class="err">selectedElement</span><span class="p">:</span><span class="w"> </span><span class="mi">0</span><span class="p">},</span><span class="w">
+	  </span><span class="p">{</span><span class="err">th:</span><span class="w"> </span><span class="nt">"State[5]"</span><span class="err">,</span><span class="w"> </span><span class="err">name</span><span class="p">:</span><span class="w"> </span><span class="s2">"State"</span><span class="p">,</span><span class="w"> </span><span class="err">selector</span><span class="p">:</span><span class="w"> </span><span class="s2">"a:eq(0)"</span><span class="p">},</span><span class="w">
+	  </span><span class="p">{</span><span class="err">th:</span><span class="w"> </span><span class="nt">"2012 estimate"</span><span class="err">,</span><span class="w"> </span><span class="err">name</span><span class="p">:</span><span class="w"> </span><span class="s2">"Population"</span><span class="p">,</span><span class="w"> </span><span class="err">type</span><span class="p">:</span><span class="w"> </span><span class="s2">"double"</span><span class="p">},</span><span class="w">
+	  </span><span class="p">{</span><span class="err">th:</span><span class="w"> </span><span class="nt">"2010 Census"</span><span class="err">,</span><span class="w"> </span><span class="err">skip</span><span class="p">:</span><span class="w"> </span><span class="s2">"true"</span><span class="p">},</span><span class="w">
+	  </span><span class="p">{</span><span class="err">th:</span><span class="w"> </span><span class="nt">"Change"</span><span class="err">,</span><span class="w"> </span><span class="err">skip</span><span class="p">:</span><span class="w"> </span><span class="s2">"true"</span><span class="p">},</span><span class="w">
+	  </span><span class="p">{</span><span class="err">th:</span><span class="w"> </span><span class="nt">"2012 land area"</span><span class="err">,</span><span class="w"> </span><span class="err">name</span><span class="p">:</span><span class="w"> </span><span class="s2">"Land Area (sq mi)"</span><span class="p">,</span><span class="w"> </span><span class="err">type</span><span class="p">:</span><span class="w"> </span><span class="s2">"double"</span><span class="p">,</span><span class="w"> </span><span class="err">selector</span><span class="p">:</span><span class="w"> </span><span class="s2">":not(span)"</span><span class="p">},</span><span class="w">
+	  </span><span class="p">{</span><span class="err">th:</span><span class="w"> </span><span class="nt">"2012 population density"</span><span class="err">,</span><span class="w"> </span><span class="err">skip</span><span class="p">:</span><span class="w"> </span><span class="s2">"true"</span><span class="p">},</span><span class="w">
+	  </span><span class="p">{</span><span class="err">th:</span><span class="w"> </span><span class="nt">"ANSI"</span><span class="err">,</span><span class="w"> </span><span class="err">skip</span><span class="p">:</span><span class="w"> </span><span class="s2">"true"</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>Connect and execute queries, 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>file/src/test/resources/wiki.json admin admin
+<span class="gp">sqlline&gt; </span><span class="k">select</span> <span class="k">*</span> from wiki.<span class="s2">"RawCities"</span>;
+<span class="gp">sqlline&gt; </span><span class="k">select</span> <span class="k">*</span> from wiki.<span class="s2">"Cities"</span>;</code></pre></figure>
+
+<p>Note that <code class="highlighter-rouge">Cities</code> is easier to consume than <code class="highlighter-rouge">RawCities</code>,
+because its table definition has a field list.</p>
+
+<p>The file adapter uses <a href="http://jsoup.org/">Jsoup</a> for HTML DOM
+navigation; selectors for both tables and fields follow the
+<a href="http://jsoup.org/cookbook/extracting-data/selector-syntax">Jsoup selector specification</a>.</p>
+
+<p>Field definitions may be used to rename or skip source fields, to
+select and condition the cell contents and to set a data type.</p>
+
+<h1 id="parsing-cell-contents">Parsing cell contents</h1>
+
+<p>The file adapter can select DOM nodes within a cell, replace text
+within the selected element, match within the selected text, and
+choose a data type for the resulting database column.  Processing
+steps are applied in the order described and replace and match
+patterns are based on
+<a href="http://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html">Java regular expressions</a>.</p>
+
+<h1 id="further-examples">Further examples</h1>
+
+<p>There are more examples in the form of a script:</p>
+
+<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="gp">$ </span>./sqlline -f file/src/test/resources/webjoin.sql</code></pre></figure>
+
+<p>(When running <code class="highlighter-rouge">webjoin.sql</code> you will see a number of warning messages for
+each query containing a join.  These are expected and do not affect
+query results.  These messages will be suppressed in the next release.)</p>
+
+<h1 id="future-improvements">Future improvements</h1>
+
+<p>We are continuing to enhance the adapter, and would welcome
+contributions of new parsing capabilities (for example parsing JSON
+files) and being able to form URLs dynamically to push down filters.</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="/apidocs">API</a></li>
+
+
+  
+  
+  
+  
+
+  
+
+  <li class=""><a href="/testapidocs">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;2017
+     <a href="https://www.apache.org/">Apache Software Foundation</a>
+     under the terms of
+     the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
+     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=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/history.html (original)
+++ calcite/site/docs/history.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,6 +878,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -862,6 +926,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -891,6 +959,26 @@ Guava versions 14.0 to 21.0;
 Druid version 0.9.1.1;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
+<h3 id="new-features">New features</h3>
+
+<ul>
+  <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-884">CALCITE-884</a>]
+File adapter (Henry Olson)
+    <ul>
+      <li>Allow multiple Calcite columns to be derived from one HTML column,
+e.g. Location → Lat, Lon</li>
+      <li>Improved pattern match: added <code class="highlighter-rouge">matchSeq</code> to allow selection of
+<i>n</i>th match</li>
+      <li>Add replace patterns to cell parsing logic</li>
+      <li>Add handling for tables without <code class="highlighter-rouge">&amp;lt;TH&amp;gt;</code> elements</li>
+      <li>Unit tests using local files; URL tests are contingent on network
+access</li>
+      <li>Ability to parse HTML from local files</li>
+      <li>Derived from CSV adapter</li>
+    </ul>
+  </li>
+</ul>
+
 <h2 id="v1-11-0"><a href="https://github.com/apache/calcite/releases/tag/calcite-1.11.0">1.11.0</a> / 2017-01-09</h2>
 
 <p>Nearly three months after the previous release, there is a long list
@@ -942,7 +1030,7 @@ Guava versions 14.0 to 19.0;
 Druid version 0.9.1.1;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features">New features</h4>
+<h4 id="new-features-1">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1551">CALCITE-1551</a>]
@@ -1207,7 +1295,7 @@ using Oracle JDK 1.7, 1.8;
 Guava versions 14.0 to 19.0;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features-1">New features</h4>
+<h4 id="new-features-2">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1208">CALCITE-1208</a>]
@@ -1364,7 +1452,7 @@ using Oracle JDK 1.7, 1.8;
 Guava versions 14.0 to 19.0;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features-2">New features</h4>
+<h4 id="new-features-3">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1177">CALCITE-1177</a>]
@@ -1561,7 +1649,7 @@ using Oracle JDK 1.7, 1.8;
 Guava versions 12.0.1 to 19.0;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features-3">New features</h4>
+<h4 id="new-features-4">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-1124">CALCITE-1124</a>]
@@ -1728,7 +1816,7 @@ on Linux, Mac OS X, Microsoft Windows;
 using Oracle JDK 1.7, 1.8;
 other software versions as specified in <code class="highlighter-rouge">pom.xml</code>.</p>
 
-<h4 id="new-features-4">New features</h4>
+<h4 id="new-features-5">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-816">CALCITE-816</a>]
@@ -1971,7 +2059,7 @@ multi-sets.  You can follow this example
 language, and immediately taking advantage of Calcite’s back-ends and
 optimizer rules. It’s all just algebra, after all!</p>
 
-<h4 id="new-features-5">New features</h4>
+<h4 id="new-features-6">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-911">CALCITE-911</a>]
@@ -2222,7 +2310,7 @@ this release includes improvements to la
 and adds a builder API so that you can easily create relational
 algebra expressions.</p>
 
-<h4 id="new-features-6">New features</h4>
+<h4 id="new-features-7">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-748">CALCITE-748</a>]
@@ -2409,7 +2497,7 @@ and
 <a href="https://issues.apache.org/jira/browse/CALCITE-704">filtered aggregate functions</a>
 and various improvements to Avatica.</p>
 
-<h4 id="new-features-7">New features</h4>
+<h4 id="new-features-8">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-505">CALCITE-505</a>]
@@ -2538,7 +2626,7 @@ distribution among relational expression
 and [<a href="https://issues.apache.org/jira/browse/CALCITE-307">CALCITE-307</a>]
 improve implicit and explicit conversions in SQL.</p>
 
-<h4 id="new-features-8">New features</h4>
+<h4 id="new-features-9">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-366">CALCITE-366</a>]
@@ -2681,7 +2769,7 @@ later.</p>
 <code class="highlighter-rouge">RelNode</code>. We strongly suggest that you use these rather than
 calling constructors directly.</p>
 
-<h4 id="new-features-9">New features</h4>
+<h4 id="new-features-10">New features</h4>
 
 <ul>
   <li>SQL
@@ -2807,7 +2895,7 @@ improvements to the algorithms that impl
 including an interpreter that can evaluate queries without compilation;
 and fixes about 30 bugs.</p>
 
-<h4 id="new-features-10">New features</h4>
+<h4 id="new-features-11">New features</h4>
 
 <ul>
   <li>SQL
@@ -3069,7 +3157,7 @@ packages and lots of classes, in what we
 have an existing application, it’s worth upgrading to this first,
 before you move on to 1.0.</p>
 
-<h4 id="new-features-11">New features</h4>
+<h4 id="new-features-12">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-436">CALCITE-436</a>]
@@ -3120,7 +3208,7 @@ Push predicates through <code class="hig
 
 <p>This is the first release as Calcite. (The project was previously called Optiq.)</p>
 
-<h4 id="new-features-12">New features</h4>
+<h4 id="new-features-13">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-430">CALCITE-430</a>]
@@ -3277,7 +3365,7 @@ most recently.</li>
 
 <p>This is the first release under the Apache incubator process.</p>
 
-<h4 id="new-features-13">New features</h4>
+<h4 id="new-features-14">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-371">CALCITE-371</a>]
@@ -3409,7 +3497,7 @@ Add unit test for <code class="highlight
 
 <h2 id="v0-8"><a href="https://github.com/apache/calcite/releases/tag/optiq-parent-0.8">0.8</a> / 2014-06-27</h2>
 
-<h4 id="new-features-14">New features</h4>
+<h4 id="new-features-15">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-310">CALCITE-310</a>]
@@ -3490,7 +3578,7 @@ Window functions throw exception without
 
 <h2 id="v0-7"><a href="https://github.com/apache/calcite/releases/tag/optiq-parent-0.7">0.7</a> / 2014-05-13</h2>
 
-<h4 id="new-features-15">New features</h4>
+<h4 id="new-features-16">New features</h4>
 
 <ul>
   <li>Implement table functions.</li>
@@ -3575,7 +3663,7 @@ Suspicious map.get in VolcanoPlanner.rer
 
 <h2 id="v0-6"><a href="https://github.com/apache/calcite/releases/tag/optiq-parent-0.6">0.6</a> / 2014-04-11</h2>
 
-<h4 id="new-features-16">New features</h4>
+<h4 id="new-features-17">New features</h4>
 
 <ul>
   <li>[<a href="https://issues.apache.org/jira/browse/CALCITE-214">CALCITE-214</a>]
@@ -3700,7 +3788,7 @@ and obsolete our copy of the resource fr
 
 <h2 id="v0-5"><a href="https://github.com/apache/calcite/releases/tag/optiq-parent-0.5">0.5</a> / 2014-03-14</h2>
 
-<h4 id="new-features-17">New features</h4>
+<h4 id="new-features-18">New features</h4>
 
 <ul>
   <li>Allow <code class="highlighter-rouge">quoting</code>, <code class="highlighter-rouge">quotedCasing</code>, <code class="highlighter-rouge">unquotedCasing</code>, and <code class="highlighter-rouge">caseSensitive</code>

Modified: calcite/site/docs/howto.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/howto.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/howto.html (original)
+++ calcite/site/docs/howto.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/index.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/index.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/index.html (original)
+++ calcite/site/docs/index.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/lattice.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/lattice.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/lattice.html (original)
+++ calcite/site/docs/lattice.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/model.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/model.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/model.html (original)
+++ calcite/site/docs/model.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Added: calcite/site/docs/pig_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/pig_adapter.html?rev=1785020&view=auto
==============================================================================
--- calcite/site/docs/pig_adapter.html (added)
+++ calcite/site/docs/pig_adapter.html Wed Mar  1 19:32:35 2017
@@ -0,0 +1,1345 @@
+<!DOCTYPE HTML>
+<html lang="en-US">
+<head>
+  <meta charset="UTF-8">
+  <title>Pig 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>Pig adapter</h1>
+          <!--
+
+-->
+
+<h1 id="overview">Overview</h1>
+
+<p>The Pig adapter allows you to write queries in SQL and execute them using
+<a href="http://pig.apache.org">Apache Pig</a>.</p>
+
+<h1 id="a-simple-example">A simple example</h1>
+
+<p>Let’s start with a simple example. First, we need a
+<a href="/docs/model.html">model definition</a>,
+as follows.</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">"SALES"</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">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"PIG"</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">"factory"</span><span class="p">:</span><span class="w"> </span><span class="s2">"org.apache.calcite.adapter.pig.PigSchemaFactory"</span><span class="p">,</span><span class="w">
+    </span><span class="nt">"tables"</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">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"t"</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">"factory"</span><span class="p">:</span><span class="w"> </span><span class="s2">"org.apache.calcite.adapter.pig.PigTableFactory"</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">"file"</span><span class="p">:</span><span class="w"> </span><span class="s2">"data.txt"</span><span class="p">,</span><span class="w">
+        </span><span class="nt">"columns"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="s2">"tc0"</span><span class="p">,</span><span class="w"> </span><span class="s2">"tc1"</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">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"s"</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">"factory"</span><span class="p">:</span><span class="w"> </span><span class="s2">"org.apache.calcite.adapter.pig.PigTableFactory"</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">"file"</span><span class="p">:</span><span class="w"> </span><span class="s2">"data2.txt"</span><span class="p">,</span><span class="w">
+        </span><span class="nt">"columns"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="s2">"sc0"</span><span class="p">,</span><span class="w"> </span><span class="s2">"sc1"</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></code></pre></figure>
+
+<p>Now, if you write the SQL query</p>
+
+<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="k">select</span> <span class="o">*</span>
+<span class="k">from</span> <span class="nv">"t"</span>
+<span class="k">join</span> <span class="nv">"s"</span> <span class="k">on</span> <span class="nv">"tc1"</span> <span class="o">=</span> <span class="nv">"sc0"</span></code></pre></figure>
+
+<p>the Pig adapter will generate the Pig Latin script</p>
+
+<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="n">t</span> <span class="o">=</span> <span class="k">LOAD</span> <span class="s1">'data.txt'</span> <span class="k">USING</span> <span class="n">PigStorage</span><span class="p">()</span> <span class="k">AS</span> <span class="p">(</span><span class="n">tc0</span><span class="p">:</span><span class="n">chararray</span><span class="p">,</span> <span class="n">tc1</span><span class="p">:</span><span class="n">chararray</span><span class="p">);</span>
+<span class="n">s</span> <span class="o">=</span> <span class="k">LOAD</span> <span class="s1">'data2.txt'</span> <span class="k">USING</span> <span class="n">PigStorage</span><span class="p">()</span> <span class="k">AS</span> <span class="p">(</span><span class="n">sc0</span><span class="p">:</span><span class="n">chararray</span><span class="p">,</span> <span class="n">sc1</span><span class="p">:</span><span class="n">chararray</span><span class="p">);</span>
+<span class="n">t</span> <span class="o">=</span> <span class="k">JOIN</span> <span class="n">t</span> <span class="k">BY</span> <span class="n">tc1</span><span class="p">,</span> <span class="n">s</span> <span class="k">BY</span> <span class="n">sc0</span><span class="p">;</span></code></pre></figure>
+
+<p>which is then executed using Pig’s runtime, typically MapReduce on
+<a href="http://hadoop.apache.org/">Apache Hadoop</a>.</p>
+
+<h1 id="relationship-to-piglet">Relationship to Piglet</h1>
+
+<p>Calcite has another component called
+<a href="/apidocs/org/apache/calcite/piglet/package-summary.html">Piglet</a>.
+It allows you to write queries in a subset of Pig Latin,
+and execute them using any applicable Calcite adapter.
+So, Piglet is basically the opposite of the Pig adapter.</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="/apidocs">API</a></li>
+
+
+  
+  
+  
+  
+
+  
+
+  <li class=""><a href="/testapidocs">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;2017
+     <a href="https://www.apache.org/">Apache Software Foundation</a>
+     under the terms of
+     the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
+     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/powered_by.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/powered_by.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/powered_by.html (original)
+++ calcite/site/docs/powered_by.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/reference.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/reference.html (original)
+++ calcite/site/docs/reference.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,6 +878,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -862,6 +926,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -3042,8 +3110,8 @@ passed to the aggregate function.</p>
   </thead>
   <tbody>
     <tr>
-      <td style="text-align: left">GROUPING(expression)</td>
-      <td style="text-align: left">Returns 1 if expression is rolled up in the current row’s grouping set, 0 otherwise</td>
+      <td style="text-align: left">GROUPING(expression [, expression ] * )</td>
+      <td style="text-align: left">Returns a bit vector of the given grouping expressions</td>
     </tr>
     <tr>
       <td style="text-align: left">GROUP_ID()</td>
@@ -3051,7 +3119,80 @@ passed to the aggregate function.</p>
     </tr>
     <tr>
       <td style="text-align: left">GROUPING_ID(expression [, expression ] * )</td>
-      <td style="text-align: left">Returns a bit vector of the given grouping expressions</td>
+      <td style="text-align: left">Synonym for <code class="highlighter-rouge">GROUPING</code></td>
+    </tr>
+  </tbody>
+</table>
+
+<h3 id="grouped-window-functions">Grouped window functions</h3>
+
+<p>Grouped window functions occur in the <code class="highlighter-rouge">GROUP BY</code> clause and define a key value
+that represents a window containing several rows.</p>
+
+<p>In some window functions, a row may belong to more than one window.
+For example, if a query is grouped using
+<code class="highlighter-rouge">HOP(t, INTERVAL '2' HOUR, INTERVAL '1' HOUR)</code>, a row with timestamp ‘10:15:00’
+ will occur in both the 10:00 - 11:00 and 11:00 - 12:00 totals.</p>
+
+<table>
+  <thead>
+    <tr>
+      <th style="text-align: left">Operator syntax</th>
+      <th style="text-align: left">Description</th>
+    </tr>
+  </thead>
+  <tbody>
+    <tr>
+      <td style="text-align: left">HOP(dateTime, slide, size [, time ])</td>
+      <td style="text-align: left">Indicates a hopping window for <em>dateTime</em>, covering rows within the interval of <em>size</em>, shifting every <em>slide</em>, and optionally aligned at <em>time</em></td>
+    </tr>
+    <tr>
+      <td style="text-align: left">SESSION(dateTime, interval [, time ])</td>
+      <td style="text-align: left">Indicates a session window of <em>interval</em> for <em>dateTime</em>, optionally aligned at <em>time</em></td>
+    </tr>
+    <tr>
+      <td style="text-align: left">TUMBLE(dateTime, interval [, time ])</td>
+      <td style="text-align: left">Indicates a tumbling window of <em>interval</em> for <em>dateTime</em>, optionally aligned at <em>time</em></td>
+    </tr>
+  </tbody>
+</table>
+
+<h3 id="grouped-auxiliary-functions">Grouped auxiliary functions</h3>
+
+<p>Grouped auxiliary functions allow you to access properties of a window defined
+by a grouped window function.</p>
+
+<table>
+  <thead>
+    <tr>
+      <th style="text-align: left">Operator syntax</th>
+      <th style="text-align: left">Description</th>
+    </tr>
+  </thead>
+  <tbody>
+    <tr>
+      <td style="text-align: left">HOP_END(expression, slide, size [, time ])</td>
+      <td style="text-align: left">Returns the value of <em>expression</em> at the end of the window defined by a <code class="highlighter-rouge">HOP</code> function call</td>
+    </tr>
+    <tr>
+      <td style="text-align: left">HOP_START(expression, slide, size [, time ])</td>
+      <td style="text-align: left">Returns the value of <em>expression</em> at the beginning of the window defined by a <code class="highlighter-rouge">HOP</code> function call</td>
+    </tr>
+    <tr>
+      <td style="text-align: left">SESSION_END(expression, interval [, time])</td>
+      <td style="text-align: left">Returns the value of <em>expression</em> at the end of the window defined by a <code class="highlighter-rouge">SESSION</code> function call</td>
+    </tr>
+    <tr>
+      <td style="text-align: left">SESSION_START(expression, interval [, time])</td>
+      <td style="text-align: left">Returns the value of <em>expression</em> at the beginning of the window defined by a <code class="highlighter-rouge">SESSION</code> function call</td>
+    </tr>
+    <tr>
+      <td style="text-align: left">TUMBLE_END(expression, interval [, time ])</td>
+      <td style="text-align: left">Returns the value of <em>expression</em> at the end of the window defined by a <code class="highlighter-rouge">TUMBLE</code> function call</td>
+    </tr>
+    <tr>
+      <td style="text-align: left">TUMBLE_START(expression, interval [, time ])</td>
+      <td style="text-align: left">Returns the value of <em>expression</em> at the beginning of the window defined by a <code class="highlighter-rouge">TUMBLE</code> function call</td>
     </tr>
   </tbody>
 </table>

Modified: calcite/site/docs/stream.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/stream.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/stream.html (original)
+++ calcite/site/docs/stream.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     

Modified: calcite/site/docs/tutorial.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/tutorial.html?rev=1785020&r1=1785019&r2=1785020&view=diff
==============================================================================
--- calcite/site/docs/tutorial.html (original)
+++ calcite/site/docs/tutorial.html Wed Mar  1 19:32:35 2017
@@ -130,6 +130,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -174,6 +178,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -218,6 +226,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -269,6 +281,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -313,6 +329,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -357,6 +377,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -408,6 +432,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -452,6 +480,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -496,6 +528,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -540,6 +576,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -591,6 +631,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -635,6 +679,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -679,6 +727,10 @@
   
     
   
+    
+  
+    
+  
 
 
     </optgroup>
@@ -730,6 +782,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -774,6 +830,10 @@
   
     
   
+    
+  
+    
+  
 
   
 
@@ -818,12 +878,20 @@
   
     
   
+    
+  
+    
+  
 
   
 
   
     
   
+    
+  
+    
+  
     
   
     



Mime
View raw message