Re: Aggregation - Blank and date aggregation

2015-01-16 Thread buddarapu nagaraju
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,

Re: Aggregation - Blank and date aggregation

2015-01-16 Thread buddarapu nagaraju
Index mapping here mappings: { - document: { - properties: { - createdDateTime: { - format: dateOptionalTime, - type: date }, - doubleSort1: { - type: double }, - stringSort3: { - type: string

Re: Aggregation - Blank and date aggregation

2015-01-16 Thread Adrien Grand
This looks good, what error did you get? On Fri, Jan 16, 2015 at 9:41 AM, buddarapu nagaraju budda08n...@gmail.com wrote: Index mapping here mappings: { - document: { - properties: { - createdDateTime: { - format: dateOptionalTime, - type: date

Re: Aggregation - Blank and date aggregation

2015-01-16 Thread buddarapu nagaraju
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 adrien.gr...@elasticsearch.com wrote: This looks good, what error did you get? On Fri, Jan 16, 2015 at 9:41 AM, buddarapu

Re: Aggregation - Blank and date aggregation

2015-01-15 Thread Adrien Grand
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 budda08n...@gmail.com wrote:

Re: Aggregation - Blank and date aggregation

2015-01-15 Thread buddarapu nagaraju
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

Aggregation - Blank and date aggregation

2015-01-14 Thread buddarapu nagaraju
Hi , Can some one help me on this ? Does term aggregation counts on blank field values ? 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 ? Regards, Nagaraju --

Re: Aggregation - Blank and date aggregation

2015-01-14 Thread Adrien Grand
On Wed, Jan 14, 2015 at 10:37 AM, buddarapu nagaraju budda08n...@gmail.com 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).