CDH 5.10.1, CentOS 7.3
I used a SQL similar to the following to simulate a delete in Impala. This did the work for me, removing rows with col1=100.
INSERT OVERWRITE mytable
select * from mytable
where col1 != 100;
However, I found that the official documentation about INSERT Statement says "Impala currently supports: Copy data from another table using SELECT query...".
So, was I using an unsupported feature and was purely lucky when it worked?