{
“id”: “1234”,
“availableTo”: [
“price1”,
“policy”
]
}
when i run the below query , i get the error given below
SELECT price.id FROM price UNNEST price.availableTo AS availableto WHERE availableto=“price1”
Error: No index available on keyspace price that matches your query
I am creating the index as below
create index index_availableTo on price(availableTo)
Could someone please suggest how to write the index for the above scenario.