How do i query on map data which contains in list?

list
index
query
map

#1

Hello, I have crores of data like this

I have map data in a list, how do I query on this? I have created list index,mapkeys index, mapvalues index and tried different queries on this data but not at all getting data.

Tried queries:

select * from test.demo in list where idInfo = "william-gozali-59450a16"

select * from test.demo in mapvalues where idInfo = "william-gozali-59450a16"

Thanks in advance


#2

This is not supported at this point. Only strings/integers/geo can be indexed within a list. So a list of map data wouldn’t work. You probably already consulted the relevant docs on this:

https://www.aerospike.com/docs/guide/cdt-list.html#list-index-queries

https://www.aerospike.com/docs/guide/cdt-map.html#map-index-queries


#3

Thank you @meher