08-14-2017 01:13 AM
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?