ES基本语法

1 Query语句

1.1 Term : 单一精确查询 =

GET pps_test_pre/product/_search
{
  "query": {
    "term": {
      "productId": {
        "value": "711"
      }
    }
  }
}

1.2 Terms : 复合查询

• 1 多条件精确查询 IN()
• 2 排序 ORDER BY
• 3 分页 LIMIT

GET pps_test_pre/product/_search
{
  "query": {
    "terms": {
      "productId": [
        "711",
        "710",
        "709",
        "708"
      ]
    }
  },
  "size": 10,
  "from": 0,
  "sort": [
    {
      "productId": {
        "order": "desc"
      }
    }
  ]
}

1.3 Ids : Id查询

GET pps_test_pre/product/_search
{
  "query": {
    "ids": {
      "values": [707,708,709,710]
    }
  }
}

1.4 Bool

• 1 must : 必须都要满足 AND
• 2 should : 满足一个即可 OR
• 3 must_not : 必须不满足 NOT IN

GET pps_test_pre/product/_search
{
	"query": {
		"bool": {
			"must": [{
					"terms": {
						"productId": [
							"707",
							"708",
							"709"
						]
					}
				}
			],
			"must_not": [
			  {
			    "term": {
			      "dataStatus": {
			        "value": "000"
			      }
			    }
			  }
			]
		}
	}
}

1.5 nested

GET product_attribute/product_attribute/_search
"query": { 
		"nested": {  # 嵌套查询
			"path": "attribute", # 外层路径
			"query": {
				"term": {
					"attribute.vid": {    # 内层查询路径
						"value": #[ ]
					}
				}
			}
		}
	}

1.6 cardinality sum_bucket

• 1 cardinality : 统计
• 2 sum_bucket: 桶总数

GET product_attribute/product_attribute/_search
{
	"query": { 
		"nested": {  # 嵌套查询
			"path": "attribute",
			"query": {
				"term": {
					"attribute.vid": {
						"value": #[ ]
					}
				}
			}
		}
	},
	"aggs": { 
		"productId": {
			"terms": {  # 根据productId分组
				"field": "productId"
			},
			"aggs": {
            "bucketNum": {
               "cardinality": {  # 计数
                  "field": "productId"
               }
            }
         }
		},
		"attrValueNum": {
         "sum_bucket": { # 桶的总数
            "buckets_path": "productId>bucketNum.value" # 桶的路径
         }
      }
	},
	"size": 0
}