Facet returns different total at different times with the latest 0.90 release

Hi Manish,

On 24 May 2013, at 13:20, Manish Singh singhmanishp@gmail.com wrote:

Hello,

I have a strange problem. My query returns different results at different times.
The query:
curl -XPOST localhost:9200/content/bb/_seach?pretty=1 -d '
{"query":{"match_all":{}},"facets":{"facet":{"terms":{"field":"country","size":10000,"order":"term"}}}}'

on the first go returns:

...
...
"facets" : {
"facet" : {
"_type" : "terms",
"missing" : 0,
"total" : 7256,
"other" : 0,
"terms" : [ {
"term" : "albania",
"count" : 1
}, {
"term" : "argentina",
"count" : 4
...
...
On the second go, the same query returns:
...
...
"facets" : {
"facet" : {
"_type" : "terms",
"missing" : 0,
"total" : 6948,
"other" : 0,
"terms" : [ {
"term" : "albania",
"count" : 1
}, {
"term" : "argentina",
"count" : 4
...
...

Please note the difference in the "total". Down the lines in the results, I find differences in numbers for individual countries. I am not sure why. My index is defined as:
Analyzer -
{
"index": {
"analysis": {
"analyzer": {
"string_lowercase": {
"type": "custom",
"tokenizer": "keyword",
"filter": "lowercase"
}
}
}
}
}

Mapping -

"bb" : {
    "properties" : {
        "content": {
            "type": "object",
            "properties":{
                "centroid":{
                    "type":"geo_point"
                  },
                 "categoryID": {
                       "type" : "string",
                       "index" : "not_analyzed"
                 },
            "address":{
                "type":"object",
                "properties":{
                    "country":{
                        "type":"string",
                        "analyzer": "string_lowercase"
                        },
                     "city":{
                        "type":"string",
                        "analyzer": "string_lowercase"
                        },
                    "postalCode":{
                        "type":"string",
                        "analyzer": "string_lowercase"
                        },
                   "houseNumber":{
                        "type":"string"
                        }
                    }
                }    
            }
        }        
    }
}

}

Any ideas why I get different results for the same query at different times?
The elasticsearch cluster is having two nodes running in Amazon Web Service.

Could it be possible that you're running into:

https://github.com/elasticsearch/elasticsearch/issues/1305

How many shards are in your index?

Cheers,
Dan

--
Dan Fairs | dan.fairs@gmail.com | @danfairs | secondsync.com

--
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.
For more options, visit https://groups.google.com/groups/opt_out.