How to do it...

1. Identify the table from which data needs to be deleted.
2. Delete full tables or only required rows:

DELETE FROM test01.web_clicks ALL; -- All rows deleted
DELETE FROM test01.web_clicks where site=01 and partition_date=date-1 -- Rows with Site=0 only deletes and use partition column to avoid full table scan.