CODEWITHSUNDEEP
gemfilegeode
vaquar khan
vaquar khan

Reputation: 11479

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'

Upvotes: 1

Views: 1628

Answers (2)

vaquar khan
vaquar khan

Reputation: 11479

I have found , please find correct solution here 

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

Upvotes: 2

Juan Ramos
Juan Ramos

Reputation: 1421

I'm not entirely sure about what you mean by find inside Region, but my guess is that you're trying to find wether a particular entry exists within a given GemFire region.

If that's the case, then you can use the get method from the Region class. If you want to use GemFire SHell directly instead of a custom Java application, on the other hand, you can use the get command. Last, but not least, you could also execute a OQL query with the query command, as an example: query --query="SELECT e.value FROM /MyRegion.entries e WHERE e.key='myKey'"

Hope this helps. Cheers.

Upvotes: 1

Related Questions