When a table is not in use right now, it can be closed temporally by Hippo. After closing this table, vector indexes created for this table will be released to reduce memory usage, and all data access operations performed again this table will not be allowed as well. Besides, all tables in trash are closed automatically to save memory.
However, uses can choose to re-open a closed table. Kindly note that re-opening a table has nothing to do with the vector indexes released previously due to close operation. If uses would like to use vector indexes, they need to re-load the indexes into memory.
The command of closing a table is listed below:
curl -u shiva:shiva -XGET 'localhost:8902/hippo/v1/{table}/_close?database_name={database_name}&pretty'
Result:
{
"acknowledged" : true
}
The command of opening a table is listed below:
curl -u shiva:shiva -XGET 'localhost:8902/hippo/v1/{table}/_open?database_name={database_name}&pretty'
Result:
{
"acknowledged" : true
}
Parameter description:
| Parameters | Description | Required |
|---|---|---|
| table | Table to be matched. Supports using asterisk (*) wildcard character and specifying multiple pattens, which are separated by comma (,) | Yes |
| database_name | The database where the table is located | No, defaults to "default" database |