I have Events entity in my database. Event looks like this:
ID, NAME, DATE, CITY
Now.. I integrated ElasticSearch JavaAPI to my application.
There are millions of events in database.
So after typing New in searchbox I want to search events and display them grouped by cities.
Is it possible to query ElasticSearch for such data structure having only such document sturture: Events(ID, NAME, DATE, CITY) indexed ?
Should ElasticSearch have Events(ID, NAME, DATE, CITY) records indexed or some more complicated documents, ready for display?
There are 1,5millions of new events daily..