I'm evaluating replace MySQL+Fulltext search for ES.
Currently I fetch information from twitter, using twitter stream api
and save it to mysql, of course, this solution isnt scalable ...
ES seems to be solution for my needs, there is one point I couln't
figure out: it is how to get count() on a date range grouped by date -
I use this kind of information to show some trends.
My query is something like:
Select created_at, count()
where create_at between '2010-01-01' and '2010-01-31'
match(text) against ('java OR ruby' in boolean match)
Group by create_at;
What should be the best way to replicate this behavior?
Thanks a lot!