Delete by query string query is not working with 1.2.0

happyprg · May 30, 2014, 3:31am

i think do that wrote according to guideline.

elastic/elasticsearch/blob/master/CONTRIBUTING.md

Contributing to elasticsearch
=============================

Elasticsearch is an open source project and we love to receive contributions from our community — you! There are many ways to contribute, from writing tutorials or blog posts, improving the documentation, submitting bug reports and feature requests or writing code which can be incorporated into Elasticsearch itself.

Bug reports
-----------

If you think you have found a bug in Elasticsearch, first make sure that you are testing against the [latest version of Elasticsearch](https://www.elastic.co/downloads/elasticsearch) - your issue may already have been fixed. If not, search our [issues list](https://github.com/elastic/elasticsearch/issues) on GitHub in case a similar issue has already been opened.

It is very helpful if you can prepare a reproduction of the bug. In other words, provide a small test case which we can run to confirm your bug. It makes it easier to find the problem and to fix it. Test cases should be provided as `curl` commands which we can copy and paste into a terminal to run it locally, for example:

```sh
# delete the index
curl -XDELETE localhost:9200/test

# insert a document
curl -XPUT localhost:9200/test/test/1 -d '{
 "title": "test document"
}'

This file has been truncated. show original

from elasticsearch version 0.90.7, was used delete-by-query-string query .
at the one time. deleted approximately 250 doc.
http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html

and i did upgrade version to 1.2.0.
after that, i did meet up error screen.
please help me ..
thanks you.

create index

curl -XPOST 'http://10.99.196.141:22000/delete_by_query_string_query_test1'

create mapping

curl -XPUT 'http://10.99.196.141:22000/delete_by_query_string_query_test1/1/_mapping' -d '{
"properties":{
"playId":{
"type":"string",
"index":"not_analyzed",
"store":"true"
}
}
}'

make doc

curl -XPOST 'http://10.99.196.141:22000/delete_by_query_string_query_test1/1' -d '{
"playId": "1395395f-1543-44f7-ba11-fd8eff137afe"
}'

delete by query string query

curl -XDELETE 'http://10.99.196.141:22000/delete_by_query_string_query_test1/1/_query?pretty=true' -d '
{
"query_string" : {
"default_field" : "playId",
"query" : "1395395f-1543-44f7-ba11-fd8eff137afe"
}
}
'

response occured error -

{
"_indices" : {
"delete_by_query_string_query_test1" : {
"_shards" : {
"total" : 2,
"successful" : 0,
"failed" : 2,
"failures" : [ {
"index" : "delete_by_query_string_query_test1",
"shard" : 1,
"reason" : "RemoteTransportException[[10.99.196.141_21001][inet[/10.99.196.141:21001]][deleteByQuery/shard]]; nested: QueryParsingException[[delete_by_query_string_query_test1] request does not support [query_string]]; "
}, {
"index" : "delete_by_query_string_query_test1",
"shard" : 0,
"reason" : "RemoteTransportException[[10.101.63.182_21000][inet[/10.101.63.182:21000]][deleteByQuery/shard]]; nested: QueryParsingException[[delete_by_query_string_query_test1] request does not support [query_string]]; "
} ]
}
}
}
}

somebody help me please.

dadoonet · May 30, 2014, 5:13am

I answered in github. API changed in 1.0.

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 30 mai 2014 à 05:31, hongsgo hongsgo@gmail.com a écrit :

i think do that wrote according to guideline.

github.com

elastic/elasticsearch/blob/master/CONTRIBUTING.md

Contributing to elasticsearch
=============================

Elasticsearch is an open source project and we love to receive contributions from our community — you! There are many ways to contribute, from writing tutorials or blog posts, improving the documentation, submitting bug reports and feature requests or writing code which can be incorporated into Elasticsearch itself.

Bug reports
-----------

If you think you have found a bug in Elasticsearch, first make sure that you are testing against the [latest version of Elasticsearch](https://www.elastic.co/downloads/elasticsearch) - your issue may already have been fixed. If not, search our [issues list](https://github.com/elastic/elasticsearch/issues) on GitHub in case a similar issue has already been opened.

It is very helpful if you can prepare a reproduction of the bug. In other words, provide a small test case which we can run to confirm your bug. It makes it easier to find the problem and to fix it. Test cases should be provided as `curl` commands which we can copy and paste into a terminal to run it locally, for example:

```sh
# delete the index
curl -XDELETE localhost:9200/test

# insert a document
curl -XPUT localhost:9200/test/test/1 -d '{
 "title": "test document"
}'

