elasticsearch 入门小教程

//索引创建
//127.0.0.1:9200/student/
{
	"settings":{
		"number_of_shards": 3,
		"number_of_replicas": 1
	},
	"mappings":{
		 "student": {
			    "properties": {
			      "studentNo": {
			        "type": "long",
			        "index": "true"
			      },
			      "name": {
			        "type": "text",
			        "index": "true"
			      },
			      "male": {
			        "type": "text",
			        "index": "true"
			      },
			      "age": {
			        "type": "integer",
			        "index":"true"
			      },
			      "birthday": {
			        "type": "date",
			        "index":"true",
			        "format": "yyyy-MM-dd"
			      },
			      "address": {
			        "type": "text",
			        "index":"true"
			      },
			      "classNo": {
			        "type": "text",
			        "index": "true"
			      },
			      "isLeader": {
			        "type": "boolean",
			        "index":"true"
			      }
			 }
		}
 
	}
}

基础数据

---

{       
        "studentNo": "1",
        "name": "刘备",
        "male": "男",
        "age": "24",
        "birthday": "1985-02-03",
        "classNo": "1",
        "address":"湖南省长沙市",
        "isLeader": "true"
 
}

{       
        "studentNo": "2",
        "name": "关羽",
        "male": "男",
        "age": "22",
        "birthday": "1987-08-23",
        "classNo": "2",
        "address":"四川省成都市",
        "isLeader": "false"
 
}

{       
        "studentNo": "3",
        "name": "糜夫人",
        "male": "女",
        "age": "19",
        "birthday": "1990-06-12",
        "classNo": "1",
        "address":"上海市",
        "isLeader": "false"
 
}

{       
        "studentNo": "4",
        "name": "张飞",
        "male": "男",
        "age": "20",
        "birthday": "1989-07-30",
        "classNo": "3",
        "address":"北京市",
        "isLeader": "false"
 
}

{       
        "studentNo": "5",
        "name": "诸葛亮",
        "male": "男",
        "age": "18",
        "birthday": "1992-04-27",
        "classNo": "2",
        "address":"江苏省南京市",
        "isLeader": "true"
 
}

{       
        "studentNo": "6",
        "name": "孙尚香",
        "male": "女",
        "age": "16",
        "birthday": "1994-05-21",
        "classNo": "3",
        "isLeader": "false"
 
}

{       
        "studentNo": "7",
        "name": "马超",
        "male": "男",
        "age": "19",
        "birthday": "1991-10-20",
        "classNo": "1",
	"address":"黑龙江省哈尔滨市",
        "isLeader": "false"
}

{       
        "studentNo": "8",
        "name": "赵云",
        "male": "男",
        "age": "23",
        "birthday": "1986-10-26",
        "classNo": "2",
	"address":"浙江省杭州市",
        "isLeader": "false"
}

创建索引：127.0.0.1:9200/student/

插入数据：127.0.0.1:9200/student/student

 

//匹配聚合查询
{
	"size":"0",
	"query":{
		"match":{
			"age":16
		}
		
	},
	
	"aggs":{
		
		"age_stats":{
			"avg":{
				"field":"age"
			}
		}
	}
	
}

 

//查询一段时间内   文档的聚合统计
{
	"size":0,
	"query":{
		"bool":{
			"must":{
				"range":{
					"utcTime":{
						"gte":"2018-10-01T16:00:00.000Z",
						"lte":"2018-10-07T16:00:00.000Z"
					}
				}
			}
		}
	},
	"aggs":{
		
		"groupDate":{
			"date_histogram":{
				"field":"utcTime",
				"interval":"day",
				"format":"yyyy-MM-dd HH:mm:ss"
			},
			"aggs":{
				"sum_cars":{
					"sum":{
						"field":"thirdLaneTwoKindAvg"
					}
				}
			}
		}
	}
}