Table Of Contents

Previous topic

Inserting Data To Hustle

Next topic

hustle – Hustle Distributed OLAP Database

This Page

Deleting Data in Hustle

Deleting data in Hustle is partition-oriented, which means you can’t remove specific rows as conventional database systems dose. There are two functions to do this with different granularities.

Delete

delete() function only deletes data but keeps the table definition. If a Table object specified, all data in that table will be deleted. To delete a particular range of partitions, pass it an Expr, for example, “impressions.date < ‘2014-01-01’”.

See also

hustle.delete()
Hustle’s delete statement
Hustle Schema Design Guide
Details of the Hustle Partition

Drop

Use drop() function to delete the whole table, including data, all partitions, and table definition. Unlike delete(), it only takes a Table object to specify the table you want to drop.

See also

hustle.drop()
Hustle’s drop statement