Facet on nested object

Marcin_Dojwa · May 22, 2012, 7:00pm

Hi,

I have the following problem, I am trying to use date_histogram facet on
nested object. Please check the mapping, data, query and the result here:

gist.github.com

https://gist.github.com/anonymous/99ca2a71742774d9786b

data.js

{
   "obj1":[
      {
         "date":"2012-01-01T00:02:00Z",
         "id":4
      },
      {
         "date":"2012-01-01T02:11:00Z",
         "id":6
      }

This file has been truncated. show original

mapping.js

{
   "type1":{
      "properties":{
         "obj1":{
            "type":"nested",
            "properties":{
               "date":{
                  "type":"date",
                  "format":"dateOptionalTime",
                  "include_in_all":false

This file has been truncated. show original

query.js

{
   "facets":{
      "facet1":{
         "date_histogram":{
            "field":"date",
            "interval":"hour"
         },
         "nested":"obj1"
      }
   }

This file has been truncated. show original

There are more than three files. show original

The result for facet1 is empty, could you help me fix this issue ? I have
the same situation when I follow the example from here:
http://www.elasticsearch.org/guide/reference/api/search/facets/ (Facets
with the nested types), the result for facet1 is empty.

Thanks.
Best regards.

Marcin_Dojwa · May 22, 2012, 7:20pm

It's interesting, after upgrading ES from 0.19.3 to 0.19.4 the query works
fine and returns correct results.

2012/5/22 Marcin Dojwa m.dojwa@livechatinc.com

Hi,

I have the following problem, I am trying to use date_histogram facet on
nested object. Please check the mapping, data, query and the result here:
Elastic search - facet on nested object · GitHub
The result for facet1 is empty, could you help me fix this issue ? I have
the same situation when I follow the example from here:
Elasticsearch Platform — Find real-time answers at scale | Elastic (Facets
with the nested types), the result for facet1 is empty.

Thanks.
Best regards.