Attributes: Filters, Aggregations?

Elastic Stack Elasticsearch
1

Hi

We wish to index physical events as documents. Each event will have multiple attributes, such as artists who are attending, and dates.

We're migrating from Sphinx, and to deal with this, we produced a mysql query which produced a single row, with some columns containing the attributes, eg:

   |id  |name      | artists                  |
   |001 | event 1 | artist1 artist2 artist3 |
   |002 | event 2 | artist1 artist4 artist9 |

Could someone point me in the correct direction for doing this with ES? I can replicate the same layout and it will perform a search query, but I want to be able to use filters, etc to pull out all 'events with artist 1' for example

Many thanks

2

ps, I will be using Logstash/JDBC to import the records via Mysql

3

Hi, so the question is how to do filter queries with Elasticsearch?

GET /_search
{
    "query": {
        "filtered": {
            "filter":   { "term": { "artists": "artist1" }}
        }
    }
}

More examples at https://www.elastic.co/guide/en/elasticsearch/guide/current/_combining_queries_with_filters.html

4

Hi

No, it was more how to store the data - should I be storing each artist as a nested attribute in the index?