Search_query


(sandeep15mca) #1

Hi!
if anybody have been used groupby query in elastic search.Please reply
me.

                                                Your Thankfully

                                              Sandeep Kumar Tiwari

(Lukáš Vlček) #2

Hi,

can you be more specific? May be you want to look at parent/child feature.

Regards,
Lukas

On Wed, Jun 22, 2011 at 10:39 AM, sandeep tiwari sandeep15mca@gmail.comwrote:

Hi!
if anybody have been used groupby query in elastic search.Please reply
me.

                                                Your Thankfully

                                              Sandeep Kumar Tiwari

(sandeep15mca) #3

Sir!
I want to know how use group by date in my elastic search query.

On Wed, Jun 22, 2011 at 2:39 PM, Lukáš Vlček lukas.vlcek@gmail.com wrote:

Hi,

can you be more specific? May be you want to look at parent/child feature.

Regards,
Lukas

On Wed, Jun 22, 2011 at 10:39 AM, sandeep tiwari sandeep15mca@gmail.comwrote:

Hi!
if anybody have been used groupby query in elastic search.Please
reply me.

                                                  Your Thankfully

                                                Sandeep Kumar Tiwari

(Lukáš Vlček) #4

Hi,

can you give some example of the output you want to get from the search
engine?

Regards,
Lukas

On Wed, Jun 22, 2011 at 11:13 AM, sandeep tiwari sandeep15mca@gmail.comwrote:

Sir!
I want to know how use group by date in my elastic search query.

On Wed, Jun 22, 2011 at 2:39 PM, Lukáš Vlček lukas.vlcek@gmail.comwrote:

Hi,

can you be more specific? May be you want to look at parent/child feature.

Regards,
Lukas

On Wed, Jun 22, 2011 at 10:39 AM, sandeep tiwari sandeep15mca@gmail.comwrote:

Hi!
if anybody have been used groupby query in elastic search.Please
reply me.

                                                  Your Thankfully

                                                Sandeep Kumar Tiwari

(sandeep15mca) #5

Sir!
Result should be date wise search of group.
example-
22/06/2011

positive-1000
Negative-500
Neutral-200
23/06/2011

positive-1000
Negative-500
Neutral-200
etc........
please help me sir!
thanks!

On Wed, Jun 22, 2011 at 3:02 PM, Lukáš Vlček lukas.vlcek@gmail.com wrote:

Hi,

can you give some example of the output you want to get from the search
engine?

Regards,
Lukas

On Wed, Jun 22, 2011 at 11:13 AM, sandeep tiwari sandeep15mca@gmail.comwrote:

Sir!
I want to know how use group by date in my elastic search query.

On Wed, Jun 22, 2011 at 2:39 PM, Lukáš Vlček lukas.vlcek@gmail.comwrote:

Hi,

can you be more specific? May be you want to look at parent/child
feature.

Regards,
Lukas

On Wed, Jun 22, 2011 at 10:39 AM, sandeep tiwari <sandeep15mca@gmail.com

wrote:

Hi!
if anybody have been used groupby query in elastic search.Please
reply me.

                                                    Your Thankfully

                                                  Sandeep Kumar Tiwari

(IvanBrusic) #6

In SQL, GROUP BY allows you to use aggregate functions on your date
such as count (in your example), max, min, etc... In ElasticSearch,
facets allow you to do similar aggregations.

http://www.elasticsearch.org/guide/reference/api/search/facets/

Is your example the output of a query? If polarity_count is the term
to group by, you can use it as a facet, and use facet filters for each
of the cases (positive, negative, neutral).

Cheers,

Ivan

On Jun 22, 8:42 am, sandeep tiwari sandeep15...@gmail.com wrote:

Sir!
Result should be date wise search of group.
example-
22/06/2011

positive-1000
Negative-500
Neutral-200
23/06/2011

positive-1000
Negative-500
Neutral-200
etc........
please help me sir!
thanks!

On Wed, Jun 22, 2011 at 3:02 PM, Lukáš Vlček lukas.vl...@gmail.com wrote:

Hi,

can you give some example of the output you want to get from the search
engine?

Regards,
Lukas

On Wed, Jun 22, 2011 at 11:13 AM, sandeep tiwari sandeep15...@gmail.comwrote:

Sir!
I want to know how use group by date in my elastic search query.

On Wed, Jun 22, 2011 at 2:39 PM, Lukáš Vlček lukas.vl...@gmail.comwrote:

Hi,

can you be more specific? May be you want to look at parent/child
feature.

Regards,
Lukas

On Wed, Jun 22, 2011 at 10:39 AM, sandeep tiwari <sandeep15...@gmail.com

wrote:

Hi!
if anybody have been used groupby query in elastic search.Please
reply me.

                                                    Your Thankfully
                                                  Sandeep Kumar Tiwari

