Hi Ashish, Unfortunately with a single line of the stacktrace we cannot understand much. We need the complete stacktrace to better see what happens.
Best, Stamatis On Mon, Apr 13, 2020 at 1:24 PM aashish choudhary < aashish.choudha...@gmail.com> wrote: > 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 > > > >> > > > > > > > >> > > > > > >> > > > > >> > > > > > > > > > >