I think i have updated the error i am getting in previous email. "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." This is a very basic functionality not sure why it is not supported. With best regards, Ashish On Sun, Apr 5, 2020, 8:54 PM Stamatis Zampetakis <zabe...@gmail.com> wrote: > 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 < > aashish.choudha...@gmail.com> 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 < > > 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 > > >> > > > > > > >> > > > > >> > > > >> > > > > > >