Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-4044

Support querying of geode regions having complex objects

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • geode-adapter
    • None

    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
       

      Attachments

        Activity

          People

            Unassigned Unassigned
            achoudhary Ashish Choudhary
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: