Author: sereda
Date: Thu Jan 3 03:58:27 2019
New Revision: 1850215
URL: http://svn.apache.org/viewvc?rev=1850215&view=rev
Log:
added example with query without view
Modified:
calcite/site/docs/elasticsearch_adapter.html
Modified: calcite/site/docs/elasticsearch_adapter.html
URL:
http://svn.apache.org/viewvc/calcite/site/docs/elasticsearch_adapter.html?rev=1850215&r1=1850214&r2=1850215&view=diff
==============================================================================
--- calcite/site/docs/elasticsearch_adapter.html (original)
+++ calcite/site/docs/elasticsearch_adapter.html Thu Jan 3 03:58:27 2019
@@ -153,7 +153,7 @@ in Elasticsearch where possible.</p>
named <code class="highlighter-rouge">zips</code> under index named <code
class="highlighter-rouge">usa</code>.</p>
<p>We can issue a simple query to fetch the names of all the states
-stored in the type <code class="highlighter-rouge">zips</code>. By default,
Elasticsearch returns only 10 rows:</p>
+stored in the type <code class="highlighter-rouge">zips</code>.</p>
<figure class="highlight"><pre><code class="language-sql"
data-lang="sql"><span class="n">sqlline</span><span class="o">></span> <span
class="k">SELECT</span> <span class="o">*</span> <span class="k">from</span>
<span class="nv">"zips"</span><span class="p">;</span></code></pre></figure>
@@ -202,6 +202,10 @@ Elasticsearch in ascending order.</p>
</span><span class="p">]</span><span class="w">
</span><span class="p">}</span></code></pre></figure>
+<p>You can also query elastic search index without prior view definition:</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="n">_MAP</span><span
class="p">[</span><span class="s1">'city'</span><span class="p">],</span> <span
class="n">_MAP</span><span class="p">[</span><span
class="s1">'state'</span><span class="p">]</span> <span class="k">from</span>
<span class="nv">"elasticsearch"</span><span class="p">.</span><span
class="nv">"zips"</span> <span class="k">order</span> <span class="k">by</span>
<span class="n">_MAP</span><span class="p">[</span><span
class="s1">'state'</span><span class="p">];</span></code></pre></figure>
+
<h3 id="use-of-scrolling-api">Use of Scrolling API</h3>
<p>For queries without aggregate functions (like <code
class="highlighter-rouge">COUNT</code>, <code
class="highlighter-rouge">MAX</code> etc.) elastic adapter
uses <a
href="https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-scroll.html";>scroll
API</a>, by default.
@@ -530,7 +534,7 @@ we try to follow official <a href="https
<img src="/img/feather.png" width="190" height="77" alt="Apache
Logo"></a>
</div>
<div id="copyright">
- <p>The contents of this website are Copyright © 2018
+ <p>The contents of this website are Copyright © 2019
<a href="https://www.apache.org/";>Apache Software Foundation</a>
under the terms of
the <a href="https://www.apache.org/licenses/";>
