sql - 如何使用 SQL 查询 AWS ElasticSearch

Question

此处的 AWS 文档表明支持 SQL 查询:https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-elasticsearch-service-sql-support/

此页面显示语法: https://docs.aws.amazon.com/elasticsearch-service/latest/developerguide/sql-support.html

POST elasticsearch_domain/_opendistro/_sql
{
  "query": "SELECT * FROM my-index LIMIT 50"
}

在 Kibana 开发工具中运行以下命令

POST my_domain/_opendistro/_sql
{
  "query": "SELECT * FROM my-index LIMIT 50"
}

给出错误

{
  "error": {
    "root_cause": [
      {
        "type": "invalid_type_name_exception",
        "reason": "Document mapping type name can't start with '_', found: [_opendistro]"
      }
    ],
    "type": "invalid_type_name_exception",
    "reason": "Document mapping type name can't start with '_', found: [_opendistro]"
  },
  "status": 400
}

我的 ElasticSearch 版本是 6.7。

Answer 1

由于你的 elasticsearch 是由 AWS 驱动的，并且你使用的是 Kibana Dev 工具，你可以通过以下方式获取查询结果

POST _opendistro/_sql
{
  "query": "SELECT * FROM your_index "
}

您不需要输入域名。它对我有用。