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