原英文版地址: https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-translate.html, 原文档版权归 www.elastic.co 所有
本地英文版地址: ../en/sql-translate.html
重要: 此版本不会发布额外的bug修复或文档更新。最新信息请参考 当前版本文档。
Elasticsearch Guide [7.7] » SQL access » SQL Translate API
« Supported REST parameters SQL CLI »

SQL Translate APIedit

The SQL Translate API accepts SQL in a JSON document and translates it into native Elasticsearch queries. For example:

POST /_sql/translate
{
    "query": "SELECT * FROM library ORDER BY page_count DESC",
    "fetch_size": 10
}

Which returns:

{
    "size" : 10,
    "docvalue_fields" : [
        {
            "field": "release_date",
            "format": "epoch_millis"
        }
    ],
    "_source": {
        "includes": [
            "author",
            "name",
            "page_count"
        ],
        "excludes": []
    },
    "sort" : [
        {
            "page_count" : {
                "order" : "desc",
                "missing" : "_first",
                "unmapped_type" : "short"
            }
        }
    ]
}

Which is the request that SQL will run to provide the results. In this case, SQL will use the scroll API. If the result contained an aggregation then SQL would use the normal search API.

The request body accepts all of the fields that the SQL REST API accepts except cursor.

« Supported REST parameters SQL CLI »