Select specific fields only with Elasticsearch

Question

I am trying to Get data with specific fields from an Index. I am using olivere elastic client. I tried the following code to select Bedrooms,rooms and location fields from property Index.

    query := elastic.NewBoolQuery()

    query = query.Must(elastic.NewTermQuery("rooms", "1"))
    query = query.Must(elastic.NewTermQuery("bedrooms", "1"))

    get1, err := client.Search("Bedrooms", "rooms", "location").
        Index("property").
        //Type("doc").
        Query(query).
        Sort("id", true).
        Size(5000).
        Do(ctx)
    if err != nil {
        // Handle error
        panic(err)
    }

Sunder R · Accepted Answer · 2018-06-23 05:02:22Z

4

You can achieve this by using the Fields

query := elastic.NewBoolQuery()

query = query.Must(elastic.NewTermQuery("rooms", "1"))
query = query.Must(elastic.NewTermQuery("bedrooms", "1"))

get1, err := client.Search("Bedrooms", "rooms", "location").
    Index("property").
    //Type("doc").
    Query(query).
    Sort("id", true).
    Fields("field1","field2")
    Size(5000).
    Do(ctx)
if err != nil {
    // Handle error
    panic(err)
}

answered Jun 23, 2018 at 5:02

Sunder R

1,1141 gold badge9 silver badges22 bronze badges

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

2 Comments

Norbert Over a year ago

Helpful answer, just a version update: Fields is the 1.x/2.x(?) term. DocValueFields is the term that works in 6.x/7.x

Franck Over a year ago

Jeez i should read the comments ... I was trying to get the Fields working. So i confirm DocValueFields works with v7

rozman · Accepted Answer · 2022-09-15 15:46:07Z

0

I'm using Olivere/elastic v7.0.32 and I couldn't get it to work with DocValueFields.

This worked for me:

query := elastic.NewBoolQuery()
// specify query that you need
query.Must(elastic.NewRangeQuery("expires").Gt(time.Now()))

// provide fields in .Include() function that you wish to return
fsc := elastic.NewFetchSourceContext(true).Include("image", "name")

// create new builder
builder := elastic.NewSearchSource().Query(query).FetchSourceContext(fsc)

searchResults, err := client.
    Search().
    Index("index").
    SearchSource(builder).
    Do(ctx)

answered Sep 15, 2022 at 15:46

rozman

1831 silver badge11 bronze badges

Collectives™ on Stack Overflow

Select specific fields only with Elasticsearch

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related