Hi Rahul, I've replied a couple of days ago to your message.
Please create JIRA ticket for (1) and (2), ideally with test cases. For examples look into existing ES adapter tests [1]. Regards, Andrei. [1] https://github.com/apache/calcite/tree/master/elasticsearch/src/test/java/org/apache/calcite/adapter/elasticsearch On Fri, May 24, 2019 at 1:35 PM rahul challapalli < [email protected]> wrote: > 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 > > >
