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