.
> > To view this discussion on the web visit
> > [https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm_medium=email&utm_source=footer)
> > .
> >
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
>
> --
> Met vriendelijke groet,
>
> Martijn van Groningen
--
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](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/26418ee0-0bc5-4719-b8db-d193019ef67f%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/26418ee0-0bc5-4719-b8db-d193019ef67f%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@JGL](https://discuss.elastic.co/u/JGL)
#### Post date: [May 5, 2014, 11:53pm UTC](https://discuss.elastic.co/t/help-with-es-1-x-percolator-query-plz/17312/5 "2014-05-05T23:53:32Z")
Can anybody help plz?
On Monday, May 5, 2014 10:24:09 AM UTC+12, JGL wrote:
> Hi Martjin,
>
> The percolator query in the 1st post above is what we registered to the
> percolator and kinda working, which consolidate all IDs in one query string
> for a match query, which seems not quite a elegant solution to us.
>
> {
> "\_index" : "my\_idx",
> "\_type" : ".percolator",
> "\_id" : "my\_query\_id",
> "\_score" : 1.0,
> "\_source" : {
> "query":{
> "match":{
> "id":{
> "query":"id1 id2 id3",
> "type":"boolean"
> }
> }
> }
> }
> }
>
> Another issue is that the above solution is not quite accurate when the
> IDs are UUIDs. For example, if the query we register is as the following
>
> {
> "\_index" : "my\_idx",
> "\_type" : ".percolator",
> "\_id" : "my\_query\_id",
> "\_score" : 1.0,
> "\_source" : {
> "query":{
> "match":{
> "id":{
> "query":"1aa808dc-48f0-4de3-8978-_a0293d54b852_ 6b256fd1-cd04-4e3c-8f38-aaa87ac2220d 1234fd1a-cd04-4e3c-8f38-aaa87142380d",
> "type":"boolean"
> }
> }
> }
> }
> }
>
> , the percolator return the above query as a match if the document we try
> to percolate is "{"doc" : {"id":"1aa808dc-48f0-4de3-8978-_00293d54b852_"}}",
> though we are expecting a no match response here as the id in the document
> does not have a matched ID in the query String.
>
> Such false positive response, according to the experimentations we had,
> happens when the doc UUID is almost the same to one of the IDs in the query
> except the the last part of ID. Wondering if there is an explanation for
> such behavior of elasticsearch?
>
> Our another question is if there is any way we could put the UUID list as
> a list into a query that is working with the percolator, like what we can
> do for inQuery or inFilter. We tried register an inQuery or a query
> wrapping an inFilter. Non of them can work with the percolator, seems the
> percolator only works with the MatchQuery, in which we cannot put the UUID
> list as a list.
>
> For example the following two queries we tried are not working with
> percolator:
>
> {
> "\_index" : "my\_idx",
> "\_type" : ".percolator",
> "\_id" : "inQuery",
> "\_score" : 1.0, "\_source" : {"query":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d54b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}
> },
>
> {
> "\_index" : "my\_idx",
> "\_type" : ".percolator",
> "\_id" : "inFilterQ",
> "\_score" : 1.0, "\_source" : {"query":{"filtered":{"query":{"match\_all":{}},"filter":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d50b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}}}
> },
>
> Thanks for your help!
>
> Jason
>
> On Friday, May 2, 2014 7:34:47 PM UTC+12, Martijn v Groningen wrote:
>
> > Hi,
> >
> > Can you share the stored percolator queries and the percolate request
> > that you were initially trying with, but didn't work?\
> >
> > Martijn
> >
> > On 2 May 2014 11:14, JGL [j.g.l...@gmail.com](mailto:j.g.l...@gmail.com) wrote:
> >
> > > Can anybody help plz?
> > >
> > > --
> > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com).
> > > To view this discussion on the web visit
> > > [https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm_medium=email&utm_source=footer)
> > > .
> > >
> > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> >
> > --
> > Met vriendelijke groet,
> >
> > Martijn van Groningen
--
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](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/554c6588-68ed-4379-81c2-0847e5e8b62e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/554c6588-68ed-4379-81c2-0847e5e8b62e%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@JGL](https://discuss.elastic.co/u/JGL)
#### Post date: [May 7, 2014, 6:29am UTC](https://discuss.elastic.co/t/help-with-es-1-x-percolator-query-plz/17312/6 "2014-05-07T06:29:35Z")
Can anybody help plz?
On Tuesday, May 6, 2014 11:53:32 AM UTC+12, JGL wrote:
> Can anybody help plz?
>
> On Monday, May 5, 2014 10:24:09 AM UTC+12, JGL wrote:
>
> > Hi Martjin,
> >
> > The percolator query in the 1st post above is what we registered to the
> > percolator and kinda working, which consolidate all IDs in one query string
> > for a match query, which seems not quite a elegant solution to us.
> >
> > {
> > "\_index" : "my\_idx",
> > "\_type" : ".percolator",
> > "\_id" : "my\_query\_id",
> > "\_score" : 1.0,
> > "\_source" : {
> > "query":{
> > "match":{
> > "id":{
> > "query":"id1 id2 id3",
> > "type":"boolean"
> > }
> > }
> > }
> > }
> > }
> >
> > Another issue is that the above solution is not quite accurate when the
> > IDs are UUIDs. For example, if the query we register is as the following
> >
> > {
> > "\_index" : "my\_idx",
> > "\_type" : ".percolator",
> > "\_id" : "my\_query\_id",
> > "\_score" : 1.0,
> > "\_source" : {
> > "query":{
> > "match":{
> > "id":{
> > "query":"1aa808dc-48f0-4de3-8978-_a0293d54b852_ 6b256fd1-cd04-4e3c-8f38-aaa87ac2220d 1234fd1a-cd04-4e3c-8f38-aaa87142380d",
> > "type":"boolean"
> > }
> > }
> > }
> > }
> > }
> >
> > , the percolator return the above query as a match if the document we try
> > to percolate is "{"doc" : {"id":"1aa808dc-48f0-4de3-8978-_00293d54b852_"}}",
> > though we are expecting a no match response here as the id in the document
> > does not have a matched ID in the query String.
> >
> > Such false positive response, according to the experimentations we had,
> > happens when the doc UUID is almost the same to one of the IDs in the query
> > except the the last part of ID. Wondering if there is an explanation for
> > such behavior of elasticsearch?
> >
> > Our another question is if there is any way we could put the UUID list as
> > a list into a query that is working with the percolator, like what we can
> > do for inQuery or inFilter. We tried register an inQuery or a query
> > wrapping an inFilter. Non of them can work with the percolator, seems the
> > percolator only works with the MatchQuery, in which we cannot put the UUID
> > list as a list.
> >
> > For example the following two queries we tried are not working with
> > percolator:
> >
> > {
> > "\_index" : "my\_idx",
> > "\_type" : ".percolator",
> > "\_id" : "inQuery",
> > "\_score" : 1.0, "\_source" : {"query":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d54b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}
> > },
> >
> > {
> > "\_index" : "my\_idx",
> > "\_type" : ".percolator",
> > "\_id" : "inFilterQ",
> > "\_score" : 1.0, "\_source" : {"query":{"filtered":{"query":{"match\_all":{}},"filter":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d50b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}}}
> > },
> >
> > Thanks for your help!
> >
> > Jason
> >
> > On Friday, May 2, 2014 7:34:47 PM UTC+12, Martijn v Groningen wrote:
> >
> > > Hi,
> > >
> > > Can you share the stored percolator queries and the percolate request
> > > that you were initially trying with, but didn't work?\
> > >
> > > Martijn
> > >
> > > On 2 May 2014 11:14, JGL [j.g.l...@gmail.com](mailto:j.g.l...@gmail.com) wrote:
> > >
> > > > Can anybody help plz?
> > > >
> > > > --
> > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com).
> > > > To view this discussion on the web visit
> > > > [https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm_medium=email&utm_source=footer)
> > > > .
> > > >
> > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > >
> > > --
> > > Met vriendelijke groet,
> > >
> > > Martijn van Groningen
--
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](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/0c0e5bf8-8790-48f3-9ce3-16b3764057b0%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/0c0e5bf8-8790-48f3-9ce3-16b3764057b0%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@JGL](https://discuss.elastic.co/u/JGL)
#### Post date: [May 9, 2014, 2:20am UTC](https://discuss.elastic.co/t/help-with-es-1-x-percolator-query-plz/17312/7 "2014-05-09T02:20:05Z")
Can anybody help plz?
On Wednesday, May 7, 2014 6:29:35 PM UTC+12, JGL wrote:
> Can anybody help plz?
>
> On Tuesday, May 6, 2014 11:53:32 AM UTC+12, JGL wrote:
>
> > Can anybody help plz?
> >
> > On Monday, May 5, 2014 10:24:09 AM UTC+12, JGL wrote:
> >
> > > Hi Martjin,
> > >
> > > The percolator query in the 1st post above is what we registered to the
> > > percolator and kinda working, which consolidate all IDs in one query string
> > > for a match query, which seems not quite a elegant solution to us.
> > >
> > > {
> > > "\_index" : "my\_idx",
> > > "\_type" : ".percolator",
> > > "\_id" : "my\_query\_id",
> > > "\_score" : 1.0,
> > > "\_source" : {
> > > "query":{
> > > "match":{
> > > "id":{
> > > "query":"id1 id2 id3",
> > > "type":"boolean"
> > > }
> > > }
> > > }
> > > }
> > > }
> > >
> > > Another issue is that the above solution is not quite accurate when the
> > > IDs are UUIDs. For example, if the query we register is as the following
> > >
> > > {
> > > "\_index" : "my\_idx",
> > > "\_type" : ".percolator",
> > > "\_id" : "my\_query\_id",
> > > "\_score" : 1.0,
> > > "\_source" : {
> > > "query":{
> > > "match":{
> > > "id":{
> > > "query":"1aa808dc-48f0-4de3-8978-_a0293d54b852_ 6b256fd1-cd04-4e3c-8f38-aaa87ac2220d 1234fd1a-cd04-4e3c-8f38-aaa87142380d",
> > > "type":"boolean"
> > > }
> > > }
> > > }
> > > }
> > > }
> > >
> > > , the percolator return the above query as a match if the document we
> > > try to percolate is "{"doc" : {"id":"1aa808dc-48f0-4de3-8978-
> > > _00293d54b852_"}}", though we are expecting a no match response here as
> > > the id in the document does not have a matched ID in the query String.
> > >
> > > Such false positive response, according to the experimentations we had,
> > > happens when the doc UUID is almost the same to one of the IDs in the query
> > > except the the last part of ID. Wondering if there is an explanation for
> > > such behavior of elasticsearch?
> > >
> > > Our another question is if there is any way we could put the UUID list
> > > as a list into a query that is working with the percolator, like what we
> > > can do for inQuery or inFilter. We tried register an inQuery or a query
> > > wrapping an inFilter. Non of them can work with the percolator, seems the
> > > percolator only works with the MatchQuery, in which we cannot put the UUID
> > > list as a list.
> > >
> > > For example the following two queries we tried are not working with
> > > percolator:
> > >
> > > {
> > > "\_index" : "my\_idx",
> > > "\_type" : ".percolator",
> > > "\_id" : "inQuery",
> > > "\_score" : 1.0, "\_source" : {"query":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d54b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}
> > > },
> > >
> > > {
> > > "\_index" : "my\_idx",
> > > "\_type" : ".percolator",
> > > "\_id" : "inFilterQ",
> > > "\_score" : 1.0, "\_source" : {"query":{"filtered":{"query":{"match\_all":{}},"filter":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d50b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}}}
> > > },
> > >
> > > Thanks for your help!
> > >
> > > Jason
> > >
> > > On Friday, May 2, 2014 7:34:47 PM UTC+12, Martijn v Groningen wrote:
> > >
> > > > Hi,
> > > >
> > > > Can you share the stored percolator queries and the percolate request
> > > > that you were initially trying with, but didn't work?\
> > > >
> > > > Martijn
> > > >
> > > > On 2 May 2014 11:14, JGL [j.g.l...@gmail.com](mailto:j.g.l...@gmail.com) wrote:
> > > >
> > > > > Can anybody help plz?
> > > > >
> > > > > --
> > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com).
> > > > > To view this discussion on the web visit
> > > > > [https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm_medium=email&utm_source=footer)
> > > > > .
> > > > >
> > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > >
> > > > --
> > > > Met vriendelijke groet,
> > > >
> > > > Martijn van Groningen
--
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](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/355c1323-5b58-4ff1-9854-56740ac2ec34%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/355c1323-5b58-4ff1-9854-56740ac2ec34%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@mvg](https://discuss.elastic.co/u/mvg)
#### Post date: [May 9, 2014, 10:04am UTC](https://discuss.elastic.co/t/help-with-es-1-x-percolator-query-plz/17312/8 "2014-05-09T10:04:51Z")
I think the issue here is that the 'id' field is analyzed and your UUIDS
are broken up into separate tokens. The standard analyzer is responsible
for breaking up by '-'. If you use the analyze api you can see what happens
with your uuids:
curl -XGET
'localhost:9200/\_analyze?text=1aa808dc-48f0-4de3-8978-a0293d54b852
6b256fd1-cd04-4e3c-8f38-aaa87ac2220d
1234fd1a-cd04-4e3c-8f38-aaa87142380d&tokenizer=standard'
The 'id' field in ES is not used as the id field. In ES the \_id field is
used to store the unique identifier and that field is not analyzed.
Assuming that the 'id' field has the same value as the id of a document
then you can use the `ids` query instead in your percolator queries:
> **[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.
Martijn
On 9 May 2014 09:20, JGL [j.g.liu.mu@gmail.com](mailto:j.g.liu.mu@gmail.com) wrote:
> Can anybody help plz?
>
> On Wednesday, May 7, 2014 6:29:35 PM UTC+12, JGL wrote:
>
> > Can anybody help plz?
> >
> > On Tuesday, May 6, 2014 11:53:32 AM UTC+12, JGL wrote:
> >
> > > Can anybody help plz?
> > >
> > > On Monday, May 5, 2014 10:24:09 AM UTC+12, JGL wrote:
> > >
> > > > Hi Martjin,
> > > >
> > > > The percolator query in the 1st post above is what we registered to the
> > > > percolator and kinda working, which consolidate all IDs in one query string
> > > > for a match query, which seems not quite a elegant solution to us.
> > > >
> > > > {
> > > > "\_index" : "my\_idx",
> > > > "\_type" : ".percolator",
> > > > "\_id" : "my\_query\_id",
> > > > "\_score" : 1.0,
> > > > "\_source" : {
> > > > "query":{
> > > > "match":{
> > > > "id":{
> > > > "query":"id1 id2 id3",
> > > >
> > > > ```
> > > > "type":"boolean"
> > > > }
> > > > }
> > > > }
> > > > }
> > > >
> > > > ```
> > > >
> > > > }
> > > >
> > > > Another issue is that the above solution is not quite accurate when the
> > > > IDs are UUIDs. For example, if the query we register is as the following
> > > >
> > > > {
> > > > "\_index" : "my\_idx",
> > > > "\_type" : ".percolator",
> > > > "\_id" : "my\_query\_id",
> > > > "\_score" : 1.0,
> > > > "\_source" : {
> > > > "query":{
> > > > "match":{
> > > > "id":{
> > > > "query":"1aa808dc-48f0-4de3-8978-_a0293d54b852_ 6b256fd1-cd04-4e3c-8f38-aaa87ac2220d 1234fd1a-cd04-4e3c-8f38-aaa87142380d",
> > > >
> > > > ```
> > > > "type":"boolean"
> > > > }
> > > > }
> > > > }
> > > > }
> > > >
> > > > ```
> > > >
> > > > }
> > > >
> > > > , the percolator return the above query as a match if the document we
> > > > try to percolate is "{"doc" : {"id":"1aa808dc-48f0-4de3-8978-
> > > > _00293d54b852_"}}", though we are expecting a no match response here
> > > > as the id in the document does not have a matched ID in the query String.
> > > >
> > > > Such false positive response, according to the experimentations we had,
> > > > happens when the doc UUID is almost the same to one of the IDs in the query
> > > > except the the last part of ID. Wondering if there is an explanation for
> > > > such behavior of elasticsearch?
> > > >
> > > > Our another question is if there is any way we could put the UUID list
> > > > as a list into a query that is working with the percolator, like what we
> > > > can do for inQuery or inFilter. We tried register an inQuery or a query
> > > > wrapping an inFilter. Non of them can work with the percolator, seems the
> > > > percolator only works with the MatchQuery, in which we cannot put the UUID
> > > > list as a list.
> > > >
> > > > For example the following two queries we tried are not working with
> > > > percolator:
> > > >
> > > > {
> > > > "\_index" : "my\_idx",
> > > > "\_type" : ".percolator",
> > > > "\_id" : "inQuery",
> > > > "\_score" : 1.0, "\_source" : {"query":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d54b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}
> > > > },
> > > >
> > > > {
> > > > "\_index" : "my\_idx",
> > > > "\_type" : ".percolator",
> > > > "\_id" : "inFilterQ",
> > > > "\_score" : 1.0, "\_source" : {"query":{"filtered":{"query":{"match\_all":{}},"filter":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d50b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}}}
> > > > },
> > > >
> > > > Thanks for your help!
> > > >
> > > > Jason
> > > >
> > > > On Friday, May 2, 2014 7:34:47 PM UTC+12, Martijn v Groningen wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > Can you share the stored percolator queries and the percolate request
> > > > > that you were initially trying with, but didn't work?\
> > > > >
> > > > > Martijn
> > > > >
> > > > > On 2 May 2014 11:14, JGL [j.g.l...@gmail.com](mailto:j.g.l...@gmail.com) wrote:
> > > > >
> > > > > > Can anybody help plz?
> > > > > >
> > > > > > --
> > > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com).
> > > > > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/)
> > > > > > msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%
> > > > > > [40googlegroups.com](http://40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm_medium=email&utm_source=footer)
> > > > > > .
> > > > > >
> > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > >
> > > > > --
> > > > > Met vriendelijke groet,
> > > > >
> > > > > Martijn van Groningen
--
Met vriendelijke groet,
Martijn van Groningen
--
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](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CA%2BA76TzpG8bjBQ68Wy1cgneHta%3DLrxh-DWKtC3AFqfRxxLksHA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CA%2BA76TzpG8bjBQ68Wy1cgneHta%3DLrxh-DWKtC3AFqfRxxLksHA%40mail.gmail.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@JGL](https://discuss.elastic.co/u/JGL)
#### Post date: [May 15, 2014, 11:09pm UTC](https://discuss.elastic.co/t/help-with-es-1-x-percolator-query-plz/17312/9 "2014-05-15T23:09:17Z")
Hi Martijin,
Thanks for the reply. The analyzer breaking up the UUID explains a lot why
the UUIDs are not matched as a whole.
I am still wondering if we can register other types of queries other than
match query into percolator. We would like to put a list of values into a
query for the "id" field, which is meant as a device ID, so that when we
percolate a document with a device ID, all percolator queries whose ID list
contains the device ID can be considered as a match.
But according to our experimentation, queries like the following are not
working with percolator, which seems only happy with match queries:
{
"\_index" : "my\_idx",
"\_type" : ".percolator",
"\_id" : "inQuery",
"\_score" : 1.0, "\_source" : {"query":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d54b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}
},
{
"\_index" : "my\_idx",
"\_type" : ".percolator",
"\_id" : "inFilterQ",
"\_score" : 1.0, "\_source" : {"query":{"filtered":{"query":{"match\_all":{}},"filter":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d50b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}}}
},
I could not find any resources clearly state that percolator can only work
with match queries. Is it actually the case?
Thanks,
Jason
On Friday, May 9, 2014 10:04:51 PM UTC+12, Martijn v Groningen wrote:
> I think the issue here is that the 'id' field is analyzed and your UUIDS
> are broken up into separate tokens. The standard analyzer is responsible
> for breaking up by '-'. If you use the analyze api you can see what happens
> with your uuids:
> curl -XGET
> 'localhost:9200/\_analyze?text=1aa808dc-48f0-4de3-8978-a0293d54b852
> 6b256fd1-cd04-4e3c-8f38-aaa87ac2220d
> 1234fd1a-cd04-4e3c-8f38-aaa87142380d&tokenizer=standard'
>
> The 'id' field in ES is not used as the id field. In ES the \_id field is
> used to store the unique identifier and that field is not analyzed.
> Assuming that the 'id' field has the same value as the id of a document
> then you can use the `ids` query instead in your percolator queries:
>
> [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-ids-query.html#query-dsl-ids-query)
>
> Martijn
>
> On 9 May 2014 09:20, JGL \<[j.g.l...@gmail.com](mailto:j.g.l...@gmail.com) \\> wrote:
>
> > Can anybody help plz?
> >
> > On Wednesday, May 7, 2014 6:29:35 PM UTC+12, JGL wrote:
> >
> > > Can anybody help plz?
> > >
> > > On Tuesday, May 6, 2014 11:53:32 AM UTC+12, JGL wrote:
> > >
> > > > Can anybody help plz?
> > > >
> > > > On Monday, May 5, 2014 10:24:09 AM UTC+12, JGL wrote:
> > > >
> > > > > Hi Martjin,
> > > > >
> > > > > The percolator query in the 1st post above is what we registered to
> > > > > the percolator and kinda working, which consolidate all IDs in one query
> > > > > string for a match query, which seems not quite a elegant solution to us.
> > > > >
> > > > > {
> > > > > "\_index" : "my\_idx",
> > > > > "\_type" : ".percolator",
> > > > > "\_id" : "my\_query\_id",
> > > > > "\_score" : 1.0,
> > > > > "\_source" : {
> > > > > "query":{
> > > > > "match":{
> > > > > "id":{
> > > > > "query":"id1 id2 id3",
> > > > >
> > > > > ```
> > > > > "type":"boolean"
> > > > > }
> > > > > }
> > > > > }
> > > > > }
> > > > >
> > > > > ```
> > > > >
> > > > > }
> > > > >
> > > > > Another issue is that the above solution is not quite accurate when
> > > > > the IDs are UUIDs. For example, if the query we register is as the following
> > > > >
> > > > > {
> > > > > "\_index" : "my\_idx",
> > > > > "\_type" : ".percolator",
> > > > > "\_id" : "my\_query\_id",
> > > > > "\_score" : 1.0,
> > > > > "\_source" : {
> > > > > "query":{
> > > > > "match":{
> > > > > "id":{
> > > > > "query":"1aa808dc-48f0-4de3-8978-_a0293d54b852_ 6b256fd1-cd04-4e3c-8f38-aaa87ac2220d 1234fd1a-cd04-4e3c-8f38-aaa87142380d",
> > > > >
> > > > > ```
> > > > > "type":"boolean"
> > > > > }
> > > > > }
> > > > > }
> > > > > }
> > > > >
> > > > > ```
> > > > >
> > > > > }
> > > > >
> > > > > , the percolator return the above query as a match if the document we
> > > > > try to percolate is "{"doc" : {"id":"1aa808dc-48f0-4de3-8978-
> > > > > _00293d54b852_"}}", though we are expecting a no match response here
> > > > > as the id in the document does not have a matched ID in the query String.
> > > > >
> > > > > Such false positive response, according to the experimentations we
> > > > > had, happens when the doc UUID is almost the same to one of the IDs in the
> > > > > query except the the last part of ID. Wondering if there is an explanation
> > > > > for such behavior of elasticsearch?
> > > > >
> > > > > Our another question is if there is any way we could put the UUID list
> > > > > as a list into a query that is working with the percolator, like what we
> > > > > can do for inQuery or inFilter. We tried register an inQuery or a query
> > > > > wrapping an inFilter. Non of them can work with the percolator, seems the
> > > > > percolator only works with the MatchQuery, in which we cannot put the UUID
> > > > > list as a list.
> > > > >
> > > > > For example the following two queries we tried are not working with
> > > > > percolator:
> > > > >
> > > > > {
> > > > > "\_index" : "my\_idx",
> > > > > "\_type" : ".percolator",
> > > > > "\_id" : "inQuery",
> > > > > "\_score" : 1.0, "\_source" : {"query":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d54b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}
> > > > > },
> > > > >
> > > > > {
> > > > > "\_index" : "my\_idx",
> > > > > "\_type" : ".percolator",
> > > > > "\_id" : "inFilterQ",
> > > > > "\_score" : 1.0, "\_source" : {"query":{"filtered":{"query":{"match\_all":{}},"filter":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d50b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}}}
> > > > > },
> > > > >
> > > > > Thanks for your help!
> > > > >
> > > > > Jason
> > > > >
> > > > > On Friday, May 2, 2014 7:34:47 PM UTC+12, Martijn v Groningen wrote:
> > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Can you share the stored percolator queries and the percolate request
> > > > > > that you were initially trying with, but didn't work?\
> > > > > >
> > > > > > Martijn
> > > > > >
> > > > > > On 2 May 2014 11:14, JGL [j.g.l...@gmail.com](mailto:j.g.l...@gmail.com) wrote:
> > > > > >
> > > > > > > Can anybody help plz?
> > > > > > >
> > > > > > > --
> > > > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com).
> > > > > > > To view this discussion on the web visit
> > > > > > > [https://groups.google.com/d/msgid/elasticsearch/4ee60836-](https://groups.google.com/d/msgid/elasticsearch/4ee60836-)
> > > > > > > 1922-43e0-8d9b-64ef9bb0b00a%[40googlegroups.com](http://40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm_medium=email&utm_source=footer)
> > > > > > > .
> > > > > > >
> > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > > >
> > > > > > --
> > > > > > Met vriendelijke groet,
> > > > > >
> > > > > > Martijn van Groningen
>
> --
> Met vriendelijke groet,
>
> Martijn van Groningen
--
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](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/e4ae14dd-8ae5-43e1-85bb-2fe3d0a1a1ab%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/e4ae14dd-8ae5-43e1-85bb-2fe3d0a1a1ab%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@mvg](https://discuss.elastic.co/u/mvg)
#### Post date: [May 19, 2014, 12:31pm UTC](https://discuss.elastic.co/t/help-with-es-1-x-percolator-query-plz/17312/10 "2014-05-19T12:31:04Z")
The reason the that these percolator queries don't match, has nothing to do
with the percolator itself, but with text analysis. The default analyzer
for string fields just also breaks up the id by dash and the terms filter
and query require exact matches, which result in no matches. On the other
hand the match query is smart enough to check if a field is analyzed and
use the analyzer that is configured in the mapping, in that case the with
the match query the percolator query does match.
In your case if you want to make the terms filter/query match your document
being percolated you should do the following:
1)
curl -XPUT 'localhost:9200/my-index' -d '
{
"mappings": {
"my-type" : {
"properties": {
"id" : {
"type": "string",
"index": "not\_analyzed"
}
}
}
}
}'
1.
curl -XPUT 'localhost:9200/my-index/.percolator/1' -d '{
"query": {
"terms": {
"id": [
"1aa808dc-48f0-4de3-8978-a0293d54b852",
"6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"
]
}
},
"type" : "my-type"
}'
By specifying that the type is 'my-type', the percolator will tell query
parsing to use not analyze the id field values and just take the values as
is.
1.
curl -XGET 'localhost:9200/my-index/my-type/\_percolate' -d '{
"doc": {
"id": "1aa808dc-48f0-4de3-8978-a0293d54b852"
}
}'
On 16 May 2014 01:09, JGL [j.g.liu.mu@gmail.com](mailto:j.g.liu.mu@gmail.com) wrote:
> Hi Martijin,
>
> Thanks for the reply. The analyzer breaking up the UUID explains a lot why
> the UUIDs are not matched as a whole.
>
> I am still wondering if we can register other types of queries other than
> match query into percolator. We would like to put a list of values into a
> query for the "id" field, which is meant as a device ID, so that when we
> percolate a document with a device ID, all percolator queries whose ID list
> contains the device ID can be considered as a match.
>
> But according to our experimentation, queries like the following are not
> working with percolator, which seems only happy with match queries:
>
> {
> "\_index" : "my\_idx",
> "\_type" : ".percolator",
> "\_id" : "inQuery",
> "\_score" : 1.0, "\_source" : {"query":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d54b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}
> },
>
> {
> "\_index" : "my\_idx",
> "\_type" : ".percolator",
> "\_id" : "inFilterQ",
> "\_score" : 1.0, "\_source" : {"query":{"filtered":{"query":{"match\_all":{}},"filter":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d50b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}}}
> },
>
> I could not find any resources clearly state that percolator can only work
> with match queries. Is it actually the case?
>
> Thanks,
> Jason
>
> On Friday, May 9, 2014 10:04:51 PM UTC+12, Martijn v Groningen wrote:
>
> > I think the issue here is that the 'id' field is analyzed and your UUIDS
> > are broken up into separate tokens. The standard analyzer is responsible
> > for breaking up by '-'. If you use the analyze api you can see what happens
> > with your uuids:
> > curl -XGET 'localhost:9200/\_analyze?text=1aa808dc-48f0-4de3-8978-a0293d54b852
> > 6b256fd1-cd04-4e3c-8f38-aaa87ac2220d 1234fd1a-cd04-4e3c-8f38-
> > aaa87142380d&tokenizer=standard'
> >
> > The 'id' field in ES is not used as the id field. In ES the \_id field is
> > used to store the unique identifier and that field is not analyzed.
> > Assuming that the 'id' field has the same value as the id of a document
> > then you can use the `ids` query instead in your percolator queries:
> > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/)
> > reference/current/query-dsl-ids-query.html#query-dsl-ids-query
> >
> > Martijn
> >
> > On 9 May 2014 09:20, JGL [j.g.l...@gmail.com](mailto:j.g.l...@gmail.com) wrote:
> >
> > > Can anybody help plz?
> > >
> > > On Wednesday, May 7, 2014 6:29:35 PM UTC+12, JGL wrote:
> > >
> > > > Can anybody help plz?
> > > >
> > > > On Tuesday, May 6, 2014 11:53:32 AM UTC+12, JGL wrote:
> > > >
> > > > > Can anybody help plz?
> > > > >
> > > > > On Monday, May 5, 2014 10:24:09 AM UTC+12, JGL wrote:
> > > > >
> > > > > > Hi Martjin,
> > > > > >
> > > > > > The percolator query in the 1st post above is what we registered to
> > > > > > the percolator and kinda working, which consolidate all IDs in one query
> > > > > > string for a match query, which seems not quite a elegant solution to us.
> > > > > >
> > > > > > {
> > > > > > "\_index" : "my\_idx",
> > > > > > "\_type" : ".percolator",
> > > > > > "\_id" : "my\_query\_id",
> > > > > > "\_score" : 1.0,
> > > > > > "\_source" : {
> > > > > > "query":{
> > > > > > "match":{
> > > > > > "id":{
> > > > > > "query":"id1 id2 id3",
> > > > > >
> > > > > > ```
> > > > > > "type":"boolean"
> > > > > > }
> > > > > > }
> > > > > > }
> > > > > > }
> > > > > >
> > > > > > ```
> > > > > >
> > > > > > }
> > > > > >
> > > > > > Another issue is that the above solution is not quite accurate when
> > > > > > the IDs are UUIDs. For example, if the query we register is as the following
> > > > > >
> > > > > > {
> > > > > > "\_index" : "my\_idx",
> > > > > > "\_type" : ".percolator",
> > > > > > "\_id" : "my\_query\_id",
> > > > > > "\_score" : 1.0,
> > > > > > "\_source" : {
> > > > > > "query":{
> > > > > > "match":{
> > > > > > "id":{
> > > > > > "query":"1aa808dc-48f0-4de3-8978-_a0293d54b852_ 6b256fd1-cd04-4e3c-8f38-aaa87ac2220d 1234fd1a-cd04-4e3c-8f38-aaa87142380d",
> > > > > >
> > > > > > ```
> > > > > > "type":"boolean"
> > > > > > }
> > > > > > }
> > > > > > }
> > > > > > }
> > > > > >
> > > > > > ```
> > > > > >
> > > > > > }
> > > > > >
> > > > > > , the percolator return the above query as a match if the document we
> > > > > > try to percolate is "{"doc" : {"id":"1aa808dc-48f0-4de3-8978-
> > > > > > _00293d54b852_"}}", though we are expecting a no match response here
> > > > > > as the id in the document does not have a matched ID in the query String.
> > > > > >
> > > > > > Such false positive response, according to the experimentations we
> > > > > > had, happens when the doc UUID is almost the same to one of the IDs in the
> > > > > > query except the the last part of ID. Wondering if there is an explanation
> > > > > > for such behavior of elasticsearch?
> > > > > >
> > > > > > Our another question is if there is any way we could put the UUID
> > > > > > list as a list into a query that is working with the percolator, like what
> > > > > > we can do for inQuery or inFilter. We tried register an inQuery or a query
> > > > > > wrapping an inFilter. Non of them can work with the percolator, seems the
> > > > > > percolator only works with the MatchQuery, in which we cannot put the UUID
> > > > > > list as a list.
> > > > > >
> > > > > > For example the following two queries we tried are not working with
> > > > > > percolator:
> > > > > >
> > > > > > {
> > > > > > "\_index" : "my\_idx",
> > > > > > "\_type" : ".percolator",
> > > > > > "\_id" : "inQuery",
> > > > > > "\_score" : 1.0, "\_source" : {"query":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d54b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}
> > > > > > },
> > > > > >
> > > > > > {
> > > > > > "\_index" : "my\_idx",
> > > > > > "\_type" : ".percolator",
> > > > > > "\_id" : "inFilterQ",
> > > > > > "\_score" : 1.0, "\_source" : {"query":{"filtered":{"query":{"match\_all":{}},"filter":{"terms":{"id":["1aa808dc-48f0-4de3-8978-a0293d50b852","6b256fd1-cd04-4e3c-8f38-aaa87ac2220d"]}}}}}
> > > > > > },
> > > > > >
> > > > > > Thanks for your help!
> > > > > >
> > > > > > Jason
> > > > > >
> > > > > > On Friday, May 2, 2014 7:34:47 PM UTC+12, Martijn v Groningen wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > Can you share the stored percolator queries and the percolate
> > > > > > > request that you were initially trying with, but didn't work?\
> > > > > > >
> > > > > > > Martijn
> > > > > > >
> > > > > > > On 2 May 2014 11:14, JGL [j.g.l...@gmail.com](mailto:j.g.l...@gmail.com) wrote:
> > > > > > >
> > > > > > > > Can anybody help plz?
> > > > > > > >
> > > > > > > > --
> > > > > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com).
> > > > > > > > To view this discussion on the web visit
> > > > > > > > [https://groups.google.com/d/msgid/elasticsearch/4ee60836-192](https://groups.google.com/d/msgid/elasticsearch/4ee60836-192)
> > > > > > > > 2-43e0-8d9b-64ef9bb0b00a%[40googlegroups.com](http://40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/4ee60836-1922-43e0-8d9b-64ef9bb0b00a%40googlegroups.com?utm_medium=email&utm_source=footer)
> > > > > > > > .
> > > > > > > >
> > > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > > > >
> > > > > > > --
> > > > > > > Met vriendelijke groet,
> > > > > > >
> > > > > > > Martijn van Groningen
> >
> > --
> > Met vriendelijke groet,
> >
> > Martijn van Groningen
--
Met vriendelijke groet,
Martijn van Groningen
--
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](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CA%2BA76Tzc0b0ddpNAg31Y2sPw5tj9Xr8aXts4GRvORnOzhaxyQA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CA%2BA76Tzc0b0ddpNAg31Y2sPw5tj9Xr8aXts4GRvORnOzhaxyQA%40mail.gmail.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@JGL](https://discuss.elastic.co/u/JGL)
#### Post date: [May 27, 2014, 12:51am UTC](https://discuss.elastic.co/t/help-with-es-1-x-percolator-query-plz/17312/11 "2014-05-27T00:51:10Z")
Hi Martijn,
It works!
Thank you so much for the help!
Thanks,
Jason
--
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](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/ed084b17-a20b-4c9b-8ffb-c779d772b3c9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/ed084b17-a20b-4c9b-8ffb-c779d772b3c9%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:26am UTC](https://discuss.elastic.co/t/help-with-es-1-x-percolator-query-plz/17312/12 "2017-07-06T01:26:49Z")