Table

Delete rows from a table

Delete rows from a table based on a SQL predicate. Returns the number of rows that were deleted.

post/v1/table/{id}/delete

Path parameters

idstring required

string identifier of an object in a namespace, following the Lance Namespace spec. When the value is equal to the delimiter, it represents the root namespace. For example, v1/namespace/./list performs a ListNamespace on the root namespace.

Request body

namestring required

The table name

namespacestring[] required

The namespace identifier

predicatestring required

SQL predicate to filter rows for deletion

Example request

{
  "predicate": "predicate",
  "name": "name",
  "namespace": [
    "namespace",
    "namespace"
  ]
}

Response

Delete successful

versioninteger required

The commit version associated with the operation

Example response

{
  "version": 0
}