bvnagaraju
(venkata nagaraju buddarapu)
January 14, 2015, 9:37am
1
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
--
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+unsubscribe@googlegroups.com .
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/06a328c6-eead-473e-ac04-41bd04464cfc%40googlegroups.com .
For more options, visit https://groups.google.com/d/optout .
jpountz
(Adrien Grand)
January 14, 2015, 11:10am
2
On Wed, Jan 14, 2015 at 10:37 AM, buddarapu nagaraju budda08nitt@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 the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com .
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j74ZqbBN0zNW6-5Feu7xYTKkomzx%3DDMhx28inFVYLSu5Q%40mail.gmail.com .
For more options, visit https://groups.google.com/d/optout .
bvnagaraju
(venkata nagaraju buddarapu)
January 15, 2015, 3:43pm
3
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.grand@elasticsearch.com > wrote:
On Wed, Jan 14, 2015 at 10:37 AM, buddarapu nagaraju <
budda08nitt@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+unsubscribe@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+unsubscribe@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 .
For more options, visit https://groups.google.com/d/optout .
jpountz
(Adrien Grand)
January 15, 2015, 5:38pm
4
Then it means that you want to use a date_histogram aggregation with
interval=day. See
Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today.
On Thu, Jan 15, 2015 at 4:43 PM, buddarapu nagaraju budda08nitt@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.grand@elasticsearch.com > wrote:
On Wed, Jan 14, 2015 at 10:37 AM, buddarapu nagaraju <
budda08nitt@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+unsubscribe@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+unsubscribe@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 the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com .
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j7Nn8h7C9BoW6PUjHbS%2Bnerpw3%3DWUi5RrC5ewtDBtSRaA%40mail.gmail.com .
For more options, visit https://groups.google.com/d/optout .
bvnagaraju
(venkata nagaraju buddarapu)
January 16, 2015, 8:23am
5
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.grand@elasticsearch.com > wrote:
Then it means that you want to use a date_histogram aggregation with
interval=day. See
Elasticsearch Platform — Find real-time answers at scale | Elastic
On Thu, Jan 15, 2015 at 4:43 PM, buddarapu nagaraju <budda08nitt@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.grand@elasticsearch.com > wrote:
On Wed, Jan 14, 2015 at 10:37 AM, buddarapu nagaraju <
budda08nitt@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+unsubscribe@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+unsubscribe@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+unsubscribe@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+unsubscribe@googlegroups.com .
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAFtuXXJ-s14ZFCMi4RjFjePCpvW9-URP5T61hBCLHKbCU9o_aA%40mail.gmail.com .
For more options, visit https://groups.google.com/d/optout .
bvnagaraju
(venkata nagaraju buddarapu)
January 16, 2015, 8:41am
6
Index mapping here
"mappings": {
"document": {
"properties": {
"createdDateTime": {
"format": "dateOptionalTime",
"type": "date"
},
"doubleSort1": {
"stringSort3": {
"doubleSort2": {
"doubleSort3": {
"numSort1": {
"stringSort2": {
"dcn": {
"numSort2": {
"numSort3": {
"path": {
"numField": {
"dateSort3": {
"format": "dateOptionalTime",
"type": "date"
},
"dateSort2": {
"format": "dateOptionalTime",
"type": "date"
},
"rank": {
"id": {
"text": {
"fields": {
"properties": {
"isAnalyzed": {
"name": {
"isFullText": {
"isStored": {
"value": {
"type": "string"
}
}
}
}
}
Regards
Nagaraju
908 517 6981
On Fri, Jan 16, 2015 at 3:23 AM, buddarapu nagaraju budda08nitt@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.grand@elasticsearch.com > wrote:
Then it means that you want to use a date_histogram aggregation with
interval=day. See
Elasticsearch Platform — Find real-time answers at scale | Elastic
On Thu, Jan 15, 2015 at 4:43 PM, buddarapu nagaraju <
budda08nitt@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.grand@elasticsearch.com > wrote:
On Wed, Jan 14, 2015 at 10:37 AM, buddarapu nagaraju <
budda08nitt@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+unsubscribe@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+unsubscribe@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+unsubscribe@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+unsubscribe@googlegroups.com .
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 .
jpountz
(Adrien Grand)
January 16, 2015, 8:54am
7
This looks good, what error did you get?
On Fri, Jan 16, 2015 at 9:41 AM, buddarapu nagaraju budda08nitt@gmail.com
wrote:
Index mapping here
"mappings": {
"document": {
"properties": {
"createdDateTime": {
"format": "dateOptionalTime",
"type": "date"
},
"doubleSort1": {
"stringSort3": {
"doubleSort2": {
"doubleSort3": {
"numSort1": {
"stringSort2": {
"dcn": {
"numSort2": {
"numSort3": {
"path": {
"numField": {
"dateSort3": {
"format": "dateOptionalTime",
"type": "date"
},
"dateSort2": {
"format": "dateOptionalTime",
"type": "date"
},
"rank": {
"id": {
"text": {
"fields": {
"properties": {
"isAnalyzed": {
"name": {
"isFullText": {
"isStored": {
"value": {
"type": "string"
}
}
}
}
}
Regards
Nagaraju
908 517 6981
On Fri, Jan 16, 2015 at 3:23 AM, buddarapu nagaraju <budda08nitt@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.grand@elasticsearch.com > wrote:
Then it means that you want to use a date_histogram aggregation with
interval=day. See
Elasticsearch Platform — Find real-time answers at scale | Elastic
On Thu, Jan 15, 2015 at 4:43 PM, buddarapu nagaraju <
budda08nitt@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.grand@elasticsearch.com > wrote:
On Wed, Jan 14, 2015 at 10:37 AM, buddarapu nagaraju <
budda08nitt@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+unsubscribe@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+unsubscribe@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+unsubscribe@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+unsubscribe@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+unsubscribe@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 .
bvnagaraju
(venkata nagaraju buddarapu)
January 16, 2015, 9:50am
8
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.grand@elasticsearch.com
wrote:
This looks good, what error did you get?
On Fri, Jan 16, 2015 at 9:41 AM, buddarapu nagaraju <budda08nitt@gmail.com
<javascript:_e(%7B%7D,'cvml','budda08nitt@gmail.com');>> wrote:
Index mapping here
"mappings": {
"document": {
"properties": {
"createdDateTime": {
"format": "dateOptionalTime",
"type": "date"
},
"doubleSort1": {
"stringSort3": {
"doubleSort2": {
"doubleSort3": {
"numSort1": {
"stringSort2": {
"dcn": {
"numSort2": {
"numSort3": {
"path": {
"numField": {
"dateSort3": {
"format": "dateOptionalTime",
"type": "date"
},
"dateSort2": {
"format": "dateOptionalTime",
"type": "date"
},
"rank": {
"id": {
"text": {
"fields": {
"properties": {
"isAnalyzed": {
"name": {
"isFullText": {
"isStored": {
"value": {
"type": "string"
}
}
}
}
}
Regards
Nagaraju
908 517 6981
On Fri, Jan 16, 2015 at 3:23 AM, buddarapu nagaraju <
budda08nitt@gmail.com
<javascript:_e(%7B%7D,'cvml','budda08nitt@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.grand@elasticsearch.com
<javascript:_e(%7B%7D,'cvml','adrien.grand@elasticsearch.com');>> wrote:
Then it means that you want to use a date_histogram aggregation with
interval=day. See
Elasticsearch Platform — Find real-time answers at scale | Elastic
On Thu, Jan 15, 2015 at 4:43 PM, buddarapu nagaraju <
budda08nitt@gmail.com
<javascript:_e(%7B%7D,'cvml','budda08nitt@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.grand@elasticsearch.com
<javascript:_e(%7B%7D,'cvml','adrien.grand@elasticsearch.com');>>
wrote:
On Wed, Jan 14, 2015 at 10:37 AM, buddarapu nagaraju <
budda08nitt@gmail.com
<javascript:_e(%7B%7D,'cvml','budda08nitt@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+unsubscribe@googlegroups.com
<javascript:_e(%7B%7D,'cvml','elasticsearch%2Bunsubscribe@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+unsubscribe@googlegroups.com
<javascript:_e(%7B%7D,'cvml','elasticsearch%2Bunsubscribe@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+unsubscribe@googlegroups.com
<javascript:_e(%7B%7D,'cvml','elasticsearch%2Bunsubscribe@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+unsubscribe@googlegroups.com
<javascript:_e(%7B%7D,'cvml','elasticsearch%2Bunsubscribe@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 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+unsubscribe@googlegroups.com
<javascript:_e(%7B%7D,'cvml','elasticsearch%2Bunsubscribe@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
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 elasticsearch+unsubscribe@googlegroups.com .
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 .