概述

• 简单搜索语法。

查询所有文档

GET /索引名称/类型/_search

• 举例
  • GET /es_db/_doc/_search
  • 对应SQL:
    • select * from student

条件查询——等于

GET /索引名称/类型/_search?q=字段:值

• 举例:
  • GET /es_db/_doc/_search?q=age:28
  • 对应SQL:
    • select * from student where age = 28

条件查询——范围

GET /索引名称/类型/_search?q=字段[起始 TO 终止]

• 举例:
  • GET /es_db/_doc/_search?q=age[25 TO 26]
• 对应SQL:
  • select * from student where age between 25 and 26

条件查询——批量

GET /索引名称/类型/_mget

• 举例:

  GET /es_db/_doc/_mget 
  {
  "ids":["1","2"]  
  }

• 对应SQL:

  • select * from student where id in (1,2)
    

    条件查询——大于/小于

    GET /索引名称/类型/_search?q=age:<=**
GET /索引名称/类型/_search?q=age:>**

• 举例:

  • GET /es_db/_doc/_search?q=age:<=28

• 对应SQL:

  • select * from student where age <= 28

    条件查询——分页

    GET /索引名称/类型/_search?q=age[25 TO 26]&from=0&size=1

• 举例:

  • GET /es_db/_doc/_search?q=age[25 TO 26]&from=0&size=1
• 对应SQL:
  • select * from student where age between 25 and 26 limit 0, 1

输出字段限制

GET /索引名称/类型/_search?_source=字段,字段

• 举例:
  • GET /es_db/_doc/_search?_source=name,age
• 对应SQL:
  • select name,age from student

排序

GET /索引名称/类型/_search?sort=字段 desc/asc

• 举例:
  • GET /es_db/_doc/_search?sort=age:desc
• 对应SQL:
  • select * from student order by age desc