No more _source if script_fields is used in elasticsearch query

Question

I am running a simple query like so:

{
  "query": {
    "term": {
      "statuses": "active"
    }
  },
  "script_fields": {
    "test": {
      "script": "_source.name"
    }
  }
}

The problem is that once I introduce the script_fields, I no longer get _source in my results.

I have tried:

{
  "fields": [
    "_all"
  ],
  "query": {
    "term": {
      "statuses": "active"
    }
  },
  "script_fields": {
    "email": {
      "script": "_source.name"
    }
  }
}

and

{
  "fields": [
    "*"
  ],
  "query": {
    "term": {
      "statuses": "active"
    }
  },
  "script_fields": {
    "email": {
      "script": "_source.name"
    }
  }
}

But they did not make any difference. Is there a way to get _source returned in addition to the script_fields?

Arun Kumar Nagarajan · Accepted Answer · 2018-04-17 16:52:08Z

33

In the fields array, make it load _source:

{
  "stored_fields": [
    "_source"
  ],
  "query": {
    "term": {
      "statuses": "active"
    }
  },
  "script_fields": {
    "email": {
      "script": "_source.name"
    }
  }
}

edited Apr 17, 2018 at 16:52

Arun Kumar Nagarajan

2,4573 gold badges19 silver badges28 bronze badges

answered Aug 8, 2012 at 0:54

F21

33.6k27 gold badges105 silver badges179 bronze badges

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

1 Comment

Henry C Over a year ago

Does anyone know exactly why this happens? Is it related to github.com/elastic/elasticsearch/issues/20068 ?

karmi · Accepted Answer · 2014-01-27 09:16:40Z

1

This works for me:

curl -X DELETE localhost:9200/a

curl -X POST localhost:9200/a/b/c -d '{"title" : "foo"}'

curl -X POST localhost:9200/a/_refresh

echo;

curl localhost:9200/a/_search?pretty -d '{
  "fields": [
    "_source"
  ],
  "query": {
    "match_all": {}
  },
  "script_fields": {
    "title_script": {
      "script": "_source.title"
    }
  }
}'

Output:

"hits" : {
  # ...
  "hits" : [ {
    # ...
    "_source" : {"title" : "foo"},
    "fields" : {
      "title_script" : "foo"
    }
  } ]
}

answered Jan 27, 2014 at 9:16

karmi

14.5k3 gold badges36 silver badges42 bronze badges

Collectives™ on Stack Overflow

No more _source if script_fields is used in elasticsearch query

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related