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