Note
This documentation is for a prior release of Kinetica. For the latest documentation, click here.
Deletes record(s) matching the provided criteria from the given table. The record selection criteria can either be one or more input parameter expressions (matching multiple records), a single record identified by record_id options, or all records when using delete_all_records. Note that the three selection criteria are mutually exclusive. This operation cannot be run on a view. The operation is synchronous meaning that a response will not be available until the request is completely processed and all the matching records are deleted.
Input Parameter Description
| Name | Type | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| table_name | string | Name of the table from which to delete records, in [schema_name.]table_name format, using standard name resolution rules. Must contain the name of an existing table; not applicable to views. | ||||||||
| expressions | array of strings | A list of the actual predicates, one for each select; format should follow the guidelines provided here. Specifying one or more input parameter expressions is mutually exclusive to specifying record_id in the input parameter options. | ||||||||
| options | map of string to strings | Optional parameters. The default value is an empty map ( {} ).
|
Output Parameter Description
| Name | Type | Description |
|---|---|---|
| count_deleted | long | Total number of records deleted across all expressions. |
| counts_deleted | array of longs | Total number of records deleted per expression. |
| info | map of string to strings | Additional information. |
