准备数据

复制代码在Kibana 开发工具执行完成模拟数据导入。

创建索引

PUT score
{
  "settings": {
    "number_of_shards": 1,
    "number_of_replicas": 0
  },
  "mappings": {
    "properties": {
      "name": {
        "type": "keyword"
      },
      "gender":{
        "type":"keyword"
      },
      "subject": {
        "type": "keyword"
      },
      "value": {
        "type": "long"
      }
    }
  }
}

这是一份模拟的成绩表，其中包含的字段含义

字段说明

• name： 姓名
• gender: 性别
• subject: 学科
• value: 成绩

填充一些数据

POST score/_bulk
POST score/_bulk
{ "index" : { "_type" : "_doc" } }
{ "name" : "Olivia",  "gender":"female", "subject":"physics", "value":90 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Sophia",  "gender":"female","subject":"physics", "value":80 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Ethan",  "gender":"male","subject":"physics", "value":77 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Sophia", "gender":"female",  "subject":"physics", "value":92 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Alexander", "gender":"male", "subject":"physics", "value":65 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Benjamin", "gender":"male",  "subject":"physics", "value":87 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Emma", "gender":"male",  "subject":"physics", "value":88 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Noah", "gender":"male",  "subject":"physics", "value":93 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Liam", "gender":"male",  "subject":"physics", "value":79 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Ava", "gender":"female", "subject":"physics", "value":59 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Isabella","gender":"female",  "subject":"physics", "value":90 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Olivia",  "gender":"female", "subject":"maths", "value":83 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Sophia",  "gender":"female","subject":"maths", "value":90 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Ethan",  "gender":"male","subject":"maths", "value":67 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Sophia", "gender":"female",  "subject":"maths", "value":72 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Alexander", "gender":"male", "subject":"maths", "value":85 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Benjamin", "gender":"male",  "subject":"maths", "value":99 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Emma", "gender":"male",  "subject":"maths", "value":78 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Noah", "gender":"male",  "subject":"maths", "value":67 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Liam", "gender":"male",  "subject":"maths", "value":29 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Ava", "gender":"female", "subject":"maths", "value":87 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Isabella","gender":"female",  "subject":"maths", "value":40 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Olivia",  "gender":"female", "subject":"chemistry", "value":70 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Sophia",  "gender":"female","subject":"chemistry", "value":85 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Ethan",  "gender":"male","subject":"chemistry", "value":100 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Sophia", "gender":"female",  "subject":"chemistry", "value":86 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Alexander", "gender":"male", "subject":"chemistry", "value":59 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Benjamin", "gender":"male",  "subject":"chemistry", "value":67 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Emma", "gender":"male",  "subject":"chemistry", "value":98 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Noah", "gender":"male",  "subject":"chemistry", "value":73 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Liam", "gender":"male",  "subject":"chemistry", "value":59 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Ava", "gender":"female", "subject":"chemistry", "value":99 }
{ "index" : { "_type" : "_doc" } }
{ "name" : "Isabella","gender":"female",  "subject":"chemistry", "value":60 }