Any pointers on this? On Tue, May 21, 2019 at 1:18 PM rahul challapalli < [email protected]> wrote:
> Hi, > > My elasticsearch index contains arrays and nested fields. What is the > level of support available to deal with those data types. Can someone point > me to sql examples on top of those data types? > > 1. For arrays, lets say I have a tags field, I want to return all the > records/docs which contain 1 or more specific tags > 2. For nested datatypes, I tried query (a) and it worked. However query > (b) returned empty results. Is it a bug or am I missing something? > a) select _MAP['a.b'] from "e"."tbl_idx" limit 5; > false > false > false > false > false > b) select _MAP['a.b'] from "e"."tbl_idx" where _MAP['a.b'] = false > No Results > > Thank You, > Rahul >
