I have not used the adapter recently so cannot tell for sure. When you say that Calcite adapter is not working, what do you mean? Is there an exception or the query simply does not return anything?
Best, Stamatis On Sun, Apr 5, 2020 at 5:01 PM aashish choudhary < [email protected]> wrote: > Any inputs in the below thread? So I assume this feature is not supported > with calcite geode adapter.? > > With best regards, > Ashish > > On Fri, Apr 3, 2020, 1:11 PM aashish choudhary < > [email protected]> > wrote: > > > I am able to query simple regions like below. > > Region<String,Object> replicated region > > But not this type of region with calcite adapter. > > Region<String,List<Object>> partitioned region > > > > For example I can run following query on geode data browser pulse without > > any issue. > > Select e.value from /PartitionedRegion name.entrySet e where > > e.key=keyvalue > > But it doesn't work with calcite adapter. > > > > Also even simple query like select * from /PartitionedRegion name limit 1 > > not working with calcite adapter and getting below exception on Dbeaver > > Query execution failed > > Reason: > > java.lang.IndexOutofBoundsException > > > > Anyone tried it before or able to query data with calcite? > > > > > > select count(*) from /PartitionedRegionname gives a count of zero even > > though it has records but for replicated regions it gives the correct > count. > > > > With best regards, > > Ashish > > > > On Fri, Apr 3, 2020, 12:40 PM Stamatis Zampetakis <[email protected]> > > wrote: > > > >> Hi Ashish, > >> > >> It would help if you can post the error that you are getting when you > >> attempt to query regions with ArrayLists (if there is one). > >> > >> It seems that the case with ArrayList is not well tested (maybe not > tested > >> at all) [1] so it does not suprise me that it fails somewhere along the > >> road. > >> > >> Best, > >> Stamatis > >> > >> [1] > >> > >> > https://github.com/apache/calcite/blob/master/geode/src/test/java/org/apache/calcite/adapter/geode/rel/GeodeAllDataTypesTest.java > >> > >> On Fri, Apr 3, 2020 at 4:47 AM aashish choudhary < > >> [email protected]> wrote: > >> > >> > +Christian > >> > > >> > With best regards, > >> > Ashish > >> > > >> > On Thu, Apr 2, 2020, 5:00 PM Danny Chan <[email protected]> wrote: > >> > > >> > > I believe few people in the community are familiar with geode, maybe > >> you > >> > > can ask the author of this module [1] > >> > > > >> > > [1] https://github.com/tzolov > >> > > > >> > > Best, > >> > > Danny Chan > >> > > 在 2020年4月2日 +0800 PM6:41，aashish choudhary < > >> [email protected] > >> > > >，写道： > >> > > > Can anyone help me with this? > >> > > > > >> > > > With best regards, > >> > > > Ashish > >> > > > > >> > > > On Wed, Apr 1, 2020, 7:27 PM aashish choudhary < > >> > > [email protected]> > >> > > > wrote: > >> > > > > >> > > > > Hi, > >> > > > > > >> > > > > I am trying to setup querying geode using calcite geode adapter. > >> So > >> > > far i > >> > > > > am successfully able to connect to geode cluster which is SSL > >> enabled > >> > > after > >> > > > > making few changes in the adapter and query data for regions > which > >> > are > >> > > > > having flat hierarchy. > >> > > > > > >> > > > > However I am not able to run any query for region having Array > >> list > >> > as > >> > > > > values and String as key. I am using Dbeaver to query following > >> this > >> > > link. > >> > > > > https://youtu.be/I_iaMgqdV3Q > >> > > > > > >> > > > > Can someone help me with this? > >> > > > > > >> > > > > With geode you can query those complex region in geode Pulse > data > >> > > browser. > >> > > > > You can do .entrySet or .entries to run queries like this. > >> > > > > > >> > > > > Also in Dbeaver in under Tables->Columns I can view fields as > well > >> > for > >> > > > > regions having flat hierarchy but it doesn't show anything for > >> > regions > >> > > > > storing arrays. > >> > > > > > >> > > > > > >> > > > > With best regards, > >> > > > > Ashish > >> > > > > > >> > > > >> > > >> > > >
