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:sreenaths1...@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
