CALCITE-4044 With best regards, Ashish
On Thu, Jun 4, 2020, 10:53 PM Julian Hyde <[email protected]> wrote: > 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 > >>>>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>> > >>>>>>>>> > >>>>>>>> > >>>>>>> > >>>>>> > >>>>> > >>>> > >>> > >> > >
