DROP FILE - Kinetica Docs

Deletes an existing KiFS file.

DROP FILE Syntax

DROP FILE[S] [IF EXIST[S]] <kifs file path(s)>

Parameters

KiFS file(s) to delete, as a comma-separated list of single-quoted file paths.

IF EXIST[S]

Optional error-suppression clause; if specified, no error will be returned if the given file(s) do not exist.

To delete a KiFS file:

DROP FILE Example

DROP FILE 'kdata/products.csv'

To delete several KiFS files, suppressing the error if any don’t exist:

DROP FILES Example

DROP FILES IF EXIST 'kdata/products.csv', 'kdata/employee.parquet'