elasticsearch7.x kibana的常用DSL(自己练习的)

本文涉及的产品
检索分析服务 Elasticsearch 版,2核4GB开发者规格 1个月
简介: elasticsearch7.x kibana的常用DSL(自己练习的)
GET bank/_mapping
GET bank/_search
GET bank/_search
{
  "aggs": {
    "age_group": {
      "range": {
        "field": "age",
        "ranges": [
          {
            "from": 20,
            "to": 29
          },
           {
            "from": 30,
            "to": 39
          },
          {
            "from": 40,
            "to": 49
          }
        ]
      }, 
      "aggs": {
        "gender_group": {
          "terms": {
            "field": "gender.keyword"
          },
          "aggs": {
            "balance_avg": {
              "avg": {
                "field": "balance"
              }
            }
          }
        }
      }
    }
  },
  "size": 0
}
GET bank/_search
{
  "aggs": {
    "state_group": {
      "terms": {
        "field": "state.keyword",
        "order": {
          "balance_avg": "asc"
        }
      },
      "aggs": {
        "balance_avg": {
          "avg": {
            "field": "balance"
          }
        }
      }
    }
  },
  "size": 0
}
GET bank/_search
{
  "aggs": {
    "state_group": {
      "terms": {
        "field": "state.keyword"
      },
      "aggs": {
        "balance_avg": {
          "avg": {
            "field": "balance"
          }
        }
      }
    }
  },
  "size": 0
}
GET bank/_search
{
  "aggs": {
    "state_group": {
      "terms": {
        "field": "state.keyword"
      }
    }
  },
  "size": 0
}
GET bank/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "range": {
           "balance": {
            "gte": 20000,
            "lte": 30000
      }
          }
        }
      ]
    }
  },
  "sort": [
    {
      "balance": {
        "order": "desc"
      }
    }
  ]
}
GET bank/_search
{
  "query": {
    "range": {
      "balance": {
        "gte": 20000,
        "lte": 30000
      }
    }
  },
  "sort": [
    {
      "balance": {
        "order": "desc"
      }
    }
  ]
}
GET bank/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "age": 40
          }
        }
      ], 
      "must_not": [
        {
          "match": {
            "state": "ID"
          }
        }
      ]
    }
  }
}
GET bank/_search
{
  "query": {
    "bool": {
      "must_not": [
        {
          "match": {
            "address": "mill"
          }
        },
        {
           "match": {
            "address": "lane"
          }
        }
      ]
    }
  }
}
GET bank/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "address": "mill"
          }
        },
        {
           "match": {
            "address": "lane"
          }
        }
      ]
    }
  }
}
GET bank/_search
{
  "query": {
    "match_phrase": {
      "address": "mill lane"
    }
  }
}
GET bank/_search
{
  "query": {
    "bool": {
      "should": [
        {
          "match": {
            "address": "mile"
          }
        },
         {
          "match": {
            "address": "lane"
          }
        }
      ]
    }
  }
}
GET bank/_search
{
  "query": {
    "match": {
      "address": "mill lane"
    }
  }
}
GET bank/_search
{
  "query": {
    "match": {
      "address": "mill"
    }
  }
}
GET bank/_search?q=account_number:20
GET bank/_search
{
  "query": {
    "match": {
      "account_number": "20"
    }
  }
}
GET bank/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "account_number": 20
          }
        }
      ]
    }
  }
}
GET /bank/_search
{
  "query": {
    "match_all": {}
  },
  "_source": ["account_number","balance"]
}
GET bank/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {
      "balance": {
        "order": "desc"
      }
    }
  ],
  "size": 10
}
POST bank/_update/1
{
  "script":"ctx._source.age+=5"
}
GET bank/_doc/1
POST my_index/_doc
{
  "productName":"雪花啤酒100L"
}
GET my_index/_search
{
  "query": {
    "match": {
      "productName": "xh"
    }
  }
}
PUT /my_index/_mapping
{
  "properties":{
    "productName":{
      "type":"text",
      "analyzer":"ik_pinyin_analyzer",
      "search_analyzer":"ik_pingying_smark"
    }
  }
}
PUT my_index
{
  "settings": {
    "analysis": {
      "analyzer": {
        "ik_pinyin_analyzer": {
          "type": "custom",
          "tokenizer": "ik_smart",
          "filter": [
            "pinyin_max_word_filter"
          ]
        },
        "ik_pingying_smark": {
          "type": "custom",
          "tokenizer": "ik_smart",
          "filter": [
            "pinyin_smark_word_filter"
          ]
        }
      },
      "filter": {
        "pinyin_max_word_filter": {
          "type": "pinyin",
          "keep_full_pinyin": "true", 
          "keep_separate_first_letter": "true",
          "keep_joined_full_pinyin": true 
        },
        "pinyin_smark_word_filter": {
          "type": "pinyin",
          "keep_separate_first_letter": "false", 
          "keep_first_letter": "false"     
        }
      }
    }
  }
}
POST /_analyze
{
  "analyzer": "pinyin",
  "text":"我是中国人"
}
POST /_analyze
{
  "analyzer": "simple",
  "text": "决战到天亮"
}
POST /_analyze
{
  "analyzer": "ik_smart",
  "text": "我是中国人"
}
POST /_analyze
{
  "analyzer": "ik_max_word",
  "text": "太白"
}
POST bank/_search
{
  "aggs": {
    "group_by_age": {
      "range": {
        "field": "age",
        "ranges": [
          {
            "from": 20,
            "to": 30
          },
          {
            "from": 30,
            "to": 40
          },
          {
            "from": 40,
            "to": 50
          }
        ]
      }
    }
  },
  "size": 0
}
POST bank/_search
{
  "aggs": {
    "taibai": {
      "terms": {
        "field": "age"
      },
      "aggs": {
        "count": {
          "top_hits": {
            "size": 3
          }
        }
      }
    }
  },
  "size": 0
}
POST bank/_search
{
  "aggs": {
    "taibai": {
      "terms": {
        "field": "age"
      }
    }
  },
  "size": 0
}
POST bank/_search
{
  "aggs": {
    "taibai": {
      "value_count": {
        "field": "age"
      }
    }
  },
  "size": 0
}
POST bank/_search
{
  "aggs": {
    "taibai": {
      "extended_stats": {
        "field": "age"
      }
    }
  },
  "size": 0
}
POST bank/_search
{
  "aggs": {
    "taibai": {
      "cardinality": {
        "field": "age"
      }
    }
  },
  "size": 0
}
POST bank/_search
{
  "aggs": {
    "taibai": {
      "avg": {
        "script": {
          "source": "doc.age.value"
        }
      }
    }
  },
  "size": 0
}
POST bank/_search
{
  "aggs":{
    "taibai":{
      "avg":{
        "field": "age"
      }
    }
  },
  "size":0
}
GET taibai/_search
{
  "query": {
     "bool": {
       "must": 
         {
           "term": {
             "sex":  "男"
           }
         },
         "must_not": 
         {
           "term": {
             "age":  "29"
           }
         },
         "should":[
           {
             "term":{
             "sex": "男"
             }
           },
            {"term":{
              "id": "1003"
            }
           }
         ]
     }
  }
}
GET taibai/_search
{
  "query": {
    "match": {
      "name": "三"
    }
  }
}
GET taibai/_search
{
  "query": {
    "range": {
      "age": {
        "gte": 20,
        "lte": 30
      }
    }
  }
}
GET taibai/_search
{
  "query": {
    "exists": {
      "field": "age"
    }
  }
}
GET taibai/_search
{
  "query": {
    "term": {
      "name.keyword": "张三"
    }
  }
}
POST /_analyze
{
  "analyzer":"standard",
  "text":"决战到天亮"
}
POST /_analyze
{
  "analyzer":"ik_max_word",
  "text":"决战到天亮"
}
POST /_analyze
{
  "analyzer": "standard",
  "text": "张三"
}
GET taibai/_mapping
GET taibai/_search
{
  "query": {
    "term": {
      "name": "张三"
    }
  }
}
GET taibai/_search
GET /bank/_search
{
  "size": 2,
  "from": 0,
  "sort": [
    {
      "_id": {
        "order": "asc"
      }
    }
  ],
  "search_after":[
    1
  ]
}
//浅分页
GET bank/_search
{
  "size": 20,
  "from": 0,
  "sort": [
    {
      "_id": {
        "order": "desc"
      }
    }
  ]
}
GET /bank/_search?scroll=5m
{
  "size": 20,
  "from": 0,
  "sort": [
    {
      "_id": {
        "order": "desc"
      }
    }
  ]
}
GET _search/scroll
{
  "scroll_id":
  "FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFkM2RkJhMEFGU3g2OWZLQ0trNEpzcVEAAAAAAAAIyBZ4UEV6VFpWTlFoZXNhMkRQNHdZZVh3",
   "scroll":"5m"
}
DELETE _search/scroll/FGluY2x1ZGVfY29udGV4dF91dWlkDXF1ZXJ5QW5kRmV0Y2gBFkM2RkJhMEFGU3g2OWZLQ0trNEpzcVEAAAAAAAAIyBZ4UEV6VFpWTlFoZXNhMkRQNHdZZVh3
DELETE _search/scroll/_all
GET bank/_search
{
  "query": {
    "match_all": {}
  },
   "sort": [
    {
      "_id": {
        "order": "asc"
      }
    }
  ],
  "size": 4,
  "from": 0
}
POST _bulk 
{ "create" :{ "_index" : "taibai", "_id" : "101" } }
{"id":101,"name":"name1","age": 20,"sex": "男"} 
{ "create" : { "_index" : "taibai", "_id" : "401" }}
{"id":401,"name":"name1","age": 20,"sex": "男"}
POST _bulk
{ "update" :{ "_index" : "taibai", "_id" : "101" } }
{"doc": {"id":101,"name":"name101","age": 201,"sex": "男101"}}
{ "update" : { "_index" : "taibai", "_id" : "401" }}
{"doc": {"id":401,"name":"name401","age": 20401,"sex": "男401"}}
POST _bulk 
{ "delete":{ "_index" : "taibai", "_id":"101" }}
{ "delete": { "_index" : "taibai", "_id":"401" }} 
GET taibai/_search
GET /bank/_mget
{
  "ids":[
    "1","40"
    ]
}
GET bank/_source/40?_source=age,email
GET bank/_doc/40?_source=id,name
GET bank/_search?q=age:23
GET bank/_search
{
  "query": {
    "match_all": {}
  },
  "size": 1000,
  "from": 0
}
GET taibai/_search
POST taibai/_doc
{
  "id":1001,
  "name" : "张三",
  "age" : 22,
  "sex" : "男"
}
GET kuangshen/user/_search
{
  "query":{
    "match": {
      "name": "狂神"
    }
  },
  "_source":["name","desc"] 
}
POST taibai/_doc/1001
{
  "id":1002,
  "name":"太白"
}
GET taibai/_search
PUT /taibai
{
  "settings": {
    "number_of_replicas": 0,
    "number_of_shards": 1
  }
}
DELETE taibai
POST taibai/_doc
{
  "id":1001,
  "name":"taibai"
}
PUT taibai/_doc/1002
{
  "id":1002,
  "name":"taibai",
   "age":21,
   "sex":"哈哈"
}
POST /taibai/_update/1002
{
  "doc": {
    "age":21
  }
}
GET /taibai/_doc/1002
DELETE taibai/_doc/9gU0l3sBa2-WIiyKQyQG

