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 > > > > >> > > > > > > > > >> > > > > > > >> > > > > > >> > > > > > > > > > > > > > > >
