You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Eugene Koifman <ek...@hortonworks.com> on 2017/03/27 15:40:36 UTC

INSERT OVERWRITE TABLE with IF NOT EXISTS

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 EXISTS be here?

Thanks
Eugene

Re: INSERT OVERWRITE TABLE with IF NOT EXISTS

Posted by Vihang Karajgaonkar <vi...@cloudera.com>.
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 <ek...@hortonworks.com>
wrote:

> 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 EXISTS be here?
>
> Thanks
> Eugene
>