How to return source fields from Elasticsearch

Question

I am using Elasticsearch V7.

I want to fetch only the source fields from Elasticsearch.

Request query:

GET /test/_search?filter_path=hits.hits._source
{
  "query": {
    "term": {
      "test": {
        "value": "123"
      }
    }
  }
}

Response:

{
  "hits" : {
    "hits" : [
      {
        "_source" : {
          "field1" : "value1",
          "field2" : "value2",
          "field3" : "value3",
        }
      }
    ]
  }
}

Expected Result:

{
  "hits" : {
    "hits" : [
      {
          "field1" : "value1",
          "field2" : "value2",
          "field3" : "value3",
      }, 
      {
          "field1" : "value1",
          "field2" : "value2",
          "field3" : "value3",
      }
    ]
  }
}

OR

    "hits" : [
      {
          "field1" : "value1",
          "field2" : "value2",
          "field3" : "value3",
      }, 
      {
          "field1" : "value1",
          "field2" : "value2",
          "field3" : "value3",
      }
    ]

Is there a way to fetch the above expected result from Elasticsearch?

Jozef - Spatialized.io · Accepted Answer · 2021-03-13 20:51:43Z

1

No, it's not possible. filter_path is as good as it gets when it comes to native response filtering.

Having said that, you can use jq -- the command line JSON processor -- to extract the _sources further:

curl -XGET "http://localhost:9200/test/_search?filter_path=hits.hits._source" \
     -H 'Content-Type: application/json' \
     -d'{ 
          "query": {   
              "match_all": {} 
          }
        }' \
    | jq '{hits: [.hits.hits[]._source]}'

answered Mar 13, 2021 at 20:51

Jozef - Spatialized.io

17k4 gold badges29 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to return source fields from Elasticsearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related