Removing record with space character from gemfire using gfsh

Question

Dear All,

We have inserted the record which has trailing spaces('JP3758190007/106 ') that we couldn't remove by using gfsh. Please advise what query do we need use to achieve the same.

Query which we tried to delete with no luck:

remove --region=/INSTR_EAI_TEMP --key='JP3758190007/106 '

query --query="select tpaInstrumentId from /INSTR_EAI_TEMP where tpaInstrumentId='JP3758190007/106 '"

Thanks and Regards,

Selva Kumar M.

Answer

Hello SelvaKumar,

Thanks for contacting the Pivotal Support Community.

My name is Juan José Ramos Cassella, and I am a GemFire Technical Support Engineer with Pivotal.

That said, and adding to what Rajiv previously stated, the remove command seems to be trimming the actual value used for the --key parameter, so you won't be able to remove this particular entry within GemFire SHell. You can, however, write a really simple java client to delete the entry:

public static void main(String[] args) throws Exception {
  ClientCache cache = new ClientCacheFactory().
    set("log-level", "config").
    set("cache-xml-file", "client-cache.xml").
    create();
 
  try {
    Region region = cache.getRegion("INSTR_EAI_TEMP");
    region.remove("JP3758190007/106    ");
  } finally {
    if (cache != null) cache.close();
  }
 
  System.exit(0);
}

Hope this helps.

Best regards.

VMware GemFire

Removing record with space character from gemfire using gfsh