Thanks Jason for your reply. I am following up with in calcite community also. Thanks once again for your help.
With best regards, Ashish On Mon, Apr 13, 2020, 10:38 PM Jason Huynh <[email protected]> wrote: > Hi Ashish, > > I am not sure if anyone is maintaining the calcite integration at the > moment. My guess is that the integration was limited in scope and probably > was only coded against replicated regions and probably only featured a > subset of OQL capability. I am not sure how difficult it would be to add > to. > I'm replying so you know people are seeing your question, but might not > have an answer for you at this time... > > If anyone knows or is interested in helping out, please reach out :-) > -Jason > > On Mon, Apr 13, 2020 at 9:33 AM 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' >> >> I get this error for partitioned regions only. >> >> With best regards, >> Ashish >> >> On Tue, Apr 7, 2020, 4:46 PM aashish choudhary < >> [email protected]> wrote: >> >>> So anyone able to query partitioned region with calcite geode adapter. >>> >>> >>> For 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 Thu, Apr 2, 2020, 11:56 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 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? >>>> >>>> With best regards, >>>> Ashish >>>> >>>> On Thu, Apr 2, 2020, 11:23 PM Anilkumar Gingade <[email protected]> >>>> wrote: >>>> >>>>> Ashish, >>>>> >>>>> Are you unable to query any region with simple key, value of String >>>>> type or are you unable to query the array type. >>>>> >>>>> Can you post your query here. >>>>> >>>>> Also, to validate your query, try executing through Geode's gfsh >>>>> command. If it is working with gfsh; then it could be an issue with the >>>>> calcite adapter. >>>>> >>>>> -Anil >>>>> >>>>> >>>>> >>>>> On Thu, Apr 2, 2020 at 6:52 AM 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. >>>>>> >>>>>> I have posted this in calcite community also but got no solution >>>>>> regarding this. >>>>>> >>>>>> Any suggestions? >>>>>> >>>>>> With best regards, >>>>>> Ashish >>>>>> >>>>>