This file has been truncated. show original

from elasticsearch version 0.90.7, was used delete-by-query-string query .
at the one time. deleted approximately 250 doc.
http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html

and i did upgrade version to 1.2.0.
after that, i did meet up error screen.
please help me ..
thanks you.

create index

curl -XPOST 'http://10.99.196.141:22000/delete_by_query_string_query_test1'

create mapping

curl -XPUT
'http://10.99.196.141:22000/delete_by_query_string_query_test1/1/_mapping'
-d '{
"properties":{
"playId":{
"type":"string",
"index":"not_analyzed",
"store":"true"
}
}
}'

make doc

curl -XPOST
'http://10.99.196.141:22000/delete_by_query_string_query_test1/1' -d '{
"playId": "1395395f-1543-44f7-ba11-fd8eff137afe"
}'

delete by query string query

curl -XDELETE
'http://10.99.196.141:22000/delete_by_query_string_query_test1/1/_query?pretty=true'
-d '
{
"query_string" : {
"default_field" : "playId",
"query" : "1395395f-1543-44f7-ba11-fd8eff137afe"
}
}
'

response occured error -

{
"_indices" : {
"delete_by_query_string_query_test1" : {
"_shards" : {
"total" : 2,
"successful" : 0,
"failed" : 2,
"failures" : [ {
"index" : "delete_by_query_string_query_test1",
"shard" : 1,
"reason" :
"RemoteTransportException[[10.99.196.141_21001][inet[/10.99.196.141:21001]][deleteByQuery/shard]];
nested: QueryParsingException[[delete_by_query_string_query_test1] request
does not support [query_string]]; "
}, {
"index" : "delete_by_query_string_query_test1",
"shard" : 0,
"reason" :
"RemoteTransportException[[10.101.63.182_21000][inet[/10.101.63.182:21000]][deleteByQuery/shard]];
nested: QueryParsingException[[delete_by_query_string_query_test1] request
does not support [query_string]]; "
} ]
}
}
}
}

somebody help me please.

--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/delete-by-query-string-query-is-not-working-with-1-2-0-tp4056754.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/1401420702674-4056754.post%40n3.nabble.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/67DE9A5A-750A-41D3-B11E-70557AC58F6B%40pilato.fr.
For more options, visit https://groups.google.com/d/optout.

happyprg · May 30, 2014, 5:52am

thanks you.
is it right?

delete by query string query

curl -XDELETE 'http://10.99.196.141:22000/delete_by_query_string_query_test1/1/_query?pretty=true' -d '
{
"query" : { //added
"query_string" : {
"default_field" : "playId",
"query" : "1395395f-1543-44f7-ba11-fd8eff137af2 OR 1395395f-1543-44f7-ba11-fd8eff137af1"
}
}
}
'

dadoonet · May 30, 2014, 6:03am

It sounds good. Does it work?

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 30 mai 2014 à 07:52, hongsgo hongsgo@gmail.com a écrit :

thanks you.
is it right?

delete by query string query

curl -XDELETE
'http://10.99.196.141:22000/delete_by_query_string_query_test1/1/_query?pretty=true'
-d '
{
"query" : { //added
"query_string" : {
"default_field" : "playId",
"query" : "1395395f-1543-44f7-ba11-fd8eff137af2 OR
1395395f-1543-44f7-ba11-fd8eff137af1"
}
}
}
'

--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/delete-by-query-string-query-is-not-working-with-1-2-0-tp4056754p4056764.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/1401429125740-4056764.post%40n3.nabble.com.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CA423A07-26A0-4C69-A284-AC6335931CAB%40pilato.fr.
For more options, visit https://groups.google.com/d/optout.

happyprg · May 30, 2014, 6:47am

Yes. it is works.
I learned a lot of things of you
Thank you.^^