Elasticsearch: Search in an array of JSONs

Question

I'm using Elasticsearch with the python library and I have a problem using the search query when the object become a little bit complex. I have objects build like that in my index:

{
   "id" : 120,
   "name": bob,
   "shared_status": {
       "post_id": 123456789,
       "text": "This is a sample",
       "urls" : [
           {
              "url": "http://test.1.com",
              "displayed_url": "test.1.com" 
           },
           {
              "url": "http://blabla.com",
              "displayed_url": "blabla.com" 
           }
       ]
   }
}

Now I want to do a query that will return me this document only if in one of the displayed URL's a substring "test" and there is a field "text" in the main document. So I did this query:

{
   "query": {
       "bool": {
           "must": [
                    {"exists": {"field": "text"}}
                   ]
           }
        }
   }
}

But I don't know what query to add for the part: one of the displayed URL's a substring "test"

Is that posssible? How does the iteration on the list works?

It is possible. Please provide output of _mapping : elastic.co/guide/en/elasticsearch/reference/current/… — Rahul
– Rahul, Commented Mar 19, 2017 at 15:54
The question is about query elasticsearch not iterate on a JSON — mel
– mel, Commented Mar 19, 2017 at 16:00
@rahulroc I simplified the situation using a fake example but my application is about tweets from the API twitter. And there is no mapping defined for those fields in my mapping. — mel
– mel, Commented Mar 19, 2017 at 16:03
@mel As you didn't provide explicit mapping, ES assumes some mapping types based on input data, more details in the answer — Rahul
– Rahul, Commented Mar 19, 2017 at 16:24

Rahul · Accepted Answer · 2017-03-19 16:23:35Z

2

If you didn't define an explicit mapping for your schema, elasticsearch creates a default mapping based on the data input.

urls will be of type object
displayed_url will be of type string and using standard analyzer

As you don't need any association between url and displayed_url, the current schema will work fine.

You can use a match query for full text match

GET _search
{
  "query": {
    "bool": {
      "must": [
        {
          "exists": {
            "field": "text"
          }
        },
        {
          "match": {
            "urls.displayed_url": "test"
          }
        }
      ]
    }
  }
}

answered Mar 19, 2017 at 16:23

Rahul

16.4k4 gold badges45 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch: Search in an array of JSONs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related