[calcite] branch site updated: Site: Elastic query example on _MAP

[se...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

sereda pushed a commit to branch site
in repository https://gitbox.apache.org/repos/asf/calcite.git


The following commit(s) were added to refs/heads/site by this push:
     new 2afea1f  Site: Elastic query example on _MAP
2afea1f is described below

commit 2afea1fc94c5cda594535f5d194b86f723e2e8be
Author: Andrei Sereda <25...@users.noreply.github.com>
AuthorDate: Thu Jan 3 11:33:36 2019 -0500

    Site: Elastic query example on _MAP
---
 site/_docs/elasticsearch_adapter.md | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

diff --git a/site/_docs/elasticsearch_adapter.md b/site/_docs/elasticsearch_adapter.md
index 3eff935..b9bab31 100644
--- a/site/_docs/elasticsearch_adapter.md
+++ b/site/_docs/elasticsearch_adapter.md
@@ -75,7 +75,7 @@ For example, in the example dataset there is an Elasticsearch type
 named `zips` under index named `usa`.
 
 We can issue a simple query to fetch the names of all the states
-stored in the type `zips`. By default, Elasticsearch returns only 10 rows:
+stored in the type `zips`. 
 
 {% highlight sql %}
 sqlline> SELECT * from "zips";
@@ -130,6 +130,12 @@ The final source json given to Elasticsearch is below:
 }
 {% endhighlight %}
 
+You can also query elastic search index without prior view definition:
+
+{% highlight sql %}
+sqlline> SELECT _MAP['city'], _MAP['state'] from "elasticsearch"."zips" order by _MAP['state'];
+{% endhighlight %}
+
 ### Use of Scrolling API
 For queries without aggregate functions (like `COUNT`, `MAX` etc.) elastic adapter 
 uses [scroll API](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-scroll.html), by default.