(calcite) branch main updated: [CALCITE-6758] Update Elasticsearch adapter tutorial document

[xiong]

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

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


The following commit(s) were added to refs/heads/main by this push:
     new 19d3730c92 [CALCITE-6758] Update Elasticsearch adapter tutorial 
document
19d3730c92 is described below

commit 19d3730c92f7bd518ef3763247410033c2f3840f
Author: Zhe Hu <iluff...@163.com>
AuthorDate: Sat Jan 4 08:31:54 2025 +0800

    [CALCITE-6758] Update Elasticsearch adapter tutorial document
---
 site/_docs/elasticsearch_adapter.md | 21 +++++++++------------
 1 file changed, 9 insertions(+), 12 deletions(-)

diff --git a/site/_docs/elasticsearch_adapter.md 
b/site/_docs/elasticsearch_adapter.md
index 4163fbc5c4..fde9625d43 100644
--- a/site/_docs/elasticsearch_adapter.md
+++ b/site/_docs/elasticsearch_adapter.md
@@ -114,32 +114,29 @@ The final source json given to Elasticsearch is below:
   "query": {
     "constant_score": {
       "filter": {
-        "bool": {
-          "must": [
-            {
-              "term": {
-                "city": "springfield"
-              }
-            }
-          ]
+        "term": {
+          "city": "springfield"
         }
       }
     }
   },
-  "fields": [
+  "_source": [
     "city",
     "state"
   ],
   "script_fields": {},
   "sort": [
     {
-      "state": "asc"
+      "state": {
+        "missing": "_last",
+        "order": "asc"
+      }
     }
   ]
 }
 {% endhighlight %}
 
-You can also query elastic search index without prior view definition:
+You can also query Elasticsearch index without prior view definition:
 
 {% highlight sql %}
 sqlline> SELECT _MAP['city'], _MAP['state'] from "elasticsearch"."usa" order 
by _MAP['state'];
@@ -154,6 +151,6 @@ scroll is automatically cleared (removed) when all query 
results are consumed.
 
 ### Supported versions
 
-Currently, this adapter supports ElasticSearch versions 6.x (or newer). 
Generally,
+Currently, this adapter supports Elasticsearch versions 6.x (or newer, up to 
7.15.2). Generally,
 we try to follow the official [support 
schedule](https://www.elastic.co/support/eol).
 Also, types are not supported (this adapter only supports indices).