Kibana学习

#获取所有索引库
GET _cat/indices?v

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

#get specific
GET /user/userinfo/6

#get all
GET /user/userinfo/_search

#Sort AND Page
GET /user/userinfo/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {
      "age": {
        "order": "desc"
      }
    }
  ],
  "from": 0,
  "size": 3
}

#Specific Search
GET /user/userinfo/_search
{
  "query": {
    "match_all": {
      
    }
  }
}

#Create new indic
PUT /user

#Create mapping
PUT /user/userinfo/_mapping
{
  "properties":{
    "name":{
      "type":"text",
      "analyzer": "ik_smart",
      "search_analyzer": "ik_smart", 
      "store": false
    },
    "city":{
      "type":"text",
      "analyzer": "ik_smart",
      "search_analyzer": "ik_smart", 
      "store": false
    },
    "age":{
      "type":"long", 
      "store": false
    },
    "description":{
      "type":"text",
      "analyzer": "ik_smart",
      "search_analyzer": "ik_smart", 
      "store": false
    }
  }
}

#Insert Info
PUT /user/userinfo/1
{
  "name":"zhangsan",
  "city":"Guangdong",
  "age":20,
  "description":"zhangsan is a boy."
}
#Insert Info
PUT /user/userinfo/2
{
  "name":"lisi",
  "city":"Shanghai",
  "age":19,
  "description":"lisi is a shanghai boy."
}
#Insert Info
PUT /user/userinfo/3
{
  "name":"wangwu",
  "city":"Guangdong",
  "age":25,
  "description":"wangwu is a guangdong handsome man."
}
#Insert Info
PUT /user/userinfo/4
{
  "name":"xiaohong",
  "city":"Beijing",
  "age":15,
  "description":"xiaohong is a Beijing girl."
}


#Insert Info
PUT /user/userinfo/5
{
  "name":"kris",
  "city":"American",
  "age":17,
  "description":"kris is a sicuan cool boy.",
  "sex":"boy"
}

#Insert Info 
#Or replace the original info
PUT /user/userinfo/6
{
  "name":"xiaomei",
  "city":"sicuan",
  "age":18,
  "description":"xiaomei is a sicuan hot girl."
}

#update the original info
POST /user/userinfo/6/_update
{
  "doc": {
    "name":"rio",
    "age":23,
    "description":"rio is a sicuan smart woman"
  }
}

#deleted
DELETE /user/userinfo/6

#nested 查询
GET /hotel/_search
{
  "query": {
    "nested" : {
      "path": "rooms",
      "query": {
        "match": {
          "rooms.roomId": 1
        }
      }
    }
  }
}

GET /hotel/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "rooms",
            "query": {
              "match": {
                "rooms.roomBedAdd": -1
              }
            }
          }
        }
      ]
    }
  }
}
GET /hotel/_search
{
  "query": {
    "match_all": {}
  }
}