ES7 sql新特性

快速入门

POST /_sql?format=txt
{
    "query": "SELECT * FROM tvs "
}

启动方式

1http 请求

2客户端：elasticsearch-sql-cli.bat

3代码

显示方式

sql 翻译

POST /_sql/translate
{
    "query": "SELECT * FROM tvs "
}

返回：

{
  "size" : 1000,
  "_source" : false,
  "stored_fields" : "_none_",
  "docvalue_fields" : [
    {
      "field" : "brand"
    },
    {
      "field" : "color"
    },
    {
      "field" : "price"
    },
    {
      "field" : "sold_date",
      "format" : "epoch_millis"
    }
  ],
  "sort" : [
    {
      "_doc" : {
        "order" : "asc"
      }
    }
  ]
}

与其他DSL结合

POST /_sql?format=txt
{
    "query": "SELECT * FROM tvs",
    "filter": {
        "range": {
            "price": {
                "gte" : 1200,
                "lte" : 2000
            }
        }
    }
}