Searching in array by elasticsearch

Question

I want to search in elasticsearch but getting hit even though the condition does not match. For eg:-

     {
         tweet: [
              {
                  firstname: Lav
                  lastname: byebye
             }
             {
                   firstname: pointto
                   lastname: ihadcre
             }
             {
                   firstname: letssearch
                   lastname: sarabhai
             }
          ]
      }
    }

Now there are following condition:-

1) must:- firstname: Lav must:- lastname: byebye required:there should be hit

getting: Hit

2) must:- firstname: Lav must:- lastname: ihadcre required:there should not be hit

getting: Hit

I should not be getting hit in 2nd condition which is problem

thanks for help

can u describe the exact query that you have tried out?

Sai
– Sai

2013-07-03 19:26:19 +00:00
Commented Jul 3, 2013 at 19:26 — Sai
– Sai, Commented Jul 3, 2013 at 19:26

imotov · Accepted Answer · 2013-07-04 15:01:24Z

4

To achieve the behavior that you are describing, tweets should be indexed as nested objects and searched using nested query or filter. For example:

curl -XDELETE localhost:9200/test-idx
curl -XPUT localhost:9200/test-idx -d '{
    "settings": {
        "index.number_of_shards": 1,
        "index.number_of_replicas": 0
    },
    "mappings": {
        "doc": {
            "properties": {
                "tweet": {"type": "nested"}
            }
        }
    }
}'
curl -XPUT "localhost:9200/test-idx/doc/1" -d '{
    "tweet": [{
        "firstname": "Lav",
        "lastname": "byebye"
    }, {
        "firstname": "pointto",
        "lastname": "ihadcre"
    }, {
        "firstname": "letssearch",
        "lastname": "sarabhai"
    }]
}
'
echo
curl -XPOST "localhost:9200/test-idx/_refresh"
echo
curl "localhost:9200/test-idx/doc/_search?pretty=true" -d '{
    "query": {
        "nested" : {
            "path" : "tweet",
            "score_mode" : "avg",
            "query" : {
                "bool" : {
                    "must" : [
                        {
                            "match" : {"tweet.firstname" : "Lav"}
                        },
                        {
                            "match" : {"tweet.lastname" : "byebye"}
                        }
                    ]
                }
            }
        }
    }
}'
echo
curl "localhost:9200/test-idx/doc/_search?pretty=true" -d '{
    "query": {
        "nested" : {
            "path" : "tweet",
            "score_mode" : "avg",
            "query" : {
                "bool" : {
                    "must" : [
                        {
                            "match" : {"tweet.firstname" : "Lav"}
                        },
                        {
                            "match" : {"tweet.lastname" : "ihadcre"}
                        }
                    ]
                }
            }
        }
    }
}'

edited Jul 4, 2013 at 15:01

answered Jul 3, 2013 at 13:36

imotov

30.2k3 gold badges93 silver badges87 bronze badges

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

2 Comments

ramseykhalaf Over a year ago

It's not just at using nested queries at query-time. Make sure to change your mapping to support nesting at index-time too. Read the es docs on nested mapping

imotov Over a year ago

I hope the example will help you to figure it out.

Collectives™ on Stack Overflow

Searching in array by elasticsearch

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related