(sandeep15mca) #7

Sir!
please give me one example.
thanks!

On Wed, Jun 22, 2011 at 11:39 PM, Ivan Brusic ivan_brusic@yahoo.com wrote:

In SQL, GROUP BY allows you to use aggregate functions on your date
such as count (in your example), max, min, etc... In ElasticSearch,
facets allow you to do similar aggregations.

http://www.elasticsearch.org/guide/reference/api/search/facets/

Is your example the output of a query? If polarity_count is the term
to group by, you can use it as a facet, and use facet filters for each
of the cases (positive, negative, neutral).

Cheers,

Ivan

On Jun 22, 8:42 am, sandeep tiwari sandeep15...@gmail.com wrote:

Sir!
Result should be date wise search of group.
example-
22/06/2011

positive-1000
Negative-500
Neutral-200
23/06/2011

positive-1000
Negative-500
Neutral-200
etc........
please help me sir!
thanks!

On Wed, Jun 22, 2011 at 3:02 PM, Lukáš Vlček lukas.vl...@gmail.com
wrote:

Hi,

can you give some example of the output you want to get from the search
engine?

Regards,
Lukas

On Wed, Jun 22, 2011 at 11:13 AM, sandeep tiwari <
sandeep15...@gmail.com>wrote:

Sir!
I want to know how use group by date in my elastic search
query.

On Wed, Jun 22, 2011 at 2:39 PM, Lukáš Vlček <lukas.vl...@gmail.com
wrote:

Hi,

can you be more specific? May be you want to look at parent/child
feature.

Regards,
Lukas

On Wed, Jun 22, 2011 at 10:39 AM, sandeep tiwari <
sandeep15...@gmail.com

wrote:

Hi!
if anybody have been used groupby query in elastic
search.Please

reply me.

                                                    Your

Thankfully

                                                  Sandeep Kumar

Tiwari


(Clinton Gormley) #8

On Thu, 2011-06-23 at 10:25 +0530, sandeep tiwari wrote:

Sir!
please give me one example.
thanks!

Sandeep, Ivan has provided you with a link to the documents about
facets, which include examples.

I suggest that you read the examples, plus as much of the docs as you
need to to understand the basics of ElasticSearch, try out the examples,
and if you're still having problems, come back with: "I tried XYZ, and
I'm seeing error FOO. What am I doing wrong?".

That way we will be more able to help you.

Also, see http://www.elasticsearch.org/help

clint

On Wed, Jun 22, 2011 at 11:39 PM, Ivan Brusic ivan_brusic@yahoo.com
wrote:
In SQL, GROUP BY allows you to use aggregate functions on your
date
such as count (in your example), max, min, etc... In
ElasticSearch,
facets allow you to do similar aggregations.

    http://www.elasticsearch.org/guide/reference/api/search/facets/
    
    Is your example the output of a query?  If polarity_count is
    the term
    to group by, you can use it as a facet, and use facet filters
    for each
    of the cases (positive, negative, neutral).
    
    Cheers,
    
    Ivan
    
    On Jun 22, 8:42 am, sandeep tiwari <sandeep15...@gmail.com>
    wrote:
    > Sir!
    >      Result should be date wise search of group.
    >   example-
    >                 22/06/2011
    >                  <polarity count>
    >                               positive-1000
    >                               Negative-500
    >                               Neutral-200
    >              23/06/2011
    >             <polarity count>
    >                               positive-1000
    >                               Negative-500
    >                               Neutral-200
    > etc........
    > please help me sir!
    >                                                     thanks!
    >
    >
    >
    >
    >
    >
    >
    
    > On Wed, Jun 22, 2011 at 3:02 PM, Lukáš Vlček
    <lukas.vl...@gmail.com> wrote:
    > > Hi,
    >
    > > can you give some example of the output you want to get
    from the search
    > > engine?
    >
    > > Regards,
    > > Lukas
    >
    
    > > On Wed, Jun 22, 2011 at 11:13 AM, sandeep tiwari
    <sandeep15...@gmail.com>wrote:
    >
    > >> Sir!
    > >>        I want to know how use group by date in my elastic
    search query.
    >
    
    > >> On Wed, Jun 22, 2011 at 2:39 PM, Lukáš Vlček
    <lukas.vl...@gmail.com>wrote:
    >
    > >>> Hi,
    >
    > >>> can you be more specific? May be you want to look at
    parent/child
    > >>> feature.
    >
    > >>> Regards,
    > >>> Lukas
    >
    
    > >>> On Wed, Jun 22, 2011 at 10:39 AM, sandeep tiwari
    <sandeep15...@gmail.com
    
    > >>> > wrote:
    >
    > >>>> Hi!
    > >>>>      if anybody have been used groupby query in elastic
    search.Please
    > >>>> reply me.
    >
    > >>>>
    Your Thankfully
    >
    > >>>>
    Sandeep Kumar Tiwari

