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

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

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:

1 Like

Thank you @meher

© 2015 Copyright Aerospike, Inc. | All rights reserved. Creators of the Aerospike Database.