Reply
Highlighted
Contributor
Posts: 46
Registered: ‎11-03-2014

INSERT OVERWRITE ... to the Same Table ?

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?