delete()
This operation deletes entities from a partition with a boolean expression.
notes
Using the partition_name parameter in the delete() method of a Collection object is equivalent to using the delete() method of a Partition object.
Request Syntax
delete(
expr: str,
timeout: float | None
)
PARAMETERS:
expr (string) -
[REQUIRED]
A boolean expression to filter the entities to delete.
timeout (float | None)
The timeout duration for this operation. Setting this to None indicates that this operation timeouts when any response arrives or any error occurs.
RETURN TYPE:
MutationResult
RETURNS:
A MutationResult object that contains the following fields:
insert_count (int)
The count of inserted entities.
delete_count (int)
The count of deleted entities.
upsert_count (int)
The count of upserted entities.
succ_count (int)
The count of successful executions during this operation.
succ_index (list)
A list of index numbers starting from 0, each indicating a successful operation.
err_count (int)
The count of failed executions during this operation.
err_index (list)
A list of index numbers starting from 0, each indicating a failed operation.
primary_keys (list)
A list of primary keys for the inserted entities.
timestamp (int)
The timestamp at which this operation is completed.
EXCEPTIONS:
MilvusException
This arises when any error occurs during this operation.
Examples
from pymilvus import Collection, Partition, CollectionSchema, FieldSchema, DataType
schema = CollectionSchema([
FieldSchema("id", DataType.INT64, is_primary=True),
FieldSchema("vector", DataType.FLOAT_VECTOR, dim=5)
])
# Create a collection
collection = Collection(
name="test_collection",
schema=schema
)
partition = Partition(
collection=collection,
name="partition_a",
)
# Insert a list of columns
partition.insert(
data=[
[0,1,2,3,4], # id
[ # vector
[0.1,0.2,-0.3,-0.4,0.5],
[0.3,-0.1,-0.2,-0.6,0.7],
[-0.6,-0.3,0.2,0.8,0.7],
[0.6,0.2,-0.3,-0.8,0.5],
[0.3,0.1,-0.2,-0.6,-0.7],
],
]
)
# Delete two entities
res = partition.delete("id in [ 0, 1 ]")
Related operations
The following operations are related to delete():