I was able to figure out through fiddler ...date histrograms are returns in seperate nested object in the result .. Now works
On Friday, January 16, 2015, Adrien Grand <[email protected]> wrote: > This looks good, what error did you get? > > On Fri, Jan 16, 2015 at 9:41 AM, buddarapu nagaraju <[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > >> Index mapping here >> >> "mappings": { >> >> - "document": { >> - "properties": { >> - "createdDateTime": { >> - "format": "dateOptionalTime", >> - "type": "date" >> }, >> - "doubleSort1": { >> - "type": "double" >> }, >> - "stringSort3": { >> - "type": "string" >> }, >> - "doubleSort2": { >> - "type": "double" >> }, >> - "doubleSort3": { >> - "type": "double" >> }, >> - "numSort1": { >> - "type": "long" >> }, >> - "stringSort2": { >> - "type": "string" >> }, >> - "dcn": { >> - "type": "string" >> }, >> - "numSort2": { >> - "type": "long" >> }, >> - "numSort3": { >> - "type": "long" >> }, >> - "path": { >> - "type": "string" >> }, >> - "numField": { >> - "type": "long" >> }, >> - "dateSort3": { >> - "format": "dateOptionalTime", >> - "type": "date" >> }, >> - "dateSort2": { >> - "format": "dateOptionalTime", >> - "type": "date" >> }, >> - "rank": { >> - "type": "double" >> }, >> - "id": { >> - "type": "long" >> }, >> - "text": { >> - "type": "string" >> }, >> - "fields": { >> - "properties": { >> - "isAnalyzed": { >> - "type": "boolean" >> }, >> - "name": { >> - "type": "string" >> }, >> - "isFullText": { >> - "type": "boolean" >> }, >> - "isStored": { >> - "type": "boolean" >> }, >> - "value": { >> - "type": "string" >> } >> } >> } >> } >> } >> >> >> Regards >> Nagaraju >> 908 517 6981 >> >> On Fri, Jan 16, 2015 at 3:23 AM, buddarapu nagaraju < >> [email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: >> >>> Hi , >>> >>> I tried but date histrogram didnt work not sure what is the mistake am >>> doing >>> >>> here is date histrogram request(json) am passing and also pasted sample >>> doc structure >>> >>> >>> >>> >>> >>> date histogram request >>> >>> { >>> "aggs": { >>> "createddatetime": { >>> "date_histogram": { >>> "field": "createddatetime", >>> "interval": "day" >>> } >>> } >>> } >>> } >>> >>> Document in index has fields >>> >>> >>> >>> - >>> - "id": 79, >>> - "rank": 0, >>> - "dateSort2": "2015-01-15T06:08:06.7091884Z", >>> - "dateSort3": "0001-01-01T00:00:00", >>> - "doubleSort1": 118.5, >>> - "doubleSort2": 67884.18, >>> - "doubleSort3": 54262.600000000006, >>> - "numField": 0, >>> - "createdDateTime": "2015-01-16T06:08:06.7091884Z", >>> - >>> >>> >>> Regards >>> Nagaraju >>> 908 517 6981 >>> >>> On Thu, Jan 15, 2015 at 12:38 PM, Adrien Grand < >>> [email protected] >>> <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: >>> >>>> Then it means that you want to use a date_histogram aggregation with >>>> interval=day. See >>>> http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-aggregations-bucket-datehistogram-aggregation.html >>>> >>>> On Thu, Jan 15, 2015 at 4:43 PM, buddarapu nagaraju < >>>> [email protected] >>>> <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: >>>> >>>>> Hey Adrien ,Thank you.I have one more question on aggregating on dates >>>>> . >>>>> >>>>> We actually stored date time in a field called "createdDateTime" but I >>>>> need only aggregates on date part of date time . >>>>> >>>>> Any ideas ? Or sample code can help us ? >>>>> >>>>> Regards >>>>> Nagaraju >>>>> 908 517 6981 >>>>> >>>>> On Wed, Jan 14, 2015 at 6:10 AM, Adrien Grand < >>>>> [email protected] >>>>> <javascript:_e(%7B%7D,'cvml','[email protected]');>> >>>>> wrote: >>>>> >>>>>> >>>>>> >>>>>> On Wed, Jan 14, 2015 at 10:37 AM, buddarapu nagaraju < >>>>>> [email protected] >>>>>> <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: >>>>>> >>>>>>> Does term aggregation counts on blank field values ? >>>>>>> >>>>>>> >>>>>> Yes, an empty value "" counts as a term. Note that you need the field >>>>>> to be not analyzed for it to work (or to use an analyzer that emits empty >>>>>> strings). Otherwise the standard analyzer would analyzer "" as an empty >>>>>> list of tokens, so a field value of "" would not actually count... >>>>>> >>>>>> >>>>>>> Does term aggregation is enough for doing date aggregation ? Or >>>>>>> there any specific aggregations we have ?All I need in date aggregation >>>>>>> is >>>>>>> to know different dates and its counts ? >>>>>>> >>>>>> >>>>>> A terms aggregation is enough, but a date_histogram aggregation is >>>>>> generally more useful on dates as there are lots of unique values and >>>>>> it's >>>>>> often more useful to group them based on the year, month or day. >>>>>> >>>>>> -- >>>>>> Adrien Grand >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to a topic in >>>>>> the Google Groups "elasticsearch" group. >>>>>> To unsubscribe from this topic, visit >>>>>> https://groups.google.com/d/topic/elasticsearch/i9N09n_-n38/unsubscribe >>>>>> . >>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>> [email protected] >>>>>> <javascript:_e(%7B%7D,'cvml','elasticsearch%[email protected]');> >>>>>> . >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j74ZqbBN0zNW6-5Feu7xYTKkomzx%3DDMhx28inFVYLSu5Q%40mail.gmail.com >>>>>> <https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j74ZqbBN0zNW6-5Feu7xYTKkomzx%3DDMhx28inFVYLSu5Q%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>>> 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 [email protected] >>>>> <javascript:_e(%7B%7D,'cvml','elasticsearch%[email protected]');> >>>>> . >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/elasticsearch/CAFtuXXKp0JycJfNvLxPGN_5YL7P-X%3DGDzvmYJQ9NFN7Q%2BaJjQw%40mail.gmail.com >>>>> <https://groups.google.com/d/msgid/elasticsearch/CAFtuXXKp0JycJfNvLxPGN_5YL7P-X%3DGDzvmYJQ9NFN7Q%2BaJjQw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> >>>> >>>> -- >>>> Adrien Grand >>>> >>>> -- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "elasticsearch" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/elasticsearch/i9N09n_-n38/unsubscribe >>>> . >>>> To unsubscribe from this group and all its topics, send an email to >>>> [email protected] >>>> <javascript:_e(%7B%7D,'cvml','elasticsearch%[email protected]');> >>>> . >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j7Nn8h7C9BoW6PUjHbS%2Bnerpw3%3DWUi5RrC5ewtDBtSRaA%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j7Nn8h7C9BoW6PUjHbS%2Bnerpw3%3DWUi5RrC5ewtDBtSRaA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>>> 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 [email protected] >> <javascript:_e(%7B%7D,'cvml','elasticsearch%[email protected]');> >> . >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/elasticsearch/CAFtuXXL1FnbPHGfE3h5WmYuyYWpRCJmG%2B0167av24Y%3Dc200u3g%40mail.gmail.com >> <https://groups.google.com/d/msgid/elasticsearch/CAFtuXXL1FnbPHGfE3h5WmYuyYWpRCJmG%2B0167av24Y%3Dc200u3g%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Adrien Grand > > -- > You received this message because you are subscribed to a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/elasticsearch/i9N09n_-n38/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected] > <javascript:_e(%7B%7D,'cvml','elasticsearch%[email protected]');> > . > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j59V6o_8_Riu9_Vo6g-YsmPM71uUMt1%3DQBWVjHm-Jq5VQ%40mail.gmail.com > <https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j59V6o_8_Riu9_Vo6g-YsmPM71uUMt1%3DQBWVjHm-Jq5VQ%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Regards Nagaraju 908 517 6981 -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAFtuXXKmxEKpPZ22uFexnWKVrNmTz7vsOoo3wMGbTCN%3DAOo%3DDw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
