You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Sreenath <sr...@gmail.com> on 2014/05/14 08:55:49 UTC

Insert into directory

Hi all,

Is there a way in hive by which i can redirect the output of a query to
some folder that already has some data.
I know 'INSERT OVERWRITE DIRECTORY' but this overwrites the existing
content

thanks

AW: Insert into directory

Posted by "Huynh, Chi-Hao" <hu...@initions.com>.

Hey Sreenath,

If you are using version 0.8 of Hive or higher you can omit overwrite and just write ‘INSERT DIRECTORY’.
This will simply append the results instead of overwriting. You can refer to the documentation for more details.

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingdataintoHiveTablesfromqueries


Von: Sreenath [mailto:sreenaths1923@gmail.com]
Gesendet: Mittwoch, 14. Mai 2014 08:56
An: user@hive.apache.org
Betreff: Insert into directory

Hi all,

Is there a way in hive by which i can redirect the output of a query to some folder that already has some data.
I know 'INSERT OVERWRITE DIRECTORY' but this overwrites the existing content

thanks