CODEWITHSUNDEEP
pythonelasticsearch
David542
David542

Reputation: 110492

How to get a list of all indexes in python-elasticsearch

How would I get a list of the names of an index in Python? Here is what I have so far:

>>> es=e.es
>>> es
<Elasticsearch([{'host': '14555f777d8097.us-east-1.aws.found.io', 'port': 9200}])>
>>> es.indices
<elasticsearch.client.indices.IndicesClient object at 0x10de86790>
# how to get a list of all indexes in this cluster?

Upvotes: 88

Views: 105528

Answers (9)

pascal
pascal

Reputation: 767

To get a list of all the indexes in a cluster, use a wildcard.

This works with elasticsearch-py.

# Python 2
for index in es.indices.get('*'):
  print index

# Python 3
for index in es.indices.get('*'):
  print(index)

Upvotes: 52

erewok
erewok

Reputation: 7845

This question comes up when searching for information on retrieving aliases using the python-elasticsearch library. The accepted answer says to use get_aliases but that method has been removed (as of 2017). To get aliases, you can use the following:

 es.indices.get_alias("*")

UPDATE

The latest usage should be with a keyword arg:

es.indices.get_alias(index="*")

Upvotes: 106

Sudharsan Aravind
Sudharsan Aravind

Reputation: 83

_cat API seems the right way to do this, since the _aliases way of doing will soon be removed by elasticsearch since it exposes the system indices.

indices = es.cat.indices(h='index', s='index').split()

It did the job for me.

Upvotes: 1

Shruti Hande
Shruti Hande

Reputation: 11

If you want 'alias name' and not 'index name', here the perfect solution:

response = es.indices.get(indexname)
alias_names = list(response[indexname]['aliases'].keys())

In alias_names we get list of alias names on a particular index.

Upvotes: 1

adamo
adamo

Reputation: 4052

You can use the Cat API:es.cat.indices(h='index', s='index').split()

Upvotes: 4

David542
David542

Reputation: 110492

Here is one way to do it with the get_alias() method:

>>> indices=es.indices.get_alias().keys()
>>> sorted(indices)
[u'avails', u'hey', u'kibana-int']

Upvotes: 43

travelingbones
travelingbones

Reputation: 8448

If you are willing to use pyelasticsearch module they have support for the GET _mapping command, which produces the schema of the cluster. This will allow you to see the indices, and drill into each index to see doc_types, and their fields, etc. Here's an example:

import pyelasticsearch as pyes
es = pyes.ElasticSearch(["http://hostname0:9200", "http://hostname1:9200"]) ## don't accidentally type Elasticsearch, the class from the other two modules
schema = es.get_mapping() ## python dict with the map of the cluster

To get just the list of indices,

indices_full_list = schema.keys()
just_indices = [index for index in indices_full_list if not index.startswith(".")] ## remove the objects created by marvel, e.g. ".marvel-date"

This is related to this question

Upvotes: 3

Ahmed
Ahmed

Reputation: 3012

You can get _mapping to get list of all indexes by doing something like that.

requests.get(full_elastic_url + "/_mapping")

Upvotes: 2

MauricioRoman
MauricioRoman

Reputation: 822

I use curl to call the stats API and get information about the indices. Then I parse the JSON object that is returned to find the index names.

curl localhost:9200/_stats

In Python you can call curl using the requests library. I don't know of a way to do this using the Elasticsearch or Elasticsearch-DSL Python library.

Upvotes: 2

Related Questions