How I can query nodes specific index hosted on?

SQL++
, ,
1

Prerequisites:
Server version 6.5.1 CE

Problem statement:
Get nodes where index hosted on.

Case:
For instance i have following index:
CREATE INDEX promo-date-cache-by-day-productId ON promo-date-cache(day,productId) WHERE (productId = “1”) WITH { “nodes”:[ “172.18.0.2:8091” ] }

I try to use SELECT * from system:indexes
but it always returning "datastore_id": "http://127.0.0.1:8091"

Same time I see than I call REST API http://localhost:8091/indexStatus
it returns correct "hosts": ["172.18.0.2:8091"]

The question is what query or combination of queries REST API used for ?

2

@1111, the REST API http://localhost:8091/indexStatus gets the information directly from the index service. SELECT * from system:indexes doesn’t have this information currently.

The other option is to use Index UI to view the details:

3

Thanks for the answer.
Do I understand correctly that at the moment there is no way to get the nodes on which the index lives programmatically?
Except for REST API calls.

4

@1111, that’s correct.