Elasticsearch: Query an array element

Question

How do I create a query to search for "TV antenna" in Elasticsearch that would return only the first object?

{
    "name": "First",
    "categories": ["Medium TV antennas and cables", "TV cables"]
},
{
    "name": "Second",
    "categories": ["antennas and cables", "TV and accessories"]
}

Could anyone assist?

Saeed Zhiany · Accepted Answer · 2016-12-21 07:04:37Z

1

Try this one:

curl -XGET 'localhost:9200/indexxx/topic/_search?pretty=true' -d '{
  "query": {
    "match": {
      "categories": {
        "query": "TV antenna",
        "operator": "and"
      }
    }
  }
}'

edited Dec 21, 2016 at 7:04

Saeed Zhiany

2,1419 gold badges34 silver badges44 bronze badges

answered Aug 7, 2014 at 6:41

Shams

3,6875 gold badges34 silver badges49 bronze badges

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

Comments

Dan Tuffery · Accepted Answer · 2014-08-07 07:45:02Z

0

Use a phrase match query:

{
    "query": {
        "match_phrase": {
            "categories": {
                "query": "TV antennas"
            }
        }
    }
}

http://www.elasticsearch.org/guide/en/elasticsearch/guide/current/phrase-matching.html

answered Aug 7, 2014 at 7:45

Dan Tuffery

5,92432 silver badges29 bronze badges

Collectives™ on Stack Overflow

Elasticsearch: Query an array element

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related