query
Run queries against Geode regions.
Run the specified OQL query as a single quoted string and displays results in pages allows to move between pages. If limit is not set in the query, then a default limit of 1000 (derived from GFSH environment variable APP_FETCH_SIZE) will be applied. Page size is derived from GFSH environment variable APP_COLLECTION_LIMIT (default value=20).
Note:
This command should not be executed from gfsh if the objects being queried contain cyclic references.
Availability: Online. You must be connected in gfsh to a JMX Manager member to use this command.
Syntax:
query --query=value [--step-name=value] [--interactive=value]
| Name | Description | Default Value |
|---|---|---|
| \-\-query | Required. The OQL string. | |
| \-\-interactive | Specifies whether or not this query is interactive. If false, then all results will be displayed at once. | true |
Table 1. Query Parameters
Example Commands:
query --query=value [--step-name=value] [--interactive=value]
Sample Output:
gfsh>query --query='SELECT * FROM /region2'
Result : true
startCount : 0
endCount : 20
Rows : 1
Result
('Hello World!!')
NEXT_STEP_NAME : END