elasticsearch-sql查询

最新推荐文章于 2024-03-14 16:55:26 发布

重生之我是一名程序员

最新推荐文章于 2024-03-14 16:55:26 发布

阅读量225

点赞数

分类专栏： elasticsearch 文章标签： elasticsearch

原文链接：https://editor.csdn.net/md/?not_checkout=1

版权

elasticsearch 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

elasticsearch-sql查询

elasticsearch除了 DSL查询，还有类似sql查询

数据

POST /user/_doc/1
{
  "age":1,
  "email":"hello@qq.com",
  "name":"tom",
  "address":"上海闵行"
}

POST /user/_doc/2
{
  "age":4,
  "email":"hello@qq.com",
  "name":"jack",
  "address":"上海闵行"
}

POST /user/_doc/3
{
  "age":40,
  "email":"hello@qq.com",
  "name":"jackMa",
  "address":"上海闵行"
}

查询所有

POST /_sql?format=txt
{
  "query": "SELECT * from user"
}

//结果
    address    |      age      |     email     |     name      
---------------+---------------+---------------+---------------
上海闵行           |1              |hello@qq.com   |tom            
上海闵行           |4              |hello@qq.com   |jack           
上海闵行           |40             |hello@qq.com   |jackMa

分组查询

POST /_sql?format=txt
{
  "query": "SELECT count(*),address from user group by address"
}

//结果
      cnt      |    address    
---------------+---------------
3              |上海闵行