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"
> },
> - "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 <budda08n...@gmail.com
> > 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 <
>> adrien.gr...@elasticsearch.com> 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 <
>>> budda08n...@gmail.com> 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 <
>>>> adrien.gr...@elasticsearch.com> wrote:
>>>>
>>>>>
>>>>>
>>>>> 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). 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
>>>>> elasticsearch+unsubscr...@googlegroups.com.
>>>>> 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 elasticsearch+unsubscr...@googlegroups.com.
>>>> 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
>>> elasticsearch+unsubscr...@googlegroups.com.
>>> 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 elasticsearch+unsubscr...@googlegroups.com.
> 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 the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to elasticsearch+unsubscr...@googlegroups.com.
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.
For more options, visit https://groups.google.com/d/optout.
