Remove Records from an Ocient System

{{ocient}} supports multiple options for removing records from a database here, you can find the different methods for removing data along with their advantages and drawbacks to help you determine the method that best fits your needs all options for removing data are destructive and cannot be undone after execution therefore, be cautious when removing any ocient records from your database required permissions to remove data, a user must have the delete privilege for the specified table for details on privileges, see the data control language (dcl) statement reference docid 7jq6fizrghsmuumsa4qiq remove records using delete the delete sql statement removes specific individual rows from a table based on the where filter clause unlike truncate , the delete statement does not restore the disk space of deleted rows without further system operations in general, delete is a good option when removing small row sets, not entire tables if a delete statement has no where filter, it removes all rows in the table the delete statement can support concurrent operations to remove rows on the same table, which might impact performance for details about the delete statement , see database, tables, views, and indexes docid\ ejutg6wjnk5eg55kizq8d remove data using delete with a filter in this example, the delete statement removes all rows from the products table with a value less than 1 in the rating column delete from products where rating < 1; remove data using joined tables you can use delete with a join statement to help filter rows for removal based on a condition that applies to the second table the statement removes rows only from the first table and not the second joined table this example deletes rows after performing a join operation on the geospatial values in two tables point table contains a column of geospatial point values us state table contains columns of all abbreviated u s state names and polygon values representing their boundaries the join operation uses the spatial relationships docid\ cai7h lh9vyvdihc8nrh function to evaluate if each point value in point table is contained within any of the polygon values in the us state table the example deletes any rows in point table that are within the boundaries of texas, abbreviated as 'tx' delete from point table p join us state table s on st intersects(s polygon wkt, p point wkt) where s state like 'tx'; data durability considerations to remove data, the data must be queryable in the system for example, streaming data systems might experience a delay before rows can be deleted while they are in progress of the loading process to become fully durable in most cases, data should be loaded and queryable within a matter of seconds related links key concepts docid\ clvgrq6xmzx3comgaluij ingest data with legacy lat reference docid\ luijhab6vyj6g1gn5bhth query ocient docid\ pj83zadmfz4dqseq5on7n