You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2016/05/06 04:37:20 UTC
svn commit: r1742498 [2/3] - in /calcite/site: community/ css/ docs/
Modified: calcite/site/docs/adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/adapter.html?rev=1742498&r1=1742497&r2=1742498&view=diff
==============================================================================
--- calcite/site/docs/adapter.html (original)
+++ calcite/site/docs/adapter.html Fri May 6 04:37:20 2016
@@ -126,6 +126,8 @@
+
+
@@ -166,6 +168,8 @@
+
+
@@ -206,6 +210,8 @@
+
+
</optgroup>
@@ -253,6 +259,8 @@
+
+
@@ -293,6 +301,8 @@
+
+
@@ -333,6 +343,8 @@
+
+
</optgroup>
@@ -380,6 +392,8 @@
+
+
@@ -420,6 +434,8 @@
+
+
@@ -460,6 +476,8 @@
+
+
@@ -500,6 +518,8 @@
+
+
</optgroup>
@@ -547,6 +567,8 @@
+
+
@@ -587,6 +609,8 @@
+
+
@@ -627,6 +651,8 @@
+
+
</optgroup>
@@ -674,6 +700,8 @@
+
+
@@ -714,6 +742,8 @@
+
+
@@ -754,6 +784,8 @@
+
+
@@ -794,6 +826,8 @@
+
+
</optgroup>
@@ -815,8 +849,9 @@
presenting the data as tables within a schema.</p>
<ul>
- <li><a href="cassandra.html">Cassandra adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/cassandra/package-summary.html">calcite-cassandra</a>)</li>
+ <li><a href="cassandra_adapter.html">Cassandra adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/cassandra/package-summary.html">calcite-cassandra</a>)</li>
<li>CSV adapter (<a href="/apidocs/org/apache/calcite/adapter/csv/package-summary.html">example/csv</a>)</li>
+ <li><a href="druid_adapter.html">Druid adapter</a> (<a href="/apidocs/org/apache/calcite/adapter/druid/package-summary.html">calcite-druid</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>Spark adapter (<a href="/apidocs/org/apache/calcite/adapter/spark/package-summary.html">calcite-spark</a>)</li>
@@ -1020,6 +1055,10 @@ as implemented by Avatica’s
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -1102,6 +1141,10 @@ as implemented by Avatica’s
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -1216,6 +1259,10 @@ as implemented by Avatica’s
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -1274,6 +1321,10 @@ as implemented by Avatica’s
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -1488,6 +1539,10 @@ as implemented by Avatica’s
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -1550,6 +1605,10 @@ as implemented by Avatica’s
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -1600,6 +1659,10 @@ as implemented by Avatica’s
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -1654,6 +1717,10 @@ as implemented by Avatica’s
+
+
+
+
<li class=""><a href="/docs/history.html">History</a></li>
@@ -1720,6 +1787,10 @@ as implemented by Avatica’s
+
+
+
+
<li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
@@ -1803,6 +1874,10 @@ as implemented by Avatica’s
+
+
+
+
@@ -1814,6 +1889,10 @@ as implemented by Avatica’s
+
+
+
+
Modified: calcite/site/docs/algebra.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/algebra.html?rev=1742498&r1=1742497&r2=1742498&view=diff
==============================================================================
--- calcite/site/docs/algebra.html (original)
+++ calcite/site/docs/algebra.html Fri May 6 04:37:20 2016
@@ -126,6 +126,8 @@
+
+
@@ -166,6 +168,8 @@
+
+
@@ -206,6 +210,8 @@
+
+
</optgroup>
@@ -253,6 +259,8 @@
+
+
@@ -293,6 +301,8 @@
+
+
@@ -333,6 +343,8 @@
+
+
</optgroup>
@@ -380,6 +392,8 @@
+
+
@@ -420,6 +434,8 @@
+
+
@@ -460,6 +476,8 @@
+
+
@@ -500,6 +518,8 @@
+
+
</optgroup>
@@ -547,6 +567,8 @@
+
+
@@ -587,6 +609,8 @@
+
+
@@ -627,6 +651,8 @@
+
+
</optgroup>
@@ -674,6 +700,8 @@
+
+
@@ -714,6 +742,8 @@
+
+
@@ -754,6 +784,8 @@
+
+
@@ -794,6 +826,8 @@
+
+
</optgroup>
@@ -1417,6 +1451,10 @@ added to the stack.</p>
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -1499,6 +1537,10 @@ added to the stack.</p>
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -1613,6 +1655,10 @@ added to the stack.</p>
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -1671,6 +1717,10 @@ added to the stack.</p>
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -1885,6 +1935,10 @@ added to the stack.</p>
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -1947,6 +2001,10 @@ added to the stack.</p>
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -1997,6 +2055,10 @@ added to the stack.</p>
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -2051,6 +2113,10 @@ added to the stack.</p>
+
+
+
+
<li class=""><a href="/docs/history.html">History</a></li>
@@ -2117,6 +2183,10 @@ added to the stack.</p>
+
+
+
+
<li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
@@ -2200,6 +2270,10 @@ added to the stack.</p>
+
+
+
+
@@ -2211,6 +2285,10 @@ added to the stack.</p>
+
+
+
+
Modified: calcite/site/docs/avatica_json_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_json_reference.html?rev=1742498&r1=1742497&r2=1742498&view=diff
==============================================================================
--- calcite/site/docs/avatica_json_reference.html (original)
+++ calcite/site/docs/avatica_json_reference.html Fri May 6 04:37:20 2016
@@ -126,6 +126,8 @@
+
+
@@ -166,6 +168,8 @@
+
+
@@ -206,6 +210,8 @@
+
+
</optgroup>
@@ -253,6 +259,8 @@
+
+
@@ -293,6 +301,8 @@
+
+
@@ -333,6 +343,8 @@
+
+
</optgroup>
@@ -380,6 +392,8 @@
+
+
@@ -420,6 +434,8 @@
+
+
@@ -460,6 +476,8 @@
+
+
@@ -500,6 +518,8 @@
+
+
</optgroup>
@@ -547,6 +567,8 @@
+
+
@@ -587,6 +609,8 @@
+
+
@@ -627,6 +651,8 @@
+
+
</optgroup>
@@ -674,6 +700,8 @@
+
+
@@ -714,6 +742,8 @@
+
+
@@ -754,6 +784,8 @@
+
+
@@ -794,6 +826,8 @@
+
+
</optgroup>
@@ -1856,6 +1890,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -1938,6 +1976,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -2052,6 +2094,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -2110,6 +2156,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -2324,6 +2374,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -2386,6 +2440,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -2436,6 +2494,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -2490,6 +2552,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/history.html">History</a></li>
@@ -2556,6 +2622,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
@@ -2639,6 +2709,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
@@ -2650,6 +2724,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
Modified: calcite/site/docs/avatica_overview.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_overview.html?rev=1742498&r1=1742497&r2=1742498&view=diff
==============================================================================
--- calcite/site/docs/avatica_overview.html (original)
+++ calcite/site/docs/avatica_overview.html Fri May 6 04:37:20 2016
@@ -126,6 +126,8 @@
+
+
@@ -166,6 +168,8 @@
+
+
@@ -206,6 +210,8 @@
+
+
</optgroup>
@@ -253,6 +259,8 @@
+
+
@@ -293,6 +301,8 @@
+
+
@@ -333,6 +343,8 @@
+
+
</optgroup>
@@ -380,6 +392,8 @@
+
+
@@ -420,6 +434,8 @@
+
+
@@ -460,6 +476,8 @@
+
+
@@ -500,6 +518,8 @@
+
+
</optgroup>
@@ -547,6 +567,8 @@
+
+
@@ -587,6 +609,8 @@
+
+
@@ -627,6 +651,8 @@
+
+
</optgroup>
@@ -674,6 +700,8 @@
+
+
@@ -714,6 +742,8 @@
+
+
@@ -754,6 +784,8 @@
+
+
@@ -794,6 +826,8 @@
+
+
</optgroup>
@@ -1035,6 +1069,10 @@ At some point Avatica could become a sep
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -1117,6 +1155,10 @@ At some point Avatica could become a sep
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -1231,6 +1273,10 @@ At some point Avatica could become a sep
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -1289,6 +1335,10 @@ At some point Avatica could become a sep
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -1503,6 +1553,10 @@ At some point Avatica could become a sep
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -1565,6 +1619,10 @@ At some point Avatica could become a sep
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -1615,6 +1673,10 @@ At some point Avatica could become a sep
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -1669,6 +1731,10 @@ At some point Avatica could become a sep
+
+
+
+
<li class=""><a href="/docs/history.html">History</a></li>
@@ -1735,6 +1801,10 @@ At some point Avatica could become a sep
+
+
+
+
<li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
@@ -1818,6 +1888,10 @@ At some point Avatica could become a sep
+
+
+
+
@@ -1829,6 +1903,10 @@ At some point Avatica could become a sep
+
+
+
+
Modified: calcite/site/docs/avatica_protobuf_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_protobuf_reference.html?rev=1742498&r1=1742497&r2=1742498&view=diff
==============================================================================
--- calcite/site/docs/avatica_protobuf_reference.html (original)
+++ calcite/site/docs/avatica_protobuf_reference.html Fri May 6 04:37:20 2016
@@ -126,6 +126,8 @@
+
+
@@ -166,6 +168,8 @@
+
+
@@ -206,6 +210,8 @@
+
+
</optgroup>
@@ -253,6 +259,8 @@
+
+
@@ -293,6 +301,8 @@
+
+
@@ -333,6 +343,8 @@
+
+
</optgroup>
@@ -380,6 +392,8 @@
+
+
@@ -420,6 +434,8 @@
+
+
@@ -460,6 +476,8 @@
+
+
@@ -500,6 +518,8 @@
+
+
</optgroup>
@@ -547,6 +567,8 @@
+
+
@@ -587,6 +609,8 @@
+
+
@@ -627,6 +651,8 @@
+
+
</optgroup>
@@ -674,6 +700,8 @@
+
+
@@ -714,6 +742,8 @@
+
+
@@ -754,6 +784,8 @@
+
+
@@ -794,6 +826,8 @@
+
+
</optgroup>
@@ -1920,6 +1954,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -2002,6 +2040,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -2116,6 +2158,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -2174,6 +2220,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -2388,6 +2438,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -2450,6 +2504,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -2500,6 +2558,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -2554,6 +2616,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/history.html">History</a></li>
@@ -2620,6 +2686,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
<li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
@@ -2703,6 +2773,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
@@ -2714,6 +2788,10 @@ SQL or by a DatabaseMetaData operation w
+
+
+
+
Modified: calcite/site/docs/avatica_roadmap.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/avatica_roadmap.html?rev=1742498&r1=1742497&r2=1742498&view=diff
==============================================================================
--- calcite/site/docs/avatica_roadmap.html (original)
+++ calcite/site/docs/avatica_roadmap.html Fri May 6 04:37:20 2016
@@ -126,6 +126,8 @@
+
+
@@ -166,6 +168,8 @@
+
+
@@ -206,6 +210,8 @@
+
+
</optgroup>
@@ -253,6 +259,8 @@
+
+
@@ -293,6 +301,8 @@
+
+
@@ -333,6 +343,8 @@
+
+
</optgroup>
@@ -380,6 +392,8 @@
+
+
@@ -420,6 +434,8 @@
+
+
@@ -460,6 +476,8 @@
+
+
@@ -500,6 +518,8 @@
+
+
</optgroup>
@@ -547,6 +567,8 @@
+
+
@@ -587,6 +609,8 @@
+
+
@@ -627,6 +651,8 @@
+
+
</optgroup>
@@ -674,6 +700,8 @@
+
+
@@ -714,6 +742,8 @@
+
+
@@ -754,6 +784,8 @@
+
+
@@ -794,6 +826,8 @@
+
+
</optgroup>
@@ -957,6 +991,10 @@
+
+
+
+
<li class=""><a href="/docs/index.html">Background</a></li>
@@ -1039,6 +1077,10 @@
+
+
+
+
<li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
@@ -1153,6 +1195,10 @@
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
@@ -1211,6 +1257,10 @@
+
+
+
+
<li class=""><a href="/docs/lattice.html">Lattices</a></li>
@@ -1425,6 +1475,10 @@
+
+
+
+
<li class=""><a href="/docs/reference.html">SQL language</a></li>
@@ -1487,6 +1541,10 @@
+
+
+
+
<li class=""><a href="/docs/model.html">JSON models</a></li>
@@ -1537,6 +1595,10 @@
+
+
+
+
<li class=""><a href="/docs/howto.html">HOWTO</a></li>
@@ -1591,6 +1653,10 @@
+
+
+
+
<li class=""><a href="/docs/history.html">History</a></li>
@@ -1657,6 +1723,10 @@
+
+
+
+
<li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li>
@@ -1740,6 +1810,10 @@
+
+
+
+
@@ -1751,6 +1825,10 @@
+
+
+
+
Modified: calcite/site/docs/cassandra.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/cassandra.html?rev=1742498&r1=1742497&r2=1742498&view=diff
==============================================================================
--- calcite/site/docs/cassandra.html (original)
+++ calcite/site/docs/cassandra.html Fri May 6 04:37:20 2016
@@ -1,1941 +1,8 @@
-<!DOCTYPE HTML>
-<html lang="en-US">
-<head>
- <meta charset="UTF-8">
+<html>
+<header>
<title>Cassandra 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>
+ <meta http-equiv="refresh" content="2; url=cassandra_adapter.html">
</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>Cassandra 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 Cassandra 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 Cassandra adapter. Note that while models can contain
-definitions of
-<a href="/docs/model.html#materialization">materializations</a>,
-the adapter will attempt to automatically populate any materialized views
-<a href="http://www.datastax.com/dev/blog/new-in-cassandra-3-0-materialized-views">defined in Cassandra</a>.</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="err">version:</span><span class="w"> </span><span class="err">'1.0',</span><span class="w">
- </span><span class="err">defaultSchema:</span><span class="w"> </span><span class="err">'twissandra',</span><span class="w">
- </span><span class="err">schemas:</span><span class="w"> </span><span class="err">[</span><span class="w">
- </span><span class="err">{</span><span class="w">
- </span><span class="err">name:</span><span class="w"> </span><span class="err">'twissandra',</span><span class="w">
- </span><span class="err">type:</span><span class="w"> </span><span class="err">'custom',</span><span class="w">
- </span><span class="err">factory:</span><span class="w"> </span><span class="err">'org.apache.calcite.adapter.cassandra.CassandraSchemaFactory',</span><span class="w">
- </span><span class="err">operand:</span><span class="w"> </span><span class="err">{</span><span class="w">
- </span><span class="err">host:</span><span class="w"> </span><span class="err">'localhost',</span><span class="w">
- </span><span class="err">keyspace:</span><span class="w"> </span><span class="err">'twissandra'</span><span class="w">
- </span><span class="p">}</span><span class="w">
- </span><span class="err">}</span><span class="w">
- </span><span class="err">]</span><span class="w">
-</span><span class="err">}</span></code></pre></figure>
-
-<p>Assuming this file is stored as <code class="highlighter-rouge">model.json</code>, you can connect to
-Cassandra via <a href="https://github.com/julianhyde/sqlline"><code class="highlighter-rouge">sqlline</code></a> as
-follows:</p>
-
-<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="gp">$ </span>./sqlline
-<span class="gp">sqlline> </span>!connect jdbc:calcite:model<span class="o">=</span>model.json admin admin</code></pre></figure>
-
-<p><code class="highlighter-rouge">sqlline</code> will now accept SQL queries which access your CQL tables.
-However, you’re not restricted to issuing queries supported by
-<a href="https://cassandra.apache.org/doc/cql3/CQL-2.2.html">CQL</a>.
-Calcite allows you to perform complex operations such as aggregations
-or joins. The adapter will attempt to compile the query into the most
-efficient CQL possible by exploiting filtering and sorting directly in
-Cassandra where possible.</p>
-
-<p>For example, in the example dataset there is a CQL table named <code class="highlighter-rouge">timeline</code>
-with <code class="highlighter-rouge">username</code> as the partition key and <code class="highlighter-rouge">time</code> as the clustering key.</p>
-
-<p>We can issue a simple query to fetch the most recent tweet ID of the
-user by writing standard SQL:</p>
-
-<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="n">sqlline</span><span class="o">></span> <span class="k">SELECT</span> <span class="nv">"tweet_id"</span>
- <span class="k">FROM</span> <span class="nv">"timeline"</span>
- <span class="k">WHERE</span> <span class="nv">"username"</span> <span class="o">=</span> <span class="s1">'JmuhsAaMdw'</span>
- <span class="k">ORDER</span> <span class="k">BY</span> <span class="nv">"time"</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">1</span><span class="p">;</span>
-<span class="o">+</span><span class="c1">--------------------------------------+
-</span><span class="o">|</span> <span class="n">tweet_id</span> <span class="o">|</span>
-<span class="o">+</span><span class="c1">--------------------------------------+
-</span><span class="o">|</span> <span class="n">f3d3d4dc</span><span class="o">-</span><span class="n">d05b</span><span class="o">-</span><span class="mi">11</span><span class="n">e5</span><span class="o">-</span><span class="n">b58b</span><span class="o">-</span><span class="mi">90</span><span class="n">e2ba530b12</span> <span class="o">|</span>
-<span class="o">+--------------------------------------+</span></code></pre></figure>
-
-<p>While executing this query, the Cassandra adapter is able to recognize
-that <code class="highlighter-rouge">username</code> is the partition key and can be filtered by Cassandra.
-It also recognizes the clustering key <code class="highlighter-rouge">time</code> and pushes the ordering to
-Cassandra as well.</p>
-
-<p>The final CQL query given to Cassandra is below:</p>
-
-<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="k">SELECT</span> <span class="n">username</span><span class="p">,</span> <span class="n">time</span><span class="p">,</span> <span class="n">tweet_id</span>
-<span class="k">FROM</span> <span class="nv">"timeline"</span>
-<span class="k">WHERE</span> <span class="n">username</span> <span class="o">=</span> <span class="s1">'JmuhsAaMdw'</span>
-<span class="k">ORDER</span> <span class="k">BY</span> <span class="n">time</span> <span class="k">DESC</span> <span class="n">ALLOW</span> <span class="n">FILTERING</span><span class="p">;</span></code></pre></figure>
-
-<p>There is still significant work to do in improving the flexibility and
-performance of the adapter, but if you’re looking for a quick way to
-gain additional insights into data stored in Cassandra, Calcite should
-prove useful.</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>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-</ul>
-
-
- </aside>
-</div>
-
-
- <div class="clear"></div>
-
- </div>
- </section>
-
-
- <footer role="contentinfo">
- <div id="poweredby">
- <a href="http://www.apache.org/">
- <span class="sr-only">Apache</span>
- <img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
- </div>
- <div id="copyright">
- <p>The contents of this website are © 2016
- <a href="https://www.apache.org/">Apache Software Foundation</a>
- under the terms of
- the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
- Apache License v2</a>. Apache Calcite and its logo are
- trademarks of the Apache Software Foundation.</p>
- </div>
-</footer>
-
- <script>
- var anchorForId = function (id) {
- var anchor = document.createElement("a");
- anchor.className = "header-link";
- anchor.href = "#" + id;
- anchor.innerHTML = "<span class=\"sr-only\">Permalink</span><i class=\"fa fa-link\"></i>";
- anchor.title = "Permalink";
- return anchor;
- };
-
- var linkifyAnchors = function (level, containingElement) {
- var headers = containingElement.getElementsByTagName("h" + level);
- for (var h = 0; h < headers.length; h++) {
- var header = headers[h];
-
- if (typeof header.id !== "undefined" && header.id !== "") {
- header.appendChild(anchorForId(header.id));
- }
- }
- };
-
- document.onreadystatechange = function () {
- if (this.readyState === "complete") {
- var contentBlock = document.getElementsByClassName("docs")[0] || document.getElementsByClassName("news")[0];
- if (!contentBlock) {
- return;
- }
- for (var level = 1; level <= 6; level++) {
- linkifyAnchors(level, contentBlock);
- }
- }
- };
-</script>
-
-
+<body>
+<p>Page has moved. Redirecting to <a href="cassandra_adapter.html">cassandra_adapter.html</a>...</p>
</body>
-</html>
Added: calcite/site/docs/cassandra_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/cassandra_adapter.html?rev=1742498&view=auto
==============================================================================
--- calcite/site/docs/cassandra_adapter.html (added)
+++ calcite/site/docs/cassandra_adapter.html Fri May 6 04:37:20 2016
@@ -0,0 +1,2019 @@
+<!DOCTYPE HTML>
+<html lang="en-US">
+<head>
+ <meta charset="UTF-8">
+ <title>Cassandra 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>Cassandra 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 Cassandra 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 Cassandra adapter. Note that while models can contain
+definitions of
+<a href="/docs/model.html#materialization">materializations</a>,
+the adapter will attempt to automatically populate any materialized views
+<a href="http://www.datastax.com/dev/blog/new-in-cassandra-3-0-materialized-views">defined in Cassandra</a>.</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="err">version:</span><span class="w"> </span><span class="err">'1.0',</span><span class="w">
+ </span><span class="err">defaultSchema:</span><span class="w"> </span><span class="err">'twissandra',</span><span class="w">
+ </span><span class="err">schemas:</span><span class="w"> </span><span class="err">[</span><span class="w">
+ </span><span class="err">{</span><span class="w">
+ </span><span class="err">name:</span><span class="w"> </span><span class="err">'twissandra',</span><span class="w">
+ </span><span class="err">type:</span><span class="w"> </span><span class="err">'custom',</span><span class="w">
+ </span><span class="err">factory:</span><span class="w"> </span><span class="err">'org.apache.calcite.adapter.cassandra.CassandraSchemaFactory',</span><span class="w">
+ </span><span class="err">operand:</span><span class="w"> </span><span class="err">{</span><span class="w">
+ </span><span class="err">host:</span><span class="w"> </span><span class="err">'localhost',</span><span class="w">
+ </span><span class="err">keyspace:</span><span class="w"> </span><span class="err">'twissandra'</span><span class="w">
+ </span><span class="p">}</span><span class="w">
+ </span><span class="err">}</span><span class="w">
+ </span><span class="err">]</span><span class="w">
+</span><span class="err">}</span></code></pre></figure>
+
+<p>Assuming this file is stored as <code class="highlighter-rouge">model.json</code>, you can connect to
+Cassandra via <a href="https://github.com/julianhyde/sqlline"><code class="highlighter-rouge">sqlline</code></a> as
+follows:</p>
+
+<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="gp">$ </span>./sqlline
+<span class="gp">sqlline> </span>!connect jdbc:calcite:model<span class="o">=</span>model.json admin admin</code></pre></figure>
+
+<p><code class="highlighter-rouge">sqlline</code> will now accept SQL queries which access your CQL tables.
+However, you’re not restricted to issuing queries supported by
+<a href="https://cassandra.apache.org/doc/cql3/CQL-2.2.html">CQL</a>.
+Calcite allows you to perform complex operations such as aggregations
+or joins. The adapter will attempt to compile the query into the most
+efficient CQL possible by exploiting filtering and sorting directly in
+Cassandra where possible.</p>
+
+<p>For example, in the example dataset there is a CQL table named <code class="highlighter-rouge">timeline</code>
+with <code class="highlighter-rouge">username</code> as the partition key and <code class="highlighter-rouge">time</code> as the clustering key.</p>
+
+<p>We can issue a simple query to fetch the most recent tweet ID of the
+user by writing standard SQL:</p>
+
+<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="n">sqlline</span><span class="o">></span> <span class="k">SELECT</span> <span class="nv">"tweet_id"</span>
+ <span class="k">FROM</span> <span class="nv">"timeline"</span>
+ <span class="k">WHERE</span> <span class="nv">"username"</span> <span class="o">=</span> <span class="s1">'JmuhsAaMdw'</span>
+ <span class="k">ORDER</span> <span class="k">BY</span> <span class="nv">"time"</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">1</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">--------------------------------------+
+</span><span class="o">|</span> <span class="n">tweet_id</span> <span class="o">|</span>
+<span class="o">+</span><span class="c1">--------------------------------------+
+</span><span class="o">|</span> <span class="n">f3d3d4dc</span><span class="o">-</span><span class="n">d05b</span><span class="o">-</span><span class="mi">11</span><span class="n">e5</span><span class="o">-</span><span class="n">b58b</span><span class="o">-</span><span class="mi">90</span><span class="n">e2ba530b12</span> <span class="o">|</span>
+<span class="o">+--------------------------------------+</span></code></pre></figure>
+
+<p>While executing this query, the Cassandra adapter is able to recognize
+that <code class="highlighter-rouge">username</code> is the partition key and can be filtered by Cassandra.
+It also recognizes the clustering key <code class="highlighter-rouge">time</code> and pushes the ordering to
+Cassandra as well.</p>
+
+<p>The final CQL query given to Cassandra is below:</p>
+
+<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="k">SELECT</span> <span class="n">username</span><span class="p">,</span> <span class="n">time</span><span class="p">,</span> <span class="n">tweet_id</span>
+<span class="k">FROM</span> <span class="nv">"timeline"</span>
+<span class="k">WHERE</span> <span class="n">username</span> <span class="o">=</span> <span class="s1">'JmuhsAaMdw'</span>
+<span class="k">ORDER</span> <span class="k">BY</span> <span class="n">time</span> <span class="k">DESC</span> <span class="n">ALLOW</span> <span class="n">FILTERING</span><span class="p">;</span></code></pre></figure>
+
+<p>There is still significant work to do in improving the flexibility and
+performance of the adapter, but if you’re looking for a quick way to
+gain additional insights into data stored in Cassandra, Calcite should
+prove useful.</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>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+</ul>
+
+
+ </aside>
+</div>
+
+
+ <div class="clear"></div>
+
+ </div>
+ </section>
+
+
+ <footer role="contentinfo">
+ <div id="poweredby">
+ <a href="http://www.apache.org/">
+ <span class="sr-only">Apache</span>
+ <img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
+ </div>
+ <div id="copyright">
+ <p>The contents of this website are © 2016
+ <a href="https://www.apache.org/">Apache Software Foundation</a>
+ under the terms of
+ the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
+ Apache License v2</a>. Apache Calcite and its logo are
+ trademarks of the Apache Software Foundation.</p>
+ </div>
+</footer>
+
+ <script>
+ var anchorForId = function (id) {
+ var anchor = document.createElement("a");
+ anchor.className = "header-link";
+ anchor.href = "#" + id;
+ anchor.innerHTML = "<span class=\"sr-only\">Permalink</span><i class=\"fa fa-link\"></i>";
+ anchor.title = "Permalink";
+ return anchor;
+ };
+
+ var linkifyAnchors = function (level, containingElement) {
+ var headers = containingElement.getElementsByTagName("h" + level);
+ for (var h = 0; h < headers.length; h++) {
+ var header = headers[h];
+
+ if (typeof header.id !== "undefined" && header.id !== "") {
+ header.appendChild(anchorForId(header.id));
+ }
+ }
+ };
+
+ document.onreadystatechange = function () {
+ if (this.readyState === "complete") {
+ var contentBlock = document.getElementsByClassName("docs")[0] || document.getElementsByClassName("news")[0];
+ if (!contentBlock) {
+ return;
+ }
+ for (var level = 1; level <= 6; level++) {
+ linkifyAnchors(level, contentBlock);
+ }
+ }
+ };
+</script>
+
+
+</body>
+</html>
Added: calcite/site/docs/druid_adapter.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/druid_adapter.html?rev=1742498&view=auto
==============================================================================
--- calcite/site/docs/druid_adapter.html (added)
+++ calcite/site/docs/druid_adapter.html Fri May 6 04:37:20 2016
@@ -0,0 +1,2085 @@
+<!DOCTYPE HTML>
+<html lang="en-US">
+<head>
+ <meta charset="UTF-8">
+ <title>Druid 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>Druid adapter</h1>
+ <!--
+
+-->
+
+<p><a href="http://druid.io/">Druid</a> is a fast column-oriented distributed data
+store. It allows you to execute queries via a
+<a href="http://druid.io/docs/0.9.0/querying/querying.html">JSON-based query language</a>,
+in particular OLAP-style queries.
+Druid can be loaded in batch mode or continuously; one of Druid’s key
+differentiators is its ability to
+<a href="http://druid.io/docs/0.9.0/ingestion/stream-ingestion.html">load from a streaming source such as Kafka</a>
+and have the data available for query within milliseconds.</p>
+
+<p>Calcite’s Druid adapter allows you to query the data using SQL,
+combining it with data in other Calcite schemas.</p>
+
+<p>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 Druid adapter.</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">"wiki"</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">"wiki"</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.druid.DruidSchemaFactory"</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">"url"</span><span class="p">:</span><span class="w"> </span><span class="s2">"http://localhost:8082/druid/v2/?pretty"</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="p">{</span><span class="w">
+ </span><span class="nt">"name"</span><span class="p">:</span><span class="w"> </span><span class="s2">"wiki"</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.druid.DruidTableFactory"</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">"dataSource"</span><span class="p">:</span><span class="w"> </span><span class="s2">"wikiticker"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"interval"</span><span class="p">:</span><span class="w"> </span><span class="s2">"1900-01-09T00:00:00.000Z/2992-01-10T00:00:00.000Z"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"timestampColumn"</span><span class="p">:</span><span class="w"> </span><span class="s2">"time"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"dimensions"</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="w">
+ </span><span class="s2">"channel"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"cityName"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"comment"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"countryIsoCode"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"countryName"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"isAnonymous"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"isMinor"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"isNew"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"isRobot"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"isUnpatrolled"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"metroCode"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"namespace"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"page"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"regionIsoCode"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"regionName"</span><span class="p">,</span><span class="w">
+ </span><span class="s2">"user"</span><span class="w">
+ </span><span class="p">],</span><span class="w">
+ </span><span class="nt">"metrics"</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="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"count"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"type"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"count"</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="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"added"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"type"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"longSum"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"fieldName"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"added"</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="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"deleted"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"type"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"longSum"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"fieldName"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"deleted"</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="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"delta"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"type"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"longSum"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"fieldName"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"delta"</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="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"user_unique"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"type"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"hyperUnique"</span><span class="p">,</span><span class="w">
+ </span><span class="nt">"fieldName"</span><span class="w"> </span><span class="p">:</span><span class="w"> </span><span class="s2">"user"</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="p">}</span></code></pre></figure>
+
+<p>This file is stored as <code class="highlighter-rouge">druid/src/test/resources/druid-wiki-model.json</code>,
+so you can connect to Druid via
+<a href="https://github.com/julianhyde/sqlline"><code class="highlighter-rouge">sqlline</code></a>
+as follows:</p>
+
+<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="gp">$ </span>./sqlline
+<span class="gp">sqlline> </span>!connect jdbc:calcite:model<span class="o">=</span>druid/src/test/resources/druid-wiki-model.json admin admin
+<span class="gp">sqlline> </span><span class="k">select</span> <span class="s2">"countryName"</span>, cast<span class="o">(</span>count<span class="o">(</span><span class="k">*</span><span class="o">)</span> as integer<span class="o">)</span> as c
+ from <span class="s2">"wiki"</span>
+ group by <span class="s2">"countryName"</span>
+ order by c desc limit 5;
++----------------+------------+
+| countryName | C |
++----------------+------------+
+| | 35445 |
+| United States | 528 |
+| Italy | 256 |
+| United Kingdom | 234 |
+| France | 205 |
++----------------+------------+
+5 rows selected <span class="o">(</span>0.279 seconds<span class="o">)</span>
+sqlline></code></pre></figure>
+
+<p>That query shows the top 5 countries of origin of wiki page edits
+on 2015-09-12 (the date covered by the wikiticker data set).</p>
+
+<p>Now let’s see how the query was evaluated:</p>
+
+<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="gp">sqlline> </span>!set outputformat csv
+<span class="gp">sqlline> </span>explain plan <span class="k">for
+ select</span> <span class="s2">"countryName"</span>, cast<span class="o">(</span>count<span class="o">(</span><span class="k">*</span><span class="o">)</span> as integer<span class="o">)</span> as c
+ from <span class="s2">"wiki"</span>
+ group by <span class="s2">"countryName"</span>
+ order by c desc limit 5;
+<span class="s1">'PLAN'</span>
+<span class="s1">'EnumerableInterpreter
+ BindableProject(countryName=[$0], C=[CAST($1):INTEGER NOT NULL])
+ BindableSort(sort0=[$1], dir0=[DESC], fetch=[5])
+ DruidQuery(table=[[wiki, wiki]], groups=[{4}], aggs=[[COUNT()]])
+'</span>
+1 row selected <span class="o">(</span>0.024 seconds<span class="o">)</span></code></pre></figure>
+
+<p>That plan shows that Calcite was able to push down the <code class="highlighter-rouge">GROUP BY</code>
+part of the query to Druid, including the <code class="highlighter-rouge">COUNT(*)</code> function,
+but not the <code class="highlighter-rouge">ORDER BY ... LIMIT</code>. (We plan to lift this restriction;
+see [<a href="https://issues.apache.org/jira/browse/CALCITE-1206">CALCITE-1206</a>].)</p>
+
+<h1 id="foodmart-data-set">Foodmart data set</h1>
+
+<p>The test VM also includes a data set that denormalizes
+the sales, product and customer tables of the Foodmart schema
+into a single Druid data set called “foodmart”.</p>
+
+<p>You can access it via the
+<code class="highlighter-rouge">druid/src/test/resources/druid-foodmart-model.json</code> model.</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>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+</ul>
+
+
+ </aside>
+</div>
+
+
+ <div class="clear"></div>
+
+ </div>
+ </section>
+
+
+ <footer role="contentinfo">
+ <div id="poweredby">
+ <a href="http://www.apache.org/">
+ <span class="sr-only">Apache</span>
+ <img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
+ </div>
+ <div id="copyright">
+ <p>The contents of this website are © 2016
+ <a href="https://www.apache.org/">Apache Software Foundation</a>
+ under the terms of
+ the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
+ Apache License v2</a>. Apache Calcite and its logo are
+ trademarks of the Apache Software Foundation.</p>
+ </div>
+</footer>
+
+ <script>
+ var anchorForId = function (id) {
+ var anchor = document.createElement("a");
+ anchor.className = "header-link";
+ anchor.href = "#" + id;
+ anchor.innerHTML = "<span class=\"sr-only\">Permalink</span><i class=\"fa fa-link\"></i>";
+ anchor.title = "Permalink";
+ return anchor;
+ };
+
+ var linkifyAnchors = function (level, containingElement) {
+ var headers = containingElement.getElementsByTagName("h" + level);
+ for (var h = 0; h < headers.length; h++) {
+ var header = headers[h];
+
+ if (typeof header.id !== "undefined" && header.id !== "") {
+ header.appendChild(anchorForId(header.id));
+ }
+ }
+ };
+
+ document.onreadystatechange = function () {
+ if (this.readyState === "complete") {
+ var contentBlock = document.getElementsByClassName("docs")[0] || document.getElementsByClassName("news")[0];
+ if (!contentBlock) {
+ return;
+ }
+ for (var level = 1; level <= 6; level++) {
+ linkifyAnchors(level, contentBlock);
+ }
+ }
+ };
+</script>
+
+
+</body>
+</html>