> >
> > > > >>> > wrote:
> > > >
> > > > >>>> Hi!
> > > > >>>> if anybody have been used groupby query in elastic
> > > search.Please
> > > > >>>> reply me.
> > > >
> > > > >>>>
> > > Your Thankfully
> > > >
> > > > >>>>
> > > Sandeep Kumar Tiwari
> > >
> > > ```
---
### Author:  [@Clinton\_Gormley](https://discuss.elastic.co/u/Clinton_Gormley)
#### Post date: [June 23, 2011, 1:32pm UTC](https://discuss.elastic.co/t/search-query/4682/11 "2011-06-23T13:32:15Z")
Hi Sandeep
> I wnat to execute {
>
> > > "query": {"match\_all":{} },
> > > "filter" : {
> > > "bool" : {
> > > "must" : {"range" : {
> > > "file\_size" :
> > > { "from" : 10, "to" : 10000 }}},//2011-08-06
> > > "must" : {"range" : {
> > > "file\_size" :
> > > { "from" : 10001, "to" : 1000000 }//here should be date
> > > }}}
> > > }
> > > } This type of query on my following database please send me
> > > example.
> This is my couch database fields-
>
> \_id 1628606f4283247f269be3f8ce00486f
> \_rev2 -4f7058756fab1350c1b25e4832a1f7ed
> author duglus
> date 2011-10-01
> msg How are you
> location mathura
> type x
Do you have your data in Elasticsearch yet?
What problem are you having when you try to do a search like that?
Note, in your previous email, you talked about grouping - the above
query doesn't group. It will just return docs that fit into your
ranges.
If you want to 'group' then you should be looking at using facets, as
Ivan pointed out.
So, given your example data, what result are you wanting? Are you able
to state the result you want in English, instead of code? For example:
I want to know the total number of docs that include the keywords
"how are you", in location "mathura", grouped by week using the date
field
clint
---
### Author:  [@sandeep15mca](https://discuss.elastic.co/u/sandeep15mca)
#### Post date: [June 23, 2011, 1:54pm UTC](https://discuss.elastic.co/t/search-query/4682/12 "2011-06-23T13:54:23Z")
Sir!
I want to all result between given date-
$ curl -XGET '192.168.1.24:9200/mydb2/mytype2/\_search?pretty=true' -d
'{"query"
:{"match\_all":{}},"filter":{"range":{"file\_size":{"from":"2011-09-02","to":"201
1-10-01"}}}}'
{
"took" : 2,
"timed\_out" : false,
"\_shards" : {
"total" : 5,
"successful" : 5,
"failed" : 0
},
"hits" : {
"total" : 0,
"max\_score" : null,
"hits" :
}
}
But I want give result between 2011-09-02 and 201
1-10-01
Thanks!
On Thu, Jun 23, 2011 at 7:02 PM, Clinton Gormley [clinton@iannounce.co.uk](mailto:clinton@iannounce.co.uk)wrote:
> Hi Sandeep
>
> > I wnat to execute {
> >
> > > > "query": {"match\_all":{} },
> > > > "filter" : {
> > > > "bool" : {
> > > > "must" : {"range" : {
> > > > "file\_size" :
> > > > { "from" : 10, "to" : 10000 }}},//2011-08-06
> > > > "must" : {"range" : {
> > > > "file\_size" :
> > > > { "from" : 10001, "to" : 1000000 }//here should be date
> > > > }}}
> > > > }
> > > > } This type of query on my following database please send me
> > > > example.
>
> > This is my couch database fields-
> >
> > \_id 1628606f4283247f269be3f8ce00486f
> > \_rev2 -4f7058756fab1350c1b25e4832a1f7ed
> > author duglus
> > date 2011-10-01
> > msg How are you
> > location mathura
> > type x
>
> Do you have your data in Elasticsearch yet?
>
> What problem are you having when you try to do a search like that?
>
> Note, in your previous email, you talked about grouping - the above
> query doesn't group. It will just return docs that fit into your
> ranges.
>
> If you want to 'group' then you should be looking at using facets, as
> Ivan pointed out.
>
> So, given your example data, what result are you wanting? Are you able
> to state the result you want in English, instead of code? For example:
>
> I want to know the total number of docs that include the keywords
> "how are you", in location "mathura", grouped by week using the date
> field
>
> clint
---
### Author:  [@Clinton\_Gormley](https://discuss.elastic.co/u/Clinton_Gormley)
#### Post date: [June 23, 2011, 2:06pm UTC](https://discuss.elastic.co/t/search-query/4682/13 "2011-06-23T14:06:47Z")
Hi Sandeep
On Thu, 2011-06-23 at 19:24 +0530, sandeep tiwari wrote:
> Sir!
> I want to all result between given date-
> $ curl -XGET '192.168.1.24:9200/mydb2/mytype2/\_search?pretty=true'
> -d '{"query"
> :{"match\_all":{}},"filter":{"range":{"file\_size":{"from":"2011-09-02","to":"201
> 1-10-01"}}}}'
Why are you using the field 'file\_size' as a date field? That doesn't
seem to make much sense. In your previous email, you have a 'date'
field.
So, I think what you're looking for is:
curl -XGET '[http://127.0.0.1:9200/mydb2/mytype2/\_search?pretty=1](http://127.0.0.1:9200/mydb2/mytype2/_search?pretty=1)' -d '
{
"query" : {
"constant\_score" : {
"filter" : {
"range" : {
"date" : {
"lte" : "2011-10-01",
"gte" : "2011-09-02"
}
}
}
}
}
}
'
clint
---
### Author:  [@sandeep15mca](https://discuss.elastic.co/u/sandeep15mca)
#### Post date: [June 23, 2011, 2:22pm UTC](https://discuss.elastic.co/t/search-query/4682/14 "2011-06-23T14:22:52Z")
thanks lot sir!
one other request if you have some material regarding elasticsearch query
please send me because I am new in that field but not in java.
```
Your thankfully
Sandeep Kumar tiwari
```
On Thu, Jun 23, 2011 at 7:36 PM, Clinton Gormley [clinton@iannounce.co.uk](mailto:clinton@iannounce.co.uk)wrote:
> Hi Sandeep
>
> On Thu, 2011-06-23 at 19:24 +0530, sandeep tiwari wrote:
>
> > Sir!
> > I want to all result between given date-
> > $ curl -XGET '192.168.1.24:9200/mydb2/mytype2/\_search?pretty=true'
> > -d '{"query"
>
> :{"match\_all":{}},"filter":{"range":{"file\_size":{"from":"2011-09-02","to":"201
>
> > 1-10-01"}}}}'
>
> Why are you using the field 'file\_size' as a date field? That doesn't
> seem to make much sense. In your previous email, you have a 'date'
> field.
>
> So, I think what you're looking for is:
>
> curl -XGET '[http://127.0.0.1:9200/mydb2/mytype2/\_search?pretty=1](http://127.0.0.1:9200/mydb2/mytype2/_search?pretty=1)' -d '
> {
> "query" : {
> "constant\_score" : {
> "filter" : {
> "range" : {
> "date" : {
> "lte" : "2011-10-01",
> "gte" : "2011-09-02"
> }
> }
> }
> }
> }
> }
> '
>
> clint
---
### Author:  [@Clinton\_Gormley](https://discuss.elastic.co/u/Clinton_Gormley)
#### Post date: [June 23, 2011, 2:34pm UTC](https://discuss.elastic.co/t/search-query/4682/15 "2011-06-23T14:34:34Z")
On Thu, 2011-06-23 at 19:52 +0530, sandeep tiwari wrote:
> thanks lot sir!
> one other request if you have some material regarding elasticsearch
> query please send me because I am new in that field but not in java.
All the information you need is available on the site:
> **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)**
>
> 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.
clint
---
### Author:  [@sandeep15mca](https://discuss.elastic.co/u/sandeep15mca)
#### Post date: [June 24, 2011, 5:11am UTC](https://discuss.elastic.co/t/search-query/4682/16 "2011-06-24T05:11:24Z")
Sir!
query which was tell by you work properly but when I want to get
information of two individual month by this query,result come out only one
month not both.
my query is-
curl -XGET '[http://127.0.0.1:9200/mydb2/mytype2/\_search?pretty=1](http://127.0.0.1:9200/mydb2/mytype2/_search?pretty=1)' -d
'
{
"query" : {
"constant\_score" : {
"filter" : {
"range" : {
"date" : {
"lte" : "2011-09-01",
"gte" : "2011-09-10"
}
}
},
"range" : {
"date" : {
"lte" : "2011-10-07",
"gte" : "2011-10-17"
}
}
}
}
}
}'
result come out is only 9th month.please guide me.
```
your faithfully
```
Sandeep Tiwari
On Thu, Jun 23, 2011 at 8:04 PM, Clinton Gormley [clinton@iannounce.co.uk](mailto:clinton@iannounce.co.uk)wrote:
> On Thu, 2011-06-23 at 19:52 +0530, sandeep tiwari wrote:
>
> > thanks lot sir!
> > one other request if you have some material regarding elasticsearch
> > query please send me because I am new in that field but not in java.
>
> All the information you need is available on the site:
>
> [http://www.elasticsearch.org/](http://www.elasticsearch.org/)
>
> clint
---
### Author:  [@Clinton\_Gormley](https://discuss.elastic.co/u/Clinton_Gormley)
#### Post date: [June 24, 2011, 9:55am UTC](https://discuss.elastic.co/t/search-query/4682/17 "2011-06-24T09:55:58Z")
On Fri, 2011-06-24 at 10:41 +0530, sandeep tiwari wrote:
> Sir!
> query which was tell by you work properly but when I want to get
> information of two individual month by this query,result come out only
> one month not both.
you need to combine your filters with and|or|not filters
see:
> **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)**
>
> 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.
> **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)**
>
> 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.
> **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)**
>
> 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.
clint
---
### Author:  [@sandeep15mca](https://discuss.elastic.co/u/sandeep15mca)
#### Post date: [June 24, 2011, 10:35am UTC](https://discuss.elastic.co/t/search-query/4682/18 "2011-06-24T10:35:14Z")
Sir!
After executing the query there is some exception please check query-
'{
"filtered":{
"query":{
"constant\_score" : {
"filter" : {"and":[{
"range" : {
"date" : {
"lte" : "2011-09-01",
"gte" : "2011-09-10"
```
}
}
}],
```
"and":[{"range" : {
"date" : {
"lte" : "2011-10-07",
"gte" : "2011-10-17"
}
}
}]
}
}
}
}
}'
On Fri, Jun 24, 2011 at 3:25 PM, Clinton Gormley [clinton@iannounce.co.uk](mailto:clinton@iannounce.co.uk)wrote:
> On Fri, 2011-06-24 at 10:41 +0530, sandeep tiwari wrote:
>
> > Sir!
> > query which was tell by you work properly but when I want to get
> > information of two individual month by this query,result come out only
> > one month not both.
>
> you need to combine your filters with and|or|not filters
>
> see:
>
> [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/query-dsl/and-filter.html)
> [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/query-dsl/or-filter.html)
> [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/query-dsl/not-filter.html)
>
> clint
---
### Author:  [@Clinton\_Gormley](https://discuss.elastic.co/u/Clinton_Gormley)
#### Post date: [June 24, 2011, 11:00am UTC](https://discuss.elastic.co/t/search-query/4682/19 "2011-06-24T11:00:15Z")
On Fri, 2011-06-24 at 16:05 +0530, sandeep tiwari wrote:
> Sir!
> After executing the query there is some exception please check
> query-
Sandeep - please read the docs. your syntax error is pretty obvious.
> **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)**
>
> 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.
> **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)**
>
> 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.
> **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)**
>
> 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.
clint
---
### Author:  [@sandeep15mca](https://discuss.elastic.co/u/sandeep15mca)
#### Post date: [June 29, 2011, 9:50am UTC](https://discuss.elastic.co/t/search-query/4682/20 "2011-06-29T09:50:04Z")
On Fri, Jun 24, 2011 at 4:30 PM, Clinton Gormley [clinton@iannounce.co.uk](mailto:clinton@iannounce.co.uk)wrote:
> On Fri, 2011-06-24 at 16:05 +0530, sandeep tiwari wrote:
>
> > Sir!
> > After executing the query there is some exception please check
> > query-
>
> Sandeep - please read the docs. your syntax error is pretty obvious.
>
> [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/query-dsl/and-filter.html)
> [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/query-dsl/or-filter.html)
> [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/query-dsl/not-filter.html)
Sir!
I try to open docs on [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/docs) but its give 404
code error while speed is to good I request to you please guide me where
syntax error in-
curl -XGET '[http://127.0.0.1:9200/mydb2/mytype2/\_search?pretty=true](http://127.0.0.1:9200/mydb2/mytype2/_search?pretty=true)' -d '
'{
"filtered":{
"query":{
"constant\_score" : {
"filter" : {"and":[{
"range" : {
"date" : {
"lte" : "2011-09-01",
"gte" : "2011-09-10"
```
}
}
}],
```
"and":[{"range" : {
"date" : {
"lte" : "2011-10-07",
"gte" : "2011-10-17"
}
}
}]
}
}
}
}
}'
because is is generated exception.
thanks
> clint
[Next page](https://discuss.elastic.co/t/search-query/4682.md?page=2)