https://groups.google.com/d/topic/elasticsearch/pjoNmosdCPs/discussion

gistfile1.txt

curl -XDELETE 'http://localhost:9200/test-idx'
echo
curl -XPUT 'http://localhost:9200/test-idx' -d '{
    "mappings": {
        "article": {
            "properties": {
                "a": {
                    "type": "integer"
                },
                "b": {
                    "type": "nested",
                    "include_in_root": true,
                    "c": {
                        "type": "integer"
                    }
                }
            }
        }
    }
}

'
echo
curl -XPUT 'http://localhost:9200/test-idx/article/1' -d '{ "a": 1, b: [{"c": 1},{"c": 2}] }'
echo
curl -XPUT 'http://localhost:9200/test-idx/article/2' -d '{ "a": 1, b: [{"c": 2},{"c": 3}] }'
echo
curl -XPUT 'http://localhost:9200/test-idx/article/3' -d '{ "a": 2, b: [{"c": 1},{"c": 10}] }'
echo
curl -XPOST 'http://localhost:9200/test-idx/_refresh'
echo
curl -XGET 'http://localhost:9200/test-idx/article/_search?pretty=true&search_type=count' -d '{     
    "query" : { "match_all" : {} },
    "facets": { 
        "test" : {
            "terms_stats" : { 
                "key_field" : "a",
                "value_field": "b.c"
            }
        } 
    }
}'
echo