Modified: calcite/site/docs/index.html URL: http://svn.apache.org/viewvc/calcite/site/docs/index.html?rev=1739659&r1=1739658&r2=1739659&view=diff ============================================================================== --- calcite/site/docs/index.html (original) +++ calcite/site/docs/index.html Sun Apr 17 21:26:04 2016 @@ -4,7 +4,7 @@ <meta charset="UTF-8"> <title>Background</title> <meta name="viewport" content="width=device-width,initial-scale=1"> - <meta name="generator" content="Jekyll v2.4.0"> + <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"> @@ -824,59 +824,59 @@ for building a database: just add data.< <p>To illustrate, letâs create an empty instance of Calcite and then point it at some data.</p> -<div class="highlight"><pre><code class="language-java" data-lang="java"><span class="kd">public</span> <span class="kd">static</span> <span class="kd">class</span> <span class="nc">HrSchema</span> <span class="o">{</span> +<figure class="highlight"><pre><code class="language-java" data-lang="java"><span class="kd">public</span> <span class="kd">static</span> <span class="kd">class</span> <span class="nc">HrSchema</span> <span class="o">{</span> <span class="kd">public</span> <span class="kd">final</span> <span class="n">Employee</span><span class="o">[]</span> <span class="n">emps</span> <span class="o">=</span> <span class="mi">0</span><span class="o">;</span> <span class="kd">public</span> <span class="kd">final</span> <span class="n">Department</span><span class="o">[]</span> <span class="n">depts</span> <span class="o">=</span> <span class="mi">0</span><span class="o">;</span> <span class="o">}</span> -<span class="n">Class</span><span class="o">.</span><span class="na">forName</span><span class="o">(</span><span class="s">"org.apache.calcite.jdbc.Driver"</span><span class="o">);</span> -<span class="n">Properties</span> <span class="n">info</span> <span class="o">=</span> <span class="k">new</span> <span class="nf">Properties</span><span class="o">();</span> -<span class="n">info</span><span class="o">.</span><span class="na">setProperty</span><span class="o">(</span><span class="s">"lex"</span><span class="o">,</span> <span class="s">"JAVA"</span><span class="o">);</span> -<span class="n">Connection</span> <span class="n">connection</span> <span class="o">=</span> <span class="n">DriverManager</span><span class="o">.</span><span class="na">getConnection</span><span class="o">(</span><span class="s">"jdbc:calcite:"</span><span class="o">,</span> <span class="n">info</span><span class="o">);</span> +<span class="n">Class</span><span class="o">.</span><span class="na">forName</span><span class="o">(</span><span class="s">"org.apache.calcite.jdbc.Driver"</span><span class="o">);</span> +<span class="n">Properties</span> <span class="n">info</span> <span class="o">=</span> <span class="k">new</span> <span class="n">Properties</span><span class="o">();</span> +<span class="n">info</span><span class="o">.</span><span class="na">setProperty</span><span class="o">(</span><span class="s">"lex"</span><span class="o">,</span> <span class="s">"JAVA"</span><span class="o">);</span> +<span class="n">Connection</span> <span class="n">connection</span> <span class="o">=</span> <span class="n">DriverManager</span><span class="o">.</span><span class="na">getConnection</span><span class="o">(</span><span class="s">"jdbc:calcite:"</span><span class="o">,</span> <span class="n">info</span><span class="o">);</span> <span class="n">CalciteConnection</span> <span class="n">calciteConnection</span> <span class="o">=</span> <span class="n">connection</span><span class="o">.</span><span class="na">unwrap</span><span class="o">(</span><span class="n">CalciteConnection</span><span class="o">.</span><span class="na">class</span><span class="o">);</span> <span class="n">ReflectiveSchema</span><span class="o">.</span><span class="na">create</span><span class="o">(</span><span class="n">calciteConnection</span><span class="o">,</span> - <span class="n">calciteConnection</span><span class="o">.</span><span class="na">getRootSchema</span><span class="o">(),</span> <span class="s">"hr"</span><span class="o">,</span> <span class="k">new</span> <span class="nf">HrSchema</span><span class="o">());</span> + <span class="n">calciteConnection</span><span class="o">.</span><span class="na">getRootSchema</span><span class="o">(),</span> <span class="s">"hr"</span><span class="o">,</span> <span class="k">new</span> <span class="n">HrSchema</span><span class="o">());</span> <span class="n">Statement</span> <span class="n">statement</span> <span class="o">=</span> <span class="n">calciteConnection</span><span class="o">.</span><span class="na">createStatement</span><span class="o">();</span> <span class="n">ResultSet</span> <span class="n">resultSet</span> <span class="o">=</span> <span class="n">statement</span><span class="o">.</span><span class="na">executeQuery</span><span class="o">(</span> - <span class="s">"select d.deptno, min(e.empid)\n"</span> - <span class="o">+</span> <span class="s">"from hr.emps as e\n"</span> - <span class="o">+</span> <span class="s">"join hr.depts as d\n"</span> - <span class="o">+</span> <span class="s">" on e.deptno = d.deptno\n"</span> - <span class="o">+</span> <span class="s">"group by d.deptno\n"</span> - <span class="o">+</span> <span class="s">"having count(*) > 1"</span><span class="o">);</span> + <span class="s">"select d.deptno, min(e.empid)\n"</span> + <span class="o">+</span> <span class="s">"from hr.emps as e\n"</span> + <span class="o">+</span> <span class="s">"join hr.depts as d\n"</span> + <span class="o">+</span> <span class="s">" on e.deptno = d.deptno\n"</span> + <span class="o">+</span> <span class="s">"group by d.deptno\n"</span> + <span class="o">+</span> <span class="s">"having count(*) > 1"</span><span class="o">);</span> <span class="n">print</span><span class="o">(</span><span class="n">resultSet</span><span class="o">);</span> <span class="n">resultSet</span><span class="o">.</span><span class="na">close</span><span class="o">();</span> <span class="n">statement</span><span class="o">.</span><span class="na">close</span><span class="o">();</span> -<span class="n">connection</span><span class="o">.</span><span class="na">close</span><span class="o">();</span></code></pre></div> +<span class="n">connection</span><span class="o">.</span><span class="na">close</span><span class="o">();</span></code></pre></figure> <p>Where is the database? There is no database. The connection is -completely empty until <code>ReflectiveSchema.create</code> registers a Java -object as a schema and its collection fields <code>emps</code> and <code>depts</code> as +completely empty until <code class="highlighter-rouge">ReflectiveSchema.create</code> registers a Java +object as a schema and its collection fields <code class="highlighter-rouge">emps</code> and <code class="highlighter-rouge">depts</code> as tables.</p> <p>Calcite does not want to own data; it does not even have favorite data format. This example used in-memory data sets, and processed them -using operators such as <code>groupBy</code> and <code>join</code> from the linq4j +using operators such as <code class="highlighter-rouge">groupBy</code> and <code class="highlighter-rouge">join</code> from the linq4j library. But Calcite can also process data in other data formats, such as JDBC. In the first example, replace</p> -<div class="highlight"><pre><code class="language-java" data-lang="java"><span class="n">ReflectiveSchema</span><span class="o">.</span><span class="na">create</span><span class="o">(</span><span class="n">calciteConnection</span><span class="o">,</span> - <span class="n">calciteConnection</span><span class="o">.</span><span class="na">getRootSchema</span><span class="o">(),</span> <span class="s">"hr"</span><span class="o">,</span> <span class="k">new</span> <span class="nf">HrSchema</span><span class="o">());</span></code></pre></div> +<figure class="highlight"><pre><code class="language-java" data-lang="java"><span class="n">ReflectiveSchema</span><span class="o">.</span><span class="na">create</span><span class="o">(</span><span class="n">calciteConnection</span><span class="o">,</span> + <span class="n">calciteConnection</span><span class="o">.</span><span class="na">getRootSchema</span><span class="o">(),</span> <span class="s">"hr"</span><span class="o">,</span> <span class="k">new</span> <span class="n">HrSchema</span><span class="o">());</span></code></pre></figure> <p>with</p> -<div class="highlight"><pre><code class="language-java" data-lang="java"><span class="n">Class</span><span class="o">.</span><span class="na">forName</span><span class="o">(</span><span class="s">"com.mysql.jdbc.Driver"</span><span class="o">);</span> -<span class="n">BasicDataSource</span> <span class="n">dataSource</span> <span class="o">=</span> <span class="k">new</span> <span class="nf">BasicDataSource</span><span class="o">();</span> -<span class="n">dataSource</span><span class="o">.</span><span class="na">setUrl</span><span class="o">(</span><span class="s">"jdbc:mysql://localhost"</span><span class="o">);</span> -<span class="n">dataSource</span><span class="o">.</span><span class="na">setUsername</span><span class="o">(</span><span class="s">"username"</span><span class="o">);</span> -<span class="n">dataSource</span><span class="o">.</span><span class="na">setPassword</span><span class="o">(</span><span class="s">"password"</span><span class="o">);</span> -<span class="n">JdbcSchema</span><span class="o">.</span><span class="na">create</span><span class="o">(</span><span class="n">calciteConnection</span><span class="o">.</span><span class="na">getRootSchema</span><span class="o">(),</span> <span class="s">"name"</span><span class="o">,</span> <span class="n">dataSource</span><span class="o">,</span> - <span class="kc">null</span><span class="o">,</span> <span class="s">"hr"</span><span class="o">);</span></code></pre></div> +<figure class="highlight"><pre><code class="language-java" data-lang="java"><span class="n">Class</span><span class="o">.</span><span class="na">forName</span><span class="o">(</span><span class="s">"com.mysql.jdbc.Driver"</span><span class="o">);</span> +<span class="n">BasicDataSource</span> <span class="n">dataSource</span> <span class="o">=</span> <span class="k">new</span> <span class="n">BasicDataSource</span><span class="o">();</span> +<span class="n">dataSource</span><span class="o">.</span><span class="na">setUrl</span><span class="o">(</span><span class="s">"jdbc:mysql://localhost"</span><span class="o">);</span> +<span class="n">dataSource</span><span class="o">.</span><span class="na">setUsername</span><span class="o">(</span><span class="s">"username"</span><span class="o">);</span> +<span class="n">dataSource</span><span class="o">.</span><span class="na">setPassword</span><span class="o">(</span><span class="s">"password"</span><span class="o">);</span> +<span class="n">JdbcSchema</span><span class="o">.</span><span class="na">create</span><span class="o">(</span><span class="n">calciteConnection</span><span class="o">.</span><span class="na">getRootSchema</span><span class="o">(),</span> <span class="s">"name"</span><span class="o">,</span> <span class="n">dataSource</span><span class="o">,</span> + <span class="kc">null</span><span class="o">,</span> <span class="s">"hr"</span><span class="o">);</span></code></pre></figure> <p>and Calcite will execute the same query in JDBC. To the application, the data and API are the same, but behind the scenes the implementation is very different. Calcite uses optimizer rules to push -the <code>JOIN</code> and <code>GROUP BY</code> operations to the source database.</p> +the <code class="highlighter-rouge">JOIN</code> and <code class="highlighter-rouge">GROUP BY</code> operations to the source database.</p> <p>In-memory and JDBC are just two familiar examples. Calcite can handle any data source and data format. To add a data source, you need to @@ -966,74 +966,50 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - - - - - - - - - - - <li class="current"><a href="/docs/index.html">Background</a></li> @@ -1044,116 +1020,78 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/tutorial.html">Tutorial</a></li> @@ -1164,20 +1102,14 @@ more details in the <a href="reference.h - - - - - - <li class=""><a href="/docs/algebra.html">Algebra</a></li> @@ -1196,14 +1128,10 @@ more details in the <a href="reference.h - - - - <li class=""><a href="/docs/adapter.html">Adapters</a></li> @@ -1214,104 +1142,70 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/stream.html">Streaming</a></li> @@ -1322,80 +1216,54 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/lattice.html">Lattices</a></li> @@ -1414,38 +1282,26 @@ more details in the <a href="reference.h - - - - - - - - - - - - <li class=""><a href="/docs/avatica_overview.html">Overview</a></li> @@ -1456,50 +1312,34 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - - - <li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li> @@ -1510,32 +1350,22 @@ more details in the <a href="reference.h - - - - - - - - - - <li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li> @@ -1546,44 +1376,30 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - <li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li> @@ -1602,98 +1418,66 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/reference.html">SQL language</a></li> @@ -1704,86 +1488,58 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/model.html">JSON models</a></li> @@ -1794,68 +1550,46 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/howto.html">HOWTO</a></li> @@ -1874,62 +1608,42 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/history.html">History</a></li> @@ -1940,92 +1654,62 @@ more details in the <a href="reference.h - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li> @@ -2036,143 +1720,161 @@ more details in the <a href="reference.h - - - - - - - - - <li class=""><a href="/docs/api.html">API</a></li> - - - - - - - - - - - + + - - - + + + - + + + - + + + - + + + - + + + - + + + + + + + + + + + + - + + + - + + + - + + + - + + + - + + + - + + + - + + + - + + + - + - <li class=""><a href="/docs/testapi.html">Test API</a></li> - + + + </ul>
Modified: calcite/site/docs/lattice.html URL: http://svn.apache.org/viewvc/calcite/site/docs/lattice.html?rev=1739659&r1=1739658&r2=1739659&view=diff ============================================================================== --- calcite/site/docs/lattice.html (original) +++ calcite/site/docs/lattice.html Sun Apr 17 21:26:04 2016 @@ -4,7 +4,7 @@ <meta charset="UTF-8"> <title>Lattices</title> <meta name="viewport" content="width=device-width,initial-scale=1"> - <meta name="generator" content="Jekyll v2.4.0"> + <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"> @@ -982,74 +982,50 @@ tiles).</p> - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/index.html">Background</a></li> @@ -1060,116 +1036,78 @@ tiles).</p> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/tutorial.html">Tutorial</a></li> @@ -1180,20 +1118,14 @@ tiles).</p> - - - - - - <li class=""><a href="/docs/algebra.html">Algebra</a></li> @@ -1212,14 +1144,10 @@ tiles).</p> - - - - <li class=""><a href="/docs/adapter.html">Adapters</a></li> @@ -1230,104 +1158,70 @@ tiles).</p> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/stream.html">Streaming</a></li> @@ -1338,80 +1232,54 @@ tiles).</p> - - - - - - - - - - - - - - - - - - - - - - - - - - <li class="current"><a href="/docs/lattice.html">Lattices</a></li> @@ -1430,38 +1298,26 @@ tiles).</p> - - - - - - - - - - - - <li class=""><a href="/docs/avatica_overview.html">Overview</a></li> @@ -1472,50 +1328,34 @@ tiles).</p> - - - - - - - - - - - - - - - - <li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li> @@ -1526,32 +1366,22 @@ tiles).</p> - - - - - - - - - - <li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li> @@ -1562,44 +1392,30 @@ tiles).</p> - - - - - - - - - - - - - - <li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li> @@ -1618,98 +1434,66 @@ tiles).</p> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/reference.html">SQL language</a></li> @@ -1720,86 +1504,58 @@ tiles).</p> - - - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/model.html">JSON models</a></li> @@ -1810,68 +1566,46 @@ tiles).</p> - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/howto.html">HOWTO</a></li> @@ -1890,62 +1624,42 @@ tiles).</p> - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/history.html">History</a></li> @@ -1956,92 +1670,62 @@ tiles).</p> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - <li class=""><a href="/docs/powered_by.html">Powered By Calcite</a></li> @@ -2052,143 +1736,161 @@ tiles).</p> - - - - - - - - - <li class=""><a href="/docs/api.html">API</a></li> - - - - - - - - - - - + + - - - + + + - + + + - + + + - + + + - + + + - + + + + + + + + + + + + - + + + - + + + - + + + - + + + - + + + - + + + - + + + - + + + - + - <li class=""><a href="/docs/testapi.html">Test API</a></li> - + + + </ul>
