hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vihang Karajgaonkar <vih...@cloudera.com>
Subject Re: INSERT OVERWRITE TABLE with IF NOT EXISTS
Date Mon, 27 Mar 2017 18:45:54 GMT
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 <ekoifman@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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message