Elasticsearch 커스텀 쿼리

script

GET index/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "script": {
            "script": {
              "source": "doc['field'].length == 0"
            }
          }
        }
      ]
    }
  }
}

SQL

POST /_sql?format=json
{
  "query": """
  SELECT * FROM "index"
  """,
  "fetch_size": 10,
  "columnar":true
}