Re: INSERT OVERWRITE TABLE with IF NOT EXISTS

2017-03-27 Thread Vihang Karajgaonkar
I am not a 100% sure but looks like it means that do not overwrite the table/partition if it exists which is kinda of weird since we already provide "OVERWRITE" in the query. On Mon, Mar 27, 2017 at 8:40 AM, Eugene Koifman wrote: > Hi, > According to https://cwiki.apache.org/confluence/display/H

INSERT OVERWRITE TABLE with IF NOT EXISTS

2017-03-27 Thread Eugene Koifman
Hi, According to https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Syntax.1 we support INSERT OVERWRITE TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...) [IF NOT EXISTS]] select_statement1 FROM from_statement; What might the intent of IF NOT EXI