Grouping most used terms by geohash_grid and date

Hello,

I am facing a problème and i don't really undestand why.

I am storing tweets and i want to know, day by day what are the "trending
topics" of the day, by localisation.

When i try this request :

curl -XGET http://localhost:9200/twitter/_search -d '{
"query":{
"match_all":{

  }

},
"filter":{
"range":{
"created_at":{
"from":"Mon Feb 23 00:00:00 +0000 2015",
"to":"Wed Feb 23 23:59:59 +0000 2015"
}
}
},
"aggs":{
"geo1":{
"geohash_grid":{
"field":"geo",
"precision":5
},
"aggs":{
"tags":{
"terms":{
"field":"text",
"size":10
}
}
}
}
}
}'

The time filter is not used.

It is not the proper way to use the filter in an agggregation ?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/bcbd34be-4fae-4bf2-bbb1-016d02c27def%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

You should use a filteredQuery.

http://www.elasticsearch.org/guide/en/elasticsearch/guide/current/_combining_queries_with_filters.html

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 26 févr. 2015 à 23:56, alexandre.klein@instantluxe.com a écrit :

Hello,

I am facing a problème and i don't really undestand why.

I am storing tweets and i want to know, day by day what are the "trending topics" of the day, by localisation.

When i try this request :

curl -XGET http://localhost:9200/twitter/_search -d '{
"query":{
"match_all":{

  }

},
"filter":{
"range":{
"created_at":{
"from":"Mon Feb 23 00:00:00 +0000 2015",
"to":"Wed Feb 23 23:59:59 +0000 2015"
}
}
},
"aggs":{
"geo1":{
"geohash_grid":{
"field":"geo",
"precision":5
},
"aggs":{
"tags":{
"terms":{
"field":"text",
"size":10
}
}
}
}
}
}'

The time filter is not used.

It is not the proper way to use the filter in an agggregation ?

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/bcbd34be-4fae-4bf2-bbb1-016d02c27def%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/E8A5364C-2C71-4FD8-A328-23DBA1BC3CAF%40pilato.fr.
For more options, visit https://groups.google.com/d/optout.