[
https://issues.apache.org/jira/browse/CALCITE-4044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashish Choudhary updated CALCITE-4044:
--------------------------------------
Description:
In current implementation of geode adapter sql is only supported for replicated
geode region. Even for replicated regions it supports querying regions having
simple keys and values like \{Region<String,Object>} or
\{Region<String,String>}
Additionally It would be good if we can have support for partitioned and
replicated regions having complex objects as value. For example if a geode
partitioned region is having key and value as like this
{Region<String,List<Object>>}
then we should be able to query it. It is not supported by calcite geode
adapter currently.
Below are the Geode OQL query example for partitioned regions with complex
objects And something like this should work with calcite also.
SELECT entry.value FROM /exampleRegion.entries entry WHERE entry.key ='1'
{{SELECT * FROM /exampleRegion.entries entry WHERE entry.value.ID > 1}}
was:
In current implementation of geode adapter sql is only supported for replicated
region. Even for replicated regions it supports querying regions having simple
keys and values like \{Region<String,Object>} or \{Region<String,String>}
Additionally It would be good if we can have support for partitioned and
replicated regions having complex objects as value. For example if a geode
partitioned region is having key and value as like this
{Region<String,List<Object>>}
then we should be able to query it. It is not supported by calcite geode
adapter currently.
Below are the Geode OQL query example for partitioned regions with complex
objects And something like this should work with calcite also.
SELECT entry.value FROM /exampleRegion.entries entry WHERE entry.key ='1'
{{SELECT * FROM /exampleRegion.entries entry WHERE entry.value.ID > 1}}
> Support querying of geode regions having complex objects
> --------------------------------------------------------
>
> Key: CALCITE-4044
> URL: https://issues.apache.org/jira/browse/CALCITE-4044
> Project: Calcite
> Issue Type: New Feature
> Components: geode-adapter
> Reporter: Ashish Choudhary
> Priority: Major
>
> In current implementation of geode adapter sql is only supported for
> replicated geode region. Even for replicated regions it supports querying
> regions having simple keys and values like \{Region<String,Object>} or
> \{Region<String,String>}
> Additionally It would be good if we can have support for partitioned and
> replicated regions having complex objects as value. For example if a geode
> partitioned region is having key and value as like this
> {Region<String,List<Object>>}
> then we should be able to query it. It is not supported by calcite geode
> adapter currently.
> Below are the Geode OQL query example for partitioned regions with complex
> objects And something like this should work with calcite also.
> SELECT entry.value FROM /exampleRegion.entries entry WHERE entry.key ='1'
> {{SELECT * FROM /exampleRegion.entries entry WHERE entry.value.ID > 1}}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
