elasticsearch中常用的简单查询语句

开始创建Document

PUT /ecommerce/product/1
{
        "name" : "gaolujie yagao",
        "desc" :    "gaoxiao meibai",
        "price" :    30,
        "producer" : "gaolujie producer",
        "tags": [ "meibai", "fangzhu" ]
}
PUT /ecommerce/product/2
{
        "name" : "jiajieshi yagao",
        "desc" :    "youxiao fangzhu",
        "price" :    25,
        "producer" :            "jiajieshi producer",
        "tags": [ "fangzhu" ]
}
PUT /ecommerce/product/3
{
        "name" : "zhonghua yagao",
        "desc" :    "caoben zhiwu",
        "price" :    40,
        "producer" :            "zhonghua producer",
        "tags": [ "qingxin" ]
}
PUT /ecommerce/product/4
{
        "name" : "yagao",
        "desc" :    "zhiwu",
        "price" :    56,
        "producer" :"111111 producer",
        "tags": [ "qingxin" ]
}
PUT /ecommerce/product/5
{
        "name" : "霸王",
        "desc" :    "霸王药业",
        "price" :    156,
        "producer" :"霸王 霸王药业",
        "tags": [ "国产" ]
}

#查询

GET /ecommerce/product/5

#覆盖,替换文档（全量替换）

PUT /ecommerce/product/1
{
    "name" : "11111",
    "desc" : " meibai",
    "price" : 44,
    "producer" : "gaolujie producer",
    "tags" : [ "meibai" , "fangzhu" ]
}

#分页查询

GET /ecommerce/product/_search
{
    "query" : { "match_all" : {}},
    "from" : 1,
    "size" : 10
}

![673F03DB47E34D5BAC4C4DF8A8BC7260.png]

#指定查询项

GET /ecommerce/product/_search
{
    "query" : {"match_all" : {}},
    "_source" : ["name", "price"]
}

#过滤查询

#搜索商品名称包含yaogao，而且售价大于25元的商品

GET /ecommerce/product/_search
{
        "query" : {
            "bool" : {
                "must" : {
                    "match" : {
                        "name" : "yagao"
              }
        },
        "filter" : {
            "range" : {
                "price": {"gt" : 50}
                    }
                }
            }
        }
    }

#ull-text search(全文检索)

GET /ecommerce/product/_search
    {
        "query" : {
            "match" : {
                "producer": "producer"
            }
        }
    }

#phrase search(短语搜索)

GET /ecommerce/product/_search
    {
        "query" : {
            "match_phrase" : {
                "producer" : "producer"
            }
        }
}

#多条件查询

#名字中有"yagao"，描述上可以有fangzhu也可以没有，价格不能是25元

GET /ecommerce/_search
{
      "query" : {
          "bool" : {
              "must" : [
                  {
                      "match" : {
                          "name" : "yagao"
                      }
                  }
                  ],
                  "should" : [
                      {
                          "match" : {
                              "desc" : "fangzhu"
                          }
                      },
                      {
                          "match" : {
                              "desc" : "caoben"
                          }
                      }
                      ],
                      "must_not" : [
                          {
                              "match" : {
                                  "price" : 25
                              }
                          }
                      ],
                      "minimum_should_match" : 1
          }
      }
}

#Join全量检索

GET /ecommerce/_search
{
    "query": {
        "match_all": {}
    },
    "sort": ["_id"]
}

#测试

GET /ecommerce/_search
{
    "query": {
        "term": {
            "name": "11111"
        }
    }
}

---------------------------------------------华丽的分割线--------------------------------------------------

PUT /ecommerce/product/1
{
        "name" : "gaolujie yagao",
        "desc" :    "gaoxiao meibai",
        "price" :    30,
        "producer" : "gaolujie producer",
        "tags": [ "meibai", "fangzhu" ]
}
PUT /ecommerce/product/2
{
        "name" : "jiajieshi yagao",
        "desc" :    "youxiao fangzhu",
        "price" :    25,
        "producer" :            "jiajieshi producer",
        "tags": [ "fangzhu" ]
}
PUT /ecommerce/product/3
{
        "name" : "zhonghua yagao",
        "desc" :    "caoben zhiwu",
        "price" :    40,
        "producer" :            "zhonghua producer",
        "tags": [ "qingxin" ]
}
PUT /ecommerce/product/4
{
        "name" : "yagao",
        "desc" :    "zhiwu",
        "price" :    56,
        "producer" :"111111 producer",
        "tags": [ "qingxin" ]
}
PUT /ecommerce/product/5
{
        "name" : "霸王",
        "desc" :    "霸王药业",
        "price" :    156,
        "producer" :"霸王 霸王药业",
        "tags": [ "国产" ]
}

#覆盖,替换文档（全量替换）
PUT /ecommerce/product/1
{
    "name" : "11111",
    "desc" : " meibai",
    "price" : 44,
    "producer" : "gaolujie producer",
    "tags" : [ "meibai" , "fangzhu" ]
}

#查询
GET /ecommerce/product/1

#分页查询
GET /ecommerce/product/_search
{
    "query" : { "match_all" : {}},
    "from" : 0,
    "size" : 10
}

#指定查询项
GET /ecommerce/product/_search
{
    "query" : {"match_all" : {}},
    "_source" : ["name", "price"]
}

#过滤查询
#搜索商品名称包含yaogao，而且售价大于50元的商品
GET /ecommerce/product/_search
{
        "query" : {
            "bool" : {
                "must" : {
                    "match" : {
                        "name" : "yagao"
              }
        },
        "filter" : {
            "range" : {
                "price": {"gt" : 50}
                    }
                }
            }
        }
    }
    
#ull-text search(全文检索)
GET /ecommerce/product/_search
    {
        "query" : {
            "match" : {
                "producer": "producer"
            }
        }
    }
    
#phrase search(短语搜索)
GET /ecommerce/product/_search
    {
        "query" : {
            "match_phrase" : {
                "producer" : "producer"
            }
        }
}
#多条件查询
#名字中有"yagao"，描述上可以有fangzhu也可以没有，价格不能是25元

GET /ecommerce/_search
{
      "query" : {
          "bool" : {
              "must" : [
                  {
                      "match" : {
                          "name" : "yagao"
                      }
                  }
                  ],
                  "should" : [
                      {
                          "match" : {
                              "desc" : "fangzhu"
                          }
                      },
                      {
                          "match" : {
                              "desc" : "caoben"
                          }
                      }
                      ],
                      "must_not" : [
                          {
                              "match" : {
                                  "price" : 25
                              }
                          }
                      ],
                      "minimum_should_match" : 1
          }
      }
}
#Join全量检索
GET /ecommerce/_search
{
    "query": {
        "match_all": {}
    },
    "sort": ["_id"]
}

#测试
GET /ecommerce/_search
{
    "query": {
        "term": {
            "name": "11111"
        }
    }
}

目录CONTENT