[hive] delete table (insert overwrite table)

insert overwrite table your_table 
    select * from your_table 
    where id <> 1
;

https://stackoverflow.com/questions/17810537/how-to-delete-and-update-a-record-in-hive

How to delete and update a record in Hive