Delete multiple indices in one Elasticsearch HTTP request (cURL)

Question

I was using this curl command line to clean my indices:

curl -XDELETE http://example.com/my_index-*

But, now, I want to delete my_index-.*[.][0-3][0-9]:

to delete only my_index-YYYY.MM.dd
to keep my_index-YYYY.MM.dd-*

The relevant Elasticsearch documentation I have found:

Delete index API does say nothing on regex.
Multiple indices says:

It also support wildcards, for example: test* or *test or te*t or *test*, and the ability to "add" (+) and "remove" (-), for example: +test*,-test3.
Date math support in index names says:

Almost all APIs that have an index parameter, support date math in the index parameter value.
[...]
date_format is the optional format in which the computed date should be rendered. Defaults to YYYY.MM.dd.

My Questions:

Is it possible to send a DELETE request method to Elasticsearch HTTP server to delete indices only formatted my_index-YYYY.MM.dd?
Or the inverse, to delete all my_index-* but keeping my_index-*-*?

For example, regex can sometimes be provided within the POST data:

curl -XPOST http://example.com/my_index-2017.07.14/_search?pretty' -H 'Content-Type: application/json' -d'
{
    "suggest": {
        "song-suggest" : {
            "regex" : "n[ever|i]r",
            "completion" : {
                "field" : "suggest"
            }
        }
    }
}'

oHo · Accepted Answer · 2017-07-07 13:31:06Z

Short answer

Delete all indices my_index-* except indices my_index-*-*

curl -X DELETE http://es.example.com/my_index-*,-my_index-*-*

No regex

Elasticsearch 5.x does not accept regex or filename patterns ?[a-z] to select multiple indices.

However, the multiple indices documentation allows + and - to include and exclude indices.

Script to prevent accidental deletion of indices my_index-*-*:

#!/bin/bash -xe
pattern="${1:-*}"
curl -X DELETE https://es.example.com/my_index-"$pattern",-my_index-*-*?pretty

Explanation

The parameter index can contain a comma separated list of index patterns, for example my_index_1,my_index_2,my_index_3.
Index pattern is based on wildcards, for example my_index*.
To include and exclude indices, use + and - as index prefix, for example my_index_*,-my_index_2017*,+my_index_2017-01*,-my_index_2017-01-31.
Do not need to use + on first index

Described example

This DELETE request deletes all indices my_index_* before my_index_2017-01-31

index_list='my_index_*,-my_index_2017*,+my_index_2017-01*,-my_index_2017-01-31'
curl -X DELETE http://es.example.com/"$index_list"

Delete all my_index_*
Except my_index_2017*
Delete my_index_2017-01*
Except my_index_2017-01-31

Collectives™ on Stack Overflow

Delete multiple indices in one Elasticsearch HTTP request (cURL)

1 Answer 1

Short answer

No regex

Explanation

Described example

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Short answer

No regex

Explanation

Described example

Comments

Your Answer

Sign up or log in

Post as a guest

Related