初步分析 Elasticsearch 文档

崔哥

发布于 2023-04-06 09:37:03

4290

文章被收录于专栏：崔哥的专栏崔哥的专栏

Query DSL

Elasticsearch提供基于JSON的完整查询DSL（Domain Specific Language）来定义查询。

https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl.html

例如：

GET /_search
{
  "query": { 
    "bool": { 
      "must": [
        { "match": { "title":   "Search"        }},
        { "match": { "content": "Elasticsearch" }}
      ],
      "filter": [ 
        { "term":  { "status": "published" }},
        { "range": { "publish_date": { "gte": "2015-01-01" }}}
      ]
    }
  }
}

REST API

https://www.elastic.co/guide/en/elasticsearch/reference/current/rest-apis.html

SQL

https://www.elastic.co/guide/en/elasticsearch/reference/current/xpack-sql.html

POST _sql?format=txt
{
    "query": "SELECT title FROM article limit 10"
}

SQL翻译API

SQL 转 Query DSL

POST /_sql/translate
{
  "query": "SELECT * FROM article ORDER BY id DESC",
  "fetch_size": 10
}

三个双引号的使用（使用 Kibana Console 才支持）

POST /_sql/translate
{
  "query": """
  SELECT * FROM "index-*" ORDER BY id DESC
  """,
  "fetch_size": 10
}

SQL CLI

中文有乱码，待解决。。

root@elasticsearch:/usr/share/elasticsearch# ./bin/elasticsearch-sql-cli

# root@elasticsearch:/usr/share/elasticsearch# ./bin/elasticsearch-sql-cli https://some.server:9200

# root@elasticsearch:/usr/share/elasticsearch# ./bin/elasticsearch-sql-cli https://sql_user:strongpassword@some.server:9200

sql> SELECT title FROM article limit 10;
                 title                 
---------------------------------------
vmware u5b89u88c5 android-x86    
Elastic Stack
logstash
yum logstash
Docker - Android
Docker for Android SDK
docker-compose RocketMQ           
vscode php         

sql>