ES 查询_es信息查询

• 查看基本信息(指定索引)
  http://{{es-host}}:9200/_cat/indices?format=json&index=gy_order

• 查看基本信息
  http://{{es-host}}:9200/_cat/indices?v

• 查看文档, 通过主键
  http://{{es-host}}:9200/gy_order/_doc/16086160590000300010235935

• 基本搜索 term

http://{{es-host}}:9200/gy_order/_search
{ 
  "query": {
    "term": {
      "o_u_id": {
        "value": 22123997
      }
    }
  }
}
1
2
3
4
5
6
7
8
9
10

• multi_match

{
  "size": 5, 
  "query": {
    "multi_match": {
      "query": " 1473068162199116261",
      "fields": ["o_goodsname", "o_ordersn", "o_remark"]
    }
  }
}
1
2
3
4
5
6
7
8
9

• match_phrase

{
  "query": {
    "match_phrase": {
      "o_goodsname": "食品"
    }
  }
}
1
2
3
4
5
6
7

• 复合查询

{
  "query": {
    "bool": {
      "should": [
        {
          "match": {
            "o_goodsname": "007259753302633"
          }
        },
        {
          "match": {
            "o_ordersn": "007259753302633"
          }
        }
      ]
    }
  },
  "from": 0,
  "size": 10,
  "sort": [],
  "aggs": {}
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

• 搜索o_id

{ 
  "query": {
    "term": {
      "o_id": {
        "value": 9370104
      }
    }
  }
}
1
2
3
4
5
6
7
8
9

• 搜索o_u_id

{
  "size" : 20,
  "query": {
    "term": {
      "o_u_id": {
        "value": 22123997
      }
    }
  }
}
1
2
3
4
5
6
7
8
9
10

• 搜索o_ordersn

{ 
  "query": {
    "term": {
      "o_ordersn": {
        "value": "408438704802070"
      }
    }
  }
}
1
2
3
4
5
6
7
8
9

• o_ordersn multi_match

        {
          "multi_match": {
            "query": "1473068162199116261",
            "fields": [
              "o_goodsname",
              "o_ordersn",
              "o_remark"
            ]
          }
        }
1
2
3
4
5
6
7
8
9
10

• 团队搜索

{
  "from": 0,
  "size": 10,
  "query": {
    "bool": {
      "should": [
        {
          "term": {
            "o_y_id": {
              "value": 22123997,
              "boost": 1
            }
          }
        },
        {
          "term": {
            "o_u_s_id": {
              "value": 22123997,
              "boost": 1
            }
          }
        },
        {
          "term": {
            "o_u_t_id": {
              "value": 22123997,
              "boost": 1
            }
          }
        }
      ],
      "adjust_pure_negative": true,
      "boost": 1
    }
  },
  "sort": [
    {
      "o_creattime": {
        "order": "desc"
      }
    }
  ]
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

• 我的本月收益 (o_u_id=?, 月份=12, o_state!=4), aggs(o_u_m)

{
  "size": 100,
  "_source": ["o_ordersn","o_u_m"], 
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "o_u_id": {
              "value": "23066916"
            }
          }
        },
        {
          "term": {
            "_dbTable": {
              "value": "db_gylm.tb_tb_order_2020_12"
            }
          }
        }
      ],
      "must_not": [
        {
          "term": {
            "o_state": {
              "value": 4
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "result": {
      "sum": {
        "field": "o_u_m"
      }
    }
  }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

• 团队的本月收益(o_y_id=?, 月份=12, o_state!=4) aggs(o_y_m)

{
  "size": 100,
  "_source": ["o_ordersn","o_u_m","o_y_m","o_u_s_m","o_u_t_m"], 
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "o_y_id": {
              "value": "22123997"
            }
          }
        },
        {
          "term": {
            "_dbTable": {
              "value": "db_gylm.tb_tb_order_2020_12"
            }
          }
        }
      ],
      "must_not": [
        {
          "term": {
            "o_state": {
              "value": 4
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "result": {
      "sum": {
        "field": "o_y_m"
      }
    }
  }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

• count 我的订单数

{ 
  "query": {
    "term": {
      "o_u_id": {
        "value": 23066916
      }
    }
  }
}
1
2
3
4
5
6
7
8
9

• count 团队订单数

{
  "query": {
    "bool": {
      "should": [
        {
          "term": {
            "o_y_id": {
              "value": 22123997
            }
          }
        },
        {
          "term": {
            "o_u_s_id": {
              "value": 22123997
            }
          }
        },
        {
          "term": {
            "o_u_t_id": {
              "value": 22123997
            }
          }
        }
      ]
    }
  }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

• count 分公司订单数

{
  "query": {
    "bool": {
      "should": [
        {
          "term": {
            "o_b_id": {
              "value": 14
            }
          }
        }
      ]
    }
  }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

• 标题

• 标题