Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

INSERT OVERWRITE ... to the Same Table ?

INSERT OVERWRITE ... to the Same Table ?

Rising Star

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.

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?


Don't have an account?
Coming from Hortonworks? Activate your account here