ElasticSearch Delete by query not working in PHP

Question

I am using Elastic search 5.x and the following code is working fine:

curl -XPOST "http://localhost:9200/test_index/test_info/_delete_by_query" -d'
{
  "query": {
    "match": {
        "category_id": "21"
    }
  }
}'

But when I am trying the same in my php code, its not working:

$client->deleteByQuery([
'index' => 'test_index',
'type'  => 'test_info',

    'query' => [
        'match' => [
                ['category_id' => 21]

        ]       
    ]

]);

Which version of the elasticsearch-php library are you using? — Val
– Val, Commented Jun 19, 2017 at 6:09
See this answer: stackoverflow.com/questions/37382980/… you need version 2.4 at least — Val
– Val, Commented Jun 19, 2017 at 7:28

Mariusz · Accepted Answer · 2018-06-28 12:06:43Z

6

You need to provide your query array inside body array of your parameters:

$client->deleteByQuery([
    'index' => 'test_index',
    'type' => 'test_info',
    'body' => [
        'query' => [
            'match' => [
                ['category_id' => 21]
            ]
        ]
    ]
]);

answered Jun 28, 2018 at 12:06

Mariusz

2463 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Manuel Pirez Over a year ago

Without type is possible too (php 7.2 - ES 7.3) ['index' => 'test_index','body' => ['query' => ['match' => ['keyword' => '123456']]],];

Ben Ahmed Nejib · Accepted Answer · 2020-07-26 15:12:21Z

2

this an old question, previous comments don't work anymore in 2020 :

$client->deleteByQuery([
    'index' => 'test_index',
   (there were a type here)  'type' => 'test_info',
    'body' => [
        'query' => [
            'match' => [
                (there were an array here) ['category_id' => 21]
            ]
        ]
    ]
]);

So the final code is :

$client->deleteByQuery([
    'index' => 'test_index',
    'body' => [
        'query' => [
            'match' => [
               'category_id' => 21
            ]
        ]
    ]

edited Jul 26, 2020 at 15:12

answered Jul 25, 2020 at 12:18

Ben Ahmed Nejib

1971 silver badge3 bronze badges

Collectives™ on Stack Overflow

ElasticSearch Delete by query not working in PHP

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related