es查询
1 .寻呼查询GET test*/_search{ 'size': 10、' from': 0、 ' query ' : { ' term ' : { ' member _ age ' :62 } }2.按id标识数据post { index }/_ update/{ id } { ' doc ' 3: } _update_by_query例句:查询member_gender将男性数据发送给女性POST {index}/_ update _ by _ query { ' script ' : { ' inline ' : ' CTX._ source.member _ gender=params.member _ gender _ gender pretty{#查询条件' query ' : { ' term ' : { ' member _ age ' :3 }, #按字段排序' sort ' : { ' member _ age ' :3 } #显示计数#聚合函数的聚合方法' aggs ' : { ' maxage ' : } ' max ' : { } 此字段只能重新计数: size=0{ ' aggs ' : { ' age _ count ' : } ' value _ count ' : { ' field ' 3360 ' ooo ' name _ count ' : { ' cardinality ' : { ' field ' : ' ordernum ' }倒计数通过添加. keyword后缀来解决错误报告
POST wipro-headpic/_search? size=1{ ' aggs ' : { ' age _ count ' : } ' value _ count ' : { ' field ' : ' ordernum ' }, ' ordernum _ count ' : { ' cardinality ' : ' field ' : ' ordernum.keyword ' }检查内存占用情况get/_ cat/segmet/segmed } vh=name,port,sm根据id查询文档post wipro-head pic/_ doc/dbmy km4bz _ xbjxpx 0ve 4
{
" member _ gender " : " ee "
“type”:“wipro-head pic”
“customer _ shop _ id”:“uuuuuuuu”,
member _ age :68
}
#根据条件更新文档
post wipro-head pic/_ update _ by _ query
{
“脚本”:{
" inline " : " CTX._ source.member _ gender=params.member _ gender ",
" params " : {
“member _ gender”:“女人”
}
(,
“query”: {
“term”: {
“member _ gender”:“男人”
}
}
}
#聚合查询的最大最小值
POST wipro-headpic/_search? pretty
{
" size " :1,
" aggs " : {
" maxage " : {
“max”: {
字段:「member_age
}
}
}
}
#聚合查询的最大最小加条件
邮政信箱
wipro-headpic/_search?pretty{
“query”:{
“term”:{
“member_age”:3
}
},
“sort”: [
{
“member_age”: {
“order”: “asc”
}
}
],
“size”: 2,
“aggs”: {
“maxage”: {
“max”: {
“field”: “member_age”
}
}
}
}
PUT wipro-headpic/_mapping
{
“properties”: {
“interests”: {
“type”: “text”,
“fielddata”: true
}
}
}
POST wipro-headpic/_search?size=1
{
}
GET /wipro-headpic/_doc/_search?q=member_age:44
{
“size”:1000
}
GET /wipro-headpic/_doc/_search?_source=member_age
{
“size”:1000
}
GET /wipro-headpic/_doc/_search
{
“size” :0,
“aggs” : {
“popular_age” : {
“terms” : {
“field” : “member_gender.keyword”,
“size”: 3
}
}
}
}
GET /wipro-headpic/_doc/_search
{
“size” :0,
“aggs” : {
“popular_age” : {
“terms” : {
“shard_size”:10,
“field” : “member_age”,
“size”: 3
}
使用 terms aggs 查询top(默认10) 全局搜索GET /wipro-headpic/_doc/_search
{
“size” :0,
“aggs” : {
“popular_age” : {
“terms” : {
“size”:3,
“field” : “member_age”
}
}
}
}
GET /wipro-headpic/_doc/_search?size=0
{
“aggs” : {
“一级actors” : {
“terms” : {
“field” : “member_age”,
“size” : 3,
“shard_size” : 10,
“collect_mode” : “breadth_first”
},
“aggs” : {
“二级costars” : {
“terms” : {
“field” : “member_id.keyword”,
“size” : 5
}
}
}
}
}
}
GET /_cat/segments/wipro-headpic?v&h=shard,segments,size,size.memory
所有segment占用的memory总和:GET /_cat/nodes?v&h=name,port,sm
查看内存占用情况GET /_cat/segments/wipro-headpic?v&h=shard,name,port,segments,size,size.memory
GET /_stats/fielddata?fields=*
先查询再去重计数POST wipro-headpic/_search?size=1
{
}
排序查询GET /_search
{
“sort”:
{
“member_age”: “desc”
}
,
“from”:0,
“size”:4,
“query” : {
“bool” : {
“must” : {
“term”:{
“member_id” : “7992254”
}
},
“filter” : {
“range”: { “member_age”:{“gt”: 4995}}
}
}
}