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]>
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]> 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]> 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]> wrote:
>>>
>>>>
>>>>
>>>> On Wed, Jan 14, 2015 at 10:37 AM, buddarapu nagaraju <
>>>> [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].
>>>> 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].
>>> 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].
>> 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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/CAFtuXXL1FnbPHGfE3h5WmYuyYWpRCJmG%2B0167av24Y%3Dc200u3g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
