geode-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dinesh Akhand <dines...@amdocs.com>
Subject RE: How to export region keys in json file
Date Thu, 17 Aug 2017 13:12:27 GMT
Hi I tried below,

gfsh>query --query='select e.key from /CUSTOMER_1.entrySet e'

Result     : true
startCount : 0
endCount   : 20
Rows       : 7

               name                | customerID | cycleCode | customerGroup | partitionID
---------------------------------- | ---------- | --------- | ------------- | -----------
amdocs.imdg.model.keys.CustomerKey | 1592       | 1         | 30006         | 300062


but when I ran

gfsh>remove --region=/AsyncEventQueue_PWInfoQueue_PARALLEL_GATEWAY_SENDER_QUEUE --key={\"customerID\":1592,\"customerGroup\":30006,\"cycleCode\":1,\"partitionID\":300062}
--key-class=amdocs.imdg.model.keys.CustomerKey
Result    : false
Message   : Key is not present in the region
Key Class : java.lang.String
Key       : {\"customerID\":1592,\"customerGroup\":30006,\"cycleCode\":1,\"partitionID\":300062}
--key-class=amdocs.imdg.model.keys.CustomerKey

Showing error key not exist.

We have customerID=LONG type
cycleCode = short
customerGroup = int
partitionID =int

Can you please suggest.

Thanks,
Dinesh Akhand


From: Barry Oglesby [mailto:boglesby@pivotal.io]
Sent: Thursday, August 17, 2017 4:18 AM
To: dev@geode.apache.org
Subject: Re: How to export region keys in json file

There isn't anything built in to export keys as JSON. There was some talk about exporting
values as JSON at one time, but that hasn't been done.

I attached a function to dump the keys as JSON. It just logs them to the terminal, but it
can easily be changed to write them to a file.

It dumps output like:

Region data contains the following 34 keys:
            {"customerID":"28","customerGroup":"group-28","cycleCode":"cycleCode-28","partitionID":28}
            {"customerID":"21","customerGroup":"group-21","cycleCode":"cycleCode-21","partitionID":21}
            {"customerID":"68","customerGroup":"group-68","cycleCode":"cycleCode-68","partitionID":68}
            {"customerID":"81","customerGroup":"group-81","cycleCode":"cycleCode-81","partitionID":81}
            {"customerID":"35","customerGroup":"group-35","cycleCode":"cycleCode-35","partitionID":35}
            {"customerID":"90","customerGroup":"group-90","cycleCode":"cycleCode-90","partitionID":90}
            {"customerID":"15","customerGroup":"group-15","cycleCode":"cycleCode-15","partitionID":15}
            {"customerID":"44","customerGroup":"group-44","cycleCode":"cycleCode-44","partitionID":44}


Thanks,
Barry Oglesby


On Wed, Aug 16, 2017 at 4:35 AM, Dinesh Akhand <dineshak@amdocs.com<mailto:dineshak@amdocs.com>>
wrote:
Hi,

How I can export Region keys in json file.

It will help full for us to use get command or remove command for particular key when we have
the composite keys defined.

get --region=/CUSTOMER_1 --key=({'customerID':'1593','customerGroup':'30013','cycleCode':'1','partitionID':'300133'})
--key-class=amdocs.imdg.model.keys.CustomerKey
Message : Error in converting JSON Couldn't convert JSON to Object of type class amdocs.imdg.model.keys.CustomerKey


Thanks,
Dinesh Akhand
This message and the information contained herein is proprietary and confidential and subject
to the Amdocs policy statement,

you may review at https://www.amdocs.com/about/email-disclaimer <https://www.amdocs.com/about/email-disclaimer>

This message and the information contained herein is proprietary and confidential and subject
to the Amdocs policy statement,

you may review at https://www.amdocs.com/about/email-disclaimer <https://www.amdocs.com/about/email-disclaimer>
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message