创建一个成绩索引
前提条件：
ES集群正常启动
Kibana正常启动并连接到ES集群
成绩表字段说明：
姓名：name
性别：sex
课程：course
成绩：Score
课程说明：
语文：yuwen
数学：shuxue
英语：yingyu
创建索引，并配置mappings
#name为text类型，用于全文检索（需要安装ik中文分词器插件），可视化统计时text类型的字段是不显示的；name_keyword为keyword类型，用于可视化时聚合。如果仅仅是测试kibana可视化，可以去掉name字段或"analyzer": “ik_max_word”。
PUT chengji
{"mappings": {"properties": {"name": {"type": "text","analyzer": "ik_max_word"},"name_keyword": {"type": "keyword"},"sex": {"type": "keyword"},"course": {"type": "keyword"},"Score": {"type": "integer"}}}
}
执行与结果如图所示：
批量添加测试数据
POST _bulk
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"张三","name_keyword":"张三","sex":"男","course":"语文","Score":76}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"张三","name_keyword":"张三","sex":"男","course":"数学","Score":95}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"张三","name_keyword":"张三","sex":"男","course":"英语","Score":58}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"李四","name_keyword":"李四","sex":"男","course":"语文","Score":68}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"李四","name_keyword":"李四","sex":"男","course":"数学","Score":45}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"李四","name_keyword":"李四","sex":"男","course":"英语","Score":37}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"王五","name_keyword":"王五","sex":"男","course":"语文","Score":81}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"王五","name_keyword":"王五","sex":"男","course":"数学","Score":74}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"王五","name_keyword":"王五","sex":"男","course":"英语","Score":64}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"马六","name_keyword":"马六","sex":"男","course":"语文","Score":69}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"马六","name_keyword":"马六","sex":"男","course":"数学","Score":93}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"马六","name_keyword":"马六","sex":"男","course":"英语","Score":77}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"小丽","name_keyword":"小丽","sex":"女","course":"语文","Score":84}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"小丽","name_keyword":"小丽","sex":"女","course":"数学","Score":61}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"小丽","name_keyword":"小丽","sex":"女","course":"英语","Score":88}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"小梅","name_keyword":"小梅","sex":"女","course":"语文","Score":85}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"小梅","name_keyword":"小梅","sex":"女","course":"数学","Score":78}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"小梅","name_keyword":"小梅","sex":"女","course":"英语","Score":92}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"周美","name_keyword":"周美","sex":"男","course":"语文","Score":96}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"周美","name_keyword":"周美","sex":"男","course":"数学","Score":97}
{"index":{"_index":"chengji","_type":"_doc"}}
{"name":"周美","name_keyword":"周美","sex":"男","course":"英语","Score":93}
执行与结果如图所示：
查询，验证数据添加成功：
POST chengji/_search
{}
查询结果如图所示，说明数据添加成功。
欢迎大家访问我的博客：随风飘雁的博客