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!

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 | Bob.Sandiford@sirsidynix.commailto:Bob.Sandiford@sirsidynix.com
www.sirsidynix.comhttp://www.sirsidynix.com/

Join the conversation: Like us on Facebook!http://www.facebook.com/SirsiDynix Follow us on Twitter!http://twitter.com/SirsiDynix

From: Sumisha [via ElasticSearch Users] [mailto:ml-node+s115913n4018866h93@n3.nabble.com]
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 ml-node+s115913n115913h50@n3.nabble.commailto:ml-node+s115913n115913h50@n3.nabble.com
To unsubscribe from ElasticSearch Users, click herehttp://elasticsearch-users.115913.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=115913&code=Ym9iLnNhbmRpZm9yZEBzaXJzaWR5bml4LmNvbXwxMTU5MTN8LTIxMTYxMTI0NTQ=.
NAMLhttp://elasticsearch-users.115913.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html!nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers!nabble%3Aemail.naml-instant_emails!nabble%3Aemail.naml-send_instant_email!nabble%3Aemail.naml

Can you share a full recreation? See Elasticsearch Platform — Find real-time answers at scale | Elastic.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sumisha@sourcebits.com 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.

Having the same issue. Ended up getting exception

Hi,

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

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See Elasticsearch Platform — Find real-time answers at scale | Elastic.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha <sum...@sourcebits.com<javascript:>

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.

--

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.

es_deletebyquery · GitHub

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See Elasticsearch Platform — Find real-time answers at scale | Elastic.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sum...@sourcebits.com 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.

--

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.

es_deletebyquery · GitHub

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See Elasticsearch Platform — Find real-time answers at scale | Elastic.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sum...@sourcebits.com 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.

--

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.

es_deletebyquery · GitHub

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See Elasticsearch Platform — Find real-time answers at scale | Elastic.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sum...@sourcebits.com 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.

--

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.

es_deletebyquery · GitHub

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See Elasticsearch Platform — Find real-time answers at scale | Elastic
.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sum...@sourcebits.com 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.

--

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.

es_deletebyquery · GitHub

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See Elasticsearch Platform — Find real-time answers at scale | Elastic
.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sum...@sourcebits.com 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.

--

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.

es_deletebyquery · GitHub

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See Elasticsearch Platform — Find real-time answers at scale | Elastic
.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sum...@sourcebits.com 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.

--

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, es_deletebyquery · GitHub

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.

es_deletebyquery · GitHub

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See Elasticsearch Platform — Find real-time answers at scale | Elastic
.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sum...@sourcebits.com 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.

--

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)

Updated gist, es_deletebyquery · GitHub

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.

es_deletebyquery · GitHub

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See
Elasticsearch Platform — Find real-time answers at scale | Elastic.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sum...@sourcebits.comwrote:

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.

--

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)

Updated gist, es_deletebyquery · GitHub

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.

es_deletebyquery · GitHub

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See
Elasticsearch Platform — Find real-time answers at scale | Elastic.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sum...@sourcebits.comwrote:

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.

--

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)

Updated gist, es_deletebyquery · GitHub

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.

es_deletebyquery · GitHub

Thanks in advance

On Monday, June 11, 2012 5:09:10 AM UTC+8, kimchy wrote:

Can you share a full recreation? See
Elasticsearch Platform — Find real-time answers at scale | Elastic.

On Wed, Jun 6, 2012 at 7:45 AM, Sumisha sum...@sourcebits.comwrote:

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.

--