CODEWITHSUNDEEP
groovyelasticsearch
datasci
datasci

Reputation: 1029

String Comparison with Elasticsearch Groovy Dynamic Script

I have an elasticsearch index that contains various member documents. Each member document contains a membership object, along with various fields associated with / describing individual membership. For example:

{membership:{'join_date':2015-01-01,'status':'A'}}

Membership status can be 'A' (active) or 'I' (inactive); both Unicode string values. I'm interested in providing a slight boost the score of documents that contain active membership status.

In my groovy script, along with other custom boosters on various numeric fields, I have added the following:

String status = doc['membership.status'].value; 
float status_boost = 0.0;

if (status=='A') {status_boost = 2.0} else {status_boost=0.0}; 

return _score + status_boost

For some reason associated with how strings operate via groovy, the check (status=='A') does not work. I've attempted (status.toString()=='A'), (status.toString()=="A"), (status.equals('A')), plus a number of other variations.

How should I go about troubleshooting this (in a productive, efficient manner)? I don't have a stand-alone installation of groovy, but when I pull the response data in python the status is very much so either a Unicode 'A' or 'I' with no additional spacing or characters.

Upvotes: 1

Views: 2876

Answers (1)

pickypg
pickypg

Reputation: 22332

@VineetMohan is most likely right about the value being 'a' rather than 'A'.

You can check how the values are indexed by spitting them back out as script fields:

$ curl -XGET localhost:9200/test/_search -d '
{
  "script_fields": {
    "status": {
      "script": "doc[\"membership.status\"].values"
    }
  }
}
'

From there, it should be an indication of what you're actually working with. More than likely based on the name and your usage, you will want to reindex (recreate) your data so that membership.status is mapped as a not_analyzed string. If done, then you won't need to worry about lowercasing of anything.

In the mean time, you can probably get by with:

return _score + (doc['membership.status'].value == 'a' ? 2 : 0)

As a big aside, you should not be using dynamic scripting. Use stored scripts in production to avoid security issues.

Upvotes: 3

Related Questions