相关实践学习
利用Elasticsearch实现地理位置查询
本实验将分别介绍如何使用Elasticsearch7.10版本进行全文检索、多语言检索和地理位置查询三个Elasticsearch基础检索子场景的实现。
ElasticSearch 入门精讲
ElasticSearch是一个开源的、基于Lucene的、分布式、高扩展、高实时的搜索与数据分析引擎。根据DB-Engines的排名显示,Elasticsearch是最受欢迎的企业搜索引擎,其次是Apache Solr(也是基于Lucene)。 ElasticSearch的实现原理主要分为以下几个步骤: 用户将数据提交到Elastic Search 数据库中 通过分词控制器去将对应的语句分词,将其权重和分词结果一并存入数据 当用户搜索数据时候,再根据权重将结果排名、打分 将返回结果呈现给用户 Elasticsearch可以用于搜索各种文档。它提供可扩展的搜索,具有接近实时的搜索,并支持多租户。
相关文章
|
2月前
|
数据可视化 索引
elasticsearch head、kibana 安装和使用
elasticsearch head、kibana 安装和使用
|
24天前
|
Docker 容器
docker 运行 elasticsearch + kibana + head 集群
docker 运行 elasticsearch + kibana + head 集群
|
3天前
|
Java API 索引
必知的技术知识:Elasticsearch和Kibana安装
必知的技术知识:Elasticsearch和Kibana安装
|
2月前
|
监控 应用服务中间件 nginx
使用 Docker Compose V2 快速搭建日志分析平台 ELK (Elasticsearch、Logstash 和 Kibana)
ELK的架构有多种,本篇分享使用的架构如图所示: Beats(Filebeat) -> -> Elasticsearch -> Kibana,目前生产环境一天几千万的日志,内存占用大概 10G
70 4
|
2月前
|
安全 Linux 测试技术
在CentOS上安装Elasticsearch和Kibana
在CentOS上安装Elasticsearch和Kibana
48 0
|
2月前
|
安全 Linux 数据安全/隐私保护
Windows 部署 Elasticsearch + kibana 8.0 指南
Windows 部署 Elasticsearch + kibana 8.0 指南
59 0
|
2月前
|
存储 安全 网络协议
云服务器 Centos7 部署 Elasticsearch 8.0 + Kibana 8.0 指南
云服务器 Centos7 部署 Elasticsearch 8.0 + Kibana 8.0 指南
54 0
|
2月前
|
监控 数据可视化 关系型数据库
MetricBeat + Elasticsearch + Kibana 实现监控指标可视化
MetricBeat + Elasticsearch + Kibana 实现监控指标可视化
26 0
|
2月前
|
安全 数据可视化 Java
linux安装ElasticSearch7.1和 kibana 启动
linux安装ElasticSearch7.1和 kibana 启动
27 1
|
2月前
|
开发工具
elasticsearch kibana设置 添加开机启动
elasticsearch kibana设置 添加开机启动
24 0