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:


Thank you @meher