Sure, log a JIRA case. Describe the use case as well as you can. Maybe give a SQL example.
Julian > On Jun 4, 2020, at 8:57 AM, aashish choudhary <[email protected]> > wrote: > > 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 >>>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >>