(sandeep15mca) #9

*Sir!
*
*
*
*
*
*I wnat to execute *{

"query": {"match_all":{} },
"filter" : {
"bool" : {
"must" : {"range" : {
"file_size" :
{ "from" : 10, "to" : 10000 }}},
"must" : {"range" : {
"file_size" :
{ "from" : 10001, "to" : 1000000 }
}}}
}
} 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 *
*
* thanks!
*
*

On Thu, Jun 23, 2011 at 2:07 PM, Clinton Gormley clinton@iannounce.co.ukwrote:

On Thu, 2011-06-23 at 10:25 +0530, sandeep tiwari wrote:

Sir!
please give me one example.
thanks!

Sandeep, Ivan has provided you with a link to the documents about
facets, which include examples.

I suggest that you read the examples, plus as much of the docs as you
need to to understand the basics of ElasticSearch, try out the examples,
and if you're still having problems, come back with: "I tried XYZ, and
I'm seeing error FOO. What am I doing wrong?".

That way we will be more able to help you.

Also, see http://www.elasticsearch.org/help

clint

On Wed, Jun 22, 2011 at 11:39 PM, Ivan Brusic ivan_brusic@yahoo.com
wrote:
In SQL, GROUP BY allows you to use aggregate functions on your
date
such as count (in your example), max, min, etc... In
ElasticSearch,
facets allow you to do similar aggregations.

    http://www.elasticsearch.org/guide/reference/api/search/facets/

    Is your example the output of a query?  If polarity_count is
    the term
    to group by, you can use it as a facet, and use facet filters
    for each
    of the cases (positive, negative, neutral).

    Cheers,

    Ivan

    On Jun 22, 8:42 am, sandeep tiwari <sandeep15...@gmail.com>
    wrote:
    > Sir!
    >      Result should be date wise search of group.
    >   example-
    >                 22/06/2011
    >                  <polarity count>
    >                               positive-1000
    >                               Negative-500
    >                               Neutral-200
    >              23/06/2011
    >             <polarity count>
    >                               positive-1000
    >                               Negative-500
    >                               Neutral-200
    > etc........
    > please help me sir!
    >                                                     thanks!
    >
    >
    >
    >
    >
    >
    >

    > On Wed, Jun 22, 2011 at 3:02 PM, Lukáš Vlček
    <lukas.vl...@gmail.com> wrote:
    > > Hi,
    >
    > > can you give some example of the output you want to get
    from the search
    > > engine?
    >
    > > Regards,
    > > Lukas
    >

    > > On Wed, Jun 22, 2011 at 11:13 AM, sandeep tiwari
    <sandeep15...@gmail.com>wrote:
    >
    > >> Sir!
    > >>        I want to know how use group by date in my elastic
    search query.
    >

    > >> On Wed, Jun 22, 2011 at 2:39 PM, Lukáš Vlček
    <lukas.vl...@gmail.com>wrote:
    >
    > >>> Hi,
    >
    > >>> can you be more specific? May be you want to look at
    parent/child
    > >>> feature.
    >
    > >>> Regards,
    > >>> Lukas
    >

    > >>> On Wed, Jun 22, 2011 at 10:39 AM, sandeep tiwari
    <sandeep15...@gmail.com

    > >>> > wrote:
    >
    > >>>> Hi!
    > >>>>      if anybody have been used groupby query in elastic
    search.Please
    > >>>> reply me.
    >
    > >>>>
    Your Thankfully
    >
    > >>>>
    Sandeep Kumar Tiwari

(sandeep15mca) #10

*Sir!
*
*
*
*
*
*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 *
*
* thanks!

  • Show quoted text -

On Thu, Jun 23, 2011 at 6:51 PM, sandeep tiwari sandeep15mca@gmail.comwrote:

*Sir!
*
*
*
*
*
*I wnat to execute *{

"query": {"match_all":{} },
"filter" : {
"bool" : {
"must" : {"range" : {
"file_size" :
{ "from" : 10, "to" : 10000 }}},
"must" : {"range" : {
"file_size" :
{ "from" : 10001, "to" : 1000000 }
}}}
}
} 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 *
*
* thanks!
*
*

On Thu, Jun 23, 2011 at 2:07 PM, Clinton Gormley clinton@iannounce.co.ukwrote:

On Thu, 2011-06-23 at 10:25 +0530, sandeep tiwari wrote:

Sir!
please give me one example.
thanks!

Sandeep, Ivan has provided you with a link to the documents about
facets, which include examples.

