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 <aashish.choudha...@gmail.com> 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 <zabe...@gmail.com> > 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 < >> aashish.choudha...@gmail.com> wrote: >> >> > +Christian >> > >> > With best regards, >> > Ashish >> > >> > On Thu, Apr 2, 2020, 5:00 PM Danny Chan <yuzhao....@gmail.com> 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 < >> aashish.choudha...@gmail.com >> > > >，写道： >> > > > Can anyone help me with this? >> > > > >> > > > With best regards, >> > > > Ashish >> > > > >> > > > On Wed, Apr 1, 2020, 7:27 PM aashish choudhary < >> > > aashish.choudha...@gmail.com> >> > > > 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 >> > > > > >> > > >> > >> >
