Can we accept a feature request for querying partitioned region with calcite geode adapter. I don't think it is fully supported. Let me know if you have any questions.
With best regards, Ashish On Tue, Apr 14, 2020, 1:40 AM Stamatis Zampetakis <[email protected]> wrote: > I still don't see the log that you are mentioning. > > Many kind of attachments are rejected when you are sending to the dev list. > It's better to provide hyperlinks or paste directly the relevant part to > the body of the email. > > On Mon, Apr 13, 2020 at 5:17 PM aashish choudhary < > [email protected]> wrote: > > > Full error is this in Dbeaver logs. Tried attaching the screenshot but > mail > > delivery got failed. > > > > Table 'GEODE.TABLENAME' not found in metadata catalog. > > > > Data type 'RecordType() MULTISET' can't be resolved by ' > > org.jkiss.dbeaver.ext.generic.model.GenericDataSource' > > > > With best regards, > > Ashish > > > > On Mon, Apr 13, 2020, 7:23 PM Stamatis Zampetakis <[email protected]> > > wrote: > > > > > 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 < > > > [email protected]> 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 <[email protected]> > > > > 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 < > > > > > [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 > > > > > > >> > > > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > >
