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