ES SQL

ES SQL

使用一下数据创建一个索引

PUT /library/book/_bulk?refresh
{"index":{"_id": "Leviathan Wakes"}}
{"name": "Leviathan Wakes", "author": "James S.A Corey", "release_date": "2001-06-02", "page_count": 561}
{"index":{"_id": "Hyperion"}}
{"name": "Hyperion", "author": "Dan simmons", "release_date": "1986-05-26", "page_count": 482}
{"index":{"_id": "Dune"}}
{"name": "Dune", "author": "Frank Herbert", "release_date": "1965-06-01", "page_count": 604}

查询发行日期小于2000-01-01

POST /_sql?format=txt
{
  "query": """
  SELECT * FROM library
  where release_date < '2000-01-01'
  """
}

输出结果