Delete by query not working for multiple ids

classic Classic list List threaded Threaded
15 messages Options
SG
Reply | Threaded
Open this post in threaded view
|

Delete by query not working for multiple ids

SG
I am trying to delete all the indices which matches the id array, when I try to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but when the same is used for delete it shows as failed.

curl -XDELETE 'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
      "ids" : {
          "values" : ["1" ,"2", "3]
      }
}

Thanks for your help!

Reply | Threaded
Open this post in threaded view
|

RE: Delete by query not working for multiple ids

rpsandiford
This post has NOT been accepted by the mailing list yet.

I don’t suppose the resolution is to add the missing closing quote to ID 3 in your curl command?

 

Bob Sandiford | Lead Software Engineer SirsiDynix

P: 800.288.8020 X6943 | [hidden email]

www.sirsidynix.com

 

Join the conversation: Like us on Facebook! Follow us on Twitter!

 

From: Sumisha [via ElasticSearch Users] [mailto:[hidden email]]
Sent: Wednesday, June 06, 2012 1:45 AM
To: Bob Sandiford
Subject: Delete by query not working for multiple ids

 

I am trying to delete all the indices which matches the id array, when I try to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but when the same is used for delete it shows as failed.

curl -XDELETE 'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
      "ids" : {
          "values" : ["1" ,"2", "3]
      }
}

Thanks for your help!



If you reply to this email, your message will be added to the discussion below:

http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html

To start a new topic under ElasticSearch Users, email [hidden email]
To unsubscribe from ElasticSearch Users, click here.
NAML

Bob.
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

kimchy
Administrator
In reply to this post by SG
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

0xff
This post has NOT been accepted by the mailing list yet.
Having the same issue. Ended up getting exception

https://gist.github.com/4222311
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

0xff
In reply to this post by kimchy
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="e1yuLuADN3IJ">sum...@...> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

Igor Motov-3
Which version of elasticsearch are you using?

On Thursday, December 6, 2012 5:07:20 AM UTC-5, Sara wrote:
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

0xff
0.15.2

On Friday, December 7, 2012 12:28:27 PM UTC+8, Igor Motov wrote:
Which version of elasticsearch are you using?

On Thursday, December 6, 2012 5:07:20 AM UTC-5, Sara wrote:
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

Igor Motov-3
The "ids" query was added in 0.16.0. So, it is not available in your version. I would encourage upgrading to a more recent release. There were significantly improvements in performance and stability since v0.15.2. 

On Friday, December 7, 2012 5:42:48 AM UTC-5, Sara wrote:
0.15.2

On Friday, December 7, 2012 12:28:27 PM UTC+8, Igor Motov wrote:
Which version of elasticsearch are you using?

On Thursday, December 6, 2012 5:07:20 AM UTC-5, Sara wrote:
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

0xff
Thanks a lot Igor. I will upgrade mine.



On Friday, December 7, 2012 7:15:36 PM UTC+8, Igor Motov wrote:
The "ids" query was added in 0.16.0. So, it is not available in your version. I would encourage upgrading to a more recent release. There were significantly improvements in performance and stability since v0.15.2. 

On Friday, December 7, 2012 5:42:48 AM UTC-5, Sara wrote:
0.15.2

On Friday, December 7, 2012 12:28:27 PM UTC+8, Igor Motov wrote:
Which version of elasticsearch are you using?

On Thursday, December 6, 2012 5:07:20 AM UTC-5, Sara wrote:
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

0xff
In reply to this post by Igor Motov-3
Hi Igor,

I have updated my elasticsearch to 0.18.7. Thanks a lot for your advice. I am able to now search by list of ids 

{
  "query": {
    "ids": {
      "values": [
        "1",
        "2",
        "3"
      ]
    }
  }
}

but I couldn't use ids in my delete by query. Not sure where I am wrong. Please find my curl recreation below

curl -XDELETE 'http://localhost:9200/_all/_query' -d '{ 
      "ids" : { 
          "values" : ["1" ,"2", "3"] 
      } 
}'

Response:

{"ok":true,"_indices":{"twitter":{"_shards":{"total":5,"successful":0,"failed":5}},"com.profyle.profiles":{"_shards":{"total":5,"successful":0,"failed":5}}}}

Trace:

org.elasticsearch.index.query.QueryParsingException: [twitter] Failed to parse
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:186)
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:175)




On Friday, December 7, 2012 7:15:36 PM UTC+8, Igor Motov wrote:
The "ids" query was added in 0.16.0. So, it is not available in your version. I would encourage upgrading to a more recent release. There were significantly improvements in performance and stability since v0.15.2. 

On Friday, December 7, 2012 5:42:48 AM UTC-5, Sara wrote:
0.15.2

On Friday, December 7, 2012 12:28:27 PM UTC+8, Igor Motov wrote:
Which version of elasticsearch are you using?

On Thursday, December 6, 2012 5:07:20 AM UTC-5, Sara wrote:
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

0xff
In reply to this post by Igor Motov-3
Hi Igor,

I have updated my elasticsearch to 0.18.7. Thanks a lot for your advice. I am able to now search by list of ids 

