Why the below query in elasticsearch does not work?

Question

I have test data shown below.

{
   "SequenceLocation":{
   "Assembly":"GPR7",
   "Chr": "10",
   "start": 1111
    }
}

Whenever I fired query like below it returns me proper values.

{
  "query" : {
    "bool" : {
      "must" : [
      { 
        "term" : {
          "SequenceLocation.Chr": "10"
        }
      }
      ]
    }
  }
  }

But when I changes query to

{
  "query" : {
    "bool" : {
      "must" : [
      { 
        "term" : {
          "SequenceLocation.Assembly": "GPR7"
        }
      }
      ]
    }
  }
  }

It does not return me any hits from Elasticsearch. Could you please explain what am I doing wrong?

vhyza · Accepted Answer · 2013-11-18 12:23:14Z

3

I think you have wrong mapping for SequenceLocation.Assembly. Default analyzer splits GPR7.p10 into two tokens gpr7 and p10.

According to documentation term query doesn't analyze your query, so you are asking elasticsearch for GPR7.p10 but it is indexed as tokens gpr7 and p10. So it can't match.

You should recreate index with mapping set to "index" : "not_analyzed" for SequenceLocation.Assembly field.

answered Nov 18, 2013 at 12:23

vhyza

1,0306 silver badges9 bronze badges

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

3 Comments

Sachin Over a year ago

I already tried with data for assembly without any '.' in it. Still I am facing the issue :(. I will update my question so that it will not mislead the users

knutwalker Over a year ago

The answer is still valid. The (default) StandardAnalyzer generates the Token gpr7 (lowercase) while the term query matches only the exact terms. Since GPR7 is different from gpr7, there is no match. Besides changing the mapping as suggested by @vhyza, you could also use a match query, which does analyze the query text.

vhyza Over a year ago

As @knutwalker said, StandardAnalyzer lowercases your input. You can check how would be field indexed by using analyze api. For example: curl localhost:9200/INDEX_WITH_MAPPING/_analyze?text=GPR7&field= SequenceLocation.Assembly&pretty shows you gpr7 if SequenceLocation.Assembly is defined with standard analyzer.

Collectives™ on Stack Overflow

Why the below query in elasticsearch does not work?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related