Support Questions
Find answers, ask questions, and share your expertise
Announcements
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.

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?

 

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