{
  "query": {
    "ids": {
      "values": [
        "1",
        "2",
        "3"
      ]
    }
  }
}

but I couldn't use ids in my delete by query. Not sure where I am wrong. Please find my curl recreation below

curl -XDELETE 'http://localhost:9200/_all/_query' -d '{ 
      "ids" : { 
          "values" : ["1" ,"2", "3"] 
      } 
}'

Response:

{"ok":true,"_indices":{"twitter":{"_shards":{"total":5,"successful":0,"failed":5}},"com.test":{"_shards":{"total":5,"successful":0,"failed":5}}}}

Trace:

org.elasticsearch.index.query.QueryParsingException: [twitter] Failed to parse
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:186)
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:175)


Thanks in advance

On Friday, December 7, 2012 7:15:36 PM UTC+8, Igor Motov wrote:
The "ids" query was added in 0.16.0. So, it is not available in your version. I would encourage upgrading to a more recent release. There were significantly improvements in performance and stability since v0.15.2. 

On Friday, December 7, 2012 5:42:48 AM UTC-5, Sara wrote:
0.15.2

On Friday, December 7, 2012 12:28:27 PM UTC+8, Igor Motov wrote:
Which version of elasticsearch are you using?

On Thursday, December 6, 2012 5:07:20 AM UTC-5, Sara wrote:
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

0xff
In reply to this post by Igor Motov-3
Hi Igor,

I have updated my elasticsearch to 0.18.7. Thanks a lot for your advice. I am able to now search by list of ids 

{
  "query": {
    "ids": {
      "values": [
        "1",
        "2",
        "3"
      ]
    }
  }
}

but I couldn't use ids in my delete by query. Not sure where I am wrong. Please find my curl recreation below

curl -XDELETE 'http://localhost:9200/_all/_query' -d '{ 
      "ids" : { 
          "values" : ["1" ,"2", "3"] 
      } 
}'

Response:

{"ok":true,"_indices":{"twitter":{"_shards":{"total":5,"successful":0,"failed":5}},"com.test":{"_shards":{"total":5,"successful":0,"failed":5}}}}

Trace:

org.elasticsearch.index.query.QueryParsingException: [twitter] Failed to parse
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:186)
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:175)

Updated gist,  https://gist.github.com/4222311


Thanks in advance

On Friday, December 7, 2012 7:15:36 PM UTC+8, Igor Motov wrote:
The "ids" query was added in 0.16.0. So, it is not available in your version. I would encourage upgrading to a more recent release. There were significantly improvements in performance and stability since v0.15.2. 

On Friday, December 7, 2012 5:42:48 AM UTC-5, Sara wrote:
0.15.2

On Friday, December 7, 2012 12:28:27 PM UTC+8, Igor Motov wrote:
Which version of elasticsearch are you using?

On Thursday, December 6, 2012 5:07:20 AM UTC-5, Sara wrote:
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

0xff
Tried with terms query and it works though,

curl -XDELETE 'http://localhost:9200/_all/_query' -d '{
            "terms": {
                "_id": ["1","2","3"]
            }
        }'
{"ok":true,"_indices":{"twitter":{"_shards":{"total":5,"successful":5,"failed":0}},"com.test":{"_shards":{"total":5,"successful":5,"failed":0}}}



On Tuesday, December 11, 2012 7:56:12 PM UTC+8, Sara wrote:
Hi Igor,

I have updated my elasticsearch to 0.18.7. Thanks a lot for your advice. I am able to now search by list of ids 

{
  "query": {
    "ids": {
      "values": [
        "1",
        "2",
        "3"
      ]
    }
  }
}

but I couldn't use ids in my delete by query. Not sure where I am wrong. Please find my curl recreation below

curl -XDELETE 'http://localhost:9200/_all/_query' -d '{ 
      "ids" : { 
          "values" : ["1" ,"2", "3"] 
      } 
}'

Response:

{"ok":true,"_indices":{"twitter":{"_shards":{"total":5,"successful":0,"failed":5}},"com.test":{"_shards":{"total":5,"successful":0,"failed":5}}}}

Trace:

org.elasticsearch.index.query.QueryParsingException: [twitter] Failed to parse
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:186)
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:175)



Thanks in advance

On Friday, December 7, 2012 7:15:36 PM UTC+8, Igor Motov wrote:
The "ids" query was added in 0.16.0. So, it is not available in your version. I would encourage upgrading to a more recent release. There were significantly improvements in performance and stability since v0.15.2. 

On Friday, December 7, 2012 5:42:48 AM UTC-5, Sara wrote:
0.15.2

On Friday, December 7, 2012 12:28:27 PM UTC+8, Igor Motov wrote:
Which version of elasticsearch are you using?

On Thursday, December 6, 2012 5:07:20 AM UTC-5, Sara wrote:
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

Igor Motov-3
Any particular reason you stopped at 0.18.7?  I would suggest upgrading to something more recent. I think the bug that you are now hitting was fixed in 0.19 branch.

On Tuesday, December 11, 2012 7:31:30 AM UTC-5, Sara wrote:
Tried with terms query and it works though,

