Re: Apache calcite geode adapter

2020-04-13 Thread aashish choudhary
Thanks Jason for your reply. I am following up with in calcite community also. Thanks once again for your help. With best regards, Ashish On Mon, Apr 13, 2020, 10:38 PM Jason Huynh wrote: > Hi Ashish, > > I am not sure if anyone is maintaining the calcite integration at the > moment. My guess

Re: Apache calcite geode adapter

2020-04-13 Thread Jason Huynh
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

Re: Apache calcite geode adapter

2020-04-13 Thread aashish choudhary
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

Re: Apache calcite geode adapter

2020-04-07 Thread aashish choudhary
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

Re: Apache calcite geode adapter

2020-04-02 Thread aashish choudhary
I am able to query simple regions like below. Region replicated region But not this type of region with calcite adapter. Region> 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

Re: Apache calcite geode adapter

2020-04-02 Thread Anilkumar Gingade
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

Apache calcite geode adapter

2020-04-02 Thread aashish choudhary
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