Delete by query string query is not working with 1.2.0


(이지홍) #1

i think do that wrote according to guideline.

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.


(David Pilato) #2

I answered in github. API changed in 1.0.

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

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

i think do that wrote according to guideline.

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.


(이지홍) #3

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"
}
}
}
'


(David Pilato) #4

It sounds good. Does it work?

--
David :wink:
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.


(이지홍) #5

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


(system) #6