curl -XDELETE 'http://localhost:9200/_all/_query' -d '{
            "terms": {
                "_id": ["1","2","3"]
            }
        }'
{"ok":true,"_indices":{"twitter":{"_shards":{"total":5,"successful":5,"failed":0}},"com.test":{"_shards":{"total":5,"successful":5,"failed":0}}}



On Tuesday, December 11, 2012 7:56:12 PM UTC+8, Sara wrote:
Hi Igor,

I have updated my elasticsearch to 0.18.7. Thanks a lot for your advice. I am able to now search by list of ids 

{
  "query": {
    "ids": {
      "values": [
        "1",
        "2",
        "3"
      ]
    }
  }
}

but I couldn't use ids in my delete by query. Not sure where I am wrong. Please find my curl recreation below

curl -XDELETE 'http://localhost:9200/_all/_query' -d '{ 
      "ids" : { 
          "values" : ["1" ,"2", "3"] 
      } 
}'

Response:

{"ok":true,"_indices":{"twitter":{"_shards":{"total":5,"successful":0,"failed":5}},"com.test":{"_shards":{"total":5,"successful":0,"failed":5}}}}

Trace:

org.elasticsearch.index.query.QueryParsingException: [twitter] Failed to parse
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:186)
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:175)



Thanks in advance

On Friday, December 7, 2012 7:15:36 PM UTC+8, Igor Motov wrote:
The "ids" query was added in 0.16.0. So, it is not available in your version. I would encourage upgrading to a more recent release. There were significantly improvements in performance and stability since v0.15.2. 

On Friday, December 7, 2012 5:42:48 AM UTC-5, Sara wrote:
0.15.2

On Friday, December 7, 2012 12:28:27 PM UTC+8, Igor Motov wrote:
Which version of elasticsearch are you using?

On Thursday, December 6, 2012 5:07:20 AM UTC-5, Sara wrote:
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Delete by query not working for multiple ids

0xff
Hi Igor,

Thanks for your reply. I stopped at 0.18.7 because of the grails elasticsearch plugin I am using. 
Need to customize the plugin to use the latest version. At the moment I am going with the terms query.

Cheers.



On Tuesday, December 11, 2012 10:41:20 PM UTC+8, Igor Motov wrote:
Any particular reason you stopped at 0.18.7?  I would suggest upgrading to something more recent. I think the bug that you are now hitting was fixed in 0.19 branch.

On Tuesday, December 11, 2012 7:31:30 AM UTC-5, Sara wrote:
Tried with terms query and it works though,

curl -XDELETE 'http://localhost:9200/_all/_query' -d '{
            "terms": {
                "_id": ["1","2","3"]
            }
        }'
{"ok":true,"_indices":{"twitter":{"_shards":{"total":5,"successful":5,"failed":0}},"com.test":{"_shards":{"total":5,"successful":5,"failed":0}}}



On Tuesday, December 11, 2012 7:56:12 PM UTC+8, Sara wrote:
Hi Igor,

I have updated my elasticsearch to 0.18.7. Thanks a lot for your advice. I am able to now search by list of ids 

{
  "query": {
    "ids": {
      "values": [
        "1",
        "2",
        "3"
      ]
    }
  }
}

but I couldn't use ids in my delete by query. Not sure where I am wrong. Please find my curl recreation below

curl -XDELETE 'http://localhost:9200/_all/_query' -d '{ 
      "ids" : { 
          "values" : ["1" ,"2", "3"] 
      } 
}'

Response:

{"ok":true,"_indices":{"twitter":{"_shards":{"total":5,"successful":0,"failed":5}},"com.test":{"_shards":{"total":5,"successful":0,"failed":5}}}}

Trace:

org.elasticsearch.index.query.QueryParsingException: [twitter] Failed to parse
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:186)
at org.elasticsearch.index.query.IndexQueryParserService.parse(IndexQueryParserService.java:175)



Thanks in advance

On Friday, December 7, 2012 7:15:36 PM UTC+8, Igor Motov wrote:
The "ids" query was added in 0.16.0. So, it is not available in your version. I would encourage upgrading to a more recent release. There were significantly improvements in performance and stability since v0.15.2. 

On Friday, December 7, 2012 5:42:48 AM UTC-5, Sara wrote:
0.15.2

On Friday, December 7, 2012 12:28:27 PM UTC+8, Igor Motov wrote:
Which version of elasticsearch are you using?

On Thursday, December 6, 2012 5:07:20 AM UTC-5, Sara wrote:
Hi,

I am having the same issue trying to do the same thing.  

https://gist.github.com/4222311

Thanks in advance


On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:
Can you share a full recreation? See http://www.elasticsearch.org/help.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <[hidden email]> wrote:
I am trying to delete all the indices which matches the id array, when I try
to fetch with "ids": {"values":["1","2","3"]} exact data are fetching. but
when the same is used for delete it shows as failed.

curl -XDELETE
'http://localhost:9200/mydb.content_collections/releases/_query' -d '{
     "ids" : {
         "values" : ["1" ,"2", "3]
     }
}

Thanks for your help!



--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Delete-by-query-not-working-for-multiple-ids-tp4018866.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--