栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 前沿技术 > 大数据 > 大数据系统

ES基础操作用到的代码

ES基础操作用到的代码

PUT /shopping


GET /_cat/indices?v

GET /shopping

DELETe /shopping

PUT /shopping/_doc
{
 "title":"小米手机",
 "category":"小米",
 "images":"http://www.gulixueyuan.com/xm.jpg",
 "price":3999.00
}

POST /shopping/_doc/1
{
 "title":"华为手机",
 "category":"华为",
 "images":"http://www.gulixueyuan.com/xm.jpg",
 "price":3999.00
}

GET /shopping/_doc/1

POST /shopping/_doc/1
{
 "title":"苹果手机",
 "category":"苹果",
 "images":"http://www.gulixueyuan.com/xm.jpg",
 "price":3999.00
}


POST /shopping/_update/1
{ 
 "doc": {"price":3000.00} 
}


GET /shopping/_update/1

DELETE /shopping/_doc/1


GET /shopping/_doc/1

POST /shopping/_doc/1
{
 "title":"小米手机",
 "category":"小米",
 "images":"http://www.gulixueyuan.com/xm.jpg",
 "price":4000.00
}

POST /shopping/_doc/2
{
 "title":"华为手机",
 "category":"华为",
 "images":"http://www.gulixueyuan.com/hw.jpg",
 "price":4000.00
}


POST /shopping/_delete_by_query
{
 "query":{
    "match":{
        "price":4000.00
    }
 } 
}

PUT /student

PUT /student/_mapping
{
  "properties": {
    "name":{
      "type": "text",
      "index": true
    },
    "sex":{
      "type": "text",
      "index": false
    },
    "age":{
      "type": "long",
      "index": false
    }
 }
}


GET student/_mapping


PUT /student2
{
 "settings": {},
 "mappings": {
 "properties": {
"name":{
 "type": "text",
 "index": true
 
},
"sex":{
 "type": "text",
 "index": false
},
"age":{
 "type": "long",
 "index": false
}
 }
 } 
  
}


POST /student/_doc/1001
{
"name":"zhangsan",
"nickname":"zhangsan",
 "sex":"男",
 "age":30
}

POST /student/_doc/1002
{
"name":"lisi",
"nickname":"lisi",
 "sex":"男",
 "age":20 
  
}

POST /student/_doc/1003
{
"name":"wangwu",
 "nickname":"wangwu",
 "sex":"女",
 "age":40 
  
}

 POST /student/_doc/1004
{
"name":"zhangsan1",
"nickname":"zhangsan1",
 "sex":"女",
 "age":50 
  
}

 POST /student/_doc/1005
{
"name":"zhangsan2",
"nickname":"zhangsan2",
 "sex":"女",
 "age":30 
  
}

GET /student/_search
{
 "query": {
    "match_all": {}
  } 
}


GET /student/_search
{
  "query": {
    "match": {
    "name":"zhangsan"
    }
  } 
}

GET /student/_search
{
  "query": {
    "multi_match": {
      "query": "zhangsan",
      "fields": ["name","nickname"]
    }
  } 
}

GET /student/_search
{
  "query": {
    "term": {
      "name": {
      "value": "zhangsan"
      }
    }
 } 
}

GET /student/_search 
{
  "query": {
    "terms": {
      "name": ["zhangsan","lisi"]
  }
 } 
}


GET /student/_search 
{
 "_source": ["name","nickname"], 
  "query": {
    "terms": {
      "nickname": ["zhangsan"]
    }
  } 
}

GET /student/_search 
{
 "_source": {
    "includes": ["name","nickname"]
 }, 
 "query": {
    "terms": {
      "nickname": ["zhangsan"]
    }
 } 
}

GET /student/_search 
{
 "_source": {
    "excludes": ["name","nickname"]
 }, 
 "query": {
    "terms": {
      "nickname": ["zhangsan"]
    }
 } 
}


GET /student/_search 
{
 "query": {
    "bool": {
      "must": [{
        "match": {
          "name": "zhangsan"
        }
      }],
      "must_not": [{
        "match": {
          "age": "40"
        }
      }],
      "should": [{
        "match": {
        "sex": "男"
        }
      }]
    }
 } 
}

GET /student/_search 
{
 "query": {
    "range": {
      "age": {
        "gte": 30,
        "lte": 35
      }
  }
 } 
}

GET /student/_search 
{
 "query": {
    "fuzzy": {
      "title": {
        "value": "zhangsan"
       }
    }
 } 
}


GET /student/_search 
{
 "query": {
    "fuzzy": {
      "title": {
        "value": "zhangsan",
        "fuzziness": 2
      }
    }
 } 
}


GET /student/_search 
{
 "query": {
    "match": {
      "name":"zhangsan"
    }
 },
 "sort": [{
    "age": {
      "order":"desc"
    }
 }]
}

GET /student/_search 
{
  "query": {
      "match_all": {}
  },
  "sort": [{
    "age": {
      "order": "desc"
    }
  },{
    "_score":{
        "order": "desc"
      }
    }
 ] 
}
 
 
GET /student/_search 
{
 "query": {
    "match": {
      "name": "zhangsan"
    }
 },
 "highlight": {
    "pre_tags": "",
    "post_tags": "",
    "fields": {
      "name": {}
    }
 } 
}


GET /student/_search 
{
 "query": {
    "match_all": {}
  },
 "sort": [{
    "age": {
      "order": "desc"
    }
 }],
 "from": 0,
 "size": 2
}

GET /student/_search 
{
 "aggs":{
    "max_age":{
      "max":{"field":"age"}
    }
 },
 "size":0
}

GET /student/_search 
{
 "aggs":{
    "min_age":{
      "min":{"field":"age"}
    }
 },
 "size":0
}

GET /student/_search 
{
 "aggs":{
    "sum_age":{
      "sum":{"field":"age"}
    }
 },
 "size":0
}


GET /student/_search 
{
  "aggs":{
    "avg_age":{
      "avg":{"field":"age"}
    }
  },
 "size":0
}


GET /student/_search 
{
 "aggs":{
    "distinct_age":{
      "cardinality":{"field":"age"}
    }
 },
 "size":0
}


GET /student/_search 
{
 "aggs":{
    "stats_age":{
      "stats":{"field":"age"}
    }
 },
 "size":0
}

GET /student/_search 
{
 "aggs":{
    "age_groupby":{
      "terms":{"field":"age"}
    }
 },
 "size":0
}


GET /student/_search 
{
 "aggs":{
    "age_groupby":{
      "terms":{"field":"age"}
    }
 },
 "size":0
}


转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/629060.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号