springgemfire

Delete query in gemfire cache?

When I run SELECT query in gfsh console, it works as expected:

query --query="SELECT * FROM /channelProfiles_composite_asrd WHERE profile.channelCode='JJ'"

But similar DELETE query fails:

query --query="DELETE * FROM /channelProfiles_composite_asrd WHERE profile.channelCode='JJ'"
Result     : false
startCount : 0
endCount   : 20
Message    : Query is invalid due for error : <Syntax error in query:  unexpected token: FROM>

NEXT_STEP_NAME : END

Does gemfire support DELETE?

Solution

  • Geode / GemFire OQL unfortunately doesn't support DELETE. You would have to iterate over your result set and delete 'manually'.