I suggest that you read the examples, plus as much of the docs as you
need to to understand the basics of ElasticSearch, try out the examples,
and if you're still having problems, come back with: "I tried XYZ, and
I'm seeing error FOO. What am I doing wrong?".

That way we will be more able to help you.

Also, see http://www.elasticsearch.org/help

clint

On Wed, Jun 22, 2011 at 11:39 PM, Ivan Brusic ivan_brusic@yahoo.com
wrote:
In SQL, GROUP BY allows you to use aggregate functions on your
date
such as count (in your example), max, min, etc... In
ElasticSearch,
facets allow you to do similar aggregations.

    http://www.elasticsearch.org/guide/reference/api/search/facets/

    Is your example the output of a query?  If polarity_count is
    the term
    to group by, you can use it as a facet, and use facet filters
    for each
    of the cases (positive, negative, neutral).

    Cheers,

    Ivan

    On Jun 22, 8:42 am, sandeep tiwari <sandeep15...@gmail.com>
    wrote:
    > Sir!
    >      Result should be date wise search of group.
    >   example-
    >                 22/06/2011
    >                  <polarity count>
    >                               positive-1000
    >                               Negative-500
    >                               Neutral-200
    >              23/06/2011
    >             <polarity count>
    >                               positive-1000
    >                               Negative-500
    >                               Neutral-200
    > etc........
    > please help me sir!
    >                                                     thanks!
    >
    >
    >
    >
    >
    >
    >

    > On Wed, Jun 22, 2011 at 3:02 PM, Lukáš Vlček
    <lukas.vl...@gmail.com> wrote:
    > > Hi,
    >
    > > can you give some example of the output you want to get
    from the search
    > > engine?
    >
    > > Regards,
    > > Lukas
    >

    > > On Wed, Jun 22, 2011 at 11:13 AM, sandeep tiwari
    <sandeep15...@gmail.com>wrote:
    >
    > >> Sir!
    > >>        I want to know how use group by date in my elastic
    search query.
    >

    > >> On Wed, Jun 22, 2011 at 2:39 PM, Lukáš Vlček
    <lukas.vl...@gmail.com>wrote:
    >
    > >>> Hi,
    >
    > >>> can you be more specific? May be you want to look at
    parent/child
    > >>> feature.
    >
    > >>> Regards,
    > >>> Lukas
    >

    > >>> On Wed, Jun 22, 2011 at 10:39 AM, sandeep tiwari
    <sandeep15...@gmail.com

    > >>> > wrote:
    >
    > >>>> Hi!
    > >>>>      if anybody have been used groupby query in elastic
    search.Please
    > >>>> reply me.
    >
    > >>>>
    Your Thankfully
    >
    > >>>>
    Sandeep Kumar Tiwari

(Clinton Gormley) #11

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


(sandeep15mca) #12

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.ukwrote:

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


(Clinton Gormley) #13

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' -d '
{
"query" : {
"constant_score" : {
"filter" : {
"range" : {
"date" : {
"lte" : "2011-10-01",
"gte" : "2011-09-02"
}
}
}
}
}
}
'

clint


(sandeep15mca) #14

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.ukwrote:

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' -d '
{
"query" : {
"constant_score" : {
"filter" : {
"range" : {
"date" : {
"lte" : "2011-10-01",
"gte" : "2011-09-02"
}
}
}
}
}
}
'

clint


(Clinton Gormley) #15

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/

clint


(sandeep15mca) #16

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' -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.ukwrote:

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/

clint


(Clinton Gormley) #17

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:

http://www.elasticsearch.org/guide/reference/query-dsl/and-filter.html
http://www.elasticsearch.org/guide/reference/query-dsl/or-filter.html
http://www.elasticsearch.org/guide/reference/query-dsl/not-filter.html

clint


(sandeep15mca) #18

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.ukwrote:

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:

http://www.elasticsearch.org/guide/reference/query-dsl/and-filter.html
http://www.elasticsearch.org/guide/reference/query-dsl/or-filter.html
http://www.elasticsearch.org/guide/reference/query-dsl/not-filter.html

clint


(Clinton Gormley) #19

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.

http://www.elasticsearch.org/guide/reference/query-dsl/and-filter.html
http://www.elasticsearch.org/guide/reference/query-dsl/or-filter.html
http://www.elasticsearch.org/guide/reference/query-dsl/not-filter.html

clint


(sandeep15mca) #20

On Fri, Jun 24, 2011 at 4:30 PM, Clinton Gormley clinton@iannounce.co.ukwrote:

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.

http://www.elasticsearch.org/guide/reference/query-dsl/and-filter.html
http://www.elasticsearch.org/guide/reference/query-dsl/or-filter.html
http://www.elasticsearch.org/guide/reference/query-dsl/not-filter.html

Sir!
I try to open docs on 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' -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