Apache Geode
CHANGELOG
define index
Define an index that can be used when executing queries. Then, you can execute a single command to create multiple indexes all at once using create defined indexes.
Availability: Online or offline.
Syntax:
define index --name=value --expression=value --region=value [--type=value]
| Name | Description | Default Value |
|---|---|---|
| ‑‑name | Required. Name of the index to define. | |
| ‑‑expression | Required. Field of the region values that are referenced by the index. | |
| ‑‑region | Required. Name/Path of the region which corresponds to the “from” clause in a query. | |
| ‑‑type | Type of the index. Valid values are: range, key and hash. | range |
Table 1. Define Index Parameters
Example Commands:
gfsh> define index --name=myIndex1 --expression=exp1 --region=/exampleRegion
gfsh> define index --name=myIndex2 --expression=”c.exp2” --region="/exampleRegion e, e.collection1 c"
gfsh> define index --name=myIndex3 --expression=exp3 --region=/exampleRegion --type=hash
//then to create the indexes, execute:
gfsh> create defined indexes
Sample Output:
gfsh>define index --name=myIndex1 --expression=exp1 --region=/exampleRegion
Index successfully defined with following details
Name : myIndex1
Expression : exp1
RegionPath : /exampleRegion