Elasticsearch 认证模拟题 - 16

一、题目

创建一个搜索模版,要求 match_prase 查询,并且用指定的格式高亮,并排序

# 创建索引
PUT my_index
{
  "settings": {
    "number_of_replicas": 0,
    "number_of_shards": 1
  },
  "mappings": {
    "properties": {
      "a":{
        "type": "text"
      },
      "b":{
        "type": "integer"
      }
    }
  }
}

# 灌入数据
POST my_index/_bulk
{"index":{}}
{"a":"elasticsearch in action", "b":1}
{"index":{}}
{"a":"kibana in action", "b":2}
1.1 考点
  1. 搜索模板
  2. 高亮
  3. 排序
1.2 答案
# 创建索引模板
PUT _scripts/my_search_template
{
  "script": {
    "lang": "mustache",
    "source": {
      "query": {
        "match_phrase": {
          "a": "{{query_string}}"
        }
      },
      "highlight": {
        "fields": {
          "a": {
            "pre_tags": [
              "<em>"
            ],
            "post_tags": [
              "</em>"
            ]
          }
        }
      },
      "sort": [
        {
          "b": "desc"
        }
      ]
    }
  }
}

# 查询索引模板预览
POST _render/template
{
  "id": "my_search_template",
  "params": {
    "query_string": "hello world"
  }
}

# 查询结果验证
GET my_index/_search/template
{
  "id": "my_search_template",
  "params": {
    "query_string": "kibana is action"
  }
}

二、题目

查询索引 task1,获取每个月 price 字段的平均值,并返回 2022 年的数据。

PUT task1
{
  "settings": {
    "number_of_replicas": 0,
    "number_of_shards": 1
  },
  "mappings": {
    "properties": {
      "rq":{
        "type": "date"
      },
      "price":{
        "type": "integer"
      }
    },
    "runtime":{
      "price_flag":{
        "type":"long",
        "script":{
          "source":
          """
          if(doc['price'].value<=100 && doc['price'].value>0) 
          emit(-1);
          if(doc['price'].value>100 && doc['price'].value<=200) 
          emit(1);
          """
        }
      }
    }
  }
}

POST task1/_bulk
{"index":{}}
{"rq":"2021-01-01","price":"50"}
{"index":{}}
{"rq":"2021-02-01","price":"150"}
{"index":{}}
{"rq":"2021-03-01","price":"250"}
{"index":{}}
{"rq":"2021-04-01","price":"50"}
{"index":{}}
{"rq":"2021-05-01","price":"250"}
{"index":{}}
{"rq":"2021-06-01","price":"150"}
{"index":{}}
{"rq":"2021-07-01","price":"50"}
{"index":{}}
{"rq":"2021-08-01","price":"450"}
{"index":{}}
{"rq":"2021-09-01","price":"80"}
{"index":{}}
{"rq":"2021-10-01","price":"550"}
{"index":{}}
{"rq":"2021-11-01","price":"50"}
{"index":{}}
{"rq":"2021-12-01","price":"500"}
{"index":{}}
{"rq":"2021-12-01","price":"50"}
{"index":{}}
{"rq":"2022-01-01","price":"200"}
2.1 考点
  1. 聚合
  2. 聚合后通过查询过滤结果(这个知识点真的是一顿好找)
2.2 答案
GET task1/_search
{
  "aggs": {
    "every_month": {
      "date_histogram": {
        "field": "rq",
        "calendar_interval": "month"
      },
      "aggs": {
        "avg_price": {
          "avg": {
            "field": "price"
          }
        }
      }
    }
  },
  "post_filter": {
    "range": {
      "rq": {
        "gte": "2021-12-31",
        "lte": "2023-01-01"
      }
    }
  }
}

在这里插入图片描述

相关推荐

  1. Elasticsearch 认证模拟 - 10

    2024-06-09 01:02:02       7 阅读
  2. Elasticsearch 认证模拟 - 12

    2024-06-09 01:02:02       3 阅读
  3. Elasticsearch 认证模拟 - 6

    2024-06-09 01:02:02       5 阅读

最近更新

  1. 运维监控系统

    2024-06-09 01:02:02       0 阅读
  2. ArrayList<Integer>()转为int[]的几种方式

    2024-06-09 01:02:02       0 阅读
  3. c++_0基础_讲解5 判断语句

    2024-06-09 01:02:02       0 阅读
  4. 算法训练营day23补签

    2024-06-09 01:02:02       0 阅读
  5. ISO七层模型 tcp/ip

    2024-06-09 01:02:02       0 阅读
  6. 2022C语言二级真题

    2024-06-09 01:02:02       0 阅读
  7. TCP协议参数设置&说明

    2024-06-09 01:02:02       0 阅读

热门阅读

  1. Ratchet websocket token 验证

    2024-06-09 01:02:02       5 阅读
  2. Composition API函数

    2024-06-09 01:02:02       3 阅读
  3. Python入门Git:探索版本控制的奥秘

    2024-06-09 01:02:02       5 阅读
  4. advices about writing promotion ppt

    2024-06-09 01:02:02       5 阅读
  5. KMeans聚类分析星

    2024-06-09 01:02:02       3 阅读
  6. 中介子方程七

    2024-06-09 01:02:02       5 阅读
  7. C++的封装(十二):外部构造函数

    2024-06-09 01:02:02       3 阅读
  8. 服务器硬件基础知识有哪些?

    2024-06-09 01:02:02       5 阅读
  9. Linux的命令补全脚本

    2024-06-09 01:02:02       5 阅读
  10. Android Camera APP预览画面镜像及旋转处理

    2024-06-09 01:02:02       3 阅读
  11. 请求分页存储管理方式

    2024-06-09 01:02:02       5 阅读
  12. Flink 容错

    2024-06-09 01:02:02       4 阅读