Search code examples
gemfilegeode

How to find key in Gemfire


How to find inside Gemfire region, what column defined as key during data load ?

List and describe is not giving required info

Example i am.looking something smiler to oracke "ALL_CONSTRAINTS" where you can run following sql to find primary key

        SELECT a.COLUMN_NAME
                FROM all_cons_columns a INNER JOIN 
               all_constraints c 
              ON a.constraint_name = c.constraint_name 
                    WHERE c.table_name = 'TBL'
                     AND c.constraint_type = 'P'

Solution

  • I have found , please find correct solution here

             query --query="select * from /region_name.keySet()"