Get specific fields from index in elasticsearch

Question

I have an index in elastic-search.

Sample structure :

{
    "Article": "Article7645674712",
    "Genre": "Genre92231455",
    "relationDesc": [
        "Article",
        "Genre"
    ],
    "org": "user",
    "dateCreated": {
        "date": "08/05/2015",
        "time": "16:22 IST"
    },
    "dateModified": "08/05/2015"
}

From this index i want to retrieve selected fields: org and dateModified.

I want result like this

{
    "took": 265,
    "timed_out": false,
    "_shards": {
        "total": 5,
        "successful": 5,
        "failed": 0
    },
    "hits": {
        "total": 28,
        "max_score": 1,
        "hits": [
            {
                "_index": "couchrecords",
                "_type": "couchbaseDocument",
                "_id": "3",
                "_score": 1,
                "_source": {
                    "doc": {
                        "org": "user",
                        "dateModified": "08/05/2015"
                    }
                }
            },
            {
                "_index": "couchrecords",
                "_type": "couchbaseDocument",
                "_id": "4",
                "_score": 1,
                "_source": {
                    "doc": {
                        "org": "user",
                        "dateModified": "10/05/2015"
                    }
                }
            }
        ]
    }
}

How to query elastic-search to get only selected specific fields ?

Val · Accepted Answer · 2015-06-01 12:30:34Z

9

You can retrieve only a specific set of fields in the result hits using the _source parameter like this:

curl -XGET localhost:9200/couchrecords/couchbaseDocument/_search?_source=org,dateModified

Or in this format:

curl -XPOST localhost:9200/couchrecords/couchbaseDocument/_search -d '{
    "_source": ["doc.org", "doc.dateModified"],  <---- you just need to add this
    "query": {
        "match_all":{}   <----- or whatever query you have
    }
}'

edited Jun 1, 2015 at 12:30

answered Jun 1, 2015 at 11:37

Val

218k14 gold badges377 silver badges384 bronze badges

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

9 Comments

RamRajVasavi Over a year ago

I write query like {"query":{ "_source":["org"] }} but it is giving error

RamRajVasavi Over a year ago

It is giving output like { "_index": "couchrecords", "_type": "couchbaseDocument", "_id": "3", "_score": 1, "_source": { } }

Val Over a year ago

Something's wrong with how your documents were indexed. What do you see when running this: curl -XGET localhost:9200/couchrecords/couchbaseDocument/3? Also can you update your question with the couchbaseDocument mapping you're using, i.e. do you have "_source" : {"enabled" : false} somewhere in them?

RamRajVasavi Over a year ago

no I am not using "_source" : {"enabled" : false} my mapping is normal

Val Over a year ago

What does this return curl -XGET localhost:9200/couchrecords/couchbaseDocument/3 ?

|

eliasah · Accepted Answer · 2015-06-01 12:01:36Z

1

That's easy. Considering any query of this format :

{
  "query": {
  ...
  },
}

You'll just need to add the fields field into your query which in your case will result in the following :

{
  "query": {
  ...
  },
  "fields" : ["org","dateModified"]
}

answered Jun 1, 2015 at 12:01

eliasah

40.5k12 gold badges128 silver badges159 bronze badges

2 Comments

RamRajVasavi Over a year ago

I write {"query":{ "match_all":{}}, "fields" : ["org","dateModified"]} and i get result as { "took": 32,"timed_out": false,"_shards": { "total": 5,"successful": 5, "failed": 0},"hits": {"total": 28, "max_score": 1, "hits": [ { "_index": "couchrecords", "_type": "couchbaseDocument", "_id": "3", "_score": 1 } , { "_index": "couchrecords", "_type": "couchbaseDocument", "_id": "8", "_score": 1 }

eliasah Over a year ago

update with your question with your query. something might be wrong with it!

Radu Linu · Accepted Answer · 2020-04-08 11:19:00Z

0

{
  "_source" : ["org","dateModified"],
  "query": {
  ...
  }
}

Check ElasticSearch source filtering.

answered Apr 8, 2020 at 11:19

Radu Linu

1,27117 silver badges34 bronze badges

Collectives™ on Stack Overflow

Get specific fields from index in elasticsearch

3 Answers 3

9 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related