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 >
