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 < aashish.choudha...@gmail.com> 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 < > aashish.choudha...@gmail.com> 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 < >> aashish.choudha...@gmail.com> 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 <aging...@pivotal.io> >>> 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 < >>>> aashish.choudha...@gmail.com> 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 >>>>> >>>>
