How to Delete all entries for a particular coloumn

Elastic Stack Elasticsearch
1

Hi,

I want to delete all entries for the Date as 2016-02-11.
How can I achieve this . I tried DELETE //_query?q=Date:2016-02-11
but it is giving response as :slight_smile:
{
"found": false,
"_index": <"indexname>",
"_type": "",
"_id": "_query",
"_version": 1,
"_shards": {
"total": 2,
"successful": 2,
"failed": 0
}
}

Kindly help asap.

2

Which version?
Did you read https://www.elastic.co/guide/en/elasticsearch/plugins/current/plugins-delete-by-query.html ?

3

Elastic search version number is 2.2.1 and lucene_version is 5.4.1.

Yaa I have gone through the link and tried the query DELETE my-index-name/index-mapping-type/_query?q=Date:2016-02-11.

I have doubt about the type(what type it is asking for ) and also can you please tell me the command.

4

Where are your data?

What is the index name?
What is the type?

Can you show a Document?

5

Also can you share your logs from the restart?

6

Data is in my local machine. Index name can be anything (mine is :testindex1).I don't have idea about what type means here (I passed my mapping type which is for me :"testmapping").

A document as below:
02/11/2015 12:42:54 PM 2015-02-11 111111111111111111111111111111 2222222222222222222222222222 3333333333333333333333333333 www.abc.com www.abc.com 7 6 9 7 9 2 2 3 3 5 0 0 0 3 0 xyz 105384 notequal punji face radio

7

This is not a document.

A document has fields, values and is in JSON.

I'm not sure you know what you are doing.

That being said, if your type is testmapping you should call:

DELETE testindex1/testmapping/_query?q=Date:2016-02-11

But again, I don't know your mapping and I don't know your docs.
Also you did not provide logs so I'm still unsure you installed correctly the plugin.